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...
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 familiarity...
Starting from scratch? This hands-on session is designed for job seekers who do not have a resume or need help creating a new one. Get assistance organizing your experience, identifying your skills, and building a professional resume. Work with the American Job Center staff during an In-Person Session at: Education and Work Center 6704 Barrington Road...
Starting from Scratch? This hands-on session is designed for job seekers who do not have a resume or need help creating a new one. Get assistance organizing your experience, identifying your skills, and building a professional resume. Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200 Wheeling, IL 60090 1/2...
How spreadsheets work, basic formulas, functions, and formatting. This webinar is part 1 of a 2-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this webinar we'll talk about the Excel environment, explore basic formulas and functions, and discuss spreadsheet formatting options. PRE-REGISTRATION IS REQUIRED FOR...
Sort and filter data, work with columns, rows, sheets, and copy/paste This webinar is part 2 of a 2-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we'll learn to sort and filter, work with columns, rows and sheets, and explore different ways...
Already have a resume? Bring it with you and get hands-on assistance updating and strengthening your resume. Learn how to use AI to tailor your resume to specific jobs, highlight relevant skills and experience, and improve it for today's applicant tracking systems (ATS). Please make sure to bring your resume with you. You can save...
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
Take your LinkedIn presence to the next level! Through our partnership with Harper College, this workshop goes beyond the basics and guides you through practical, actionable strategies to boost your job search, including: 🔹 Generating tailored headlines and summaries with AI-powered suggestions 🔹 Discovering strategies to target the right jobs and employers 🔹 Optimizing and balancing your...
