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 who have used Excel but don't feel they know enough about functions. We'll talk about...
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,...
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...
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...
Location: American Job Center, 1400 S Wolf Road, Building 200, Wheeling, IL 60090 Learn from someone who understands the job search journey and the challenges you are facing. During this in-person session, participants will learn methods to improve their resumes with guidance through a Peer Counselor. Topics will include: Tips and tricks to target your resume Tailoring...
Click below to download flyer Ill State Treasure at AJC flyer 2025
Location: This is a virtual workshop. You will be emailed the link shortly before the workshop begins. Please watch for an email from peercounselor@bcsillinois.org . Learn from someone who understands the job search journey and the challenges you are facing. During this in-person session, participants will learn methods to improve their resumes with guidance through a Peer...
Location: 1400 S Wolf Road, Building 200, Wheeling, IL 60090 Learn from someone who understands the job search journey and the challenges you are facing. During this in-person session, participants will learn methods to prepare for interviews with guidance through a Peer Counselor. Topics will include: Preparation of an Elevator Speech Knowing your audience and...
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...