Excel spreadsheet???

Question

I just got a promotion to bar manager and I have to set up a spreadsheet for inventory. I have never done that. How do I? I have entered in information before on a spreadsheet but it was always set up for me. How do I go about getting a sheet ready?

Answer 1

Look online. Google Excel tutorials.

http://www.bcschools.net/staff/ExcelHelp.htm

http://office.microsoft.com/en-us/assistance/CH790018021033.aspx

http://www.uwec.edu/help/excel03.htm

http://www.exceltip.com/category.html#6

Answer 2

It depends on what information you need from it however... I'll guess.
Type the name of each item down the left hand column.
Put the date at the top of each column going from left to right.
Under each date and next to each item, type the number of units of each item at the end of each day.
You could put more information in it like dollar values of inventory used and inventory values left.
You could also put formulas in some the fields to tell you how much what is being used most. Some colleges have adult learning classes on EXCEL. CompUSA also has classes. Some libraries might give classes, have books on teaching EXCEL or even have video tapes to teach EXCEL. The best thing to do is see what information is already being kept track of and try to build a spreadsheet from that.

Answer 3

Look at old spreadsheet. The names on top and on the side are easily noted and placed in new spreasheet. ( copy one line or row from old and paste into new ) Then look at the places where numbers changed. ( not the place you entered numbers ) Look up at the bar just above the top of your spreadsheet. There is the missing formula. If it confusses you look in the help section for any part of the formula. Remember this is a tool that you tell it what you want it to do. Any questions look at help. To make a wall takes many bricks. ( wilber Berkey, 1953 )

Answer 4

I think you can search for the inventory template through google or yahoo!. It's commonly available now. But if you plan to design it on your own, you need to have understandings on the input, retrieve and the design of interface. Perhaps some programming knowledge on VB Script would help.

Besides Excel, maybe you can try to look for solution in Microsoft Access.

Answer 5

About the best thing you can do is get your hands on the old spreadsheet that you were using when you were just entering data, erase the data that's already on there and use that. There's no reason to duplicate work.

Answer 6

On the www.microsoft.com website there are training sessions you can access. These sessions enable you to learn step by step. After each session you can test yourself. I found it very handy for PowerPoint. In the search window type excel training, the first link displayed is Microsoft Office Training Excel 2003. Click on this link and it will take you through to the courses that are available. Click on the fifth link Get to know Excel - Enter formulas. This will take you through step by step on how to set up your formulas. I hope this helps you :)