Website is currently under going upgrading works. Some features may not be available. Should you require any assistance, do contact us via email at enquiries@avantustraining.com.
EX02-200-2016 | Analysis with Excel 2016

EX02-200-2016

-

1 Day(s)

Instructor-Led Training

from SGD $230*

Course Schedules

01 Feb 2024
11 Apr 2024
24 Jun 2024
26 Aug 2024
26 Dec 2023

Enroll/ Enquire Now

*Course Pricing Subjected to Terms & Conditions.

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.

Who Should Enrol?

  • Basic Excel usage and operating concepts
  • Able to use a Microsoft Windows computer

Course Outcome

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

LEARNING PATHWAY

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

FULL COURSE OUTLINE 👉

Related Courses

You might also be interested in these courses

office-banner.
EXC16S | Microsoft Excel 2016
office-banner.
WD02-200-2016 | Managing Word Documents and Publications 2016
office-banner.
EX02-200-2019 | Analysis with Excel 2019
office-banner.
PP02-200-2016 | Effective Presentations with PowerPoint 2016
office-banner.
EX03-200-2019 | Power Functions in Excel 2019
office-banner.
WOR19E - Microsoft Word 2019 (Expert)