Excel Usefull Skiller

in #excel7 years ago
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!!!!!!!

Coin Marketplace

STEEM 0.17
TRX 0.16
JST 0.029
BTC 74302.19
ETH 2658.52
USDT 1.00
SBD 2.42