Posts tagged "Excel"

Excel Formula Sheet

I am attaching herewith the excel formula sheet. Please go through and let me know your valuable inputs.

 

Function keys in Microsoft Excel
Function Key SHIFT CTRL ALT CTRL+SHIFT ALT+SHIFT
F1 Display Help or the Office Assistant What’s This? Insert a chart sheet Insert a new worksheet
F2 Edit the active cell Edit a cell comment Save As command Save command
F3 Paste a name into a formula Paste a function into a formula Define a name Create names by using row and column labels
F4 Repeat the last action Repeat the last Find (Find Next) Close the window Exit
F5 Go To Display the Find dialog box Restore the window size
F6 Move to the next pane Move to the previous pane Move to the next workbook window Move to the previous workbook window
F7 Spelling command Move the window
F8 Extend a selection Add to the selection Resize the window Display the Macro dialog box
F9 Calculate all sheets in all open workbooks Calculate the active worksheet Minimize the workbook
F10 Make the menu bar active Display a shortcut menu (right click) Maximize or restore the workbook window
F11 Create a chart Insert a new worksheet Insert a Microsoft Excel 4.0 macro sheet Display Visual Basic Editor
F12 Save As command Save command Open command Print command

2 comments - What do you think?
Posted by Hrformats - October 13, 2012 at 2:32 PM

Categories: HR   Tags: , ,

Budget Planner

Use our budget planner in Excel to work out what you are spending your money on and compare this with your income.

Instructions
You may move from worksheet to worksheet by clicking on the dark blue buttons
located at the top of each worksheet or the blue tabs at the bottom of this workbook.
Enter data in only the white cells with gray borders:
Use the drop down boxes                            to chart different time periods (Current Month, Prior Month, Yearly, Jan, Feb, etc.)
Quick Budget
Create a quick and easy budget by filling out the white cells on the “Quick Budget” sheet.  Enter the “Frequency” by using the drop down menu
provided in each cell.  The Monthly/Yearly figures are calculated for you and compared to your Tracking (actual) figures on the “Comparison” sheet.
Make sure “Use this budget for comparison purposes” is selected. (If this box is not selected, the “Budget By Month” figures will be used for
comparison purposes instead.)
Budget by Month
Use the “Budget By Month” sheet to create a budget with greater detail.  Select your first budget month by using the drop down box in
the “Income” section.  To unhide future months, click the grey button at the top of the sheet labeled “Click here then Ctrl+Shift+0”.
Make sure “Use this budget for comparison purposes” is selected if you are building ‘a budget by month.  (If this box is not selected,
the “Quick Budget” sheet figures will be used for comparison purposes instead.)
Tracking
Use this sheet to track your actual income and spending.  Select your first tracking month by using the drop down box in the “Income” section.
These figures will be compared to your budgeted figures on the “Comparison” page.
Comparison
Use this sheet to monitor how well you are sticking to your budget.  Compare different time periods by using the drop down box above the
“Income” section
Daily Spending
We’ve provided this sheet for those interested in tracking their spending on a daily basis.  This simple record goes a long way in helping
you stick to your budget.

 

Click Here To Download Daily Expense Manager Excel

Be the first to comment - What do you think?
Posted by Hrformats - October 1, 2012 at 6:59 AM

Categories: HR   Tags: , , ,

Format for Keeping Stocks of Stationery and Housekeeping Items

I have attached format for keeping stocks of stationery and housekeeping items. You can modify as per needs and can be used for your purpose.

