Booking System Essay Example

Booking System Essay Example Booking System Essay Booking System Essay 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 worksheetsIn this section, I am showing how I set up my sheets and named my cells and sheets.Section 2: Setting up the zones floor 2In this section I am showing how I created my seating zones and added a logo. |Section 3 Hiding the gridlinesIn 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 ValidationYou 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 isnt working.Section 6: Setting up Conditional FormattingTo Set Up The Conditional Formatting You Have To.Section 7: Setting up the messageboardSection 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 Ava ilable, (IF(AR13=0, None Available, Limited Seats)))Section 11: Not Needed.Section 12: Using CountIF statements to count the number of Adults, Teenagers ; Children=COUNTIF(ZoneA,C)+COUNTIF(ZoneB,C)Section 13: Linking cells (e.g. linking floor 1 and floor 2)Section 14: Setting up the accounts pageSection 15: Creating a menuSection 16: Creating macros to link the worksheets togetherSection 17: Decorating the booking systemSection 18: Locking Cells