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.…
Click below to download flyer Ill State Treasure at AJC flyer 2025
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…
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…
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…
PowerPoint: create effective data visualization presentations Learn to use PowerPoint’s graphic options like charts, tables, SmartArt, and more to create meaningful and impactful presentations that help your audience visualize and understand key data points. Creating impactful PowerPoint presentations involves leveraging its graphic options to visualize data effectively. Learn how about these key tools and how…
Are You Ready? Drop-In Resume Assistance Get support and guidance to strengthen your resume or build one targeted to specific job opportunities – no appointment needed! Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200, Wheeling, IL 60090 1/2 block south of Palatine-Willow Road on the WEST side…
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,…
THE CHICAGO COOK WORKFORCE PARTNERSHIP’S Healthcare Sector Center (HCSC) in partnership with Business and Career Services and the American Job Center in Wheeling are hosting a full-service Hiring Event for positions at NORTHWESTERN MEDICINE FEATURED JOBS: Imaging & Radiology Clinical Nurse/Registered Nurse Patient Support/Medical Assistant Advanced Practice Nurse/Physician Assistant Patient Support/Patient Care Technician Pharmacy Tech ….And…
Basic editing and formatting: fonts, bulleted lists, indentation, and line spacing This 90-minute webinar is designed to introduce key concepts crucial to building a working knowledge of MS Word. In this webinar we’ll talk about the Word environment, and explore the essential editing/formatting tools necessary to create basic documents. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS…
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.…
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…