Menu
Menu
PREMIUM COURSE

Microsoft Excel 2016 Intermediate

0

Course Objectives

  • Create simple to complex formulas and functions like:
    1. Database Function
    2. COUNTIF Function
    3. COUNTIFS Function
    4. AVERAGEIF Function
    5. AVERAGEIFS Function
    6. SUMIF Function
    7. SUMIFS Function
    8. IF Function
    9. AND Function
    10. VLOOKUP Function
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filter
  • Create Chart
  • Clean Duplicate Records
  • Apply Conditional Formatting-

Target Audience

REQUIRED PREREQUISITES:

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

Have attended Microsoft Excel – Foundation Level; OR

  • Able to switch between task applications
  • Able to create a spreadsheet with simple formatting
  • Able to create a basic chart
  • Able to print a spreadsheet with headers and footers added
  • Able to apply Freeze Pane command
  • Able to create basic formulas – Addition, Subtraction, Multiplication and Division
  • Able to use basic functions – AutoSum, Count, Max, Min and Average functions.
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 – Performing Calculations
    Topic A: Reuse Formulas
  • Module 2 – Creating Advanced Formulas
    Topic A: Apply Range Names
    Topic B: Use Specialized Functions
  • Module 3 – Organizing Worksheet Data with Tables
    Topic A: Create and Modify Tables
    Topic B: Sort and Filter Data
    Topic C: Use Subtotal and Database Functions to Calculate Data
    Topic D: Validating your Data
  • Module 4 – Working with Statistical, Mathematical, Logical and Lookup Functions
    Topic A: Statistical Functions
    Topic B: Mathematical Function
    Topic C: Use Logical Functions
    Topic D: Use Lookup Functions
  • Module 5 – Visualizing Data with Charts
    Topic A: Create Charts
    Topic B: Modify and Format Charts
    Topic C: Sparkline
  • Module 6 – Showing Data as Graphic Lesson
    Topic A: Conditional Formatting  
  • Module 7 – Finalize Workbook
    Topic A: Worksheet and Workbook Protection
    Topic B: Managing Multiple Windows

Get To Know The Trainer

Private Profile

 

Chat with us LIVE to get a

FREE QUOTATION!

COURSE INCLUDES

  • 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?