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

Microsoft Excel Advanced 2019

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

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

PC
Pang Chee Chung
Senior Executive, Accounting and Finance
5
SK
Siti Norashikin Binti Kamaruzaman
Senior Executive, Accounting and Finance
5
Trainer is helpful and class was ok
CY
CHOO KHAI YEE
Senior Executive, Accounting and Finance
5
Good training
Ts
Teh joo san
Senior Executive, Accounting and Finance
5
DS
Durar Fatin binti Md Sharif
Senior Executive, Warehousing / Logistics
5
KW
Khoo Sing Wan
Manager / Supervisor, Accounting and Finance
5
MM
Marliyati Binti Mohatar
Senior Executive, Accounting and Finance
5
RR
RUSNANI KAMILA BINTI MOHD ROZI
Executive, Accounting and Finance
5
RH
Reagan Fow Meng Han
Manager / Supervisor, Accounting and Finance
5
As
Abu bakar bin ahmad sabri
Senior Executive, Accounting and Finance
5
Wy
Wong mei ye
Manager / Supervisor, Accounting and Finance
5
MJ
MOHD NAZRUL B CHE JAMALUDIN
Junior Executive, Manufacturing / Production
5
ZS
ZAILANID BIN SIMAN
Manager / Supervisor, Operations
5
SY
Siti Nor Aishah Binti Mohd Yusoff
Senior Executive, Accounting and Finance
4
NZ
NUR SYAZWANI BINTI ZABERI
Executive, Accounting and Finance
4
FY
Foo Shi Ying
Assistant Manager, Accounting and Finance
4
YY
Yeoh Choir Yin
Senior Executive, Accounting and Finance
4
Cr
Chan Wei ren
Junior Executive, Accounting and Finance
4
NH
Nur Azzhari Bin Hassan
Junior Executive, Others
4
MI
MUHAMAD ZUBIR BIN ISMAIL
Manager / Supervisor, Manufacturing / Production
4
Good and recommended
MJ
Mohd Fadzil Bin Abd Jalil
Junior Executive, Manufacturing / Production
4
MM
Mohd Nazri bin Abd Majid
Junior Executive, Marketing / Design
3