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 Azrul

 

Azrulnizam Ahmad has been working in the business industry since 2004 and has been exposed to all the common challenges faced by business personnel. With his years of experience working with business and management, IT services and end users, he understands the importance of business value, infrastructure efficiency and user productivity.He shares his training passion in Microsoft Office 2007 Application - Excel, PowerPoint, and Word; Microsoft Office 2010 Application - Excel, PowerPoint, and Word and also emphasizes on the criticality of this aspect in any implementation

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.8

  • 83%
  • 10%
  • 7%
  • 0%
  • 0%
  • NL
    NORAMIRA SYAHADAH LIM
    Assistant Manager, Operations

    5

  • NK
    Nur Azyyati binti Abdul Kadir
    Manager / Supervisor, Operations

    5

  • NM
    Noor Azah Mokhtar
    Senior Manager, HR / Learning and Development

    5

    -
  • ld
    lily anak dian
    Senior Manager, Operations

    5

    good 👍 service
  • NH
    NUR HAYATI BINTI HAMIM
    Assistant Manager, Operations

    5

  • SZ
    Syahiirah Binti Zulkifli
    Executive, Operations

    5

    Good
  • NJ
    Nurul Basyirah Binti Mohd Jasrila
    Manager / Supervisor, Operations

    5

  • NE
    Nurul Emera
    Manager / Supervisor, Operations

    5

    Overall is good
  • SA
    Siti Aisyah Binti Ahmad
    Assistant Manager, Operations

    5

  • SS
    SA'ADAH FATIMAH BT SURANI
    Assistant Manager, Operations

    5

  • Uk
    Ummi kulsum
    Executive, Operations

    5

  • Na
    Nik nur hannah bt nik azlan
    Executive, Operations

    5

  • NA
    NIK IDA MAHIRAH BINTI NIK ANUAR
    Executive, Administration / Secretarial

    5

  • NN
    NUR FARAH AIN NATASHA BINTI NICOLAS
    Junior Executive, Accounting and Finance

    5

  • Na
    Nur syafiqka amira binti ambri
    Assistant Manager, Operations

    5

  • SB
    Siti Nuraqilah Binti Baharuddin
    Executive, Administration / Secretarial

    5

  • NN
    NUR FARAH AIN NATASHA BINTI NICOLAS
    Junior Executive, Accounting and Finance

    5

  • TM
    Tengku Masitah binti Tengku Mazlan
    Junior Executive, Administration / Secretarial

    5

  • SR
    Syahirah Amira Binti Roslan
    Executive, HR / Learning and Development

    5

  • MI
    Mohd NoorJamil Mohd Ishak
    Executive, Project Management

    5

  • SS
    SHATILA BINTI CHE SAAD
    Senior Executive, Operations

    5

    Nil
  • MK
    Muhammad Faisal Kamaruddin
    Senior Executive, Operations

    5

    Good training
  • NN
    NURDINIE NABIHAH BINTI NORYAMAL
    Executive, Operations

    5

    Good explanation & engagement from trainer
  • NK
    Nadratun Na'im Binti Kamarudin
    Manager / Supervisor, Others

    5

    Ok
  • IF
    Irdina Sofea Binti Fadil
    Junior Executive, Others

    4

    -
  • TO
    Tuan Noor Hasini Binti Tuan Omar
    Assistant Manager, Others

    4

  • RH
    Redzuan Bin Hamdan
    Executive, Administration / Secretarial

    4

  • YK
    Yap Mei Kuen
    Executive, Administration / Secretarial

    3

  • NT
    Nur Ameerah binti Che Ahmad Tantowi
    Executive, Others

    3

    Ok
OF 3Next

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?