How to make Salary Sheet using Microsoft excel (Excel Advance Urdu Hindi)

In this tutorial you 'll learn: How to make Salary Sheet using Microsoft excel, this is Excel Advance tutorial in Urdu and Hindi language.

Urdu & Hindi training by: www.MickeyTuts.com

What is Ms office ?
Ms office is an application program which is using for different purpose like: Ms word using for application, form & letter purpose , excel for sheet,math formula & many other office related usage most popular Access for database & power point for presentation etc.

How to create Salary sheet ? for those people who didn't understand Urdu/Hindi language
First of all open excel program & type following value in each cell.

1: E no Serial number like : 1,2,3,4
2: Name Worker name
3: Designation Manger, CEO, etc
4: Department Name of Department
5: Basic Put basic salary like: $1000
6: Attendance How much attendance of employ in month
7: Salary Basic x attendance/30)= salary
8: House Rent Basic x 45%=house rent
9: Convence Attendance x $1=daily convance
10: Gross Salary+House rent+ Convance = Gross
11: Income text If gross grater then symbol 10000,Gross x 5%=I.Text
12: GP fund Gross x 8.33%= Gpfund
13: Total Deduction Income text+ Gp fund=T Deduction
14: Net salary Gross - Total deduction=Net salary
--------------------------------------------------------------------------------------

Note: if you have any qustion about this tutorial so you can ask in comment box Thanks

Video Length: 20:30
Uploaded By: Urdu Hindi Tutorials
View Count: 199,340

Related Software Products

Advanced Excel Report

Published By:
EMS Software Development

Description:
Advanced Excel Report component for Delphi and C++ Builder is a powerful band-oriented generator of template-based reports in MS Excel. Easy-to-use component property editors allow you to create powerful reports in MS Excel quickly, easily and intuitively understandable. Now you can easily create reports, which can be edited, saved to file and viewed almost on any computer. Advanced Excel Report supports Borland Delphi 5-7, 2005, 2006 and MS Office 97 SR-1, 2000, 2002 (XP), 2003.BRBR Key ...

Related Videos

How to Create a Summary Report from an Excel Table

One of my viewers asked for my help in creating an Executive Summary Report - because her manager will not allow her to use a Pivot Table. Here are the tips and techniques that I demonstrate in this lesson: 1) Use Excel's Advanced Filter to Extract a list of unique customer names from a filed with over 4,000 records. 2) Convert a normal range of data cells into an Excel 2007 / 2010 Table (as a List in Excel 2003) - so that range references will update automatically when you ...
Video Length: 12:06
Uploaded By: Danny Rocks
View Count: 692,693

How to Use Advanced Filters in Excel

In addition to the built-in AutoFilters in Excel, you can create Advanced Filters that allow you to extract unique records or calculate criteria based on external data. I do not use Advanced Filters as much as I did in the past because Excel 2007 greatly improved the built-in AutoFilters. However, you will pick up at least two good tips from this lesson - including how to extract Unique Records and copy them to a new worksheet. I invite you to visit my online ...
Video Length: 10:45
Uploaded By: Danny Rocks
View Count: 433,067

How to Make a Business Account Ledger in Excel : Advanced Microsoft Excel

Subscribe Now: http://www.youtube.com/subscription_center?add_user=Ehowtech Watch More: http://www.youtube.com/Ehowtech Making a business account ledger in Excel is a great way to keep track of your finances. Make a business account ledger in Excel with help from a mechanical engineer in this free video clip. Expert: Edward Russell Filmmaker: Patrick Russell Series Description: Microsoft Excel isn't just for ...
Video Length: 03:06
Uploaded By: eHowTech
View Count: 209,643

Advanced Reporting in SharePoint with Microsoft Power View

http://www.Gig-Werks.com - http://www.YouTube.com/GigWerks - http://www.TheSharePointBlog.net Join Award Winning SharePoint solution provider Gig Werks for a complimentary webcast on Advanced Reporting in SharePoint with Power View. Microsoft Power View enables quick and easy visualization of your data while allowing sharing and collaboration of business insights in a familiar SharePoint Server environment. This webcast will highlight all the features available from Power View ...
Video Length: 51:20
Uploaded By: Gig Werks SharePoint Solution Channel
View Count: 63,980

Dynamic Pivot Table Report Filters - Excel Tutorial

http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ Learn how to dynamically update Pivot Table Report Filters using simple macro code. In this example you can see how this idea can help you create a dynamic chart from Pivot Tables. For details visit http://chandoo.org/wp/2011/04/27/update-report-filter-macro/ You can also download example files from there. hr / bClosed Caption:/b hi everyone welcome .font color="#E5E5E5" ...
Video Length: 06:19
Uploaded By: ExcelTutorials
View Count: 53,921

MS Excel 2010 Tutorial: Employee Sales Performance Report, Analysis & Evaluation - PART 1

http://www.excelfornoobs.com http://www.subjectmoney.com http://www.subjectmoney.com/articledi... What we have built here is a Microsoft Excel template that can be used to analyze the performance of sales representatives with a focus on restaurant servers (waiters and waitresses). In this example we are analyzing the quarterly performance of the restaurant as a whole, and each sales unit (the servers). We will also take a deeper look into each month that the ...
Video Length: 07:54
Uploaded By: Surfwtw
View Count: 45,505

Highline Excel Class 22: Budgets, Scenarios & Scenarios Report

Download Excel file: http://people.highline.edu/mgirvin/ex... Create a Budget with Formula Inputs in an assumption area and formulas. Then do what if analysis by saving and showing scenarios. Save Variables for a Budget with Scenario Manager. Create Scenario Report based on a Result cell. Add Scenarios button to the Quick Access Toolbar QAT. See other What If Analysis videos: Excel Magic Trick 253: Data Table 1 Variable What If Analysis Excel Magic Trick # 254: Data ...
Video Length: 11:33
Uploaded By: ExcelIsFun
View Count: 40,990

How to copy Excel data from one sheet to another and print the extracted report

Our Excel training videos on YouTube cover formulas, functions and VBA. Useful for beginners as well as advanced learners. New upload every Thursday. For details you can visit our website: http://www.familycomputerclub.comYou can copy data from one Excel worksheet to another based on criteria to create a report automatically and then print it with a single click. The code for copying the data using a do while loop macro is described in greater detail than before because many people ...
Video Length: 12:15
Uploaded By: Dinesh Kumar Takyar
View Count: 38,366

How to create report from Excel data sheet with VBA

Learn to create report from Excel data sheet with VBA according to your needs. Our Excel training videos on YouTube cover formulas, functions and VBA or macros. Useful for beginners as well as advanced learners. New upload every Thursday. For details including complete VBA code you can visit our website: http://www.exceltrainingvideos.com/ho...
Video Length: 20:46
Uploaded By: Dinesh Kumar Takyar
View Count: 37,855

Excel Magic Trick 402: Monthly Comparative Report - Pivot Table

See how to use a Pivot Table to create a Report that shows the differences in Sales between Months. See the Pivot Table tricks: 1.Group Dates by Quarter and Year 2.Drag and Drop Fields 3.Show values as Difference from 4.Formatting a Pivot Tables hr / bClosed Caption:/b welcome tofont color="#CCCCCC" exile magic number 402/font hey if you want to download this font color="#CCCCCC"workbook/fontfont color="#E5E5E5" and follow along ...
Video Length: 03:52
Uploaded By: ExcelIsFun
View Count: 23,799