When I was researching art software to purchase to keep track of my inventory, my husband reminded me that I could use Excel to create an inventory.
I use all word, excel, access, PowerPoint for my day job and never thought of using if for my art.
So I sat down at Excel and in 30 minutes had my inventory up and running. The hardest part is to just keep it up. But I found it to work well and also to work well for my graphic design business and also to inventory all the valuables in my house (even though I did videotape my house)
So I made a video and since I am an advance user in excel, I may have worked too fast for some. Please email me with any questions and I can help you or send you a starter template for this.
Good Luck!!!
Advertisement
Like this:
3 bloggers like this post.
Thank you for taking your valuable time to share this wonderful tool. So very helpful.
you are very welcome, Glad it can help
hey, I knew that!!
LOL
you could also automatically link each picture & number on your cover page to the page that belongs to it so you don’t have to look along the bottom
I think I’ll go put pictures on my inventory that’s already in excel
I also use QuickBooks accountant and think I can put pictures in there but I’ve never really looked into it
Thanks ~ Sherry
actually you can link the cell to the cell for the info but most people don’t know that, I told you, you would get it once you see it. easy breezy for excel queens
The video isn’t available any longer
Do you still have the template?
Hi Kevin,
My YouTube account is down, I will repost it in a few days
The link is now fixed