What level of Excel do I need to start this course?

This course is designed for intermediate to advanced Excel users — comfortable with basic formulas, formatting, and pivot tables. Complete beginners should start with an introductory Excel course first.

Does this course cover Power BI as well as Excel?

This course focuses on Excel, including Power Query and Power Pivot which overlap with Power BI functionality. A separate CPD module covering Power BI for financial reporting and dashboarding is available as a companion course.

How many CPD hours does the Excel course deliver?

This course delivers approximately 6-8 hours of structured CPD across all modules. Individual modules can be completed as standalone development sessions.

Is the Python module suitable for non-programmers?

Yes. The Python for Finance module is designed specifically for accountants with no programming background. It focuses on practical applications — automating Excel tasks, processing large datasets — rather than programming theory.

Will this course help me work more efficiently?

Yes. Finance professionals who complete the Power Query and Power Pivot modules typically report saving multiple hours per week on data preparation and reporting tasks.

CPDCPD Excel

CPD Excel for Accountants | Advanced Excel Skills | Learnsignal

In short

Learnsignal's CPD Excel for Accountants course develops advanced Excel skills for finance professionals — Power Query, Power Pivot, dynamic arrays, financial modelling, and Python basics.

5 min read

Why Excel CPD Matters for Accountants

Despite the rise of cloud accounting software, Excel remains the primary tool for financial analysis, modelling, and reporting in most finance teams. But there is a significant gap between how most accountants use Excel — manually, slowly, with brittle formulas — and how it can be used to automate, analyse, and model with confidence and speed.

Learnsignal's CPD Excel for Accountants course is designed for qualified accounting professionals who already use Excel regularly but want to develop significantly more advanced skills — moving from competent to expert in the features that make the most difference to finance work.

What the Course Covers

Power Query — Data Automation

Power Query allows you to connect to, import, clean, and transform data from multiple sources automatically — eliminating the repetitive manual data preparation work that consumes hours in most finance teams. Covers connecting to data sources, transforming data, and refreshing reports with a single click.

Power Pivot and Data Modelling

Power Pivot enables Excel to handle millions of rows and create relationships between tables — providing analytical power within a familiar spreadsheet environment. Covers building data models, calculated columns and measures using DAX (Data Analysis Expressions), and producing dynamic management reports from large datasets.

Advanced Formulas and Financial Modelling

Excel's most powerful formulas for financial analysis — XLOOKUP, dynamic array formulas (FILTER, SORT, UNIQUE), lambda functions, and advanced conditional logic. Plus financial modelling best practice: model structure, separation of inputs and outputs, sensitivity analysis, and scenario modelling.

Introduction to Python for Finance

An accessible introduction to Python as a complement to Excel — automating repetitive tasks, handling large datasets, and building financial analyses using pandas. No programming background required: the focus is practical finance applications for accountants.