Using Excel to inventory your collection

[riacarolina]

Sorry if this is in the wrong forum mods!

I wanted to find a way to keep inventory on all my MAC, since I'm a MA and I like knowing what I have, how many, and especially, the total cost (for tax/business purposes). I downloaded excel, and I had no trouble listing everything and the prices from the MAC website, but the actual coding/spreadsheet functions got me lol... I'm definitely not an accountant. After a couple internet searches on how to do a few things, I created a working spreadsheet that keeps track of all my MAC, and the total cost of my collection.

If anyone is interested, PM me and I will email you mine as a sample, and you can just change all the items and stuff with your collection

I thought I'd share, since people here recommend excel, but no one has really explained how to use it

I hope this helps someone

 

[JediFarfy]

I LOVE using Excel! I just redid my spreadsheet. I'm such an Excel nerd. I'll get around to Access one of these days.

Jf

 

[VDUB*BELLA]

^^^ LOL Me too

I am using Excel right now too to inventory my collection but I admit that the last couple of months I have been kinda lazy with the updates

 

[hollyca]

I use Excel too. It's even a cute pink and black color. hahaha

 

[malaviKat]

LOL...

Awesome. I told my local MA that I used excel to keep track of my MAC and she looked at me funny.

Glad to see there are other nerds around...

 

[lablonde]

LOL I also use Excel. Different colours for example when I wait for some products from Ebay. I can see everything in just a blink

 

[meeshkapeesh]

I used to use excel. . but I never had my 'LIST' with me when I needed it. Thanks to google, I use GOOGDOCs. I

google. =p

 

[coquetayloca]

I used to use excel too, but I would always forget my list of inventory when I went to MAC. I am NOTORIOUS for buying stuff that I already have. Is it bad to say that the main reason I got an Iphone was so that I could put my spreadsheets on Google Docs and have access to them at all times...

 

[gildedangel]

I use Excel to keep track of my MAC. I usually document what it was, if it was LE or perm, how many I have ever owned, how many empties I have and if I would ever consider buying it again. Glad to see that I am not the only one who does this. Mine isn't pretty though, I barely know how to type in that program lol.

 

[Vixxan]

I use a Access database for mine. It's easy to search for items in database. I never thought about using Excel.

 

[theperfectqueen]

Tried to PM you but the message said:

1. riacarolina has exceeded their stored private messages quota and can not accept further messages until they clear some space.

Can you please PM me a sample of your excel spreadsheet?

Thanks!

 

[tee]

This is a brilliant idea, thank you

 

[Delightful D]

I sent a private message too and it was full. I would love to take a look at it.

Have a beautiful days Girls,
Diana

 

[Lucinda9999]

You could have used access too. I have done that to keep record of my DVDs and CDs and since I could put them all into catergories and everytrhing like that. I once made a weight chart thing on excel. I love ICT! I also make a budget and a cash book for myself on excel too

 

[Kragey]

Hey, ladies! I use an Excel spreadsheet for my make-up, too, although I'm sure it's less sophisticated than you ladies'. I stripped mine naked and uploaded it to SendSpace for those of you who are interested. Here's a screenshot of what it looks like:

http://i47.tinypic.com/2wpnuko.png

Very simple and easy to modify. For the record, I organize my stuff alphabetically by brand, then alphabetically by shade, and that works great for me.

Here's a download link, for those who want it!

Download MakeupInventory.xls from Sendspace.com - send big files the easy way

 

[nursee81]

i'd like a copy too.

 

[tangledrose]

I've got one on googledocs, and nerdy little me was so excited that I worked out how to make an automated form for input. So now its all drop down boxes and check boxes. About the only thing I need to fill out is the name of the e/s for e.g.

Small pleasures....