Formulas in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Events
View monthly American Job Center Newsletters in the news section for more resources and upcoming events.
Get news delivered to your email — subscribe to our newsletter.
Loading view.
Functions in Microsoft Excel
OnlineSum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
Charts in Microsoft Excel
OnlineHow to insert a chartChart and layout style Switching rows and columns How to change the chart type
PivotTables in Microsoft Excel
OnlineHow to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Power Query Editor in Microsoft Excel
OnlineIntroduction to Power Query EditorImporting Data Transforming Data Data Cleansing
Power Pivot in Microsoft Excel
OnlineHow to enable Power Pivot in ExcelBenefits of Power Pivot
Employment Technology Webinar
OnlineHow to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Introduction to Google Apps
OnlineGetting Started with Microsoft Word
OnlineCreating DocumentsFormatting Text Headers & Footers Formatting Pictures &Tables
Mailings Option in Microsoft Word
OnlineHow to combine excel and word to create labels, letters & envelopes
Getting Started with Microsoft PowerPoint
OnlineSlide BasicsApplying Themes, Transitions & Animations Presenting your Slide Show
Featured
50th Ward Job Fair
Chicago Public Library Northtown Branch 6800 N Western Ave, Chicago, ILThis job fair is hosted by the Illinois Department of Employment Security, Senator Ram Villivalam, Illinois State Representative Kevin Olickal, 50th Ward Alderwoman Debra Silverstein, The Chicago Cook Workforce Partnership, the American Job Center in Wheeling, and Business and Career Services Inc. Career seekers can click here to register. Employers can register at https://50thward.org/jobfair
Working with Objects in Microsoft PowerPoint
OnlineInserting Music & VideosWorking with Tables & Charts
Workforce Innovation Board: Service Delivery Committee
Cook County Building 22nd Floor Conference Room G 69 W. Washington, 22nd Floor Conference Room G, Chicago, IL, United StatesThis meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room G. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/85073336537?pwd=iN1ubbXsmyNhHfQhbbxYlaoFmiBu2S.1
Workforce Innovation Board: Finance Committee
Cook County Building 22nd Floor Conference Room G 69 W. Washington, 22nd Floor Conference Room G, Chicago, IL, United StatesThis meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room G. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/87302003342?pwd=6KBWTptPxrYkP2iEVJ0VbfP8ds3EGU.1
Workforce Innovation Board: Youth Committee
Cook County Building 22nd Floor Conference Room G 69 W. Washington, 22nd Floor Conference Room G, Chicago, IL, United StatesThis meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room G. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/86304694237?pwd=m5YFOksdyAPvNF6oHte8aMDbdwSy5L.1
Getting Started with Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
Workforce Innovation Board Meeting
Cook County Building 22nd Floor Conference Room H 69 W. Washington St, 22nd Floor, Conference Room H, Chicago, IL, United StatesThis meeting will be held in person at 69 W Washington St, Chicago, IL, 60602 – 22nd floor, Conference Room H. You may attend this meeting virtually through Zoom. https://chicookworks-org.zoom.us/j/82548560486?pwd=KeZGpjERuSDQMz0WmxgrnY6uYbEA3P.1
Formulas in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
AARP Foundation Back To Work 50+
American Job Center at The King Center 4314 S. Cottage Grove, Chicago, IL, United StatesFREE WORKSHOPS FOR 50+ JOBSEEKERS You have the experience. Now regain the confidence. This may be the most important job connection you'll ever make. Job hunting is hard, especially now. Do you need help creating and launching a successful job campaign? Attend a free in-person or online BACK TO WORK 50+ workshop to get the …
ConstructionWorks Community Leader Open House
St. Augustine at Lewis University 1345 W Argyle St, Chicago, United StatesJoin the Illinois Tollway and The Chicago Cook Workforce Partnership for an opportunity to learn about ConstructionWorks workforce training opportunities and resources now available for your community.
Functions in Microsoft Excel
OnlineSum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
PivotTables in Microsoft Excel
OnlineHow to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Featured
North Suburban Career Connector Hiring & Career Resources Event
Harper College Learning and Career Center 1375 South Wolf Road, Prospect Heights, IL, United StatesCareer Connector consists of a series of in-person programs and events throughout suburban Cook County that connect residents to quality career-path opportunities and employers to a skilled, diverse talent pool. This program is brought to you by Cook County and The Chicago Cook Workforce Partnership.
ConstructionWorks Community Leader Open House
Rock Valley University 3301 N Mulford Rd, SSC Building Atrium Room #1118, Rockford, United StatesJoin the Illinois Tollway and The Chicago Cook Workforce Partnership for an opportunity to learn about ConstructionWorks workforce training opportunities and resources now available for your community.
Find-A-Job Friday
American Job Center at Malcolm X College West Campus 4624 W. Madison St., Chicago, IL, United StatesJoin us for "Find-a-Job Fridays!"—an exclusive job club series where you can connect with industry professionals, discover current job openings, and sharpen your job search skills. Whether you're just starting your search or looking to make a career change, we're here to support you every step of the way Why Attend? - Connect with potential …
ConstructionWorks Community Leader Open House
American Job Center in North Riverside 7222 W. Cermak Rd., Suite 301, North Riverside, IL, United StatesJoin the Illinois Tollway and The Chicago Cook Workforce Partnership for an opportunity to learn about ConstructionWorks workforce training opportunities and resources now available for your community.
Power Query Editor in Microsoft Excel
OnlineIntroduction to Power Query EditorImporting Data Transforming Data Data Cleansing
Power Pivot in Microsoft Excel
OnlineHow to enable Power Pivot in ExcelBenefits of Power Pivot
Featured
Fall Career & Resource Fair
St Sabina Church 1210 W. 78th Place, Chicago, IL, United StatesThe confirmed employers include Allied Universal, the City of Chicago, Chicago Public Schools, CTA, FedEx, Jewel Osco, the State of Illinois, SCR, White Castle, and 30 others! This is a no-children event. Be ready to interview and bring 20 copies of your resume.
Employment Technology Webinar
OnlineHow to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Featured
Fall Job & Resource Fair
American Job Center at Truman College 1145 W. Wilson, Chicago, IL, United StatesConstructionWorks Community Leader Open House
Chatham Education & Workforce Center 640 East 79th Street, Chicago, IL, United StatesJoin the Illinois Tollway and The Chicago Cook Workforce Partnership for an opportunity to learn about ConstructionWorks workforce training opportunities and resources now available for your community.
Microsoft OneDrive Workshop
OnlineGetting to know OneDrive. Creating and opening files and folders.
Featured
Citywide Career Fair
Olive-Harvey College 10001 S Woodlawn Ave, Chicago, IL, United StatesDoors open at 10 AM. Dress professionally and bring plenty of copies of your most updated resume. For assistance with resumes and interviewing skills, visit your neighborhood American Job Center, levelupajc.org
Featured
BWTT Building Wealth Today for Tomorrow
UIC Forum 1213 S Halsted St, Chicago, IL, United StatesJoin the “Building Wealth Today for Tomorrow” Summit! 🌟 Are you ready to unlock financial success? Look no further than the “Building Wealth Today for Tomorrow Financial Empowerment Summit” (BWTT)—Chicago’s premier event for empowering residents like you! 🔑 Why Attend? Expert Insights: Learn from seasoned professionals, industry leaders, and financial experts who will share practical strategies for wealth …
Getting Started with Microsoft Word
OnlineCreating DocumentsFormatting Text Headers & Footers Formatting Pictures &Tables
Illustration Options in Microsoft Word
OnlineLearn how to insert pictures, shapes, icons and WordArt
Getting Started with Microsoft PowerPoint
OnlineSlide BasicsApplying Themes, Transitions & Animations Presenting your Slide Show
Media and Print Options in Microsoft PowerPoint
Online- Inserting Music & Videos- Start the presentation and see your notes in Presenter view - Print your PowerPoint slides, handouts, or notes
Getting Started with Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
Formulas and Functions in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Functions in Microsoft Excel
OnlineSum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
PivotTables in Microsoft Excel
OnlineHow to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Power Query Editor in Microsoft Excel
OnlineIntroduction to Power Query EditorImporting Data Transforming Data Data Cleansing
Featured
West Suburban Cook County Career Connector Event
Triton College 2000 5th Avenue, River Grove, IL, United StatesTriton College - Student Center - Building B - 2000 5th Avenue, River Grove, IL 60171 Please dress to impress Bring 10 copies of your resume Be prepared to interview on the spot! See you on Tuesday, October 29!
Power Pivot in Microsoft Excel
OnlineHow to enable Power Pivot in ExcelBenefits of Power Pivot
Employment Technology Webinar
OnlineHow to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Microsoft Teams Workshop
Online-- Overview of Teams interface- Creating and managing Teams and channels - Chat functionality - Get started with Meetings - Audio and video calls - File sharing and collaboration in Teams
Featured
Southland Cook County Career Connector: Mission Employment
Richton Park Community Center 4455 Sauk Trail, Richton Park, ILPlease join us for this Cook County Career Connector Hiring Event in the Southland featuring 25+ hiring employers and resources that may be beneficial to you. This event is open to the public with a focus on providing employment opportunities to Veterans and their family members.
Getting Started with Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
Formulas and Functions in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Featured
The Partnership’s Sector Centers Hiring Event
Blue Door Neighborhood Center - South Lawndale 2551 W. Cermak Road, Chicago, United StatesThis hiring event will provide job seekers the opportunity to meet and interview with participating industry partners across all four sectors. Pre-registration is required! Please bring at least 4 copies of your resume, and dress professionally for an interview!
PivotTables in Microsoft Excel
OnlineHow to create a PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Power Query Editor in Microsoft Excel
OnlineIntroduction to Power Query EditorImporting Data Transforming Data Data Cleansing
Power Pivot in Microsoft Excel
OnlineHow to enable Power Pivot in ExcelBenefits of Power Pivot
Employment Technology Webinar
OnlineHow to create and format your Resume according the ATSHow to track all the details of your job hunt and be organized Job Search Techniques Emails components Proper etiquette while sending your job application email How to organize your email Uploading and downloading your Resume
Featured
The People’s Plan Hiring Event
Washburne Culinary & Hospitality Institute 740 W. 63rd Street, Chicago, IllinoisYou're invited to a hiring fair hosted by the City of Chicago Mayor's Office of Community Safety, The Chicago Cook Workforce Partnership, St. Sabina Employment Resource Center, and Kennedy-King College, City Colleges of Chicago.