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 Jarina

 4.5

Managing and maintaining a Microsoft Windows Server 2003 Environment - educate the IT professionals who implement, manage, and troubleshoot existing network and system environments based on the Windows Server 2003 platform. Implementation responsibilities include installing and configuring parts of systems. Management responsibilities include administering and supporting systems

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

4.6

  • 65%
  • 35%
  • 0%
  • 0%
  • 0%
  • MS
    Monique sylvester a/p Sathiasegaran
    Senior Executive, Customer Service / Hospitality

    5

  • DY
    Daniel Teoh Chun Yang
    Senior Executive, Marketing / Design

    5

  • KM
    Kirija a/p Munthry
    Manager / Supervisor, Customer Service / Hospitality

    5

  • MS
    Magdelin Tan Mei Sim
    Manager / Supervisor, Marketing / Design

    5

  • EM
    Elakheya a/p Murugan
    Senior Executive, Customer Service / Hospitality

    5

    Na
  • YH
    YEOH SEOW HOOI
    Manager / Supervisor, Marketing / Design

    5

  • FH
    Fidza Hamdan
    Manager / Supervisor, Marketing / Design

    5

  • CJ
    Chang Wen Jinn
    Manager / Supervisor, Operations

    5

  • AJ
    Ashwin Jeyapalasingam
    C-Level, Operations

    5

  • TR
    Thaneswary a/p Thanka Rajoo
    Senior Executive, Customer Service / Hospitality

    5

  • CM
    Chan Sam Mun
    Manager / Supervisor, Marketing / Design

    5

  • RL
    Robin Chan Chun Loong
    Senior Executive, Marketing / Design

    4

  • VY
    Vida Lim Hung Yee
    Manager / Supervisor, Marketing / Design

    4

  • KL
    Karen Kum Li Lin
    Manager / Supervisor, Operations

    4

  • TG
    Tan Seok Geok
    Manager / Supervisor, Marketing / Design

    4

  • AT
    Adrian Chow Yuk Ting
    Senior Manager, Operations

    4

  • LW
    Lew Chi Wei
    Manager / Supervisor, Marketing / Design

    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?