Building on the foundational knowledge of Excel, this intermediate workshop will provide participants with the tools to create dynamic spreadsheets using essential advanced formulas. Participants will learn how to manipulate and analyze large data in pivot tables, charts and more! Discover tips and shortcuts to change the way you use Excel, saving you valuable time and improving your efficiency!

Participants will learn to:

• Learn how to create 3D spreadsheets including linking and grouping of data across sheets.
• Understand the use and purpose of Functions (including IF statements, date functions and text functions).
• Discover how to use conditional formatting and data validation to edit and format data.
• Learn how to work with large data and navigate worksheets efficiently using various tips and shortcuts.