Microsoft Excel 2016 Advanced

Public Class

Live Virtual Class

Private Class

In-House Class

Key points about this course

Duration : 1 Day
Public Class : RM 950.00
Live Virtual Class : RM 850.00
HRDF Claimable
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