Build a Job-Market Skills Dashboard

Compare live job postings and build an evidence-based career action plan.

Introduction

30 Second Summary

Several job postings can sound equally promising while asking for very different proof. Scattered notes make it hard to see which opportunity deserves your time.

In this project, you will build a Google Sheets dashboard that compares three current vacancies. The dashboard will reveal a defensible target role plus the evidence you should build next.

What You'll Build

Your finished workbook gives you one screen to show someone your chosen role, the market evidence behind it, your strongest proof, and your next portfolio move.

By the end of this project, you'll have:

  • A three-role comparison where you can review current postings side by side using interest scores plus honest reasons for your interest.
  • An evidence map that connects twelve role requirements to examples from your work, education, volunteering, or personal projects.
  • A defensible target role plus action plan backed by a transparent fit score, visible hard blockers, a focused portfolio brief, and truthful application language.
  • Secret Mission: Add a fourth vacancy to test whether your chosen target still holds up.

Are there any prerequisites?

A Google Account gives you access to Google Sheets at no cost for this project. No spreadsheet experience is required because the guide includes setup for computers plus Android and iOS devices.

Before We Start

Before the hands-on work begins, commit to using real vacancies and honest evidence. Defining the employment outcome you want gives every comparison in your dashboard a clear purpose.

Set Up Your Job-Market Workbook

Job-search notes become scattered quickly. Once vacancy links sit apart from your evidence, every comparison becomes harder to defend.

In this step, you will create one Google Sheets workbook for your opportunities, skills, ranking, and next actions. Your employment outcome from Step 0 remains the goal that guides this workspace.

In this step, get ready to:
  • Access Google Sheets with a Google Account.
  • Create the Job-Market Skills Dashboard workbook.
  • Organize the workbook into four named tabs.
Access Google Sheets on your device

A Google Account gives you access to Google Sheets. You can use a Gmail address or an existing non-Gmail email address.

Your password stays inside Google's sign-in flow. This project never asks you to place it in the workbook.

  • Choose the device tab that matches how you plan to use Google Sheets.

Computer browser

Choose the account state that matches your situation.

✔️ I already have a Google Account

  • Open sheets.google.com in your computer browser.
  • Click Sign in if Google asks you to authenticate.
  • Enter your existing Google Account details.

You should reach the Google Sheets home screen while signed in to your account.

ⓧ I need a Google Account

  • Open sheets.google.com in your computer browser.
  • Click Sign in.
  • Click Create account.
  • Choose Personal use.
  • Select Use your existing email if you want to register a non-Gmail address.
  • Complete each on-screen account prompt.
  • Return to sheets.google.com.
  • Sign in with your new Google Account.

You should reach the Google Sheets home screen while signed in to your new account.

Android

Choose the account state that matches your situation.

✔️ I already have a Google Account

  • Open the Google Play Store on your Android device.
  • Search for Google Sheets.
  • Tap Install.
  • Open the Google Sheets app.
  • Sign in with your existing Google Account.

You should see the Google Sheets file list under your account.

ⓧ I need a Google Account

  • Open the Google Play Store on your Android device.
  • Search for Google Sheets.
  • Tap Install.
  • Open the Google Sheets app.
  • Choose the sign-in option.
  • Tap Create account.
  • Choose Personal use.
  • Select Use your existing email if you want to register a non-Gmail address.

Google now guides you through the remaining account details.

  • Complete each on-screen account prompt.
  • Return to the Google Sheets app.
  • Sign in with your new Google Account.

You should see the Google Sheets file list under your new account.

iOS

Choose the account state that matches your situation.

✔️ I already have a Google Account

  • Open the App Store on your iPhone or iPad.
  • Search for Google Sheets.
  • Tap GET.
  • Approve the installation if your device asks for authentication.
  • Open the Google Sheets app.
  • Sign in with your existing Google Account.

You should see the Google Sheets file list under your account.

ⓧ I need a Google Account

  • Open the App Store on your iPhone or iPad.
  • Search for Google Sheets.
  • Tap GET.
  • Approve the installation if your device asks for authentication.
  • Open the Google Sheets app.

