Learn how to create and track a basic Inventory List in Excel with this step-by-step tutorial. I'll show you how to create a simple yet effective Inventory List in Excel. Whether you're managing inventory for your small business, or organizing personal items, I'll show you all the essential columns of data you'll want to capture, as well as how to leverage conditional formatting to set up visual alerts for items you need to re-order. We'll even take a look at how to set up pivot tables so you can filter, view & analyze your inventory data more easily.

You will 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 you started on the right track. Here is a link to purchase the template: https://creatoriq.cc/44qUfjx

Having an organized inventory is essential for businesses and personal use. By the end of this tutorial, you'll have a functional inventory spreadsheet that allows you to efficiently manage your inventory and make informed decisions. Whether you're a small business owner, an office manager, or simply someone looking to keep track of personal belongings, this tutorial will provide you with the necessary skills to get started.

#ExcelInventoryTutorial #InventoryManagement #ExcelTutorial #inventorytracking

Also watch:
Track Inventory Stock Automatically: https://youtu.be/wHTBezb-pEk
Analyze your Inventory Data: https://youtu.be/cjQO6L9VXYQ

00:00 Create an Inventory List in Excel Overview
03:22 Create Inventory List from New
08:25 Sum Total Inventory Value
09:00 Set up Drop-down List in Excel

FREE COURSE :
How To Create Fillable Forms in Microsoft Word - A Step-by-Step Guide
Create Fillable Forms, Surveys & Questionnaires in Microsoft Word like a Pro!
https://youtu.be/438pCPCSuG4

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/
__________
GEAR
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 top notch webcam)

RESOURCES
JotForm: https://www.jotform.com/pricing/?utm_source=sharon-smith&utm_campaign=jf1&utm_medium=blog
Wondershare PDFelement (PDF Editor): https://bit.ly/31QEkA8
PresenterMedia: https://shareasale.com/r.cfm?b=417324&u=2065055&m=43706&urllink=&afftrack=

Some links included here are affiliate links. If you click on these links and make a purchase, I may earn a small commission at no additional cost to you. Thanks 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?ref=listing_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 from this PayPal link: https://www.paypal.com/cgi-bin/webscr?cmd=_s-xclick&hosted_button_id=AJJ6SXERNDMYA&source=url. Your donation, no matter what amount, is greatly appreciated and goes towards producing content that enhances your productivity and elevates your skills. Thanks for supporting this channel!
__________
FREE DOWNLOADS
Visit https://mailchi.mp/6a0859ea0844/sharonsmithhrformulasdownload to sign-up for my e-mail list and get FREE downloads of super helpful spreadsheet formulas, dashboards and Org Chart templates for HR professionals.
__________
PLAYLISTS:
Jotform Tutorials: https://www.youtube.com/playlist?list=PLb80efKTbWuO84pPbnHdTdgurmxHgZcyD

Creating Fillable Forms: https://www.youtube.com/watch?v=YktZ3B-tyqs&list=PLb80efKTbWuOe1LfFMNExEabkRkB5ehcv

PowerPoint Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMcFRbsZO5wkXgYjBG4meRM

Excel Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuNjHDGgNeuGrGwOvh4JQC90

Excel Quickies (Around 2 Minutes): https://www.youtube.com/playlist?list=PLb80efKTbWuPI7fEWtroXHvJHhx5FnVMW

Word Tutorials for HR: https://www.youtube.com/playlist?list=PLb80efKTbWuMotoYEXBFMlB3PtsBlFn45

Welcome | About Me: https://www.youtube.com/playlist?list=PLb80efKTbWuOd17uW4U2V8Xip0sTAfkLR