Excel Pivot Tables & Introduction To Dashboards The Step-By-Step Guide (Paperback)

C.J. Benton

ISBN 10: 1541343212 / ISBN 13: 9781541343214

Published by Createspace Independent Publishing Platform, 2017

About this Item

Paperback. Learn how to create Pivot Tables quickly and easily with this step-by-step guide!Updated for Microsoft(R) Excel(R) 2016! This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards. **Version 2019 is now available**Organize and summarize dataFormat & filter Pivot Table resultsCreate Pivot ChartsDisplay averages & percentagesGroup data into predefined rangesUse SlicersRank resultsApply calculated fieldsCreate Pivot Table reports from imported filesAnd more!In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting. A great resource for: Business AnalystsData AnalystsFinancial AnalystsAdministrative and Support staffImagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft(R) Excel's(R) best features! Shipping may be from our UK warehouse or from our Australian or US warehouses, depending on stock availability.

Seller Inventory # 9781541343214

Bibliographic Details

• Title: Excel Pivot Tables & Introduction To Dashboards The Step-By-Step Guide (Paperback)
• Publisher: Createspace Independent Publishing Platform
• Publication Date: 2017
• Language: English
• ISBN 10: 1541343212
• ISBN 13: 9781541343214
• Binding: Paperback
• Condition: new

About this title

Synopsis

Learn how to create Pivot Tables quickly and easily with this step-by-step guide!
Updated for Microsoft® Excel® 2016! This book provides easy to follow step-by-step examples with screenshots demonstrating how to create Pivot Tables and basic Dashboards.

**Version 2019 is now available**

• Organize and summarize data
• Format & filter Pivot Table results
• Create Pivot Charts
• Display averages & percentages
• Group data into predefined ranges
• Use Slicers
• Rank results
• Apply calculated fields
• Create Pivot Table reports from imported files
• And more!

In addition to the above, you will also learn how to create, format, and update a basic Dashboard using Pivot Table data. Including how to incorporate charts and performance symbols into your reporting.

A great resource for:

• Business Analysts
• Data Analysts
• Financial Analysts
• Administrative and Support staff

Imagine the time you'll save by not having to search the internet or help files to learn the most practical ways of using one of Microsoft® Excel’s® best features!