Independent Publishers Group Logo

Sign up today...
for featured pop culture and science reads, books for kids and teens,special offers, bestsellers, and more, in your inbox!

Subscribe to receive special offers, monthly books suggestions, seasonal selections, and more!

PowerPivot Alchemy
PowerPivot Alchemy

PowerPivot Alchemy

Patterns and Techniques for Excel


295 Pages, 8 x 10

Formats: Mobipocket, PDF, EPUB

PDF, $19.99 (US $19.99) (CA $21.99)

Publication Date: June 2014

ISBN 9781615472147

Rights: WOR

Holy Macro! Books (Jun 2014)


eBook Editions Available

Will it work on my eReader?
Price: $19.99
NOTE: You are attempting to order an e-book. Please see will it work on my eReader? for directions on how to enjoy this book on your eReader device.
add ebook to cart


Tips and tricks for analyzing big data

Rob Collie (PowerPivotPro) and Bill Jelen (MrExcel) join forces in this combined sequel to their best-selling Power Pivot books. Alchemy sets aside the fundamentals of past books and provides a series of practical, easy-to-follow "patterns" for dozens of common analysis, reporting, and dashboarding needs. Three "bonus" chapters introduce you to the newer members of the "Power BI" family – Power Query, Power View, and Power Map. Whether you are starting your transformation from "old school" Excel User to Modern Data Professional or a veteran of the Power BI arts, this book will dramatically expand your data superpowers.

Author Biography

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 practitioners 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 ( and occasionally sleeps.Bill Jelen is the host of and the author of 43 books about Microsoft Excel. He is a Microsoft MVP in Excel and a contributor to Strategic Finance Magazine.