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 WORKSHOP! Registration closes 24...
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 also look at some alternatives to VLOOKUP like INDEX/MATCH. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register,...
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...
🚨 Upcoming Hiring Event at Metropolitan Family Services Southeast July 18th You're invited to join us — and help spread the word — for two exciting Community Hiring Events happening this July in South Chicago! We’re bringing together a wide range of employers who are actively hiring for roles in: 🚚 CDL Driving 🚌 Bus Aides...
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...
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...
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 early: Need help practicing your “elevator speech” or printing your resume? Want to research a hiring company? Drop into the Career Mini-Mart Resource Center. Printers...
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...
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....
Explore a Career in Public Service! The Partnership is proud to join the Illinois Department of Employment Security and local elected officials to connect career seekers with meaningful roles in government. Meet and network directly with representatives from city, county, and state agencies. This no-cost event offers access to a wide range of career paths...
Click below to download flyer Ill State Treasure at AJC flyer 2025