In Microsoft Excel Level 3, participants will build confidence and mastery in their skills. Filled with practical instruction and ample practice, participants will learn to consolidate, validate, and forecast data. They will learn to use data validation tools to maintain data integrity. Participants will learn how to use Look Up and Reference functions with large data sets and how to combine formulas and functions to add automation to workbooks. Participants will leave the course with the ability to use the software to drive greater efficiency, reduce errors and make confident decisions using data-driven insights.   

Key Learning Outcomes

• Review formatting, fomulars, functions, pivot tables, and charts
• Text, date, and time functions including nesting formulas and functions
• Formila audits including referencing other sheets and workbooks
• Defined names and ranges
• References and look up functions
• Data validation
• What-if analysis tools
• Macros
• Protecting data, sheets, and workbooks
• Shortcuts

This course requires intermediate knowledge and experience with MS Excel. Participants must have a working understanding of the following:

• How to open, save, and print workbooks
• Formatting cell contents as numbers, text, currency, time and so forth
• MS Excel Operators
• Knowledge of formulas and functions
• Absolute and relative cell references
• Data Tables

Course Duration: 1 day | Continuing Education Contact Hours: 7 

This course is part of the Mastering Microsoft Excel Program

If you are unsure of your level of knowledge and experience with Excel as it pertains to this course, please 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, Microsoft Excel 365, or a compatible version installed on their computer. 

To further boost your productivity, we suggest using a second monitor, which allows you to easily follow along and practice simultaneously.

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.

Past Participants Said

"I'm a hands on individual and the practical side was awesome getting to practice what was just reviewed."

- Fall 2022 Participant

"Top three strengths of this course are: - the exercise booklet - the Instructor - the participant manual"

- Winter 2023 Participant 

"The back and forth between the presentation & the live examples then immediately followed up practicing ourselves really kept the course interesting, not drained out. Great interactive experience for learning."

- Winter 2023 Participant 

___________________________________________________________________________________________

This course qualifies for Professional Development Units (PDUs) as defined by the Project Management Institute (PMI).

Each course has a specific qualifying factor for PDUs. See the table below for a specific PDU breakdown for this Gardiner Center program.

To learn more about PDUs and how to apply these credits to your active credential please see www.pmi.org.

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.