Lecture1.1: V Lookup, Conditional formatting
Lecture1.2: Date Functions
Lecture1.3: Character Functions
Lecture1.4: Nested If Reporting
Lecture1.5: PIVOT Tables
Lecture1.6: What-If-analysis
Lecture1.7: Linking Between Word / Excel / PPT
Lecture1.8: Count IF, Probability Distribution
Lecture1.9: Linking Multiple Sheets
Lecture1.10: Password Protecting Worksheets
Lecture1.11: if Statement, Compound IF, Sum IF
Lecture1.12: Consolidation of Data & Data Validation