Microsoft Excel 2016 Basic

Exam Code : 727

Duration: 1 Day

Training Fee: RM 450.00

HRDF Claimable

About this course

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 Basic training, you will create and edit basic worksheets and workbooks. This course is designed for students who want to gain the necessary skills to create, edit, format, and print basic Microsoft Excel 2016 worksheets.

Audience Profile

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.

Course Content

The Basic

  • Getting Started
  • Signing In
  • Creating a New Workbook
  • Understand the Basic Parts of a Workbook
  • Saving a Workbook
  • Opening a Workbook


Your First Workbook

  • Selecting Data
  • Entering and Deleting Data
  • Using Undo and Redo
  • Using Cut, Copy, and Paste


Working with Data

  • Inserting Rows and Columns
  • Merging and Splitting Cells
  • Moving Cells
  • Using Paste Special
  • Using Find and Replace
  • Hiding and Unhiding Cells


Hiding and unhiding Cells

  • Using AutoFill
  • Using Flash Fill
  • Using AutoSum
  • Using AutoComplete
  • Using AutoCalculate


Formatting Texts

  • Changing the Font Face, Size, and Color
  • Applying Text Effects
  • Applying Borders and Fill
  • Using the Font Tab of the Format Cells Dialog
  • Clearing Formatting


Formatting Data

  • Wrapping Text
  • Changing the Size of Rows and Columns
  • Adjusting Cell Alignment
  • Changing Text Direction
  • Changing Number Format


Charting Data

  • Creating Sparklines
  • Inserting Charts


Viewing, Printing, and Sharing Your Workbook

  • Using Views
  • Saving a Workbook as PDF or XPS
  • Printing a Workbook


Customizing the Interface

  • Changing Ribbon Display Options
  • Customizing the Quick Access Toolbar
  • Hiding and Showing Ribbon Tabs
  • Creating Custom Ribbon Tabs
  • Resetting Interface Changes

Training Methods

Public Class Training

Private Class Training

In-House Class Training

Public Class Schedule
10 Jan 2020
6 Mar 2020
6 May 2020
2 Jul 2020
4 Sep 2020
13 Nov 2020

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