Learning Pivot Tables/Charts

Use a PivotTable report to summarize, analyze, explore, and present summary data. Use a PivotChart report to visualize that summary data in a PivotTable report, and to easily see comparisons, patterns, and trends.

  1. Dynamic Dashboards using Pivot Tables & Slicers

    Do you know that Excel 2010 makes creation of dynamic dashboards very simple? Yes, that is right. Using slicers feature, you can create d...

  2. Guide to Excel Pivot Tables

    Excel pivot tables are very useful and powerful feature of MS Excel. They can be used to summarize, analyze, explore and present your dat...

  3. What is a Pivot Table and How to Make one

    In this excel pivot tables tutorial we will learn what is a pivot table and how to make a pivot table using Microsoft excel. Excel pivot ...

  4. Use Excel PivotChart to Graph Data

    Fast Charts with Pivot Charting Amber MacArthur, Bill Jelen, Leo Laporte, Andy Walker on the set of Call for Help on TechTV Canada. This ...

  5. Pivot Table 101

    This blog is the video podcast companion to the book, Learn Excel 97-2007 from MrExcel. This is a great tutorial if you are trying to lea...

  6. How to Create and Format a Pivot Chart in Excel

    After you create a pivot table in Excel 2010, you can create a pivot chart to display its summary values graphically. You also can format...

  7. Pivot Table Report Filters

    We all know that Pivot Tables help us analyze and report massive amount of data in little time. Excel has several useful pivot table feat...

  8. Data Analysis Pivot Tables

    The Excel Basics Series shows a systematic description of what Excel can do from beginning to end. Most importantly this video goes over ...

  9. How to Create an Interactive Excel Pivot Chart

    Excel Pivot Table Reports and Excel Pivot Table Charts work "hand-in-hand" to give you the ability to create interactive displays of the ...

  10. Pivot Table Tricks

    Learn Microsoft Excel Pivot table tricks and tips. Know how to drill down pivot tables, slice and dice pivot reports, change summary form...

  11. Pivot Tables examples

    See these 20 Pivot Table examples: 1 Proper Format 2 Understanding Pivot Tables 3 Drag & Drop in 2003 4 Change 2003 to 2007 5 Pivot T...

Continue learning by following more paths or create your own. Join for FREE

By clicking 'Get Started Free' you agree to our Terms of Service and Privacy Policy