Introducing Microsoft Excel
Exploring types of data
Introducing formulas Learn about using formulas in Microsoft Excel, including syntax, operators, entering formulas, and copying and pasting formulas.
See the full content for Introducing formulas.
Introducing functions
Working with absolute cell references
Utilizing a named range Learn how named ranges can be useful when working in Excel.
See the full content for Utilizing a named range.
Introducing charts Learn about charts in Microsoft Excel and create a pie chart.
See the full content for Introducing charts.
Updating worksheet data Explore what happens with data in the worksheet is updated or edited.
See the full content for Updating worksheet data.
Adding a worksheet Learn how to add a new worksheet to the workbook and add data using the autofill feature.
See the full content for Adding a worksheet.
Inserting columns and rows See how to insert blank columns and rows into a worksheet.
See the full content for Inserting columns and rows.
Creating an Excel table See how to create an Excel table and how to use that table to sort and filter data.
See the full content for Creating an Excel table.
Sorting and filtering data Use the features of the Excel table to sort and filter the data.
See the full content for Sorting and filtering data.
Working with data validation
Splitting cell contents Separate data in a single column to multiple columns.
See the full content for Splitting cell contents.
Utilizing special cell formats See how to apply specialized cell formattings such as zip codes and custom number formats.
See the full content for Utilizing special cell formats.
Working with external data
Working across worksheets See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
See the full content for Working across worksheets.
Copying visible data
Introducing VLOOKUP Explore the VLOOKUP function in both Microsoft Excel and Google Sheets.
See the full content for Introducing VLOOKUP.
Using VLOOKUP to find an exact match
Using multiple VLOOKUP functions See how to use more than one VLOOKUP function in a worksheet.
See the full content for Using multiple VLOOKUP functions.
Using VLOOKUP across worksheets Learn how to enter the VLOOKUP function using references from other worksheets.
See the full content for Using VLOOKUP across worksheets.
Using VLOOKUP to find an approximate match See how to use the VLOOKUP function to find an approximate, or closest without going over, match.
See the full content for Using VLOOKUP to find an approximate match.
Using absolute cell references in the VLOOKUP function
Using a named range with the VLOOKUP function
Additional VLOOKUP practice Practice your VLOOKUP skills with additional exercise files.
See the full content for Additional VLOOKUP practice.
Introducing pivot tables Begin to learn about pivot tables in Microsoft Excel.
See the full content for Introducing pivot tables.
Creating an Excel table
Creating a pivot table Create a pivot table from data in a spreadsheet.
See the full content for Creating a pivot table.
Filtering a pivot table
Sorting a pivot table Learn how to create a multi-level sort within a pivot table.
See the full content for Sorting a pivot table.
Working with multiple value fields See how to work with multiple value fields and then group a pivot table by date.
See the full content for Working with multiple value fields.
Working with calculations See how to add a percent of grand total calculation and a calculated field.
See the full content for Working with calculations.
Creating a pivot chart 
