Excel courses
Excel remains one of the most powerful tools in an accountant’s toolkit. From mastering formulas and data analysis to building dashboards, financial models, and forecasts, CPD in Excel helps you work faster, smarter, and more accurately. These courses are designed specifically for accountants, giving you the practical skills to automate processes, analyse financial data, and present insights with clarity and confidence.
-
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
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.
£100 +VAT -
Power Query and Get & Transform: Getting Started
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.
£100 +VAT -
Power Pivot: Getting Started
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.
£100 +VAT