Course Details

Fundamental Data Analysis using Excel

Overview

  • Course Date:

    8 Jun 2026 to 9 Jun 2026

    14 Sep 2026 to 15 Sep 2026

    14 Dec 2026 to 15 Dec 2026

  • Registration Period:

    5 Mar 2026 to 25 May 2026

    5 Mar 2026 to 24 Aug 2026

    5 Mar 2026 to 23 Nov 2026

  • Duration/Frequency:

    16 Hours | (9 am - 6 pm)

  • Mode of Training:

    Classroom

Course Objective

Ever wonder how you can generate relevant information and convert it to business insights, using Microsoft Excel? Well, take this course and master this powerful tool, increasing your job efficiency with enhance Data Analysis skills. Designed for analysing data in Business applications, you will learn how to digitally import it from various sources, merge and process data for visual presentation, as well as build predictive models to support complex decision-making.

By end of this course, participants will be able to:

  1. Understand how to apply commonly used statistical and lookup functions.
  2. Gather data and organise it for Business analysis.
  3. Generate and interpret charts.
  4. Build dashboards using PivotTables and PivotCharts.
  5. Use Excel What-If Analysis and Data Analysis tools for generating different Business Development scenarios and aid decision-making.

Topics to be covered
  • Collecting and Managing Business Data
  • Constructing Charts
  • Building Dashboard using PivotTables and PivotCharts
  • Decision Making using What-If Analysis


Hands-On Practice
Practicing a list of tasks that help hone data analysis skills in generating required information

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.