Hotline 0703 824 3668 Chat on WhatsAppSuite 2011/2020, Anbeez Plaza, Wuse Zone 5, Abuja
DMC Business School

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

DMC Business SchoolYour pathway to professional exam success and practical business skillsICAN · ATSWA · CITN exam preparationLearn from chartered accountantsStudy at your own pace on any deviceIn partnership with Topnotch Learning Centre