Excel

Level up your Excel skills with the latest updates, from AI-powered Copilot to new regex and calculation functions, plus improved accessibility features.

Learn how to use ChatGPT and Copilot to speed up and simplify your Excel work, from cleaning data and writing formulas to generating insights.

As a finance professional you use Excel to analyse data, but how often do you overlook Excel's useful features? This course explores some basic and more advanced features of Excel's PivotTable tool, covering Power Pivot and DAX (Data Analysis Expressions) formulas.

Not everyone can spot trends and concerns in data the way accountants can. To deliver a key message you often need to reframe data as a story, to engage people's emotions and steer them towards a desired outcome. This course will help you to build a story using creative techniques and keep your audience engaged.

It's easy to find yourself using Excel the same way for years at a time. This course concentrates on a range of practical and simple techniques that can make spreadsheets quicker to set up, easier for the user to use, more automated, and guard against career-threatening errors.

Excel is a powerful calculation tool, record keeper and a tool for reporting and analysing. This course takes you through the features and functions available. Enhance your knowledge of navigating an Excel workbook, formatting data, and more.

This course explores the various ways you can use statistics and probability to enhance your role as an accounting and finance professional. Gain an understanding of basic probability functions and testing your hypotheses using Excel.

Take your knowledge and application of Power Query and Get & Transform Data to the next level. This course looks at adding custom, index and conditional columns, covers the basics of JSON and M (Mashup), and explores the uses of parameters and custom functions.

This course introduces you to Power BI, Microsoft's powerful data analysis tool, and how it can benefit you in your finance role. Transform the way you handle and analyse data, creating a range of interactive data visualisations.

This course examines what Excel can offer accountants. Become confident in using fundamental and advanced Excel functions and features including conditional calculations and IF statements, lookups, tables, PivotTables and dynamic arrays.