excel training: how to calculate the product in excel

php editor Banana Excel training teaches you how to calculate points in Excel. Integral is an important calculation method in Excel, which can help users easily analyze and process data. Mastering the method of calculating points allows users to process data more efficiently and improve work efficiency. There are many ways to calculate integrals in Excel. Through training and learning, you will master various methods to make Excel more powerful and practical in your hands.

1. First, we open the excel table and enter two columns of data, as shown in the figure below:

2. Then, in the cell below the product Enter [=H10*I10], and then press the Enter key on the keyboard, and the result will come out, as shown in the red circle in the figure below:

##3. Then, in cell J12, you will find that the lower right corner becomes [ ]. Just hold down the left mouse button and pull down to fill it, as shown by the red arrow in the figure below:

4. We can also use functions to find values. Click the [Formula] button on the menu bar and click [Insert Function], as shown in the red circle in the figure below:

5. In the pop-up box, we select the [product] function and click the [OK] button, as shown below:

6. Then, Select the function parameter, which is the data that needs to be multiplied, and then click OK, as shown in the figure below:

7. Finally, you can see that the result is calculated, select the cell , hold down the left mouse button, and the drop-down filling is completed, as shown in the figure below:

After reading the above operation method, do you think I just performed a simple 7-step operation? It is indeed not difficult to calculate the product of such a long number. You don’t need to do Excel training because the steps are very simple and you can learn it by yourself.

The above is the detailed content of excel training: how to calculate the product in excel. For more information, please follow other related articles on the PHP Chinese website!