fbpx

Microsoft Excel 2016 Advanced

Exam Code : 272

Duration: 1 Day

Training Fee: RM 500.00

HRDF Claimable

About this course

Overview

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
12 Jan 2019
23 Feb 2019
9 Mar 2019
6 Apr 2019
23 May 2019
8 Jun 2019
5 Jul 2019
10 Aug 2019
7 Sep 2019
9 Oct 2019
16 Nov 2019
5 Dec 2019

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