Looking to build confidence using Excel for data analysis and reporting? Learn key formulas, data organization tools and features along with other essential tools to organize, analyze, and visualize your data effectively. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Walk-ins accepted on a space available basis. Registration closes 24 hours prior to class. Class Location: American…
Are You Ready? Strengthen Your Resume in 45 Minutes. Get support and guidance to improve your resume or create a targeted version to specific job opportunities. Work with the American Job Center VIRTUALLY in a 45-minute session. Once registered, you will be asked to share your resume and a job lead before getting the link…
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.…
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.…
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:…
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…
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 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…
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…
Click below to download flyer Ill State Treasure at AJC flyer 2025
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…
Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing. This two-day in-person class (January 7th & 8th 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 construction,…