Microsoft Excel Intermediate 2010

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

4.5

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
  • Nested Functions
  • Database Function
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • Advanced Chart Formatting
  • Clean Duplicate Records
  • Visualizing Data as a Graphics

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; 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

  • Module 2 – CREATING ADVANCED FORMULAS

  • Module 3 – WORKING WITH FUNCTIONS

  • Module 4 – ORGANIZING WORKSHEET DATA WITH TABLES

  • Module 5 – VISUALIZING DATA AS A GRAPHICS

  • Module 6 – MANAGING VIEWS

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 INCLUDE

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.5

  • 57%
  • 35%
  • 8%
  • 0%
  • 0%
  • LY
    Lee Liang Yi
    Manager / Supervisor, Administration / Secretarial

    5

  • HN
    Ho Li Ngin
    Senior Executive, Administration / Secretarial

    5

  • TG
    Ting Ai Gee
    Senior Executive, Sales

    5

  • LL
    LOO PUI LIM
    Executive, Accounting and Finance

    5

  • Sk
    Sathia kumaran
    Executive, Sales

    5

  • CY
    Cheah Mei Ying
    Executive, Procurement / Purchasing

    5

  • NB
    Nur Basirah Zaidah binti Bahari
    Executive, HR / Learning and Development

    5

  • TL
    TAN KENG LEE
    Junior Executive, IT Management

    5

  • NN
    NGA BAO NIAN
    Executive, Others

    5

  • MR
    MUHAMMAD AIZAT NABIL B RAHMAD
    Executive, Operations

    5

  • LW
    Lee Jie Wey
    Senior Executive, Others

    5

  • YC
    YIP KAH CHUN
    Executive, Accounting and Finance

    5

  • AR
    Ari Saw Yong Ren
    Senior Executive, Accounting and Finance

    5

  • Ks
    Khoo yit sean
    Executive, Accounting and Finance

    5

  • AY
    Ang Sea Yen
    Executive, Procurement / Purchasing

    5

  • SA
    Siti Sarah binti Azman
    Executive, Operations

    5

  • Na
    Nabihah binti azhar
    Senior Executive, HR / Learning and Development

    5

  • FH
    Farah Aisyah binti Muhammad Hatta
    Executive, Administration / Secretarial

    5

    Easy to understand and very detailed!
  • NN
    NORAFIDAH NASARUDDIN
    Executive, Administration / Secretarial

    5

  • yk
    yap kwai kwan
    Executive, Administration / Secretarial

    5

    The course is great, gain new skill and knowledge, friendly speaker
  • TK
    TAN VIN KAY
    Executive, Accounting and Finance

    5

  • SA
    Shaheera Nabila Binti Anuar
    Executive, Others

    5

  • SJ
    SIA WOEI JINQ
    Senior Executive, Accounting and Finance

    5

  • CY
    Chan Weng Yin
    Junior Executive, Others

    5

  • HM
    Ho Sher Mein
    Executive, Others

    5

  • WY
    Wong Chin Yap
    Executive, Others

    5

  • YY
    Yong Xin Yi
    Executive, Marketing / Design

    5

    Pauline is a good trainer! Well explanation during the class!
  • FN
    Fiona Lim Yun Ni
    Executive, Administration / Secretarial

    5

  • WL
    Wan Nur Laila
    Executive, Accounting and Finance

    5

  • DS
    Doris Soh
    Senior Executive, HR / Learning and Development

    4

  • CT
    Chin Yun Tong
    Junior Executive, Others

    4

    Good
  • NC
    NG LI CHING
    Senior Executive, Sales

    4

    Knowledgeable trainer and easy to understand.
  • H
    Hemawathi
    Executive, Sales

    4

  • LY
    Lee Liang Yi
    Manager / Supervisor, Administration / Secretarial

    4

  • GP
    Ging Kok Ping
    Executive, Accounting and Finance

    4

  • WY
    WEI SOO YIN
    Junior Executive, Accounting and Finance

    4

  • LP
    Leong Yan Ping
    Executive, Others

    4

  • LX
    Law Jun Xian
    Senior Executive, Accounting and Finance

    4

  • TJ
    TAY PEI JUN
    Executive, Accounting and Finance

    4

  • TE
    Tan Eugene
    Executive, Others

    4

  • Cj
    Chong man jin
    Junior Executive, Accounting and Finance

    4

  • MT
    Mah Yu Ting
    Executive, Accounting and Finance

    4

  • CT
    Cheah Lok Theng
    Executive, Accounting and Finance

    4

  • DZ
    Desmond Loy Shao Zhen
    Executive, Marketing / Design

    4

  • WK
    Wong Hew Kei
    Executive, Procurement / Purchasing

    4

  • TR
    Tan Xiao Rou
    Junior Executive, Marketing / Design

    4

  • SE
    Soo Eva
    Executive, Procurement / Purchasing

    4

  • jl
    john koon tzer lim
    Assistant Manager, Operations

    3

  • TY
    Tee Yee Ying
    Executive, Others

    3

  • YL
    Yap Han Lin
    Executive, Corporate Communications

    3

  • SS
    Soo Jing Shin
    Executive, Marketing / Design

    3

OF 6Next

Courses you may like

Optimized by Optimole

MEMBERS ONLY FEATURE

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

LOGIN

[nextend_social_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

[nextend_social_login]

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?