Morning Session>>

1) Introduction to Excel basics and interface overview.

2) Organizing data into tables: formatting and structure.

3) Understanding and applying data validation techniques.

4) Overview of common errors in raw data and their solutions.

5) Using Text-to-Columns and Flash Fill for quick formatting.

6) Removing duplicates, handling blanks, and correcting data types.

7) Working with Power Query for importing and cleaning data.

8) Key formulas: SUMIFS, COUNTIFS, IF & nested functions.

9) Advanced lookup: VLOOKUP, XLOOKUP

10) Implementing conditional formatting for highlighting insights.

11) Working with logical functions to identify trends/outliers

Afternoon Session>>

14) Summarising data with PivotTables and PivotCharts.

15) Grouping, filtering, and slicing data for deeper insights.

16) Conducting basic statistical analysis (mean, median, variance).

17) Combining multiple datasets for cross-referencing and analysis.

18) Creating and customising charts (bar, line, scatter, and pie charts).

19) Introduction to dynamic charts with slicers.

20) Designing dashboards using linked PivotTables and charts.

21) Adding interactivity to visualisations with form controls

22) Simplifying data presentation for better readability.

23) Using sparklines and conditional formatting for emphasis.

24) Exporting data and visualisations for reports and presentations.

25) Final project: Creating a comprehensive report with a dashboard.