2-11: Use AutoSum to apply an AVERAGE, MAX, MIN or COUNT function.
This lesson teaches how to use AutoSum to quickly apply the AVERAGE, MAX, MIN or COUNT function to a selected range of cells. There's also a Sample File to enable you to work along with the lesson (download link at the beginning of the video) just like with all other video lessons from The Smart Method®.
You'll also learn how to change the cell range that an existing AutoSum function references. Along the way you'll learn how to use the F2 key to display an AutoSum marquee (sometimes called the AutoSum "marching ants") work.
This video comes from the "Doing Useful Work with Excel" session (Session 2 in our YouTube Excel Essential Skills free video training course).
You'll find the lessons in this session easier with our free e-book: https://thesmartmethod.com/Excel-free...