Getting Started with Microsoft Excel
OnlineHow to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation
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.
Technical Skills Workshops
- Events
- Technical Skills Workshops
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
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
Job Application Email Workshop
OnlineEmails componentsProper etiquette while sending your job application email How to organize your email Uploading and downloading your resume