Microsoft Excel Intermediate

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. 

Course Details: 
Thursday, May 15
12:00 PM - 4:00 PM NDT
Cost: $220.00 +hst NLCA Members / $320.00 +hst Non-Members 

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. 

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 

Instructor: Izzy Perry, Microsoft Office Specialist Expert and Microsoft Certified Trainer. 

Method of Delivery: This course is delivered as an interactive Virtual Instructor Led Training (VILT) course using the PESL GoToTraining platform. 

Duration: 1/2 Day (4 hours) Canadian Construction Association Gold Seal Certification Program: This course is a CCA Gold Seal Certified Course (1 Credit).