Analysis with Excel 2016

Course Code:
EX02-200-2016

Duration:
1 day
8.30am to 5.30pm  
SSG Funding Validity Period
8 Mar 2019 – 6 Mar 2023
Course Fees:
S$230 (excl of G.S.T)
Course Reference Number
TGS-2020501311

Mode of Training
Instructor-led (Classroom)

2021 Course Dates
9 Sep 2021
7 Oct 2021
18 Nov 2021
9 Dec 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.

SkillsFuture Credit Eligible

All Singaporeans aged 25 and above can use their $500 SkillsFuture Credit from the government to pay for a wide range of approved skills-related courses. Visit the SkillsFuture Credit website (www.skillsfuture.sg/credit) to choose from the courses available on the SkillsFuture Credit course directory.

Course Overview

Excel has powerful analysis tools such as Pivot Tables and charts. These provide a visual and interactive way to analyse and present your data in meaningful ways. Participants will learn these to understand and apply analysis concepts in this one-day course.

Course Outline

Module 1: Working with Charts

Module 2: Adding Sparklines

Module 3: Working with Pivot Tables

Module 4: Working with Pivot Charts

Module 5: WHAT-IF Analysis

Module 6: Using Excel as A Database

Module 7: Macros

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min