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.

This course is part of the Mastering Microsoft Excel Program.

Key Learning Outcomes

• 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

This course requires intermediate knowledge and experience with MS Excel. Participants should understand spreadsheet programs including the layout and composition of workbooks. Experience manipulating spreadsheets, formatting cells, using cell references, calculations, and using the function library to insert functions.

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 compatible version) installed on their laptop.

Continuing Education Contact Hours: 7

Accreditations

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)

Kelly Patey

Kelly Patey has been developing and delivering professional development training for over 15 years. She is an experienced facilitator in both the private and public sectors who specializes in leadership development, employee engagement and workplace wellness.

Kelly holds a Bachelor of Arts degree in Psychology, a Master of Education in Counselling Psychology, and a Diploma in Applied Information Technology. She also holds numerous certifications including EQi 2.0, DISC, and Appreciation at Work.