Advanced Excel for Analysis | Dataford Interview Questions

How have you used advanced Excel features to analyze and present data?

Demonstrate the SQL equivalent by producing a customer-level sales summary for completed sales from January through March 2025. Include customers without qualifying sales and classify each customer based on total sales.

Output

One row per customer, including customers without qualifying sales.
Columns: customer_name, completed_order_count, total_sales, average_sale, and customer_tier.
Classify customers as High for totals of at least 500, Standard for totals from 200 through 499.99, Starter for lower nonzero totals, and No purchases when no qualifying sale exists.
Order by total_sales descending, then customer_name ascending.

Schema

customers

Column	Type	Description
customer_idPK	INT	Unique customer identifier
customer_name	VARCHAR(100)	Customer display name
region	VARCHAR(50)	Customer region

sales

Column	Type	Description
sale_idPK	INT	Unique sale identifier
customer_id	INT	Customer associated with the sale
sale_date	DATE	Date of the sale
amount	DECIMAL(10,2)	Sale amount
status	VARCHAR(20)	Sale status

Your question is Advanced Excel for Analysis. Start with the requirements and the two tables in the Question tab.

Run and submit as often as you like. When you're ready, talk me through your approach or go straight to the code.

Problem