Microsoft Excel Intermediate

This course is designed for participants who already have a basic understanding of Microsoft Excel and want to take their skills to the next level. Building on foundational knowledge, you’ll learn to work more efficiently, analyze data with greater depth, and take advantage of Excel’s advanced features to create professional, dynamic spreadsheets.

Topics:

• Customization: Ribbon and Quick Access Toolbar

• Names & Linking: Named Ranges, links to other sheets and external workbooks

• Formatting & Visualization: Conditional Formatting, creating and managing Tables and Charts

• Data Analysis: Building and analyzing data with PivotTables

• Functions: Logical functions (IF(S), SUMIF(S), AVERAGEIF(S), COUNTIF(S))

• Lookup Tools: VLOOKUP and XLOOKUP

Note: Access to the Microsoft Excel desktop app is required. For the best experience, we recommend using two monitors or screens so you can follow along while practicing your new skills.

This course is ideal for individuals who are comfortable with the basics of Excel and want to expand their skills. It’s suited for anyone who needs to work more efficiently with data, create reports, and apply intermediate-level Excel functions in their role.

Participants should be comfortable with basic Excel skills, including creating and saving workbooks, navigating worksheets, formatting cells, and using simple formulas. A general working knowledge of Windows is also required.

Izzy Perry

Microsoft Office Specialist Expert and Microsoft Certified Trainer

Live, Online, Instructor-led training. 

This workshop is hosted by the instructor on the GoToTraining platform. Access information and any course materials will be provided to you by the instructor via email in advance of the training.

WCA Cancellation Policy

WCA will provide a full refund or education credit equal to the amount paid for the course if registration is cancelled two (2) full business days prior to the course start date. Payment is non-refundable for cancellations made within two (2) full business days of the course start date and there will be no transfers to future course dates.

Complimentary substitution of another member of your company/team is welcome right up until the course start time for no additional fee. Please email us at wcaeducation@winnipegconstruction.ca if you require a substitution.