traumafindr

Ok Everyone. I KNOW ALOT OF USERS USE EXCEL FOR INVENTORY OF COINS BUT IM CONFUSED. NOT BEING ALL THAT FAMILIAR WITH EXCELL HOW DO I GO ABOUT STARTING A INVENTORY/DATABASE OF MY COINS?? CAN ANYONE HELP?

WAITING TO HEAR
THANKS JIM

hontonai

Here are the basics:

Open an Excel file and enter column headings across the page for the information you want to keep, such as denomination, date, mintmark, metallic content, value, acquisition date, etc..

Adjjust the column sizes to accomdate the information and then start entering.

Most people format the column headings line, for example as centered, bold underlined text, sometimes using background colors or different type colors. You should use the "freeze window" command to keep the titles on the page when you have more entries than you are able to show on a page.

From there you can customize the worksheet a million different ways. Good luck, and have fun!

__________________
Ethical conduct is being honest when no one is watching.

GoldCoinLover

I actually had to put my coin collection in excel on a table for part of my computer training. I completed it, and it looks pretty good. Get the 2007 verison, it's the best verison and far better than the others. Insert a table and some shading..will look nice. If you don't want text to wrap, you can just double click the column line to make space. And you can copy different text by clicking on the box in the lower right hand corner and drag down to copy anything

__________________
1834 Breen-6138. No Motto, Small Head style. (Small head variety)
NGC AU53/CAC $2.50 classic head
http://i10.photobucket.com/albums/a1...4labelcomp.jpg

ldhair

I learned a lot about excel by just going in and playing around.
The cool thing is that once the data is in the file you can change things forever without loosing what has been entered.

__________________
Larry

schatzy

Please PM me your email address and I will send you a template to get you started!!

__________________
~Jaime~ My Proof Roosevelt Set
My Toned Roosevelt's

Vess1

There are several excellent walk throughs on youtube dealing with Excel spreadsheets and their functions if somebody really wants to learn the basics.

My favorite function is the ability to create additional sheets while working in the same file. You will see the current sheet you are on (in bold), on the tab in the bottom left corner. You can click on that and re-name the 'Sheet' (Silver dollars, quarters, dimes...etc..) Then click on the next couple and rename them. Right click on any one of them to insert a new work sheet. Create as many as you need.
After it's set up, you can just click the coin specific tab you want to look at a series within the same open file, without having a list of stuff a mile long being all together. That's the handiest feature, IMO.

Not to take anything away from the formulas you can use to automatically perform calculations.

__________________
When the well's dry, we know the worth of water.
- Benjamin Franklin

PennyGuy

Yes, Excel is fairly easy to get familiar with. Using an empty column you can shade it any color to separate sections of you coin listings. I use this method to seperate Large Cents from IHC's, from Lincolns, etc.

The formulas functions are quite powerful, and make it easy to create a master page, with summary information on coin sets, counts, acquired values, retail values, etc.

__________________
ANA - MSNS - EAC - SLCC - NLOC
"A penny hit by lightning is worth six cents" Opie Taylor

Just Carl

There has been an add on TV many times for some guy that sells CD's on how to use different programs. Something doctor but can't remember exactly what. Hopefully someone here knows that info. The first one is free in hopes you buy more. So you could ask for Excel and forget the rest. At many book stores there are pamphlets on Excel or Microsoft Office and usually cheap. I bought one of them and for basics it's great.
However, I've basically done what others have already said, just play around with it. The main thing to remember is to use your save thing as much as possible. I've had that misfortune in making something and closing it without saving. POOF, gone.
I don't know how many people you know but I've found the greatest info is to email people you know and ask how to do something in Excel. eventually you'll find someone that likes to show off how much they know and will help you all your want.