![]() |
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. :rolleyes: 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. |
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. |
I use Excel a lot. Let me know if there is something I can help you with. |
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. |
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. |
| All times are GMT -8. The time now is 08:52 AM. |
Powered by vBulletin® Version 3.8.9
Copyright ©2000 - 2026, vBulletin Solutions, Inc.
Copyright ©2003 - 2018 YorkieTalk.com
Privacy Policy - Terms of Use