— AV234-MDAE

AV234-MDAE | Modern Data Analysis in Excel

AV234-MDAE

-

2 Day(s)

Instructor-Led Training

SGD $900

office-banner.

Course Schedules

30 Jan 2023 - 01 Feb 2023
27 Mar 2023 - 29 Mar 2023
17 Apr 2023 - 19 Apr 2023
26 Jun 2023 - 28 Jun 2023

TELL YOUR FRIENDS

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.
VIS16 | Microsoft Visio 2016
funded-course-tab
office-banner.
WOR16E | Microsoft Word 2016 Expert
office-banner.
50433 | PowerPivot for End Users
funded-course-tab
office-banner.
EXC16E | Microsoft Excel 2016 Expert
office-banner.
PRO16 | Microsoft Project 2016
office-banner.
OUT16 | Microsoft Outlook 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..