SL. No Material Brand Packet Pieces  Existing Stock New Order Total Stock Consumption Week 1 Consumption Week 2 Consumtion Week 3 Consumtion Week 4 Balance Stock
1 Awl Pin PKT 100 1 1 0 0 0 1
2 Binder Clip 19MM PKT 12 9 9 1 0 0 8
3 Binder Clip 25MM PKT 12 5 5 0 0 0 5
4 Binder Clip 32MM PKT 12 5 5 0 0 0 5
5 Binder Clip 41MM PKT 12 5 5 0 0 0 5
6 Brown Tape 2″ Roll 10 5 5 1 3 0 1
7 Camel Board Marker PCS 13 13 1 2 1 9
8 Camel Gel Pen PCS 4 50 54 5 10 5 34
9 Camel OHP Marker PCS 7 7 0 0 1 6
10 CD Mailer PCS 70 70 6 2 0 62
11 Cello Tape 1″ PCS 4 12 16 2 2 2 10
12 Cello Tape 2″ PCS 7 7 1 2 2 2
13 Century A4ST I Laser Sti PKT 100 1 5 6 0 0 2 4
59 Clock PCS 0 0 0 0 0 0
14 Cobra File PCS 20 20 2 0 0 18
15 Copy PowerA-4 Paper RIM 500 5 25 30 4 3 5 18
16 Corporate Push Pin PKT 100 4 4 0 0 0 4
17 Double Side Tape 1” PCS 2 2 0 0 0 2
18 Envelop 10*12 Lemina PCS 0 0 0 0 0 0
19 Envelop 8*10 Cloth PCS 35 35 2 0 0 33
20 Faber Cassle Ball PE PCS 58 58 7 10 10 31
21 Falcon 1/4 Spiral PA PCS 7 7 4 0 0 3
22 Falcon 1/6 Spiral PA PCS 25 10 35 4 0 4 27
23 Fevi Quick PCS 3 3 0 0 0 3
24 Gift Paper PCS 0 0 0 0 0 0
25 Glue Stic PCS 19 19 2 2 0 15
60 Hans Slip Pad PCS 100 6 6 0 0 0 6
26 Highliter PCS 25 25 0 0 1 24
58 ID Card Holder PCS 59 59 6 0 2 51
27 Index File  24T Big PCS 0 20 20 0 20 0 0
28 Kangaroo Punch 480 PCS 0 0 0 0 0 0
29 Kangaroo Punch 600 PCS 0 0 0 0 0 0
30 Kangaroo Stapler 10D PCS 6 6 0 0 0 6
31 Kangaroo Stapler 45N PCS 3 3 0 0 0 3
32 Kores Carbon Blue SA PKT 100 1 1 0 0 0 1
33 Loxur Sketch Pen Set SET 12 1 1 0 0 0 1
34 Magha Punchless File PCS 38 38 5 3 0 30
35 Megnet For White Board PCS 42 42 0 0 0 42
36 Moser Baer 100CD SPINDEL PKT 100 3 3 0 0 1 2
37 Moser Baer DVD10 SPINDEL PKT 10 2 2 0 0 0 2
38 My Clear Bag PCS 14 14 0 2 0 12
39 Natraj Erazer PCS 0 0 0 0 0 0
40 Natraj Pencil PCS 24 24 10 0 0 14
41 Natraj Shapner PCS 7 7 0 0 0 7
42 Omega Tape Dispenser PCS 1 1 0 0 0 1
43 Pepar Cutter Medium PCS 6 6 1 1 0 4
44 Post IT Pad 2*3 PKT 100 9 9 0 0 1 8
45 Post IT Pad 3*3 PKT 100 6 6 0 0 0 6
46 Post IT Promt PCS 10 0 0 0 0 0
47 Scale Star PCS 6 6 0 0 0 6
48 Scale Steel 1FT PCS 8 8 0 0 0 8
49 Scholer Colour Drawing Pin PKT 100 1 1 0 0 0 1
57 Seperatus Card Sheet PCS 10 10 10 0 0 0 10
50 Solo CD Zipper 96CD PCS 0 0 0 0 0 0 0
51 Stapler Pin 24/6 PKT 1000 9 9 0 0 0 9
52 Stapler Pin No 10 Kan PKT 1000 6 20 26 2 3 3 18
53 Torch With Cell PCS 0 0 0 0 0 0 0
54 Visiting Card 240 CR PCS 2 2 0 0 1 1
55 White Fluid Pen PCS 3 3 3 0 0 0 3
56 World L Sharp Folder PCS 15 18 18 0 0 0 18
61 World Milky Folder PCS 45 45 3 1 0 41
62 Megha Report File PCS 5 5 0 0 0 5
63 World Ring File PCS 1 1 0 0 0 1
64 Register 180 Page Falcon PCS 0 5 5 1 0 0 4
65 Register Inward R/B PCS 0 1 1 1 0 0 0
66 Numex Ink PCS 0 2 2 2 0 0 0
0
0
0
0
0

 

Click Here To Download Excel Format For Stationery & Housekeeping

 

Housekeeping Job Card Format Sample
When you have a good number of housekeeping staff working for you, it is extremely important to manage their working in which housekeeping job card format plays a significant role.

Search Sample Formats:

3 comments - What do you think?
Posted by Hrformats - August 29, 2012 at 4:54 AM

Categories: HR   Tags: , , , , ,

Pay Roll Software in Excel

