Upcoming live training
Whether you're new to Excel or an Excel power user, there's a course available to take your skills to the next level. All courses are available on the O'Reilly learning platform. Free trial available!
Generative AI for Excel Automation (find out more and register)
May 28, 2026
Excel automation goes far beyond formulas. In this hands-on course, you’ll learn how to automate data and worksheet tasks in Excel using Power Query, macros, and Office Scripts—supercharged by generative AI.
Dawn Griffiths focuses the course on real-world automation scenarios, including importing and transforming data, combining datasets, automating repetitive workbook actions, and extracting meaning from text. You’ll discover how to use generative AI as an assistant and learning partner, helping you understand features, generate queries and scripts, explain existing automation, and troubleshoot issues more efficiently.
Mastering Microsoft Excel PivotTables including Power Pivot (find out more and register)
June 10, 2026
PivotTables are one of Excel’s most powerful components, allowing you to quickly create interactive summaries of your data. Go beyond the basics with expert Dawn Griffiths to gain full mastery of this important technique. You’ll learn how to create a PivotTable with secondary rows, add calculations such as sums, counts, and averages, and display the results as percentages. You’ll discover ways of filtering PivotTables using slicers and timelines, implement automatic and manual grouping, and use calculated items and fields to include custom calculations. Finally, you’ll discover how the Excel data model lets you use multiple related tables in a single PivotTable and learn how to use Power Pivot to create more advanced PivotTables.
Generative AI for Excel (find out more and register)
June 17, 2026
Using generative AI with Excel can help you save time and work more efficiently, regardless of your level of experience.
Join expert Dawn Griffiths to explore the available options and their different capabilities. You’ll learn how to use Copilot’s Agent mode to interact with workbooks, including updating tables, create charts and PivotTables, and inserting formulas; and you’ll find out how this differs from the built-in Analyze Data tool. You'll use ChatGPT (or similar browser-based tools) to learn about Excel features, create cell formulas, clean and categorize data, perform data analysis, and more. Finally, you’ll learn how add-ins can let you write generative AI prompts directly in Excel cell formulas. By the end of the course, you’ll have the skills needed to use generative AI with Excel in multiple ways.
Foundations of Microsoft Excel: Functions, Tables, PivotTables, and Power Query (registration opening soon)
Date to be announced
Do you use Excel for simple lists but get lost when you need to do something more complex? Are you tired of wasting time trying to manually make sense of your data?
Do more with the data you have. Join expert Dawn Griffiths to learn how to make calculations and summarize your data like a real Excel power user. You’ll learn how to use Excel’s powerful built-in functions to quickly get the results that you want and discover how to use tables to organize, sort, filter, and summarize your data. You’ll uncover the mysteries of PivotTables and see how they give you a flexible way to summarize your data in multiple ways. You'll find out how to use Power Query to split, extract and import data. Along the way, you’ll discover tips, tools, and features to help you get more out of Excel and become more productive.
Introduction to Statistics and Data Analysis with Microsoft Excel (registration opening soon)
Date to be announced
Have you ever wished you knew more about statistics and how to interpret and use them in your everyday or professional life? Do you want to learn how Excel’s statistical tools and functions can help you, and how to use them? If so, this hands-on practical course is for you!
Join expert Dawn Griffiths to learn how to apply key statistical concepts such as variance, probability distributions, confidence intervals, and hypothesis tests using Microsoft Excel. You’ll learn how to generate statistics using Excel's built-in statistical functions and the Analysis ToolPak, and the insights they provide into your data. You’ll discover the pitfalls of biased samples and how to avoid them. You’ll use probability and probability distributions to make predictions, create confidence intervals, and put your theories to the test with hypothesis testing. Along the way, you’ll use tables, Pivot Tables, and charts, to summarize, visualize and help you interpret your results.
Excel Skills for Finance (registration opening soon)
Date to be announced
In this live event, you’ll learn core Excel skills needed to work with financial data more effectively. You’ll use financial functions such as PMT, FV, NPV, and IRR to determine the future value of an investment, calculate loan payments, and determine project viability. You’ll learn how to use the VLOOKUP, XLOOKUP, INDEX, and MATCH functions to look up values. You’ll discover how to use custom number formats and apply conditional formatting to highlight information and make patterns more apparent. You’ll discover techniques for working with linear, exponential, and seasonal data, including analyzing trends with moving averages and using the Forecast Sheet to make seasonal forecasts. You’ll create custom data validation rules and learn techniques for working with stock and currency data. Finally, you’ll discover how to create custom functions, making it easier to calculate financial quarters and years. By the end of the course, you’ll have acquired key Excel skills for working with financial and other types of data.