Live Virtual Training (Most Popular!) > Microsoft Excel 2019 Advanced

Microsoft Excel 2019 Advanced

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

MS
Muhammad Fadzli Fuad bin Saharudin
Executive, Operations
5
Tc
Tee sheng chuan
Senior Executive, HR / Learning and Development
5
Well explanation and learn new skill and functions
SY
SHUM XUE YAO
Assistant Manager, Accounting and Finance
5
LS
LIM HAN SHENG
Executive, Accounting and Finance
5
CJ
Chew Yee Jing
Executive, Others
5
NS
Ng Min Si
Executive, Procurement / Purchasing
5
Nice Trainer , Fun course
CQ
Cheah Shi Qing
Assistant Manager, Research and Development
5
LF
LEE KUM FUNG
Executive, Accounting and Finance
5
FM
FATIN NADIAH BT AHMAD MARZUKI
Executive, Accounting and Finance
5
NZ
NOR MANISAH BINTI ZAKARIA
Senior Executive, Accounting and Finance
5
NQ
NG JIN QUAN
Junior Executive, Accounting and Finance
5
LY
LEE YEN YEN
Executive, Administration / Secretarial
5
TY
Tan Min Yi
Executive, Administration / Secretarial
4
CA
Chu Tong Ang
Assistant Manager, Procurement / Purchasing
4
LY
LOOI ZHI YING
Executive, Accounting and Finance
4
LY
LOOI ZHI YING
Executive, Accounting and Finance
4
NN
Ng Qian Ni
Executive, HR / Learning and Development
4
YK
YAP KWAI KWAN
Senior Executive, Administration / Secretarial
4
NZ
Nur Diana Athirah binti Zahid
Executive, Accounting and Finance
4
Trainer deliver it so well, i enjoy the class.
SY
Son Keng Yin
Manager / Supervisor, Administration / Secretarial
4