Excel Forum
Similar Content
RATE Function - Calculate an Interest Rate in Excel
Tutorial: The Rate function in Excel (RATE) calculates the interest rate for a financial transaction...
Convert Column Number to Letter Using a Formula in Excel
Tutorial: How to get a column letter from a number in Excel using a simple formula. This is an ...
Loop through a Range of Cells in Excel VBA/Macros
Tutorial: How to use VBA/Macros to iterate through each cell in a range, either a row, a column, or ...
Excel VBA Course
Excel VBA Course - From Beginner to Expert

200+ Video Lessons
50+ Hours of Video
200+ Excel Guides

Become a master of VBA and Macros in Excel and learn how to automate all of your tasks in Excel with this online course. (No VBA experience required.)

View Course




Excel Basics #7: Range Functions


The Excel Basics Series shows a systematic description of what Excel can do from beginning to end.
#7 Video topics:
1)See how a range function is more efficient than a formula without a range function
2)=SUM(A13:A18) is better than =A13+A14+A16+A17+A18+A19
3)Insert a row and the range function will automatically update





Got a Question? Ask it Here in the Forum.