Local Navigation

riacarolina · 06-07-2008, 10:08 AM #1 (**permalink**)

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 · 08-17-2008, 01:26 AM #2 (**permalink**)

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 · 08-17-2008, 01:33 AM #3 (**permalink**)

^^^ 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 · 08-17-2008, 03:38 PM #4 (**permalink**)

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

malaviKat · 08-27-2008, 11:47 PM #5 (**permalink**)

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 · 08-29-2008, 12:37 PM #6 (**permalink**)

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 · 05-27-2009, 12:41 AM #7 (**permalink**)

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 · 07-11-2009, 09:18 PM #8 (**permalink**)

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 · 07-12-2009, 01:45 AM #9 (**permalink**)

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.