Accounting Skills · Online course
Data Analysis for Finance
Accountants who must turn large transaction files into findings and recommendations.
- Self-paced, on demand
- 6 months access
- 24 lessons
- Certificate on completion
- 6 months from confirmed payment
- Study on your phone, tablet or computer
- Certificate when you complete the course
Secure online payment. Your login link arrives by email as soon as payment is confirmed. 48-hour refund policy
Course content
9 modules · 24 lessons
Video 1 · The Data Analysis Workflow2 lessons
- Part A · From question to data to finding: how an analysis engagement is structured
- Part B · Data sources in a finance function and what each can and cannot tell you
Video 2 · Getting and Cleaning Data3 lessons
- Part A · Importing from CSV, PDF, bank portals and accounting packages
- Part B · Cleaning: duplicates, blanks, text-as-number, dates and inconsistent codes
- Part C · Structuring a flat table that can be analysed
Video 3 · Power Query3 lessons
- Part A · The query editor: steps, applied transformations and refresh
- Part B · Appending and merging queries; unpivoting reports back into data
- Part C · Building a repeatable monthly refresh
Video 4 · Data Modelling and Power Pivot3 lessons
- Part A · The data model, tables and relationships
- Part B · Fact and dimension tables for finance data
- Part C · Introduction to DAX measures
Video 5 · PivotTables and Analytical Measures3 lessons
- Part A · PivotTables for financial analysis: grouping, sorting and calculated fields
- Part B · Common measures: variance, percentage of total, running total and year on year
- Part C · Slicers, timelines and interactive summaries
Video 6 · Analytical Techniques3 lessons
- Part A · Variance and trend analysis
- Part B · Ratio and common-size analysis on transaction data
- Part C · Segmenting by customer, product, branch and period
Video 7 · Visualisation and Dashboard Design3 lessons
- Part A · Choosing the right chart for the message
- Part B · Building a finance dashboard in Excel
- Part C · Design rules: clarity, labelling and avoiding chart junk
Video 8 · Audit and Forensic Analytics2 lessons
- Part A · Duplicate payments, round-sum entries, weekend and out-of-hours postings
- Part B · Benford’s Law, outlier detection and sampling for testing
Video 9 · Reporting, Automation and Refresh2 lessons
- Part A · Writing up findings: what was tested, what was found, what to do
- Part B · Automating the pack so next month is a refresh, not a rebuild
Who this is for
Practitioners, students and business owners who want practical skills they can use straight away.
48-hour refund window
Apply within 48 hours of payment if you have watched no more than 10% of any video and have not downloaded course materials. Read the refund policy
Before you enrol
How do I get access?
Pay securely online. As soon as your payment is confirmed, we email you a link to set your password and start learning. Existing learners can sign in with their account.
How long can I study?
6 months from confirmed payment
Will I receive a certificate?
A certificate is available only for courses marked as certificate-bearing, after their completion requirements are met. Professional-exam courses do not issue certificates.
What if I need help or a refund?
Contact support for course or payment questions. Refund eligibility depends on the payment and your learning activity; review the refund policy before paying.

