Excel -- More on Grouping & Elasticity (feat. Mack Wilk) - Episode 1617
2,931 views · Published 14 December 2012 · 6:10 · Indexed 25 October 2026
Channel: MrExcel.com · 2012 · Education
Microsoft Excel Tutorial: More on Excel Grouping & Elasticity with ModelOff Finalist Mack Wilk. Welcome to another episode of the MrExcel podcast! In this video, we have a special guest, Mack, who will be showing us some amazing tricks with grouping and elasticity in Excel. I have to admit, I have never been able to figure out how to use grouping effectively, but Mack has some great insights that he is going to share with us. Mack starts off by explaining his cascading structure method for constructing financial models. He uses the example of a company's revenues and breaks it down into different products. He then shows us how to use the SUMIF function to calculate the revenues for each product. But here's where it gets interesting - Mack introduces us to the concept of grouping. Grouping allows us to collapse and expand certain sections of our data, making it easier to analyze and present. Mack shows us how to group rows and even create subgroups within groups. He also shares a useful tip on how to change the settings in Excel so that the groups are collapsed from top to bottom, rather than the default bottom to top. This makes it much more user-friendly and visually appealing. But the real game-changer is when Mack shows us how to use grouping in conjunction with the Outline Group feature. This allows us to automatically collapse and expand sections of our data, making it even more efficient and organized. Mack also demonstrates how to use manual grouping, which gives us more control over which sections we want to collapse or expand. I have to say, I am blown away by these grouping techniques and I can't wait to start using them in my own financial models. Thank you, Mack, for sharing your knowledge with us all the way from Poland. And to all our viewers, good luck in tomorrow's ModelOff finals! Don't forget to like, comment, and subscribe for more helpful Excel tips and tricks. See you next time on the MrExcel podcast! Buy Bill Jelen's latest Excel book: https://www.mrexcel.com/products/latest/ You can help my channel by clicking Like or commenting below: https://www.mrexcel.com/like-mrexcel-on-youtube/ Table of Contents: (00:00) Introduction to Grouping in Excel (00:20) Using a Cascading Structure for Financial Models (01:00) Creating Categories and Calculations (02:14) Grouping Rows and Changing Settings (04:27) Creating Subcategories and Linking Data (05:29) Using Manual Grouping to Collapse and Expand Sections (06:00) Clicking Like really helps the algorithm #excel #microsoft #microsoftexcel #exceltutorial #exceltips #exceltricks #excelmvp #freeclass #freecourse #freeclasses #excelclasses #microsoftmvp #walkthrough #evergreen #spreadsheetskills #analytics #analysis #dataanalysis #dataanalytics #mrexcel #spreadsheets #spreadsheet #excelhelp #accounting #tutorial This video answers these common search terms: Changing Excel settings for grouping rows Collapsing and expanding sections in Excel Excel cascading structure for financial modeling Excel grouping tutorial How to create groups inside of groups in Excel Manual grouping in Excel Model Off's finals preparations MrExcel Learns how to Group MrExcel tutorial from Poland Tips and tricks for grouping in Excel Using grouping for automatic subtotals in Excel YouTube video on grouping in Excel Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1153432/ Bill 'MrExcel' Jelen was Live in New York City to Judge the ModelOff Worldwide Excel Championship! And With 16 Excel Rock Stars, from around the Globe, in NYC -- and Bill having access to them all -- why not do some Podcasting On-Site! Bill says. "OK... you caught me. I was completely thrown off yesterday when Mack Wilk started using the Grouping Function in Excel. Today, I get him to explain Grouping again." Follow along with Bill and Mack Wilk in Episode #1617 as they go deeper into the elasticity of Grouping in Microsoft Excel. ModelOff is a worldwide competition to find the best Excel modellers with a $25,000 cash prize. For information on next year's competition, visit http://www.modeloff.com/modeloff-2013/ ...This blog is the video podcast companion to the book, Learn Excel 2007 through Excel 2010 from MrExcel. Download a new two minute video every workday to learn one of the 512 Excel Mysteries Solved! and 35% More Tips than the previous edition of Bill's book! http://www.mrexcel.com/learn2010/LE2010.html "The Learn Excel from MrExcel Podcast Series" Visit us: MrExcel.com for all of your Microsoft Excel Needs!
More from this channel
-
2:13
Excel Calculate Decimal Hours from two Time Cells - Episode 902
-
3:57
Excel 2007 - Color of Selected Sheets is too much like unselected sheets - Episode 907
-
2:48
Excel - Adding Equals Icon to Excel QAT - Build Formula with Mouse - Episode 911
-
3:30
Excel Grouping Percentages into Buckets for a Pivot Table - Method 2 - Episode 913
-
2:04
Excel Change Color of Selected Cells - Episode 914
-
4:38
Excel - Auto Numbering a List with Frequent Inserts & Deletes - Episode 916
-
2:00
Excel Hiding Data in Plain Site - Episode 919
-
2:20
Excel - Bring Back The Full Excel 2003 Dialogs In Excel! - Episode 920