:"Mastering the Name Manager: Easily define and use cell reference names"-Table skills免费ppt模版下载-道格办公

"Mastering the Name Manager: Easily define and use cell reference names"

```html

Graphic and text skills

Video tutorial (click to watch):

The name manager feature in Excel allows you to customize names to replace cell references, which can make your formulas more convenient and intuitive.

Here are the steps on how to use the name manager:

1. For example, use the SUM function to calculate the total value of two products.

2. Select the product value area, right-click "Customize Name", or click "Formula" - "Name Manager" in the menu bar above.

3. In the name manager window that pops up, click "New", set the name and reference location, and then click "OK".

4. Use the name manager to set the total value of the second product. The operation is the same as above.

5. At this time, use the SUM function to calculate the total value of the two products. Just enter the formula =SUM (total value 1, total value 2) to get the calculation result.

6. Have you learned this practical function?

Articles are uploaded by users and are for non-commercial browsing only. Posted by: Lomu, please indicate the source: https://www.daogebangong.com/en/articles/detail/zhang-wo-ming-cheng-guan-li-qi-qing-song-ding-yi-he-shi-yong-dan-yuan-ge-yin-yong-ming-cheng.html