Look Who it Was Random video

Excel - Mastering Pivot Tables: Solving Impossible Data Challenges in Excel - Episode 967

2,305 views · Published 10 March 2009 · 2:55 · Indexed 29 October 2026

Channel: MrExcel.com · 2009 · Education

Watch on YouTube

Microsoft Excel Tutorial:  Mastering Pivot Tables: Solving Impossible Data Challenges in Excel.

Welcome back to the MrExcel netcast! In this video, we're going to tackle the challenge of analyzing massive amounts of data. How are we going to do this? By using a pivot table, of course! But here's the twist - we're going to show you how to solve a problem that may seem impossible at first glance. So, let's dive in and see if you can keep up with this Excel challenge.

But before we get started, I have to give a shoutout to my friend and fellow Excel expert, Mike "ExcelIsFun" Girvin. If you're a fan of this podcast, you need to check out his YouTube channel for even more amazing Excel tips and tricks. And speaking of amazing, check out this cool gift that Mike gave me - a boomerang from his own line! Did you know that Mike is a five-time world record holder in boomerangs? And to top it off, we discovered that we both know the same boomerang expert, David Beim. What a small world!

Now, let's get back to Excel. In this video, we're going to show you a handy trick for totaling subtotaled data. You may have a table with numbers and sums scattered throughout, and you need to come up with a total of all the records excluding the sums. But since they're not subtotals, you can't use the SUBTOTAL function. So, what's the solution? Well, I suggested dividing the whole range by 2, but my friend and Excel MVP, Bob "ExcelisFun" Umlas, blew me away with his method. By simply double-clicking the AutoSum button, he was able to write a formula that grabbed all of the totals. Now, that's what I call Excel magic!

And speaking of magic, have you checked out Bob's book, "This Isn't Excel, It's Magic"? It's available in both red and blue versions, updated for Excel 2007 and 2003 respectively. And a big thank you to Mike Girvin for bringing some fun to the MVP summit and for his upcoming book on Excel. He truly is an exciting guy and a wealth of knowledge when it comes to Excel.

Well, that's all for now from the MVP summit in Seattle. I hope you enjoyed this netcast and learned something new. Don't forget to subscribe to our channel for more Excel tips and tricks, and we'll see you next time for another netcast from MrExcel. Thanks for watching!

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/


Bob Umlas from the Excel Magic book passed on another amazing tip to me at the Microsoft Summit. If you need to add a total to data that was subtotaled using SUM formulas, you can do it in 1 double-click. Episode 967 shows you how.

Table of Contents:
(00:00) Introduction to MrExcel netcast with Bill Jelen 
(00:14) Recap of previous netcasts and recommendation to check out ExcelIsFun on YouTube 
(00:37) Introduction to Michael and his boomerang skills 
(00:55) Recap of past tips and plans for the day at the summit 
(01:05) Bob Umlas shares a tip for summing numbers in a range 
(01:44) Using the AutoSum button to quickly write a formula 
(02:01) Recommendation to check out Bob's book "This Isn't Excel, It's Magic" 
(02:11) Recap of the day and thanks to Mike Gel Girvin 
(02:27) 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:
AutoSum button
Bob's book This Isn't Excel, It's Magic
Boomerangs
Excel 2007 and Excel 2003 versions
Excel MVPs
Excel tips and tricks
ExcelIsFun YouTube channel
Mike Gel Girvin
MVP summit in Seattle
Pivot table analysis
Summing numbers

Join the MrExcel Message Board discussion about this video at https://www.mrexcel.com/board/threads/1152258/



This video is the podcast companion to the book, Learn Excel 97-2007 from MrExcel. Download a new two minute video every workday to learn one of the 377 tips from the book!

More from this channel