Microsoft Excel 2016 Intermediate

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

COURSE BENEFITS

ALL IN FROM ONLY

RM949/DAY

RRP RM2,500/DAY   SAVE RM1,551

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.6

  • 64%
  • 36%
  • 0%
  • 0%
  • 0%
  • Wy
    Wong meow yan
    Manager / Supervisor, Sales

    5

  • FK
    Fabian Koh
    Executive, Sales

    5

  • S
    Sham
    Executive, Marketing / Design

    5

  • TJ
    Tan Suo Jian
    Junior Executive, Sales

    5

  • GM
    Goh MovLee
    Executive, Administration / Secretarial

    5

  • RS
    Richard Foo Kai Seng
    Senior Executive, Operations

    5

    N/A
  • C
    Cheryl
    Senior Executive, HR / Learning and Development

    5

  • GH
    Gan Boon Hoo
    Executive, Sales

    4

  • EW
    Elaine Wong
    Manager / Supervisor, HR / Learning and Development

    4

    No comment
  • CY
    Cha Fui Yee
    Junior Executive, Accounting and Finance

    4

  • NJ
    Norashikin Janudin
    Executive, Sales

    4

OF 2Next

Courses you may like

MEMBERS ONLY FEATURE

Kindly sign-up or log-in to get access.

LOGIN

Login with your social account

or

Don’t have an account with us?

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?