Process Payroll in Excel

Processing Payroll in excel with tax computation, Monthly Salary statement, Pay slip etc. Process up to 10 employees salary. LATEST VERSION OF PAYROLL SOFTWARE IN EXCEL FOR FREE  1    Update Employee master with employee details.       In employee master select status "EXISTING" Or "LEFT"       if you select the status "LEFT" the salary will not be processed for that employee       If a employee leaves , you need not delete the record, just change the status to "LEFT"       2   …

Continue Reading

Find the Duplicate entries in the list using Countif formula

To find out the duplicate entries in a list, we can use the COUNTIF formula. The COUNTIF function counts the number of cells in a range which meets the given criteria. With the help of COUNTIF function we can find out how many times a given entry is appearing in the list.Syntax for COUNTIF Function:=COUNTIF(range, criteria)We will take a example of list of 20 names, in which we have to find out how many times a particular name is repeated. Following…

Continue Reading

How to make auto fill forms in excel using linked pictures

Auto fill forms can be prepared in excel using linked picture option easily. If we prepare format of any form in excel, it will take lot of time and if it contains picture, logo and colours, it is difficult to align and set for print. To avoid this we can scan and insert the blank form in picture format and insert the linked pictures of the field to update the form.In the given example the application for digital signature is…

Continue Reading

10 Shortcut Keys in excel to speedup your work.

The shortcut keys will speed up the work by avoiding mouse clicks. Remembering these shortcut keys may be difficult, but by regular practice we can develop the habit of using short cut keys.Following are the 10 shortcut keys to speedup your work. 1 Ctrl+Space and Shift+Space  these are the short cut keys used for selection of cell. Ctrl+Space will select the entire column of selected cells. Shift+Space is used to select the rows of selected cells. 2 Ctrl+Shift+-  Ctrl+Shift+- is…

Continue Reading

Left, Right and Len functions in excel

If you want to split the information in a cell and get only few number of characters in a particular cell you can use the simple functions like LEFT or RIGHT.LEFT: syntax for LEFT function=LEFT(text, [num_chars])LEFT function will give the number of characters given in the formula from left of the referred cell. If the number of characters is not given, then it will take it as 1. For example, the information contains Employee Number and Employee name in same cell, then…

Continue Reading

Currency count for salary disbursement with special requirement

When the cash salary is to be disbursed to many employees, the currency of different denominations are required to make the payment. Some times currency notes of few denominations may not be available. Before making the payment the payer should be ready with the cash of required denominations. The Currency count for salary disbursement excel sheet will help to do this. Currency count for salary disbursement excel sheet is prepared to calculate the currency notes of different denominations required for paying…

Continue Reading

Billing and debtors management utility for CA’s

New latest version of Invoice preperation utility in Excel July 31st is the last date for filing the Income tax return, when I requested my CA friend to file my tax return, in turn I received a request from him prepare a worksheet to prepare and maintain his billings. Based on his request I prepared the worksheet and I am sharing the same with you with brief note on how to use this.This is a simple and free to use utility, you…

Continue Reading

How to use VLOOKUP in excel

VLOOKUP in excel is the popular and widely used formula in MS Excel. VLOOKUP function searches given value ( lookup_value) in the left most column of the table and returns the value in the  given column (col_index_num) of the matching row. The syntax for VLOOKUP in excel: =VLOOKUP(lookup_value, table_array, col_index_num, [range_lookup]) Lookup_value: lookup_value  is the value you want to search in a table or array.This can be text, number or logical vaues and are not case sensetive. table_array: this is…

Continue Reading

SUMIFS Functions in Excel

SUMIF function is used to add the cells in a range which meets the given criteria. In SUMIF function you can give only one criteria. SUMIFS function adds the cells in a range which meets multiple criteria. Syntax for SUMIFS function is=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)The sequence of arguments are different in SUMIFS function as compare to SUMIF.sum_range argument is the first argument in the SUMIFS function. This is the range of cells the value of which is to…

Continue Reading

How to use Excel SUMIF Formula

In this article we have explained how to use Excel SUMIF Formula.Excel SUMIF function can be used to sum the value in a range that meets the given criteria.  Syntax for Excel SUMIF Formula is: =SUMIF(range, criteria,[sum_range])range is the argument that specifies the cells in which the criteria or the condition is to be checked. We should select the range of cells in the formula.criteria is the condition to be checked, which can be text, number, cell reference, formula etc. The criteria…

Continue Reading
Close Menu