How to create a Quotation System using an Excel spreadsheet - [create your own Template]

Does your business need to send out Quotations?

Does this seem to take ages to do?

If that’s the case, then why not create your own Quotation System template using an Excel spreadsheet so that you can automate the entire process.

Hello and welcome to another Mr. SpreadSheet video:

In this short presentation we will create a QUOTATION SYSTEM using an Excel spreadsheet that includes a Customer and a Products or Services database.

The completed template is easy to use and can be either printed or saved as a pdf for you to email to your potential customers.

The finished template uses many Excel functions commands and techniques.
we will Insert Graphics and Text Boxes,
we NAME Ranges,
we create a NESTED formula combining the CONCATENATE and XLOOKUP functions
and we FORMAT the final template for Printing and email.

All of these techniques are explained in in the presentation.

If you would like to get a copy of the completed template, then all we ask is that you subscribe to our channel and give this video a big thumbs up.

I hope you enjoy watching.

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

Free Quotation 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