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 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…
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…
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…
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:…
Excel Charts – Graphically visualize and communicate data using Excel’s robust chart tools In this 90-minute session you’ll learn to make your data more understandable and accessible using Excel’s robust chart feature. Learn how to choose the right chart type (column, line, pie, etc.), and explore formatting and layout options. We’ll also explore some of Excel’s…
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 – 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…
A step-by-step guide to help you prepare This is an in-person event. 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 are an excellent opportunity to network, connect with potential employers, and discover new career paths. But navigating a job fair…
In this 90-minute webinar, we will explore practical strategies to organize and streamline your workflow using the new version of Microsoft Outlook. Learn how to effectively manage folders, create rules, apply categories, and use shortcuts and built-in time-saving tools—all within the updated Outlook interface. Designed to help you work smarter, this session focuses specifically on features and…
Job Fair, Hiring Event and Career Mini-mart What is a Career MiniMart? 10:00 am – 12:30 pm Employer list will be emailed to people who pre-register on June 8th. 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…