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

