Microsoft’s Power Pivot is an add-on to Excel that enables you to produce new kinds of reports and analyses that were simply impossible before. This book is the first to tackle DAX formulas, the core capability of Power Pivot, from the perspective of the Excel audience. Written by a leading Power Pivot educator (and former leader on the Power Pivot and Excel teams at Microsoft), the book’s concepts and approach are introduced in a simple, step-by-step manner tailored to the learning style of Excel users everywhere.

The techniques presented allow users to produce, in hours or even minutes, results that formerly would have taken entire teams weeks or months to produce. In this book you will learn how Power Pivot:

1) Gives you “portable” formulas that can be re-used across multiple different reports with a single click.
2) Removes the need to ever write a VLOOKUP formula again.
3) Allows you to add smart calculations to pivots, such as “Year over Year” and “Moving Averages” which auto-adjust as the pivot changes.
4) Effortlessly merges disjointed sets of data into unified insight.

As a bonus, Power Pivot and DAX formulas are both the heart AND brain of Microsoft’s “Power BI” system, giving us a long-needed bridge between the worlds of Excel and Business Intelligence – a bridge that any Excel PivotTable user can cross with the help of this easy-to-follow book. Your new career – and your organization’s future – starts within these pages

About the Author

A former Microsoft engineering leader, Rob Collie is an entrepreneur, author, and consultant who believes Excel is enjoying a renaissance in power and importance - a trend that provides massive opportunities for the millions of Excel practioners worldwide. His passion is empowering and the Excel Professional to seize those opportunities. When he's not training, consulting, or writing, Rob can be found in his laboratory, devising new tools and techniques for the Excel community. He also operates the world's leading PowerPivot website (PowerPivotPro.com) and occassionally sleeps.

"About this title" may belong to another edition of this title.

Store Description

This book is being offered by Goodwill, a non-profit organization. All funds raised are used to support the Goodwill which provides quality, effective employment training and basic education to individuals experiencing significant barriers to economic opportunity. Because Jobs Change Lives. Proceeds from the sale of these goods and financial donations from the community make it possible for us to operate our free job training programs. Your donations and purchases help support these important programs and make the community a better place for all of us.

Visit Seller's Storefront

Seller's business information

Seattle Goodwill Industries
700 Dearborn PL S, Seattle, WA, 98144, U.S.A.

Sale & Shipping Terms

Terms of Sale

Returns are accepted according to the Abebooks Returns Policy. We respond to all inquiries within 2 business days.

Shipping Terms

We ship everything within 48 hours, and all our orders are shipped via UPS Mail Innovations. Please let us know if you have any questions or concerns. Customer satisfaction is our top priority.

Shipping rates within U.S.A.

Shipping rates within U.S.A.
Order quantity	5 to 14 business days	3 to 6 business days
First item	US$ 3.99	US$ 6.99

Delivery times are set by sellers and vary by carrier and location. Orders passing through Customs may face delays and buyers are responsible for any associated duties or fees. Sellers may contact you regarding additional charges to cover any increased costs to ship your items.