www.excelhub.org

Excelhub.org textbox link to cell auto update

Excel text box link to cell to auto update text box or shapes

Posted on by Excelhub

How to add textbox or shapes? Before learning how excel text box link to cell, if you dont know how to add textbox or shapes in excel, you can refer below steps: To insert textbox, click on Insert on ribbon tab and click on text box. In case if you want to insert shapes to excel sheet, you can goREAD MORE

How to use excel cell function

Posted on by Excelhub

Version in which excel CELL function can work: Excel CELL function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010. AboutREAD MORE

MAC address lookup in excel vba code

Posted on by Excelhub

What is MAC address? A media access control address (MAC address) is a unique identification assigned to a device network interface controller (NIC) for communication at the data link layer of a network segment. In simple words, this is a unique identification for a device or computer in a network for communication. You can get more details from here HowREAD MORE

Payroll software in excel for FY 2018-19- Latest version

Posted on by Excelhub

We have released our new version of Payroll Management software. The software is updated for processing salary for Financial Year 2018-19. The tax rates and deductions are updated as per latest amendments. Submit your email to download the file. Enter your email address: For More details about this software Click Here Watch our video about how to use thisREAD MORE

How to use ACCRINT function in excel

Posted on by Excelhub

Excel version in which ACCRINT function can work: ACCRINT function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. AboutREAD MORE

How to use LEN function in excel

Posted on by Excelhub

Excel version in which LEN function can work: LEN function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.READ MORE

How to use INFO function in excel

Posted on by Excelhub

Excel version in which INFO function can work: INFO function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Starter 2010. This function isREAD MORE

How to use CONCATENATE function in excel

Posted on by Excelhub

Excel version in which CONCATENATE function can work: CONCATENATE function works in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010. InREAD MORE

How to use TODAY function in excel

Posted on by Excelhub

Excel version in which TODAY function can work: TODAY function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.READ MORE

How to use SUBSTITUTE function in excel with multiple text replacement

Posted on by Excelhub

Excel version in which SUBSTITUTE function can work: SUBSTITUTE function will work in Excel for Office 365 Excel for Office 365 for Mac Excel 2016 Excel 2013 Excel 2010 Excel 2007 Excel 2016 for Mac Excel for Mac 2011 Excel Online Excel for iPad Excel for iPhone Excel for Android tablets Excel for Android phones Excel Mobile Excel Starter 2010.READ MORE

Excelhub.org vlookup and more

How to use Vlookup wildcard search in excel

Posted on by Excelhub

In excel formulas; we can use the wildcard for partial matches to get the results. This can be used many functions where we do matching to get the results. Similarly, we can use the wildcard in vlookup formula. In this post I will explain you how to use vlookup wildcard in excel formula. You can also download the sample excelREAD MORE

Excel VBA to Display search result in listbox

Posted on by Excelhub

In case if you have a large list of employee data in a sheet and you want to select one employee details in main sheet based on the employee number. You can put a vlookup table and the details can be retrieved based on id in that table as below. But in case if you cant remember all employee id’s,READ MORE

Vlookup multiple sheets with same formula with Vlookup with Indirect

Posted on by Excelhub

With the combination of Vlookup and Indirect functions, you can dynamically change the sheet name in the formula to Vlookup multiple sheets with same formula. How to use Vlookup multiple sheets with Indirect In VLOOKUP Function you can search the given value from a table and give the output for matching value. In case if you have data table inREAD MORE

Excel autocorrect feature and tricks to save time

Posted on by Excelhub

While typing in excel, you might have seen that excel will do many auto correct functions. We can customize the autocorrect features in excel as per our requirement. To go to excel autocorrect options, follow the below steps: Click on Office buttonClick on Excel options and thenClick on Proofing Click on AutoCorrect options. It gives various options and you can customiseREAD MORE

How to insert drop down list in excel

Posted on by Excelhub

In various web pages and software you might have seen drop down list.This drop down list allows us to select the input without any error. Now let’s see advantages of drop down list and how to insert drop down list in Excel : it will give options to the user to select the input easily and quickly the input given byREAD MORE

How to add the developer tab to the ribbon

Posted on by Excelhub

In case you want to learn macros, vba programming and want to become advanced user of excel, you will have to add the developer tab to the ribbon. By default in excel this will not be added in the ribbon. How to add the developer tab to the ribbon in excel 2007 ? Click on excel Office Button Click onREAD MORE

How to find duplicates in excel- 3 ways to check for duplicates

Posted on by Excelhub

As a part of data analysis , in excel we can find and remove duplicate values. there are different ways to remove duplicates in excel. In this article let us understand how to find duplicates in excel. 3 Different ways to check duplicates: There are three different ways to find duplicates in excel. Conditional formating to find duplicates Using RemoveREAD MORE

How to lock cell and protect sheet in excel

Posted on by Excelhub

Excel provides the facility to protect sheet from updating from users. We can define the cells to be protected and cells to be allowed to be used in the sheet in a same sheet. The cells not protected will be allowed for user for updating the data and the protected cell can’t be altered by the users. The protection canREAD MORE

Free Software ITR 1 Sahaj income tax return for AY 2018-19

Posted on by Excelhub

What is ITR 1 and who can file this. ITR 1 Sahaj form can be filed by individuals with the income up to Rs. 50 Lakhs and with the following income. Salary or Pension Income Income from one house property ( excluding loss brought from previous year) Income from other sources (excluding winning from Lottery and Income from Race Horses)READ MORE

