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)

2022 Course Dates
20 Jan 2022
10 Feb 2022
17 Mar 2022
21 Apr 2022
9 Jun 2022
12 Jul 2022
8 Aug 2022
15 Sep 2022
6 Oct 2022
1 Dec 2022
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