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. :P 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