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