Getting Started With PowerPivot For Excel 2010 - Softcover

Murphy, Indera E

Softcover

ISBN 10: 1935208160 ISBN 13: 9781935208167

Publisher: Tolana Publishing, 2011

Synopsis

(A new version is available for Power Pivot For Excel 2016. See ISBN 978-1935208273 and 978-1935208297) PowerPivot is a free new add-on for Excel 2010 that is used to enhance pivot tables and pivot charts. PowerPivot brings self-service business intelligence to the desktop by allowing you to connect to a variety of data sources. This functionality is used to enhance data analysis in Excel. The purpose of PowerPivot for Excel is to help Excel end users access data in multi-dimensional databases without having extensive training and knowledge of this type of data modeling. Additionally, PowerPivot has a new programming language called Data Analysis Expressions (DAX). This language adds data manipulation functionality to Excel formulas, including analysis and complex grouping that is above the formula capabilities that are available in Excel. DAX takes the formulas that you are use to creating for pivot tables and pivot charts in Excel to a whole new level. In a user friendly, step-by-step way, you will learn the following: How to use the Table Import Wizard, How to import data into PowerPivot, How to create pivot tables and pivot charts using data in PowerPivot, How to create DAX formulas and much more.

About this title

About the Author

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, Indera is also an online adjunct professor. She teaches courses in a variety of areas including project management, technical writing, information processing, Access, HTML, Windows, Excel, Dreamweaver and critical thinking.

Edition details

• Publisher: Tolana Publishing
• Publication date: 2011
• Language: English
• ISBN 10: 1935208160
• ISBN 13: 9781935208167
• Binding: Paperback
• Number of pages: 308