2024-25 Update: Excel

This course will enable you to

• Get to grips with the latest updates and improvements to Excel
• Use new data conversion options to import and handle data
• Take advantage of the latest advancements in Excel formulas
• Create better reports using the NEW PIVOTBY, GROUPBY, and PERCENTOF functions
• Use the new generative AI powers of Excel’s Copilot

About the course

For many people who work with Excel, it’s the tech gift that keeps on giving, and the latest set of updates is no exception. In fact, they go a long way towards proving that Excel is still a giant in the world of data analysis. The key is having the know-how to get the full potential out of this powerful tool.

This course has some tips and guidance for beginners, but also covers some of the advanced new capabilities of Excel that can be used to improve efficiency and control of data, details of formula enhancements, an introduction to the GROUPBY, PIVOTBY, and PERCENTOF functions. Additionally, it introduces some uses for the generative AI powers of Excel’s Copilot that you might not have known were possible.