To help keep track of where resumes have been sent, what applications have been filled out, when tests were taken and with which companies, etc., I'm creating an Excel spreadsheet and would like ideas/input.
So far, the column titles under consideration are:
Company Name; Rating (using 5 asterisks - stars method); W2/1099; FT/PT; Appl (date filled out); Resume (date sent out); Cold/Job Listed; Company Replied (date and brief comment such as 5/12/2016 - firmly requiring 1 yr experience ICD-9 coding); Check back (date); Tested (date); Score; Contact/Recruiter (name); Recruiter contact (usually email address); Interview Notes (fixed schedule, constant IM help if needed, direct hire option, etc.); Thank you (date sent); and Company Website (email address). Another possibility for an additional heading could be Experience Required (yrs in this column). You can later organize by column such as years experience required, rating, or just alphabetical.
Possibly Sheet1 could also be used just for cold contact companies and Sheet2 with the same headings but just for companies who had advertised job listings.
Concerning cold contacts, Glenda suggests if the company doesn't reply or if they state they aren't currently hiring but 2-3 weeks later a job listing is posted, you know to check back with them to see if they might consider you at that time. Her recommendation for thank you's is if it's a remote company or if correspondence is primarily done by email, then use an email thank you but if you've dealt with the contact/recruiter in person or on the phone, a mailed thank you would probably be more appreciated.
Or you could use Sheet 1 for W2 employment opportunities and Sheet2 for 1099 IC positions.
Or using separate sheets to organize, you could use Sheet1 for companies contacted before obtaining credentials,
Sheet2 if you apply/test after Module III and/or gaining the CPC, and
Sheet3 for apps/resumes sent after earning the CCS cert.
I'll eventually post something more complete in the graduation section as posts can get buried here after a while and this is needed more in that section anyway.
Your comments, suggestions, and/or ideas are greatly appreciated.
- Thanks, Kim
What a great idea both for spreadsheet(s) and thank you notes.
Great idea Kim. It does start to get confusing!
I started with a company list found on the fb group Jobs For American Medical Coders. I added local companies to it as I applied. Was very helpful!
Also, post your profile to Ziprecruiter, LinkedIn, CareerBuilder and Indeed... Just remember to ONLY post your email as contact info. No need for address or phone number on a searchable site.
Hi Kim!
I don't have any ideas to add to this, I just want to tell you thanks for the excellent idea!