|
Welcome to the YorkieTalk.com Forums Community - the community for Yorkshire Terriers. You are currently viewing our boards as a guest which gives you limited access to view most discussions and access our other features. By joining our free community you will have access to post topics, communicate privately with other members (PM), respond to polls, upload content and access many other special features. You will be able to chat with over 35,000 YorkieTalk members, read over 2,000,000 posted discussions, and view more than 15,000 Yorkie photos in the YorkieTalk Photo Gallery after you register. We would love to have you as a member! Registration is fast, simple and absolutely free so please, join our community today! If you have any problems with the registration process or your account login, please click here to contact us. |
|
| LinkBack | Thread Tools |
04-24-2011, 09:26 PM | #1 |
www.yorkierescue.com Donating Member Join Date: May 2009 Location: Las Vegas & Orange County
Posts: 17,408
| I need help with Excel I need to figure out how to format the cells to keep track of customers who are using layaway. Currently we are just using a book and calculator. I don't get how to use the formulas. Help! I've also started a worksheet to keep track of customers' purchases, phone numbers, and bike models with serial numbers. a LOT of kids have been getting their bikes stolen, and asked me if I have the serial numbers, so I want to be able to have the serial numbers on hand to help them out in case the worst happens.
__________________ The T.U.B. Pack! Toto, Uni, & Bindi RIP Lord Scrappington Montgomery McLimpybottom aka El Lenguo the Handicapped Ninja 10-12-12 |
Welcome Guest! | |
04-25-2011, 05:36 AM | #2 |
Donating Senior Yorkie Talker | Frankly, it's so easy to screw up a record in an excel spreadsheet, I wouldn't use it to record layaways... unless you're also keeping paper records as a backup. But if you can describe what you're trying to do, I may be able to help you with the formula. I would recommend you use a database program such as Access for this, but it's been probably 15 years since I last used it so I can't help you there. Recording serial numbers, on the other hand, is a great use for excel, since you are not going to be changing the data for a customer once entered. But it still requires care to make sure you are not accidentally writing over the wrong record. |
04-25-2011, 08:16 AM | #3 |
Donating YT 500 Club Member Join Date: Nov 2008 Location: Where the deer and the antelope play
Posts: 7,069
| I use Excel a lot. Let me know if there is something I can help you with.
__________________ Shelly and the girls Moka Mylee |
04-25-2011, 09:00 AM | #4 |
Thor's Human Donating Member | I LOVE Excel. Really. What version are you using? Mac or PC? It's pretty easy to get the hang of it. The help has great starter topics. Read some of the "Getting Started" topics, and you'll be an expert in no time.
__________________ If you love something, set it free. Unless it's an angry tiger. |
04-27-2011, 02:48 AM | #5 |
YT 1000 Club Member Join Date: Apr 2010 Location: Winnipeg, MB, Canada
Posts: 1,795
| I'm familiar with all versions - 2003, 2007, 2008, and a little of 2010. PM if you need any help. In our program (Commerce) we're required to use Excel a lot.
__________________ Kendra Harley, you were the light in my life, rest peacefully my love! |
Bookmarks |
|
|
| |
|
|
SHOP NOW: Amazon :: eBay :: Buy.com :: Newegg :: PetStore :: Petco :: PetSmart