Microsoft Excel 2021 Advanced

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

4.7

Course Objectives

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

  • Create Subtotal Using the Subtotal Function
  • Analyze data Using Pivot Tables
  • Perform What If Analysis using:
  • Goal Seek
  • Solver
  • Input Table
  • Scenarios
  • Use VLOOKUP function to extract data
  • Nesting INDEX and MATCH Function
  • Combining & Consolidating Data
  • Summarizing & Analyzing with Pivot Table and Pivot Charts
  • Record and Run a Macro

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 – Organize Summary and Details on Your Data

  • Module 2 – Planning, Forecasting & Projection of Your Data

  • Module 3 – Retrieve, Compare or Compiling Data with Functions

  • Module 4 – Present Data with Visual Report

  • Module 5 – Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts

  • Module 6 – Navigating Large Workbooks

  • Module 7 – Automate Task with Macros
  • Module 8 – Prevent User Changes with Protection

Get To Know The Trainer

Trainer Nazarudin

 4.5

Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.

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.

Rahul

 4.5

Rahul Thomas graduated in Bachelor of Information Technology majoring Computer Security and currently pursuing in Master of Information Technology majoring in Cybersecurity. He is an internationally certified trainer with successful years of experience in Cybersecurity, Cloud Computing and Microsoft Office. He is also recognized for his unconditional consistent in performance excellence and contributions to success in the Information Technology industry. Besides that, he also has a very enthusiastic personality when it comes to training, and he has been recognized for disseminating remarkable trainings.

Trainer Beatrice

 4.5

Beatrice has been in the training industry for the past 27 years being one of the pioneer trainers of Microsoft Office training programs. She has vast experience having trained many people from various corporate sectors. She is a certified Microsoft Office training consultant and is accredited by Pembangunan Sumber Manusia Berhad (PSMB/HRDC).

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

