Effective Data Analysis Using Excel
About This Course
Microsoft Excel remains one of the most widely used and accessible tools for business analysis across organisations. This course equips participants with practical skills to transform, manage, and analyse data using Microsoft Excel (Microsoft 365 / Excel 2024+ or equivalent), with the support of Generative AI to enhance productivity and insight generation.
Designed for working professionals who handle data in their daily roles, the course emphasises hands-on learning using realistic workplace datasets. Participants will apply Excel tools such as pivot tables, charts, and interactive dashboards to clean, analyse, and present data. Generative AI will be used to support formula creation and analytical tasks, enabling participants to work more efficiently and confidently with data.
Participants will also explore scenario planning tools to evaluate business situations and support data driven decision making, strengthening both individual effectiveness and enterprise data literacy.
What You'll Learn
1. Prepare and clean datasets using text, lookup and Power Query functions
2. Apply statistical and logical functions to perform descriptive and comparative analysis
3. Create and customise charts and PivotCharts to communicate data insights
4. Build interactive dashboards using PivotTables, Slicers, Timelines and the Data Model for multi-table analysis
5. Evaluate business scenarios with Goal Seek, Data Tables and Scenario Manager to support informed decision-making
Entry Requirements
Basic English literacy, numeracy, and computer skills. No prior Excel experience required.