Plain-English Spreadsheet Analytics for Business Analysts & Ops.

SELECT department, SUM(amount) AS total_expense, COUNT(*) AS transactions
FROM [Expenses$]
WHERE expense_date >= '2026-04-01' AND expense_date <= '2026-06-30'
GROUP BY department
ORDER BY total_expense DESC;

SELECT o.order_id, o.order_date, o.total_amount, c.customer_name, c.email, c.region
FROM [Orders$] o
INNER JOIN [Customers$] c ON o.customer_id = c.customer_id
WHERE o.order_status = 'Completed';

SELECT email, COUNT(*) AS occurrences
FROM [Contacts$]
GROUP BY email
HAVING COUNT(*) > 1
ORDER BY occurrences DESC;

SELECT carrier, AVG(DATEDIFF(day, shipped_date, delivered_date)) AS avg_days
FROM [Shipments$]
WHERE status = 'Delivered'
GROUP BY carrier;