Bobby López Personal Library
home

Bobby López Personal Library

Mastering Excel: PowerPivot
Mark Moore
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.**
Mastering Excel: Power View
Mark Moore
This Mastering Excel lesson covers Power View. Power View is a new Excel feature that lets you explore you data and create dynamic & interactive presentations. You will start with the basics, creating a List Report, moving onto Matrix Tables, then Cards, Charts, Filters, Slicers and even Maps! This lesson is a bit longer than the rest of the series because it is a big topic. You can do so much with Power View. Once you finish this lesson and you begin to use Power View in your day to day work, be prepared to get questions form everyone about it. You will amaze everyone and yes, this just might make you the office Excel guru. Seriously, it is that impressive. Like all the other Mastering Excel lessons, this one also come with follow along workbooks. Click on the link in the book to re...