The app now gives you access to Google's account sign-in flow.

  • Choose the sign-in option.
  • Tap Create account.
  • Choose Personal use.
  • Select Use your existing email if you want to register a non-Gmail address.
  • Complete each on-screen account prompt.
  • Return to the Google Sheets app.
  • Sign in with your new Google Account.

You should see the Google Sheets file list under your new account.

Access is sorted. Google Sheets is now ready to keep your job-market evidence in one connected workspace.

Can't Reach Google Sheets?

  • Check that your device has an active internet connection.
  • Confirm that Google Sheets shows the account you want to use for this project.
  • Use Google's account-recovery option if your existing password is rejected.
  • Still stuck? Help me access Google Sheets with my Google Account.
Create your workbook

Google Sheets stores the workbook in Google Drive while you work. A clear title gives every later tab one stable home.

  • Choose your device path to create the workbook.

Computer browser

  • Click Create on the Google Sheets home screen.
  • Select the blank spreadsheet option.
  • Click Untitled document at the top of the spreadsheet.
  • Enter Job-Market Skills Dashboard as the title.
  • Press Enter.

You should see Job-Market Skills Dashboard at the top of the open workbook.

Android

  • Tap Create in the bottom-right corner of the Google Sheets app.
  • Choose the new file option.
  • Return to the Google Sheets file list.
  • Tap More beside the new spreadsheet.
  • Tap Rename.
  • Enter Job-Market Skills Dashboard.
  • Tap Ok.
  • Tap the renamed workbook to reopen it.

You should see Job-Market Skills Dashboard at the top of the open workbook.

iOS

  • Tap Create in the bottom-right corner of the Google Sheets app.
  • Choose the new spreadsheet option.
  • Enter Job-Market Skills Dashboard as the spreadsheet name.
  • Tap Create.

You should see Job-Market Skills Dashboard at the top of the open workbook.

Your dashboard now has its permanent home. The workbook is open under the exact name you will use throughout the project.

Workbook Title Not Saving?

  • Click the title at the top again if the computer version still shows its original name.
  • Use the file menu's Rename option if the mobile app still shows its original name.
  • Confirm that your device is connected to the internet so the workbook can sync.
  • Still stuck? Help me rename my Google Sheets workbook.
Add the four dashboard tabs

Each tab holds one stage of your employment decision. This separation keeps the final ranking traceable to the vacancies and evidence behind it.

  • Choose your device path to create the four blank tabs.

Computer browser

  • Click Add sheet three times at the bottom of the workbook.

You should now see four blank tabs along the bottom of the workbook.

  • Double-click the first tab name.
  • Enter Opportunities.
  • Press Enter.
  • Double-click the second tab name.
  • Enter Skills.
  • Press Enter.

The first two tabs should now read Opportunities and Skills.

  • Double-click the third tab name.
  • Enter Dashboard.
  • Press Enter.
  • Double-click the fourth tab name.
  • Enter Action Plan.
  • Press Enter.

Android

  • Tap the plus icon beside the tab row three times.

You should now see four blank tabs in the workbook.

  • Tap the Down arrow on the first tab.
  • Tap Rename.
  • Enter Opportunities.
  • Tap OK.
  • Tap the Down arrow on the second tab.
  • Tap Rename.
  • Enter Skills.
  • Tap OK.

The first two tabs should now read Opportunities and Skills.

  • Tap the Down arrow on the third tab.
  • Tap Rename.
  • Enter Dashboard.
  • Tap OK.
  • Tap the Down arrow on the fourth tab.
  • Tap Rename.
  • Enter Action Plan.
  • Tap OK.

iOS

  • Tap the plus icon beside the tab row three times.

You should now see four blank tabs in the workbook.

  • Tap the Down arrow on the first tab.
  • Tap Rename.
  • Enter Opportunities.
  • Tap OK.
  • Tap the Down arrow on the second tab.
  • Tap Rename.
  • Enter Skills.
  • Tap OK.

The first two tabs should now read Opportunities and Skills.

  • Tap the Down arrow on the third tab.
  • Tap Rename.
  • Enter Dashboard.
  • Tap OK.
  • Tap the Down arrow on the fourth tab.
  • Tap Rename.
  • Enter Action Plan.
  • Tap OK.

