Please note: In order to keep Hive up to date and provide users with the best features, we are no longer able to fully support Internet Explorer. The site is still available to you, however some sections of the site may appear broken. We would encourage you to move to a more modern browser like Firefox, Edge or Chrome in order to experience the site fully.

Supporting your high street Find out how »
Excel 2019 Pivot Tables & Introduction To Dashboards The Step-By-Step Guide, Paperback / softback Book

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

Paperback / softback

Available to Order - This title is available to order, with delivery expected within 2 weeks

Description

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!

    • Information

    £10.99

    Available to Order - This title is available to order, with delivery expected within 2 weeks
    Add to Basket
    Sign in to add to wishlist
     
    Free Home Delivery

    on all orders

     
    Pick up orders

    from local bookshops

    Information