Excel Usefull Skiller

EXCEL is still a usefull program  Right???????

EXCEL -> Blockchain 

The blockchain will someday eliminate the Excel program.

Before that, Excel will be an important program for the company for about 10 years.

so, Excel Formulas > Name Manager  .   

It's very important skill~!!!!

  

1. you want to select the area    ... for   Name Manager
2. and Enter the Name you would like to......    In black bold border "B4" ~!!!! ex.  i will enter "Com"
3. then you can call this area (Name Manager ,  "Com" ) anytime
    

 Tip: I think that the best of number type is "Times New Roman" ~!!!!!

let's do it the same way.    "a_score",    "b_score",   " c_score"    

a_score : C4:C6 area  /  b_score : D4:D6  /  c_score : E4:E6

ex) mouse select area "E4:E6" and "C_SCORE" appears in the upper left corner.

  

Function be Used as follow~!!!!!

• Why  is "SUM" in the function expression ???

 

The sumif function can get the sum of the conditions I want

and Name Manager view "SUMIF(Com, B9, C_score)"

a score and a Company is 89(C4) + 80(C6) = 166

very easy~!!!!!! excel ability!!!!!!!