Business & Career Services, Inc.

Excel Focus on Functions- Work with Text and Dates (Virtual Class)
2025-12-16 09:30 - 11:00 (America/Chicago)
Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text
Text 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.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.

PLEASE NOTE:

You must register as there is limited space for this virtual class.

Log in 10 minutes prior to class. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.

Workshops are for individuals age 18+.

If 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.

Please DO NOT REGISTER MORE THAN ONCE.

This 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
QUESTIONS? EMAIL: contact@bcsillinois.org

Excel Must Have Functions: Explore powerful IF family of Logical Functions (VIRTUAL CLASS)
2025-12-16 13:00 - 14:30
Learn about this powerful group of condition-based widely-used Excel Functions. We’ll look at IF, IFS, AND, OR and expand into the exceptionally useful IF variations such as SUMIF, COUNTIF, and IFERROR
Excel has a powerful group of conditional functions that automate decisions and calculations, allowing you to analyze and summarize data based on specific criteria.
Improving your EXCEL skills can give you that competitive edge in today’s job market – whether for a promotion or a new job.
Pre-registration is required to attend. Registration ends by 24 hours the day prior to the Webinar.

If you need to cancel, please cancel 48 hours prior so someone else on the waiting list can use your seat.

PLEASE do not register and then no show.

The 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
QUESTIONS? EMAIL: contact@bcsillinois.org

Excel Pivot Tables Level 1 (Virtual Class)
2025-12-17 09:30 - 11:00
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.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.

PLEASE NOTE:

You must register as there is limited space for this virtual workshop.
Log in 10 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts.
Workshops are for individuals age 18+.
If 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.
Please DO NOT REGISTER MORE THAN ONCE.

This 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
QUESTIONS? EMAIL: contact@bcsillinois.org

Excel Advanced Concepts: Additional Data Analysis tools (Virtual Class)
2025-12-17 13:00 - 14:30
Excel Advanced Concepts: Additional Data Analysis tools – Data validation, Subtotal and What-Ifs
This 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.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.

PLEASE NOTE:

You must register as there is limited space for this virtual workshop.

Log in 10 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.

Workshops are for individuals age 18+.

If 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.

Please DO NOT REGISTER MORE THAN ONCE.

This 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
QUESTIONS? EMAIL: contact@bcsillinois.org

Excel Pivot Tables Level II (Virtual Class)
2025-12-18 09:30 - 11:00
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.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS!

Registration closes 24 hours prior to class.
PLEASE NOTE:

You must register as there is limited space for this virtual class.

Log in 10 minutes prior to class. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.

Classes are for individuals age 18+.

If 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.

Please DO NOT REGISTER MORE THAN ONCE.

This 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
QUESTIONS? EMAIL: contact@bcsillinois.org

Google Workspace: Explore the spreadsheet power of Sheets! (Virtual Class)
2025-12-18 13:00 - 14:30
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.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.

PLEASE NOTE:

You must register as there is limited space for this virtual class.

Log in 10 minutes prior to workshop. ABSOLUTELY NO ADMITTANCE after session starts. Be sure to allow enough time to log in.

Classes are for individuals age 18+.

If 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.

Please DO NOT REGISTER MORE THAN ONCE.

This 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
QUESTIONS? EMAIL: contact@bcsillinois.org

LinkedIn Advanced with AI (Virtual Workshop)
2025-12-18 14:00 - 15:30
Take your LinkedIn presence to the next level!
Through our partnership with Harper College, this workshop goes beyond the basics and guides you through practical, actionable strategies to boost your job search, including:
🔹 Generating tailored headlines and summaries with AI-powered suggestions
🔹 Discovering strategies to target the right jobs and employers
🔹 Optimizing and balancing your professional content
🔹 Learning best practices for making professional connections and networking
Walk away with practical tips and AI shortcuts to help you stand out, grow your network, and land more opportunities!
As part of the registration process, we will review your LinkedIn profile to confirm the essentials are in place. After this review, you will receive an email containing the Zoom meeting link for your scheduled session.
PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class.

This 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
QUESTIONS? EMAIL contact@bcsillinois.org

Illinois State Treasurer I-Cash event
2025-12-23 13:30 - 15:00 | American Job Center in Wheeling, 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, 60090, United States
Click below to download flyer
Ill State Treasure at AJC flyer 2025
