Staying organized is an important part of searching for a job. There are so many individual pieces of information you need to keep track of. What was that job opening you saw yesterday? And where was it? Which jobs have you applied for? What was the username and password you created for that job website? In January, one of our Career Center staff led a seminar on how to power your job search with Google Tools. This post is a quick introduction on how to do that.
- In order to use Google Tools to power your job search you first need a Google/Gmail account. If you have a Google/Gmail account then go to Google.com and Sign in. If you do *not* have a Google/Gmail account then go to Google.com and Create account. Once you’re signed in, go into your Google Drive (drive.google.com).
- On your Google Drive page click on New in the upper left. Then on Google Sheets. This will create a new Google Sheets.
- Let’s take a moment and get oriented to what a Google Sheet looks like. Each sheet contains little rectangles called Cells. Cells are organized into Rows (which have numbers) and Columns (which have letters). Each cell also has an address based on its Column and Row, such as A1. You can click on a cell to add text, formatting, functions, and formulas.
- Let’s add some headings to your sheet. You can use these or make up your own: Job Position, Company Name, Job Location, Salary or Hourly Rate, Website URL (so you can go back to that job listing), Notes, Progress. You can click on each cell to add text. You can also hit Tab to move to the next cell on the same row.
- The next step is pretty cool. You can use your sheet to track the status of each application in your job search. One good way to do this is by using data validation. Data validation helps you control what kind of data you enter in your sheet. Data validation can create a drop-down list of items for each cell so you do not have to type in the same data every time.
Click on the G above Progress. This selects that column. Then click on Data > Data Validation.
- In the Data validation window next to Criteria click the box and choose List of items. In the box that says Enter items separated by a comma type a list of options separated by commas. For example Have not started, Resume in Progress, Submitted, Interview Scheduled, Offer received. Then click on Save. Congratulations! Now every cell on that column will have a little drop down menu.
- As you enter on each row a new job opening, you can choose the status of your progress. Everything from Haven’t started to Offer received. Click on a cell in that column and try it.
- Finally give your sheet a name. Click where it says Untitled spreadsheet and enter a helpful name for this sheet. Something like My Job Search 2020.
- Your job search sheet is now ready for you to put some information in each row. So click on the + on your web browser to open a new tab and look for some jobs.
Continued in Power Your Job Search with Google Tools, Part Two
Written by Richard Wright