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....
Excel Advanced Concepts - Transform and Manipulate Data with Power Query In this online webinar: Get started with Excel's amazing data management tool that allows you to manipulate and transform data quickly and easily. Learn how to create, edit, load and refresh basic queries that will allow you to more easily solve everyday dataset issues. To...
This IN-PERSON class is taught in 1 session from 1:00pm to 3:00pm. How to "work" a Job Fair and get an offer (In Person Workshop) Join us on Wednesday, October 30, 2024 at 1:00 (Chicago time), for an in-person event that will transform your job search game! Located at the Education and Work Center, 6704 Barrington Rd, Hanover Park, IL 60133. Turn your next Hiring...
2024-10-31 Excel Advanced Concepts - Dashboards: Use PivotTables, Sparklines, Charts, VLOOKUP to create Excel Dashboards Dashboards are at-a-glance summaries that use graphics to illustrate progress towards a goal. Excel has a number of features like PivotTables, PivotCharts, Sparklines, and Functions that can be combined to create surprisingly robust dashboards. We highly recommend you have some...
Canva Basics - Create content for print, presentations and social media with this free online graphic design app You don't need to be a graphic designer to produce professional looking designs! By utilizing Canva's built-in templates, photo and font options anyone can create exciting content to be shared online, posted on social media site, or...
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,...
Walk-ins welcome! 12-2:30pm Career Minimart: print resume, practice elevator speech, interview coaching and more. 1p - 3p Job Fair: spectacular employers with great jobs and strong career paths. Join us for an On-the-Spot Interview - - there’s something for everyone on our team. Find out what’s best for you and your schedule. What is a...
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...