Translations:Basic Excel Trainer/20/en

Begin calculating the numbers of people who will be able to attend a workshop dinner (if there is one - if not, think of another example). Have the list of participant names all prepared, then enter a 1 or 0 against them to signify attendance. Then total the column to give the number of attendees (using Excel as a calculator). Next, begin to develop a budget - suggest three types of restaurants, and ask participant preferences (enter 1,2, or 3 in the next column). Have a price for each type of restaurant. Depending on how the exercise is progressing, you could ask if participants have any suggestions about how to proceed for budget development. Explain that there are quite a number of ways of achieving the same outcome, and that some are quite simple, and others more complex, allowing exploration of 'what-if' scenarios. Tell them that in the NEXT workshop, you will be able to work together on some of the more complex approaches, but for now, you will do it very simply, using only those skills they will explore in this workshop. Make a copy of the preference list in the next column, because you may need it again later. Then, use 'find-and-replace' to replace the restaurant code with the appropriate price. Add up the total - now we have a budget! You can also explore 'what-if' scenarios, using the same approach with different prices on the copied restaurant preference code column. Participants may wish to tell you that there are better ways to do this. Ask them to describe these, and to explain why they are better. Do they other participants feel the same way? Have different suggestions? Note whether the skills will be covered in this, or in a subsequent workshop.