Product Description and Amount: It allows you to add the product description you are selling and the amount to be added under each category.Customer Details: Company name and address details of the same.Date: The date on which invoice is being allocated to your customer.

Company Address: The address of the company along with contact details.Company Name: The name of your company for which we should make payments.Step 2: You should add the following details under each cell as per the table below. Double click on Blank Workbook it will open up a blank excel workbook. Step 1: Open an Excel file by typing “excel” in the search box, double click on it. This step is essential because if you fail to save the updated invoice, you will lose all the updated data from your invoice.Įxample #2 – How to Create an Invoice in Excel from Scratch This way, you can save your invoice at any location in your system and can send it. Enter a name suitable for your invoice and click on the Save button. Click on the File menu from the excel ribbon present at the uppermost corner. Step 8: Once you are done with the update of the invoice, you need to save this template. Most of the excel invoice templates are using formulas that keep your Final Total updated. Step 7: You can add them as per the service provided and also should have a look at the final total amount. Add the company name in this template, and then you can add the amount associated with the goods. Step 6: Now, you can edit and customize this invoice template as per your need. You’ll see a template in excel like the screenshot below. Step 5: Once you click Create button, excel downloads the template for you and opens it. Click on Create Button to download and create the template in Excel. Step 4: Once you select any template, Excel allows you to download the same and use it in excel for further purposes. Step 3: Select and click on a template appropriate and fulfilling your needs. TEXT and String Functions in Excel (26+).Lookup and Reference Functions in Excel (36+).Excel Conditional Formatting Based on Another Cell Value.SUMPRODUCT Function with Multiple Criteria.Compare Two Columns in Excel for Matches.

Excel invoice template free download