How to use formulas in excel sheet

As in any office activity, you can make use of the same function through the use of various techniques or modalities. Knowing how to use formulas in Excel, you will notice that this is not the exception, and you can use it in the way that best suits your needs.

Knowing how to use formulas in excel will be a great advantage for you since you will not only have the necessary knowledge to carry out the same activity in different ways, but you will also be able to optimize your time to a great extent. This way, your work will have a highly professional and completely organized final result without any inconvenience.

How to use formulas in excel using the autocomplete method?

When you carry out an office activity and want to know how to use formulas in Excel 2016, you will notice that it can carry out in many ways, including the autocomplete method. By following these instructions, you will know how to use formulas in Excel in a way that is efficient and safe.

1. This time, cell E5 will be used as an example, so once selected, you must enter the formula =D5-C5

2. This way, you will notice that the result of both cells is reflected in cell E5, as follows.

3. A select cell E5 again and drag over the rest of the cells to acquire the same formula reflected in cell E5.

How to use formulas in Excel by applying a shortcut to multiple cells?

This procedure may be ideal for you if you want to know how to use formulas in Excel 2019 quickly and easily. Follow these instructions properly, and you will know how to use formulas in Excel.

Select all the cells where you want to add the same formula.

2. Proceed to write the formula you want. In this case, the formula =D5-C5 will be used as an example.

3. Followed by this, you must keep the CTRL key pressed; without releasing it, you have to press the ENTER key. Following this, you will notice that the formula will successfully apply to the rest of the cells you have selected.

How to use formulas in Excel online using tables?

On many occasions, you may have to use these office activities regardless of the device or interface you are in, so it is not a bad idea to learn how to use formulas in Excel mac online. You have to follow these instructions to get the best possible results without any setbacks.

1. To begin, select any data in the table. After this, press the keys CTRL + T, and a table box will open. This will automatically select all the data found in the sheet. After this, click on the option My header table and click on OK.

2. Go to cell E5 and type the symbol =.

3. Following this, select cell D5, and without performing any other action, type the symbol - to later select cell C5, leaving the formula as shown in the following image.

4. Press the Enter button. And you will immediately notice how the results will be displayed in each selected cell.

Knowing how to use formulas in Excel is extremely useful regardless of the task you have to perform, especially if you continuously need a large number of vital data. Whether you are a finance employee or a student who wants to organize all your activities or expenses, this is ideal. You can use these functions in an extremely varied way to achieve different results that will adapt effectively to your needs.

At WPS Academy, you can find a lot of information and instructions to carry out any office task without inconvenience. So if you want to become a great expert in using these functions, the best thing you can do is read all the available information. In the same way, you can download WPS Office completely free of charge to enjoy all the advantages and tools this data processing software can offer.