Excel
ChatGPT
CopilotAnalyze
Intermediate·30 min
Analyze hiring practices against requirements
Track open requisitions against hiring requirements and surface where the pipeline doesn't match what the role actually needs.
Word
ClaudeUpdated Sep 30, 2026
Scenario
Costs are rising but revenue is flat.
Mission
Calculate the true margin for the top 50 clients.
Start Files
| ClientID | Revenue | ServiceCost |
|---|---|---|
| C-203 | 72282 | 67222 |
| C-105 | 26358 | 18714 |
| C-200 | 73137 | 69480 |
| C-110 | 20683 | 12823 |
| C-128 | 47144 | 36772 |
Preview — first 5 rows of top-50-clients.csv
Your task
- Join the revenue export with the service-cost export on customer ID.
- Calculate gross margin and margin percentage for each of the top 50 clients by revenue.
- Rank the clients from lowest to highest margin percentage.
Prompt idea:
I have a table of clients with revenue and service cost. Write the Excel formulas to calculate gross margin and margin percentage, then rank clients from lowest to highest margin.
Check Your Result
What is the lowest margin percentage in the dataset (nearest whole number)?
Need a hint?
MarginPct = (Revenue - ServiceCost) / Revenue.
Reveal Solution
The solution files contain the completed challenge. Review the approach to see if you missed any edge cases.
Related Workflows
Analyze
Intermediate·25 min
Classify customer feedback sentiment by theme
Turn a column of open-text customer feedback into themed, pivotable sentiment data.
Updated Sep 30, 2026
WORK WITH LIMINALS
Make AI useful for your team.
Get practical help with AI consulting or ask about training courses for your team.