Create Automatic Stock Reports - In and Out Recap - Beginner Excel Tutorial - ignasiusryan
This video explains how to create an automatic report of incoming or outgoing stock recaps. We use 3 Excel formulas/features to create a report like this: VLOOKUP, SUMIF, and Conditional Formatting.
The exercise files can be downloaded for free here: https://drive.google.com/file/d/112Fn...
EXCEL E-BOOK PRICE IS ANYTHING
🎓 Learn Excel from Zero E-book https://lynk.id/ignasiusryan/D8p04vG
📊 E-book 72 Excel Formulas https://lynk.id/ignasiusryan/kKgPP4W
🏎️ E-book 100 Important Shortcuts https://lynk.id/ignasiusryan/DAabpz5
MY DESK SETUP
🖥️ Monitor screen https://invol.co/cl8a7cu
⌨️ Keyboard https://invol.co/cl8a6w8
📷 Webcam https://invol.co/cl8a6y8
🖱️ Mouse https://invol.co/cl8a788
🎙️ Microphone https://invol.co/cl8a76o
💡 Lighting https://invol.co/cl8a75k
💼 Work desk https://invol.co/cl8a7sj
🥙 Others https://ignasiusryan.notion.site/Desk...
GET IN TOUCH
📷 Instagram / ignasiusryan
✈️ Telegram https://t.me/ignasiusryan
📧 Email [email protected]
📽️ Tiktok / ignasiusryan
🌐 Website linktr.ee/ignasiusryan
I use Excel 365.
If you find this video helpful, please subscribe so you don't miss my other videos and help share it with others. Who knows, this might be the video they've been looking for.
Thanks,
Igna
Crazy, you read the description of this video until the end.