Formulas and Tables in Microsoft Excel
OnlineIntro to Formulas Learn 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.
Technical Skills Workshops
Functions and Conditional Formatting in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum value How 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
OnlineHow to insert and delete cells Modifying Columns and Rows Formatting Cells Data Filtering and Validation
Transforming Data in Microsoft Excel
OnlineIntro to Formulas Learn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
PivotTables in Microsoft Excel
OnlineSum, Average, Count, Maximum value, and Minimum value How the If, VLOOKUP and SUBTOTAL functions work in a sale report
Power Pivot in Microsoft Excel
OnlineHow to insert a chart Chart and layout style Switching rows and columns How to change the chart type
Google Sheets Workshop
OnlineGetting StartedBuilding your Spreadsheet Sort, Filter and Data Validation Formulas and Functions Chart and Pivotable
Google Docs Workshop
OnlineHow to create a new DocumentText Basics Tables and Bulleted lists Formatting Pictures
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 …