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.

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.

This course has been designed to take the novice Power Pivot user to a level where they are comfortable working with Power Pivot models and using Pivot tables and charts. You'll also be able to carry out calculations and time intelligence functions by learning the basics of DAX.

If you are a novice Get & Transform Data user, this course will help you to navigate your way comfortably around the user interface. Learn the basics of using Power Query to connect, combine and transform your data, so that it meets your analysis needs.