Excel on Steroids

Screenshot 2023-11-09 at 11.50.48

Course content

Introduction
Unit 1: Formula Basics
Unit 2: Logical Functions
Unit 3: Lookup Function
Unit 4: Reporting Formulas
Unit 5: Text Formulas
Unit 6: Dates
Unit 7: Financial Functions
Unit 8: Other
Unit 9: Google Sheets
Examination
Certificate

  • Introduction
    Unit 1: Vba Coding: Where To Start
    Unit 2: Basic Functions
    Unit 3: User Forms
    Unit 4: Formulas
    Unit 5: Loops
    Unit 6: Finishing Your Program
    Unit 7: Other Codes
    Unit 8: More Complicated Programs Explained
    Unit 9: Free Codes To Use
    Assessment
    Certificate

Introduction
Unit 1: Create Reports From Multiple Sources
Unit 2: Converting Multiple Columns Into A Database Format
Unit 3: Simplifying Reporting
Unit 4: Automatic Reconciliations
Unit 5: Reporting By Using The Indirect Formula
Unit 6: Compiling An Age Analysis
Unit 7: Amortization Tables
Unit 8: Cash Flows
Assessment
Certificate

Final Exam – Exam on Steroids (I1)