Desktop Application


Go Back   CiteHR Home > Human Resource Section > Talk To Seniors





 
Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 03-12-2007, 05:15 PM
akshita_ashu's Avatar
Join Date: Nov 2007
Location: delhi
Posts: 128
Default How Excel is used in HR Function

Hi, plz help me how Excel is used in HR Function. As I am new in HR,I don't know the usage of Excel in HR Function For what we use it and how we use it to do our work properly... As I know for maintaining data we use Excel,for MIS we use Excel, but plz help me to go deeper in this and how to draw border and Formatting in Excel
Akshita
Sponsors
  #2 (permalink)  
Old 03-12-2007, 06:11 PM
Raghav's Avatar
Join Date: Aug 2006
Location: Chennai
Posts: 1,065
Default Re: Excel

Hi Akshita,

Attaching a document that would help you. Hope it helps

Regards,
~Raghav V

Attached Files
File Type: pdf excel_book_1__134.pdf (478.7 KB, 3754 views)
  #3 (permalink)  
Old 03-12-2007, 06:18 PM
mallet's Avatar
Join Date: Jun 2006
Location: Hyderabad
Posts: 594
Default Re: Excel

Hi Akshita,

Without Excel it would be very difficult to survive in HR. Lot of your day to day activities would include trackers which are excel sheets.


Some of the things that you should be thorough with to maintain data in excel.

1. Formatting - Very important to manage data sheet neatly. Creates an impression!

2. Formula's you need to be thorough with:
1. SUM Function
2. COUNT Function
3. DATE AND TIME FUNCTION
4. Logical Statements like IF and OR
5. VLOOKUP

3. Data Sorting

4. Data Validation


Cheers,

Mallet
  #4 (permalink)  
Old 03-12-2007, 06:33 PM
rahul wagh's Avatar
Join Date: Sep 2007
Location: Pune, India
Posts: 166
Default Re: Excel

Good posting!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!!111
  #5 (permalink)  
Old 03-12-2007, 07:00 PM
Raghav's Avatar
Join Date: Aug 2006
Location: Chennai
Posts: 1,065
Default Re: Excel

My Pleasure Friends.
  #6 (permalink)  
Old 03-12-2007, 07:01 PM
Pragya Tejaswini's Avatar
Join Date: Jan 2006
Location: delhi
Posts: 17
Default Re: Excel

THnaks...

The book is really informative.
  #7 (permalink)  
Old 03-12-2007, 07:05 PM
jayashri's Avatar
Join Date: Oct 2007
Location: chennai
Posts: 174
Default Re: Excel

Hi Raghav,

Thanks for your information. Really helped.

Regards,

R.Niveditha
  #8 (permalink)  
Old 03-12-2007, 07:08 PM
Manju27's Avatar
Join Date: Oct 2007
Location: Hyderabad
Posts: 2,141
Default Re: Excel

Hi Raghav,

Very useful posting..

Keep it up.

Regards,
Manju
  #9 (permalink)  
Old 03-12-2007, 07:08 PM
Raghav's Avatar
Join Date: Aug 2006
Location: Chennai
Posts: 1,065
Default Re: Excel

Always welcome Ms. Niveditha.

Please make use of the "Downloads Search" in the top of the page for any queries.

Regards,
~Raghav V
  #10 (permalink)  
Old 03-12-2007, 07:15 PM
binubabu's Avatar
Join Date: Mar 2007
Location: India
Posts: 951
Default Re: Excel

Good Posting

Thanks

Binu

   Post New Thread  Reply

Similar Topics

Downloads

Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Thread Tags
excel, function

All trademarks and copyrights held by respective owners. Member comments & attachments are owned by the poster.
Privacy Policy | Disclaimer | Terms Of Service