Hide formulas in excel and protect worksheet from update

Posted on by Excelhub

The Formula bar shows the formula entered in a cell when the cell is selected. In case if you have entered some complicated formula which you don’t want to show to the user, you can hide formulas in excel sheet without hiding the results of the formula. By doing this the results will appear without any impact. To hide formulasREAD MORE

MIS reporting 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 and decision making for different level of management.

Different department may use different kinds of reports to analyse and decision making. Generally small organisation will prepare the MIS report to analyse the performance of the organisation in terms of sales, expenses and profitability.

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

FD calculator for monthly interest recognision

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

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.

This ageing analysis can be done in excel with transaction details. This excel sheet is prepared to generate the ageing report of transaction.

Central Excise Invoice in excel – Excel Utility

The Manufacturer of excisable goods, who charge excise duty has to prepare invoice as per rule 11 of central excise rule 2002. This excel template is prepare to generate the invoice under central excise rule. The invoice can be prepared, saved and printed as per the requirement of central excise rule.

Following are the features of excise invoice utility.

Update Company Master to print in invoices.
Prepare invoice with up to 10 line items in an invoice.
Define Invoice series for invoices.
Maintain Customer Master.
Printing of invoices.

Central Excise Invoice in excel

PAN application form in excel with Database facility.

Permanent Account Number (PAN) is a unique identification number allotted by the Department of income tax to the Assessee. Application is to be filed along with the relevant documents to the department to get the PAN. Indian resident can file the application in form No. 49A and nonresident has to file the application in Form No. 49AA.

This utility is prepared to generate the form No. 49A PAN application form in excel. Details for PAN application can be updated, saved and printed in this utility.Features PAN application form in excel.

Fill & edit form 49A
Save application details.
Print application form 49A.
Update and track the status of PAN application.

PAN application in excel

Fill form 49A: Click on New Entry to open the form and fill up the form with all required details to generate form 49A PAN application form in excel.

Save application details: The details updated in the form will be saved in the sheet, you can save up to 20 PAN application form details in the excel utility. The details saved in the utility can be edited to make necessary changed and printed.

Print PAN application form 49A: Filled form can be saved and printed any time with print option. Print Form will be generated as per the latest form released by the department.

Update and track the status of application: Application acknowledgement number can be saved with comments in remark column. The PAN can also be updated when it is allotted for the reference.

Invoice preperation utility in Excel

Preparing invoice, maintaining the record and keeping the track of receivable may be time consuming and difficult task. This invoice template in excel is prepared to make this easy for the service providers. Service providers can prepare invoice and also charge service tax in the invoice. Following are the features of the invoice template in excel:

· Prepare invoice with up to 5 line items in an invoice.

· Define Invoice series.

· Maintain Client Master.

· Update the collection details from the customers.

· Debtor’s statement with aging.

· Printing of invoices.

invoice template in excel

Prepare invoice: In this invoice template in excel invoice can be created with detailed description up to 5 line items in one invoice. If service tax is not applicable on certain line item in the invoice, you can untick the check box to not to consider for service tax calculation. Job card No. or PO number can be mentioned in reference number field. When the invoice is created, the summary of invoice will appear in Home sheet.

Define Invoice series: Invoice series with prefix and suffix can be defined in the utility. Invoice number will be generated automatically with this information.

Maintain Client Master: Client / Customer code can be created and edited with all relevant details. When you select a client code while preparing the invoice, it will take all other information from the client master.

Update the collection details from the customers: Collection from customer can be updated with the amount, date and narration column. To update the collection, select a particular invoice and click on update collection button. Up to 5 records can be updated in collection details.

Debtors statement with aging: Based on the invoices prepared and collection details updated in the utility, debtors statement is automatically generated with aging statement.

Printing of invoices: you can print a professional invoice with all relevant information. Select the invoice and click on print invoice to see the printable invoice and you can also create a pdf invoice in this utility.

This excel invoice utility with all these features is available for an offer price of Rs. 99/-

The excel invoice template can be downloaded from the below link. Enable the macros and click on generate system no. and submit this number while making the payment to get the activation code.

ITR 1 (Sahaj) in excel for AY 2015-16 with auto fill function for printing

Are you filing ITR 1 in hard copy ? spending lot of time in writing and filling ITR 1?

Save lot of time in in filling ITR 1 and avoid mistakes using this excel utility.

Important Features of this excel utility:

Autofill of form ITR 1 for printing and submitting to the department along with ITR V ( Acknowledgement)
Bulk filing template to prepare and print many returns in short time.
Save the ITR in PDF form.

This excel utility is prepared for Preparation of Income Tax Return ITR 1 for the Assessment Year 2015-16. This is easy to use excel utility, in which you can prepare the ITR 1 form for filing the hard copy with the department. When you update the details in the excel sheet, the details will be automatically updated in the ITR 1, This can be used for offline filing (Physical submission of Printed forms) return ITR 1 to the department. This can be printed on A4 paper in colour as per the instruction given by the Income Tax Department. The automatically filled form includes ITR 1 and Acknowledgment.

This utility also provides bulk filing template, in which you can update many records in the given format. Facility is provided to print forms in bulk, save pdf in bulk and print individual forms. You can update up to 500 records in bulk filing template once.