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.
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