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,...

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...

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...

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....

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 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...

I-Cash Location: 9am - 11am - December 24, 2024 American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200, Wheeling, IL 60090 One block south of Palatine-Willow Road & Wolf Road. West side of Wolf Road. Ample free parking This American Job Center is committed to providing all customers with quality, professional...

This IN-PERSON class is taught in 1 session from 2:00pm to 3:30pm. Creating Your Target Resumes - More critical than you think! Join us on Tuesday, January 7, 2025 at 2:00 (Chicago time), for an in-person event that will transform your job search game! Located at the Schaumburg Township District Library, 130 S Roselle Rd, Schaumburg, IL 60193, this...

Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing. This two-day in-person class 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 construction, basic formulas and functions, sort, filter,...

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) January 9  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...

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...