Easy MIS report format of performance for small business.

MIS report format of performance for small business: Management information system reporting or MIS reporting is a set of data compiled and presented to management. This information is helpful in analyzing the business situation. This will also help in decision making for different level of management. This MIS report format will help for small business to present the information in a easy manner.   Different department may use different kinds of reports to analyse and decision making. Generally small organisation…

Continue Reading

Simple project management dashboard in excel

Simple project management dashboard in excel: Project is a unique non routine task, the completion of which requires many sequence of activities. To complete any project successfully proper planning, execution, reviewing monitoring is very essential. The list of activities to complete the project is to be identified and the time required to complete each activity is to be estimated to complete the project within time. Simple project management dashboard in excel will help you to keep track of a project. Simple project…

Continue Reading

FD calculator for monthly interest recognision

When an organisation keeps money in many fixed deposit, the interest should be recognized  on periodic basis. Usually it is calculated on monthly, quarterly, half yearly or yearly basis. When there are many fixed deposit,  it is difficult to calculate accrued interest for a period. This fd calculator Excel sheet is prepared to calculate the monthly interest accrued amount on each FD to recognize the revenue. The FD calculator for monthly interest Excel sheet can also be used to monitor the maturity schedule of the FD accounts. You…

Continue Reading

Accounts receivable ageing report in excel

Ageing Statement analysis is a key control for any business. The ageing analysis can be for accounts receivable, accounts payable, advance received, advance paid, inventory etc. Any delay in settling the transaction may have some adverse impact on business. Therefore, the ageing analysis will help in finding such delay in settling the transaction and early attention can be taken to avoid any difficulty. Aging report in excel format This ageing analysis can be done in excel with transaction details. This…

Continue Reading

ITR 1 in excel for AY 2014-15 with auto fill function.

This excel utility is prepared for Preparation of Income Tax Return ITR 1 for the Assessment Year 2014-15. Enable Macros to use this utility. Use TAB to update the details in MAIN sheet. This can be used for offline filing (Physical submission of Printed forms) return ITR 1 to the department. The details required like Name, Address, Income, Deduction and Tax payment details can be updated in the Main Sheet. This information will be automatically updated in the form ITR…

Continue Reading

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
Close Menu
×

Cart