Key points about this course

Duration : 1 Day
Public Class : RM 950.00
Live Virtual Class : RM 850.00

HRD Corp Claimable Course

Microsoft Excel 2016 Advanced

Live Virtual Class

Public Class

In House Training

Private Class

Course Overview

Microsoft Excel helps you to organise data, do basic and complex mathematical functions, turn piles of data 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

× WhatsApp Us