Expand the accordion folds to see a detailed description of the content.
Explore the contents of Excel Crash Course:
Excel Crash Course Contents
Explore the Excel interface.
Learn how to identify text and numeric data.
Learn about using formulas in Excel, including syntax, operators, entering formulas, and copying and pasting formulas.
Explore various ways to enter functions, including the Insert Function command on Windows, the Formula Builder on MacOS, and the AutoSum function.
Learn how to enter and AutoFill a formula and explore absolute cell references and named ranges.
See the full content for Working with Absolute Cell References and Named Ranges.
View a summary of selected data on the status bar.
See the full content for Evaluating Data with the Status Bar.
Learn about and create data validation rules.
See the full content for Improving Data Entry with Data Validation.
Work with existing data validation rules.
Separate data in a single column into multiple columns.
Combine two columns (First_Name and Last_Name) into a single column.
Copy the year from a date and place it in a new column.
Explore the benefits of using an Excel table.
Work with table features such as the total row, fill options, and filters.
Learn about the structure and use of PivotTables as well as how to organize source data.
Create and format a simple PivotTable.
Explore how to filter and then pivot a PivotTable.
See various ways to sort and group data, including by date, across PivotTables, and over multiple levels.
Explore how to filter and format a PivotTable, view the hidden details behind data, and work with built-in calculations.
See the full content for Filtering Data and Working with Built-in Calculations.
Use Excel's search feature to add fields to the PivotTable.
See the full content for Using the Search Feature to Add Fields to a PivotTable.
Explore ways to make your PivotTable more understandable, including renaming and rearranging fields and pivoting rows and columns.
See the full content for Making the PivotTable Easier to Understand.
See how to add a total field and an average field to a PivotTable.
See the full content for Working with Multiple Value Fields.
Use filters to view specific data in the PivotTable.
Explore how to use the Slicer tool to filter data.
Create a dynamic link between worksheets and explore what happens when the source data is changed.
See the full content for Linking and Refreshing PivotTables.
Explore the VLOOKUP function in both Microsoft Excel and Google Sheets.
Use the VLOOKUP function to find an exact match.
See the full content for Using VLOOKUP to find an exact match.
See how to use more than one VLOOKUP function in a worksheet.
Learn how to enter the VLOOKUP function using references from other worksheets.
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.
Explore using absolute cell references in a VLOOKUP function.
See the full content for Using absolute cell references in the VLOOKUP function.
See how to use a named range in a VLOOKUP function.
See the full content for Using a named range with the VLOOKUP function.
Practice your VLOOKUP skills with additional exercise files.
Explore how delimited text files can be imported into Excel.
Remove blank rows, set consistent formats, and find and replace spaces.
Use a formula to calculate a running balance.
Use the worksheet tabs to place the worksheets in chronological order.
Explore ways to work with data in multiple worksheets, including copying and pasting data, correcting the #REF! error, and linking data between worksheets.
See the full content for Working with Data Across Worksheets.
Select multiple worksheets and format these worksheets simultaneously.
Review how to hide columns then learn how to select only the visible data.
Utilize the Remove Duplicates dialog box to remove duplicate data.