BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//Business & Career Services, Inc. - ECPv6.3.3.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
X-WR-CALNAME:Business & Career Services, Inc.
X-ORIGINAL-URL:https://bcsillinois.org
X-WR-CALDESC:Events for Business & Career Services, Inc.
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:20260308T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20261101T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20260520T093000
DTEND;TZID=America/Chicago:20260520T110000
DTSTAMP:20260509T143734
CREATED:20260420T151530Z
LAST-MODIFIED:20260509T154527Z
UID:10000279-1779269400-1779274800@bcsillinois.org
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 CLASS! Registration closes 24 hours prior to class. \n \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual class.\n\n\nLog in 15 minutes prior to class. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.\n\n\nClasses 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.\n\n\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://bcsillinois.org/event/excel-focus-on-functions-lookup-and-reference-explore-vlookup-hlookup-and-alternatives-like-index-and-match-virtual-class-9/
CATEGORIES:Computer workshop,Job Search Workshop
ATTACH;FMTTYPE=image/jpeg:https://bcsillinois.org/wp-content/uploads/2025/07/MS-Excel-Advanced-bk3bvU.jpg
ORGANIZER;CN="Business and Career Services Inc.":MAILTO:contact@bcsillinois.org
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20260520T130000
DTEND;TZID=America/Chicago:20260520T143000
DTSTAMP:20260509T143734
CREATED:20260420T151530Z
LAST-MODIFIED:20260509T154527Z
UID:10000280-1779282000-1779287400@bcsillinois.org
SUMMARY:Excel Focus on Functions- Work with Text and Dates (Virtual Class)
DESCRIPTION:Excel Focus on Functions- Work with Text and Dates: CONCATENATE\, TODAY\, Flash Fill and Delimited Text\nText strings and dates can cause big problems in a spreadsheet if you’re not aware of how to identify and manipulate them! In this 90-minute webinar we’ll talk about basic text functions like CONCATENATE and date functions like TODAY. We’ll also explore tools like Flash Fill\, Text to Columns\, and delimited text.\nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.\n \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual class.\n\n\nLog in 10 minutes prior to class. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.\n\n\nClasses 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.\n\n\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://bcsillinois.org/event/excel-focus-on-functions-work-with-text-and-dates-virtual-class-9/
CATEGORIES:Computer workshop,Job Search Workshop
ATTACH;FMTTYPE=image/jpeg:https://bcsillinois.org/wp-content/uploads/2025/07/MS-Excel-Advanced-bk3bvU.jpg
ORGANIZER;CN="Business and Career Services Inc.":MAILTO:contact@bcsillinois.org
END:VEVENT
END:VCALENDAR