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,…
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 manage resumes and applications. If the ATS can’t read or understand the information on your resume, your application might not be evaluated or considered. For…
Excel Function Overview (In Person Class) 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 in person class is designed for people who have used Excel but don’t feel they know enough about functions. We’ll talk about function…
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 staff in our Wheeling computer lab in a 45-minute session. Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite…
How spreadsheets work, basic formulas, functions, and formatting. This webinar is part 1 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this webinar we’ll talk about the Excel environment, explore basic formulas and functions, and discuss spreadsheet formatting options. PRE-REGISTRATION IS REQUIRED FOR…
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…
Sort and filter data, work with columns, rows, sheets, and copy/paste This webinar is part 2 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we’ll learn to sort and filter, work with columns, rows and sheets, and explore different ways…
Create a slide presentation using themes, graphics, and transitions: In this 90-minute webinar you’ll learn how to create PowerPoint slides and explore how to take advantage of PowerPoint’s many built-in template and style features to help streamline your PowerPoint process! PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Registration closes 24 hours prior to class. PLEASE…
Function overview & troubleshooting, Comments, and printing in Excel This webinar is part 3 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we’ll explore additional functions, look at how functions behave in the Excel environment, add Comments, and discuss printing…
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…
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…
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…
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…
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 understand key data points. Creating impactful PowerPoint presentations involves leveraging its graphic options to visualize data effectively. Learn how about these key tools and how…
Organize Your Job Search! A Step-by-Step Guide – Organize your Job Search – Get Results! Get Help! Get Hired! Get tips on what makes an effective job search and how to target your resume, develop a crisp “elevator speech,” practice successful interview techniques, and more. How do you start? Where do you start? What do you…
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 designs! By utilizing Canva’s built-in templates, photo and font options anyone can create exciting content to be shared online, posted on social media site, or…
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 number of features like PivotTables, PivotCharts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some familiarity…
Excel Advanced Concepts – Transform and Manipulate Data with Power Query In this online webinar: Get started with Excel’s amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will allow you to more easily solve everyday dataset issues. To…
