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...
Location: This is a virtual workshop. You will receive an email with the link to enter class shortly before class. Please watch for an email from the Peer Counselors at BCSIllinois.org. Learn from someone who understands the job search journey and the challenges you are facing. During this in-person and interactive session, participants will learn how...
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 WORKSHOP! Registration closes 24 hours prior to class. Once...
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 and interactive session, participants will learn how to organize their job search with guidance through a Peer Counselor. This sessions will include: An introduction to job search...
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....