Create a small spreadsheet project that shows prioritization, ownership, status control, and a useful summary.
Created by the First Role Skills Editorial Team. This lesson uses a fictional workplace scenario and links to primary product documentation where the interface or feature matters.
A realistic scenario
You want to demonstrate spreadsheet judgment without exposing employer data. You will build a fictional two-week admin workload from scratch.
DeliverableA portfolio-ready tracker with clean source data, validation rules, and a short explanation of your design choices.
Three beginner mistakes
- Adding a dashboard before the source table works
- Using color as the only status signal
- Presenting a template without explaining decisions
Complete it in six controlled steps
Define the workflow
Choose a believable scope: incoming requests, due dates, owners, priority, status, and next action. Keep the project small enough to explain in five minutes.
Create a tidy source table
Use one row per task and stable columns. Add fictional IDs, dates, request types, and owners. Do not use real employer, client, or applicant data.
Constrain entries
Use dropdown validation for Status and Priority. Include visible text labels so the tracker remains understandable without color.
Add useful logic
Create an overdue flag that ignores completed tasks. Add counts by status and owner. Test blank dates and tasks due today.
Design a restrained summary
Show three or four decisions: open work, overdue work, blocked tasks, and upcoming deadlines. Avoid decorative charts that do not answer a question.
Write the portfolio note
Explain the scenario, your role, the method, two design choices, how you tested it, and what you would improve with real user feedback.
Before and after
Before:
A colorful sheet with merged headers, no validation, and tasks copied from a real company.
After:
Fictional dataset, validated status fields, overdue logic, summary counts, accessibility note, and a one-page project explanation.
Complete the exercise
Use the starter CSV to build the tracker. Add validation, one overdue formula, three summary counts, and a README sheet describing the fictional data and tests.
Download the task-tracker starter — A fictional two-week workload with 24 tasks and deliberate edge cases. — Download file
Use only fictional or fully anonymized data. Never upload an employer’s confidential information to a portfolio.
Turn the exercise into credible evidence
Package the tracker with a one-page project note. Include the fictional scenario, fields you selected, the overdue rule, edge cases tested, and a screenshot of the restrained summary. State that the data is synthetic. A useful review demonstration is to add a new blocked task, change a due date, and show how the counts update. That proves the workbook behaves as a small system rather than a static colored template.
Check your own work
- Fictional data only
- One row per task
- Validated categories
- Edge cases tested
- Method explained
Primary reference: Google Workspace Learning Center: Google Sheets cheat sheet
Why this matters in your first job
Administrative and operations roles are judged heavily on reliability: did the task get done, on time, without being chased? A simple tracker makes your workload visible to you and your manager, prevents forgotten requests and gives you evidence of what you handled when review time comes. It is also one of the most common portfolio pieces for admin applicants, because employers can see your organization at a glance.
Common questions
Is a spreadsheet good enough, or do I need project software? For one person or a small team, a well-structured spreadsheet is often enough. If your team already uses a project tool, use that instead and apply the same principles: clear owners, statuses and due dates.
How many statuses should I use? Keep the list short, usually four to six. Too many statuses make filtering harder and people stop updating them.
How do I use it in check-ins? Filter by “due this week” and “blocked” before your one-on-one. See how to prepare for your first one-on-one and time management in your first job.