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…
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! Walk-ins accepted on a space available basis. Registration closes…
Looking to build confidence using Excel for data analysis and reporting? Learn key formulas, data organization tools and features along with other essential tools to organize, analyze, and visualize your data effectively. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS CLASS! Walk-ins accepted on a space available basis. Registration closes 24 hours prior to class. Class Location: American…
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…
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 CLASS! Registration closes 24 hours prior to class. PLEASE NOTE: You must register as there is limited space for this virtual class. Log…