DATA INSIGHT TRAINING
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog

10 Facts about Excel Pivot Tables

1/8/2018

0 Comments

 
Picture
Many people worry that creating a PivotTable is time consuming, but if you have a well-organised data source, you can create a PivotTable in a snap.
Picture
Tables and PivotTables are a great match!  When you use a table as source data for a PivotTable, Excel will automatically expand and shrink the table as you add or remove data, so your PivotTable will always stay in sync with your data.

Picture
You might think you have to be working with numbers to use a PivotTable but, by default, a PivotTable will count any text field.
Picture
When you've created a PivotTable from data in the same worksheet, you can remove the data if you like and the PivotTable will continue to function.  Each PivotTable has a pivot cache that contains an exact duplicate of the data used to create the PivotTable.
Picture
Although PivotTables can automatically group data in many ways, you can also group items manually.
Picture
One of the most powerful features of PivotTables is the ability to group data by numbers.  You can use this feature to group by age range, price range, or any numerical range that makes sense in your data.
When you add fields to a PivotTables, the PivotTable will display the name that appears in the source data.  Value field names appear with "Sum of" or "Count of" at the start.
Picture
It may seem counterintuative, but you can add the same field to a PivotTable more than once.  In fact, there are situations where you'll want to do just that.
Picture
Anytime you add a value field to a PivotTable, make sure you set the number format on the field itself.
Picture
Anytime you see a subtotal or grand total in a PivotTable, you can easily get to the exact data that makes up that value using the "drill down" feature built in to any PivotTable.
0 Comments



Leave a Reply.

    Categories

    All
    Business Data Analysis
    Complete Introduction To
    Coronavirus
    Data Skills
    DAX
    Excel Dashboards
    Excel Formulas
    Gartner Report
    Inspiration & Motivation
    Pivot Tables
    Power BI
    Power BI Desktop
    Power BI Query Editor
    Power BI Services
    Power Map
    Power Pivot
    Power Query
    Power View
    Tables & Reports

    Archives

    April 2020
    March 2020
    February 2020
    January 2020
    December 2019
    November 2019
    October 2019
    September 2019
    August 2019
    July 2019
    June 2019
    May 2019
    April 2019
    February 2019
    January 2019
    December 2018
    November 2018
    October 2018
    September 2018
    August 2018
    July 2018
    June 2018
    May 2018
    April 2018
    February 2018
    January 2018
    December 2017
    November 2017
    October 2017
    September 2017
    August 2017
    July 2017
    June 2017
    May 2017

Privacy Policy
Copyright datainsighttraining.com
info@datainsighttraining.com
+44 330 223 5910
  • Home
  • On-Site Training
    • Power BI Master Class
    • Excel BI Boot Camp
    • Interactive Dashboards with Excel Pivot Tables
  • Online & Virtual Training
    • Our Courses
    • Affiliate Courses
  • About Us
  • Blog