Faster than calculators, Excel's powerful statistical power

When it comes to addition, subtraction, multiplication and division, and numerical operations, the first word that comes to mind is "calculator".

The reason is that. Because it is the most familiar computing tool.

Today, the boss asked his cousin to use Excel to calculate a large amount of data.

But the goose. Each cell is not a separate number, but a mixture of addition, subtraction, multiplication and division.

What should I do? My cousin knocked on the table. Hey! Got it!

My cousin picked up the computer and knocked on it.

Let's see how my cousin does it.

👇👇👇

When you need to calculate a lot of data, it is obviously tiring to calculate one by one.

At this point, we need to consider batch computing.

So, how do we achieve batch computing?

Xiao E recommends using the function of [define name] here.

Define a formula as a name, and when you need to reuse this formula, you can use the name directly to simplify the operation process.

The following is the calculation process of the dynamic diagram:

After seeing the moving picture, now let's take a look at the analysis of text and pictures.

First, we select the cell and find [defined name]-[defined name] under the Formula tab.

Then, enter calculation in the name box of the pop-up window

Enter the formula in [reference location]:

= evaluate (A2)

PS: write the cells that need to be calculated in parentheses.

Finally, find the calculation formula you just set in the definition name and double-click to fill it.

Done!

Actually, you know what?

[definition name], in addition to the above operation, there are two more convenient methods:

❶ is located directly in the name box, which is suitable for defining a range of cells.

❷ is created automatically. Select [Formula]-[defined name]-[create according to the selected content], and select it according to your needs.

This article comes from the official account of Wechat: Akiba Excel (ID:excel100), author: witty Qiu Xiao E Editor: Zhu Lan