Excel Power Tools for Analytics

Stay afloat with Excel's 'Power tools' and AI capabilities, as Microsoft MVP George Mount hosts this special in-depth 1-day Masterclass.

Excel continues to evolve in its capabilities for analytics and automation, offering an ever-expanding set of tools. This Masterclass explores some of the latest and greatest 'Power tools' for working with Excel.

First, we will delve into maximising the potential of AI tools for Excel, utilising resources available both inside and outside of Excel.

Next, we will take a deep dive into the integration of Python with Excel, exploring analyses and visualisations that would be challenging or impossible to achieve using Excel alone.

Finally, we will investigate Office Scripts, Power Automate, and other cloud-based tools to elevate your analytics and automation skills to new heights.

‍

What you'll learn?

• Explore current AI features in Excel for pattern recognition, forecasting, and natural language querying, among other capabilities.
• Learn how to generate sample data, troubleshoot formulas, and create reproducible examples using generative AI for Excel.
• Utilise Python within Excel to conduct time series analyses, create statistical plots, and more.
• Automate the creation of reports using Office Scripts. Develop shareable, multistep workflows for Excel with Power Automate.

‍

This class will be delivered in-person at LABS House 15, 19 Bloomsbury Way, London WC1A 2TH (Room: Palladium + Krypton (1st Floor))

‍

This training is available as a single Masterclass or as part of our Premium In-Person Global Excel Summit ticket.