Microsoft Excel Basics: Excel Basics: Spreadsheet construction, basic formulas and functions, sort, filter, formatting, and printing. This in-person TWO DAY 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,...

WORD Basics: Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing. This in-person class is taught in 1 sessions (See Below) Oct. 2nd from 1:00pm to 3:30pm Chicago time Microsoft WORD Basics: Document creation, font, paragraph and page formatting including bulleted lists, alignment, indentation, and line spacing. PRE-REGISTRATION IS REQUIRED FOR ATTENDING...

PowerPoint Basics: Create, edit and format slides, use themes, transitions and animation. This in-person class is taught in 1 sessions (See Below) Oct. 3rd  from 1:00pm to 3:30pm - Chicago time. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Registration closes at 4pm the day prior to class. Walk-ins...

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

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

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

Excel Pivot Tables Level 1 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...

Excel Pivot Tables Level II 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 WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter...

Excel Focus on Functions - Lookup and Reference: explore VLOOKUP, HLOOKUP and alternatives like INDEX and MATCH 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...

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

This IN-PERSON class is taught in 1 session from 1:00pm to 3:00pm. Creating Your Target Resumes - More critical than you think! Join us on Wednesday, October 16, 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, this is: Your opportunity to learn...

Excel and Conditional Tools: IF functions, Data Validation, Filtering, and Conditional Formatting Many tools in Excel are condition-based. So what is a condition??? We'll look at several areas of Excel that serve different purposes, but use the same underlying concept of condition. Understanding how conditions are used in Excel not only extends your knowledge of...

Get going with Google Docs: Use Docs to easily create, edit and store text-based files online In this 90-minute webinar we'll explore Google Docs - Google's web-based alternative to MS Word. Learn how to use this online text editor to create, download, and share letters, reports, resumes and other text-based documents. PRE-REGISTRATION IS REQUIRED FOR...

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

MS Word Beyond the Basics - Efficient document design with Styles, Style sets, and built-in Quick Parts Discover the power of Styles - the efficient way to format and design Word documents. If you're a regular user of Word creating reports, proposals, manuscripts, etc. learning to use Styles is a game changer! PRE-REGISTRATION IS REQUIRED...

This IN-PERSON class is taught in 1 session from 1:00pm to 3:00pm. Getting interviews - but not the job? Interview Success Secrets (In Person Workshop) Join us on Wednesday, October 23, 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. Are you tired of...

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 WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter...

In this 90-minute webinar we'll go beyond the basics to use PowerPoint's new AI Design tool, create an overall design with Slide Masters and look at basic object animation. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Registration closes 24 hours prior to class. Once you register, you will receive the link to enter class shortly...

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

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

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

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