Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide

C J Benton

ISBN 10: 1093394838 / ISBN 13: 9781093394832

Editore: Independently Published, 2019

Riguardo questo articolo

This item is printed on demand. New copy - Usually dispatched within 5-9 working days 185.

Codice articolo C9781093394832

Dati bibliografici

• Titolo: Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide
• Editore: Independently Published
• Data di pubblicazione: 2019
• Lingua: Inglese
• ISBN 10: 1093394838
• ISBN 13: 9781093394832
• Rilegatura: Paperback / softback
• Condizione: New
• Peso: 185 grammi

Descrizione articolo

Riassunto

Learn Pivot Tables ~By Example~ - Updated for 2019!

With this practical and to-the-point guide on Pivot Tables and basic Dashboards, you'll develop the skills to build and modify reports with step-by-step examples and screenshots including how to:

Organize and summarize data

Format & filter Pivot Table results

Create Pivot Charts

Display averages & percentages

Group data into predefined ranges

Use Slicers, Timelines, and Sparklines

Rank results

Apply calculated fields

Use Power Query to create and combine 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:

Incorporate Pivot Charts, Sparklines, and performance symbols into your reporting

Refresh and protect your Pivot Table data

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!