American Job Center in Wheeling

Understanding Excel Tables: Create and work  with Excel Tables to improve everyday data analysis tasks. Working with tables is fundamental to improving everyday data analysis tasks, as they provide a structured and efficient way to organize, manipulate, and extract insights from data. Excel tables provide a clear, structured way to manage data, making it easier…

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…

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…

Learn to format a standard applicant tracking system, compliant resume including how to set tabs correctly, insert stored text, and track changes.   Many companies use Applicant Tracking Systems (ATS) to manage resumes and applications. If the ATS can’t read or understand the information on your resume, your application might not be evaluated or considered. For…

Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing. This two-day in-person class (July 9 & July 10 at 9:30am) is designed to introduce key concepts crucial to building a working knowledge of Microsoft Excel. In this class we’ll talk about the Excel environment, how spreadsheets work, spreadsheet…