WallStreetMojo

WallStreetMojo

WallStreetMojo

MENUMENU
  • Free Tutorials
  • Certification Courses
  • Excel VBA All in One Bundle
  • Login
Home » Excel, VBA & Power BI » Excel Tutorials » Insert Function in Excel

Insert Function in Excel

Excel Insert Function

Insert function is not an actual function in excel instead it is an wizard box provided by excel to help us in finding out the type of function we require in our data, in older versions of excel this function was located in the insert tab however in the newer versions of excel this wizard box is available in the formulas tab by clicking in the FX button provided which is the wizard box for the insert function.

Method #1 – Using Equal To Sign

For sure, we all know all the formulas in excel start with an equal (=) sign in excel, and I think this is what our early excel coach must have taught. Now let’s start with inserting formula in excel with equal sign first.

You can download this Insert Function Excel Template here – Insert Function Excel Template

#1 – Calculations without Inbuilt Formulas

We can use excel as a basic calculator to perform basic calculations without the help of inbuilt formulas. Unlike a calculator, Excel can make the formula dynamic if you are referring the formula to cells, and if you are entering the numbers directly to the formula, it does not make the formula dynamic.

Now take a look at the calculation of 10 + 20 = 30 in excel. Open the equal sign in the cell A1.

Insert Function 1

Type 10+20.

Insert Function 1-1

Now hit the enter button; it will perform the calculation just like your calculator.

Insert Function 1-2

Now we can see the result of 10+20 in the cell A1, and we can see the formula in the formula bar.

#2 – Calculations without Inbuilt Formulas: Based On Cell Values

We have learned how to enter the formula in excel by using equal and supply values directly to the formula itself. Now we will see how to apply formulas for cells.

In cell A1 I have the number 10 & in cell A2, I have the number 20. In cell A3, I want the summation value of these two.

Insert Function 2

Open equal sign in cell A3 and select the A1 cell.

Insert Function 2-1

After selecting the cell A1 type plus (+) sign and select the cell A2.

Insert Function 2-2

Hit enter to see the result of the excel formula.

Popular Course in this category
Sale
All in One Excel VBA Bundle (35 Courses with Projects)
4.9 (1,353 ratings)
35+ Courses | 120+ Hours | Full Lifetime Access | Certificate of Completion
View Course

Insert Function 2-3

This is a dynamic formula because if any change happens in cell A1 & A2, it will impact the cell A3 because A3 cell contains the formula which is completely dependent on A1 & A2 cells.

Method #2 –  Using Insert Function Dialog Box

Example #1 – Excel Built-in Formulas

Take the same example as cell A1 & A2 apply inbuilt SUM function to get the total. In A3, after equal start the letter S, we will get all the formula which starts with S.

Insert Function Example 1

Next, enter the letter U. Now, we will see all the formulas which start with the letters SU.

Insert Function Example 1-1

Like this, we can apply built-in formulas in excel. Remembering 450+ formulas in excel is not an easy task at all, but we can insert formula by using the Excel INSERT FUNCTION option as well.

Insert Function Example 1-2

Click on this fx option to open the INSERT FUNCTION dialogue box.

Insert Function Example 1-3

Here we can search the formula we want to use. If we are not sure which formula to apply, we can enter a brief description of the formula; for example, if I want to SUM cells, I can write sum cells, and it will give me the list of excel formulas.

Insert Function Example 1-4

Once you get the list of recommended formulas, click on the function you want to use.

Insert Function Example 1-5

Now we need to specify which cells we want to use to SUM.

Insert Function Example 1-6

  • Number 1 will be our first number, which is there in the cell A1.
  • Number 2 will be our second number, which is there in the cell A2.

Select both the numbers.

Insert Function Example 1-7

Now look at the options we have; it has opened up one more Number 3 slot to select the third number if any, and also, we can see the resulting review here only.

Insert Function Example 1-8

Click on OK to complete the formula, and we will have a result in the A3 cell.

Insert Function Example 1-9

Example #2 – Using Insert Function Dialog Box

Take a look at one more example. I have four values.

Example 2

In cell B6, I want to calculate the AVERAGE values of the above 4 numbers in cell B2, B3, B4, and B5.

Step 1: Select the cell B6 and click on fx.

Example 2-1

Step 2: Now, we will see the INSERT FUNCTION dialogue box.

Example 2-2

Step 3: Now type AVERAGE in the search box and click on GO; we will see the AVERAGE function.

Example 2-3

Step 4: Select the AVERAGE function. We will see the dialogue box.

Example 2-4

Step 5: Select the first 2 cell values, i.e., B2 & B3. It will open up another cell reference.

Example 2-5

Step 6: Like this, select all the values you want to find the average.

Example 2-6

Now we can see the result preview, what are cells we have selected, and click on OK to complete the formula.

Example 2-7

We have the AVERAGE function is cell B6.

Things to Remember

  • Limit INSERT FUNCTION only for your understanding. Once you are comfortable with formulas, type them directly into the cell.
  • We can INSERT FUNCTION under the FORMULA tab as well.
  • We can INSERT FUNCTION under Auto SUM drop down by clicking on More Functions.
  • The short cut key to INSERT FUNCTION in excel is Shift + F3.

Recommended Articles

This has been a guide to Insert Function in Excel. Here we discuss how to insert formulas and functions in excel using equal to sign and insert function dialogue box along with practical examples and a downloadable excel template. You may learn more about excel from the following articles –

  • Search Box in Excel
  • Insert Page Break in Excel
  • How to Insert New Worksheet in Excel?
  • Insert Date in Excel
0 Shares
Share
Tweet
Share
All in One Excel VBA Bundle (35 Courses with Projects)
  • 35+ Courses
  • 120+ Hours
  • Full Lifetime Access
  • Certificate of Completion
LEARN MORE >>
Primary Sidebar
Footer
COMPANY
About
Reviews
Contact
Privacy
Terms of Service
RESOURCES
Blog
Free Courses
Free Tutorials
Investment Banking Tutorials
Financial Modeling Tutorials
Excel Tutorials
Accounting Tutorials
Financial Statement Analysis
COURSES
All Courses
Financial Analyst All in One Course
Investment Banking Course
Financial Modeling Course
Private Equity Course
Venture Capital Course
Excel All in One Course

Copyright © 2021. CFA Institute Does Not Endorse, Promote, Or Warrant The Accuracy Or Quality Of WallStreetMojo. CFA® And Chartered Financial Analyst® Are Registered Trademarks Owned By CFA Institute.
Return to top

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Book Your One Instructor : One Learner Free Class
Let’s Get Started
Please select the batch
Saturday - Sunday 9 am IST to 5 pm IST
Saturday - Sunday 9 am IST to 5 pm IST

This website or its third-party tools use cookies, which are necessary to its functioning and required to achieve the purposes illustrated in the cookie policy. By closing this banner, scrolling this page, clicking a link or continuing to browse otherwise, you agree to our Privacy Policy

WallStreetMojo

Free Excel Course

Excel functions, Formula, Charts, Formatting creating excel dashboard & others

* Please provide your correct email id. Login details for this Free course will be emailed to you

Login

Forgot Password?

WallStreetMojo

Download Insert Function Excel Template

New Year Offer - All in One Excel VBA Bundle (35 Courses with Projects) View More