🛢️ Advanced Excel Course

Course Topics:

Advanced Excel Course
Duration: 5 sessions × 1.5 hours

1. PivotTables and PivotCharts (Introduction)

   • Creating PivotTables

   • Grouping and filtering

   • Basic PivotCharts

2. Tables and Structured References

   • Converting data into tables

   • Table formulas

3. Basic Dashboard Elements

   • Combining visuals

   • Using form controls (sliders)

4. Advanced Functions

   • SUMIFS, COUNTIFS, IFS

   • OFFSET, INDIRECT, CHOOSE

   • Speed improvement using Excel shortcuts

5. Advanced PivotTable Techniques

   • Calculated fields

   • Slicers and timelines

   • Grouping by date or custom fields

6. Power Query (Get & Transform)

   • Importing from multiple data sources

   • Cleaning and transforming data

7. Advanced Charting Techniques

   • Combo charts and sparklines

   • Dynamic charts with named ranges

8. Dashboard Design

   • KPI indicators

9. Macros & VBA (Introduction)

   • Recording macros

   • Basic VBA editor usage