Formulas & Conditional Formatting in Microsoft Excel
OnlineIntro to FormulasLearn how to use cell references to create a simple formula in Excel How to create a complex formula 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 FormulasLearn how to use cell references to create a simple formula in Excel How to create a complex formula in Excel
The parts of a functionCreating a function To create a function using the AutoSum command
Understanding chartsHow to insert a chart Chart and layout style Switching rows and columns data How to change the chart type
How to create a PivotTableHow to insert Slicers Timeline PivotChart
Getting StartedCreating your Resume How to format your Resume according to the ATS Email and upload your resume
Getting StartedHow to create a new presentation Transition & Animations Adding Images Music and Videos
Getting Started with Google FormsCreating Simple Forms Adjusting Your Settings Sending Forms Organizing and Analyzing Responses
Getting StartedBuilding Your Spreadsheet Sort & Filter Data Formulas & Basic Functions Charts Pivotable
Getting StartedHow to create a new presentation Transition & Animations Adding Images Music and Videos
How to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation
Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Sum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
How to insert a chartChart and layout style Switching rows and columns How to change the chart type
How to create a PivotTableFilters, slicers, and PivotCharts.
How to combine multiple worksheets in oneGet data from a PDF File
How to create a new documentTables and Bulleted lists Adding Pictures and Shapes
How to combine excel and word to create labels, letters and envelopes
Applying Themes and TransitionsAnimations Inserting Pictures, Audio and Videos
How to use the Morph transition, and combine shapes and images
Emails componentsProper etiquette while sending your job application email How to organize your email Uploading and downloading your resume
Benefits of Using DriveCreate and Upload Folders Organize Files and Folders Share Folders
How to create a new DocumentText Basics Tables and Bulleted lists Formatting Pictures
Creating and Opening PresentationsApplying Themes Applying Transitions Animations Inserting Pictures Inserting Audio and Videos
Getting StartedBuilding your Spreadsheet Sort, Filter & Data Validation Formulas & Functions Chart and Pivotable
How to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation
Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Sum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
How to insert a chartChart and layout style Switching rows and columns How to change the chart type
How to insert and delete cells Modifying Columns and Rows Formatting Cells Data Filtering and Validation
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 chartChart and layout style Switching rows and columns How to change the chart type
How to insert and delete cells Modifying Columns and Rows Formatting Cells Data Filtering and Validation
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 sending your job application email How to organize your email Uploading and downloading your Resume
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
How to insert and delete cellsModifying Columns and Rows Formatting Cells Data Filtering and Validation
Intro to FormulasLearn how to use cell references to create a simple formula in Excel Absolute formulas in Excel
Sum, Average, Count, Maximum value, and Minimum valueHow the If, VLOOKUP and SUBTOTAL functions work in a sale report
How to insert a chartChart and layout style Switching rows and columns How to change the chart type