Before you check, which four tab labels do you expect to find in the workbook?

  • Confirm that Job-Market Skills Dashboard appears at the top of the open workbook.
  • Read every tab label from left to right on a computer.
  • Swipe across the tab row to check every label on a mobile device.

You should see the blank tabs Opportunities, Skills, Dashboard, and Action Plan. This confirms that your workbook structure is ready.

Missing a Tab?

  • Count the tabs to confirm that the workbook contains four.
  • Add another blank tab if the count is below four.
  • Rename any incorrect label with the exact spelling shown above.
  • Still stuck? Help me fix my Google Sheets tab structure.

Your job-market workspace is ready. Next, you will fill the Opportunities tab with three real vacancies that you can compare.

Capture Three Real Opportunities

Your Job-Market Skills Dashboard has its four tabs in Google Sheets. Now the Opportunities tab needs the real market evidence that drives everything else.

Career ideas stay vague until they sit beside real vacancies. A visible table turns those ideas into concrete options you can compare.

In this step, get ready to:
  • Find three active vacancies from the same role family.
  • Record each vacancy's details with an interest score.
  • Mark your current favorite from the completed shortlist.
Find three related vacancies

A useful comparison needs vacancies from the same role family. Similar roles let your later analysis compare like with like.

  • Refer to your employment outcome statement from earlier.
  • Search for active vacancies that support that outcome.
  • Choose three genuinely interesting roles from the same role family.
  • Prefer the employer's own careers page when one is available.
  • Confirm each posting still accepts applications.
  • Keep all three posting pages available while you complete the workbook.

Why compare related roles?

Related vacancies reveal patterns across employers. Those patterns help you separate common market expectations from requirements that belong to only one posting.

Build the Opportunities table

Each vacancy occupies one row. A fixed header row keeps the same detail in each column.

  • Switch back to the Opportunities tab in the workbook from earlier.
  • Type Role into cell A1.
  • Type Company into cell B1.
  • Type Location or Work Mode into cell C1.
  • Type Posting URL into cell D1.
  • Type Closing Date into cell E1.
  • Type Interest Score (1-5) into cell F1.

You should now see six headers across the first row. They create a consistent structure for every vacancy.

What does the interest score mean?

The score records how strongly the role appeals to you before fit analysis. It captures interest at this moment.

Use 1 for your lowest interest. Use 5 for your highest interest.

  • Complete row 2 with the details from your first posting.
  • Complete row 3 with the details from your second posting.
  • Complete row 4 with the details from your third posting.
  • Keep any unavailable closing date cell blank.

You should see three populated rows beneath the headers. Each row should end with an interest score.

Choose your current favorite

A score becomes more useful when you record the reason behind it. This preserves what attracted you before the fit analysis changes your view.

  • Type Why It Interests Me into cell G1.
  • Write one honest sentence in cell G2 explaining your interest in the first role.
  • Write one honest sentence in cell G3 explaining your interest in the second role.
  • Write one honest sentence in cell G4 explaining your interest in the third role.
  • Review the three interest scores.
  • Choose the role that currently appeals to you most.
  • Prefix that role's reason with Current favorite:.

Before you review the finished table, which role do you expect to stand out from the three interest scores? Hold that answer in mind.

  • Scan cells A1 through G1 to confirm all seven headers are present.
  • Check every vacancy row for a posting link.
  • Check every vacancy row for an interest score from 1 to 5.
  • Check every vacancy row for one honest reason.
  • Confirm one reason starts with Current favorite:.
  • Confirm the Skills tab remains visible.
  • Confirm the Dashboard tab remains visible.
  • Confirm the Action Plan tab remains visible.

What should I see?

  • Three complete vacancy rows are visible.
  • Every row contains a posting link.
  • Every row contains an interest score.
  • Every row contains one honest reason.
  • One reason carries the current favorite marker.

Strong start. Your dashboard now replaces vague role ideas with three opportunities you can compare.

Your shortlist is ready. Next up, you'll map the requirements behind each role to your current evidence.

Map Requirements to Honest Evidence

Your three vacancies turn your Google Sheets workbook into a concrete shortlist. The interest scores show which opportunities attract you most.

