Are You Looking for a State of Illinois Job? The Illinois Department of Employment Security invites You to a Work 4 Illinois Recruitment Workshop featuring Central Management Services! The workshop will include the following services: Instruction on how to apply for jobs with the State of Illinois Overview of current job openings & opportunities with…
Are You Ready? Strengthen your interview techniques and gain confidence in a supportive 45-minute session. Once registered, you will be asked to share your resume and a job lead prior to attending the session. Location: Education and Work Center 6704 Barrington Road Hanover Park, IL 60133 PLEASE NOTE: The American Job Center in Wheeling…
American Job Center in Wheeling 1400 S Wolf Road, Wheeling, IL Illinois State Treasure at AJC Wheeling flyer 2026 dates Rev March date change
How spreadsheets work, basic formulas, functions, and formatting. This 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. PRE-REGISTRATION IS REQUIRED FOR…
Sort and filter data, work with columns, rows, sheets, and copy/paste This 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…
Function overview & troubleshooting, Comments, and printing in Excel This 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…
In this 90-minute webinar, we will explore practical strategies to organize and streamline your workflow using the new version of Microsoft Outlook. Learn how to effectively manage folders, create rules, apply categories, and use shortcuts and built-in time-saving tools—all within the updated Outlook interface. Designed to help you work smarter, this session focuses specifically on features and…
VLOOKUP Foundations – explore this classic and important Lookup and Reference function. 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. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.…
The American Job Center in Wheeling is on the move! Staff will be on-site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Schaumburg Township District Library Locations:…
Create a slide presentation using themes, graphics, and transitions: In 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! PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class. PLEASE…
VLOOKUP Foundations – explore this classic and important Lookup and Reference function. 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. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class.…
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…
Location: Skokie Library 5215 Oakton Street, Skokie Join us on Thursday, July 9, 2026 at 1:30pm – 3:30pm (Chicago time), for an in-person event that will transform your job search game! Business and Career Services employment specialists are available for in-person assistance with career counseling and job search support. Bring your questions about navigating the job search and…
Excel Function Overview (In Person Class) Excel Functions Overview: Setup, structure and syntax, common problems with functions, and troubleshooting tips Not as confident about Excel functions as you’d like to be? This in person class is designed for people who have used Excel but don’t feel they know enough about functions. We’ll talk about function…
Dig into VLOOKUP, INDEX/MATCH and other important lookup functions. In 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…
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! Walk-ins accepted on a space available basis. Registration closes…
The American Job Center in Wheeling is on the move! Staff will be on site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Township of Schaumburg 1…
The American Job Center in Wheeling is on the move! Staff will be on-site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Schaumburg Township District Library Locations:…
Location: Palatine Library District 700 N North Ct, Palatine, IL 60067 Join us on Tuesday, July 21, 2026 at 9am – 12:00pm (Chicago time), for an in-person event that will transform your job search game! Business and Career Services employment specialists are available for in-person assistance with career counseling and job search support. Bring your questions about navigating…
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:…
A step-by-step guide to help you prepare This is an in-person event. Navigating a job fair/hiring event requires preparation. This interactive workshop guides you to successfully prepare, navigate, network and follow-up like a pro. Job fairs are an excellent opportunity to network, connect with potential employers, and discover new career paths. But navigating a job fair…
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. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24…
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…
Excel Charts – Graphically visualize and communicate data using Excel’s robust chart tools In this 90-minute session you’ll learn to make your data more understandable and accessible using Excel’s robust chart feature. Learn how to choose the right chart type (column, line, pie, etc.), and explore formatting and layout options. We’ll also explore some of Excel’s…
The American Job Center in Wheeling is on the move! Staff will be on-site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Schaumburg Township District Library Locations:…
American Job Center in Wheeling 1400 S Wolf Road, Wheeling, IL Illinois State Treasure at AJC Wheeling flyer 2026 dates Rev March date change
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.…
JOB FAIR THURSDAY, July 29, 2026 10 A.M. TO 1 P.M. Community Consolidated School District 21 959 West Dundee Rd. Wheeling This job fair will connect job seekers with numerous employment opportunities in the local business community. Canty Job Fair 6-20 (3) 1 (to download flyer)
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.…
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…
Excel Advanced Concepts – Transform and Manipulate Data with Power Query In this online webinar: Get started with Excel’s amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will allow you to more easily solve everyday dataset issues. To…
