Microsoft Excel 2021 Intermediate

All versions available. Outline version below is Microsoft Excel 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 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
  • 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

Topic A: Formula Reference

  • Relative References
  • Absolute References
  • Mixed References

Topic B: Apply Range Names

  • Adding a Range Names Using the Name Box
  • Adding a Range Names Using Define Name
  • Adding multiple names using Create from Selection
  • Editing and Deleting Range Name Using Name Manager
  • Using Range Names in Formulas

Module 2: Working with Functions

Topic A: Data Summary with Function

  • COUNTA
  • AVERAGEA

Topic B: Conditional Data Summary 1

  • COUNTIF / COUNTIFS
  • AVERAGEIF / AVERAGEIFS
  • SUMIF / SUMIFS
  • MAXIF
  • MINIF

Topic C: Conditional Data Extraction

  • IFERROR
  • IF
  • IFS & Nested IF

Topic D: Conditional Data Summary 2

  • DSUM
  • DCOUNT / DCOUNTA
  • DAVERAGE
  • DMAX
  • DMIN

Module 3: Organize Dynamic Data Range with Table

Topic A: Create and Modify Tables

  • Create table
  • Table Styles and Options
  • Removing Duplicate Values
  • Total Row with SubTotal Functions
  • Rename table
  • Convert table to range

Topic B: Data Validation

  • Data Validation Using Lists
  • Data Validation Using Whole Number / Decimal
  • Data Validation Using Date

Topic C: Sort and Filter Data

  • Sorting Data by value
  • Sorting data by color
  • Filtering Data
  • Advanced Filtering

Module 4: Data Visualization

Topic A: Conditional Formatting

  • Highlight Cell Rules
  • Data Bars
  • Icon Sets
  • Creating New Rules with Formula

Topic B: Create Charts

  • Chart Insertion Methods
  • Resizing and Moving the Chart
  • Adding Additional Data
  • Switching Between Rows and Columns

Topic C: Modify and Format Charts

  • Formatting the Chart with a Style
  • Chart Elements
  • Title
  • Axis
  • Legend
  • Data Label
  • Data Table

Topic D: Adding Sparklines

  • Adding Sparklines
  • Removing Sparklines

Topic E: Editing Sparklines

  • Showing and Hiding Data
  • Changing the Style
  • Changing the Sparkline and Marker Color
  • Setting Axis Options

Module 5: Setting Up Reports as Pages

Topic A: Working with Different Views

  • Using Page Break Preview for Page Setup
  • Using Page Layout View for Express Header & Footer
  • Using Custom view

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

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 Slyvia

 

Sylvia has been in the IT Training Industry for the past 20 years She began her career as a Corporate Trainer and her personal areas of expertise are wide; encompassing Microsoft and Adobe applications. In addition to that; she also specializes in corporate coaching for government, multi-national companies to local SMEs

Trainer Patrick

 

Patrick Cheah has been involved in the IT and Training industry since 2002. He is very passionate about sharing knowledge and providing technical solutions. A Microsoft Certified Trainer and a member of the Toastmasters International, he has conducted trainings since 2005 to clients from various sectors. Patrick is also involved in writing and publishing online articles, promotional write-ups and event reports in several web portals.

Trainer CK

 4.5

CK has been involved in Microsoft Office Consulting for more than 15 years with the intention of helping friends and working adults to reach their full capability which in return will increase their work productivity. Throughout his many years of working experience using Microsoft Office Applications, he participated with various projects involving Engineering Data Analysis, A Complete System for Employees such as Leave Application, Petty Cash Claim, Arranging Schedule and so on with Programming using VBA Programming.

  View more trainers

Chat with us LIVE to get a

FREE QUOTATION!

