Excel Power Pivot & Power Query For Dummies
Product ID: 363602781
Buy anything from 5,000+ international stores. One checkout price. No surprise fees. Join 2M+ shoppers on Desertcart.
Desertcart purchases this item on your behalf and handles shipping, customs, and support to Romania.
Learn to crunch huge amounts of data with PowerPivot and Power Query Do you have a ton of data you need to make sense of? Microsoft’s Excel program can handle amazingly large data sets, but you’ll need to get familiar with PowerPivot and Power Query to get started. And that’s where Dummies comes in. With step-by-step instructions―accompanied by ample screenshots― Excel PowerPivot & Power Query For Dummies will teach you how to save time, simplify your processes, and enhance your data analysis and reporting. Use Power Query to discover, connect to, and import your organization’s data. Then use PowerPivot to model it in Excel. You’ll also learn to: Make use of databases to store large amounts of data Use custom functions to extend and enhance Power Query Add the functionality of formulas to PowerPivot and publish data to SharePoint If you’re expected to wrangle, interpret, and report on large amounts of data, Excel PowerPivot & Power Query For Dummies gives you the tools you need to get up to speed quickly. Review: Very helpful to build foundation - I have learned about Power Query from youtube videos and use it sometimes. But this book was very helpful to put everything into context and build a foundation. I think I will be using Power Query more often. Review: Good introduction - It was a good introduction to power pivot. But nothing beyond a beginner level. I wish it was a bit more in-depth.
| Best Sellers Rank | #249,796 in Books ( See Top 100 in Books ) #47 in Microsoft Excel Guides #68 in Spreadsheet Books #539 in Computer Science (Books) |
| Customer Reviews | 4.3 out of 5 stars 93 Reviews |
L**O
Very helpful to build foundation
I have learned about Power Query from youtube videos and use it sometimes. But this book was very helpful to put everything into context and build a foundation. I think I will be using Power Query more often.
S**C
Good introduction
It was a good introduction to power pivot. But nothing beyond a beginner level. I wish it was a bit more in-depth.
E**D
Quick resource for Excel
Quick resource for Excel
A**Z
Succinct and useful
Great reference to keep on hand.
P**A
Good book
Buenas herramientas
A**R
Not Really for Beginners
There apparently is a difference between "regular" pivot tables in Excel and "power" pivot tables. Although there are approximately 8 chapters on pivot tables, you really need to know about regular pivot tables first. Power Query is a very advanced way to work on pivot tables. I "assumed" this book was for beginners, but is more for more advanced users. If you are already familiar with pivot tables, this book is for you. If you're looking for a beginner's guide, look elsewhere. Will be returning.
C**N
Well written
Loads of practical information
A**K
Not for Dummies
I’ve enjoyed multiple books from the Dummies line. I’m an advanced Excel user but this book is a little too advanced. Power queries are a tough topic and this book didn’t help me.
B**D
Useful and easy to follow.
Very useful book. Well written and not overly complicated.
A**R
Arrived on time
And in good condition thanks
J**B
very very light introduction
A very light introduction to managing data in Excel with P.Pivot and Query, the information is clear and stepwise introduction to managing this Excel add-ins. I miss some real life example usage, some troubleshooting when one tries to stablish relations within tables and it does not work, ..... , and it keeps surprising me the "generous" waste of paper with margins and pages half empty ... In my opinion, too expensive for what you get.
S**Y
Pivot Table
Like the book very much
T**.
Exel Power Pivot & Power Query For Dummies
Alles Bestens, war sehr hilfreich - gut beschrieben! Schnelle Lieferung!
Trustpilot
1 month ago
3 weeks ago