This Excel based Pay Roll software is more useful to all West Bengal Govt employees or West Bengal Govt Concerned who are prepared the Pay Bill as manually. This Excel Based Pay Roll Software can Prepare at a time the Employees Pay Inner Sheet + Pay Outer Sheet + GPF Schedule + Bill Extract + all the Papers as required by the Treasury Office for payment of Salary of Govt Employees.

Click Here To Download Pay Roll Software in Excel for W.B.Govt Employees

Be the first to comment - What do you think?
Posted by Hrformats - July 24, 2012 at 6:53 AM

Categories: HR   Tags: , , , , , , ,

Employee Office in And Out Time Excel Sheet

I have Attached Employee Office in And Out Time Excel Sheet 

Note –  when employee come office, put cursor in related employee office in time cell and click on  red “office in time button” when employee left office , put cursor in related employee office out time cell and click on  blue “office out time button”

Sr No Name Of Employee Office In Time   Office Out Time 1 PATEL JITENDRA 10:37:34 PM   10:39:09 PM 2 PATEL NIRAJ 10:43:39 PM   10:44:08 PM 3 RAVAL JAIVIK 10:47:56 PM   10:48:13 PM 4 SONI SACHIN       5         6         7

 

Click Here To Download Employee Office in And Out Time Excel Sheet

1 comment - What do you think?
Posted by Hrformats - July 17, 2012 at 4:31 AM

Categories: HR   Tags: , , , , , , ,

FIFO Formula in Excel Sheet for Inventory Valuation

Attached herewith Inventory valuation done in FIFO in excel sheet.

BALANCE
Sl.No. Qty. Rates Rs. QTY Rs.
1 0 6 0 TOTAL Balance 250 1875
2 0 7 0
3 0 8 0
4 250 7.5 1875
5 0 0 0
6 0 0 0
7 0 0 0
8 0 0 0
9 0 0 0
10 0 0 0
11 0 0 0
12 0 0 0
13 0 0 0
14 0 0 0
15 0 0 0
16 0 0 0
17 0 0 0
18 0 0 0
19 0 0 0
20 0 0 0

 

Click Here To Download FIFO in Excel Sheets

Search Sample Formats:

1 comment - What do you think?
Posted by Hrformats - June 9, 2012 at 5:08 AM

Categories: HR   Tags: , , ,

Sample HR Audit Sheet

I have attached HR audit sheet in excel format.

 

HR AUDIT – Process Chart
Sr.No Detail Content Obtain Marks Total Marks Remark
1 Appointment Letter Designation 2
Date of Joining 2
CTC 2
2 Offer Letter Date of Joining 2
Offered Designation 2
3  Interview Evaluation Sheet Interview Panel 2
Approval 2
CTC Offer 2
4 Qualification certificate Last Degree 3
Certificate 2
Addi. Qualification 2
5 Experience related certificate Experience Letter 2
Relieving Letter 2
Last Salary Slip 3
6 Confirmation Letter(If Confirm Or Completed Six month) Date of Confirmation 5
7 Salary Increment letter(If Applicable) Approval for Increment 5
8  Office Order(If Applicable) Office order 2
9 HRMS Entry Personal Detail 5
Professional Detail 5
Educational Detail 5
Leave Balance 5
10 Attendance Process/ Register Bio Matrix Attendance 5
Register (On-Roll) 2
Register (Off-Roll) 2
11  Leave Process & Record Leave Form 5
Approved Authority 5
Signature 2
Balance 2
12 HR System At Unit Level Actual HR System At Unit level 3
Way of work for HR 3
Day to Day activity 3
13 Salary Discrepancy Last Salary Sheet 2
Salary Discrepancy 2
Approval of HOD 2
Any other issue related to Salary 2
14 Salary File Month Wise 5
All Documents as per check list 5
Company wise Salary File (i.e.NLL, CHHPL, TDPL) 5
15 Meeting with HOD Meeting with HOD during Morning Meeting in Unit. 2
Take feedback and suggestion to improve HR System. 2
Give instruction to Follow HR Process. 2
Update HR System 2
16 Observation Work Process 5
Work Environment 5
Attitude/Behavior of HOD 5
17 MIS – HR Employee Detail 2
New Joinee Detail – Monthly 5
Left Emloyee Detail – Monthly 5
Full & Final Status of Left Employee 5
18 Legal Compliance ESIC Sub Code (If Applicable) 5
ESIC No. of all employee 3
Form – 2 for PF Nomination 3
 Form – F for Gratuity Nomination 3
Monthly ESIC Chalan Copy 3
Form – 5 & Form – 10 3
All Required Register 3
Total

 

