Introduction
  • Introduction to the Course
Presentation of the Tool
  • Introduction to Presentation of the Tool
  • Tables sheet
  • General Ledger sheet – part 1
  • General Ledger sheet – part 2
  • Pivot Table sheet
  • Self-practice - building the sheets
  • Conclusion to Section 2
Using the tool for past's needs, historical reports
  • Introduction to Section 3
  • Exemplification - Expenses and payments to suppliers
  • Exemplification - Checks and checks that have not yet been repaid
  • Exemplification - Credit cards
  • Exemplification - Bank reconciliation
  • Practice challenge
  • Conclusion to Section 3
Use of the tool to build forecasts for future periods
  • Introduction to Section 4
  • Exemplification
  • Conclusion to Section 4
Mistakes' investigation, Frauds
  • Checking bank account and credit cards
Using of multiple bank accounts
  • Introduction to Section 6
  • Exemplification
Work procedures
  • Work procedures
Course Wrap-Up
  • Conclusion