skip to Main Content

2-Day Instructor-Led Power Pivot for Excel (Basics) Class Offered Online!

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

PPPUniversityLogoBasics300

HomeIcon Get trained in the comfort of your own office or home!
ChatIcon Fully interactive, chat, phone/voip, webcam, & screen sharing!
ChartIcon Build skills with take-home exercises & validate learning with provided solutions!
QuestionIcon Follow-up Q & A session after training!

Download-IconDOWNLOAD THE BROCHURE

Logistics:

Delivery Method: Live Online via GoToTraining Date: Dec 1st & 2nd, 2015
Cost: $249 Time: 9:00 AM – 11:00 AM PST both days
Change Timezone

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.

EnrollNowBorder
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.
Digital copy of Rob Collie’s book, “DAX Formulas for Power Pivot”.
Networking opportunity with fellow professionals and Avi.
Followup Q&A session after training, where after practice you can bring in any of your questions.

EnrollNowBorder
Prefer to enroll via email or phone?
Multiple enrollment discounts available.
Call 440.719.9000 or email [email protected]
.

Agenda

PowerPivotForExcelBasicsAgenda

EnrollNowBorder
Prefer to enroll via email or phone?
Multiple enrollment discounts available.
Call 440.719.9000 or email [email protected]
.