Excel - Most Popular Excel Functions: Episode 1553

4,757 views · Published 26 April 2012 · 4:21 · Indexed 6 November 2026

Channel: MrExcel.com · 2012 · Education

Watch on YouTube

Microsoft Excel Tutorial: Learn Excel: Master the SUM Function and Win a Free Copy of Excel In Depth!

Welcome to the MrExcel podcast. In this episode, we kick off a new series where we dive into some of the most popular Excel calculation functions. But, I need your help! Send an email to [email protected] with your favorite functions like SUM, AVERAGE, COUNT, MAX, MIN, and more. We'll choose one lucky winner on May 5th to receive a copy of my book, "Excel 2010 in Depth", which covers everything you need to know about Excel, including every single function.

First up in our series is the SUM function, which is often the first function people learn when using spreadsheets. But, did you know there are some cool tips and tricks to using this function? Back in 1985, I used to add numbers by typing a plus sign and manually adding each cell. But, an MBA student showed me a better way - using the ADDSUM function (now known as =SUM). This allows you to easily add a range of cells, and even updates automatically when new rows are added.

Speaking of new features, in Excel 2010, when you insert a new row or column in a range that has a SUM formula, the formula will automatically update to include the new cells. This may seem like a small feature, but it can save a lot of time and hassle when working with large datasets. Another time-saving tip is to use the AutoSum button, which can be found on the Formulas tab or the Home tab. But, I prefer to use the shortcut key ALT + = to quickly add a SUM formula to a range of cells.

But, what if you have a range of cells that is not adjacent to your total? No problem! Just use the AutoSum button and then manually select the cells you want to include in the formula. And for those of you thinking, "How boring, he's just talking about AutoSum", don't worry, there's more! Did you know you can use AutoSum to quickly add a total row or column to your data? Just select the cells you want to include, hit AutoSum, and it will automatically add the formula to the entire range.

But, my favorite trick with AutoSum is using it to quickly add totals to blank cells. Just select all the cells in your data, press CTRL + G to bring up the Go To Special menu, choose "Blanks", and then hit AutoSum. This will add a total to every blank cell in your data, saving you time and effort. So, there you have it - the SUM function may seem simple, but it has some powerful features that can make your life easier when working with data in Excel. Don't forget to send in your favorite functions to be featured in future episodes of this series. Thanks for tuning in to the MrExcel podcast, and I'll see you next time!

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 Popular Excel Functions Series
(00:35) Function #1: SUM
(00:49) History of Adding in Excel
(01:13) Introduction to SUM Function
(01:29) Benefits of Using SUM Function
(02:13) Shortcut Key for AutoSum
(02:41) AutoSum Across Multiple Rows and Columns
(03:05) Adding Non-Adjacent Cells
(03:30) Totaling Across and Down
(03:57) Bonus Tip: Totaling Blank Cells
(04:07) 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
AVERAGE function
COUNT function
CTRL + G for Go to Special
Excel functions
MAX function
MIN function
SUM function
Totaling rows and columns


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

You asked for it and here it is: a Learn Excel from MrExcel Podcast Series covering the Most Popular Functions in Microsoft Excel.
Bill will be covering the Most Popular Functions in Excel in the series starting with "=SUM". Follow along with Bill today in Episode #1553 to learn a few tips - including how you can win a free copy of "Microsoft Excel 2010 In Depth" by Bill Jelen.

...This episode is the video podcast companion to the book, "Excel 2010 In Depth", by Bill Jelen a.k.a. MrExcel. http://www.mrexcel.com/store/index.php?l=product_detail&p=189

"The Learn Excel from MrExcel Podcast Series"

MrExcel.com — Your One Stop for Excel Tips and Solutions. Visit us today!

More from this channel