6. Using Insert Function Option from Formulas Tab

1.  Using Insert Function Option from Formulas Tab  

If you want full control of your functions insertion, using the Excel Insert Function dialogue box is all you ever need. To achieve this, go to the Formulas tab and select the first menu labeled Insert Function. The dialogue box will contain all functions you need to complete your analysis.  The Excel shortcut to insert a function is ALT + M + F. The Corporate Finance Institute Excel 

2.  Selecting a Formula from One of the Groups in Formula Tab  

The option is for those who want to delve into their favorite functions quickly. To find this menu, navigate to the Formulas tab and select your preferred group. Click to show sub-menu filled with a list of functions. From there, you can select your preference. However, if you find your preferred group is not on the tab, click on the More Functions option – probably it‘s just hidden there. 

The Excel formula shortcuts are the following: 

Recently used: ALT + M + R 

Financial: ALT + M + I 

Logical: ALT + M + L 

Text: ALT + M + T 

Date & Time: ALT + M + E 

Lookup & Reference: ALT + M + O 

Math & Trig: ALT + M + G 

More Function: ALT + M + Q The Corporate Finance Institute Excel 

4. Using AutoSum Option  

For quick and everyday tasks, AutoSum is your go-to option. So, navigate to the Home tab, in the far-right corner, click the AutoSum option. Then click the caret to show other hidden formulas. This option is also available in the Formulas tab first option after the Insert Function option. 

Alternatively, the Autosum Excel function can be accessed by typing ALT + the = sign in a spreadsheet and it will automatically create a formula to sum all the numbers in a continuous range. 

Step 1: Place the cursor below the column of numbers you want to sum (or to the left of the row of numbers you want to sum). 

Step 2: Hold down the Alt key and then press the equals = sign while still holding Alt. 

Step 3: Press Enter. 

5. Quick Insert: Use Recently Used Tabs  

If you find re-typing your most recent formula a monotonous task, then use the Recently Used menu. It‘s on the Formulas tab, a third menu option just next to AutoSum. The Corporate Finance Institute Excel