I am a pretty organized person.  I also tend to be very efficient with computer — I’m always looking for the faster way to do things. Applying these qualities to my job search, I have perfected my process, and thought I’d share my “Top 8 tips for automating your job search”:

1. Tracking job applications

It is really important to track what jobs you have applied for.  The three most important reasons that come to my head are: a) If you are contacted about a job, you will easily know where you originally found the job so can find the job description again, b) You may see the same job listed week after week, so it’s easy to go back to your list and see if you have applied for the job already, and c) Many headhunters will want to know if you have submitted your resume to a company they want to present you for.

The columns I have on my tracking spreadsheet are:

Jobs Applied For

  • Company
  • Position
  • How Heard (how I heard about the job)
  • How Applied (monster, their website, email, etc.)
  • Date Applied
  • Contacts (people I know at the company)
  • Status
  • Notes

As soon as I apply for a job, I fill in all columns.  I can easily search for a company using CTRL+F if I want to see if I’ve applied to the job already.  And, if I receive a “ding” notice (a rejection letter) from the company, I move them to the bottom of my spreadsheet in the “DEAD” category.  Most companies don’t get back to you, but if they do, it helps to know the status.

2. Email address

I find it overwhelming to have all the job search emails coming into my regular email account, so I use a separate email address for any websites I register for related to my job search.  Mentally, it’s easier to separate myself from my job search sometimes without the emails starting me in the face.

3. Autofill

Download the Google toolbar for whatever browser you use.  The feature “Autofill” allows you to enter standard contact information on web pages with the click of one button.  When you’re applying for tons and tons of jobs online, having to retype your contact information can be a huge time waster.  Autofill saves you all that time!

4. Networking list

I have been doing a lot of networking over the past few months.  At first, I wasn’t very organized about it and kept people’s names in 10 different places.  Finally, I got organized and put together a networking spreadsheet that has helped get everything together in one place and remind me who to follow up with (believe it or not, not everyone responds to you!).

The columns I have on my tracking spreadsheet are:

  • Name
  • Company
  • Contact (my contact who sent me to this person)
  • Emailed (date I emailed them)
  • Follow-up (date I should follow up with them — see below for “Conditional Formatting“) – 10 days after the date I emailed them
  • Met/Talked (date I met with or spoke to them)
  • Processed notes (date I looked through and completed the followups from the notes from our discussion)
  • TY note (date I wrote a thank you note)
  • LinkedIn (date I connected with them on LinkedIn — only do this after I’ve spoken to the person)
  • Entered contact info (put their contact info into my Outlook contact list)
  • Thanked original person (emailed my original contact to let them know that I met their contact)
  • Status/notes

Once all the columns are completed for a person, I move them to a “Closed” tab in the spreadsheet, to keep them separate from the active ones.

Another use for this sheet is that oftentimes when you meet someone, they say “I think it would be great for you to talk to John Smith.  I’ll get in touch with him and let you know when you can contact him.”  This is an area of high “slippage” (they forget to follow up with you!), so at the bottom of my networking spreadsheet, I also list my contacts so I remember to follow up with them.

5. Conditional formatting

Conditional formatting is one of the most useful tools in Microsoft Excel.  Basically, it allows you to say “format a cell this way, if a certain condition exists”.  So, what I do, is I create this on the “follow-up” cell so that once the date I’m supposed to follow up has passed, the cell highlights in pink.  That way, I can quickly scan my spreadsheet every day, and see who I need to follow up with.

To do this in Microsoft Office 2007, go to Home and select Conditional Formatting, and it’s very self-explanatory.  Contact me if you need help setting this up!

6. RSS Reader

For those of you who don’t know what an RSS reader is, basically, it’s a way to bring website content updates to you, rather than you going and getting them.  So instead of having to log on to Monster, Hotjobs, Indeed, etc. every day, an RSS reader like Google Reader brings the job postings to you.  It also allows you to mark items as read, and star your favorites.  I find that it helps me organize what I’ve looked and what I haven’t.  And, I can quickly scan for good jobs if I only have a bit of time, and know that I haven’t read the rest of the listings.

I only started using RSS feeds back in June, and now I’m in shock when I see sites that don’t  have an RSS feed!

Google Reader

7. Cover letter

I have a standard cover letter with the name “cover letter template”. Each time I start a new cover letter, I open the template, and do a Save As with the company’s name.  I am using Office 2007, so I also have my template anchored to the menu bar so I can easily access it.

The template has all customizable items highlighted in red (i.e. COMPANY). That way, I can easily see what needs to be changed for each company.  After I’ve filled in all the red text, I click CTRL+A to highlight the entire letter, change the font to black, CTRL+C to copy the entire letter, and in the email or webpage, CTRL+V to paste the entire letter.  It’s very quick and easy to do.

Cover Letter Template

8. Indeed.com

Indeed.com is a website that I discovered recently.  It essentially goes and looks at many other job search sites out there, and brings the results into one site.  So, you don’t have to look at as many websites.  Of course, just to be sure, I still do, but I spend most of my time using Indeed.

