How to create an INVOICE in Excel - Spreadsheet Template for 2021

In this short video I will show you how to create an Invoice using Excel.

The spreadsheet template will use Excel's features and functions available in 2021.

The final Invoice Template is very easy to use and can be expanded and adapted to suit your business needs.

As usual on the Mr.SpreadSheet channel I will show you how to obtain a copy of the final template towards the end of the tutorial.

The Invoice spreadsheet uses the following Excel commands and formulae:

Importing and re-sizing your company logo
NAME various ranges
Using the new XLOOKUP and the popular VLOOKUP commands
Use CONDITIONAL FORMATING
Create simple IF Statements
Use Excel's ROUND and TODAY functions
Create drop down boxes using the DATA VALIDATION tool
Prepare the final product for PDF's and Printing

We do hope that you enjoy watching and that there is lots of content that will be both useful and informative.

Here are the links to the various Mr.SpreadSheet resources available to you.
Please help support our channel by subscribing.
Many thanks

Free Invoice Spreadsheet Template - https://www.MrSpreadsheet.com/product...

You can also visit our websites at:

USA & Canada & World - https://www.MrSpreadSheet.com
UK & Europe - https://www.MrSpreadSheet.co.uk

Or our Social channels:

FaceBook -   / mrspreadsheets  
Instagram -   / mrspreadsheet  
Twitter -   / mr_spreadsheet  

#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting