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 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
Charts in Microsoft Excel
OnlineHow to insert a chartChart and layout style Switching rows and columns How to change the chart type
Data-Cleaning in Microsoft Excel
OnlineRemoving Duplicates How to combine multiple worksheets in one Get data from a PDF File Import data from a text file
PivotTables in Microsoft Excel
OnlineHow to create a PivotTable from a Range or Table Filters, slicers, and Pivot Charts
Employment Technology Webinar & Job Application Email
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
Fat Burger Hiring Event
Wabash Ave. 218 S. Wabash Ave. Suite 540, Chicago, IL, United States
Featured
Chicago Residents & New Arrivals Job Fair
Arturo Velasquez Institute (AVI) 2800 S. Western Avenue, Chicago, IL, United States
Featured
Community Day
West Side Learning Center 4624 W. Madison St., Chicago, IL, United StatesGoogle Drive and Docs Workshop
OnlineGetting Started with Google DriveCreating Google Docs Formatting Text Working with Tables & Images