skip to Main Content


“Dangerously good.” -Mark Polino

“I have the two other best-selling PowerPivot books, but this is by FAR the best.” –Janet Belding

“it’s been a while since I’ve read a book so entertaining and effective at teaching a valuable skill.” -Paul Turley

“I am buying this book for every member of my team.” -Dan English

“Four days working through this with my own data and I am now making some amazing stuff that eluded me before.”  -Ken Puls

#1 Best Seller in’s Software Category


Click to Visit the Page Offering Free Reference Card and eBook for USA Orders

PowerPivot Book for the Excel User by Rob Collie, PowerPivotPro
Click to Visit the Book Page

PowerPivot DAX Reference Card, Free With All Purchases of the Book from

Free Reference Card from – Front and Back Shown
(Also Sold Separately on for $2.95)

EBook – iPad, Kindle, etc. also Available

PowerPivot eBook Formats for Kindle, iPad, etc.

Click to Visit the eBook Page

Sample Contents


This diagram from an early chapter of the book illustrates Rob’s
“Learn incrementally and at your own pace” philosophy

clip_image002_thumb5 clip_image0024_thumb5 clip_image0026_thumb5

A Few Sample Pages – Click Each for Larger Version

Data Sources and Workbooks From the Book

PowerPivot Book Sample Files

All Files Used in the Book Are Available for Free Download
Click Image to Visit the Download Page

More Reader Reactions


“Human… this is how technical books should be written.”

-Tom LaRock

“…writing style is very addictive… it’s a real page-turner.”

-Siraj Samsudeen

“Rob has a gift for explaining things in a way that makes it easy to understand.”

-Shawn Frizzell

“…extremely well written, clear, concise and flows logically down your DAX adventure.”

-Dave Boylan

“This book gets to grips with the real problems faced when implementing a powerpivot solution. The section on performance was especially worthwhile and the examples meaningful.”

-Dave Pitts

“Packed with loads of super useful tips and tools. After getting through the first chapters I had already gotten my money’s worth. Best gift to data analysis in the 21st century.”

-Dan Wesson