Microsoft Excel 2016 Advanced

Exam Code : 272

Duration: 1 Day

Training Fee: RM 500.00

HRDF Claimable

About this course


Microsoft Excel helps you to organise data, Do basic and complex mathematical functions, Turn piles of date into helpful graphics and charts, Analyse data and forecasting predictions, Create, build, and edit pixelated images and many more.

In this Microsoft Excel 2016 training, you will learn the skills necessary to use pivot tables, audit and analyze worksheet data, utilize data tools, collaborate with others, and create and manage macros.

This Microsoft Excel course is available in our public training class at our training lab in Kuala Lumpur or In House training at client’s venue throughout Malaysia.

Audience profile

Students who have intermediate skills with Microsoft Excel 2016 who want to learn more advanced skills or students who want to learn the topics covered in this course in the 2016 interface.

Course Content

Managing Data

  • Consolidating Information
  • Removing Duplicates
  • Configuring Data Validation
  • Converting Text to Columns


Outlining and Group Data

  • Outlining Data
  • Showing and Hiding Outline Details
  • Grouping Data
  • Creating Subtotals
  • Removing Outlining and Grouping


Data Visualization

  • Understand Types of Charts
  • Box & Whisker compares sets of data
  • Creating Treemap Chart
  • Creating Waterfall Chart


Analyzing Data

  • Using Goal Seek
  • Using Data Tables


Using Solver

  • Setting up the Worksheet
  • Running Solver
  • Generating Reports and Scenarios with Solver
  • Modifying Constraints
  • Setting Solver Options


Pivot Table Features

  • Creating a Basic PivotTable
  • Creating a Basic PivotChart
  • Using the PivotTable Fields Pane
  • Adding Calculated Fields
  • Sorting Pivoted Data
  • Filtering Pivoted Data
  • Using Slicers
  • Creating Timelines

Training Methods

Public Class Training

Private Class Training

In-House Class Training

Public Class Schedule
14 Jan 2020
10 Mar 2020
11 May 2020
7 Jul 2020
8 Sep 2020
17 Nov 2020

Please contact us if you need more information about Private or In-House Class Training – click here

Register Here

  • Public Class Training

  • Date Format: DD slash MM slash YYYY
  • Date Format: DD slash MM slash YYYY
  • Your Information

  • Participant List

  • NameContact NumberDesignation 

Any Questions?

  • Contact Us

Call Us : 03-21165778

× WhatsApp Us