MENU

Fun & Interesting

Learn How To Create This Automated Purchase Order Application In Excel While I Build It From Scratch

Excel For Freelancers 288,688 lฦฐแปฃt xem 5 years ago
Video Not Working? Fix It Now

Tired of manually creating Purchase Orders? Let Excel do it all for youโ€”in just one click.

๐Ÿ”ฅ ๐†๐„๐“ ๐Ÿ‘๐Ÿ“๐ŸŽ ๐Ž๐… ๐Œ๐˜ ๐๐„๐’๐“, ๐ƒ๐Ž๐๐„-๐…๐Ž๐‘-๐˜๐Ž๐” ๐“๐„๐Œ๐๐‹๐€๐“๐„๐’๐Ÿ‘‰ https://www.excelforfreelancers.com/350-workbooks-ytdesc
๐Ÿ‘จโ€๐Ÿ’ผ ๐Œ๐€๐’๐“๐„๐‘ ๐Ÿ-๐‚๐‹๐ˆ๐‚๐Š ๐‘๐„๐๐Ž๐‘๐“๐’ ๐ˆ๐ ๐Œ๐˜ ๐ƒ๐€๐’๐‡๐๐Ž๐€๐‘๐ƒ ๐Œ๐€๐’๐“๐„๐‘๐‚๐‹๐€๐’๐’ ๐Ÿ‘‰ https://www.excelforfreelancers.com/dashboard-masterclass-ytdesc
๐Ÿ“ฃ ๐‹๐„๐€๐‘๐ ๐•๐๐€ ๐…๐‘๐Ž๐Œ ๐’๐‚๐‘๐€๐“๐‚๐‡ ๐–๐ˆ๐“๐‡ ๐“๐‡๐„ ๐”๐‹๐“๐ˆ๐Œ๐€๐“๐„ ๐•๐๐€ ๐‚๐Ž๐”๐‘๐’๐„๐Ÿ‘‰ https://www.excelforfreelancers.com/ultimate-vba-ytdesc


In this weekโ€™s training, Iโ€™ll walk you through how to build a complete Purchase Order system from scratch in Excel. Youโ€™ll learn how to generate full POs with a single click, print and save them, and instantly load any past PO by number.

In This Video, Youโ€™ll Learn:
โœ“ How to generate a complete Purchase Order in one click
โœ“ Create, print, save, and load POs easily
โœ“ Design a clean and professional PO layout
โœ“ Add dynamic data selection for items and suppliers
โœ“ Download the free template and follow along step-by-step

๐Ÿ‘‡๐ƒ๐Ž๐–๐๐‹๐Ž๐€๐ƒ ๐“๐‡๐ˆ๐’ ๐–๐„๐„๐Š'๐’ ๐–๐Ž๐‘๐Š๐๐Ž๐Ž๐Š ๐“๐„๐Œ๐๐‹๐€๐“๐„ ๐‡๐„๐‘๐„:
http://bit.ly/PurchaseOrder_Wb

๐Ÿ›  ๐๐„๐„๐ƒ ๐‡๐„๐‹๐?
โžก๏ธ ๐—š๐—ฒ๐˜ ๐—˜๐˜…๐—ฝ๐—ฒ๐—ฟ๐˜ ๐—›๐—ฒ๐—น๐—ฝ ๐—–๐˜‚๐˜€๐˜๐—ผ๐—บ๐—ถ๐˜‡๐—ถ๐—ป๐—ด ๐—ง๐—ต๐—ถ๐˜€ ๐—ข๐—ฟ ๐—”๐—ป๐˜† ๐—ง๐—ฒ๐—บ๐—ฝ๐—น๐—ฎ๐˜๐—ฒ. ๐—ข๐˜‚๐—ฟ ๐——๐—ฒ๐˜ƒ๐—ฒ๐—น๐—ผ๐—ฝ๐—ฒ๐—ฟ๐˜€ ๐—”๐—ฟ๐—ฒ ๐—ฅ๐—ฒ๐—ฎ๐—ฑ๐˜† ๐—ง๐—ผ ๐—”๐˜€๐˜€๐—ถ๐˜€๐˜ ๐—ฌ๐—ผ๐˜‚ ๐—ก๐—ผ๐˜„! https://www.excelforfreelancers.com/CustomsJobs_YTDesc


