Create and Track a Basic Inventory List in Excel - Excel Inventory List Template

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.

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

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

📺 Check out my New YouTube Course! Create Fillable Forms in Microsoft Word:

CHANNEL LINK 📺
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 📎
__________
GEAR

RESOURCES

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
Thank you for supporting my channel!
(Scroll down for a link to my free resources)
__________
__________
FREE DOWNLOADS
__________
PLAYLISTS:

[BoB]

Me in high school... 'When TF am i going to use excel ever' ... Here I am at 31 boys

[williambrown]

The double click for the total order is a game changer alone for me! Thank you very much.

[paulmiller]

I just purchased your template, but still watching your vids. Great teacher. I’m brand new to all of this!

[courageenejo]

You are amazing Sharon, just created my first inventory.

[muxibausa]

OMG You are the best, my first inventory. Thank you 😉

[bapattack]

Saved my bacon today. You're amazing, thank you.

[MegaWatcher]

Wow! Such as amazing and cheerful teacher and guide! You're a life saver! More Power and Godbless you!

[PriyankaLiyanage]

Realy enjoyed your tutorial. Thank you.

[luckymsomi]

You make it easy to understand everything, thanks for the tutorial.

[akbermagerramov]

Sharon thanks darling, it is so benefit from you, learning creating like that.

[JOYCEMCNAIR-fmhx]

This sheet is going to save me so much time thank

[syedqaisarabbas]

Hello Sharon how r u its me Qaisar Abbas from Pakistan I m doing a Job of Computer Operator since last ten years but there was some missing to use some important keys of Ms Word, Ms Excel one day i saw your video that was very helpful for thanks for your way of teaching its really very impressive i really appreciate it your videos are really very helpful.
now i have become your regular student. I daily watch your new videos. Lot's of love from Pakistan.

[maestro]

I found your video very helpful easy to follow ❤

[emilysavage]

You are amazing. This is so so helpful thank you 💓

[SunnyHeartKay]

Thank you SO much! I have never used excel in my life and I had to create a source list on Excel for a new job. You have totally saved me! Thx for showing the basics for complete beginners! You are so pretty and appear to be very happy btw🙂 thx again

[KierLegaspiEatwithKier]

It's very helpful. Thank you for the tutorial video. :)

[shcdc]

Hi. this really helps a lot. TQ. I have 1 questions, do excel have format to create fixed weekly schedule for stock count?

[marjsantiago]

Youre amazing really learned from your videos, i hope you can include stock in and sales in the inventory as well.

[stephanieawuah]

1. She reminds me of Tina Fey😂
2. This tutorial is excellent. Thanks!

[ronsullivan]

Great video, very easy to watch and follow. Next question would be how would I set up a Sales page that would automatically reduce the appropriate inventory level based on the quantity in the sale? I scanned all your videos looking for that topic but did not see it, if it exists. Thanks!!