AV234-MDAE | Modern Data Analysis in Excel

AV234-MDAE

-

2 Day(s)

Instructor-Led Training

from SGD $900

Course Schedules

05 Jan 2023 - 06 Jan 2023
30 Mar 2023 - 31 Mar 2023
31 May 2023 - 01 Jun 2023
27 Jul 2023 - 28 Jul 2023
07 Aug 2023 - 08 Aug 2023
21 Sep 2023 - 22 Sep 2023
09 Nov 2023 - 10 Nov 2023

TELL YOUR FRIENDS

Exam Code

Course Duration

2 Day(s)

Delivery Mode

Instructor-Led Training

Course Price

from $900

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 IS THE COURSE FOR?

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

ATTAINABLE SKILLS

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.

LEARNING PATHWAY

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

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

office-banner.
EXC16E | Microsoft Excel 2016 Expert
office-banner.
ACS16 | Microsoft Access 2016
office-banner.
WOR19E - Microsoft Word 2019 (Expert)
office-banner.
EXC19E | Microsoft Excel 2019 Expert
office-banner.
WD02-200-2016 | Managing Word Documents and Publications 2016
office-banner.
PPT16 | Microsoft PowerPoint 2016

Have A Question?

WE'RE Here To Assist You 😊

Alternatively, you may contact us via live chat on the bottom right of your browser.

Search For A Course..

You may be interested in these