ALL IN FROM ONLY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

  • 77%
  • 20%
  • 3%
  • 0%
  • 0%
  • AH
    A Ramlan Hassan
    Manager / Supervisor, Operations

    5

    Ok
  • NZ
    Norzalina Zainuddin
    Manager / Supervisor, Engineering

    5

    Recommended
  • GP
    GUNALAN S PONNIAH
    Senior Manager, Procurement / Purchasing

    5

  • IH
    Intan Hassan
    Junior Executive, Others

    5

  • HB
    Haslina binti Abu Bakar
    Junior Executive, Others

    5

  • NN
    NURAINI BINTI MOHAMAD NOR
    Junior Executive, Others

    5

    I have a good session with Beatrice.. i get more knowledge that can use to improve my task at office..
  • MR
    MOHAMAD NUR AZRI RAZALI
    Executive, Procurement / Purchasing

    5

  • AA
    Adibah Binti Azlan
    Junior Executive, Accounting and Finance

    5

  • AJ
    AMIR IKHWAN BIN JAZLAN
    Junior Executive, Operations

    5

    Terbaik
  • MS
    MUHAMMAD ZAHIN BIN SHARIPUDIN
    Junior Executive, Operations

    5

  • NK
    Nor Farikha Mohd Khairoji
    Senior Executive, Others

    5

  • Mb
    Mohd fairus rashid bin mohammad bahar
    Manager / Supervisor, Operations

    5

  • MR
    Mohd Redza Bin Mohd Radzuan
    Executive, Operations

    5

  • BS
    Brinthawani A/P K Subramaniam
    Senior Executive, Operations

    5

  • CY
    Cornelius Yong
    Senior Executive, Sales

    5

  • SY
    Soo Kian Yie
    Executive, Sales

    5

    Good
  • Os
    Ong ling sing
    Senior Executive, Sales

    5

  • SR
    Suguna Ramasamy
    Manager / Supervisor, Operations

    5

  • IN
    ISAAC PHILIP NGO
    Assistant Manager, Accounting and Finance

    5

    N/A
  • Gh
    Gabriel Gan Chong hoe
    Manager / Supervisor, Sales

    5

  • AA
    ANAS BIN AMIL
    Junior Executive, Customer Service / Hospitality

    5

    All is good, content is nice and easy to follow
  • SF
    Simon Yong Mun Foo
    Senior Executive, Sales

    5

    Simple and easy
  • LN
    Leong Su Ni
    Manager / Supervisor, Marketing / Design

    5

  • NR
    NUR TANIA BINTI REEKIFILEE
    Assistant Manager, HR / Learning and Development

    5

    Understandable
  • Nn
    Nur asyeela mohd noh
    Manager / Supervisor, IT Management

    5

  • SN
    Syaza Najihah
    Assistant Manager, Accounting and Finance

    5

  • MR
    MOHAMAD AMIN BIN REDZUAN
    Executive, IT Management

    5

    Great learning experience
  • RM
    Rahah Binti Mokhtar
    Manager / Supervisor, IT Management

    5

  • NK
    Nur Aqilah binti Kassim
    Senior Manager, Facilities / Maintenance

    5

  • AK
    Aiman Faez bin Mohd Khazani
    Executive, Procurement / Purchasing

    5

    Satisfied with knowledge sharing by the trainer.
  • FZ
    FATIN SYAZWANI BINTI ZAFRULLAH
    Executive, Others

    5

  • SD
    Safinazline Ahmad Dzarawi
    Junior Executive, HR / Learning and Development

    5

  • MA
    Mohd Zamri bin Alias
    Senior Manager, Project Management

    5

    Great course to attend
  • MY
    Muhammad Nur Imran Bin Md Yusri
    Executive, Procurement / Purchasing

    5

    Well experiences trainer
  • NS
    Nazrul Amree Bin Abd Shahid
    Manager / Supervisor, Others

    5

  • AM
    Ahmad Rashaad bin Muhammad
    Senior Manager, Accounting and Finance

    5

  • IO
    IVY FARADINA BINTI OMAR
    Junior Executive, Operations

    5

  • AR
    Aina Sofea Binti Mohamad Razali
    Executive, HR / Learning and Development

    5

  • NZ
    NURSAZILA BINTI ZAINAL
    Manager / Supervisor, HR / Learning and Development

    5

  • WY
    Wan Muhamad Fakhri bin Wan Yusoff
    Junior Executive, Facilities / Maintenance

    5

  • YA
    YASMIN BINTI ZAINOL ABIDIN
    Senior Executive, Others

    5

  • AS
    AIWAN AERFAH BT NOOR SAHARIF @ SHARIF
    Junior Executive, Facilities / Maintenance

    5

  • HA
    Hannie Amalina
    Junior Executive, Administration / Secretarial

    5

  • AC
    Alfred M. Carpio
    Executive, Quality Assurance

    5

    Mr. Rahul is a good trainer and be patience. Very easy to communicate.
  • WM
    WAN AINOL ARIFFIN BIN WAN MUDA
    Executive, Facilities / Maintenance

    5

  • SR
    SAHRULERMAN BIN ABD. RAHIM
    Junior Executive, Quality Assurance

    5

    Mr. Rahul is very good in teaching about Excel
  • NY
    Nur Lina binti Muhd Yusof
    Junior Executive, Quality Assurance

    5

    Mr Rahul is very good in teaching us about excel.
  • KS
    KAMILAH BINTI MOHD SAID
    Senior Executive, Quality Assurance

    5

  • RJ
    Ravi Chandran A/L Jeyacelan
    Manager / Supervisor, Others

    5

    Gain Great Knowledge… Must Attend…
  • So
    Siti nadirah binti othman
    Executive, Quality Assurance

    5

    Great
  • NN
    Nurhanisah binti Nazarali
    Senior Executive, Manufacturing / Production

    5

  • Ce
    Chiong chung eng
    Senior Manager, Others

    5

  • PA
    Prakash Muniela Athan
    Executive, Marketing / Design

    5

  • NZ
    Nge Zhuo Zhen
    Executive, Marketing / Design

    5

  • NR
    Norfatiha Bt Rosley
    Junior Executive, Warehousing / Logistics

    5

  • ZA
    ZAIRIE BIN ALIAS
    Senior Manager, Quality Assurance

    5

  • CN
    Chang Sze Ning
    Executive, Others

    5

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

    5

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

    5

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

    5

  • JL
    Joshua Aloysius Choo Jin Liang
    Executive, Others

    5

  • Aa
    Anies syaqiera binti abdul aziz
    Junior Executive, Quality Assurance

    5

  • PR
    PRITHINI RAMU
    Executive, Marketing / Design

    5

  • S
    Shamira
    Junior Executive, Engineering

    5

  • AA
    Ain Najwa Binti Adnan
    Executive, Others

    5

  • GT
    GOO WEN TIAN
    Assistant Manager, HR / Learning and Development

    5

  • OC
    ONG CHUN CHYN
    Executive, Accounting and Finance

    5

  • mz
    muhammad sadruddin bin zawawi
    Executive, Manufacturing / Production

    5

  • Ck
    Chuah kok keng
    Senior Executive, Procurement / Purchasing

    5

  • TJ
    Tan Gee Jien
    Senior Executive, Administration / Secretarial

    5

  • S
    Sharon
    Executive, Accounting and Finance

    5

    All good
  • LH
    Lee Chee Hooi
    Senior Executive, Accounting and Finance

    5

  • MZ
    Mohd Fikhrie bin Zakaria
    Executive, Engineering

    5

  • LH
    Lau Hong Hao
    Executive, Others

    5

  • MH
    Mohd Fakhrul Radzi Bin Hamzah
    Executive, Operations

    4

  • NK
    Noriah bt Khairudun
    Junior Executive, Facilities / Maintenance

    4

  • MR
    Muhd Hafizanulukman bin Razali
    Junior Executive, Operations

    4

  • NH
    Noor Aizawati Binti Hassanuddin
    Assistant Manager, Others

    4

    -
  • DF
    Dianafadilah Binti Mohamad Fadzil
    Junior Executive, Others

    4

    Recommended
  • KD
    Kamariah Daut
    Junior Executive, Others

    4

    Recommended
  • NN
    Nurdini binti Nordin
    Senior Executive, Others

    4

    Usefull training help to apply in my current job scope and needed
  • RY
    Rachel Boon Wing You
    Executive, Sales

    4

  • DT
    Daniel Teoh
    Manager / Supervisor, Marketing / Design

    4

  • LM
    LEE SIAU MEI
    Senior Executive, Sales

    4

  • RJ
    Roselilawani Jusoh
    Senior Executive, Operations

    4

  • GG
    GERALD SELVAKUMAR GEORGE
    Senior Executive, Procurement / Purchasing

    4

    Good
  • GG
    Gan Shiaw Hui @ Gareen Gan
    Manager / Supervisor, Accounting and Finance

    4

  • WG
    WAN MOHD SHAHARIL BIN WAN MOHD GHAZALI
    Executive, Manufacturing / Production

    4

  • FK
    FONG CHIN KONG
    Senior Manager, Marketing / Design

    4

  • Y(
    Yew Pei Jia (Peggy)
    Senior Executive, Accounting and Finance

    4

  • ST
    Seow Yi Teng
    Manager / Supervisor, HR / Learning and Development

    4

  • St
    Sophia thian
    Manager / Supervisor, HR / Learning and Development

    4

  • L(
    Lau Yuke Huan (Emmy)
    Senior Executive, Accounting and Finance

    4

  • AL
    Agnes Ng Siew Lin
    Senior Executive, Sales

    3

  • TT
    TANTI BINTI TUKIMAN
    Junior Executive, Operations

    3

  • NA
    Nuramira Azman
    Executive, Marketing / Design

    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?