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: 
Tuesday, June 9
12:00 PM - 4:00 PM NDT
Cost: $249.00 +hst NLCA Members / $349.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. 

Course Outline:

Part 1: Cleaning and Formatting Data Data Cleanup 

• Text To Columns 
• Flash Fill 
• Removing Duplicates 
• Conditional Formatting 
• Tables  

Part 2: Summarizing and Analyzing Data 

• PivotTables 
• Slicers  
• Charts  
• PivotCharts 

Part 3: Smart Functions for Work Tracking 

• The IF Function 
• IFS 
• SUMIF and SUMIFS 
• SUMIF  
• SUMIFS 
• IFERROR 
• TODAY 

Part 4: Lookups & Automation 

• Dropdown Lists 
• 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).

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 highly recommended to have two screens/monitors. 

Course Length: ½ day (4 hours)