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:...
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....
New to LinkedIn? Learn the essentials to get started, which include: Setting up a strong professional profile. Highlighting your skills and experience. Building your first connections. Session is In-Person at: American Job Center in Wheeling 1400 S Wolf Road, Building 200 - Suite 200 Wheeling, IL 60090
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:...
Join us on Wednesday, January 21, 2026 at 10:00am (Chicago time), for an in-person event that will transform your job search game! Located at the Skokie Public Library 5215 Oakton St, Skokie, IL 60077 Are you tired of acing interviews only to be left empty-handed? If you've been struggling to land a job after making it past...
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...
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...
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...
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...