AOEP Increases Slots for Half-Day Recruiter Bootcamp at Bentley College, Waltham, MA 9/26/07

by Glenn Gutmacher

I signed up to present the Internet sourcing session at the Association of Employment Professionals first annual Recruiter Bootcamp. As with the last several events that this Boston area-focused non-profit has held, it was oversold (over 150 have pre-registered, coming from as far as Maine).

I wasn't going to promote it because I was told it was sold out. But when they oversold, AOEP got the host site, Bentley College, to add additional classroom space and now they have room for 200. AOEP will still offer registration at just $50 (yes, that's a two-digit dollar amount) per person for the half-day program (including breakfast).

The content and speakers are best-in-class. And as a non-profit, all-volunteer organization, AOEP provide this to the employment community at substantially below-market costs.

It will be held at Bentley College this Wednesday, 9/26/07 from 8:00AM  - 12:30 PM. Seating is limited to pre-paid registrants. To pre-register, go to www.aoep.com/chapters/ma/events/form-mass.php or you can print out the registration form and fax it to 617-507-7702. If you have a recent credit card that expires in 2010 or later, you may find it more efficient to simply fax your order. Contact Mike Vangel at 781-895-4040 if questions.

Doors open and Continental breakfast served at 8:00AM. Sessions begin @ 8:30 sharp. Each presentation is 60 minutes long, most will be presented twice. There are three session timeslots in total so you can pick your favorites:

• Optimizing Your Interviewing Skills - Patricia Hunt Sinacole

Patricia is an expert on interview techniques and is a regular columnist in the Boston Globe. She will share valuable insight's from a recruiter's perspective on how to maximize the candidate interview process. Interactive format.

• Internet Sourcing At Light Speed - Glenn Gutmacher

Glenn is AOEP's 2007 H. Michael Boyd Award winner for Excellence in Employment, founder of Recruiting-Online.com, a bonafide Sourcing Sleuth, and a Recruiting Researcher at Microsoft.

• Making Staffing Metrics Meaningful To Your Organization- Dan Kilgore

Dan is the Director of Talent Acquisition for Getronics North America. He has presented on Staffing Metrics nationally to ERE conferences, and locally to NEHRA and AOEP.

• Best Practices In College Recruiting - Panel discussion featuring AOEP "Excellence in Employment" Award Winner, Cindy Gallerani, EMC For Best Practices In College Recruiting.

A very special thanks to event sponsor, Talent Retriever: "Delivering hire results".

P.S. If you miss me at this event, note that I will be presenting in October at the New Jersey Metro EMA Chapter meeting and the 495-128 HR Collaborative near Boston (both are inexpensive), as well as the Recruiting Excellence 2007 conference in Boston, and then in November at the Kennedy Recruiting Conference in Orlando, FL. More details at those websites and in a future blogpost.

by Glenn Gutmacher

Q: I have a Microsoft Excel spreadsheet with thousands of names of potential candidates. I don't intend to blind e-mail them, but I do want to process them all over time. The entries are all in a single column, and look like this:

name1

company1

e-mail address1

ID number1

name2

company2

e-mail address2

ID number2

etc.

I can't find anyone who can tell me how to "rotate" this spreadsheet so that I'll end up with 4 columns that look like this:

name1 company1 e-mail address1 ID number1

name2 company2 e-mail address2 ID number2

A: I'm glad you don't plan to mass-email that many, which can get you in trouble with the US federal CAN-SPAM Act. But I do agree you need to change the vertical orientation to horizontal as you indicated in order to send even small batches of messages in any email processing program.

Fortunately, lists like this are easily fixable. The key to doing this simply is the INDIRECT function, which didn't exist with earlier versions of Excel. (If you have Microsoft Office 2007, then you're all set.)

Assuming your list is in column A, with the first name in cell A1, first company in cell A2, etc., put the following in the cells indicated (values beginning with an equals sign are formulas):

cell b1: =INDIRECT("A"&F1)

cell c1: =INDIRECT("A"&F1+1)

cell d1: =INDIRECT("A"&F1+2)

cell e1: =INDIRECT("A"&F1+3)

cell f1: 1

cell b2: =INDIRECT("A"&F2)

cell c2: =INDIRECT("A"&F2+1)

cell d2: =INDIRECT("A"&F2+2)

cell e2: =INDIRECT("A"&F2+3)

cell f2: =F1+4

The cells in B2 through F2 can be copied in one move all the way down (starting with corresponding columns in row 3 down thousands of rows as desired). This will instantly "rotate" (display) the data from column A as you desired.

If you don't want the (now) extraneous data in column A and F, don't delete them or everything in columns B-E will be messed up! Instead, click column headings B-E to highlight the content all the way down, and copy (Ctrl+C). Launch a new blank worksheet in the same file (or a completely new spreadsheet file) and press Paste --> Paste special (not the regular Ctrl+V paste). Select the radio button preceding Values and click OK.

You now have all the records in rows, with the formulas replaced by plain values, and won't be messed up if you sort, move them around, etc.!