IT and Computing (Live Online) > Maximizing Pivot Table

Maximizing Pivot Table

Course Objectives

Elements of this syllabus are subject to change. This one-day instructor- led course provides students with the knowledge and skills to examine and manipulate raw data through the use of Microsoft Office Excel PivotTables and Pivot Charts.

Target Audience

This course is intended for Information Workers.

Methodology

After completing this course, students will be able to:

Understand the benefits of PivotTable Reports.
Convert raw data in an Excel worksheet into meaningful PivotTables and Pivot Charts.
Manipulate the PivotTable layout.
Use grouping.
Create custom calculations.
Use formulas and create formulas outside of a report.
Create a PivotChart and publish it to a Web site

Course Modules

Lesson 1: Make Your Data Work for You

Lesson 2: A Quick Tour

Lesson 3: Manipulating the PivotTable

Lesson 4: Digging Deeper

Lesson 5: Beyond the Basics

Lesson 6: More PivotTable Calculations

Lesson 7: Optional Topics

Get To Know The Trainer

Trainer Nazarudin

4.5

Nazarudin Aziz started freelancing as a Corporate Trainer since the year of 2005 specializing in the field of Multimedia Graphic Designer and Microsoft Office Applications. His list of clients are Perodua, Grand Pacific Hotel, Cosway, UDA Mall, Institut Teknologu Rekabentuk Perabot Malaysia, Telekom Malaysia, Lembaga Tabung Haji, Yayasan Pelajaran MARA, Kementerian Pembangunan Wanita & Masyarakat, Hospital Tengku Ampuan Rahimah Klang, United Engineers Malaysia, Malaysian Maritime & Dredging Corporation, Jabatan Perdana Menteri, Indah Water Consotrium and many more.

VIEW PROFILE

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!

THIS PUBLIC COURSE INCLUDES

CLASS DETAILS

ALL IN FROM ONLY

RM0/PAX

*T&C Applies

4.8

YY
YONG PUI YEE
Senior Executive, Customer Service / Hospitality
5
CX
CHAI CHANG XIN
Executive, Customer Service / Hospitality
5
ND
NURSYAHIRAH BINTI DZULKIFLI
Executive, Others
5
Awesome
LS
Lim Wee Shyan
Senior Executive, Sales
5
NM
NUR NADIA BINTI MOHAMAD
Executive, Procurement / Purchasing
5
Goods trainer, easy to learning and understood the content and practice.
Es
Esther wong ying san
Senior Executive, Customer Service / Hospitality
5
Nice and details trainer and sources
LW
LEE PIK WEN
Senior Executive, Customer Service / Hospitality
5
NA
PQ
Poo Zi Quan
Executive, Procurement / Purchasing
5
NT
Nozira Termizi
Executive, Administration / Secretarial
5
WP
Wong Leh Ping
Assistant Manager, Operations
5
CL
CHAN KAI LIE
Executive, Customer Service / Hospitality
5
Sn
Sharifah zulaikha bt syed muhammad nurdin
Executive, Customer Service / Hospitality
5
Excellent trainer
HX
Hoh Si Xuan
Executive, Procurement / Purchasing
5
TL
Tan Fun Loong
Executive, Procurement / Purchasing
5
NA
Nur Zaafira Binti Azahari
Executive, Procurement / Purchasing
5
MS
Muhammad Farid Bin Mohd Sam
Manager / Supervisor, Warehousing / Logistics
5
The training is very clear and easy to understand.
NQ
Nicole Chan Zhi Qi
Junior Executive, Warehousing / Logistics
5
CW
Chia Xiu Wei
Executive, Warehousing / Logistics
5
KN
KHOR AI NEE
Manager / Supervisor, Marketing / Design
5
Ly
Lim shu ying
Assistant Manager, Warehousing / Logistics
5
Md
Mohd sharil Izzat bin Mohd dom
Senior Executive, Warehousing / Logistics
5
FR
FAZIATUL AISHAH BINTI RASHID
Junior Executive, Accounting and Finance
5
AS
Anthikka Suwanno
Senior Executive, Others
5
NZ
Nur Shazwani Binti Zainudin
Senior Executive, Manufacturing / Production
5
N/A
SR
Sureshkumar Rajan
Manager / Supervisor, Customer Service / Hospitality
5
HG
Hok Chew Guen
Junior Executive, Operations
4
YX
Yeoh Khye Xin
Executive, Procurement / Purchasing
4
CP
Chin Siew Ping
Senior Executive, Accounting and Finance
4
LF
Lai Tet Fui
Assistant Manager, Others
4
KH
Khoo Kah Hooi
Senior Executive, Manufacturing / Production
4
Good
LL
Liew Ying Lin
Junior Executive, Customer Service / Hospitality
3
-