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.
-
Intermediate Excel Formulas for Accountants
ake your Excel skills to the next level with this course on intermediate level formulas. Learn about a variety of rounding and text functions, as well as how to make the most out of date and time formulas and increase your workbooks resistance to errors.
£100 +VAT -
Advanced Excel Formulas for Accountants
This course explores advanced Excel accounting functions and how you can apply them in your finance work. Learn how to calculate future value, carry out one and two variable analysis, use reference functions, create dynamic ranges and more, in this course.
£100 +VAT -
General Excel Formulas for Accountants
Designed specifically for accountants, this course enables you to create basic and complex IF statements and use various LOOKUP functions. It also explains how to use conditional functions, relative and absolute cell references to write formulas efficiently.
£100 +VAT -
Creating Dashboards in Excel
Dashboards are useful for presenting complex information in a more user-friendly way. This course will guide you through the fundamentals of creating dashboards in Excel, enabling you to produce professional charts and interactive visualisations that will inform users.
£100 +VAT -
Financial Modelling: Business Simulation
Updated for 2024. Did you know Excel can be used to model potential business situations? In this course, you can learn the basics of business simulation in Excel, along with how to create financial models to aid decision making.
£100 +VAT -
Charts and Visualisations in Excel
Excel provides a host of charts and visualisations to tell stories data. Explore the basics of creating charts in Excel and what makes a good chart. And discover how to use a range of less common Excel charts for maximising the effectiveness of your data visualisations.
£100 +VAT -
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.
£400 +VAT -
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.
£100 +VAT