Dear kanchwala.insiya, the aspect which you wish to learn is vibrant and requires a constant work out. Your realization of learning these skills which are mandate for you is appreciated, I have a huge data base to share the concepts and examples, but all it works perfect only if you can implement in your actual day to day work. Therefore you can post your query or a sample work on to
or can post your issue on www..jsriram.in
or can call me also on 9010352384. as an HR you must be operating [a] attendance, [b] payroll [c] data compiling [d] leaves portal, etc., all this will be made easy to work on in EXCEL, therefore as requested if you post your specific requirement either on to the id's provided or on to this site, which will enable is to provide you the accurate solution and you can carry on from it. other wise if a formula posted like =VLOOKUP(lookup_value,table_array,col_index_num,ra nge_lookup) this will be a big bouncer to you and will be of no use until you expertise each and every element of this. Hope am clear and expect a revert on to this.