In this step-by-step tutorial, you'll learn how to create and track a simple inventory list in Excel. I'll show you how to create a simple but effective inventory list in Excel. Whether you're managing inventory for your small business or organizing personal items, I'll show you all the important columns of data you'll want to capture and how to use conditional formatting to set up visual alerts for items you need to reorder. We'll even show you how to set up pivot tables so you can more easily filter, view, and analyze your inventory data.

You'll learn how to create this inventory list template from scratch, but you can also purchase the template we use in this video to save time and get started right away. Here's a link to purchase the template: https://creatoriq.cc/44qUfjx

An organized inventory is essential for both business and personal use. By the end of this tutorial, you will have a functional inventory spreadsheet that will help you efficiently manage your inventory and make informed decisions. Whether you are a small business owner, office manager, or simply someone who wants to keep track of their personal belongings, this tutorial will give you the skills you need to get started.

#ExcelInventoryTutorial #WarehouseManagement #ExcelTutorial #WarehouseTracking

00:00 Create an inventory list in Excel – Overview
03:22 Recreate inventory list
08:25 Sum of total inventory value
09:00 Setting up a dropdown list in Excel

Check out my new YouTube course! Create fillable forms in Microsoft Word:
https://www.youtube.com/playlist?listPLb80efKTbWuNzAyHVMYrPOS7itBm5gWVs

CHANNEL LINK
https://www.youtube.com/@SharonSmith
Visit my channel page on YouTube to see all my videos, playlists, community posts, and more!
__________
KEYWORDS: inventory list in excel, inventory list template, excel tutorial
__________
CONNECT WITH ME
Visit my website: https://www.sharonsmithhr.com for more information, tools and resources.
LinkedIn: https://www.linkedin.com/in/sharonsmithhr
Twitter: https://twitter.com/SharonSmithHR
Instagram: https://www.instagram.com/sharonsmithlearn/
__________
CORRIDOR
Blue Yeti USB Microphone: https://amzn.to/2W4SbzV (Great for recording professional sounding audio for your videos!)
Silent Mouse: https://amzn.to/3pxpc25 (This is a really cool mouse!)
Screen recording software: https://techsmith.z6rjha.net/NZG5b
Green Screen: https://amzn.to/2DnHsY2
Camera: https://amzn.to/39KvpQA
Live Stream Tool: https://amzn.to/2VFJyID (Turns your DSLR into a premium webcam)

RESOURCES
️ JotForm: https://www.jotform.com/pricing/?utm_sourcesharon-smith&utm_campaignjf1&utm_mediumblog
Wondershare PDFelement (PDF editor): https://bit.ly/31QEkA8
PresenterMedia: https://shareasale.com/r.cfm?b417324&u2065055&m43706&urllink&afftrack

Some of the links included here are affiliate links. When you click on those links and make a purchase, I may receive a small commission at no additional cost to you. Thank you for supporting this channel!
__________
TEMPLATES
Check out my helpful list of templates available for purchase: https://www.etsy.com/listing/875846662/employee-engagement-survey-ms-excel?reflisting_published_alert
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
NOTE: If you found this content helpful, please consider donating to my channel using this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd_s-xclick&hosted_button_idAJJ6SXERNDMYA&sourceurl. Your donation, regardless of the amount, is greatly appreciated and goes towards creating content that will increase your productivity and improve your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign up for my email list and receive FREE downloads of extremely helpful spreadsheet formulas, dashboards, and org chart templates for HR professionals.
__________
PLAYLISTS:
Jotform tutorials: https://www.youtube.com/playlist?listPLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

Create fillable forms: https://www.youtube.com/watch?vYktZ3B-tyqs&listPLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

PowerPoint tutorials for HR: https://www.youtube.com/playlist?listPLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

Excel tutorials for HR: https://www.youtube.com/playlist?listPLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel quickies (approx. 2 minutes): https://www.youtube.com/playlist?listPLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

Word tutorials for HR: https://www.youtube.com/playlist?listPLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

Welcome About me: https://www.youtube.com/playlist?listPLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR

Please take the opportunity to connect with your friends and family and share this video with them if you find it useful.