What do you think?
Rate this book
Mastering Excel: PowerPivot
PowerPivot is a big deal for Excel. PowerPivot is a new feature where Excel will load data into a Data Model that can handle millions of rows. You can create relationships between tables, build hierarchies and improve the already extensive data analysis capabilities of Excel.
In this lesson, I show you how to install Power Pivot, connect to various data sources, build relationships, add time based intelligence to the Data Model and I throw is some more tricks along the way.
You must have Excel 2010 or later to use PowerPivot. The screenshots in the lesson are from Excel 2016. Earlier version will look a little different but not substantially so.
This lesson come with several follow along workbooks that you can use to work through the exercises as you read the book.
In this lesson, I show you how to install Power Pivot, connect to various data sources, build relationships, add time based intelligence to the Data Model and I throw is some more tricks along the way.
You must have Excel 2010 or later to use PowerPivot. The screenshots in the lesson are from Excel 2016. Earlier version will look a little different but not substantially so.
This lesson come with several follow along workbooks that you can use to work through the exercises as you read the book.
78 pages, Kindle Edition
Published March 26, 2016
13 people are currently reading
2 people want to read
About the author
Mark Moore
199 books3 followersLibrarian note:
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
There is more than one author in the GoodReads database with this name
This profile may contain books from multiple authors of this name.
Ratings & Reviews
Friends & Following
Create a free account to discover what your friends think of this book!
Community Reviews
Displaying 1 of 1 review
November 29, 2016
Must read for intermediate users
If your an advanced user you will get a good refresher. Clear and concise with well depicted examples. Will definitely use again as a reference source since I don't need these skills on a daily basis.
Looking forward to reading more of these mini but powerful trainers
Well Done
If your an advanced user you will get a good refresher. Clear and concise with well depicted examples. Will definitely use again as a reference source since I don't need these skills on a daily basis.
Looking forward to reading more of these mini but powerful trainers
Well Done
Displaying 1 of 1 review