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 CLASS! Registration closes 24 hours prior to class. PLEASE NOTE:...
Welcome to Techapalooza for Job Seekers | Join us for the first Techapalooza of the spring! Network and connect with local companies to learn about available opportunities in IT training, careers, and more! CLICK HERE TO DOWNLOAD FLYER
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....
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....
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...
The American Job Center in Wheeling is on the move! Staff will be on site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Township of Schaumburg 1...
Get ready for the April Job Fair hosted by Hanover Township with our 3-Part Prep Series. We’ll help you strengthen your resume, practice interviewing, and offer suggestions on how you can connect with employers confidently. Each session is drop-in and no appointment is necessary! The 3-sessions are in-person located at the Education and Work Center...
The American Job Center in Wheeling is on the move! Staff will be on-site offering free employment and career services. Stop by for free job search assistance, resume reviews, interview preparation, and access to employment and training resources. Open to all job seekers and NO appointment necessary. Location and Dates: Schaumburg Township District Library Locations:
Illinois State Treasure at AJC Wheeling flyer 2026 dates Rev March date change
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:...
Creating Your Target Resume – Craft Your Path to Success Presented by a workforce professional from Business and Career Services, Inc, This center is one of more than 3,000 federally funded American Job Centers nationwide that provide services for both job seekers and employers. In this workshop you’ll learn: Register for this workshop to guide...
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 CLASS! Registration closes 24...
