Microsoft Excel 2021 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 formulas and functions, like:
  • AVERAGEA &AVERAGEIFS Function
  • SUMIF & SUMIFS Function
  • IF Functions
  • Nested Functions
  • Validate data in a Worksheet
  • Filter data using Auto & Advanced Filters
  • 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: Organize Dynamic Data Range with Table

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

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

Trainer Izham

 4.5

Izham has 14 years of teaching background with 4 years in the academic department of a public university followed by corporate clienteles in the later years. Since becoming a corporate trainer, Izham has been helping office workers all over cope with data and document volumes in digital form to become efficient and come out being smart office workers.

Trainer KK

 4.5

Cheah has more than 20 years’ experience in IT industry and 15 years in computer training. With his experience as Analyst Programmer in one of the manufacturing company in Singapore for 5 years, he has equipped with the knowledge and analytical skill to develop and handle different system. He also gain a lot of reputation from the customers for his quality training to not only shared his knowledge but also his experience with his student

  View more trainers

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

  • 63%
  • 33%
  • 4%
  • 0%
  • 0%
  • OA
    Ormiela Abbraham a/p Joseph Abraham
    Executive, Others

    5

  • YQ
    YIM FANG QIN
    Assistant Manager, Operations

    5

  • CP
    CHIA ZI PEI
    Junior Executive, Operations

    5

  • AE
    Asmahan binti Taufic Effandi
    Junior Executive, Project Management

    5

  • WC
    Wong Shu Chi
    Senior Manager, Administration / Secretarial

    5

    Patient trainer and easy to understand guide and material.
  • MH
    Mohd Fauzi Harun
    Assistant Manager, Manufacturing / Production

    5

    Good trainer, good info
  • Mr
    Mageswari raja
    Executive, Customer Service / Hospitality

    5

  • JV
    Jivitha A/P Venugopal
    Senior Executive, Customer Service / Hospitality

    5

    Excellent training
  • Nm
    Nor asrifah binti misran
    Senior Executive, HR / Learning and Development

    5

    Nice and good
  • NA
    NUR AFIQAH
    Assistant Manager, Operations

    5

  • SS
    Saadatul Salihah
    Executive, Manufacturing / Production

    5

  • MZ
    MUHAMMAD HAIQAL HIQMI BIN MOHD ZAMRI
    Junior Executive, Marketing / Design

    5

  • Ty
    Teo siang yen
    Senior Executive, Customer Service / Hospitality

    5

  • HO
    Hamizah Othman
    Senior Executive, Procurement / Purchasing

    5

  • LJ
    Lee Pooi Ji
    Executive, Marketing / Design

    5

    I enjoyed the training session. Thank you for coming and delivering such useful and engaging session. I like the exercise given after each new formula being teach. We have much better understanding.
  • MK
    Mohamad Amerul Akmal Bin Kamarulzaman
    Junior Executive, Operations

    5

  • NH
    Nurul Iffah Binti Fazrul Hilmy
    Assistant Manager, Administration / Secretarial

    5

  • SM
    Sabrina Mohd
    Senior Executive, Sales

    5

  • II
    Izura Idris
    Senior Executive, Accounting and Finance

    5

  • FA
    Fatin Azreen
    Director, Manufacturing / Production

    5

  • Nk
    Nurashikin bt karim
    Executive, Procurement / Purchasing

    5

  • MN
    Mohd Faridzul Aktar Bin Mohd Nadzri
    Director, Project Management

    5

    Great teaching
  • AS
    AHMAD FIKRI BIN AHMAD SUPIAN
    Manager / Supervisor, Manufacturing / Production

    5

  • FJ
    Fatin Aznim binti Mohd Al Johari
    Executive, Accounting and Finance

    5

  • Ka
    Khairul azeem
    Junior Executive, Accounting and Finance

    5

  • ss
    siti sazarina binti sajidin
    Executive, Accounting and Finance

    5

  • NB
    Nur Syahirah BINTI ABU BAKAR
    Executive, Administration / Secretarial

    5

  • RM
    Raja Muhammad Zahid Bin Raja Mafuzi
    Senior Executive, Sales

    5

  • Sa
    Shamirul bin azmi
    Executive, Facilities / Maintenance

    5

    Good for refreshers
  • WL
    WALTER LIM
    Manager / Supervisor, Marketing / Design

    5

  • MO
    Mohamad Aziq Bin Othman
    Executive, Engineering

    5

    Good understanding and knowledge
  • TM
    Thum Yok Mei
    Executive, HR / Learning and Development

    5

  • FJ
    FOONG LEONG JUN
    Assistant Manager, Procurement / Purchasing

    5

    No
  • TS
    Tan Sear Siean
    Executive, Procurement / Purchasing

    5

  • AW
    Annabel chan Mei Whei
    Senior Executive, Others

    5

  • Kc
    Khor Leng chean
    Senior Manager, Accounting and Finance

    5

  • TF
    Tan Ming Fong
    Executive, Procurement / Purchasing

    5

  • NL
    NG WEI LOON
    Junior Executive, Accounting and Finance

    5

  • LY
    LIM PEI YOONG(JENNY)
    Junior Executive, Accounting and Finance

    5

  • TC
    TAN CHAI CHII
    Executive, Customer Service / Hospitality

    5

  • GC
    GIAM WEE CHONG
    Executive, Customer Service / Hospitality

    5

  • CW
    Chong Hui Wen
    Junior Executive, Administration / Secretarial

    5

  • LH
    Lim See Hui
    Senior Executive, Marketing / Design

    5

  • TY
    TAN LEOK YEN
    Manager / Supervisor, Customer Service / Hospitality

    5

  • FW
    Frances chua Sam Woon
    Executive, Others

    5

  • TY
    TAN BAO YAN
    Executive, Marketing / Design

    5

  • KE
    Khoo Chee En
    Executive, Accounting and Finance

    5

  • IY
    Irene Puah Zheng Ying
    Executive, Others

    5

  • AS
    AIMI SHAZWANI BINTI MHD SHUKRI
    Executive, Administration / Secretarial

    5

    Excellent
  • TH
    Tan Peng Hang
    Senior Manager, Others

    5

  • PY
    PHANG TEE YOONG
    Senior Executive, Marketing / Design

    5

  • NI
    Nurul Ezzaty Binti Ibrahim
    Junior Executive, Others

    5

  • TS
    TAN MIN SHENG
    Executive, Others

    5

  • KV
    KALAIARASI A/P VIJAYAN
    Self-Employed, HR / Learning and Development

    5

  • LM
    LIM SIEW MUN
    Senior Executive, HR / Learning and Development

    5

  • WL
    Wildren Grospe Lobo
    Manager / Supervisor, HR / Learning and Development

    5

    all okay
  • LF
    LIEW KIM FOONG
    Manager / Supervisor, HR / Learning and Development

    5

  • SN
    Siti Hajar Binti Nordin
    Senior Executive, Operations

    5

  • FL
    Faradira Liyana
    Senior Executive, Operations

    5

  • CJ
    Catherine Goh Ee Jie
    Executive, Accounting and Finance

    5

  • AA
    AHMAD KAMAL DANIAL BIN AZMAN
    Senior Executive, Operations

    5

    Good session
  • Ly
    Leong che yin
    Junior Executive, Accounting and Finance

    5

  • MM
    Muhammad Noor Fahmi bin Mastor
    Senior Executive, Operations

    5

  • KC
    Kiong Khoon Ching
    Manager / Supervisor, Others

    4

  • Cc
    Chiow soo ching
    Senior Executive, Customer Service / Hospitality

    4

  • FZ
    Farrawahida Binti Zakaria
    Executive, Procurement / Purchasing

    4

  • RA
    RAJA NURUL NABILA BT RAJA ARIFF
    Junior Executive, Customer Service / Hospitality

    4

  • SF
    SITI NOOR FAZIRA
    Executive, Accounting and Finance

    4

  • SS
    Sim Poh Sean
    Executive, Marketing / Design

    4

  • SN
    SITI NAZIMATUL NADIA BINTI NAZIM
    Executive, Administration / Secretarial

    4

  • NZ
    Nurul Syahirah Binti Zaini
    Executive, Accounting and Finance

    4

  • ZY
    ZULAIKHA BINTI MOHD YUSOFF
    Assistant Manager, Engineering

    4

  • Th
    Tan chee hui
    Assistant Manager, Sales

    4

  • na
    nurani fadilah binti ahmad
    Junior Executive, Warehousing / Logistics

    4

  • IW
    Ivy Tan Su Wei
    Assistant Manager, Procurement / Purchasing

    4

  • TJ
    Tang Hou Jing
    Executive, Engineering

    4

  • TS
    TAN YEE SHUEN
    Junior Executive, Accounting and Finance

    4

    -
  • TC
    Tan Carey
    Junior Executive, Procurement / Purchasing

    4

    Good
  • TL
    Thaddea Teh Tze Ling
    Senior Executive, Others

    4

  • TX
    Tan Qiu Xian
    Executive, Others

    4

  • GS
    GAN KHAI SAND
    Senior Executive, Others

    4

  • Ky
    Koh Chen yean
    Senior Executive, Procurement / Purchasing

    4

    Very nice training, learn a lot of new function of excel which I never learnt before. Recommended !
  • LQ
    Lee Ang Qi
    Junior Executive, Accounting and Finance

    4

  • BK
    Boo Seng Khai
    Executive, Marketing / Design

    4

  • Y(
    YEAP SEOW KIT (BRYAN)
    Senior Executive, Others

    4

  • TK
    TEE BEE KIEU
    Senior Executive, Administration / Secretarial

    4

  • ay
    ang chee yong
    Junior Executive, Others

    4

  • K3
    Ke Woon 3
    Senior Executive, Accounting and Finance

    4

  • BL
    Boo Shea Li
    Assistant Manager, HR / Learning and Development

    4

  • TK
    TEH HOOI KHOON
    Senior Executive, Others

    4

  • CS
    CHIA FU SHAN
    Senior Executive, Procurement / Purchasing

    4

  • DL
    DANIAL ARIFF BIN ABDUL LATIF
    Junior Executive, Procurement / Purchasing

    4

    good training
  • NO
    Noraini binti Hj Omar
    Senior Executive, HR / Learning and Development

    4

  • HH
    Ho Jia Hui
    Junior Executive, Accounting and Finance

    4

  • AJ
    AMIRUL AFIF BIN JASMI
    Senior Executive, Sales

    4

  • LJ
    Lee Li Jing
    Junior Executive, Accounting and Finance

    4

  • TC
    Tan Siew Chin
    Executive, Administration / Secretarial

    3

  • LS
    Lian Chee Sim
    Executive, HR / Learning and Development

    3

  • M
    May
    Junior Executive, Sales

    3

  • TS
    Tan Joo Seng
    Executive, Others

    3

OF 10Next

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?