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 WORKSHOP! Registration closes 24 hours prior to class. Once...
Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing. This two-day in-person class (July 9 & July 10 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...
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...
PowerPoint Basics: Create, edit and format slides, use themes, transitions and animation. This in-person class is taught in 1 sessions (See Below) July 10 from 1:00pm to 3:30pm - Chicago time. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Registration closes 24 hours the day prior to class. Walk-ins...
Join us on Thursday, July 10, 2025 at 2:00 (Chicago time), for an in-person event that will transform your job search game! Located at the Hoffman Estates Branch Library, 1550 Hassell Rd, Hoffman Estates, IL 60169 Are you tired of acing interviews only to be left empty-handed? If you've been struggling to land a job after making...
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 webinar is designed for people who who have used Excel but don't feel they know enough about functions. We'll talk about function syntax, how to recognize problems with functions,...
A step-by-step guide to help you prepare 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 successfully requires strategy, preparation, and...
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,...
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...
Job Fair, Hiring Event and Career Mini-mart What is a Career MiniMart? 1:30 pm - 4:00 pm Employer list will be emailed to registrants on July 16th. 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 Center. Printers...
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...
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....
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...
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...
