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...
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...
Basic editing and formatting: fonts, bulleted lists, indentation, and line spacing This 90-minute webinar is designed to introduce key concepts crucial to building a working knowledge of MS Word. In this webinar we'll talk about the Word environment, and explore the essential editing/formatting tools necessary to create basic documents. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS...
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...
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...
FREE Certified Tax Preparation February to April 2025 Thursday afternoons in Prospect Heights BY APPOINTMENT ONLY OR CALL 847.385.6001 click below to download flyer AARP 2025 Flyer (003) taxes weekly from Feb thru April
Take the LinkedIn Basics workshop to enhance your profile. Participants must have a LinkedIn profile, access to username, password & email. LinkedIn Beginners-FREE- In Person Preregistration is required. Come join us on Tuesday, April 8, 2025 at the American Job Center in Wheeling for a hands-on workshop on how to enhance your LinkedIn profile! This...
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...
Location: Niles-Maine District Library, 6960 W Oakton St. Niles, IL 60714 Join us on Wednesday, April 9, 2025 at 1p - 2:30pm (Chicago time), for an in-person event that will transform your job search game! Business and Career Services employment specialists are available for in-person assistance with career counseling and job search support. Bring your questions about...
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 WORKSHOP! Registration closes 24...
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,...
FREE Certified Tax Preparation February to April 2025 Thursday afternoons in Prospect Heights BY APPOINTMENT ONLY OR CALL 847.385.6001 click below to download flyer AARP 2025 Flyer (003) taxes weekly from Feb thru April
Discover the power of Styles - the efficient way to format and design Word documents. If you're a regular user of Word creating reports, proposals, manuscripts, etc. learning to use Styles is a game changer! Your productivity will SOAR if iInstead of using direct formatting, you use styles to format your document so you can quickly and easily apply a set of formatting choices consistently. PRE-REGISTRATION IS REQUIRED FOR...
Hospitality Hires Chicago 2025: The Eighth Year is a Great Year Save the date for the 8th Annual Hospitality Hires Chicago, a Chicago Cook Workforce Partnership production, on Tuesday April 15 from 9 am to 3 pm! This year’s event will once again be held at the Palmer House Hilton Hotel, 17 East...
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...
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 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...
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...
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. Workshop Location:...
Dig into VLOOKUP, INDEX/MATCH and other important lookup functions. In this workshop, we'll dive into some of the most important lookup functions in Excel and their uses: VLOOKUP, INDEX/MATCH, and other similar functions. These functions are essential for searching for data in large datasets and bringing back related information. We'll explore the pros and cons of VLOOKUP, INDEX...
PowerPoint Beyond the Basics: Intermediate level overview including animation, Slide Masters, Sound, and Looped Presentations. This in-person class is designed to introduce key concepts crucial to building a working knowledge of Microsoft PowerPoint. In this class we'll talk about intermediate level concepts including animation, Slide Masters, sound, and looped presentations. PRE-REGISTRATION IS REQUIRED FOR ATTENDING...
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: Skokie Public Library, 5215 Oakton St., Skokie, IL 60077 Join us on Thursday, April 24, 2025 at 1p - 4:00pm (Chicago time), for an in-person event that will transform your job search game! Business and Career Services employment specialists are available for in-person assistance with career counseling and job search support. Bring your questions about navigating...
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....
Organize Your Job Search and Get Results April 26, 2025 1:00 pm - 2:30 pm Midlothian Public Library, 14701 Kenton Ave, Midlothian, IL 60445 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,”...
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...
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...
In this 90-minute webinar we'll explore Sheets - Google's web-based alternative to Excel. Learn to use this powerful spreadsheet program to create spreadsheets, work with functions, add formatting, and sort/filter data. 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...
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...
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...
