Data Analysis Fundamentals using Excel

Course Code:
MS10994

Duration:
2 days
8.30am to 5.30pm  
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
 Course Fees:
S$1,200 (excl of G.S.T)
2020 Course Dates
3 – 4 Dec 2020
None of the published dates will work for you? Speak to our training consultants for a private tuition arrangement or a closed door training.
Do note that this course listed is a Microsoft Digital Class (DMOC Class). You are required to bring your own device.

Course Overview

The main purpose of the course is to give students the ability to add analysis capabilities to Excel spreadsheets and to provide students with a foundation to learn about more advanced data analytics with Excel or Power BI.

Course Outline

Module 1: Reporting in Excel

Module 2: Excel Tables

Module 3: Pivot Tables and Pivot Charts

Module 4: Dashboards

Module 5: Hierarchies

Module 6: The Excel Data Model

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min