Microsoft Excel Training

Understand the Excel Screen

How to create blank & template-based workbooks in Excel

How to Navigate Worksheets in Excel

How to Open Workbooks in Excel

How to Save Workbooks in Excel

How to AutoRecover Excel Files

How to Use The Quick Access Toolbar in Excel

How to Print in Excel

How to Get Help in Excel

How to Close and Exit from Excel

How to Select Cells and Ranges in Excel

How to Edit Cell Data in Excel

How to Cut, Copy, and Paste in Excel

How to Use Undo, Redo, Repeat Commands in Excel

How to Use Special Paste Options in Excel

How to Insert and Move Cells in Excel

How to Delete Cells in Excel

Learn how you use Excel's spell check to proof your worksheets for spelling errors.

How to Use Find and Replace in Excel

How to Hide Columns and Rows in Excel

How to View and Edit Document Properties in Excel

How to Create Basic Formulas in Excel

How to Use AutoFill in Excel

How to Use Sum and Average Formulas in Excel

How to Use MIN and MAX Functions in Microsoft Excel

How to Use the COUNT Function in Excel

How to Apply Formatting to Text in Excel

How to Align and Merge Cells in Excel

How to Format Numbers and Dates in Excel

How to Add Cell Borders and Background Colors in Excel

How to Copy Formatting in Excel

How to Adjust Row Heights and Column Widths in Excel

How to Insert Images in Excel

How to Insert and Format Shapes in Excel

How to Insert Hyperlinks in Excel

How to Adjust Object Properties and Alt Text in Excel

How to Change Worksheet Views in Excel

How to Work with Multiple Windows in Excel

How to Move and Copy Worksheets in Excel

How to Insert, Rename, and Delete Worksheets in Excel

How to Freeze Rows and Columns in Excel

How to Hide Worksheets and Gridlines in Excel

How to Create Charts in Excel

How to Move and Resize a Chart in Excel

How to Change Chart Types in Excel

How to Apply Chart Layouts and Styles in Excel

How to Customize Chart Titles and Legends in Excel

How to Display Chart Gridlines, Labels, and Data Tables in Excel

How to Format Chart Data in Excel

How to Modify Chart Data in Excel

How to Filter Charts in Excel

How to Add Trendlines in Excel

How to Create Dual-Axis Charts in Excel

How to Create Chart Templates in Excel

How to Add Sparklines in Excel

How to Adjust Page Size and Scale in Excel

How to Set Print Area and Page Breaks in Excel

How to Print Titles, Gridlines, and Headings in Excel

How to Add Headers and Footers in Excel

How to Adjust Margins and Orientation in Excel

How to Inspect for Issues in Excel

How to Reference External Worksheets in Excel

How to use Absolute and Relative References in Excel

Order of Operations in Excel

How to Add Cell and Range Names in Excel

How to Insert Functions in Excel

How to Use the CONCAT Function in Excel

How to Use the PMT Function in Excel

How to Display Formulas in Excel

How to Use Date Formulas in Excel

The Quick Analysis tool helps you quickly format your data into a chart, table, or sparkline.

How to Use the Outline and Subtotal Features in Excel

How to Use Data Validation Rules in Excel

How to Use Flash Fill in Excel

How to Import and Export Excel Data

How to Insert a Table in Excel

How to Sort Data in Excel

How to Filter Data in Excel

How to Add Rows and Columns to Excel Tables

How to Apply Table Styles in Excel

How to Remove Duplicates in Excel

How to Use Slicers in Excel

How to Use Structured References in Excel

How to Apply Conditional Formatting in Excel

How to Apply and Remove Cell Styles in Excel

How to Create and Modify Cell Styles in Excel

How to Find and Replace Formatting in Excel

How to Apply a Theme in Excel

How to Add, Edit, and Delete Cell Comments in Excel

How to Share Workbooks in Excel

How to Co-author Workbooks in Excel

How to Use Version History in Excel

How to Protect a Worksheet in Excel

How to Protect a Workbook's Structure in Excel

How to Add Password Protection in Excel

How to Create PivotTables in Excel

How to Add Multiple PivotTable Fields to a PivotTable in Excel

How to Change a PivotTable's Calculation in Excel

How to Add and Remove Calculated Fields in Excel PivotTables

How to Use the GETPIVOTDATA Function in Excel

How to Filter PivotTables in Excel

How to Add a Timeline in Excel

Adjust a PivotTable's Layout in Excel

How to Group Values in Excel

How to Refresh a PivotTable in Excel

How to Format a PivotTable in Excel

How to Create PivotCharts in Excel

PivotChart Options in Excel

How to Apply PivotChart Styles in Excel

How to Drill-Down Chart Data in Excel

How to Fix Formula Errors in Excel

How to The Watch Window in Excel

How to Evaluate Formulas in Excel

How to Customize Conditional Formatting in Excel

How to Use Conditional Formatting with Formulas in Excel

How to Manage Conditional Formatting in Excel

How to Use International Currency and Formats in Excel

How to Apply Body and Heading Font Options in Excel

How to Create and Apply Color Schemes in Excel

How to Create and Apply Custom Themes in Excel

How to Form Controls in Excel

How to Save a Form as a Template in Excel

How to Use the IF Function in Excel

How to Insert Nested Functions in Excel

How to use AND, OR, and NOT Functions in Excel

How to Use SUMIF, AVERAGEIF, and COUNTIF Functions in Excel

How to Use the VLOOKUP Function in Excel

How to Use HLOOKUP in Excel

How to Use the INDEX and MATCH Functions in Excel

How to Use UPPER, LOWER, and PROPER Functions in Excel

How to Use RIGHT, LEFT, and MID Functions in Excel

How to Change Formula Calculation Options in Excel

How to Use Goal Seek in Excel

How Use to Scenario Manager in Excel

How to Consolidate Data in Excel

How to Enable Macros in Excel

How to Create Macros in Excel

How to Modify Macros in Excel

How to Copy Macros in Excel