MS OFFICE
1. COMPUTER FUNDAMENTALS
2. WINDOWS OPERATING SYSTEM
3. MS WORD
4. MS EXCEL
5. MS POWERPOINT
1. EXCEL FUNCTIONS (Logical, Text, Lookup, Error & Conditional, etc.)
2. ADVANCED SORTING, FILTERING & DATA VALIDATION
3. CONDITIONAL FORMATTING, NAMED & DYNAMIC RANGES
4. EXCEL TABLES, STRUCTURE, PIVOT TABLES, CHARTS, SLICERS, WHAT-IF ANALYSIS
5. POWER QUERY (IMPORTING & CLEANING DATA)
6. INTRO TO MACROS & VBA + INTRO TO FINANCIAL MODELLING
7. 3-STATEMENT MODEL + FORECASTING TECHNIQUES
8. SCENARIO / SENSITIVITY ANALYSIS + VALUATION MODELS + REVIEW
9. VALUATION MODELS + CREATING SUMMARY SHEETS / DASHBOARDS
10. CAPSTONE PROJECT + FINAL REVIEW
Course Code : S-SKC001
Course Code : S-SKC002
Course Code : S-SKC003
Course Code : S-SKC004
Course Code : S-SKC005
Course Code : SKC006
Course Code : SKC007
Course Code : SKC008
Course Code : SKC009
Course Code : SKC010
Course Code : SKC011
Course Code : SKC012
Course Code : SKC013
Course Code : SKC014
Course Code : SKC015
Course Code : SKC016
Course Code : SKC017
Course Code : SKC018
Course Code : M-SKC001
Course Code : M-SKC002
Course Code : M-SKC003
Course Code : M-SKC004
Course Code : M-SKC005
Course Code : M-SKC006
Course Code : M-SKC007
Course Code : M-SKC008
Course Code : M-SKC009
Course Code : M-SKC010
