Functions and Conditional Formatting in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
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.
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 PivotTableFilters, slicers, and PivotCharts.
Featured
Winter Hospitality Hiring Event
Hospitality and Tourism Sector Center 218 South Wabash Avenue, Chicago, United StatesThis hiring event will allow job seekers to meet with employers in one location looking to hire part-time and full-time team members. Pre-registration is required! Please bring at least 5 copies of your resume, and dress professionally for an interview!
Queries in Microsoft Excel
OnlineHow to combine multiple worksheets in oneGet data from a PDF File
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 Preparing your Employment Portfolio
Job Application Email Workshop
OnlineEmails componentsProper etiquette while sending your job application email How to organize your email Uploading and downloading your resume
Healthcare Hiring Event
Blue Door Neighborhood Center - Morgan Park 11840 S. Marshfield Ave., Chicago, IL, United StatesSTARTING PAY RANGES $18-S45 DOE/DOP Positions Available Include: NURSING ASSISTANTS PATIENT TRANSPORTER MEDICAL ASSISTANTS PATIENT SERVICE REP. LPN, RN, EMT, PARAMEDICS CUSTOMER SERVICE PHLEBOTOMISTS COORDINATOR STERILE PROCESSING PATIENT CARE TECH OPERATING ROOM LIAISON PATIENT SERVICES REPS SURGICAL TECHNICIANS HOME HEALTH AIDES CALL CENTER
Featured
New Year, New Career Job Fair
Chatham Education & Workforce Center 640 East 79th Street, Chicago, IL, United StatesThis event presents a great opportunity for job seekers to connect with leading companies to explore a wide range of career opportunities. Whether you need immediate employment or long-term career options, don’t miss out on this chance to advance your career. Dress professionally, bring resumes and be ready to interview with hiring managers! When? February …
Featured
Aspire to Hire Community Hiring Event
Discover Customer Care Center 8560 S Cottage Grove Ave, Chicago, IllinoisIndustries Represented: Transportation, Distribution, and Logistics (TDL) Manufacturing and Warehouse
Back to Work 50+ March Virtual Intro Session
OnlineTo register, call 855-850-2525. AARPF Back to Work 50+ Virtual Overview Workshop | 7 Smart Strategies
Blue Island Multi-Employer Hiring Event
Salvation Army in Blue Island 2900 Burr Oak Avenue, Blue Island, IL, United StatesWalk-ins welcome! Register by March 7th to receive the list of participating employers. Questions? contact@bcsillinois.org