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

Livre 2 sur 3: The Excel 2019 Step-By-Step Series

Benton, C.J.

 
9781093394832: Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide
Couverture souple
ISBN 10 : 1093394838 ISBN 13 : 9781093394832
Editeur : Independently published, 2019

Synopsis

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!

    • Les informations fournies dans la section « Synopsis » peuvent faire référence à une autre édition de ce titre.

    Éditeur
    Independently published
    Date d'édition
    2019
    Langue
    anglais
    ISBN 10 
    1093394838
    ISBN 13 
    9781093394832
    Reliure
    Broché
    Nombre de pages
    174
    Coordonnées du fabricant
    non disponible
    Personne responsable
    non disponible