logo
g Text Version
Beauty & Self
Books & Music
Career
Computers
Education
Family
Food & Wine
Health & Fitness
Hobbies & Crafts
Home & Garden
Money
News & Politics
Relationships
Religion & Spirituality
Sports
Travel & Culture
TV & Movies

dailyclick
Bored? Games!
Nutrition
Postcards
Take a Quiz
Rate My Photo

new
Painting
Heart Disease
Horror Literature
Dating
Hiking & Backpacking
SF/Fantasy Books
Healthy Foods


dailyclick
All times in EST

Full Schedule
g
g Desktop Publishing / Ebooks Site

BellaOnline's Desktop Publishing / Ebooks Editor

g

Manage you Job Search with Excel

Guest Author - Chris Curtis

In today’s economic environment looking for work is a tough job. Posting your resume on a job search site just isn’t going to be enough to land you that position which satisfies your goals. It’s going to take a considerable effort on your part. Tracking your efforts using Excel could help you organize your contacts, resume submissions, applications and interviews.

Let’s begin to set up your workbook structure. Unless you have made changes to your Excel defaults, when you open up a new workbook, you will have three worksheets with which to work. For your basic jobs search workbook, you will need two worksheets. Here’s what to do:

1. Launch Excel and Open a new workbook
2. Rename two of your worksheets as follows: Websites, Positions – to rename your worksheet: Double click on the worksheet tab and type the label you want.

The first step in your process is to choose which career websites you will use. You will do an extensive search and determine those job search sites that best fit your needs. Once you identify the website, you want to track those on your first worksheet tab which you named Websites. To set up your worksheet for Websites do the following:
• In Cells A2 through H2– Type the following headings: Website, URL, Log on ID, Password, Date Posted Resume, Date Posted Cover Letter, Position Available, Requirements, Other
• Select range – Click on Bold (the formatting is important for Excel to recognize this row as a header row of a list. Setting the worksheet up as a list, you will be able to sort and filter your information)
• As you locate websites, enter the information necessary according to the heading you have established.

The Positions worksheet will help you track leads given to you through your networking efforts. Set up your worksheet as follows:
• In Cells A2 through L2: Date, Position, Company, Contact Name, Phone Number, email address, mailing address, city, state, zip code, web site, referral source, date resume sent, date of interview, thank you letter date, comments, follow-up.
• Select range – Click on Bold
• Enter the data for each position for which you are applying.

With your first worksheet, you will track which websites you have selected offering positions that are suitable for your skill set. I recommend that you drag the URL from the browser to the worksheet to provide a direct link from Excel to each job search website.

The second worksheet is all purpose. Here you will track each potential position for which you have an interest. Record all of the pertinent information about each position including any follow-up actions necessary to secure the position.

Keep your documents in order, as well. If you are forwarding resumes and thank you letters by email, set up a folder titled Job Search in which to store these important communications. In your "My Documents" folder set up a folder also title Job Search in which to store your resume, inquiries, and thank you letters. Remember, if you want the position, be sure to follow-up any interviews (including phone interviews) with a thank you letter. In your thank you letter, you should be specific about how your qualifications meet those objectives of the position for which you seek. Good luck!




Add Manage+you+Job+Search+with+Excel to Twitter Add Manage+you+Job+Search+with+Excel to Facebook Add Manage+you+Job+Search+with+Excel to MySpace Add Manage+you+Job+Search+with+Excel to Del.icio.us Digg Manage+you+Job+Search+with+Excel Add Manage+you+Job+Search+with+Excel to Yahoo My Web Add Manage+you+Job+Search+with+Excel to Google Bookmarks Add Manage+you+Job+Search+with+Excel to Stumbleupon Add Manage+you+Job+Search+with+Excel to Reddit




RSS | Related Articles | Editor's Picks Articles | Top Ten Articles | Previous Features | Site Map


For FREE email updates, subscribe to the Desktop Publishing / Ebooks Newsletter


Past Issues


print
Printer Friendly
bookmark
Bookmark
tell friend
Tell a Friend
forum
Forum
email
Email Editor


Content copyright © 2013 by Chris Curtis. All rights reserved.
This content was written by Chris Curtis. If you wish to use this content in any manner, you need written permission. Contact Laura Nunn for details.

g


g features
Becoming a Fiction Editor

Making a Background Transparent Using Photoshop

Merging Letters in Word 2007

Archives | Site Map

forum
Forum
email
Contact

Past Issues
memberscenter


vote
Poetry
Daily
Weekly
Monthly
Less than Monthly



BellaOnline on Facebook
g


| About BellaOnline | Privacy Policy | Advertising | Become an Editor |
Website copyright © 2013 Minerva WebWorks LLC. All rights reserved.


BellaOnline Editor