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

EX19I Microsoft Excel Intermediate

All versions available. Outline version below is Microsoft PowerPoint 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
Nested Functions
Database Function
Validate data in a Worksheet
Filter data using Auto & Advanced Filters
Advanced Chart Formatting
Clean Duplicate Records
Visualizing Data as a Graphics

Target Audience

This course is designed for Clerks, Officers, Executives, Supervisors, Administrators, Managers of all levels; 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, discussions and practical exercise

Course Modules

Module 1 – PERFORMING CALCULATIONS
Module 2 – CREATING ADVANCED FORMULAS
Module 3 – WORKING WITH FUNCTIONS
Module 4 – ORGANIZING WORKSHEET DATA WITH TABLES
Module 5 – VISUALIZING DATA AS A GRAPHICS
Module 6 – MANAGING VIEWS

Get To Know The Trainer

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.

VIEW PROFILE

Chat with us LIVE to get a

FREE QUOTATION!

COURSE DETAILS

COURSE INCLUDE

ALL IN FROM ONLY

RM0/DAY

*T&C Applies

PARTICIPANT REVIEWS FOR THIS COURSE

4.7

OH
Ooi Seow Hwee
Junior Executive, Others
5
CM
Chew Yee Mun
Executive, Operations
5
Pauline Trainer is patient and kind, teaching the syllabus step by step. I will attend the next class couching by Pauline.
TY
Tan Min Yi
Executive, Administration / Secretarial
5
LH
LEONG ZHAN HUNG
Executive, Operations
5
TZ
Tan Wen Zi
Executive, Others
5
NZ
NUR FATIHAH BINTI ZAKARIA
Executive, HR / Learning and Development
5
MH
MASHERRINA BINTI HERMAN
Manager / Supervisor, Others
5
TY
TEO RUI YI
Executive, Others
5
OC
Ong Jia Chong
Assistant Manager, Others
5
CQ
CHUNG WAE QIONG
Assistant Manager, Procurement / Purchasing
5
LY
LEE YEN YEN
Executive, Administration / Secretarial
5
YQ
Yap Kai Qi
Executive, Marketing / Design
5
HT
HO YIN TENG
Executive, Customer Service / Hospitality
5
NR
Nurul Izzati Binti Razin
Junior Executive, Accounting and Finance
5
LY
Loh Onn Yee
Assistant Manager, Others
5
TC
Tsu Weng Chen
Manager / Supervisor, Others
5
SS
Shyammala Devi Supramaniam
Executive, Administration / Secretarial
5
TH
Tan Gaik Har
Senior Executive, Others
5
Well understand with helpful trainer
BH
Bahareh Sadat Hosseini
Junior Executive, Others
5
YC
Yeow Hong Chai
Executive, Others
5
HK
Haziqah binti Khasmuni
Executive, Engineering
5
Hh
Hasmaliza hasan
Executive, Others
5
-
NF
Nur Syahira Afiqah Binti Mohd Fahmi
Executive, Marketing / Design
5
NH
Nur Hanizah Ali Hassan
Executive, Accounting and Finance
5
Ns
Nur shakira Saidor shahar
Executive, Accounting and Finance
5
MN
Muhd Fyairees Syalihin Norezan
Junior Executive, Engineering
5
NA
Nurul Shazlynn Binti Amran
Executive, Marketing / Design
5
So fun
Mm
Muhammad istiaq mubarak
Junior Executive, Engineering
5
RS
RADHWAN BIN ABDUL SALIM
Executive, Accounting and Finance
5
AB
AINUR AFIAH BINTI BURHANORDIN
Executive, Engineering
5
MR
MOHD HANIS BIN HJ RAMLI
Executive, Others
5
AA
Abdul Rahim bin Abdelkrim
Executive, Accounting and Finance
5
NH
Nur Fatin Hidayah Hamzah
Executive, Accounting and Finance
5
FF
Fayra Farinna
Executive, HR / Learning and Development
5
HH
Hasriyadi Bin Hassan
Assistant Manager, Engineering
5
AB
ATIKAH BINTI BADARUDDIN
Junior Executive, Administration / Secretarial
5
TH
TEH WAI HUEI
Junior Executive, Accounting and Finance
5
NN
Nur Assila Binti Md Nasser
Executive, Operations
5
Ti
Tiew ing ing
Senior Executive, Administration / Secretarial
5
MP
Mohd Akmal Ariff Bin Mohd Padzil
Assistant Manager, HR / Learning and Development
5
DD
Destina Devaraj
Executive, Operations
5
MR
Muhammad Danial Bin Ahmad Rizan
Executive, HR / Learning and Development
5
ZZ
Zainol Amin bin Zainal
Senior Executive, IT Management
5
YI
YUSRIANNA BINTI IBRAHIM
Senior Manager, Accounting and Finance
5
NA
Nurul Syazwani Binti Azahurin
Junior Executive, Project Management
5
Good trainer!
MR
Muhammad Danial Bin Ahmad Rizan
Executive, HR / Learning and Development
5
MA
Muhammad Izzudin bin Zainal Abidin
Junior Executive, Others
5
NH
Nur Nabilah Kamar Hisham
Senior Executive, IT Management
5
HA
Haznina Ashikin
Junior Executive, HR / Learning and Development
5
DW
Dayana Bazilah Binti Wahid
Manager / Supervisor, Project Management
5
SS
SITI NURADLIN SYAHIRAH
Junior Executive, IT Management
5
NB
NURUL ASYIRAH BAHAR
Executive, Others
5
nh
nadia nabilah bt hamzah
Junior Executive, Administration / Secretarial
4
TW
Tnee Jin Wen
Executive, Others
4
IK
INSYIRAH BT KAMARUDDIN
Executive, Administration / Secretarial
4
LR
Lailatul Hajar Binti Abd Rahim
Executive, Customer Service / Hospitality
4
Fa
Faradyana azman
Executive, Others
4
CM
Chin Chee Ming
Senior Executive, Sales
4
kp
kuan wai ping
Senior Executive, IT Management
4
TL
Tai Fong Lim
Senior Executive, Others
4
JS
Jacky Liew Hon Siong
Manager / Supervisor, Sales
4
IJ
Ian Brendan Jobidon
Executive, Accounting and Finance
4
NIL
NH
Norul Ilyani Hamdan
Senior Manager, IT Management
4
NS
Norairin Mahmat Sani
Senior Executive, HR / Learning and Development
4
EZ
Erwaniz Bin Zulkefli
Manager / Supervisor, Others
4
NH
Norul Ilyani bt Hamdan
Senior Manager, IT Management
4
HH
HALIMATUL SALEHA BINTI ABD HALIM
Junior Executive, Others
4
Very Good Session
SA
Siti Hadijah binti Zulkifli Auni
Assistant Manager, Project Management
4
NM
Norbaizura Mazlan
Executive, Others
3
Good trainer