Excel courses
Excel is a crucial tool for every accountant. Our Excel CPD offers in-depth insight into its powerful features, catering to all skill levels - from beginners to experts. Enhance your proficiency and become a more sophisticated and effective accounting professional.
Excel Productivity Booster
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.
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.
2024-25 Update: Excel
This course covers recent updates and improvements to Excel, including the latest tools to help you handle data, details of formula enhancements, an introduction to the GROUPBY, PIVOTBY, and PERCENTOF functions, as well as some uses for the generative AI powers of Excel's Copilot.
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.
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.
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.
Career Progression Pathway: Finance Data Analysis
Explore how data analysis can empower you to deliver valuable insights to your business and clients. This pathway provides the tools, technologies, and methodologies you need to ensure you play a pivotal role in decision making.
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.
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.
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.