Speech bubbles are telling you how to do things.
The square boxes are hints on how to make it better.
Section 1: Setting up the worksheets
In this section, I am showing how I set up my sheets and named my cells and sheets.
Section 2: Setting up the zones – floor 2
In this section I am showing how I created my seating zones and added a logo. |
Section 3 Hiding the gridlines
In this slide, you click on; Tools, Options and then at the bottom take out the tick next to Gridlines, so that they are hidden.
Section 4: Setting up Data Validation
You also have to create a error message, so if somebody types in a letter that is not valid, a message comes up explaining why it isn’t working.
Section 6: Setting up Conditional Formatting
To Set Up The Conditional Formatting You Have To.
Section 7: Setting up the messageboard
Section 8: Naming Cells (Naming Zones)
Section 9a: Using Counta;
Section 9b: Using Countblank;
Section 9c: Using CountIF;
Section 10: Using If statements to display messages
=IF(AR13>20, “Seats Available”, (IF(AR13=0, “None Available”, “Limited Seats”)))
Section 11: Not Needed.
Section 12: Using CountIF statements to count the number of Adults, Teenagers & Children
Section 13: Linking cells (e.g. linking floor 1 and floor 2)
Section 14: Setting up the accounts page
Section 15: Creating a menu
Section 16: Creating macros to link the worksheets together
Section 17: Decorating the booking system
Section 18: Locking Cells