REMOTE OFFICE HOURS at American Job Center in Wheeling 1400 S Wolf Rd Wheeling, IL 60090 Monday 8/26 2-4 pm. Staff from State Rep Tracy Katz Muhl, along with the office of Treasurer Michael Frerichs (find your unclaimed property with iCash) and State Representative Mary Beth Canty. On Monday, our teams will be hosting remote...
Excel Advanced Concepts - Pivot Tables: Summarize and manipulate data with pivot tables and pivot charts In this 90-minute webinar we'll talk about what a pivot table does and how to create pivot tables and pivot charts. We'll also look at some of the additional PivotTable options like Slicers, Timelines, calculated fields and custom grouping....
Excel Advanced Concepts - Additional tools: Data validation, Subtotal, and Conditional Formatting 1:00PM CHICAGO TIME This 90-minute webinar focuses on some of the additional 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), Outline and the What-If tools. Improving your...
Excel Focus on Functions- Work with Text and Dates: CONCATENATE, TODAY, Flash Fill and Delimited Text 9:30 am Chicago time 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...
Canva Basics - Create content for print, presentations and social media with this free online graphic design app Aug 29 at 1pm Chicago time In this virtual webinar: 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...
This IN-PERSON class is taught in 1 session from 1:00pm to 2:30pm. Creating Your Target Resumes - More critical than you think! Join us on Thursday, August 29, 2024 at 1:00pm (Chicago time), for an in-person event that will transform your job search game! Located at Harper Learning & Career Center 1375 South Wolf Road,...
How spreadsheets work, basic formulas, functions, and formatting This webinar is part 1 of a 3-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...
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...
Sort and filter data, work with columns, rows, sheets, and copy/paste This webinar is part 2 of a 3-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...
Create a slide presentation using themes, graphics, and transitions: In this 90-minute webinar you'll learn how to create PowerPoint slides and explore how to take advantage of PowerPoint's many built-in template and style features to help streamline your PowerPoint process! PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Once you register, you will receive the link...
Maybe a little friendly interview coaching will help? This IN-PERSON class is taught in 1 session from 1:00pm to 2:30pm. Are you tired of acing interviews only to be left empty-handed? If you've been struggling to land a job after making it past the interview stage, don't give up just yet. Learn sneaky secrets to interview success...
Take the LinkedIn Beginners workshop to create your profile. You must have access to an email address to confirm account.LinkedIn Beginners-FREE- In PersonCome join us on Tuesday, September 10, 2024 at the American Job Center in Wheeling for a hands-on workshop on how to kickstart your LinkedIn profile! This event is perfect for beginners.Instructor Dee...
Function overview & troubleshooting, Comments, and printing in Excel This webinar is part 3 of a 3-part webinar series designed to introduce key concepts crucial to building a working knowledge of MS Excel. In this 90-minute webinar we'll explore additional functions, look at how functions behave in the Excel environment, add Comments, and discuss printing...
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...
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! Once you register, you...
Hiring for multiple jobs - entry level to senior management and summer jobs! Job Fair at Northtown Public Library! Thurs., Sept. 12th 10am - 1pm Walk-ins welcome! Fast track your entrance: Registration is strongly recommended. Employer list* (including links to job app site) will be emailed to pre-registrants September 6th. Full-time? Part-time? Are you looking...
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! Once you register, you will receive the link to enter class shortly before class. Please watch for an...
Functions are predefined formulas that perform calculations by using specific values, called arguments, in a particular order, or structure. We'll talk about function syntax, how to recognize problems with functions, how the function library is organized, and some general troubleshooting for Excel spreadsheets. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis....
This In Person, complimentary workshop, we'll explore Google Drive, Google Docs and Google Sheets. Free Google account required. Learn how to store files online, access them from anywhere, and share these files with others. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. Workshop Location: American Job Center in Wheeling...
Streamline your Excel process with popular Windows keyboard and mouse shortcuts. Learn how to use Excel shortcut keys to quickly navigate worksheets and improve your productivity. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins accepted on a space available basis. Workshop Location: American Job Center in Wheeling 1400 S Wolf Road, Building 200, Suite 200,...
Unleash your inner creativity - that you didn't even know you have! Learn how to easily create content for print, presentations and social media with this free app. Canva is a free-to-use online graphic design tool that you can use to create social media posts, presentations, posters, videos, logos and more. Free Canva account required. PRE-REGISTRATION IS REQUIRED FOR ATTENDING THIS WORKSHOP! Walk-ins...
Hiring for hundreds of jobs at all levels – from entry level to senior management! (FOR COMPLETE FLYER) North Suburban Cook County Career Connector Hiring & Career Resources Event Questions? email contact@bcsillinois.org Funding for the North Suburban Cook County American Job Center is made possible through a grant provided by the Chicago Cook Workforce Partnership....
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....
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...
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 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 INDEX/MATCH. PRE-REGISTRATION...
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...
Excel Advanced Concepts - Get Started with Excel Tables 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...
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...
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...
