Why Ms Excel important?
- 4Tools in making analysis and presentation
- 4User friendly
- 4Most organizations used this application
- 4Security ( Password & Protection ) à Employee data ( Level/Grade , Salary, Promotion data, etc )
- 4Goal Seek
- 4Validation
- 4Sort
- 4Text to Column
- 4Group & Un-group
- 4Freeze / Spilt
- 4Move, copy and delete Sheets in workbook
- 4Filter
- 4Format Cell
- 4VLOOKUP / HLOOKUP -->VLOOKUP(lookup_value,table_array,col_index_num,range_lookup)
- 4RIGHT, LEFT & MID -->RIGHT/LEFT(text,num_chars), MID(text,start_num,num_chars)
- 4IF -->IF(logical_test,value_if_true,value_if_false)
- 4COUNT, COUNTA & COUNTBLANK --> COUNT(value1,value2,...) ; COUNTA(value1,value2,...)
- 4MAX, MIN, MEDIAN & AVERAGE -->MAX(number1,number2,...)
- 4DATE & YEAR àDATE(year,month,day) , YEAR(serial_number)
- 4EXACT -->EXACT(text1,text2)
- 4UPPER / LOWER àUPPER(text)
- 4ROUND, ROUNDUP, ROUNDOWN --> ROUND(number,num_digits) , ROUNDUP(number,num_digits) , ROUNDDOWN(number,num_digits)
- 4CONCATENATE, AND & OR -->CONCATENATE (text1,text2,...), AND(logical1,logical2, ...) , OR(logical1,logical2,...)
Tidak ada komentar:
Posting Komentar