Loading view.
Excel Lookup Functions (NEW! In-Person Class)
American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United StatesDig 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...
Free
Excel Pivot Tables (New! In-Person)
American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United StatesLearn 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...
Free
Excel Essential Data Analysis Tools (New! In-Person)
American Job Center in Wheeling 1400 South Wolf Road, Building 200, Suite 200, Wheeling, IL, United StatesLooking 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...
Free
Resume Assistance (Virtual)
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...
Free
Excel Focus on Functions- Work with Text and Dates (Virtual Class)
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....
Free
First Student Hiring on the Spot
MFS- Southeast 3062 E 91st Street, Chicago, IL, United States
Free
Excel Must Have Functions: Explore powerful IF family of Logical Functions (VIRTUAL CLASS)
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....
Free
Excel Pivot Tables Level 1 (Virtual Class)
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:...
Free
Excel Advanced Concepts: Additional Data Analysis tools (Virtual Class)
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...
Free
Excel Pivot Tables Level II (Virtual Class)
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...
Free
Google Workspace: Explore the spreadsheet power of Sheets! (Virtual Class)
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 CLASS! Registration closes 24 hours prior to class. PLEASE NOTE: You must register as there is limited space...
Free