skip to Main Content

2-Day Power Pivot for Excel Class Offered at the Microsoft Chevy Chase Office near Washington, D.C.!

Join us for a 2-day live class on Power Pivot and hone your analytical superpowers!

PowerPivot Training Class Washington DC, Maryland, Virginia

Download-IconDOWNLOAD THE BROCHURE

Logistics:

Location: Microsoft Office
5404 Wisconsin Ave., Ste. 700
Chevy Chase, MD 20815
Date: November 3rd & 4th, 2015
Cost: $1249 Time: 9:00 am – 4:00 pm both days

Benefits of Attending:

Gain analytical superpowers. Achieve better and faster results than with Excel alone.
Produce valuable metrics for your business that never existed before. Learn “recipes” to solve complex problems and create stand-out work.

Enroll PowerPivot Training Class
Prefer to enroll via email or phone?
Multiple enrollment discounts available.
Call 440.719.9000 or email [email protected]
.

Course Overview

Power Pivot is a technology full of surprises: while still perceived as “Brand New,” in reality it reflects 15+ years of ongoing development at Microsoft. Armed with that industrial-strength depth, you will conquer an unlimited spectrum of analytical, reporting, and modeling needs.

The next surprise, however, is even better: A remarkable simplicity underlies all of that power. In fact, the most useful capabilities are conveniently the most learnable.

In this two-day training, former Microsoft engineering leader Rob Collie has filtered his years of Power Pivot education, writing, and consulting experience down to that set – the things anyone can learn AND retain in a short period of time, while simultaneously building a confident foundation for future learning. Together you will take a 100% human and pragmatic approach. He brings the technology’s power to you, not vice versa.

But that down to earth approach, geared toward absolute beginners, will give you analytical superpowers. This learning strategy is built on four pillars:

  1. Fundamentals – short and simple, these fit onto a single 6-step flowchart (provided).
  2. Patterns – “recipes” that you can easily follow and modify to solve business problems, without requiring PhD-level mastery.
  3. Priorities – Focused on the capabilities that are most “bang for the buck.” Avoids topics that are too complex or too “niche.”
  4. Examples – there is no reference guide quite like a working example that you can revisit when needed. Each student takes home dozens of such examples in workbook form.

Download-IconDOWNLOAD THE BROCHURE

Who Should Attend?

Intensive users of Excel, particularly those responsible for reporting and analysis.
Business leaders who need to mine their data for actionable insight – using existing resources and on short deadlines.
Organizations looking to leverage Microsoft’s groundbreaking PowerBI offerings.
Business Intelligence and Database professionals looking to increase their professional agility and dramatically expand their capabilities.

(Note: Persons with Database, BI, Programming, or similar experience are quite qualified to take this course, even if lacking in Excel experience)

Prerequisites

Light usage of Excel PivotTables (or similar data analysis tools).
Familiarity with Excel functions like SUMIF and VLOOKUP are a plus.
A passion for acquiring Data Superpowers.

What You Will Receive

Exposure to best-in-class Power Pivot techniques, “recipes”, & practical tips.
Physical copy of Rob Collie’s book, “DAX Formulas for Power Pivot.
USB stick with example workbooks, sample data, and PDF guides.
Networking opportunity with fellow professionals and Rob.

Enroll PowerPivot Training Class
Prefer to enroll via email or phone?
Multiple enrollment discounts available.
Call 440.719.9000 or email [email protected]
.

Agenda

PowerPivot Training Agenda Day 1

PowerPivot Training Agenda Day 2

Enroll PowerPivot Training Class
Prefer to enroll via email or phone?
Multiple enrollment discounts available.
Call 440.719.9000 or email [email protected]
.