Interest cannot prove that you can demonstrate a role's requirements. This step uses evidence mapping to connect each requirement to truthful proof from your experience.

In this step, get ready to:
  • Build a requirement-by-requirement evidence matrix.
  • Extract four explicit requirements from each vacancy.
  • Score twelve requirements using evidence you can explain or show.
Build the evidence matrix

An evidence matrix gives each requirement its own row. The columns capture where the requirement came from plus the evidence you currently have.

  • Switch back to the Skills tab.
  • Enter Role in cell A1.
  • Enter Exact Requirement in cell B1.
  • Enter Category in cell C1.
  • Enter Must-Have? in cell D1.
  • Enter Evidence Level (0-2) in cell E1.
  • Enter Evidence Example in cell F1.

You should see six headings across the first row of the Skills tab. This structure keeps every requirement connected to its source and your evidence.

Extract and classify twelve requirements

Requirement extraction means lifting explicit expectations from a posting into a structure you can compare. Keep the posting's wording so every row stays grounded in real market evidence.

How do the categories work?

  • A skill is an ability such as stakeholder communication or data analysis.
  • A tool is software or a platform used in the role.
  • A credential is a qualification such as a degree or certification.
  • A responsibility is an outcome or task the person performs in the role.

Use Required when the posting presents the requirement as mandatory. Use Not Required when the posting presents it as optional or preferred.

  • Return to the Opportunities tab.
  • Open the first role's link from the Posting URL column.
  • Identify four explicit requirements in the posting.
  • Return to the Skills tab.
  • Enter the first role's title in cells A2 through A5.
  • Copy one requirement into each cell from B2 through B5.

Rows 2 through 5 should now show the first role beside four requirements taken from its posting.

  • Classify the four requirements in cells C2 through C5.
  • Mark the four requirements in cells D2 through D5 as Required or Not Required.

The first role now has four classified requirements. Each row also shows whether the posting treats that requirement as a must-have.

  • Return to the Opportunities tab.
  • Open the second role's link from the Posting URL column.
  • Identify four explicit requirements in the posting.
  • Return to the Skills tab.
  • Enter the second role's title in cells A6 through A9.
  • Copy one requirement into each cell from B6 through B9.

Rows 6 through 9 should now add four requirements for the second role.

  • Classify the four requirements in cells C6 through C9.
  • Mark the four requirements in cells D6 through D9 as Required or Not Required.

You should now have eight classified requirements across two roles. The repeated structure makes missing information easier to spot.

  • Return to the Opportunities tab.
  • Open the third role's link from the Posting URL column.
  • Identify four explicit requirements in the posting.
  • Return to the Skills tab.
  • Enter the third role's title in cells A10 through A13.
  • Copy one requirement into each cell from B10 through B13.

Rows 10 through 13 should complete the twelve-row requirement list.

  • Classify the four requirements in cells C10 through C13.
  • Mark the four requirements in cells D10 through D13 as Required or Not Required.

Your Skills tab now contains four explicit requirements for each of the three vacancies. That gives every role equal space in the analysis.

Score your evidence honestly

An evidence level measures what you can currently explain or show. It does not measure your potential or your enthusiasm for learning.

How does the evidence scale work?

  • Use 0 when you have no current evidence. Enter No current evidence as the example.
  • Use 1 for partial or learning-stage evidence. Name the course exercise or early project accurately.
  • Use 2 for evidence you can explain or show. Name the concrete task or result that demonstrates it.

Evidence can come from work, education, volunteering, or personal projects. Truthful evidence describes what you actually did without turning exposure into professional experience.

  • Assign an evidence level to the first role's requirements in cells E2 through E5.
  • Add one brief truthful example per requirement in cells F2 through F5.

The first role should now have four evidence levels plus four examples. Every example should describe something you can discuss honestly.

  • Assign an evidence level to the second role's requirements in cells E6 through E9.
  • Add one brief truthful example per requirement in cells F6 through F9.

Eight rows should now contain complete evidence assessments. The zeros matter because they keep genuine gaps visible.

  • Assign an evidence level to the third role's requirements in cells E10 through E13.
  • Add one brief truthful example per requirement in cells F10 through F13.

