Power BI Tools Volume 2: Learning Power Pivot For Excel Made Easy

	By Dr. Indera E. Murphy Published: June 24, 2016 ISBN-13: 978-1-935208-27-3 ISBN-10: 1-935208-27-6 LCCN: 2016910217 252 Pages Paperback Price $29.95 US Table Of Contents You can buy this book from: Amazon or Barnes & Noble

Overview
This book is based on Power Pivot for Excel 2016. Power Pivot is a popular tool for Excel. It is powerful and easy to learn. Power Pivot For Excel Made Easy gets you up and running with Power Pivot by teaching you the basics relatively quickly, so that you can import data and create pivot tables and chart for decision making purposes.

Each chapter explains new concepts and most chapters have exercises to help reinforce the topics. This puts your new skills to work right away. I try hard not to bore you with a lot of history. You will learn how to link data tables, create summary pivot tables and make the data displayed in a pivot table interactive by adding filters, slicers and timelines. And did I say that sample files are available, so that you can complete the step-by-step instructions? What makes Power Pivot fun is that you can see your changes (good or bad) immediately.

If you are also looking to learn Power Query, see Power BI Tools Volume 4: Learning Power Query And Power Pivot For Excel Made Easy,ISBN 978-1-935208-29-7. We also have a book that covers Power View and Power Map, in addition to Power Query, see Power BI Tools Volume 3: Learning Power Query, Power View And Power Map For Excel Made Easy, ISBN 978-1-935208-28-0.

Table Of Contents

Chapter 1 - Getting Started With Power Pivot For Excel
Chapter 2 - Quick Tour Of Power Pivot
Chapter 3 - Exploring the Power Pivot Workspace
Chapter 4 - Using The Table Import Wizard
Chapter 5 - Import Data From A Database
Chapter 6 - Import Data From Non Database Sources
Chapter 7 - Linking Tables, Pasting And Appending Data
Chapter 8 - Using Filters And Sorting Data
Chapter 9 - Creating Relationships
Chapter 10 - Creating Pivot Tables
Chapter 11 - Creating Pivot Charts
Chapter 12 - Using Slicers
Chapter 13 - Enhancing Pivot Tables And Pivot Charts Part 1
Chapter 14 - Enhancing Pivot Tables And Pivot Charts Part 2
Chapter 15 - Timelines, Sparklines And Conditional Formatting






PowerPivot For Excel Home Page | Errata |