BEGIN:VCALENDAR VERSION:2.0 PRODID:-//American Job Center in Wheeling - ECPv6.0.13.1//NONSGML v1.0//EN CALSCALE:GREGORIAN METHOD:PUBLISH X-WR-CALNAME:American Job Center in Wheeling X-ORIGINAL-URL:https://www.ajcwheeling.com X-WR-CALDESC:Events for American Job Center in Wheeling REFRESH-INTERVAL;VALUE=DURATION:PT1H X-Robots-Tag:noindex X-PUBLISHED-TTL:PT1H BEGIN:VTIMEZONE TZID:America/Chicago BEGIN:DAYLIGHT TZOFFSETFROM:-0600 TZOFFSETTO:-0500 TZNAME:CDT DTSTART:20250309T080000 END:DAYLIGHT BEGIN:STANDARD TZOFFSETFROM:-0500 TZOFFSETTO:-0600 TZNAME:CST DTSTART:20251102T070000 END:STANDARD END:VTIMEZONE BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250121T093000 DTEND;TZID=America/Chicago:20250121T110000 DTSTAMP:20260422T185538 CREATED:20241209T032019Z LAST-MODIFIED:20241209T032019Z UID:10005851-1737451800-1737457200@www.ajcwheeling.com SUMMARY:Excel Conditional Tools: IF functions\, Data Validation (VIRTUAL CLASS) DESCRIPTION:Learn how to use IF and other logical functions to add conditions to Excel tasks\n\n\nThis virtual class meets on January 21st at 9:30am Chicago time. \nAdd power and complexity to your Excel spreadsheets! In this 90-minute webinar we’ll talk about about one of the most powerful functions in Excel – the IF function. We’ll also talk about other logical functions like AND/OR as well as functions like SUMIF and AVERAGEIF. Many tools in Excel are condition-based. So what is a condition??? We’ll look at several areas of Excel that serve different purposes\, but use the same underlying concept of condition. Understanding how conditions are used in Excel not only extends your knowledge of different tools in Excel\, but adds to your overall understanding of Excel. \nImproving your EXCEL skills can give you that competitive edge in today’s job market – whether for a promotion or a new job. \nPre-registration is required to attend. \n \nRegistration ends by 24 hours the day prior to the Webinar. \nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from  North Cook Job Center \nFOR OPTIMAL USER EXPERIENCE: \n\nIt is recommended that you register with an email address from GMAIL or OUTLOOK.\nJoin the webinar using the GOOGLE CHROME browser.\nYou will receive an email from North Cook Job Center with your access link.\n\n\nIf you need to cancel\, please cancel 48 hours prior so someone else on the waiting list can use your seat.\n\n\nPLEASE do not register and then no show.\n\nThe 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: \nhttps://www.ajcwheeling.com/wp-content/uploads/2020/08/Customer-Code-of-Conduct-handout.pdf \nQUESTIONS? EMAIL: contact@bcsillinois.org URL:https://www.ajcwheeling.com/event/excel-conditional-tools-if-functions-data-validation-virtual-class-3/ ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2023/02/baaac6e35e8233dc874f834e12158ef7.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250121T130000 DTEND;TZID=America/Chicago:20250121T143000 DTSTAMP:20260422T185538 CREATED:20241209T032321Z LAST-MODIFIED:20250107T150250Z UID:10005852-1737464400-1737469800@www.ajcwheeling.com SUMMARY:Excel Focus on Functions - Lookup and Reference: explore VLOOKUP\, HLOOKUP and alternatives like INDEX and MATCH (virtual class) DESCRIPTION:VLOOKUP is a must-have Excel function that’s used to manipulate data. In this 90-minute webinar we’ll explore VLOOKUP and the additional options that make it such a useful tool. We’ll also look at some alternatives to VLOOKUP like INDEX/MATCH. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. \n \nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from North Cook Job Center \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nLog in 15 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.\n\n\nWorkshops are for individuals age 18+.\n\n\nIf you need to cancel\, please let us know a minimum of 48 hours prior to class so someone else on the waiting list can use your seat.\nPlease DO NOT REGISTER MORE THAN ONCE.\n\nThis 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 \nQUESTIONS? EMAIL contact@bcsillinois.org URL:https://www.ajcwheeling.com/event/excel-focus-on-functions-lookup-and-reference-explore-vlookup-hlookup-and-alternatives-like-index-and-match-virtual-class-3/ ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/08/MS-Excel-Advanced.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250121T140000 DTEND;TZID=America/Chicago:20250121T153000 DTSTAMP:20260422T185538 CREATED:20241002T162847Z LAST-MODIFIED:20241216T160804Z UID:10005773-1737468000-1737473400@www.ajcwheeling.com SUMMARY:How to "work" a Job Fair and get an offer (In Person Workshop) DESCRIPTION:  \nJoin us on Tuesday\, January 21\, 2025 at 2:00 (Chicago time)\, for an in-person event that will transform your job search game! \nLocated at the Schaumburg Township District Library\, 130 S Roselle Rd\, Schaumburg\, IL 60193. \nTurn your next Hiring Event or Job Fair into a tool to get noticed\, and get hired. \nAre you tired of attending job fairs without any success? Do you want to learn the secrets of standing out from the crowd and securing a job offer? Look no further! \nLearn how find virtual and in-person hiring events\, job fairs and how to interact effectively with recruiters: \n\nReview employer job postings ─before the Job Fair\nCustomize your resume ─to the skills and experience the employer wants\nSell yourself to recruiters ─ discuss how your skills and experience match the job\nFollow up — get the recruiter’s contact information and send a thank you note afterwards\n\nIt’s your choice to learn how to turn your next Job Fair into a tool to get noticed\, called back and hired. Remember\, it’s not just about attending the job fair\, but about “working” it to secure that coveted job offer. See you there! \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. \n \nWorkshop Location: Schaumburg Township District Library\, 130 S Roselle Rd\, Schaumburg\, IL 60193. \nPLEASE NOTE: \n\nYou must register as there is only space for 24 people per workshop.\nRegistration closes 24 hours prior to workshop.\nCheck in 15 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time for traffic\, construction & weather.\nWorkshops are for individuals age 18+.\nEach person has their own computer for learning.\nSubject to change without notice.\nIf you need to cancel\, please let us know 48 hours prior to the workshop\, so someone else can use your seat.\n\nIMPORTANT: For additional job fairs\, free workshops and free computer classes\, visit northcookjobcenter.com/events/ \nBCS is committed to providing all customers with quality\, professional services as well as a safe and comfortable learning environment. The use of our resources (in person or virtual) implies acceptance of our Customer Code of Conduct (see attached Code of Conduct)\, 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 \nOur agency is an equal opportunity employer/program. Auxiliary aids and services are available upon request to individuals with disabilities. Funding for this program is made possible through a grant provided by the Chicago Cook Workforce Partnership. This workforce product was funded by a grant awarded by the U.S. Department of Labor’s Employment and Training Administration. For more information please visit ChiCookWorks.org/DOL-Funding \nQUESTIONS? EMAIL contact@bcsillinois.org URL:https://www.ajcwheeling.com/event/how-to-work-a-job-fair-and-get-an-offer-in-person-workshop-2/ LOCATION:Schaumburg Township District Library\, 130 S Roselle Rd\, Schaumburg\, IL 60193\, 130 S Roselle Rd\, Schaumburg\, IL\, 60193\, United States CATEGORIES:Job Search Workshop ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/07/How-to-work-a-job-fair.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250121T143000 DTEND;TZID=America/Chicago:20250121T160000 DTSTAMP:20260422T185538 CREATED:20241223T215643Z LAST-MODIFIED:20241223T215643Z UID:10005865-1737469800-1737475200@www.ajcwheeling.com SUMMARY:Organize Your Job Search and Get Results DESCRIPTION:Organize Your Job Search and Get Results\nTuesday\, January 21\, 2025\n2:30 pm – 4:00 pm \nBusiness and Community Center \nSkokie Public Library  5215 Oakton St\, Skokie\, IL 60077 (847) 673-7774 \nGet tips on what makes an effective job search and how to target your resume\, develop a crisp “elevator speech\,” practice successful interview techniques\, and more. \nPresented by a workforce professional from Business and Career Services\, Inc\, located at the North Cook County American Job Center. This center\, located in Wheeling\, is one of more than 3\,000 federally funded American Job Centers nationwide that provide services for both job seekers and employers. \n  \nRegistration begins January 2. URL:https://www.ajcwheeling.com/event/organize-your-job-search-and-get-results/ LOCATION:Skokie Public Library\, 5215 Oakton St\, Skokie\, IL\, 60077\, United States CATEGORIES:Job Search Workshop ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/12/organize-your-job-search.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT END:VCALENDAR