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

What will you be able to do post training?

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

What's included in your training?

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

Course Content - Overview

INTRODUCTION TO POWERPIVOT POWERPIVOT ENVIRONMENT TAKING DATA INTO POWERPIVOT CALCULATED COLUMNS DAX MEASURES
  1. Table-Valued Functions
  2. Date and Time Functions
  3. Filter Functions
  4. Information Functions
  5. Logical Functions
  6. Mathematical and Trigonometric Functions
  7. Statistical Functions
  8. Text Functions
  9. Time Intelligence Functions
WORKING WITH MULTIPLE TABLES DISCONNECTED TABLES CREATING ADVANCED DAX MEASURES WITH ADVANCED DAX FUNCTIONS
  1. Calculate()
  2. All()
  3. Filter()
  4. IF()
  5. Switch()
  6. SumX()
CREATING CUSTOM CALENDARS USING ADVANCED FILTER() ADVANCED CALCULATED COLUMNS CREATING ADVANCED DASHBOARDS WITH POWERPIVOT

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, (315) 633-4414
  • inquiry_excel@excelgoodies.com

Connect us on

@

Learner stories around the world!

  • Trainer's Expertise
  • Course Structure
  • Course Content
  • Quality of Assignments
  • Certification Process

Bob Smith

Procurement Specialist

Trainer's knowledge and experience with every nook of Excel were highly impressive. The course was properly structured in terms of content, assignments and the flow of the training.

I am happy to be using most of Excel Formulae for my operational reports...

Daniel Foisy

Onboarding and Retention Specialist

I am happy to be certified! Thank you, Sami, for being highly patient in teaching complex formulae. Your art of teaching is something I would always cherish for a long time.

You have certainly set the benchmark of teaching standards. Assignments are something...

Chris Evan

Business Analyst

I loved working on challenging assignments. Want more of it. Formulae sessions were highly interesting.

Thanks, Andrew! It was wonderful knowing you and the whole team of Excelgoodies. Cheers...

Gary Roberts

Data Support Analyst

The format of the course was good. Assignments after every 15-20 topics reinforced my learning.


Shortcut Tool is something I find really interesting at work. Good work team!...

Joel Coleman

Document Review Specialist

One quality of Sami that I would like to highlight is - he was considerate of all training levels & made sure we were all taken care at our own speeds.

I am amused at his patience level and truly...

Other Excel Courses offered

Powerpivot - Data Analytics

View Details

Advanced Excel Training

View Details

Financial Modeling with Excel

View Details

MIS Reporting with Excel

View Details