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 2018
21 Feb 2018
7 Mar 2018
4 Apr 2018
3 May 2018
6 Jun 2018
2 Jul 2018
8 Aug 2018
5 Sep 2018
4 Oct 2018
14 Nov 2018
3 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