Central Excise Invoice in excel – Excel Utility

DOWNLOAD  GST invoice preparation utility in excel 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…

Continue Reading

PAN application form in excel with Database facility.

Updated on : 26th March 2017. 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. 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…

Continue Reading

Invoice preperation utility in Excel

DOWNLOAD  GST invoice preparation 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. ·        …

Continue Reading

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…

Continue Reading

Excel shortcuts to speed up your work.

Click here to download this in ExcelFunctionKeyOpen[Ctrl] + [O]Exit[Alt] + [F4]Move to the beginning of the worksheet[Ctrl] + [Home]Move to next sheet[Ctrl] + [Page Down]Move to previous sheet[Ctrl] + [Page Up]Convert to a percentage[Ctrl] + [Shift] + [%]Apply outline to active cell[Ctrl] + [Shift] + [&]Applies the Date format.[Ctrl]+[Shift]+[#]Formats the current cells as Currency.[Ctrl]+[Shift]+[$]Applies the General format.[Ctrl]+[Shift]+[~]Edit the active cell[F2]Paste a name into a formula[F3]Repeat the last action[F4]Display the Go To dialog box[F5]Moves to the next pane in a split worksheet.[F6]Check…

Continue Reading

Excise Invoice Preparation utility in excel

DOWNLOAD  GST invoice preparation utility in excel The central excise invoice format in excel is developed to prepare central excise invoice as per the provisions of central excise rule. you can prepare invoice, edit that if you want to and print the invoice. Update the company master data in the Home sheet, this information will be printed in the invoice. You can also update the Invoice number prefix and suffix and invoice starting number. Invoice number will be updated each…

Continue Reading

Shared workbooks feature in excel

If several users who need to work from the same workbook at the same time, you can use Shared Workbook feature. To use this feature, select Tools | Share Workbook, and Excel will allow more than one users to update the workbook. You can set options that control when changes are updated and how to handle conflicting edits by different users. You can choose to save updates when a user clicks Save, or you can specify a time interval for…

Continue Reading

Break Link to remove the linked file sources

When you work on a large file which contains link from different files, the file size becomes large and removing the link by searching different links may be difficult.To remove these link easly and to make the linked contents as paste special values you can follow these steps.·         Go to Data tab and click on Edit links.·         You can see the different source files linked to this workbook.·         Select the file you want to remove the link and click on…

Continue Reading

Quick access to worksheets

When there are many worksheets in a workbook and all the worksheets are not visible in the worksheet tab. The user has to search for the required worksheet. To search the sheet quickly you can right click on the any of the tab scrolling buttons, a short cut menu will pop-up and you can select the worksheet you want.

Continue Reading

Large file size due to names with error in excel

Some times, when you move sheets from different file, the file size will be too large even though the contents of the file are very less.The reason for this may be the Names defined in the original file which is moved to new file. These Names may not be required in this file and if the link for the defined Name is linked to sheet which is not moved, it will be of no use and it will show the…

Continue Reading
Close Menu