Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide (The Excel 2019 Step-By-Step Series) - Softcover

Buch 2 von 3: The Excel 2019 Step-By-Step Series

Benton, C.J.

 
9781093394832: Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide (The Excel 2019 Step-By-Step Series)

Inhaltsangabe

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!

  • Die Inhaltsangabe kann sich auf eine andere Ausgabe dieses Titels beziehen.