Microsoft Excel 365 Intermediate (October 16, 2025)

Description

Course Specifications 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

Instructor - Izzy Perry

Izzy is an administrative professional with over twenty years of experience working with Microsoft Office. Her experience in various paralegal, corporate and government offices has given her differing perspectives to engage and develop both her knowledge and her students' knowledge. She is passionate about computers and software and brings that passion to her work and her classes.

Izzy served as President of the Canadian Sport Parachuting Association and was on their Board of Directors for five years. She is a Learning Facilitator and Coach Evaluator certified through the Coaching Association of Canada and the National Coaching Certification Program, and has been teaching people to skydive for over ten years.

Izzy was the recipient of the 2020 Canadian Sport Parachuting Association Cathy Johnson Service Award, in recognition of the outstanding support, contribution and dedication to sport parachuting in Canada.