Formulas and Tables 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
PivotTables in Microsoft Excel
OnlineHow to create a PivotTableFilters, slicers, and PivotCharts.
Queries in Microsoft Excel
OnlineHow to combine multiple worksheets in oneGet data from a PDF File
Getting Started with Microsoft Word
OnlineHow to create a new documentTables and Bulleted lists Adding Pictures and Shapes
Mailings option in Microsoft Word
OnlineHow to combine excel and word to create labels, letters and envelopes
Getting Started with Microsoftc PowerPoint
OnlineApplying Themes and TransitionsAnimations Inserting Pictures, Audio and Videos
Microsoft PowerPoint – Advanced Class
OnlineHow to use the Morph transition, and combine shapes and images
Featured
Winter Hiring Event
American Job Center at Malcolm X College West Campus 4624 W. Madison St., Chicago, IL, United StatesJoin us at this winter hiring event to explore career opportunities and connect with leading companies and organizations. Don't miss out on this chance to kick-start your professional journey!
CPS Hiring Event
American Job Center at the King Center 4134 S Cottage Grove, Chicago, IllinoisHosted by Chicago Public Schools and the American Job Center at the King Center
Featured
New Year New Career
SERCO is hosting the first event of the year showcasing over 20 employers attending and looking to hire for their open positions. You will have an opportunity to ask questions, apply, and even land an interview. As an American Job Center if you need assistance with finding employment we can help you with our direct …