THIS PUBLIC COURSE INCLUDES

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

  • 79%
  • 17%
  • 4%
  • 0%
  • 0%
  • AI
    Aina Fariha binti Mohamad Izzat
    Junior Executive, Facilities / Maintenance

    5

  • GP
    Gunalan S Ponniah
    Senior Manager, Procurement / Purchasing

    5

  • MA
    Muhammad Zulfahmi Bin Mohammed Alam
    Executive, Operations

    5

    A lot of function that i did not know before, right now it will easier my task.
  • NK
    Nurhamizah Kamaruzaman
    Junior Executive, Others

    5

  • NZ
    Norzalina Zainuddin
    Manager / Supervisor, Engineering

    5

    Very good
  • MK
    Mohamad Bin A Mohd Kasim
    Executive, Accounting and Finance

    5

  • AH
    Abdul Rahman Ismail @ Hussain
    Manager / Supervisor, Accounting and Finance

    5

    Recomended
  • MR
    Maizurah Abdul Razak
    Executive, Engineering

    5

    Fun & engaging course
  • NA
    Nurul Syaqinadirah binti Azizi
    Executive, HR / Learning and Development

    5

  • HA
    Hannie Amalina
    Junior Executive, Administration / Secretarial

    5

  • NH
    Nur Farah Aainaa Hamidon
    Executive, Engineering

    5

  • C
    Charlotte
    Manager / Supervisor, Others

    5

    Very clear and careful instructor, as any learner may know ... In excel, you missed one step, you probably lost and can hardly continue. The trainer is helpful and the course really an eye-opener to the what Excel could do. I wish I could master Excel, coz' it is a useful and powerful tool that all of us need in analysing & presenting data.
  • MI
    Muhammad Yazid bin Mohamad Isa
    Junior Executive, Accounting and Finance

    5

    Excellent trainer and highly recommended company for Excel training. Thank you!
  • NR
    Nur Khairiyah Binti Abdul Rahman
    Executive, Others

    5

  • AR
    Afifah Md Radzi
    Executive, Others

    5

  • ND
    Nor Rafidah binti Duaji
    Assistant Manager, HR / Learning and Development

    5

    Attended Microsoft Intermediate and Advance. The organiser provided a great trainer- Mr. CK for this training. It was such a great session, I learnt so much!
  • AM
    ABDULLAH BIN MAHMOOD
    Junior Executive, Facilities / Maintenance

    5

  • NO
    Norasnida Binti Osmarani
    Junior Executive, Administration / Secretarial

    5

  • SJ
    Sabrina Joseph
    Senior Executive, Customer Service / Hospitality

    5

    Trainer CK is very experienced and an awesome trainer.
  • LO
    Lailatulmunira Binti Omar
    Senior Executive, Others

    5

    Very good session with highly integrative session
  • Na
    Nur aznirah binti ahmad azreen
    Junior Executive, Others

    5

  • Zw
    Zahira wahab
    Executive, Administration / Secretarial

    5

  • MY
    MOHAMMAD RETHWAN BIN MOHF YASIN
    Junior Executive, HR / Learning and Development

    5

  • ku
    kharulfadly ujang
    Senior Executive, Procurement / Purchasing

    5

  • MK
    Muhammad Aizuddin Kamaruszaman
    Senior Executive, Engineering

    5

  • ku
    kharul fadly ujang
    Senior Executive, Procurement / Purchasing

    5

  • Nr
    Nurul shafina binti ramli
    Executive, Engineering

    5

    Great knowledge.
  • ZZ
    Zunaiddy Mohamed Zin
    Junior Executive, Engineering

    5

  • ND
    Nor Rafidah binti Duaji
    Assistant Manager, HR / Learning and Development

    5

  • HH
    Haswani Athirah Binti Hussein
    Junior Executive, Others

    5

  • SR
    Siti Rosidah Binti Ramli
    Junior Executive, Others

    5

  • NY
    Ngee Fei Yang
    Junior Executive, Accounting and Finance

    5

  • TY
    Tuan Nor Asiah BT Tuan Yahya
    C-Level, Administration / Secretarial

    5

  • SN
    SHAHRUL NAZHA BIN NAJMI
    Assistant Manager, Procurement / Purchasing

    5

  • NH
    NORHAYATI BINTI HUSSIN
    Junior Executive, Facilities / Maintenance

    5

  • AY
    Aisyah binti Moosah Al-Mustafa Yoshikatsu
    Junior Executive, Engineering

    5

    Recommended
  • RM
    Rahah Binti Mokhtar
    Manager / Supervisor, IT Management

    5

    The training is really beneficial for me where it enhances my knowledge in using excel and can use it for my project management. Beatrice is a really good trainer and does exlains it clearly.
  • AS
    Amira Syaheerah binti Shaidin
    Junior Executive, Engineering

    5

    Very clear explaination by the trainer. Our trainer is very helpful
  • NA
    NURFARIZA BINTI AZNAN
    Junior Executive, Engineering

    5

  • RA
    RADEN YUSNAIDI ADIPUTRA BIN ALIAS
    Manager / Supervisor, HR / Learning and Development

    5

    Cool and fun. Method of teaching with the zoom in and zoom out is the best as we can really see and learn things effectively.
  • AM
    Ahmad Rashaad bin Muhammad
    Senior Manager, Others

    5

    Fantastic, easy to understand with well elaborated trainings!
  • AS
    Aiwan Aerfah Bt Noor Saharif @ Sharif
    Junior Executive, Facilities / Maintenance

    5

  • MM
    Mohd Amirul Mansor
    Manager / Supervisor, Operations

    5

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

    5

  • YA
    Yasmin binti Zainol Abidin
    Senior Executive, Others

    5

    Great class and trainer
  • NS
    Norhafizie Sunarde
    Junior Executive, IT Management

    5

  • NZ
    Nurul Farhana binti Zulkafli
    Senior Executive, Others

    5

  • NR
    NURUL FATIN ATIQAH BINTI ABD RAHIM
    Junior Executive, HR / Learning and Development

    5

  • MR
    MOHAMMAD ASYRUL BIN ABD RASHID
    Executive, Engineering

    5

  • M
    Manimaran
    Senior Executive, Manufacturing / Production

    5

    Should be
  • Ns
    Nor syareeza binti mohammad shazlan
    Junior Executive, Manufacturing / Production

    5

  • ZA
    Zuraiha Abdullah
    Junior Executive, Quality Assurance

    5

  • MA
    Madam Noradzlin Abd Aziz
    Junior Executive, Engineering

    5

  • NF
    NORHAYATI MOHD FUZI
    Senior Executive, Quality Assurance

    5

    Good
  • C
    Cheeranan
    Executive, Engineering

    5

  • KN
    Khairul Nizam
    Junior Executive, Warehousing / Logistics

    4

  • AS
    AMIR SHAABAN
    Senior Executive, Procurement / Purchasing

    4

  • AF
    Annis Naqilah Fauzi
    Executive, Operations

    4

  • NJ
    Nurhayati Jusoh
    Assistant Manager, Operations

    4

    good training
  • SA
    Siti Norizan Mohd Ali
    Assistant Manager, Others

    4

    👍 Great!
  • NZ
    Nur Aina Athirah Bt Mohamad Zariyani
    Senior Executive, Others

    4

  • NN
    Nur Fadzlina Binti Abdul Nahar
    Junior Executive, Sales

    4

  • mH
    ms Fathiyah Binti Abdul Halim
    Junior Executive, Others

    4

    -
  • SO
    Suhaimi Bin Osman
    Manager / Supervisor, Engineering

    4

  • AH
    Asrul Effendi Bin Abdul Halim
    Executive, Engineering

    4

  • Ms
    Mohd sharulnizam bin saleh
    Executive, Operations

    4

  • NN
    Nurdini binti md Nordin
    Senior Executive, Others

    4

    Good to improve skill on excel
  • AJ
    ALIAH JAMALUDIN
    Manager / Supervisor, Project Management

    3

  • MA
    Mohd Hazarudin Bin Ariffin
    Manager / Supervisor, Facilities / Maintenance

    3

  • TT
    Thanigesh Thiyagu
    Executive, Engineering

    3

OF 7Next

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?