Click Here To Download Hr Audit Sheet In Excel Format

Search Sample Formats:

Be the first to comment - What do you think?
Posted by Hrformats - June 7, 2012 at 5:23 AM

Categories: HR   Tags: , , , , ,

Journal to Balance Sheet in Excel

 Useful for Accounting people to explore the wonders of excel formulas.

Date Debit particulars
(DR.)
Credit particulars
(CR.)
L.F. Debit-Rs. Credit-Rs Narration

furniture A/c
2 Enter Ledger account name
JOURNAL ENTRIES Date Debit particulars
(DR.)
Credit particulars
(CR.)
Folio Debit-Rs. Credit-Rs Balance-Rs. Narration
cash A/c capital A/c 50000 50000 capital introduce in the business furniture A/c Bank A/c 0 10000 10000 furniture purchased against cheque
Bank A/c cash A/c 35000 35000 opened bank account depreciation A/c furniture A/c 0 200 9800 depreciate furniture@2%
Purchases A/c ajay A/c 20000 20000 goods purchased on credit 9800
vijay A/c Sales A/c 14000 14000 sold good on credit 9800
ajay A/c Bank A/c 19500 19500 paid ajay in full settlement 9800
ajay A/c Discount A/c 500 500 paid ajay in full settlement 9800
Bank A/c vijay A/c 13000 13000 received in full settlement 9800
Discount A/c vijay A/c 1000 1000 received in full settlement 9800
furniture A/c Bank A/c 10000 10000 furniture purchased against cheque 9800
Travelling & conveyance expenses A/c cash A/c 3000 3000 paid for travelling expenses 9800
cash A/c Sales A/c 10000 10000 sold goods for cash 9800
Purchases A/c cash A/c 8000 8000 goods purchased for cash 9800
Bank A/c cash A/c 5000 5000 cash deposited in bank 9800
capital A/c Bank A/c 3000 3000 withdrawn for personal use 9800
salary A/c cash A/c 2000 2000 paid salary in cash 9800
telephone expenses A/c outstanding expenses A/c 1500 1500 telephone expenses were unpaid 9800
depreciation A/c furniture A/c 200 200 depreciate furniture@2% 9800
9800

 

Click Here To Download Journal to Balance Sheet in Excel

Search Sample Formats:

1 comment - What do you think?
Posted by Hrformats - May 23, 2012 at 11:43 AM

Categories: HR   Tags: , , , , ,

Salary Calculation Sheet in Excel

 I have Attached Salary Calculation Sheet in Excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
Name: Grade: Revised
Design: D.O.J.: Grade:
E.Code: Design:
Deptt.: D.O. Inc.: w.e.f.:
SALARY BREAK UP
(Amt.in Rs.)
S.No. Description Existing Increment Revised salary Remarks
salary w.e.f. w.e.f.
1 Basic Pay 4428
2 HRA 40% of Basic Pay 1771
3 Conv.Allow 15% of Basic Pay 664
4 C.E.A 5% of Basic Pay 221
5 Uniform Maint. Allow 500
GROSS AMOUNT 7584
6 P.F. 531
7 Bonus 886
TOTAL CTC 9001
SR. MANAGER (HR.) BUSINESS HEAD

 

Click Here To Download Salary Calculation sheet in excel

1 comment - What do you think?
Posted by Hrformats - January 27, 2012 at 11:43 AM

Categories: HR   Tags: , , ,

Salary Calculation Sheet in Excel

 I have Attached Salary Calculation Sheet in Excel

FOR GENERAL STAFF
INPUT HERE TOTAL CTC   = 9001
XYZ LTD.
Name: Grade: Revised
Design: D.O.J.: Grade:
E.Code: Design:
Deptt.: D.O. Inc.: w.e.f.:
SALARY BREAK UP
(Amt.in Rs.)
S.No. Description Existing Increment Revised salary Remarks
salary w.e.f. w.e.f.
1 Basic Pay 4428
2 HRA 40% of Basic Pay 1771
3 Conv.Allow 15% of Basic Pay 664
4 C.E.A 5% of Basic Pay 221
5 Uniform Maint. Allow 500
GROSS AMOUNT 7584
6 P.F. 531
7 Bonus 886
TOTAL CTC 9001
SR. MANAGER (HR.) BUSINESS HEAD

Click Here To Download Salary Calculation Sheet in Excel

2 comments - What do you think?
Posted by Hrformats - January 25, 2012 at 11:17 AM

Categories: HR   Tags: , , ,

Next Page »