My next blog post will be a list of my other favorite job search sites.

Do you have any tips of your own?  Please share them below!

Be Sociable, Share!
    If you enjoyed this post, make sure you subscribe to my RSS feed!
    • http://twitter.com/skaufman24 Scott Kaufman

      Good tips. I recommend http://asktheheadhunter.com for good perspectives on job searching, online sites, etc., and http://jibberjobber.com if you want to track and store your search details online.

    • http://twitter.com/skaufman24 Scott Kaufman

      Good tips. I recommend http://asktheheadhunter.com for good perspectives on job searching, online sites, etc., and http://jibberjobber.com if you want to track and store your search details online.

    • http://twitter.com/Jiibe/statuses/1085536281 Jiibe (Greg Scott)

      Thx! @bostonmarketer – This is a great strategy to get organized for your job search! http://bit.ly/12T6V

    • http://sarahmontague.wordpress.com/ Sarah Montague

      You are organized!

      I am in the same boat and the other tips I have are:

      1)Leverage the Hidden Job Market. Identify companies or organizations you want to work with, use LinkedIn to find connections to those companies, use RSS feeds to find info on those companies. This helps you take advantage of the hidden job market, those opportunities that pop up that might be filled before they get to posting.

      2) Create opportunities. Sometimes you may see an article about a company initiative (company merger, spin off, product launch) and you can write to the company to tell them how you can help them. Could be a long shot, but you never know.

      3) Use Twitter to search industry and companies, you may find connections & ideas.

      4) Always let everyone you know where and when you landed. Thank them again for their help and reiterate that you are always available to help.

      5) Volunteer somewhere. Could be related to your work or interests(volunteer as marketing person for nonprofit). Volunteering makes you feel good and when you feel good, you are “more yourself” and interesting opportunites to emerge.

      Sarah Montague’s last blog post..When we were fearless

    • http://sarahmontague.wordpress.com Sarah Montague

      You are organized!

      I am in the same boat and the other tips I have are:

      1)Leverage the Hidden Job Market. Identify companies or organizations you want to work with, use LinkedIn to find connections to those companies, use RSS feeds to find info on those companies. This helps you take advantage of the hidden job market, those opportunities that pop up that might be filled before they get to posting.

      2) Create opportunities. Sometimes you may see an article about a company initiative (company merger, spin off, product launch) and you can write to the company to tell them how you can help them. Could be a long shot, but you never know.

      3) Use Twitter to search industry and companies, you may find connections & ideas.

      4) Always let everyone you know where and when you landed. Thank them again for their help and reiterate that you are always available to help.

      5) Volunteer somewhere. Could be related to your work or interests(volunteer as marketing person for nonprofit). Volunteering makes you feel good and when you feel good, you are “more yourself” and interesting opportunites to emerge.

      Sarah Montague’s last blog post..When we were fearless

    • http://www.rkgroup.us/ Rick Kirkendall

      Rachel…your process is well done. Would add the best book I have read on the topic of job search. “Rites of Passage” by John Lucht. It is solid with perspectives from the POV of all the important players. Everyone should have it in their biz library. Best…rk

    • http://www.rkgroup.us Rick Kirkendall

      Rachel…your process is well done. Would add the best book I have read on the topic of job search. “Rites of Passage” by John Lucht. It is solid with perspectives from the POV of all the important players. Everyone should have it in their biz library. Best…rk

    • http://www.nooozeguy.com/ Josh Fialkoff

      This is a great list of tips Rachel!

      One idea I have is to use this with a system like David Allen’s “Getting Things Done” methodology (Merlin Mann has written extensively on GTD– here’s a good intro: http://www.43folders.com/2004/09/08/getting-started-with-getting-things-done).

      This way you could leverage your contacts even more (for instance, by collecting all of the topics and connections you want to discuss with a particular contact).

      -Josh

    • http://www.nooozeguy.com Josh Fialkoff

      This is a great list of tips Rachel!

      One idea I have is to use this with a system like David Allen’s “Getting Things Done” methodology (Merlin Mann has written extensively on GTD– here’s a good intro: http://www.43folders.com/2004/09/08/getting-started-with-getting-things-done).

      This way you could leverage your contacts even more (for instance, by collecting all of the topics and connections you want to discuss with a particular contact).

      -Josh

    • http://ariwriter.com Ari Herzog

      Along the lines of your autofill advice above for forms, how about for passwords? If you use Firefox as your browser, you can do what I do and install the Sxipper addon which memorizes which usernames and passwords go with which profiles through intuitive training: http://www.sxipper.com

      Ari Herzog’s last blog post..Why I Shake My Head at Obama

    • http://www.ariwriter.com Ari Herzog

      Along the lines of your autofill advice above for forms, how about for passwords? If you use Firefox as your browser, you can do what I do and install the Sxipper addon which memorizes which usernames and passwords go with which profiles through intuitive training: http://www.sxipper.com

      Ari Herzog’s last blog post..Why I Shake My Head at Obama

    • http://kynamdoan.com/ KyNam Doan

      I’ve been receiving email updates by Indeed for new postings. I hadn’t thought about using Google Reader. I’ll try that one out. I also don’t use a spreadsheet for jobs applied. I use google tags and place them all under the same tag “applied jobs.” Definitely easier your way though.

      Thanks for the tips! I’m going to take your advice on two of them.

      KyNam Doan’s last blog post..Cause Marketing: Increase your Profits while Doing Good in 6 Steps

    • http://kynamdoan.com/ KyNam Doan

      I’ve been receiving email updates by Indeed for new postings. I hadn’t thought about using Google Reader. I’ll try that one out. I also don’t use a spreadsheet for jobs applied. I use google tags and place them all under the same tag “applied jobs.” Definitely easier your way though.

      Thanks for the tips! I’m going to take your advice on two of them.

      KyNam Doan’s last blog post..Cause Marketing: Increase your Profits while Doing Good in 6 Steps

    • http://www.ictineducation.org/ Terry Freedman

      Rachel, this is a great example of good use of a spreadsheet.

    • http://www.ictineducation.org Terry Freedman

      Rachel, this is a great example of good use of a spreadsheet.

    • http://twitter.com/ouelletteda/statuses/1097337376 ouelletteda (Danielle Ouellett

      Interesting tactics for automating the job search from @bostonmarketer http://tinyurl.com/6t5jhk

    • http://ryanscottmiller.com/ Ryan

      Great list of tips! I have just started my job search (laid off right before the holidays) and keeping track of jobs applied for and such is something I should have done (and will do).
      Have you delved much into the online resumes like visualcv.com & linkedin.com?

      Ryan’s last blog post..Back to the Old School

    • http://ryanscottmiller.com Ryan

      Great list of tips! I have just started my job search (laid off right before the holidays) and keeping track of jobs applied for and such is something I should have done (and will do).
      Have you delved much into the online resumes like visualcv.com & linkedin.com?

      Ryan’s last blog post..Back to the Old School

    • Joanna Rothman

      Rachel,

      This is truly impressive! As a manager of thousands of volunteers, I find your process to be thoughtful, organized, and demonstrates your future abilities as an employee. I will second the above comment about volunteering. While volunteering at an organization does not guarantee you employment, it certainly helps with skill development, provides you with the ins & outs of the organization, and connects you with the staff.

    • Joanna Rothman

      Rachel,

      This is truly impressive! As a manager of thousands of volunteers, I find your process to be thoughtful, organized, and demonstrates your future abilities as an employee. I will second the above comment about volunteering. While volunteering at an organization does not guarantee you employment, it certainly helps with skill development, provides you with the ins & outs of the organization, and connects you with the staff.

    • Michael

      You’ve got many great tips! Thanks!

    • Michael

      You’ve got many great tips! Thanks!

    • http://bermidor.blogspot.com/ Adrienne

      Excellent tips! Keep up the great work and I’m sure you’ll find something fantastic. I really admire what you’re doing.

    • http://bermidor.blogspot.com/ Adrienne

      Excellent tips! Keep up the great work and I’m sure you’ll find something fantastic. I really admire what you’re doing.

    • Pingback: Worried you might let laid off? | Rachel Levy - Boston marketing pro (social networking, Twitter)

    • Pingback: Daily Endeavor, the Endeavor Prep blog — Career Search Roundup 2009-1-15

    • http://blog.endeavorprep.com/ Matthew Mahoney

      Great tips!

      Matthew Mahoney’s last blog post..Career Search Roundup 2009-1-15

    • http://blog.endeavorprep.com Matthew Mahoney

      Great tips!

      Matthew Mahoney’s last blog post..Career Search Roundup 2009-1-15

    • Pingback: Secret Tips To Finding Your Next Job. | 7Wins.eu

    • https://www.jobsindubai.com/career.asp?qArticleID=60&page=1 Jobs In Dubai

      I would love to share this article that will teach you a 5 tips on how to be nailed on the job you want https://www.jobsindubai.com/career.asp?qArticle… as we all know most of people who are seeking for a job now a days are having a hard time to find a job that is really appropriate to the skills they have

    • https://www.jobsindubai.com/career.asp?qArticleID=60&page=1 Jobs In Dubai

      Such kind of article can be a big help to job seekers as well as this one https://www.jobsindubai.com/career.asp?qArticleID=60&page=1 well job seekers especially the first timers needs an advice to make sure that they are on the right path

    • https://www.jobsindubai.com/career.asp?qArticleID=60&page=1 Jobs In Dubai

      Such kind of article can be a big help to job seekers as well as this one https://www.jobsindubai.com/career.asp?qArticle… well job seekers especially the first timers needs an advice to make sure that they are on the right path

    • Guest

      for me automation is the answer to get things done real quick.

    • http://msidata.com/ MSI Data

      for me automation is the answer to get things done real quick. http://msidata.com/