Description

This course is intended for anyone who wants to gain a foundational understanding of Microsoft Excel. Participants will learn how to use the basic features and functions of Excel to create and edit basic spreadsheets.  

Course Details:
Wednesday, May 6
12:00 - 4:00 PM NST
Cost: $249.00 +hst NLCA Members / $349.00 +hst Non-Members

New Course Outline:

Part 1: Getting Comfortable in Excel User Interface Basics 

• The Ribbon 
• Quick Access Toolbar 
• Navigating with the Name Box 
• The Statu s Bar 
• Getting Help: the Search Bar 
• The Formula Bar 
• Understanding Worksheets 

Part 2: Entering and Formatting Data Entering Data 

• Formatting Text 
• AutoFill 
• Number Formatting 
• Clear Formatting

Part 3: Organizing Information 

• The Anatomy of a Tidy Dataset 
• Sorting and Filtering data 
• Sorting data 
• Filtering data 
• Workbook Views 
• Freeze Panes 

Part 4: Basic Formulas and Functions Creating Formulas 

• Mathematical Operators and the Order of Operations 
• Understanding Cell References 
• Using AutoFill for formulas 
• Function Basics 
• AutoSum Functions 

Prerequisites: A basic knowledge of and experience with Windows, including being able to start programs, switch between programs, locate saved files, and close programs.  

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

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.0 hours)

Canadian Construction Association Gold Seal Certification Program: This course is a CCA Gold Seal Certified Course (1 Credit).