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
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
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 …
Introduction to Google Workspace
OnlineWhat is Google Workspace? Productivity apps for Job Seekers Google Docs Google Sheets Google Slides
Getting Started with Microsoft Word
OnlineHow to create a new Document Tables & Bulleted lists Adding Pictures & Shapes
Getting Started with Microsoft PowerPoint
OnlineApplying Themes & Transitions Animations Inserting Pictures, Audio and Videos
Getting Started with Microsoft Excel
OnlineHow to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation
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