You now have twelve requirements mapped to honest evidence. Each vacancy has four completed rows.

Before you compare the roles, predict whether your original favorite has the strongest evidence.

  • Compare the favorite role's four evidence levels with the rows for the other two roles.
  • Try to identify the strongest overall fit using only the row-by-row evidence.

The twelve rows expose real strengths and gaps. They still do not produce a complete fit ranking.

That shortfall is intentional. Interest and raw evidence remain separate inputs that are difficult to compare across three roles.

  • Keep the Skills tab open.
  • Confirm that rows 2 through 13 contain twelve requirements.
  • Confirm that every requirement row contains all six requested fields.

You did the careful part by mapping twelve requirements to evidence you can defend. Next, you'll make the three roles directly comparable while keeping hard blockers visible.

Rank Roles by Demonstrated Fit

Your Google Sheets workbook now contains twelve honest evidence scores from the last step. Each evidence row is useful.

The three roles are still difficult to compare. In this step, you'll turn that raw list into a consistent ranking that keeps hard blockers visible. The finished dashboard will point to one defensible target role.

In this step, get ready to:
  • Build one Dashboard row for each role.
  • Convert evidence points into comparable fit percentages.
  • Choose one primary target role with blockers still visible.
Build the comparison table

A comparison table gives every role the same structure. Each row will preserve your original interest score while adding evidence-based measures.

How the Dashboard columns work

  • The Role column identifies the vacancy.
  • The Interest Score column preserves your original interest rating.
  • The Evidence Points column totals the four evidence levels for that role.
  • The Maximum Points column shows the highest possible total of 8.
  • The Evidence Fit column converts the evidence total into a percentage.
  • The Hard Blocker column keeps unmet non-negotiable requirements visible.
  • The Decision column turns the comparison into a next step.
  • Switch back to the Dashboard tab from earlier.
  • Enter the seven column labels from the callout across row 1 in the same order.

You should see one header row that runs from Role through Decision.

  • Enter the three role names from the Opportunities tab in rows 2 through 4.
  • Transfer each role's matching interest score into the Interest Score column.

You should see three Dashboard rows with the same role names and interest scores as the Opportunities tab.

Do the roles and scores look mismatched?

  • Match each Dashboard role name against the spelling in the Opportunities tab.
  • Keep every interest score on the same row as its role name.
  • Still stuck? Help me align my Dashboard rows with my Opportunities tab.
Calculate evidence fit

Each role has four evidence levels from 0 to 2. Adding those four values produces a score out of 8 that can be compared across all three roles.

  • In the Skills tab from earlier, add the four evidence levels for the first Dashboard role.
  • Record the total in that role's Evidence Points cell on the Dashboard tab.

The first role now has one evidence total between 0 and 8.

  • Repeat the evidence total for the remaining two roles.
  • Enter 8 in the Maximum Points column for all three roles.

You should see three evidence totals measured against the same maximum of 8.

Convert Points into Evidence Fit

Use the same scale for every role. A shared scale makes the comparison transparent.

  • A total of 0 becomes 0%.
  • A total of 1 becomes 12.5%.
  • A total of 2 becomes 25%.
  • A total of 3 becomes 37.5%.
  • A total of 4 becomes 50%.
  • A total of 5 becomes 62.5%.
  • A total of 6 becomes 75%.
  • A total of 7 becomes 87.5%.
  • A total of 8 becomes 100%.
  • Find the first role's evidence total in the conversion scale.
  • Enter the matching percentage in that role's Evidence Fit cell.

The first role now has a percentage that summarizes its four evidence scores.

  • Repeat the percentage conversion for the remaining two roles.
  • Compare the three values in the Evidence Fit column.

You should now be able to see which role has the strongest demonstrated evidence.

Keep blockers visible and choose a target

A high percentage summarizes evidence strength. An unmet non-negotiable requirement can still stop an application from being realistic today.

  • In the Skills tab from earlier, identify any must-have requirement you currently cannot meet for the first role.
  • Complete the first role's Hard Blocker cell with the exact unmet requirement or No current blocker.

The first Dashboard row now shows whether a non-negotiable requirement affects the role.

  • Repeat the hard-blocker check for the remaining two roles.
  • Confirm that every Hard Blocker cell contains an unmet requirement or No current blocker.

