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

Murphy, Indera E

Brossura

ISBN 10: 1935208276 ISBN 13: 9781935208273

Casa editrice: Tolana Publishing, 2016

Riassunto

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.

After completing the exercises in this book, you will be able to perform the following tasks and more:

• Import data into the data model
• Use the Table Import Wizard
• Create relationships
• Use slicers
• Create pivot tables and pivot charts
• Create KPI's and hierarchies
• Add sparklines to a pivot table
• Apply conditional formatting

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.

Su questo libro

Informazioni sull?autore

Dr. Indera E. Murphy is an author, educator and IT professional that has over 20 years of experience in the Information Technology field. She has held a variety of positions including technical writer, programmer, consultant, web designer, course developer and project leader. Indera has designed and developed software applications and web sites, as well as, manage technology driven projects in several industries. In addition to being an Executive Director and consultant, as an online adjunct professor, she has taught courses in a variety of areas including project management, technical writing, information processing, Access, HTML, Windows, Excel, Dreamweaver and critical thinking.

Dettagli dell?edizione

• Editore: Tolana Publishing
• Data di pubblicazione: 2016
• ISBN 10: 1935208276
• ISBN 13: 9781935208273
• Rilegatura: Copertina flessibile
• Lingua: Inglese
• Numero di pagine: 252
• Contatto del produttore: non disponibile