Overview

The AutoSum function in Excel is a useful shortcut to help save time in financial modeling. Instead of manually typing "=SUM(...)", you can simply press ALT and = on the keyboard to automatically sum up all numbers in a continuous range. This function works for both vertical and horizontal ranges of numbers.
For financial analysts, the ability to navigate around Excel without the use of mouse could save them a huge amount of time, leaving them with more time performing more complicated analyses!

Share
Reviews Add a review
No reviews yet

More From Corporate Finance Institute®

Browse our top rated business templates. See All
Financial Institution Dividend Discount Model
413
0
The financial institution dividend discount model uses future dividends to find the implied share price. This model is based on…
Loan Payment Calculator
276
0
The loan payment calculator allows users to determine the principal and interest payment each month until the full balance of…
DDM - Excel Dividend Discount Model Template
337
28
The dividend discount model template allows investors to value a company base on future dividend payments. This is based on…
Non-directional trading strategy template Non-directional Trading Strategies Template
329
0
The non-directional trading strategies template allow users to determine the profit when buying options. This template focuses on non-directional strategies…
restructuring financial model template preview 1 Restructuring Financial Model Template
566
0
This restructuring financial model template is used to demonstrate the financial interactions behind the restructuring process. Adjust this model to…
TMT Financial Model Template Preview TMT Financial Model Template
739
0
This TMT financial model template is used to value technology, media, and telecom firms. This model provides a template to…