Week 1: Excel Basics & Navigation

• Understanding Excel interface: ribbons, cells, ranges
• Workbook and worksheet structure
• Basic formatting: fonts, colours, borders
• Number formats and data types
• Saving, naming, and organising workbooks
• Go to Chapter

Week 2: Formulas & Functions

• Using arithmetic operators in formulas
• Introduction to common functions: SUM, AVERAGE, COUNT, MAX, MIN
• Conditional functions: IF, COUNTIF, SUMIF
• Text functions: LEFT, RIGHT, MID, CONCATENATE, TEXTJOIN
• Relative vs. absolute cell referencing
• Go to Chapter

Week 3: Data Tools & Analysis

• Sorting and filtering data
• Using Tables and structured references
• Introduction to PivotTables and PivotCharts
• Data validation and drop-down lists
• Conditional formatting rules
• Go to Chapter

Week 4: Dashboards & Automation

• Design principles for dashboards
• Using slicers and charts interactively
• Intro to Power Query: merging and cleaning data
• Intro to Macros and automation basics with VBA
• Final project outline: Build your own dashboard
• Go to Chapter