Analysis with Excel 2019

Course Code:
EX02-200-2019
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
9 Jan 2020
5 Mar 2020
4 May 2020
9 Jul 2020
3 Sep 2020
12 Nov 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.
Do note that this course listed uses digital courseware. You are required to bring your own device to access the digital manual.

Course Overview

Excel Formula and Functions provide a powerful way to carry out automate calculations on your data and streamline your work. You will learn in detail, how basic operators and functions work, some common types of functions available and their applications.

Course Outline

SECTION 1: CHARTING
Introduction To Charts
Creating Charts
Editing Charts
Move Charts
Saving a Chart as a Template
Creating Charts with Quick Analysis
Sparklines

SECTION 2: PIVOT TABLE
Introducing to Pivot Tables
Creating a Pivot Table
Manipulating Data
Formatting Pivot Tables
Sorting Data in a Pivot Table
Filtering Data in a Pivot Table
Grouping Data in a Pivot Table
Performing Calculations in a Pivot Table
Creating and Manipulating Pivot Charts

SECTION 3: WHAT-IF ANALYSIS
Overview of What-If Analysis
Goal Seek
Scenario Manager

SECTION 4: WORKING WITH LISTS
Fill Data
Sorting Data
Filtering Data
Summarizing Data
Data Validation

SECTION 5: USING MACROS
Overview Of Macros

Click Here for full course outline

Take the Next Step

It Takes Less Than 5 Min