Functions in Microsoft Excel
OnlineSum, average, count, maximum value, and minimum valueThe IF, VLOOKUP & SUBTOTAL functions
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
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 …
Microsoft OneDrive Workshop
OnlineGetting to know OneDrive. Creating and opening files and folders.
Getting Started with Microsoft Word
OnlineCreating DocumentsFormatting Text Headers & Footers Formatting Pictures &Tables
Illustration Options in Microsoft Word
OnlineLearn how to insert pictures, shapes, icons and WordArt
Getting Started with Microsoft PowerPoint
OnlineSlide BasicsApplying Themes, Transitions & Animations Presenting your Slide Show
Media and Print Options in Microsoft PowerPoint
Online- Inserting Music & Videos- Start the presentation and see your notes in Presenter view - Print your PowerPoint slides, handouts, or notes