Introduction to Ms Excel for HR day to day operation

Teguh Yoga Raksa ( 2008)

Why Ms Excel important?

• 4Tools in making analysis and presentation
• 4User friendly
• 4Most organizations used this application

General 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

Frequently used functions :

• 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,...)

just do it...learn - Action and Success...(TY)