Microsoft Excel 2016 Intermediate
  • Helps you to organise data, do basic and complex mathematical functions, turn piles of data into helpful graphics and charts, analyse data etc
  • For students who have some familiarity with Microsoft Excel
  • Class is taught by the expert Microsoft Excel trainer

Public Class

Virtual Class

Private Class

In-House Class

Key points about this course

Duration : 1 Day
Training Fee : RM 650.00
Virtual Training Fee : RM 550.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 Intermediate level training, you will advance your skill set by learning to work with right formulas, lists, and illustrations. You will also work with charts and advanced formatting including styles.

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

Audience profile

This course is intended for students who have some familiarity with Microsoft Excel 2016 or more experienced Excel users who want to learn the topics covered in this course in the 2016 interface.

At course completion

After completing this course, students will be able to:

  • Learn to use formulas and functions.
  • Create and modify charts.
  • Convert, sort, filter, and manage lists.
  • Insert and modify illustrations in a worksheet.
  • Learn to work with tables.
  • Learn to use conditional formatting and styles.
Course Prerequisites
  • Basic Excel experience
Course Content

Working with Formulas

  • Concept of Formulas
  • Understanding Relative and Absolute Cell References
  • Understanding Named Ranges
  • Defining Named Ranges
  • Editing Named Ranges
  • Deleting Named Ranges
  • Using Named Ranges in Formulas
  • Using Array Formulas
  • Using 3D References

Working with Functions (I)

  • Concept of Functions
  • Using Advanced Functions
  • Using Logical Function: IF
  • Using Logical Function: AND
  • Using Logical Function: OR
  • Using Logical Function: IFS, SWITCH

Working with Functions (II)

  • Using Statistical functions: AVERAGEIF, COUNTIF
  • Using Lookup Functions: VLOOKUP ,HLOOKUP, LOOKUP
  • Using Text functions: TEXTJOIN, CONCAT
  • Using Statistical Functions: MAXIFS and MINIFS

Auditing Worksheets

  • Tracing Formula Precedents and Dependents
  • Showing Formulas
  • Evaluating Formulas
  • Using Error Option Buttons
  • Running an Error Check

Auditing Worksheets

  • Converting Data in range as a Table
  • Total the Data in Table
  • Removing Duplicates from Table
  • Using Sort and Filter