๐„๐—๐‚๐„๐‹ ๐‚๐Ž๐”๐‘๐’๐„๐’:
โ–บ๐— ๐—˜๐—ก๐—ง๐—ข๐—ฅ๐—ฆ๐—›๐—œ๐—ฃ ๐—ฃ๐—ฅ๐—ข๐—š๐—ฅ๐—”๐— : https://www.excelforfreelancers.com/mentorship-program-ytdesc
โ–บ๐——๐—”๐—ฆ๐—›๐—•๐—ข๐—”๐—ฅ๐—— ๐— ๐—”๐—ฆ๐—ง๐—˜๐—ฅ๐—–๐—Ÿ๐—”๐—ฆ๐—ฆ: https://www.excelforfreelancers.com/dashboard-masterclass-ytdesc
โ–บ๐—•๐—˜๐—š๐—œ๐—ก๐—ก๐—˜๐—ฅ๐—ฆ ๐—ฉ๐—•๐—” ๐—–๐—ข๐—จ๐—ฅ๐—ฆ๐—˜: https://www.excelforfreelancers.com/ultimate-vba-ytdesc
โ–บ๐—™๐—ฅ๐—˜๐—˜๐—Ÿ๐—”๐—ก๐—–๐—˜๐—ฅ'๐—ฆ ๐—”๐—–๐—”๐——๐—˜๐— ๐—ฌ: https://www.excelforfreelancers.com/freelancers-ytdesc
โ–บ๐—ช๐—˜๐—• ๐—”๐—จ๐—ง๐—ข๐— ๐—”๐—ง๐—œ๐—ข๐—ก ๐—ช๐—œ๐—ง๐—› ๐—ฉ๐—•๐—”: https://www.excelforfreelancers.com/CompleteWebAutoYTDesc


๐„๐—๐‚๐„๐‹ ๐๐‘๐Ž๐ƒ๐”๐‚๐“๐’:
โ–บ๐—š๐—ฒ๐˜ ๐Ÿฏ๐Ÿฑ๐Ÿฌ ๐—ง๐—ฒ๐—บ๐—ฝ๐—น๐—ฎ๐˜๐—ฒ๐˜€ ๐—œ๐—ป ๐Ÿญ ๐—ญ๐—ถ๐—ฝ ๐—™๐—ถ๐—น๐—ฒ: https://www.excelforfreelancers.com/350-workbooks-ytdesc
โ–บ๐—š๐—ฒ๐˜ ๐—ฌ๐—ผ๐˜‚๐—ฟ ๐—”๐—ฐ๐˜๐˜‚๐—ฎ๐—น ๐—˜๐—บ๐—ฝ๐—น๐—ผ๐˜†๐—ฒ๐—ฒ ๐—›๐—ผ๐˜‚๐—ฟ๐—น๐˜† ๐—–๐—ผ๐˜€๐˜: https://www.excelforfreelancers.com/labor-burden-ytdesc
โ–บ๐—š๐—ฒ๐˜ ๐Ÿฑ๐Ÿฌ๐Ÿฌ+ ๐——๐—ผ๐—ป๐—ฒ-๐—™๐—ผ๐—ฟ-๐—ฌ๐—ผ๐˜‚ ๐— ๐—ฎ๐—ฐ๐—ฟ๐—ผ๐˜€: https://www.excelforfreelancers.com/udvl-ytdesc
โ–บ๐—š๐—ฒ๐˜ ๐—–๐—ต๐—ฎ๐˜๐—š๐—ฃ๐—ง ๐—œ๐—ป๐˜๐—ผ ๐—˜๐˜…๐—ฐ๐—ฒ๐—น ๐—ช๐—ถ๐˜๐—ต ๐—ง๐—ต๐—ถ๐˜€ ๐—”๐—ฑ๐—ฑ๐—ถ๐—ป: https://www.excelforfreelancers.com/ai-toolpack-ytdesc
โ–บ๐—š๐—ฒ๐˜ ๐——๐—ฒ๐—ฒ๐—ฝ๐—ฒ๐—ฟ ๐——๐—ฎ๐˜๐—ฎ ๐—œ๐—ป๐˜€๐—ถ๐—ด๐—ต๐˜๐˜€ ๐—ช๐—ถ๐˜๐—ต ๐—”๐—œ ๐——๐—ฎ๐˜๐—ฎ ๐—”๐—ป๐—ฎ๐—น๐˜†๐˜€๐˜: https://www.excelforfreelancers.com/ai-data-ytdesc
โ–บ๐—ง๐—ต๐—ฒ ๐—จ๐—น๐˜๐—ถ๐—บ๐—ฎ๐˜๐—ฒ ๐—ฆ๐—ฐ๐—ต๐—ฒ๐—ฑ๐˜‚๐—น๐—ฒ ๐—ข๐—ฟ๐—ด๐—ฎ๐—ป๐—ถ๐˜‡๐—ฎ๐˜๐—ถ๐—ผ๐—ป ๐—ช๐—ถ๐˜๐—ต ๐—˜๐˜…๐—ฐ๐—ฒ๐—น ๐—–๐—ฎ๐—น๐—ฒ๐—ป๐—ฑ๐—ฎ๐—ฟ ๐—ฃ๐—ฟ๐—ผ: https://www.excelforfreelancers.com/calendar-pro-ytdesc


