- Jobstronauts
- Posts
- How MS Excel got this student a job in the USA.
In partnership with
John was a graduate student in the USA who was looking for jobs but had no luck for a long time as the job market was not at all in good shape.
He had student loans to pay back and family debt, which made him nervous.
On the other hand, he had no idea what he was doing in his job search. He couldn’t track how many jobs he was applying for, what companies he applied to, recruiters' names, or any other details.
To follow up on previous applications, he had to search his email inbox every day, and this made him frustrated with his job search process.
So he reached out to his friend who had recently started a full-time job about this situation.
This changed his entire life; he found out that one tool was responsible for so many students' job search success stories.
The name of the tool: Microsoft Excel !!! 🙃
Read how to use MS Excel below 👇️
Get value stock insights free.
PayPal, Disney, and Nike recently dropped 50-80%. Are they undervalued? Can they recover? Read Value Investor Daily to find out. We read hundreds of value stock ideas daily and send you the best.
1. Create a Job Application Tracker
Steps to Set Up:
Columns to Include:
Job Title
Company Name
Location
Application Date
Contact Person
Email/Phone
Status (Applied, Interview Scheduled, Offer, etc.)
Notes
Benefits:
Keep all your applications in one place.
Track the status of each application.
Set reminders for follow-ups.
Get value stock insights free.
PayPal, Disney, and Nike recently dropped 50-80%. Are they undervalued? Can they recover? Read Value Investor Daily to find out. We read hundreds of value stock ideas daily and send you the best.
2. Analyze Job Search Metrics
Steps to Set Up:
Track Key Metrics:
Number of applications sent per week
Response rate
Interview rate
Offer rate
Benefits:
Identify patterns in your job search.
Adjust strategies based on what works best.
3. Organize Networking Efforts
Steps to Set Up:
Columns to Include:
Contact Name
Company
Position
Date Contacted
Follow-up Date
Notes
Benefits:
Maintain a professional network.
Track communications and follow-up dates.
Ensure consistent networking.
4. Manage Skill Development
Steps to Set Up:
Columns to Include:
Skill
Current Level
Target Level
Resources
Completion Date
Benefits:
Track your skill development progress.
Set realistic goals.
Access resources quickly.
Tips for Maximizing Excel Use:
Use Conditional Formatting: Highlight important dates or statuses with colors.
Set Up Alerts: Use Excel’s built-in alert functions to remind you of important dates.
Leverage Pivot Tables: Summarize and analyze your job search data quickly.
Use Filters: Easily sort and find specific information within your spreadsheet.
To learn more about job search strategies, and get 100 job postings based on your choice everyday in your inbox two times a day for less than a $1 , subscribe to our premium newsletter below 👇️
Happy Juneteenth and Have a happy job search !! See you tomorrow.