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