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

Accounting Skills · Online course

Preparing Financial Statements and Management Accounts Using Excel

Accountants and account officers who must produce a full set of accounts from raw records, without a package.

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

20 modules · 51 lessons

Video 1 · General Introduction to IAS and IFRS and Their Application3 lessons
  1. Part A · Introduction to International Financial Reporting Standards & International Accounting Standards (IFRS & IAS)
  2. Part B · The Conceptual Framework: objectives, qualitative characteristics and the elements of financial statements
  3. Part C · The standards you meet most often in practice: IAS 1, 2, 7, 8, 16, 36, 37, 38 and IFRS 15 and 16
Video 2 · Excel for Accountants4 lessons
  1. Part A · Setting up a workbook an auditor can follow: structure, sheet naming and the colour convention for inputs, formulas and links
  2. Part B · The functions that do most accounting work: SUMIFS, COUNTIFS, IF, IFERROR, VLOOKUP, XLOOKUP, INDEX and MATCH
  3. Part C · Tables, named ranges and data validation for clean, consistent postings
  4. Part D · PivotTables for trial balances, ledger summaries and management schedules
Video 3 · What Is Accounting and Bookkeeping2 lessons
  1. Part A · Accounting and bookkeeping distinguished: scope of each and where the client obligation begins
  2. Part B · The accounting cycle end to end, and the accountant’s ethical duties to the client and the public
Video 4 · Bookkeeping Tools2 lessons
  1. Part A · Manual books, spreadsheets and cloud packages: choosing by client size, volume and budget
  2. Part B · Chart of accounts design and a coding structure that survives an audit
Video 5 · Difference Between Audited Financial Statements and Management Accounts2 lessons
  1. Part A · Purpose, audience, frequency and legal status of each
  2. Part B · What may appear in management accounts that cannot appear in statutory accounts, and how to caveat a management pack
Video 6 · Bank Analysis3 lessons
  1. Part A · Obtaining, cleaning and structuring a bank statement in Excel
  2. Part B · Classifying receipts and payments; separating capital from revenue items
  3. Part C · Spotting related-party movements, contra entries, reversals and unexplained lodgements
Video 7 · Analysing USD Bank Statements and Summaries3 lessons
  1. Part A · Foreign currency accounts: IAS 21 essentials and choice of exchange rate
  2. Part B · Translating USD movements to Naira: transaction rate, closing rate and exchange differences
  3. Part C · Building the USD summary schedule and reconciling it to the Naira ledger
Video 8 · Running Cashbook2 lessons
  1. Part A · Building a running cash book in Excel with automatic balances and analysis columns
  2. Part B · Petty cash, the imprest system and multi-column analysis cash books
Video 9 · Bank Reconciliation Statements3 lessons
  1. Part A · Why the cash book and the bank statement differ: timing, errors and unrecorded items
  2. Part B · The adjusted cash book and the reconciliation statement, worked live from a real statement
  3. Part C · Reconciling high-volume accounts and dealing with long-outstanding items
Video 10 · Source Documents and Books of Original Entry2 lessons
  1. Part A · Invoices, receipts, goods received notes, payment vouchers: what a complete file must contain
  2. Part B · Day books, the general journal, and the audit trail from source document to ledger
Video 11 · Summarised Cash Books2 lessons
  1. Part A · Summarising a year of transactions into a workable cash book
  2. Part B · Building income and expenditure summaries where records are incomplete
Video 12 · Quarterly Reports2 lessons
  1. Part A · Designing the quarterly reporting pack: contents, layout and turnaround
  2. Part B · Variance commentary and quarter-on-quarter comparison
Video 13 · Fixed Asset Register3 lessons
  1. Part A · Building the register: cost, additions, disposals, location and custodian
  2. Part B · Depreciation schedules and the IAS 16 movement note built in Excel
  3. Part C · Physical verification, tagging, and reconciling the register to the ledger
Video 14 · Debtors and Creditors Daybook2 lessons
  1. Part A · Sales and purchase day books and their control accounts
  2. Part B · Ageing schedules, customer statements and reconciliation to suppliers’ statements
Video 15 · Journals2 lessons
  1. Part A · Journal types, narration discipline, supporting evidence and authorisation
  2. Part B · Accruals, prepayments, provisions and the year-end adjusting journals
Video 16 · Extended Trial Balance3 lessons
  1. Part A · From the ledger to the trial balance in Excel
  2. Part B · The adjustment columns: correcting errors, clearing the suspense account and posting accruals
  3. Part C · Extending to profit or loss and financial position
Video 17 · Notes and Financial Statement Preparation4 lessons
  1. Part A · Statement of profit or loss and other comprehensive income
  2. Part B · Statement of financial position and statement of changes in equity
  3. Part C · Statement of cash flows: the indirect method built directly from the extended trial balance
  4. Part D · Accounting policies and the supporting notes
Video 18 · Financial Statement Analysis3 lessons
  1. Part A · Profitability, liquidity, efficiency and gearing ratios
  2. Part B · Trend analysis, common-size analysis and cash flow analysis
  3. Part C · Writing the analysis so that a non-accountant can act on it
Video 19 · Communicating the Management Report2 lessons
  1. Part A · Structuring the report: executive summary, findings, recommendations and appendices
  2. Part B · Charts, dashboards and presenting the numbers to a board or an owner-manager
Video 20 · Introduction to AI for the Accountant2 lessons
  1. Part A · What AI can and cannot do inside an accounting engagement
  2. Part B · Practical uses: drafting, reconciliation checks and analysis, and the confidentiality rules that apply

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