3 Ways to Insert using Excel.

Jefferies Jiang
2 min readOct 27, 2021

Excel’s Basic Terms
In Excel, there are two primary methods for performing calculations: formulas and functions.

Formulas are number one.
A formula in Excel is an expression that works with values in a range of cells or a single cell. For example, =A1+A2+A3 calculates the sum of the values in cells A1 through A3.

2. Functions
In Excel, functions are predefined formulas. They do away with the time-consuming manual entering of formulas by providing them human-friendly labels. =SUM, for example (A1:A3). The function adds up all of the values in the range A1 to A3.

Five Time-saving Ways to Insert Data into Excel

There are five typical ways to insert basic Excel formulas while evaluating data. Each technique has its own set of benefits. As a result, before we get into the core formulas, let’s go through those ways so you can set up your preferred workflow right away.

1. Simple insertion: Typing a formula inside the cell

Inserting basic Excel formulas is as simple as typing a formula in a cell or using the formula bar. Typically, the procedure begins with an equal sign followed by the name of an Excel function.
Excel is clever in that it displays a pop-up function indication as you start typing the function name. You’ll choose your preference from this list. Do not, however, press the Enter key. Instead, press the Tab key to continue inserting further options. Otherwise, you can get an invalid name error, which looks like ‘#NAME?’. Simply select the cell again and complete your function in the formula bar.

2. Using the Formulas Tab’s Insert Function Option
The Excel Insert Function dialogue box is all you need if you want complete control over your function insertion. To do so, go to the Formulas tab and pick Insert Function from the first selection. All of the functions you’ll need to do your financial analysis will be available in the dialogue box.

Using the AutoSum feature
The AutoSum function is your go-to tool for short and everyday jobs. So, go to the Home tab and choose the AutoSum option in the far-right corner. Then click the caret to reveal more formulas that were previously concealed. This option is also available after the Insert Function option in the Formulas tab.

Links:

https://support.microsoft.com/en-us/office/overview-of-formulas-in-excel-ecfdc708-9162-49e8-b993-c311f47ca173

--

--