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

