Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet

Interactive Stock Control Sheet in Excel | Automated Inventory Management | Inventory Control Sheet In Excel | Stock Management

Get his sheet: https://bit.ly/3MzrCev
Get a customized stock sheet: http://bit.ly/3nKiWrh
Check out previous stock control video:    • Stock Control Sheet In Excel | Invent...  

You can support me on
1- Patreon http://bit.ly/433u4Q2
2- Buymeacoffee http://bit.ly/40IH6AR

Formulas already taught on my channel:
Vlookup:    • How To Do VLOOKUP Excel | MS Excel VL...  
If:    • How To Use IF Function In Excel | Log...  
Sumif:    • How To Use Sumif Formula In Excel Wit...  

0:00 Intro / Recap
0:50 Data Sheet (Sheet 1)
2:15 Format as table in Excel
3:30 Ins & Outs (Sheet 2)
4:40 Data Validation in Excel
8:52 If formula in Excel along with vlookup formula
12:45 Multiple If / Ifs formula
16:35 Master (Sheet 3)
19:00 Vlookup formula in Excel
21:17 Sumifs Formula in Excel
25:10 Inventory count + Inventory Valuation
26:20 Formatting and then Outro

Play Lists
Microsoft Excel for beginners: http://bit.ly/3UaDANe
Business Studies: http://bit.ly/3K8eie9

Recommend WPS Office-Best FREE alternative to Microsoft Office, Download for Win & Mac & Mobile.
Free Download link: https://bit.ly/49UYJCD

Email: [email protected]

#Excel #ExcelTutorial #ExcelForBeginners