.You need to create a spreadsheet model that will help your restaurant in someway:
You could create a spreadsheet model to help you plan the amount of food and drink needed for the launch parties, based upon the number of replies you have to your invitations. In other words, if 25 people can come you will need to order and prepare more food and drink than if 18 people could come.
The model should allow you to simply enter the number of people attending and automatically calculate the amount required of each item of food or drink.
You would have to bear in mind that you cannot just order half a baguette or a third of a bottle of wine, so you may need two types of cost - the cost of feeding everyone and the actual cost of the shopping you will have to do to make sure you have enough!
You can add a front page with hyperlinks to other pages and your logo; you can use LOOKUPS; absolute cell references; data validation to give drop down boxes; ROUNDUP; AUTOSUM; cell protection; gridlines; shading; cell merging and alignment ......
Quick Worker Task!:
Make a copy of your existing spreadsheet and add the word 'exploration' to the end of the file name. Click here to go to a set of video tutorials that will extend your understanding of spreadsheet functions/facilities - see how many of these you can utilise in your spreadsheet to make it even better.
- It could be to help cost outside catering for parties that you take on
- It could be to do with the cost of staff during the week and at weekends or busy times such as holidays.
- It could be to calculate the cost of your launch party depending on how many people accept your invitation.
You could create a spreadsheet model to help you plan the amount of food and drink needed for the launch parties, based upon the number of replies you have to your invitations. In other words, if 25 people can come you will need to order and prepare more food and drink than if 18 people could come.
The model should allow you to simply enter the number of people attending and automatically calculate the amount required of each item of food or drink.
You would have to bear in mind that you cannot just order half a baguette or a third of a bottle of wine, so you may need two types of cost - the cost of feeding everyone and the actual cost of the shopping you will have to do to make sure you have enough!
You can add a front page with hyperlinks to other pages and your logo; you can use LOOKUPS; absolute cell references; data validation to give drop down boxes; ROUNDUP; AUTOSUM; cell protection; gridlines; shading; cell merging and alignment ......
Quick Worker Task!:
Make a copy of your existing spreadsheet and add the word 'exploration' to the end of the file name. Click here to go to a set of video tutorials that will extend your understanding of spreadsheet functions/facilities - see how many of these you can utilise in your spreadsheet to make it even better.