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

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

Paperback (18 Nov 2019)

  • $16.13
Add to basket

Includes delivery to the United States

10+ copies available online - Usually dispatched within 7 days

Publisher's 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(R) Excel's(R) best features!

  • Book information

    ISBN: 9781093394832
    Publisher: Amazon Digital Services LLC - KDP Print US
    Imprint: Independently Published
    Pub date:
    Language: English
    Number of pages: 176
    Weight: 284g
    Height: 155mm
    Width: 233mm
    Spine width: 14mm