Create Excel Ticket Sales Form

# Create an Excel Ticket Sales Form

Create complete instructions for building an Excel ticket sales form and tracking sheet for [EVENT_NAME] — a [EVENT_TYPE — e.g., gala, concert, conference, fundraiser, school play] on [EVENT_DATE] at [VENUE].

## Form Requirements
- **Ticket types:** [TICKET_TYPES — e.g., General $25, VIP $75, Student $15]
- **Maximum capacity:** [CAPACITY] seats
- **Fields to capture:** Buyer name, email, phone, ticket type, quantity, payment method, payment status
- **Skill level of user:** [SKILL_LEVEL — e.g., beginner with Excel]

## Deliverables

### Sheet 1: Ticket Sales Entry Form
Step-by-step instructions to create:
- Data validation dropdowns for ticket type and payment method
- Auto-calculated total price (quantity × price)
- Conditional formatting: highlight unpaid orders in red
- A sequential order number (auto-incrementing)

### Sheet 2: Sales Dashboard
- Total tickets sold by type (COUNTIF)
- Total revenue collected vs. outstanding
- Remaining capacity (capacity minus tickets sold)
- Simple bar chart: tickets sold by type

### Sheet 3: Print-Ready Confirmation Template
- Mail merge-style confirmation that can be copied and pasted into an email
- Pulls buyer name, ticket type, quantity, total, and order number from Sheet 1

## Step-by-Step Build Instructions
Provide numbered instructions for building each sheet from scratch, including exact formulas.

## Formulas Reference
List all formulas used with plain-English explanations.

Write in a clear, beginner-friendly tone. Include example data.