How to create a Quotation System using an Excel spreadsheet - [create your own Template]
Vložit
- čas přidán 27. 07. 2024
- 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 - www.MrSpreadsheet.com/product...
You can also visit our websites at:
USA & Canada & World - www.MrSpreadSheet.com
UK & Europe - www.MrSpreadSheet.co.uk
Or our Social channels:
FaceBook - / mrspreadsheets
Instagram - / mrspreadsheet
Twitter - / mr_spreadsheet
#MrSpreadSheet #Excel #spreadsheet #exceltutorial #msexcel #Accounting - Jak na to + styl
This video was very, very helpful. this is the only one I watched that made any sense. Thanks a million I really appriciate it ♥
Hi Jodian, many thanks, so glad you found it helpful :)
This video was very helpful, it helped me to improve my layout and organisation of the quotation document. Much Appreciated, my Quote Doc now looks really sharp!
Hi Elise, Glad it helped,
Thank you so much MrSpreadsheet
Thanks Milton :-)
Very detailed loved it. It helped me so much🙌
Glad it helped! :-)
Very good video and beautifully explained... Subscribed
Thanks and welcome :-)
thank you. well explained.
Glad it was helpful! 😊
Great video! Thanks you very much
Glad you liked it!
thank you for my good work.
Hi Asim, Very pleased you liked it ... :-)
very useful - thank you !
Glad it was helpful!
Wow very informative.
Hi Jane, so glad you enjoyed it! :)
Subscribed and liked
Thanks Wes :-)
Waw Thankyou
Welcome 😊
Very helpful, thank you - I have subscribed and liked (very big like) ... how can I get a copy of the template download please?
Hi Tony, you can get a download at www.MrSpreadSheet.com :-)
Amazing tutorial , i have a question - when I add D12 to the formula, it takes the value of D12 from the product sheet ... how to correct it? please help
Hi, You can download a copy of the completed template and check your work against that. Visit www.MrSpreadSheet.com :-)
Thank you, i subscribed and liked the video. how do i get a template
Hi Hosea, The file you have requested can be obtained by following the guide in this video czcams.com/video/m7Zf8_UWPGQ/video.html 😊
Hey i was trying to get the copy of the template like the others. The link says private. Thank you
Hi Nicholas, there should be no issues with this as we have multiple downloads daily 😊
Subscribed - how do I get the copy of the template please?
Hi Tilly, The file you have requested can be obtained by following the guide in this video czcams.com/video/m7Zf8_UWPGQ/video.html 😊
I am always getting the #name? Error when i tried it Im following every step but I cannot seem to make it auto populate
Hi Sacred Cow, you can download the original and then check your work, www.MrSpreadSheet.com 😊
is it possible to create an invoice from this Quote?
Hi Daniel, Yes, just change the headings around. 😊
Can this template auto generate the next quote number
Hi, Yes, this is possible, I will incorporate the routine in a future video. :-)
when I run the sheet as describes it returns #NAME? What did I do wrong?
Hi, You can check your work against the original. See the download guide video czcams.com/video/m7Zf8_UWPGQ/video.html 😊
Same here
Same please help
this happens if you are using Excel 2013,2016, 2020 versions as XLookup only available on 365
subscribe and would love a copy of the template
Hi, downloads are available at www.MrSpreadSheet.com :-)
your lookup has stopped working
Hi, Why not download a copy of the original and then you can check your work against that. Hi, Downloads are available at www.MrSpreadSheet.com :-)