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

Microsoft Excel Intermediate 2010

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

LY
Lee Liang Yi
Manager / Supervisor, Administration / Secretarial
5
HN
Ho Li Ngin
Senior Executive, Administration / Secretarial
5
TG
Ting Ai Gee
Senior Executive, Sales
5
LL
LOO PUI LIM
Executive, Accounting and Finance
5
Sk
Sathia kumaran
Executive, Sales
5
CY
Cheah Mei Ying
Executive, Procurement / Purchasing
5
NB
Nur Basirah Zaidah binti Bahari
Executive, HR / Learning and Development
5
TL
TAN KENG LEE
Junior Executive, IT Management
5
NN
NGA BAO NIAN
Executive, Others
5
MR
MUHAMMAD AIZAT NABIL B RAHMAD
Executive, Operations
5
LW
Lee Jie Wey
Senior Executive, Others
5
YC
YIP KAH CHUN
Executive, Accounting and Finance
5
AR
Ari Saw Yong Ren
Senior Executive, Accounting and Finance
5
Ks
Khoo yit sean
Executive, Accounting and Finance
5
AY
Ang Sea Yen
Executive, Procurement / Purchasing
5
SA
Siti Sarah binti Azman
Executive, Operations
5
Na
Nabihah binti azhar
Senior Executive, HR / Learning and Development
5
FH
Farah Aisyah binti Muhammad Hatta
Executive, Administration / Secretarial
5
Easy to understand and very detailed!
NN
NORAFIDAH NASARUDDIN
Executive, Administration / Secretarial
5
yk
yap kwai kwan
Executive, Administration / Secretarial
5
The course is great, gain new skill and knowledge, friendly speaker
TK
TAN VIN KAY
Executive, Accounting and Finance
5
SA
Shaheera Nabila Binti Anuar
Executive, Others
5
SJ
SIA WOEI JINQ
Senior Executive, Accounting and Finance
5
CY
Chan Weng Yin
Junior Executive, Others
5
HM
Ho Sher Mein
Executive, Others
5
WY
Wong Chin Yap
Executive, Others
5
YY
Yong Xin Yi
Executive, Marketing / Design
5
Pauline is a good trainer! Well explanation during the class!
FN
Fiona Lim Yun Ni
Executive, Administration / Secretarial
5
WL
Wan Nur Laila
Executive, Accounting and Finance
5
DS
Doris Soh
Senior Executive, HR / Learning and Development
4
CT
Chin Yun Tong
Junior Executive, Others
4
Good
NC
NG LI CHING
Senior Executive, Sales
4
Knowledgeable trainer and easy to understand.
H
Hemawathi
Executive, Sales
4
LY
Lee Liang Yi
Manager / Supervisor, Administration / Secretarial
4
GP
Ging Kok Ping
Executive, Accounting and Finance
4
WY
WEI SOO YIN
Junior Executive, Accounting and Finance
4
LP
Leong Yan Ping
Executive, Others
4
LX
Law Jun Xian
Senior Executive, Accounting and Finance
4
TJ
TAY PEI JUN
Executive, Accounting and Finance
4
TE
Tan Eugene
Executive, Others
4
Cj
Chong man jin
Junior Executive, Accounting and Finance
4
MT
Mah Yu Ting
Executive, Accounting and Finance
4
CT
Cheah Lok Theng
Executive, Accounting and Finance
4
DZ
Desmond Loy Shao Zhen
Executive, Marketing / Design
4
WK
Wong Hew Kei
Executive, Procurement / Purchasing
4
TR
Tan Xiao Rou
Junior Executive, Marketing / Design
4
SE
Soo Eva
Executive, Procurement / Purchasing
4
jl
john koon tzer lim
Assistant Manager, Operations
3
TY
Tee Yee Ying
Executive, Others
3
YL
Yap Han Lin
Executive, Corporate Communications
3
SS
Soo Jing Shin
Executive, Marketing / Design
3