Website is currently under going upgrading works. Some features may not be available. Should you require any assistance, do contact us via email at
AV234-MDAE | Modern Data Analysis in Excel



2 Day(s)

Instructor-Led Training

from SGD $900*

Course Schedules

15 Jan 2024 - 16 Jan 2024
04 Mar 2024 - 05 Mar 2024
23 May 2024 - 24 May 2024
25 Jul 2024 - 26 Jul 2024
05 Aug 2024 - 06 Aug 2024
21 Sep 2024 -22 Sep 2024

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

Course Overview

This course is specially designed for existing users of Microsoft Excel who want to import, manage, and transform data from single or multiple sources and create reports in Excel with Office Excel 365.

Who Should Enrol?

Information workers using Microsoft Excel focusing on data management, analysis and reporting.

Course Outcome

Participants will gain an understanding of the importance of managing the quality of data that they are working with. They will learn skills on cleaning and transforming data to remove noise. They will also be able to work with data relationships to link multiple datasets together for use later. They will be able to create reports using PivotTables or any other visualization tools. They will then load and present the analysis into the Excel worksheet.


Module 1: Introduction to the Modern Data Analysis Tools in Excel
Module 2: Connect Data from Multiple Sources
Module 3: Transform and Shape Data with Power Query
Module 4: Loading Data
Module 5: Modeling Data with PowerPivot
Module 6: Building Interactive Report Visualizations


Related Courses

You might also be interested in these courses

EX02-200-2019 | Analysis with Excel 2019
EX03-200-2016 | Power Functions in Excel 2016
VIS16 | Microsoft Visio 2016
PPT16 | Microsoft PowerPoint 2016
EXC19S | Microsoft Excel 2019
PRO19 - Microsoft Project 2019