TIMESTAMPS:
0:00 โ€“ Introduction
3:00 โ€“ Worksheet Design
29:55 โ€“ Change Event Worksheet
41:51 โ€“ Save & Update Purchase Order
1:00:02 โ€“ Load Purchase Order
1:18:02 โ€“ Add New Purchase Order
1:23:34 โ€“ Cancel New Purchase Order
1:25:05 โ€“ Print Purchase Order
1:31:19 โ€“ Generate Purchase Order

๐‰๐Ž๐ˆ๐ ๐Ž๐”๐‘ ๐‚๐Ž๐Œ๐Œ๐”๐๐ˆ๐“๐˜ ๐Ÿ‘‰ https://www.excelforfreelancers.com/EFFGroup

๐…๐จ๐ฅ๐ฅ๐จ๐ฐ ๐Œ๐ž ๐Ž๐ง ๐Œ๐ฒ ๐’๐จ๐œ๐ข๐š๐ฅ ๐Œ๐ž๐๐ข๐š ๐€๐œ๐œ๐จ๐ฎ๐ง๐ญ๐ฌ:
โœ–๏ธX: https://x.com/Excel4Freelance
๐Ÿ”—LinkedIn: https://www.linkedin.com/in/excelforfreelancers/


๐€๐›๐จ๐ฎ๐ญ ๐”๐ฌ:
I help Excel enthusiasts turn their skills into passive incomeโ€”no need to trade time for money. If you enjoy these weekly videos, you can support Excel For Freelancers by grabbing one of our powerful tools to boost your Excel skills and chase your dreams.

๐†๐ž๐ญ ๐€๐ฅ๐ž๐ซ๐ญ๐ž๐ ๐ˆ๐Œ๐Œ๐„๐ƒ๐ˆ๐€๐“๐„๐‹๐˜ ๐–๐ข๐ญ๐ก ๐๐ž๐ฐ ๐…๐ซ๐ž๐ž ๐“๐ซ๐š๐ข๐ง๐ข๐ง๐  ๐•๐ข๐๐ž๐จ๐ฌ & ๐–๐จ๐ซ๐ค๐›๐จ๐จ๐ค ๐๐ฒ ๐’๐ฎ๐›๐ฌ๐œ๐ซ๐ข๐›๐ข๐ง๐  ๐‡๐ž๐ซ๐ž ๐Ÿ‘‰ https://www.youtube.com/c/ExcelForFreelancers/

New Training Video Uploaded Every Tuesday And Saturday!

๐™๐™๐™–๐™ฃ๐™  ๐™ฎ๐™ค๐™ช ๐™ซ๐™š๐™ง๐™ฎ ๐™ข๐™ช๐™˜๐™ ๐™›๐™ค๐™ง ๐™ฎ๐™ค๐™ช๐™ง ๐™˜๐™ค๐™ฃ๐™ฉ๐™ž๐™ฃ๐™ช๐™š๐™™ ๐™จ๐™ช๐™ฅ๐™ฅ๐™ค๐™ง๐™ฉ,
Randy Austin

#exceltraining #purchaseorder #purchaseorderapplication #excelforbusiness

Comment