Use a Consistent Decision Rule

  • Use Apply Now when Evidence Fit is 75% or higher. The role must also have No current blocker.
  • Use Build Evidence when the role remains relevant. More proof or a resolvable blocker still needs work.
  • Use Do Not Prioritize when the current fit makes another role a more useful focus.

This project uses 75% as a planning heuristic. Employers make decisions using wider context.

  • Assign Apply Now, Build Evidence, or Do Not Prioritize to each role in the Decision column.

Every role now has a decision based on the same evidence rubric.

  • Compare the finished ranking with the favorite you marked in the Opportunities tab.
  • Record one primary target role below the Dashboard table.

Your chosen target is now visible beside the evidence that supports it.

What Makes the Target Defensible?

A defensible target reflects genuine interest. It also has evidence you can explain or show.

Your justification should acknowledge any blocker that still needs work. This keeps the decision honest.

  • Write one sentence below the target that explains why it is your strongest current option.

Before you inspect the finished Dashboard, ask yourself whether your original favorite will remain the strongest target.

  • Check each of the three rows in the Dashboard tab.
  • Confirm that every row has an interest score, evidence points, a maximum of 8, an evidence fit percentage, a blocker check, and a decision.

You should see all three roles compared through the same evidence rubric. One primary target role should appear below the table with a one-sentence justification.

That's the raw-list obstacle resolved. Your Dashboard now turns twelve evidence rows into one career decision you can defend.

Your target role is clear. Next up, you'll turn its strongest evidence gap into a focused portfolio brief and truthful application language.

Build Your Employment Action Plan

Your Google Sheets dashboard now identifies one primary target role from real market evidence. That decision needs a practical next move before it can strengthen your application.

This step turns your ranking into an employment Action Plan for building missing evidence. You will also draft application language that you can support with genuine examples.

In this step, get ready to:
  • Summarize your target role using your strongest evidence.
  • Turn your priority evidence gap into a portfolio brief.
  • Draft truthful application language with a dated next action.
Summarize your target and evidence

Matched requirements show where your evidence is strongest. The priority gap shows which missing proof is most useful to build next.

A hard blocker stays separate because it can stop an application even when the overall evidence score looks strong.

  • Switch back to the Dashboard tab.
  • Confirm the primary target role selected beneath your comparison table.
  • Return to the Action Plan tab.
  • Enter Target Role, Three Strongest Matched Requirements, Highest-Priority Evidence Gap, and Blocker Before Applying across cells A1:D1.
  • Enter your selected role in cell A2.
  • List the three requirements with your strongest evidence in cell B2.
  • Choose the most important weak requirement for cell C2.
  • State the unmet non-negotiable requirement in cell D2. Use No blocker identified when your Dashboard shows no hard blocker.

How do I choose the priority gap?

Start with a requirement marked as required in the Skills tab. Give priority to a requirement with an evidence level of 0 or 1.

Choose a gap that you can address through a focused piece of work. Your portfolio brief turns that gap into evidence you can show.

You should now see one target role with three supported strengths. You should also see the gap that deserves attention before your next application.

Turn your evidence gap into a portfolio brief

A portfolio brief gives your evidence-building work a clear boundary. Each field connects the selected gap to something another person can inspect.

What goes into the brief?

  • The Audience identifies who benefits from the work.
  • The Problem describes the specific need you will address.
  • The Deliverable names the finished item you will produce.
  • The Evidence Produced states what the project lets you demonstrate.
  • The Success Check defines an observable test for completion.
  • The Timebox limits the amount of time you will spend.
  • Enter Audience, Problem, Deliverable, Evidence Produced, Success Check, and Timebox vertically in cells A5:A10.
  • Enter the intended audience for your portfolio work in cell B5.

Your brief now starts with a specific audience. This keeps the project tied to a real need.

  • Describe the audience's problem in cell B6.
  • Name the finished deliverable in cell B7.

You should now see a direct connection between the problem and the item you plan to create.

  • Describe the proof your deliverable produces in cell B8.
  • Define an observable completion test in cell B9.

