American Job Center in Wheeling

Excel Focus on Functions - IF function (part 2)
2021-01-21 11:00 - 12:00 (America/Chicago)
Excel Focus on Functions – IF function (part 2): IF variations including nested IF, IFS, SUMIF and AVERAGEIF

This is part 2 of a 2-part series. Continue learning about the IF family of functions including nested IF statements, IFS, IFERROR, and SUMIF. The IF functions are some of the most widely used functions in Excel and are useful regardless of industry or job type!
The North Suburban Cook County American Job Center is committed to providing all customers with quality, professional services as well as a safe and comfortable learning environment. The use of our resources implies acceptance of our Customer Code of Conduct, which is based on the principle of respect for all customers and staff. READ: https://www.ajcwheeling.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf

How to identify your Transferable Skills to land your next job
2021-01-21 10:30 - 11:30
Your guide for building meaningful career plans

Communication, Critical Thinking, Teamwork and Creativity are important skills in almost every job. But what is the secret sauce to success?
In this workshop you’ll learn how to implement this powerful formula for identifying your super powers (meaning transferable skills). Everyone is good at something – it is just a matter of asking the right questions, and figuring out your own answers. And then being able to communicate your skills to future employers. We will teach you how to unlock your potential and “sell” yourself with confidence and pride—knowing that you can deliver what you promise – whether on your resume or during an interview.
We will show you how to identify your transferable skills, incorporate them into your resumes and cover letters and craft answers to potential interview questions.

Registration closes 24 hours prior to workshop.
Your meeting access link will be emailed with your ticket registration confirmation.
If you do NOT IMMEDIATELY RECEIVE your ticket confirmation upon registration – PLEASE CHECK YOUR SPAM FOLDER.
THIS WORKSHOP IS HOSTED ON “GOtoMEETING.”
PLEASE DO NOT REGISTER MULTIPLE TIMES for the same session. ONLY REGISTER once for the same session
Please plan to arrive a little early to ensure that you are able to access the online meeting.
If you are having trouble logging in – – DON’T PANIC – try calling into the meeting using the phone number that is emailed to you along with your meeting access link.
If the meeting is full – click on registration and request to be placed on the waiting list.
The North Suburban Cook County American Job Center is committed to providing all customers with quality, professional services as well as a safe and comfortable learning environment. The use of our resources implies acceptance of our Customer Code of Conduct (See attached), which is based on the principle of respect for all customers and staff. https://www.ajcwheeling.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf

IMPORTANT: If you would like to be notified of other free job search resources including training – please email contact@bcsillinois.org. Include your name, phone number and what kind of help you need.

Working for the State of Illinois
2020-12-16 10:30 - 12:30
HOW TO APPLY FOR STATE OF ILLINOIS EMPLOYMENT
1. Application Procedure
2. Veteran’s Preference
3. Application Resources
WEDNESDAY, DECEMBER 16TH, 2020
10:30 AM-12:30 PM
*** Workshop starts promptly at 10:30 am. Login starts 15 minutes prior.
Please be on time to get all the information. ***
VIRTUAL WEBEX MEETING
Register at: https://bit.ly/2Vlw1pt
Guest Speakers are Mayra Magaña-CMS & Brittany Ott-IDOC
www.work.illinois.gov
https://www2.illinois.gov/idoc/Pages/default.aspx
Inquiries regarding reasonable accommodation policy or processing procedures must be directed to the Equal Opportunity
Officer, Office of Equal Employment Opportunity/Affirmative Action, 33 South State Street, 10th Floor,
Chicago, Illinois 60603-2802, Voice (312) 793-9290 /TTY (888) 340-1007 /Fax (312) 793-0302.
“State of Illinois
Employment Workshop”
Presented by:
Central Management Services &
The Illinois Department of Corrections

CEDA
2020-12-10 08:00 - 11:30 | Online
Housing and Medical Webinar
Register here

Harper College LinkedIn Webinar
2020-12-09 16:00 - 17:00 | Online
Please register here for this partner event
Event will cover LinkedIn etiquette and job seeking tips

Job Fair
2020-12-09 09:00 - 11:00 | Online
Hospitality Hires

Please click here to register

New Webinar Class
2020-12-08 14:30 - 15:00
New webinar
Register here

Manufacturing Info Session
2020-12-08 14:00 - 14:30
Discussion how trades compare with college.
Explore careers in manufacturing
Register here

Excel Focus on Functions (part 2)
2020-09-22 00:00
Excel Focus on Functions – Working with Text and Dates (Part 2): Flash Fill, Text to Columns and delimited text

Registration ends by 5pm the day prior to the Webinar. Once you register on Eventbrite, you will receive an email from the instructor through GoToWebinar with the link to join this class.

This is part 2 of a 2-part series. In this 60-minute webinar we’ll continuing exploring the text and date options in Excel. In this webinar we’ll explore more functions in the Text and Date/Time categor
