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)
2019 Course Dates
12 Dec 2019
2020 Course Dates
16 Jan 2020
13 Feb 2020
12 Mar 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