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 receive the materials in your email.
THIS IS IMPORTANT. PLEASE READ THIS:
You MUST have the right version of Excel to use Power View. Power View and Power Pivot are only available in the Office Professional Plus and Office 365 Professional Plus editions, and in the standalone edition of Excel 2013. Excel 2016 has Power View but Microsoft has removed the Power View button. In the lesson, I show you how to add it to the ribbon.