Analysis with Excel 2016

Course Code:
EX02-200-2016

Duration:
1 day
8.30am to 5.30pm  
Location:
80 Jurong East Street 21 #04-04
Devan Nair Institute
Singapore 609607
Course Fees:
S$230 (excl of G.S.T)
2020 Course Dates
16 Jul 2020
11 Aug 2020
17 Sep 2020
8 Oct 2020
26 Nov 2020
10 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.

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