Training The Digital Workforce of Tomorrow.
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
23 Sep 2024 - 24 Sep 2024
18 Nov 2024 - 19 Nov 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

WOR19S - Microsoft Word 2019
EXC16S | Microsoft Excel 2016
VBA13 | Excel 2013 Programming with VBA
WOR19E - Microsoft Word 2019 (Expert)
EXC19S | Microsoft Excel 2019
PPT16 | Microsoft PowerPoint 2016