Course Description

Description:
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.
Prerequisites:
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.
Note: 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.
Course Length: ½ day (4 hours)

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

Cancellation Policy

SCA will provide a full refund or education credit equal to the amount paid for the course if registration is cancelled three (3) full business days prior to the course start date. Payment is non-refundable for cancellations made within three (3) 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.

For more information or to register please email Kim: kim@constructionsk.ca