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

Google Drive, Docs & Sheets (In Person Class) Learn the basics of this popular free web-based alternative to One Drive, Word and Excel (must have a Google account).   Google Docs, Google Sheets, and Google Drive are free web-based alternatives to Microsoft Word, Excel, and OneDrive that are part of the Google suite of productivity tools:...

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

Take the LinkedIn Basics workshop to enhance your profile. Participants must have a LinkedIn profile, access to username, password & email.LinkedIn Beginners-FREE- In PersonCome join us on Tuesday, November 12, 2024 at the American Job Center in Wheeling for a hands-on workshop on how to enhance your LinkedIn profile! This event is perfect for getting...

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

Excel Charts - Graphically visualize and communicate data using Excel's robust chart tools In this 90-minute session you'll learn to make your data more understandable and accessible using Excel's robust chart feature. Learn how to choose the right chart type (column, line, pie, etc.), and explore formatting and layout options. We'll also explore some of Excel's...

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