Everything Job Search

One Way to Stay Organized While Searching for a Job

Last summer, I applied to a lot of jobs, but one problem I ran into is that sometimes I would get contacted for an interview for jobs that I did not remember applying for. I would gladly accept the interview and research the company. As it turns out, I had not always applied for them a recruiter had just come across my resume on Indeed, LinkedIn, etc.

Now that I am searching for a full-time job. I knew I needed to find a way to stay organized and keep track of my job applications.

How did I do this?

The answer is easy…a spreadsheet! As it turns out, Excel (at least the Mac version, but I am sure the PC version does this too) has a template for either a Job Application Log or a Job Application Tracker. Personally, I chose the Job Application Log because it was more pleasing to the eye and had more options.

Screen Shot 2018-02-04 at 11.35.15 PM
My two choices for a pre-made format

How did I find the template?

It is quite simple. Go file à New from Template à Enter ‘job’ in search bar à Choose the template that works best for you!

What happened once I found the template?

Once I found the template I edited a few of the titles and deleted some of the columns that were not necessary for me. I also added another column to number each row so I could keep track of the amount of job applications.

What now?

Now, every time I apply to a job I add the following to my log:

  1. Job Title
  2. Company Name/Website
  3. Date Cover Letter & Resume was sent
  4. How they were sent (i.e. email, through Indeed, on their website, etc.)
  5. References sent (if it was requested)
  6. Application Status
    1. If I was rejected I turn the text in that row red
    2. I write in if they said I would hear from them and would not
  7. Interview Date
  8. Follow up info (whether they contacted me after the interview, whether or not they said they would contact me)
  9. How I heard about the job

The template had most of the titles already put in, so it was a breeze getting started. I also input whether or not I was considered or not.

Outcome

I have yet to find a full-time job, but I only just finished school and I know a lot of people are having trouble finding work, so I know I am not alone. Doing this spreadsheet has not only helped keep me organized, but has made me feel as though I have been working hard to find work and this spreadsheet demonstrates this.

How do YOU keep organized during your job search? Please provide your input in the comments.

Thanks for reading my post!

-Ariel

Website

LinkedIn 

Twitter: @ArielPandachuck

Instagram: @Ariellmp

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Google+ photo

You are commenting using your Google+ account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s