Showing 1–10 of 20 resultsSorted by latest
-
Course
Data Analysis With Excel
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.
-
Course
AI Tools in Excel
Learn how to use ChatGPT and Copilot to speed up and simplify your Excel work, from cleaning data and writing formulas to generating insights.
-
Course
Financial Modelling: Building a Model
Financial modelling is an invaluable skill for accountants but in the wrong hands, models can be confusing and misleading. This course will teach you to build robust financial models in Excel to forecast future performance, and to measure and respond to uncertainty and change.
-
Course
Financial Modelling: Getting Started
Financial modelling is one of the most highly valued skills of the finance professional. This course will help you to get started mastering that skill, by choosing the right approach, following the right processes and adhering to the relevant standards and guidelines. -
Course
Building a Spreadsheet Forecasting Model
This course explains how to build and operate spreadsheets for forecasting, planning and business models. It’s a practical guide, which takes a step-by-step approach to building, utilising and maintaining models.
-
Course
Excel for Accountants: Getting Started
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. -
Course
Data Analysis for Accountants: Statistics
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.
-
Course
Data Analysis for Accountants: Power BI
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.
-
Course
Power Query and Get & Transform: Intermediate
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. -
Course
Excel Skills Booster for Accountants
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.