![Page 1: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/1.jpg)
A Theatre Seating Plan
How to use Excel to create a seating plan and ticket sales model
![Page 2: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/2.jpg)
Developing the seating plan
We are learning today (WALT)To name a range of cells and use the COUNTIF function to count how many seats are sold
To calculate income from seat sales
![Page 3: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/3.jpg)
An example…
![Page 4: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/4.jpg)
Using Excel
Seating Plan :We need to
design a seating plan using MS Excel spreadsheet software
![Page 5: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/5.jpg)
The Model
Sales Model :We need to
design a model for calculating income from ticket sales
![Page 6: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/6.jpg)
This lesson…
Learn how to name a range of cells Learn how to use the COUNTIF function Calculate sales
![Page 7: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/7.jpg)
Demonstration – named range
This movie will show you how to name the range of cells that makes up your seating plan
![Page 8: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/8.jpg)
Demonstration - countif
This movie will show you how to use the COUNTIF function in a formula to calculate how many seats are sold
![Page 9: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/9.jpg)
Extension 1…
Conditional formatting to change the seats that have been sold to a different colour so that they stand out
![Page 10: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/10.jpg)
Extension 2…
Create an if formula that will automatically type the text SOLD OUT or AVAILABLE into the cell
![Page 11: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/11.jpg)
Excellent working Excellent working atmosphere today!atmosphere today!
![Page 12: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/12.jpg)
Satisfactory working Satisfactory working atmosphere today.atmosphere today.
![Page 13: A Theatre Seating Plan How to use Excel to create a seating plan and ticket sales model](https://reader035.vdocuments.us/reader035/viewer/2022062303/551a1be455034619378b51ef/html5/thumbnails/13.jpg)
Difficult working Difficult working atmosphere.atmosphere.