Advanced Excel (2 Months)

Advanced Excel (2 Months)

Week 1-2

• Excel Basics Review: Short recap of formulas, formatting, and shortcuts.
•  Advanced Formulas: VLOOKUP, HLOOKUP, INDEX, MATCH, Nested IFs, COUNTIFS, SUMIFS
• Text Functions: CONCATENATE, LEFT, RIGHT, MID, LEN, TEXT

 Week 3-4

•  Data Analysis: Pivot Tables and Pivot Charts, Conditional Formatting (Custom Rules), Sorting and Filtering Advanced Data

 Week 5-6

• Data Visualization: Creating Dashboards, Using Sparklines, Charts: Waterfall, Histogram, Gantt Charts

Week 7-8

• Macros & VBA Basics: Recording and running Macros, Writing Basic VBA Scripts
• Data Tools: Data Validation, Grouping, Subtotals, Power Query Introduction