Excel on Steroids
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)