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…
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…
PowerPoint Basics: Create, edit and format slides, use themes, transitions and animation. This in-person class is taught in 1 sessions (See Below) July 10 from 1:00pm to 3:30pm – Chicago…
Join us on Thursday, July 10, 2025 at 2:00 (Chicago time), for an in-person event that will transform your job search game! Located at the Hoffman Estates Branch Library, 1550 Hassell Rd,…
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 webinar is designed for…
A step-by-step guide to help you prepare 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…
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…
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. We’ll…
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…
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…
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…
Job Fair, Hiring Event and Career Mini-mart What is a Career MiniMart? 1:30 pm – 4:00 pm Employer list will be emailed to registrants on July 16th. Arrive a little…
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…
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…
Click below to download flyer Ill State Treasure at AJC flyer 2025
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…
Canva Basics – Create content for print, presentations and social media with this free online graphic design app You don’t need to be a graphic designer to produce professional looking…
Excel Advanced Concepts – Dashboards: Use PivotTables, Sparklines, Charts, VLOOKUP to create Excel Dashboards Dashboards are at-a-glance summaries that use graphics to illustrate progress towards a goal. Excel has a…
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…