This video is taken from my course Excel Analyst
Check out the Course
This video is taken from my course Excel Analyst
Check out the Course

Demo of SUM Function & "Punch Through" Technique

 

Masters the SUM function and save time with punch throughs!

 

SUM is just about the most widely used function in Excel. But it doesn't mean there's nothing to learn. This video looks at the basics of SUM - how we quickly add/select individual cells, multiple cells and ranges of cells, and shortcuts to insert SUM faster.

In the second half of the video we take a look and evaluate the Pros & Cons of a technique called a "Punch-through", which allows us to sum the same cell across many worksheets, often saving us a lot of time.

Along the way we even touch on SUMIFS, one of my Top 5 functions, and how we can sum much more quickly with it, using criteria.