Banner Image

All Services

Business & Finance

Excel: Pivot Tables and Pivot Charts

$10/hr Starting at $25

When you are faced with a large set of data, say in a worksheet or database query, it can be a challenge to get the information you want from that data. Excel Pivot Tables and Pivot Charts are a great way to get information flexibly, interactively and at the click of your mouse. Once a Pivot Table is set up, users can view the data in different ways, adding or removing fields, sorting or filtering and adding subtotals and averages to get precisely the view they need. Pivot Charts add a further dimension, allowing the user to get a graphic view of the information in just the same way. The Pivot Table can also be linked to the data, so that as new data is added the Pivot can automatically refresh. The example I have attached was built for a ticketing company with multiple venues and performance sites. Each day the Pivot Table was refreshed to give the user the latest days sales. With a couple of clicks, different venues could be selected and or different dates and times.

About

$10/hr Ongoing

Download Resume

When you are faced with a large set of data, say in a worksheet or database query, it can be a challenge to get the information you want from that data. Excel Pivot Tables and Pivot Charts are a great way to get information flexibly, interactively and at the click of your mouse. Once a Pivot Table is set up, users can view the data in different ways, adding or removing fields, sorting or filtering and adding subtotals and averages to get precisely the view they need. Pivot Charts add a further dimension, allowing the user to get a graphic view of the information in just the same way. The Pivot Table can also be linked to the data, so that as new data is added the Pivot can automatically refresh. The example I have attached was built for a ticketing company with multiple venues and performance sites. Each day the Pivot Table was refreshed to give the user the latest days sales. With a couple of clicks, different venues could be selected and or different dates and times.

Skills & Expertise

ExcelPivot ChartsPivot Tables

Related Work Collections

4 Reviews

  • Nathan 115

    Nathan 115 says,

    Paul is great to work with. Not only was he very professional, but cordial, as well. And, he more than helped me, but taught me a few tricks, as well. Highly recommended!

    for Excel Sheet on May 17, 2016

  • Phil 60

    Phil 60 says,

    Paul did an excellent job helping me format Excel charts for a presentation. I will definitely use him again.

    for Help with two charts on Apr 01, 2016

  • gflory

    gflory says,

    Excellent grasp of the software and my specific Excel workbook needs. Provided recommendations for improvement that I will be implementing

    for excel spreadsheet update on Dec 18, 2015

  • Jacob_Weiss1

    Jacob_Weiss1 says,

    Paul is a very talanted person, his work was excellent, with not having to explain too much.

    for Excel List Maintanence on Mar 09, 2015