BEGIN:VCALENDAR
VERSION:2.0
PRODID:-//American Job Center in Wheeling - ECPv6.0.13.1//NONSGML v1.0//EN
CALSCALE:GREGORIAN
METHOD:PUBLISH
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:20230312T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20231105T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20231128T093000
DTEND;TZID=America/Chicago:20231128T110000
DTSTAMP:20260425T112729
CREATED:20231019T202339Z
LAST-MODIFIED:20231019T202339Z
UID:10005156-1701163800-1701169200@www.ajcwheeling.com
SUMMARY:EXCEL - Focus on Functions - Working with Text and Dates (VIRTUAL)
DESCRIPTION:Excel Focus on Functions- Work with Text and Dates: CONCATENATE\, TODAY\, Flash Fill and Delimited Text\n\n\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. \nPreregistration is required to attend this class! \n \n\nRegistration ends by 5pm the day prior to the Webinar. \nOnce you register on Eventbrite\, you will receive an email from the instructor through GoToWebinar with the link to join this class.\nIMPORTANT: There are limited spaces available in this class. If you register to attend but need to cancel – please CANCEL 48 HOURS PRIOR TO THE CLASS. We have an extensive waiting list and would hope to offer another person your seat. \n\nFor an optimal webinar experience when registering and attending these virtual workshop\, the following is recommended: \n\nUSE the following email accounts-Gmail (google.com) or Outlook (outlook.com)\nRegister and attend the workshop with either browser-Google Chrome or Microsoft Edge\nIf you don’t receive the emails in your inbox\, please check your JUNK/SPAM Folder\nSessions are CST\nSign in 10 minutes prior to the webinar\n\nYou’ll receive the following emails. Last two have Join Webinar/LINK to attend \n\nEventbrite: Email Confirmation from Eventbrite which is ONLY your E-Ticket Summary\nGoToWebinar: Email Registration Confirmation of Computer Webinar from instructor to Click JOIN WEBINAR (LINK)\nGoToWebinar: Email Reminder ONE DAY PRIOR to Computer Webinar from instructor to Click JOIN WEBINAR (LINK)\n\nNote: There’s NO access code\, you’ll receive JOIN WEBINAR/LINK in your 2nd& 3rd emails. \nInformation/Cancel workshop-send email to webinar.organizer6@gmail.com \nYou can also send a note via Eventbrite website in the ticket order email section. \nThe 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 \nQUESTIONS? EMAIL: contact@bcsillinois.org \nSubject to change without notice.
URL:https://www.ajcwheeling.com/event/excel-focus-on-functions-working-with-text-and-dates-virtual-7/
ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2023/10/b943e92236e3013f41e557423bec77ef.jpg
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20231128T130000
DTEND;TZID=America/Chicago:20231128T143000
DTSTAMP:20260425T112729
CREATED:20231019T202558Z
LAST-MODIFIED:20231019T202558Z
UID:10005157-1701176400-1701181800@www.ajcwheeling.com
SUMMARY:Excel and Conditional Tools: IF functions\, Data Validation\,  (VIRTUAL)
DESCRIPTION:Learn how to use IF and other logical functions to add conditions to Excel tasks\n\n\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. \nPREREGISTRATION IS REQUIRED TO ATTEND THIS CLASS \n \n\nRegistration ends by 5pm the day prior to the Webinar. \nOnce you register on Eventbrite\, you will receive an email from the instructor through GoToWebinar with the link to join this class.\nIMPORTANT: There are limited spaces available in this class. If you register to attend but need to cancel – please CANCEL 48 HOURS PRIOR TO THE CLASS. We have an extensive waiting list and would hope to offer another person your seat. \n\nFor an optimal webinar experience when registering and attending these virtual workshop\, the following is recommended: \n\nUSE the following email accounts-Gmail (google.com) or Outlook (outlook.com)\nRegister and attend the workshop with either browser-Google Chrome or Microsoft Edge\nIf you don’t receive the emails in your inbox\, please check your JUNK/SPAM Folder\nSessions are CST\nSign in 10 minutes prior to the webinar\n\nYou’ll receive the following emails. Last two have Join Webinar/LINK to attend \n\nEventbrite: Email Confirmation from Eventbrite which is ONLY your E-Ticket Summary\nGoToWebinar: Email Registration Confirmation of Computer Webinar from instructor to Click JOIN WEBINAR (LINK)\nGoToWebinar: Email Reminder ONE DAY PRIOR to Computer Webinar from instructor to Click JOIN WEBINAR (LINK)\n\nNote: There’s NO access code\, you’ll receive JOIN WEBINAR/LINK in your 2nd& 3rd emails. \nInformation/Cancel workshop-send email to webinar.organizer6@gmail.com \nYou can also send a note via Eventbrite website in the ticket order email section. \nThe 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 \nQUESTIONS? EMAIL: contact@bcsillinois.org \nSubject to change without notice.
URL:https://www.ajcwheeling.com/event/excel-and-conditional-tools-if-functions-data-validation-virtual-5/
ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2023/10/d7e1e6b1e0903e5c8226a5934ffa6e18.jpg
END:VEVENT
END:VCALENDAR