Microsoft Excel 365 Intermediate | Live, ONLINE

This course is intended for anyone who has a foundational understanding of Microsoft Excel, and wants to dive deeper into some of its more advanced features and functions.

In this course students will learn to:
• Customize the Ribbon and Quick Access Toolbar
• Define and use Names and Named Ranges
• Create links to other sheets and external workbooks
• Use Conditional Formatting
• Create and manage Tables and Charts
• Create and work with Pivot Tables to quickly analyze and visualize information
• Create and work with logical functions including IF(S), SUMIF(S), AVERAGEIF(S) and COUNTIF(S)
• Create and work with Lookup functions such as VLOOKUP and XLOOKUP

• 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.
• This course is delivered in partnership with local construction associations across Canada. You will be participating with a cohort of industry peers from multiple regions.

A basic knowledge of and experience with Excel and Windows, including being able to start programs, switch between programs, locate saved files, and close programs. Basic Excel skills are also required.

Access to the Microsoft Excel desktop app is required for this course. It is also
recommended to have two monitors/screens, so students can follow along and test out their new skills as we go