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

Accounting Skills · Online course

Basic Excel

Beginners and staff who need a dependable working foundation before anything else.

  • Self-paced, on demand
  • 6 months access
  • 18 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

8 modules · 18 lessons

Video 1 · The Excel Interface and Navigation2 lessons
  1. Part A · The ribbon, workbook, worksheets, cells and the name box
  2. Part B · Moving, selecting and shortcuts that save hours
Video 2 · Entering, Editing and Formatting Data2 lessons
  1. Part A · Data types, autofill, flash fill, copy, paste and paste special
  2. Part B · Number, date and currency formats; alignment, borders and styles
Video 3 · Formulas, References and Operators3 lessons
  1. Part A · How a formula is built; operators and order of calculation
  2. Part B · Relative, absolute and mixed references
  3. Part C · Linking across sheets and workbooks
Video 4 · Essential Functions3 lessons
  1. Part A · SUM, AVERAGE, COUNT, COUNTA, MIN, MAX and ROUND
  2. Part B · IF, AND, OR, IFERROR
  3. Part C · SUMIF, SUMIFS, COUNTIF, COUNTIFS and VLOOKUP
Video 5 · Tables, Sorting and Filtering2 lessons
  1. Part A · Converting a range to a table and why it matters
  2. Part B · Sorting, filtering, subtotals and removing duplicates
Video 6 · Basic Charts2 lessons
  1. Part A · Column, bar, line and pie charts and when to use each
  2. Part B · Formatting a chart so it communicates
Video 7 · Printing, Page Setup and Sharing2 lessons
  1. Part A · Page setup, print areas, headers, footers and fitting to a page
  2. Part B · Saving formats, PDF export and sharing safely
Video 8 · Good Spreadsheet Habits2 lessons
  1. Part A · Layout, labelling and documentation of a working file
  2. Part B · Common errors and how to avoid them: hardcoding, broken ranges and hidden rows

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