Word Level II – Efficient document design with Styles, Style sets, and built-in Quick Parts (virtual class)

Discover the power of Styles - the efficient way to format and design Word documents. If you're a regular user of Word creating reports, proposals, manuscripts, etc. learning to use Styles is a game changer! Your productivity will SOAR if iInstead of using direct formatting, you use styles to format your document so you can quickly and easily apply a set of formatting choices consistently. PRE-REGISTRATION IS REQUIRED FOR...

Free

Excel Function Overview (In Person Class)

American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United States

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 who have used Excel but don't feel they know enough about functions. We'll talk about...

Free

Excel Pivot Tables (New! In-Person)

American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United States

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 WORKSHOP! Registration closes 24 hours prior to class. Workshop Location:...

Free

Excel Lookup Functions (NEW! In Person Class)

American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United States

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

Free

PowerPoint Beyond the Basics – In Person workshop

American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United States

PowerPoint Beyond the Basics: Intermediate level overview including animation, Slide Masters, Sound, and Looped Presentations. This in-person class is designed to introduce key concepts crucial to building a working knowledge of Microsoft PowerPoint. In this class we'll talk about intermediate level concepts including animation, Slide Masters, sound, and looped presentations. PRE-REGISTRATION IS REQUIRED FOR ATTENDING...

Free

Excel Pivot Tables Level 1 (Virtual Class)

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 WORKSHOP!  Registration closes 24 hours prior to class. Once you...

Free

Excel Conditional Tools: IF functions, Data Validation (VIRTUAL CLASS)

Learn how to use IF and other logical functions to add conditions to Excel tasks Add 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...

Free

Excel Pivot Tables Level II (Virtual Class)

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 WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter class shortly before class. Please...

Free

Excel Focus on Functions- Work with Text and Dates (Virtual Class)

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

Free

Excel Advanced Concepts: Additional Data Analysis tools (Virtual Class)

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

Free

Google Workspace: Explore the spreadsheet power of Sheets! (Virtual 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 WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter...

Free

PowerPoint: create effective data visualization presentations (Virtual Workshop)

PowerPoint: create effective data visualization presentations Learn to use PowerPoint's graphic options like charts, tables, SmartArt, and more to create meaningful and impactful presentations that help your audience visualize and understand key data points. Creating impactful PowerPoint presentations involves leveraging its graphic options to visualize data effectively. Learn how about these key tools and how...

Free
Our Office
American Job Center in Wheeling
1400 South Wolf Road - Building 200 Suite 200
Wheeling, IL 60090
Hours

Monday – Friday:  8:30AM – 5:00PM

Helpful Links
Social Links

The American Job Center in Wheeling is an equal opportunity employer/program. Auxiliary aids and services are available upon request to individuals with disabilities.

This workforce product was funded by a grant awarded by the US Department of Labor’s Employment and Training Administration. The product was created by the recipient and does not necessarily reflect the official position of the U.S. Department of Labor. The Department of Labor makes no guarantees, warranties, or assurances of any kind, express or implied, with respect to such information, including any information on linked sites and including, but not limited to, accuracy of the information or its completeness, timeliness, usefulness, adequacy, continued availability, or ownership. This product is copyrighted by the institution that created it.

Copyright © 2025 American Job Center in Wheeling. All rights reserved.

Language
Skip to content