Microsoft Excel is used by an estimated 750 million users worldwide. A more staggering statistic tells us that approximately 81% of workplaces use Excel to help their business run smoothly and make informed decisions. Excel is a flexible and dynamic program that allows users to present information and analyze data efficiently and professionally. The Mastering Microsoft Excel Program elevates the user's skills from beginner to advanced. Working through three levels of Excel, participants will learn to expertly navigate the software; execute functions to support their organization; and build confidence in analyzing, manipulating, and presenting accurate data and information. 

Key Learning Outcomes

• Be comfortable navigating the Excel user interface, entering, manipulating, and formatting data.
• Use formulas and functions to perform calculations on data.
• Analyze data and present the results in a user-friendly way.
• Create charts and tables that effectively summarize raw data.
• Automate choices and data lookups using functions.
• Create easy-to-use spreadsheets.
• Validate data, find and correct errors.

Program Content

Microsoft Excel Level 1: Formatting, Filters and Functions - September 22, 2025
Learn how to use the function tool, create tables and dynamic charts with impact.

• Introduction to spreadsheets
• Navigating Excel
• Formatting font, cells, and data
• Conditional formatting
• Sorting and filtering data
• Basic formula syntax and mathematical operators in excel
• Cell references in formulas
• Using the function dialogue box (i.e. SUM, AVERAGE)
• Printing and saving workbooks

Microsoft Excel Level 2: Executing Data Analysis and Visual Presentation - May 29, 2025
Learn how to use mathematical operators and syntax, statistical functions, and pivot tables to present data in a clear and professional manner.

• Conditional formatting
• Inserting graphics
• Inserting links, comments, text, and symbols
• Creating tables
• Naming tables
• Formatting tables
• Calculations in tables
• Defined Names
• Charts with impact
• Pivot tables
• Pivot table tools
• Pivot charts
• Reviewing tools

Microsoft Excel Level 3: Business Analytics and Data Management - June 6, 2025
Learn how to use look-up and reference functions as well as skills to consolidate, validate, and forecast data.

• Get and transform data
• Data types
• Data validation tools
• Forecasting tools
• Formula syntax
• MS Excel Operators
• Function syntax
• Editing using the formula bar
• Enabling function complete
• Nesting formulas and functions
• Look up functions
• A variety of 2+ argument functions from the function library
• Using multiple worksheets and workbooks
• Protecting data, sheets, and books

Courses can also be completed individually. Feel free to use the Microsoft Excel Placement Self-Assessment to determine which level you should begin with.

NOTE: This is an interactive session. Participants must have Microsoft Excel 2016 or Microsoft Excel 365 (or a compatible version) installed on their laptops.

Course Endorsements & Partnerships

This course qualifies as credits toward the International Association of Business Communicators (IABC) professional certifications.

When applying to sit for either the exam for Communications Management Professional (CMP)(R) or Strategic Communication Management Professional (SCMP)(R) or to apply for recertification, Gardiner Centre courses can be an integral part of your application package.

To learn more about this global standard certification, visit: gcccouncil.org. To inquire about sitting for a certification exam, contact the local IABC NL chapter at iabcnl@gmail.com, or visit iabcnl.com.

Continuing Education Contact Hours: 21

Instructor(s)

Betsy Bond

Betsy is a Prosci® Executive Instructor and expert facilitator with extensive experience designing content across the Microsoft Office suite. With over 25 years of experience in change and project management, she draws on a broad background across sectors including manufacturing, financial services, health care, non-profit, and more.

Starting her career in information technology, Betsy seamlessly transitioned her technical skills into the field of change management. She is passionate about helping teams solve problems quickly, build new skills, and find practical ways to boost personal and team productivity.