How to Create an Invoice Template in Excel!

How to Create an Invoice Template in Excel!In this session, we’ve explained in easy STEP by STEP details about how to create an Invoice Template by just using some basic sum function and lookup feature without VBA in just few minutes. After this video, not only it will be easier for you to create such basic templates, but also you can get the print outs of this template at a single click.

This template is very useful for beginners, startups businesses and individuals as it helps in managing and organizing all your finances into one place.

We’ve used the following features to create this tutorial.

1. Border Alignments & Formatting
2. SUM function
3. VLOOKUP with IFERROR function
4. Cross Across Selection
5. Page Setup & Print Preview
6. Excel to PDF
7. CONCATENATE function to combine normal text and text from cell reference

Visit us for daily dose of Excel Tips & Tricks at

In case of any simple or complicated “Excel” query, you can ask to our experts for instant solution at