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
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.
Intro to Formulas Learn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Sum, Average, Count, Maximum value, and Minimum value How the If, VLOOKUP and SUBTOTAL functions work in a sale report
How to insert a chart Chart and layout style Switching rows and columns How to change the chart type
Getting StartedBuilding your Spreadsheet Sort, Filter and Data Validation Formulas and Functions Chart and Pivotable
How to create a new DocumentText Basics Tables and Bulleted lists Formatting Pictures
How 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 …
How to create a new Document Tables & Bulleted lists Adding Pictures & Shapes
How to combine excel and word to create labels, letters & envelopes
Applying Themes &Transitions Animations Inserting Pictures, Audio and Videos
Introduction to Outlook Email Management Calendar and Scheduling Contacts and Address Book Tasks and To-Do Lists