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. 30-day free trial available!
Introduction to Statistics and Data Analysis with Microsoft Excel (find out more and register)
May 14th 2024
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.
Generative AI for Excel (find out more and register)
May 30th 2024
Using generative AI with Excel can help you save time and work more efficiently, regardless of your level of experience.
This live event explores the available options and demonstrates their different capabilities and how to use them. You’ll learn how Copilot Pro can analyze table data, create charts and PivotTables, insert formulas, and you’ll find out how this differs from the built-in Analyze Data tool. You’ll use ChatGPT to help you write cell formulas, create macros, define custom functions, and more. Finally, you’ll learn how generative AI add-ins can help you clean and categorize your data. By the end of the course, you’ll have the skills needed to use generative AI with Excel in multiple ways.
Excel Skills for Finance (find out more and register)
June 20th, 2024
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. Finally, 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. By the end of the course, you will have mastered key Excel skills needed for working with financial and other types of data.
Mastering Microsoft Excel Charts (find out more and register)
July 3rd, 2024
Microsoft Excel comes with a wide variety of built-in charts you can use to visually represent your data. They can help you see patterns and relationships, spot business trends that may otherwise go unnoticed, and communicate the meaning of your data at a glance.
This course teaches you how to make best use of Excel’s charting capabilities. You’ll learn how to create a basic chart, how to choose the best chart for your data, and how to modify all aspects of your chart design in order to best get your message across. You’ll discover how to deal with missing data, add trendlines and create combination charts. You’ll find out how to use sparklines—small charts that are displayed in a single cell—to quickly spot trends and variations in your data. Along the way, you’ll discover tips and tricks for working with charts more effectively.
Mastering Problem Analysis with Microsoft Excel (registration opening soon)
July 10th, 2024
Excel’s What-If Analysis tools―Data Tables, Scenarios, Goal Seek and Solver―are a mystery to many. But once mastered, they can help you make important business decisions and save you and your business time and money.
Expert Dawn Griffiths shows you how Excel’s built-in analysis tools can make problem-solving a breeze. You’ll learn how to use Data Tables and Scenarios to explore the potential impact of a range of situations; how to use Goal Seek to help you meet your targets; and how to use the powerful Solver tool to quickly solve complex problems such as how to maximize your profits and minimize your overheads.
Mastering Microsoft Excel PivotTables (registration opening soon)
July 17th, 2024
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, filter it using slicers and timelines, include calculated fields and items, and add automatic and manual grouping. Along the way, you’ll pick up data validation techniques to keep your data clean and tidy and discover how the Excel data model lets you use multiple tables in a single PivotTable.
Foundations of Microsoft Excel: Functions, Tables, PivotTables, and Power Query (registration opening soon)
July 24th, 2024
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. Finally, you'll find out how to use Power Query to split, extract and import data.
Mastering Power Query with Microsoft Excel (registration opening soon)
September 10th, 2024
Do you want to spend less time manipulating data in Microsoft Excel? Do you need to collect data from other workbooks or data sources? Or do you wish you could automate repetitive, manual tasks such as preparing monthly reports?
Join Excel expert Dawn Griffiths to learn how Excel’s Power Query tool can help save you hours of work by making data manipulation a breeze. You’ll find out how to perform common tasks ⎯ such as splitting columns and extracting codes⎯using Power Query’s intuitive editor. You’ll discover how to import data from elsewhere, including time-saving techniques for automatically collating data that’s been added to a single folder. You’ll discover how to add derived and custom columns, combine data sets, and work with multiple queries. By the end of the course, you’ll have all the skills you need to use Power Query in your day-to-day work, import and transform data with ease, and apply it to other products such as Power BI.