1,349,736 views
👌 Learn how to create an INVENTORY CONTROL for your startup, micro venture or business and download the adaptable template 😱 Download my complete catalog of short videos here: https://www.elingefrancisco.com/produ... Template download link: https://mega.nz/file/PVBCiRbT#B0bUDsI... ------------------------------------------------------------------------ Step by step: 00:00 Greeting 01:10 Demonstration of the template 02:45 Creation of the tables 04:50 Copying data 06:18 Custom formats to the input document field 07:34 Validation of data ready in input code 08:40 Vlookup function in description of entries 09:37 Vlookup function in batch of entries 10:10 If.error function in description and batch of entries 10:55 Custom formats to the output document field 11:30 Validation of data ready in output code 12:10 Vlookup function in output description 13:19 Vlookup function in output batch 14:20 Sum.if.set function in inventory entry 17:21 Sum.if.set function in inventory output 18:51 Calculating current inventory stock 20:00 Calculating inventory unit cost 20:21 Calculating inventory amount 22:44 Conditional formats with stock alert icons 25:08 Creating buttons 29:06 Creating totals 30:45 Final recommendations ____________________________________________ Don't forget to also visit: How to #create an #invoice in #Excel with #buttons and #interactive #form controls: • How to #create an #invoice in #Excel with... How to make an interactive #ACTIVITY and #PROCESS #CONTROL PANEL with progress percentage?: • How to make a #CONTROL PANEL of ... How to create a #consultation #form with photos in Excel: • How to create a #consultation #form ... ____________________________________________ Paypal for collaborations: https://paypal.me/FranciscoTeran?loca... ____________________________________________ Follow me on my social networks: Twitch (LIVE) Coming soon: / elingefrancisco TikTok: https://www.tiktok.com/elingefrancisco Instagram: / elingefrancisco