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