Search

Select theme:

Shopping cart

Subtotal
$97.00
View cart Checkout

Saved articles

You have not yet added any article to your bookmarks!

Browse articles
Newsletter image

Subscribe to the Newsletter

Join 10k+ people to get notified about new posts, news and tips.

Do not worry we don't spam!

GDPR Compliance

We use cookies to ensure you get the best experience on our website. By continuing to use our site, you accept our use of cookies, Privacy Policy, and Terms of Service.

  • Home
PowerPivot Alchemy

PowerPivot Alchemy

By Bill Jelen Computers 01/06/2014

PowerPivot is an amazing new add-in for Excel 2013 that allows business intelligence pros to process large amounts data. Although it is simple to use in a demo environment, analysts are likely to run into real-life scenarios that are difficult to solve. This guide, dedicated solely to the PowerPivot tool, provides techniques and solutions to real-world problems, including showing the Top N customers by using slicer filters, comparing budget to actuals, drilling across data instead of through data, and joining data from two different sources in a single analysis.

Read More
More Books from Bill Jelen
VLOOKUP Awesome Quick Bill Jelen
VLOOKUP Awesome Quick
Excel 2016 VBA and Macros Bill Jelen
Excel 2016 VBA and Macros
Slaying Excel Dragons Mike Girvin & Bill Jelen
Slaying Excel Dragons
Microsoft Excel 2019 VBA and Macros Bill Jelen & Tracy Syrstad
Microsoft Excel 2019 VBA and Macros
Learn Excel 2007 through Excel 2010 From MrExcel Bill Jelen
Learn Excel 2007 through Excel 2010 From MrExcel
Using Microsoft Excel 2010, Enhanced Edition Tracy Syrstad & Bill Jelen
Using Microsoft Excel 2010, Enhanced Edition
Excel 2013 In Depth Bill Jelen
Excel 2013 In Depth
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365) Bill Jelen & Tracy Syrstad
Microsoft Excel VBA and Macros (Office 2021 and Microsoft 365)
Don't Fear the Spreadsheet Tyler Nash, Bill Jelen & Kevin Jones
Don't Fear the Spreadsheet
Power Excel with MrExcel - 2017 Edition Bill Jelen
Power Excel with MrExcel - 2017 Edition
PowerPivot Alchemy Bill Jelen
PowerPivot Alchemy
MrExcel XL Bill Jelen & Szilvia Juhasz
MrExcel XL
Power OneNote Kathy Jacobs & Bill Jelen
Power OneNote
MrExcel LX The Holy Grail of Excel Tips Bill Jelen
MrExcel LX The Holy Grail of Excel Tips
Excel Gurus Gone Wild Bill Jelen
Excel Gurus Gone Wild
Power Excel 2019 with MrExcel Bill Jelen
Power Excel 2019 with MrExcel
Learn Excel 97 Through Excel 2007 from Mr. Excel Bill Jelen
Learn Excel 97 Through Excel 2007 from Mr. Excel
Power Excel with MrExcel Bill Jelen
Power Excel with MrExcel
Learn Excel from Mr. Excel Bill Jelen
Learn Excel from Mr. Excel
Excel for Marketing Managers Ivana Taylor & Bill Jelen
Excel for Marketing Managers
Guerilla Data Analysis Using Microsoft Excel Bill Jelen
Guerilla Data Analysis Using Microsoft Excel
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365) Bill Jelen
Microsoft Excel Pivot Table Data Crunching (Office 2021 and Microsoft 365)
MrExcel LIVe Bill Jelen
MrExcel LIVe
Excel Dynamic Arrays Straight to the Point 2nd Edition Bill Jelen
Excel Dynamic Arrays Straight to the Point 2nd Edition
Excel for Auditors Bill Jelen & Dwayne K. Dowell
Excel for Auditors
Excel 2007 Miracles Made Easy Bill Jelen
Excel 2007 Miracles Made Easy
Using Microsoft Excel 2010 Tracy Syrstad & Bill Jelen
Using Microsoft Excel 2010
Microsoft Excel Inside Out (Office 2021 and Microsoft 365) Bill Jelen
Microsoft Excel Inside Out (Office 2021 and Microsoft 365)
MrExcel 2021 Bill Jelen
MrExcel 2021
Guerrilla Data Analysis Using Microsoft Excel Oz du Soleil & Bill Jelen
Guerrilla Data Analysis Using Microsoft Excel
Rev Up to Excel 2010 Bill Jelen
Rev Up to Excel 2010
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot Bill Jelen
Microsoft Excel Pivot Table Data Crunching Including Dynamic Arrays, Power Query, and Copilot
MrExcel 2022 Bill Jelen
MrExcel 2022
The Spreadsheet at 25 Bill Jelen
The Spreadsheet at 25
Excel for Teachers Colleen Conmy, Bill Hazlett, Bill Jelen & Adrienne Soucy
Excel for Teachers
Power Pivot dla Excela. Zaawansowane możliwości Bill Jelen & Rob Collie
Power Pivot dla Excela. Zaawansowane możliwości
Microsoft Excel VBA and Macros Tracy Syrstad & Bill Jelen
Microsoft Excel VBA and Macros
Guerrilla Data Analysis Using Microsoft Excel Bill Jelen & Oz du Soleil
Guerrilla Data Analysis Using Microsoft Excel
Excel Subtotals Straight to the Point Bill Jelen
Excel Subtotals Straight to the Point
Comments