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

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

Register Here

  • Public Class Training

  • Your Information

  • Participant List

  • NameContact NumberDesignation 
    Add a new row

Any Questions?

  • Contact Us

Call Us : 03-21165778