Menu
PREMIUM COURSE

Microsoft Excel 2016 Foundation

0

Course Objectives

  • Give participant a systematic understanding of a spreadsheet ad its benefits
  • Equip participant with essential skills of effectively utilizing spreadsheet software in a day-to-day
    business environment
  • Navigate Excel Interface, Create a New Workbook Template
  • Adjust column width and row height
  • Use and understand basic formulas
  • Use and understand basic functions
  • Perform Spell check
  • Use the Find and Replace command
  • Apply Border & Formatting, Number format
  • Header Footer, Set page orientation
  • Print a spreadsheet
  • Apply print tiles on spreadsheet
  • Use the freeze pane to lock database title

Target Audience

REQUIRED PREREQUISITES:

Basic knowledge of Windows is essential with the following pre-requisites:

  • Able to maneuver with the mouse – Point, Click, Drag and Double Click
  • Able to configure the desktop
  • Able to use the Control Panel
  • Able to move and re-size Application Windows
  • Able to switch between task applications
This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels;
and personnel who already know and understand and want to further enhance their knowledge and practical
uses of Microsoft Excel.

Methodology

This program will be conducted with interactive lectures, PowerPoint presentation, discussions and practical exercise.

Course Modules

  • Module 1 – Getting Started with Microsoft Excel 2016
    Topic A: Identify the Elements of the Excel Interface Microsoft Excel 2016
    Topic B: Create a Basic Worksheet
  • Module 2 – Performing Calculations
    Topic A: Create Formulas in a Worksheet
    Topic B: Insert Functions in a Worksheet
  • Module 3: Modifying a Worksheet
    Topic A Manipulate Data
    Topic B: Insert, Manipulate, and Delete Cells, Columns, and Rows
    Topic C: Search For and Replace Data
  • Module 4: Formatting a Worksheet
    Topic A: Modify Fonts
    Topic B: Add Borders and Colors to cells
    Topic C: Apply Number Formats
    Topic D: Align Cell Contents
    Topic E: Apply Cell Styles
  • Module 5: Printing Workbook Contents
    Topic A: Define the Basic Page Layout for a workbook
    Topic B: Refine the Page Layout and Apply Print Options
  • Module 6: Managing Large Workbooks
    Topic A: Format Worksheet Tabs
    Topic B: Manage Worksheets
    Topic C: Manage the View of Worksheet and Workbooks

Get To Know The Trainer

Private Profile

 

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 1 or 2 Days of training
  • E-Certificate of Completion
  • E-Training manual
  • Trainer logistic to client's place

COURSE BENEFITS

  • 1 or 20 pax, same price
  • Confirmed-to-run even for 1 pax
  • Cheapest available (*we will price match!)
  • Money-Back-Guaranteed Quality
  • HRDF Certified & Claimable

ALL IN FROM ONLY

RM1,100/DAY

RRP RM2,500/DAY   SAVE RM1,400

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

What Other People Bought

LOGIN

Login with your social account

or

Don’t have an account with us?

Edit Profile

FREE FOR LIFE

Sign Up to Bookmark your Favourite Course
or Request for a Quotation instantly

Sign in with your social account

or

By signing up, you agree to our Terms of Use and Privacy Policy

Have an account with us already?