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:20250806T093000 DTEND;TZID=America/Chicago:20250806T110000 DTSTAMP:20260502T100251 CREATED:20250605T170743Z LAST-MODIFIED:20250806T143957Z UID:10006155-1754472600-1754478000@www.ajcwheeling.com SUMMARY:Excel Basics Part 1 (Virtual Workshop) DESCRIPTION:How spreadsheets work\, basic formulas\, functions\, and formatting\nThis webinar is part 1 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this webinar we’ll talk about the Excel environment\, explore basic formulas and functions\, and discuss spreadsheet formatting options. \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\nAmerican Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nCheck in 15 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. \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 \nsubject to change without notice. URL:https://www.ajcwheeling.com/event/excel-basics-part-1-virtual-workshop-9/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250806T130000 DTEND;TZID=America/Chicago:20250806T143000 DTSTAMP:20260502T100251 CREATED:20250605T171212Z LAST-MODIFIED:20250806T144057Z UID:10006158-1754485200-1754490600@www.ajcwheeling.com SUMMARY:MS Word Basics (Virtual Workshop) DESCRIPTION:Basic editing and formatting: fonts\, bulleted lists\, indentation\, and line spacing\nThis 90-minute webinar is designed to introduce key concepts crucial to building a working knowledge of MS Word. In this webinar we’ll talk about the Word environment\, and explore the essential editing/formatting tools necessary to create basic documents. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. \n \n\nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from\nAmerican Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nCheck in 15 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. \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 \nSubject to change without notice URL:https://www.ajcwheeling.com/event/ms-word-basics-virtual-workshop-8/ CATEGORIES:Computer workshop ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/08/ms-office-word-class.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250807T093000 DTEND;TZID=America/Chicago:20250807T110000 DTSTAMP:20260502T100251 CREATED:20250605T170854Z LAST-MODIFIED:20250806T144225Z UID:10006156-1754559000-1754564400@www.ajcwheeling.com SUMMARY:Excel Basics Part 2 (Virtual Workshop) DESCRIPTION:Sort and filter data\, work with columns\, rows\, sheets\, and copy/paste\nThis webinar is part 2 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we’ll learn to sort and filter\, work with columns\, rows and sheets\, and explore different ways to use copy and paste in Excel. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! \n \n\nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from\nAmerican Job Center \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nCheck in 15 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. \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-basics-part-2-virtual-workshop-9/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250807T130000 DTEND;TZID=America/Chicago:20250807T143000 DTSTAMP:20260502T100251 CREATED:20250716T165405Z LAST-MODIFIED:20250716T165405Z UID:10006184-1754571600-1754577000@www.ajcwheeling.com SUMMARY:Excel Basics Part 3 (Virtual Workshop) DESCRIPTION:Function overview & troubleshooting\, Comments\, and printing in Excel\nThis webinar is part 3 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we’ll explore additional functions\, look at how functions behave in the Excel environment\, add Comments\, and discuss printing options in Excel. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! \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. \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-basics-part-3-virtual-workshop-9/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250813T093000 DTEND;TZID=America/Chicago:20250813T110000 DTSTAMP:20260502T100251 CREATED:20250605T171504Z LAST-MODIFIED:20250605T171504Z UID:10006159-1755077400-1755082800@www.ajcwheeling.com SUMMARY:Excel Advanced Concepts - Get Started with Excel Tables (Virtual Class) DESCRIPTION:You’ve heard of Excel tables but never had a chance to use them? Learn how to structure Excel tables\, understand the differences between normal ranges and tables\, and the advantages of using tables to create more complex pivot tables and use the Power Query Feature. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! \n \nRegistration closes 24 hours prior to class. \nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from North Cook Job Center \n  \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-advanced-concepts-get-started-with-excel-tables-virtual-class-12/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250813T130000 DTEND;TZID=America/Chicago:20250813T143000 DTSTAMP:20260502T100251 CREATED:20250605T171620Z LAST-MODIFIED:20250605T171701Z UID:10006160-1755090000-1755095400@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-9/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250814T093000 DTEND;TZID=America/Chicago:20250814T110000 DTSTAMP:20260502T100251 CREATED:20250605T171821Z LAST-MODIFIED:20250605T171821Z UID:10006161-1755163800-1755169200@www.ajcwheeling.com SUMMARY:PowerPoint Basics (Virtual Workshop) DESCRIPTION:Create a slide presentation using themes\, graphics\, and transitions:\nIn this 90-minute webinar you’ll learn how to create PowerPoint slides and explore how to take advantage of PowerPoint’s many built-in template and style features to help streamline your PowerPoint process! \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\nCheck in 10 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. \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/powerpoint-basics-virtual-workshop-9/ CATEGORIES:Computer workshop,Job Search Workshop ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/08/POWERPOINT-LOGO.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250814T130000 DTEND;TZID=America/Chicago:20250814T143000 DTSTAMP:20260502T100251 CREATED:20250605T171902Z LAST-MODIFIED:20250605T171902Z UID:10006162-1755176400-1755181800@www.ajcwheeling.com SUMMARY:Google Workspace: Explore the spreadsheet power of Sheets! (Virtual Class) DESCRIPTION:In this 90-minute webinar we’ll explore Sheets – Google’s web-based alternative to Excel. Learn to use this powerful spreadsheet program to create spreadsheets\, work with functions\, add formatting\, and sort/filter data. \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 10 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/google-workspace-explore-the-spreadsheet-power-of-sheets-virtual-class-9/ CATEGORIES:Computer workshop,Job Search Workshop ATTACH;FMTTYPE=image/jpeg:https://www.ajcwheeling.com/wp-content/uploads/2024/06/a3ae8cf088dac1df2988e8325b5cde3d.jpg ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250820T093000 DTEND;TZID=America/Chicago:20250820T120000 DTSTAMP:20260502T100251 CREATED:20250605T172415Z LAST-MODIFIED:20250605T172415Z UID:10006167-1755682200-1755691200@www.ajcwheeling.com SUMMARY:Excel Function Overview (In Person Class) DESCRIPTION:Excel Function Overview (In Person Class)\nExcel Functions Overview: Setup\, structure and syntax\, common problems with functions\, and troubleshooting tips \nNot as confident about Excel functions as you’d like to be? This in person class is designed for people who who have used Excel but don’t feel they know enough about functions. We’ll talk about function syntax\, how to recognize problems with functions\, how the function library is organized\, and some general troubleshooting for Excel spreadsheets. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! \n \nRegistration closes 24 hours prior to class. Walk-ins accepted on a space available basis. \nWorkshop Location: \nAmerican Job Center in Wheeling \n1400 S Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL 60090 \n(One block south of Palatine/Willow Road & Wolf Road – west side of Wolf Rd. Ample free parking in front.) \nPLEASE NOTE: \n\nYou must register as there is only space for 15 people per 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.\nIf you need to cancel\, please let us know a minimum of 48 hours prior to class so someone else can use your seat. We will have an extensive waiting list – so if you cannot come – PLEASE CANCEL.\nPlease do NOT REGISTER MULTIPLE TIMES.\n\nThe American Job Center in Wheeling 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-function-overview-in-person-class-7/ LOCATION:American Job Center in Wheeling\, 1400 South Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL\, 60090\, United States CATEGORIES:Computer workshop,Job Search Workshop 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:20250820T130000 DTEND;TZID=America/Chicago:20250820T153000 DTSTAMP:20260502T100251 CREATED:20250605T172528Z LAST-MODIFIED:20250605T172528Z UID:10006168-1755694800-1755703800@www.ajcwheeling.com SUMMARY:Excel Lookup Functions (NEW! In Person Class) DESCRIPTION:Dig into VLOOKUP\, INDEX/MATCH and other important lookup functions. \nIn this workshop\, we’ll dive into some of the most important lookup functions in Excel and their uses: VLOOKUP\, INDEX/MATCH\, and other similar functions. These functions are essential for searching for data in large datasets and bringing back related information. We’ll explore the pros and cons of VLOOKUP\, INDEX and MATCH. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted n a space available basis. \nRegistration closes 24 hours prior to class. \n \nWorkshop Location: \nAmerican Job Center in Wheeling \n1400 S Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL 60090 \n(One block south of Palatine/Willow Road & Wolf Road – west side of Wolf Rd. Ample free parking in front.) \nPLEASE NOTE: \n\nYou must register as there is only space for 15 people per 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.\nIf you need to cancel\, please let us know a minimum of 48 hours prior to class so someone else can use your seat. We will have an extensive waiting list – so if you cannot come – PLEASE CANCEL.\nPlease do NOT REGISTER MULTIPLE TIMES.\n\nThe American Job Center in Wheeling 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-lookup-functions-new-in-person-class-2/ LOCATION:American Job Center in Wheeling\, 1400 South Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL\, 60090\, United States CATEGORIES:Computer workshop,Job Search Workshop 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:20250821T093000 DTEND;TZID=America/Chicago:20250821T120000 DTSTAMP:20260502T100251 CREATED:20250605T173949Z LAST-MODIFIED:20250605T173949Z UID:10006170-1755768600-1755777600@www.ajcwheeling.com SUMMARY:Better Data Analysis with Excel Tables (New! In-Person) DESCRIPTION:Understanding Excel Tables: \nYou’ve heard of Excel tables but never had a chance to use them? Learn how to structure Excel tables and take a look at how organizing data into tables can make everyday tasks more efficient. \nExcel tables are a powerful feature that allows you to structure and organize your data within a dedicated object on your worksheet. Unlike regular ranges of data\, Excel tables offer built-in functionalities to enhance your data management\, analysis\, and presentation. \n  \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. \nRegistration closes 24 hours prior to class. \n \nWorkshop Location: \nAmerican Job Center in Wheeling \n1400 S Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL 60090 \n(One block south of Palatine/Willow Road & Wolf Road – west side of Wolf Rd. Ample free parking in front.) \nPLEASE NOTE: \n\nYou must register as there is only space for 15 people per 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.\nIf you need to cancel\, please let us know a minimum of 48 hours prior to class so someone else can use your seat. We will have an extensive waiting list – so if you cannot come – PLEASE CANCEL.\nPlease do NOT REGISTER MULTIPLE TIMES.\n\nThe American Job Center in Wheeling 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/better-data-analysis-with-excel-tables-new-in-person/ LOCATION:American Job Center in Wheeling\, 1400 South Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL\, 60090\, United States CATEGORIES:Computer workshop,Job Search Workshop 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:20250821T130000 DTEND;TZID=America/Chicago:20250821T153000 DTSTAMP:20260502T100251 CREATED:20250605T172703Z LAST-MODIFIED:20250605T172703Z UID:10006169-1755781200-1755790200@www.ajcwheeling.com SUMMARY:Excel Pivot Tables (New! In-Person) DESCRIPTION:Learn the basics of Pivot Table construction in Excel. We’ll discuss data organization\, define what a pivot table does\, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. \nRegistration closes 24 hours prior to class. \n \nWorkshop Location: \nAmerican Job Center in Wheeling \n1400 S Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL 60090 \n(One block south of Palatine/Willow Road & Wolf Road – west side of Wolf Rd. Ample free parking in front.) \nPLEASE NOTE: \n\nYou must register as there is only space for 15 people per 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.\nIf you need to cancel\, please let us know a minimum of 48 hours prior to class so someone else can use your seat. We will have an extensive waiting list – so if you cannot come – PLEASE CANCEL.\nPlease do NOT REGISTER MULTIPLE TIMES.\n\nThe American Job Center in Wheeling 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-pivot-tables-new-in-person-3/ LOCATION:American Job Center in Wheeling\, 1400 South Wolf Road\, Building 200\, Suite 200\, Wheeling\, IL\, 60090\, United States CATEGORIES:Computer workshop 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:20250827T093000 DTEND;TZID=America/Chicago:20250827T110000 DTSTAMP:20260502T100251 CREATED:20250605T171958Z LAST-MODIFIED:20250825T220745Z UID:10006163-1756287000-1756292400@www.ajcwheeling.com SUMMARY:Excel Pivot Tables Level 1 (Virtual Class) DESCRIPTION:Learn the basics of Pivot Table construction in Excel. We’ll discuss data organization\, define what a pivot table does\, and create several examples of this need-to-know Excel feature. Familiarity with the Sorting and Filtering tools in Excel is recommended. \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:\n                                American Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\nLog in 10 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. \nWorkshops are for individuals age 18+.\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-pivot-tables-level-1-virtual-class-13/ CATEGORIES:Computer workshop,Job Search Workshop ATTACH;FMTTYPE=image/webp:https://www.ajcwheeling.com/wp-content/uploads/2024/10/EXCEL-pivot-table-18-20240830-4505698.webp ORGANIZER;CN="Business%20and%20Career%20Services%20Inc.":MAILTO:contact@bcsillinois.org END:VEVENT BEGIN:VEVENT DTSTART;TZID=America/Chicago:20250827T130000 DTEND;TZID=America/Chicago:20250827T143000 DTSTAMP:20260502T100251 CREATED:20250605T172059Z LAST-MODIFIED:20250825T220829Z UID:10006165-1756299600-1756305000@www.ajcwheeling.com 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 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 American Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nLog in 10 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-work-with-text-and-dates-virtual-class-12/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250828T093000 DTEND;TZID=America/Chicago:20250828T110000 DTSTAMP:20260502T100251 CREATED:20250605T172025Z LAST-MODIFIED:20250825T220916Z UID:10006164-1756373400-1756378800@www.ajcwheeling.com SUMMARY:Excel Pivot Tables Level II (Virtual Class) DESCRIPTION:In this 90-minute webinar we’ll dive deeper into Pivot Tables exploring Pivot Charts\, Slicers\, Timelines\, Calculated Fields and Custom Grouping. Familiarity with basic pivot tables recommended. \nPRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! \n \nRegistration closes 24 hours prior to class. \nOnce you register\, you will receive the link to enter class shortly before class. Please watch for an email from American Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nLog in 10 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-pivot-tables-level-ii-virtual-class-12/ CATEGORIES:Computer workshop,Job Search Workshop 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:20250828T130000 DTEND;TZID=America/Chicago:20250828T143000 DTSTAMP:20260502T100251 CREATED:20250605T172258Z LAST-MODIFIED:20250825T221013Z UID:10006166-1756386000-1756391400@www.ajcwheeling.com SUMMARY:Excel Advanced Concepts: Additional Data Analysis tools (Virtual Class) DESCRIPTION:Excel Advanced Concepts: Additional Data Analysis tools – Data validation\, Subtotal and What-Ifs\nThis 90-minute webinar focuses on some additional data 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)\, and the What-If tools. \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 American Job Center \n  \nPLEASE NOTE: \n\nYou must register as there is limited space for this virtual workshop.\n\n\nLog in 10 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-advanced-concepts-additional-data-analysis-tools-virtual-class-18/ CATEGORIES:Computer workshop,Job Search Workshop 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 END:VCALENDAR