EX19I(1) Microsoft Excel Intermediate

All versions available. Outline version below is Microsoft Excel 2019. If you need assistance just chat with us LIVE.

Course Objectives

Upon completion of this program, participants should be able to:

    • Create simple to complex formulas and functions, like:
    • COUNTA & COUNTIFS Function
    • AVERAGEA &AVERAGEIFS Function
    • SUMIF & SUMIFS Function
    • IF Functions
    • Filter data using Auto & Advanced Filters
    • Clean Duplicate Records
    • Visualizing Data as a Graphics

Target Audience

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, discussion and practical exercise.

Course Modules

Module 1:  Referencing Calculations

Module 2: Working with Functions

Module 3: Organizing Dynamic Data Range with Tables

Module 4: Data Visualization

Get To Know The Trainer

Trainer P.L

 4.5

She is an expert on Microsoft Applications, Publisher (Version 2000, XP, 2003 & 2007, VBA, Introduction To Internet, Multimedia Fundamentals, IT Skills For Non-PC Users, Basic IT skills and related programs. In her previous company, she was responsible for developing training courseware and customizing training curriculum.

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE BENEFITS

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

5

  • 100%
  • 0%
  • 0%
  • 0%
  • 0%
  • LY
    Lim Sook Yee
    Manager / Supervisor, Accounting and Finance

    5

  • AH
    Azianni Binti Husain
    Junior Executive, HR / Learning and Development

    5

  • SM
    SITI NORFATIN NAJWA BINTI MAHZIE
    Junior Executive, HR / Learning and Development

    5

  • FF
    Fatin Fadzliana Binti Mohd Faizal
    Junior Executive, HR / Learning and Development

    5

  • KW
    Khor Khar Wei
    Executive, Administration / Secretarial

    5

  • LY
    Low Huey Yen
    Junior Executive, HR / Learning and Development

    5

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?