All programs
Digital SkillsProductivityDMPT-101 100% HRDF claimable
Data Analysis Fundamentals using Excel
Learn the essential skills needed to analyse data using Microsoft Excel. Covers core concepts of data analysis, fundamental functions for insight generation, practical data-cleaning techniques, and the use of PivotTables and PivotCharts for summarizing and visualizing data.
2 DaysPEOPLElogy
What you'll learn
- Understand the basic concepts and workflow of data analysis
- Apply essential Excel functions to summarize and analyse data
- Clean and prepare raw datasets using built-in Excel tools
- Build PivotTables to explore and summarize large datasets
- Create PivotCharts to visualize results
Course modules (5)
01Introduction to data analysis
02Functions for data analysis (aggregations, IF, lookup)
03Data cleaning methods
04Pivot Tables for analysis
05PivotCharts for visualization