Microsoft Excel 2016 Intermediate

Exam Code : 727

Duration: 1 Day

Training Fee: RM 450.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 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 little or no 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.

Prerequisite

  • 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

Training Methods

Public Class Training

Private Class Training

In-House Class Training

Public Class Schedule
11 Jan 2018
22 Feb 2018
8 Mar 2018
5 Apr 2018
25 May 2018
14 Jun 2018
4 Jul 2018
9 Aug 2018
6 Sep 2018
5 Oct 2018
15 Nov 2018
4 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