Introduction to Excel Spreadsheet
Understanding Cell Referencing
Data Extraction: Advanced Sorting & Filtering, Creating Data Extraction
Using Vlookup, Lookup, Index and Match Functions
Data Validation
Conditional logical statements for business analysis (If, SumIf, CountIf, And, Or, Not etc)
Consolidating Multiple Sheets: Methods for automatically consolidating data from different sheets
Building Financial Functions into Ms-Excel (PMT, FV, PV, PPMT, IPMT etc)
Importing & Exporting Data in Ms-Excel
Loan Amortization Schedule
Sensitivity Analysis Testing Using Data Table
Pivot Table: Introduction to Pivot Tables and Pivot Charts
What-If Analysis (Goal Seek, Scenario Manager)
Excel Macros – The Power of Automation