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 CLASS! Registration closes 24 hours prior to class. PLEASE NOTE:...
New to LinkedIn? Learn the essentials to get started, which include: Setting up a strong professional profile. Highlighting your skills and experience. Building your first connections. Session is In-Person at: American Job Center in Wheeling 1400 S Wolf Road, Building 200 - Suite 200 Wheeling, IL 60090
Are You Ready? Strengthen your interview techniques and gain confidence in a supportive 45-minute session. Once registered, you will be asked to share your resume and a job lead prior to attending the session. Location: Education and Work Center 6704 Barrington Road Hanover Park, IL 60133 PLEASE NOTE: The American Job Center in Wheeling...
Are You Ready? Strengthen your interview techniques and gain confidence in a supportive 45-minute session. Once registered, you will be asked to share your resume and a job lead prior to attending the session. PLEASE NOTE: The American Job Center in Wheeling is committed to providing all customers with quality, professional services as well as...
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 have used Excel but don't feel they know enough about functions. We'll talk about function...
Are You Looking for a State of Illinois Job? The Illinois Department of Employment Security invites You to a Work 4 Illinois Recruitment Workshop featuring Central Management Services! The workshop will include the following services: Instruction on how to apply for jobs with the State of Illinois Overview of current job openings & opportunities with...
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...
Are You Ready? Strengthen Your Resume in 45 Minutes. Get support and guidance to improve your resume or create a targeted version to specific job opportunities. Work with the American Job Center VIRTUALLY in a 45-minute session. Once registered, you will be asked to share your resume and a job lead before getting the link...
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....
Learn about this powerful group of condition-based widely-used Excel Functions. We'll look at IF, IFS, AND, OR and expand into the exceptionally useful IF variations such as SUMIF, COUNTIF, and IFERROR Excel has a powerful group of conditional functions that automate decisions and calculations, allowing you to analyze and summarize data based on specific criteria....
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 CLASS! Registration closes 24 hours prior to class. PLEASE NOTE:...
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...
