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 Schedule

Program Content

Microsoft Excel Level 1: Formatting, Filters and Functions - January 17, 2025
Learn how to use the function tool, and 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 - February 7, 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 - February 28, 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® Master Instructor, an expert facilitator with extensive experience designing content in the Microsoft Office suite of products.  With over 25 years of experience in change and project management she uses her knowledge of working in various sectors, including manufacturing, banking, insurance, health care, transportation, packaged foods, retail and non-profit. Her ability to bring teams together and deliver crisp communication across diverse workgroups gains quick results. With a background in information technology and a strong analytical capacity, Betsy also helps teams quickly solve problems and endorses various tools to make teams more effective. She offers coaching to leaders who are responsible for complex change initiatives.