LearnHub

How we can use Excel in business data activities. Like Stock Manupolations, Accounting, Contact Lists, Reminders etc.?

step 1.) Select the colum
step.) Click Data menu
Step 3.) choose the ascending or desecending option from data menu
Step 4.) click ok

Excel use in business in many ways;
For example:-
1.) mantain the stock report i excel
2.) create the employee list with details
3.) create the salary statement in excel
4.) mantain the other accounts details in excel

create the contact list in excel:-
1.) Type heading contact list
2.) Type name of contact person
3.) Type contact no of person.
4.) Then save the contact list in excel.
5.) if You need to sort the list according to alphabets then we can use sort option from data menu

Stock manupolations:-
Basically business man maintain the stock manupolations using visual baic software. that software available in market .

We use excel in business for Calculate business profit and loss,maintain the stock report,Calculate the Salary statements maintaining the record of employee and custmor etc

For calculate the salary of Employee:- 1.)Open new work Sheet by Ctrl+N
2.)Firstly creat a format according to our requirment i.e Name ,Post,Gross salary,DA,TA,Medical Allowance,Net Salary etc
3.)Then fill the record in that row and column
4.)For Calculate the Salary Type a method in Cell and enter
For example if we want to Find the DA that is 10 % 0f gross salary then we write farmula as:(position of Gross salary*10)100 enter

For Sorting:-
Select the column
Click on data menu
Choose the ascending or decending option
Click no header
ok

what is the use of consolidation in microsoft excel?

What is theuse of goal seek in excel ?

How we use record narration in ex cel?

What is the use of goal seek ?

sub total:
sub total command is used to calculate summary values such as total and average for individual groups of data

sorting:
sorting is arranging data in an ascending or descnding order on the basis of one or more columns

how to create employee details in excel like basic,hra,gross salary,da,net salary

How to create employee salary details in excel