Summarizing Data in Excel Using Subtotals
This is the 4th of a five-part series on Summarizing Data
This week, I will cover Subtotals, Remove Duplicates, Advanced Filter, Consolidate, & Pivot Tables
How to summarize with Consolidate:
1. Select a top-left corner cell in a blank area of your worksheet
2. Data, Consolidate. Specify D1:H564. Choose Top Row, Left Column OK
This is the 4th of a five-part series on Summarizing Data
This week, I will cover Subtotals, Remove Duplicates, Advanced Filter, Consolidate, & Pivot Tables
How to summarize with Consolidate:
1. Select a top-left corner cell in a blank area of your worksheet
2. Data, Consolidate. Specify D1:H564. Choose Top Row, Left Column OK
Transcript of the video:
Learn Excel from MrExcel Podcast, Episode 2190: Summarize with Consolidate.
Hey, this is our fourth attempt at our Summarize Data week, this one is so old I remember doing this back in, like, 1993, even.
The Consolidate command.
And it's going to be the surprise winner, so far, because it is easy and fast.
We're going to click here-- this is click number one-- in J1, a blank section.
Everything below this, to the right of this, should be blank.
Click number two, Data; click number three, Consolidate.
They default to Function Sum, that's great.
For my reference, I'm going to click in D1-- that's four; Ctrl+Shift+Down, five; Ctrl+Shift+Right, six; top row, seven; left column, eight-- okay, nine, and there is a hard result-- nine clicks.
It's going to drive me crazy that Customer’s not there, so I guess ten.
Ctrl+C, eleven; twelve, Ctrl+V paste.
Done.
What a fast, fast way to create that report.
No subtotals, no Remove Duplicates, no Advanced Filter.
Consolidate, of course, is in this book, MrExcel, The 54 Greatest Tips of All Time-- MrExcel LIVe.
That's the Roman numeral for 54 with a little "e" on the end.
This is what I use in my live Power Excel seminars as I travel around the country.
Click the "I" on the top right-hand corner for more information about that book.
Alright, this is our fourth of a five part series on Summarizing Data-- Consolidate.
Easy.
Select the top left corner in a blank area of your worksheet; Data; Consolidate; specify the input range; choose Top row and left column; click OK; and you're essentially done.
Maybe copy the Customer heading over, or just type Customer-- whichever you want to do.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
Hey, this is our fourth attempt at our Summarize Data week, this one is so old I remember doing this back in, like, 1993, even.
The Consolidate command.
And it's going to be the surprise winner, so far, because it is easy and fast.
We're going to click here-- this is click number one-- in J1, a blank section.
Everything below this, to the right of this, should be blank.
Click number two, Data; click number three, Consolidate.
They default to Function Sum, that's great.
For my reference, I'm going to click in D1-- that's four; Ctrl+Shift+Down, five; Ctrl+Shift+Right, six; top row, seven; left column, eight-- okay, nine, and there is a hard result-- nine clicks.
It's going to drive me crazy that Customer’s not there, so I guess ten.
Ctrl+C, eleven; twelve, Ctrl+V paste.
Done.
What a fast, fast way to create that report.
No subtotals, no Remove Duplicates, no Advanced Filter.
Consolidate, of course, is in this book, MrExcel, The 54 Greatest Tips of All Time-- MrExcel LIVe.
That's the Roman numeral for 54 with a little "e" on the end.
This is what I use in my live Power Excel seminars as I travel around the country.
Click the "I" on the top right-hand corner for more information about that book.
Alright, this is our fourth of a five part series on Summarizing Data-- Consolidate.
Easy.
Select the top left corner in a blank area of your worksheet; Data; Consolidate; specify the input range; choose Top row and left column; click OK; and you're essentially done.
Maybe copy the Customer heading over, or just type Customer-- whichever you want to do.
I want to thank you for stopping by, we'll see you next time for another netcast from MrExcel.
