Course Description:Semester I: 1. Introduction to Advanced Excel 2. Working with VLOOKUP and HLOOKUP 3. Data Validation Semester II: 1. Working with Pivot Tables 2. Using Subtotals 3. Conditional Formatting 4. What-If Analysis 5. Charts and Macros 6. Use of Sparklines