Live Virtual Training (Most Popular!) > Microsoft Excel 2021 Intermediate Customized

Microsoft Excel 2021 Intermediate Customized

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:
- 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
Module 2: Working with Functions
Module 3: Organize Dynamic Data Range with Table
Module 4: Data Visualization
Module 5: Summarizing and Analyzing Data with PivotTable, Slicer and PivotCharts

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

VIEW PROFILE

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

SO
SURIANI BINTI OTHMAN
Manager / Supervisor, Customer Service / Hospitality
5
Good session
MJ
Muhammad Farid Bin Jallaludin
Executive, Customer Service / Hospitality
5
RH
Ruhaida Abd Halim
Executive, Customer Service / Hospitality
5
ND
NURUL HIDAYAH BINTI MD DAUD
Executive, Customer Service / Hospitality
5
Good lesson
AA
Akmal Haqimi Bin Khairul Annuar
Executive, Customer Service / Hospitality
5
MS
MOHAMMAD IDDIN BIN SHAMSUDDIN
Executive, Facilities / Maintenance
5
MO
MUHAMMAD KHAIRUL FA'IQ OSHMAN
Junior Executive, Customer Service / Hospitality
5
DV
Darvin Raj Vijayan
Manager / Supervisor, Facilities / Maintenance
5
KR
Kavitha Rajamanikam
Executive, Operations
5
Na
MJ
Mazida Jamil
Executive, Operations
5
NA
Nor Ain Syazwani Bt Nor Azmin
Executive, Customer Service / Hospitality
5
NB
Nanthini Balasubramaniam
Executive, Customer Service / Hospitality
5
NA
Norshasa Azira Binti Abdul Aziz
Executive, Customer Service / Hospitality
5
NK
Nik Nur Syafiqah Binti Mohd Kamal
Executive, Customer Service / Hospitality
5
Mr
Muhammad Rohaizad bin rosli
Executive, Customer Service / Hospitality
5
VT
VINOOTHINY TAMILCHELVAN
Executive, Customer Service / Hospitality
4