08/01/2011 - 09/01/2011


To Select Company
Open Tally 9.ERP Software --> Getway of Tally --> Press Alt+F3 --> Company Information --> Select the Company Name --> Ok

To Shut Company
Open Tally 9.ERP Software --> Getway of Tally --> Press Alt+F3 --> Company Information --> Select the Shut Company Name --> Ok

To Open Company
Open Tally 9.ERP Software --> Getway of Tally --> Press Alt+F3 --> Company Information --> Select the Open Company Name --> Ok

To Modify Company
Open Tally 9.ERP Software --> Getway of Tally --> Press Alt+F3 --> Company Information --> Alter --> Company Name

To Delete Company
Open Tally 9.ERP Software --> Getway of Tally --> Press Alt+F3 --> Company Information --> Alter --> Company Name want to Delete --> Ok


First download Tally 9.ERP latest version software & install it. Education version software free to download & use. After fully installed, please launch the Tally 9.ERP software.
After launch, you can notice this screen same like under mentioned picture. View It

Click Picture to Large View
Use Down Array Key to highlight the "WORK IN EDUCATION MODE" & press ENTER key on this menu. After this select "SILVER EDITION MODE" & press ENTER.

You notice screen like under mentioned picture. View It

Click Picture to Large View
Click on CREATE COMPANY menu & new screen open like under mentioned picture. View It

Now you need to fill up new company creation form with information. It's use for education, so use some information as example. Don't use any company information.

To go next menu, press "ENTER". To go previous menu, press "SHIFT+TAB"
Name :- Company name
Mailing Name :- Alies name (optional field) (can use same like name) & press ENTER
Address :- Put address as example
Statutory compliance for :- Choose COUNTRY (for quick search, press 1st letter of country name)
State :- Choose State (for quick search, press 1st letter of state name) & press ENTER
PIN Code :- put as example
Telephone No :- put as example
Mobile No :- put as example
Email :- put as example
Currency Symbol :- Type currency symbol i.e. Rs for India
Maintain :- Choose 1 option from 2 option. ACCOUNTS ONLY if no inventory record & ACCOUNTS WITH INVENTORY if both are recorded.
Financial Year from :- put year starting date like 1.4.2008
Books Beginning from :- use same date which is use for Financial Year

USE SECURITY CONTROL because its use for Education
USE basic Currency options

After give ENTER, ACCEPT YES or NO option show. Press "Y" to choose "YES"


After press "Y", all date are saved & you can see screes like under mentioned picture


Company successfully created.


Use Minimum, Maximum Function & Use Minimum & Maximum Function at a time.

Minimum Function:-
Excel Minimum Formula use to choose minimum value among multiples numbers. Suppose there are 10 number i.e. 59, 12, 75, 82, 05, 25, 89, 09, 93 & 100. If you want to get the minimum value among 10 numbers, use this formula in your excel cell.

Formula =MIN(cell rahge) i.e. =MIN(A2:A11) ans 5
OR USE =MIN(59,12,75,82,5,25,89,9,93,100) and 5


Maximum Function:-
Excel Minimum Formula use to choose maximum value among multiples numbers. Suppose there are 10 number i.e. 59, 12, 75, 82, 05, 25, 89, 09, 93 & 100. If you want to get the maximum value among 10 numbers, use this formula in your excel cell.

Formula MAX(cell rahge) i.e. =MAX(A2:A11) ans 100
OR USE MAX(59,12,75,82,5,25,89,9,93,100) and 100


Use Minimum & Maximum Function at a Time:-
When you want to insert some value within minimum & maximum value (or has lower & upper limit), you can use minimum & maximum function at a time.
Example :- I want to get excel to return a formula result only within specified minimum and maximum values. Assume between 50 to 100.

1st :- Put 75 in the A1 cell
2nd:- Then put =MIN(MAX(50,A2),100) in the call B1
3rd:- Put 200 in A1 cell, B2 cell shows maximum value 100. Put 25 in the A1 cell, B2 cell shows minimum value 50. Try more




Ms excel Salary calculator format helps you to calculate individuals salary. It also very helpfull to manage a Salary pay Slip. In a firm or small company where the number of employees are upto 500, there is always a need of a salary calculator which can calculate the salary of full month. It's totally Excel Logical Function (If Function) based application which reduce energy & time to calculate salary or prepare salary slip.

Example Salary Calculation & Use of IF Function

PART-1
To calculate salary 1st open Excel 2003 / 2007 file & create a simple database like this:-

Employee Code No = keep it same like in picture
Name = keep it same like in picture
Designation = keep it same like in picture
Basic Salary = keep it same like in picture

PART-2
Now calculate some ALLOWANCES based on assumption
House Rent Allowance (HRA) = If 10% of basic salary is higher than Rs 2000, than HRA will Rs 2000. If 10% of basic salary is lower than Rs 2000, then HRA will 10% of Basic Salary
Formula =IF(D2*10%>2000,2000,D2*10%)
write formula in E2 cell & drag formula to E21 cell,

Dearness Allownace (DA) = DA is 25% on Basic Salary
Formula =D2*25%
write formula in F2 cell & drag formula to F21 cell

Medical Allowance (MA) = Executives get MA Rs 1000, Officers get MA Rs 700 & Assistants get MA Rs 500
Formula =IF(C2="Excutives",1000,IF(C2="Officers",700,500))
write formula in G2 cell & drag formula to G21 cell

PART-3

Gross Salary = Total of Basic + HRA + DA + MA
Formula =SUM(D2:G2)
write formula in H2 cell & drag formula to H21 cell

Professional Tax = Upto 5000 = 0, upto 1000 = 60, upto 15000 = 100 & over 15000 = 150
Formula =IF(H2<=5000,0,IF(H2<=10000,60,IF(H2<=15000,110,150)))
write formula in I2 cell & drag formula to I21 cell

Salary Paid Per Month = Gross Salary - Professional Tax
Formula =H2-I2
write formula in J2 cell & drag formula to J21 cell

Annual Salary = Salary Paid Per Month * 12
Formula =J2*12
write formula in K2 cell & drag formula to K21 cell

Income Tax = Upto 100000 = 0, then 50000 = 10%, then 100000 = 20%, over 250000 = 30%
Formula =IF(K2<=100000,0,IF(K2<=150000,(J2-100000)*10%,IF(K2<=250000,(K2-150000)*20%+5000,(K2-250000)*30%+25000)))
write formula in L2 cell & drag formula to L21 cell

Net Salary Payable = Annual salary - income tax
Formula =M2-M2

Contact Form

Name

Email *

Message *

Powered by Blogger.
Javascript DisablePlease Enable Javascript To See All Widget