Mastering the Fundamentals of Excel – Intermediate
US$220.00 – US$275.00
Thank you for your expressed interest in selected Program. There are no assigned dates at this time however we do encourage customised sessions where we will be happy to discuss more detail with you. Kindly contact our Programs Team at firstname.lastname@example.org and thank you for choosing the Massy Learning Institute.
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.