Getting Started with 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.
Formulas in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Functions in Microsoft Excel
OnlineSum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
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 PivotTable from a Range or TableFilters, slicers, and Pivot Charts
Power Query Editor in Microsoft Excel
OnlineIntroduction to Power Query EditorImporting Data Transforming Data Data Cleansing
Power Pivot in Microsoft Excel
OnlineHow to enable Power Pivot in ExcelBenefits of Power Pivot
Employment Technology Webinar
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
Introduction to Google Apps
OnlineGetting Started with Microsoft Word
OnlineCreating DocumentsFormatting Text Headers & Footers Formatting Pictures &Tables
Mailings Option in Microsoft Word
OnlineHow to combine excel and word to create labels, letters & envelopes