100% NZ-owned | 80,000+ Books In NZ 📚

Today Only: 20% Off When You Buy 2+ Stationery Items! 🎨

Excel Power Pivot & Power Query For Dummies

Book Hero Magic crafted this summary to help describe this book. While it's new and still learning, it may not be perfect - your feedback is welcome! Summary
Excel Power Pivot & Power Query For Dummies by Michael Alexander is an accessible guide designed to help users harness the power of Excel for advanced data analysis. It explains how to efficiently use Power Pivot to create data models and Power Query to streamline data processing. Ideal for both beginners and those looking to deepen their understanding, the book demystifies complex tasks, enabling readers to transform raw data into meaningful insights.
Read More
Format: Paperback / softback
$7599
AVAILABLE WITH SUPPLIER Ships from our Auckland warehouse within 3-4 weeks

Found a better price? Request a price match

Book Hero Magic created this recommendation. While it's new and still learning, it may not be perfect - your feedback is welcome! IS THIS YOUR NEXT READ?

You might enjoy this book if you're looking to enhance your Excel skills by diving into Power Pivot and Power Query, tools that streamline data processing and analysis. It's perfect for anyone interested in transforming large amounts of data effortlessly, making it a great resource for professionals handling intensive data tasks.

Book Hero thinking about your next read

Excel Power Pivot & Power Query For Dummies

Book Hero Magic formatted this description to make it easier to read. While it's new and still learning, it may not be perfect - your feedback is welcome! Description

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 organisation’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.

Book Details

INFORMATION

ISBN: 9781119844488

Publisher: John Wiley & Sons Inc

Format: Paperback / softback

Date Published: 10 March 2022

Country: United States

Imprint: For Dummies

Edition: 2nd edition

Audience: Professional and scholarly

DIMENSIONS

Spine width: 13.0mm

Width: 180.0mm

Height: 229.0mm

Weight: 386g

Pages: 288

About the Author

Michael Alexander is a senior consultant at Slalom Consulting with more than 15 years’ experience in data management and reporting. He is the author of more than a dozen books on business analysis using Microsoft Excel and has been named Microsoft Excel MVP for his contributions to the Excel community.

Also by Michael Alexander

View all

More from Computing & Technology

View all

Why buy from us?

Book Hero is not a chain store or big box retailer. We're an independent 100% NZ-owned business on a mission to help more Kiwis rediscover a love of books and reading!

Service & Delivery

Service & Delivery

Our warehouse in Auckland holds over 80,000 books and puzzles in-stock so you're not waiting for your order to arrive from overseas.

Auckland Bookstore

Auckland Bookstore

We're primarily an online store, but for your convenience you can pick up your order for free from our bookstore, which is right next door to our warehouse in Hobsonville.

Our Gifting Service

Our Gifting Service

Books make wonderful thoughtful gifts and we're here to help with gift-wrapping and cards. We can even send your gift directly to your loved one.