Data Analysis Fundamentals using Excel

Course Code:
MS10994

Duration:
2 days
8.30am to 5.30pm  
 Course Fees:
S$1,200 (excl of G.S.T)
2021 Course Dates
27 – 28 May 2021
24 – 25 Jun 2021
29 – 30 Jul 2021
2 – 3 Sep 2021
14 – 15 Oct 2021
18 – 19 Nov 2021
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