Getting Ready
  • Introduction to the Course
  • Download Resources
  • Excel Functions
  • Excel Shortcuts
  • Install the Magnimetrics Add-In
Project 1: Bank Reconciliation
  • Prepare a Bank Reconciliation
Project 2: Fixed Assets Register
  • Fixed Assets Register Reconciliation - Part 1
  • Fixed Assets Register Reconciliation - Part 2
Project 3: Trade Raceivables Ageing Analysis
  • Trade Receivables Ageing Analysis - Part 1
  • Trade Receivables Ageing Analysis - Part 2
  • Trade Receivables Ageing Analysis - Part 3
  • Trade Receivables Ageing Analysis - Part 4
Project 4: Sales Analytics
  • Sales Analysis with Pivot Tables - Part 1
  • Sales Analysis with Pivot Tables - Part 2
Congratulations
  • Course Completion
Additional Learning
  • Trial Balance Mapping in Excel