Black Friday Sale!

Ends in:

Easy Pivot Table in Excel (Auto-Subtotals Feature)

Add to Favorites
Author: | Edits: don
BLACK FRIDAY SALE (65%-80% Off)

Excel Courses Online
Video Lessons Excel Guides

How to make a paired-down version of a Pivot Table for Excel. This allows you to quickly perform calculations on data to see things like: how much of each item was sold, how many items were sold on a specific day, how many items in each category were sold, and much more.

The basic premise of this feature is that you can group similar items together in order to perform calculations on them and you do not need to use a PivotTable in order to do that.

This feature will allow you to quickly summarize sets of data so that you can analyze them and better understand the data.

To make the light version or small version of the PivotTable, we use the Subtotals feature in conjunction with a data sort.

Resources

Subtotals Feature (Microsoft Link)

PivotTable Overview (Microsoft Link)


Downloadable Files: Excel File

Question? Ask it in our Excel Forum


Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons 50+ Hours of Instruction 200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course

Similar Content on TeachExcel
Use a Form to Enter Data into a Table in Excel
Tutorial: You can enter data into a table in Excel using a form; here I'll show you how to do that....
Filter Data to Show the Top 10 Percent of the Data Set in Excel - AutoFilter
Macro: This Excel macro filters a set of data in Excel to display only the top 10 percent of that...
Filter Data in Excel to Show Only the Top X Percent of that Data Set - AutoFilter
Macro: This Excel macro filters a set of data in Excel and displays only the top X percent of tha...
Enter a Constant Value in a Defined Name in Excel - Text, Numbers, Formulas, Etc.
Tutorial: In Excel you can store values in Defined Names.  Often people use a Defined Name to refe...
Easily Compare Duplicate Values in Excel
Tutorial: Here, I'll show you a simple technique to quickly and easily compare large lists of duplic...
Require a Unique List of Numbers in a Range in Excel
Tutorial: I'll show you how to require a user to enter a unique number into a range of cells in Exce...
Tutorial Details
Downloadable Files: Excel File
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course