Accounting Skills · Online course
Advanced Excel
Accountants who already use Excel daily and need speed, automation and reliability.
- Self-paced, on demand
- 6 months access
- 28 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
10 modules · 28 lessons
Video 1 · Advanced Lookup and Reference3 lessons
- Part A · INDEX and MATCH, and two-way lookups
- Part B · XLOOKUP, XMATCH and dynamic ranges
- Part C · OFFSET, INDIRECT, CHOOSE and their risks
Video 2 · Logical, Text and Date Functions3 lessons
- Part A · Nested IF, IFS, SWITCH and complex conditions
- Part B · TEXT, LEFT, RIGHT, MID, TRIM, SUBSTITUTE and TEXTJOIN for cleaning data
- Part C · Date and time functions for financial periods and ageing
Video 3 · Array Formulas and Dynamic Arrays3 lessons
- Part A · SUMPRODUCT and array logic
- Part B · FILTER, SORT, UNIQUE and SEQUENCE
- Part C · Replacing helper columns with dynamic array formulas
Video 4 · Conditional Formatting and Data Validation2 lessons
- Part A · Rule-based formatting, formulas in rules and data bars
- Part B · Validation lists, dependent dropdowns and input control
Video 5 · Advanced PivotTables and PivotCharts3 lessons
- Part A · Grouping, calculated fields and calculated items
- Part B · GETPIVOTDATA and building reports on top of pivots
- Part C · Slicers, timelines and connecting multiple pivots
Video 6 · What-If Analysis3 lessons
- Part A · Goal Seek and scenario manager
- Part B · One-way and two-way data tables
- Part C · Solver for allocation and optimisation problems
Video 7 · Power Query and Power Pivot3 lessons
- Part A · Importing and transforming with Power Query
- Part B · The data model and relationships
- Part C · Introductory DAX measures for finance
Video 8 · Dashboards3 lessons
- Part A · Planning the dashboard: audience, message and metrics
- Part B · Building the data layer, the calculation layer and the display layer
- Part C · Interactivity, refresh and handover
Video 9 · Macros and VBA Basics3 lessons
- Part A · Recording, running and editing a macro
- Part B · The VBA editor, variables, loops and conditions
- Part C · Practical macros for month-end routines
Video 10 · Protection, Auditing and Performance2 lessons
- Part A · Protecting sheets, workbooks and specific ranges
- Part B · Formula auditing, trace precedents and error checking; speeding up a slow workbook
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.

