Course Details

Effective Data Analysis Using Excel

Overview

  • Course Date:

    10 Sep 2026 to 11 Sep 2026

    27 Oct 2026 to 28 Oct 2026

  • Registration Period:

    27 Aug 2026 to 3 Sep 2026

    27 Aug 2026 to 13 Oct 2026

  • Duration/Frequency:

    16 Hours

  • Mode of Training:

    Face-to-Face (Classroom Teaching)

What You Will Learn

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 Generative AI (GenAI) to enhance productivity and insight generation.

Designed for working professionals who handle data in their daily roles, they will undergo hands-on learning with realistic workplace datasets. They will apply Excel tools like pivot tables, charts, and interactive dashboards to clean, analyse, and present data. GenAI will be used to support formula creation and analytical tasks, letting participants 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.

By end of this course, participants will be able to:
  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, as well as 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.

Topics to be covered
  • Preparing and Managing Business Data
           (a) Importing data from multiple sources
           (b) Cleaning data with Power Query and text functions
           (c) Using statistical and lookup functions
           (d) Formatting and conditional formatting
           (e) Applying real-world datasets for analysis

  • Analysing and Visualising Data
           (a) Creating and customising charts
           (b) Using Sparklines for trend visualisation
           (c) Enhancing chart presentation for reports
           (d) PivotTables and PivotCharts 
           (e) Building Excel PivotTables
           (f) Designing dashboards with PivotCharts
           (g) Adding slicers and timelines
           (h) Applying data model for multi-table analysis

  • Scenario-based Analysis for Decision Making
           (a) Using Goal Seek
           (b) Building Data Tables
           (c) Using Scenario Manager
           (d) Exploring Data Analysis ToolPak

Courses that may also interest you:

back to top

Singapore Polytechnic

500 Dover Rd Singapore 139651

Last updated: 11 June 2025

© 2025 Singapore Polytechnic

Best viewed using latest version of Microsoft Edge, Mozilla Firefox, Safari and Google Chrome.