WEEK 3-WEEK 4 

Excel (Foundational → Advanced)

Over the next two week we would be driving into the world of Microsoft Excel. we would start with the basic and then build on this until you are confident to work on your own project. 

Excel is a powerful spreadsheet application used to organise, analyse, and visualise data. This course covers Excel fundamentals, including basic maths and statistical functions, logical formulas such as IF, AND, and OR, and conditional formatting. Learners will also develop data cleaning and analysis skills using duplicate removal, text functions, date and time calculations, and chart selection based on best-use scenarios. Advanced topics include XLOOKUP, INDEX-MATCH, SUMIFS, COUNTIFS, Pivot Tables, and Power Query, culminating in a practical project focused on building interactive dashboards to transform data into actionable insights.