The brief now states what your project proves. It also defines how you will recognize a finished result.

  • Set a realistic number of hours or days in cell B10.

You should now see all six portfolio fields completed. The brief turns one evidence gap into a bounded project you can finish.

Draft truthful application language

Truthful application language connects the posting's terms to evidence you can explain or show. Course exposure stays described as learning unless you have used it in work you can demonstrate.

Your next action gives the plan momentum. A date turns that action into a commitment you can revisit.

  • Enter Professional Summary, Resume or Cover-Letter Bullet, Next Action, and Date vertically in cells A12:A15.
  • Draft one professional-summary sentence in cell B12 using relevant posting language that accurately matches your evidence.

Read the summary as if an interviewer asked you to prove every claim. Each phrase should connect to an example in your Skills tab.

  • Draft one truthful resume or cover-letter bullet in cell B13.
  • Enter one concrete next action in cell B14.

Your application language now describes demonstrated evidence. Your next action identifies the immediate move that follows this workbook.

  • Enter the date for completing that action in cell B15.

Before you review the finished plan, do you expect every claim to trace back to evidence already in your workbook?

  • Review the completed Action Plan from top to bottom.
  • Compare the claims in cells B12:B13 with the evidence examples in the Skills tab.

You should see your target role, three strengths, one priority gap, and any blocker in the top section.

Below it, you should see all six portfolio fields, two truthful application lines, and one dated next action.

Does the plan feel unsupported?

  • Compare the target role with the primary role selected in your Dashboard tab.
  • Replace any unsupported application claim with language that matches an evidence example from your Skills tab.
  • Still unsure about a claim? Help me check whether my application language is supported by my evidence.

Strong finish. Your employment dashboard now leads to a focused project, defensible application language, and a dated next move.

Secret mission

Secret Mission: Stress-Test Your Target with a Fourth Job

Add a fourth vacancy from the same role family to test your selected target. Repeat the full evidence analysis before recording whether the wider market evidence supports a keep-or-change decision.

Clean Up Your Resources

Clean Up Your Resources

Standard Google Sheets access costs $0 with a Google Account. Choose whether to keep your workbook available, pause by closing it, or move it to Trash.

Resources you used:

  • The Job-Market Skills Dashboard workbook stored in Google Drive.

Keep everything running

No action needed. Choose this if you want to reuse the dashboard whenever you find another relevant vacancy.

  • Keep the Job-Market Skills Dashboard workbook in Google Drive.
  • Update the workbook when you find a new vacancy in your target role family.
  • Use the Dashboard and Action Plan to review whether new market evidence changes your target.

Pause - I'll come back to this later

Pausing keeps your four vacancies, evidence scores, target decision, and employment plan ready for your next session.

  • Close the Job-Market Skills Dashboard workbook.
  • Return later through sheets.google.com in a computer browser or the Google Sheets app on Android or iOS.
  • Confirm that the Opportunities, Skills, Dashboard, and Action Plan tabs are still visible.

Delete - I don't want to use this again

Moving the workbook to Trash removes it from your active files. Google Drive permanently deletes it after 30 days.

  • Open Google Drive in your signed-in computer browser.
  • Find the Job-Market Skills Dashboard workbook in your file list.
  • Right-click the workbook.
  • Click Move to Trash.
  • Select Trash in the left sidebar.
  • Confirm that the Job-Market Skills Dashboard workbook is listed there.

That clears the only project resource from your active files. Google Drive permanently deletes the workbook after 30 days.

Nice Work!

Nice Work!

Excellent work! Your reusable Google Sheets dashboard now turns four live vacancies into a defensible employment strategy.

You've learned how to:

  • Compare current vacancies in a reusable job-market dashboard. The dashboard keeps interest scores beside demonstrated evidence. It also keeps fit percentages beside hard blockers.
  • Map sixteen role requirements to truthful evidence from your own experience. This makes every fit score explainable.
  • Create an employment plan that converts your highest-priority gap into a focused portfolio brief. The same plan includes a truthful professional-summary sentence. It also includes a truthful resume or cover-letter bullet.
  • Stress-test your chosen role against a fourth vacancy in the Secret Mission. Record an evidence-based Keep Target or Change Target decision.

Ready to quiz yourself?