Description
Workshop Overview & Details
+
Time: 9:00 AM – 5:00 PM
(Price Includes SST)
- FREE Workbook
- FREE Certificate
- FREE Digital Notes
Morning Session
+
1) Excel basics & interface
2) Structuring data into tables
3) Data validation techniques
4) Common data errors & fixes
5) Cleaning duplicates & blanks
6) Key formulas (SUMIFS, IF)
7) VLOOKUP & XLOOKUP
8) Conditional formatting
9) Logical analysis
10) PivotTables & PivotCharts
Afternoon Session
+
11) Filtering & slicing data
12) Basic statistics
13) Combining datasets
14) Charts & visualisation
15) Dynamic charts
16) Dashboard design
17) Interactivity controls
18) Readability techniques
19) Sparklines & highlights
20) Exporting reports
21) Final dashboard project
