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:20240310T080000
END:DAYLIGHT
BEGIN:STANDARD
TZOFFSETFROM:-0500
TZOFFSETTO:-0600
TZNAME:CST
DTSTART:20241103T070000
END:STANDARD
END:VTIMEZONE
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20240425T093000
DTEND;TZID=America/Chicago:20240425T110000
DTSTAMP:20260426T052457
CREATED:20240307T153323Z
LAST-MODIFIED:20240307T153323Z
UID:10005358-1714037400-1714042800@www.ajcwheeling.com
SUMMARY:MS 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\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. \nPreregistration is required to attend this class. \n \nRegistration 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. \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\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 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/ms-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
END:VEVENT
BEGIN:VEVENT
DTSTART;TZID=America/Chicago:20240425T130000
DTEND;TZID=America/Chicago:20240425T143000
DTSTAMP:20260426T052457
CREATED:20240307T151706Z
LAST-MODIFIED:20240307T151706Z
UID:10005359-1714050000-1714055400@www.ajcwheeling.com
SUMMARY:Excel Advanced Concepts - Additional Data Analysis tools (VIRTUAL class)
DESCRIPTION:Excel Advanced Concepts – Additional tools: Data validation\, Subtotal\, and Conditional Formatting\n\n\nThis 90-minute webinar focuses on some of the additional tools available in Excel that are very useful but often overlooked. We’ll talk about data validation\, the Subtotal feature (an alternative to pivot tables)\, Outline and the What-If tools. \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 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. \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 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-advanced-concepts-additional-data-analysis-tools-virtual-class-2/
ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2023/05/56ec419e2290c295384f8ec8e79d44a7.jpg
END:VEVENT
END:VCALENDAR