Excel and Data Analysis CPE for CPAs: Build a Learning Plan

Excel and data-analysis training works best when it addresses a task you need to perform: reconciling an export, reviewing exceptions, explaining a variance or preparing an audit analysis. Start with that task, identify the missing skill, and choose courses in a sequence that lets you practise it.

For a US CPA, there is a second decision: whether the particular course satisfies your CPE requirements. The learning routes below use courses in Learnsignal’s Excel CPD catalogue. They are recommendations for building skills, not a pre-approved CPE bundle. Confirm the current course-specific CPE disclosures before booking; do not convert a displayed CPD unit or hour total into US CPE credits.

Diagnose the skill gap before choosing a course

Take a small, anonymised spreadsheet that resembles your normal work. Try the following tasks without following a tutorial. Record where you need help rather than judging yourself by how many years you have used Excel.

• Foundations: enter dates and amounts consistently, navigate a workbook and explain what a formula refers to.
• Data quality: identify missing values, duplicate records, inconsistent formats and totals that do not reconcile to the source.
• Analysis: combine an account code with its description, summarise transactions by category and explain an unusual result.
• Reporting: turn the analysis into a chart or dashboard that helps someone make a decision.
• Audit application: explain what an analytical result suggests, its limitations and what further evidence you would need.

Your starting point is the earliest task you cannot yet complete reliably. Someone who builds charts quickly may still benefit from data-integrity training if their source totals regularly change.

Match the course to the problem

The following descriptions reflect the published course pages checked on 22 October 2026. Use the linked page to review the full syllabus. The suggested practice outputs are our learning recommendations, not additional course completion requirements.

A sequence for a beginner

Begin with Spreadsheet Know How, then Spreadsheet Functions. Practise with a single clean file before combining several files. The aim is to understand what a formula does and how copying it affects its references.

Next, study Sorting, Checking & Importing Data before relying on summaries. Move to Pivot Tables and Workbook Management once you can explain the input data and reconcile its totals. Finish with the reporting or audit course that matches your role.

These are suggested learning stages. They do not replace a sponsor’s official program knowledge level or prerequisites. Schedule practice between stages rather than selecting a long list of courses solely to fill a credit target.

A sequence for an experienced Excel user

Start with the diagnostic exercise. If your formulas and references are reliable, focus on the weakness that causes rework. For example, a monthly reporting analyst might study data integrity, review PivotTables and then build a dashboard. An auditor might review data quality, move into audit analytics and practise explaining exceptions.

Use a before-and-after work sample to assess progress. Can another person follow the source, calculation and conclusion? Can you refresh the analysis without silently dropping rows? Those tests are more useful than adding features that your work does not need.

Use the existing tutorials between courses

For a focused refresher, our PivotTable guide explains source layout, summaries and refreshing. Our XLOOKUP guide covers lookup behaviour and version compatibility. Use them when a particular step needs clarification, rather than repeating a whole course.

After the underlying process is reliable, the Power Automate cloud flows and approvals guide can help you explore workflow automation. Check your organisation’s permissions, software licences and data policies first. Reading these blog tutorials does not itself award a Learnsignal CPE certificate.

Check the field of study as well as the credit total

General spreadsheet instruction and applied audit analysis can fall into different fields. NASBA’s Fields of Study document places general Computer Software & Applications learning in a non-technical field, while software instruction focused on a particular accounting, auditing or tax application can be classified in that relevant field. The content and objectives matter.

Use the field assigned to the specific program; do not relabel a certificate because you used the skill at work. Your board may impose its own technical-subject minimums or other limits. Check your jurisdiction through NASBA’s board information and the board’s current rules.

Course-selection checklist

• Identify one work problem and the skill needed to solve it.
• Check prerequisites, software version, operating system and any required licences.
• Confirm that the exact course and delivery method are offered for US CPE, including the published credits and field of study.
• Check board acceptance, subject limits and your reporting deadline.
• Confirm access duration, assessment requirements and certificate conditions before paying.
• Plan a practice output and record the final awarded credit from the certificate, not your personal study time.

Browse Learnsignal’s Excel courses to build your shortlist. Choose the course that closes the most useful skill gap, then complete the CPE checks for that specific program before enrolling.