PivotTable, Charts and Dashboards

Taught by Microsoft Certified Trainers

(758)

This is a 5 hours course designed for Excel users to crunch numbers substantially, create reports dynamically using PivotTable and, present professional information Dashboards in Microsoft Excel that is beautiful, precise and clear.

Talk to the Trainer

Know your current Excel skills through a quick pre-assessment, discuss your requirements (if any) with the Trainer and, feel your comfort level before registering for the program.

Course Fee

$199

Course Duration:
6 Hours (2 Sessions, each of 3 hours)

Mode of Training:
Virtual Classroom (Instructor-Led)

Pre-requisite:
Basic Excel knowledge

Check your eligibility for the course

Course Fee $199

What will you be able to do post training?

Transform business records into a detailed report within seconds
Construct different views for your business needs
Present visually appealing data through Charts
Summarize all data points into a single screen for effective decision-making

What's included in your training?

Pre-Course Assessment
Hands-On Instructor Led Training
10+ Assignments and Real-time exercises
Post-training Support for period of 30 Days

Course Content - Overview

Pivot Table

Creating Pivot Table

Changing the Pivot Table layout
Formatting row , column and value fields
Grouping items – Number Grouping and Date Grouping
Inserting calculated fields
Display and hide data in fields
Layout reports directly on worksheet
Manual, Single & Multi sorting options
Manual, Single & Multi Filtering options
Multiple ways of presenting data in Pivot Table
Using advanced value field setting
Display Amount in Percentage
Pivot Table – Design Tab

Pivot table options Using slizers CHARTS & PIVOT CHARTS

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

EXCEL DASHBOARD

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

Testimonials

"To sum it all, It was one on the finest sessions I've come across recently. Thanks, Sami! I am been able to approach Excel scenarios more confidently. I kind of enjoyed your Dashboard session the most. I will surely share some work of mine soon to you. Cheers!"

Richard Carter

Data Coordinator, First Protocol,

New York City, NY

Course Fee

For One-to-One
personalized training

$199

For Group of 3
Participants

$129 (per participant)

Contact Us

Mr. Perrie Smith, Business Associate

(650) 491-3131, (347) 790-1311

inquiry_excel@excelgoodies.com

Connect us on

Course Content - Overview

Power Pivot

Creating Pivot Table

Changing the Pivot Table layout
Formatting row , column and value fields
Grouping items – Number Grouping and Date Grouping
Inserting calculated fields
Display and hide data in fields
Layout reports directly on worksheet
Manual, Single & Multi sorting options
Manual, Single & Multi Filtering options
Multiple ways of presenting data in Pivot Table
Using advanced value field setting
Display Amount in Percentage
Pivot Table – Design Tab

Pivot table options Using slizers CHARTS & PIVOT CHARTS

Bar Charts / Pie Charts / Line Charts
Dual Axis Charts
Dynamic Charting
Other Advanced Charting Techniques

EXCEL DASHBOARD

Bar Charts / Pie Charts / Line Charts
Planning a Dashboard
Adding Tables to Dashboard
Adding Charts to Dashboard
Adding Dynamic Contents to Dashboard

What you will be able to do post-training?

Transform business records into a detailed report within seconds
Construct different views for your business needs
Present visually appealing data through Charts
Summarize all data points into a single screen for effective decision-making