Designed for The Center of Excellence for Women and Technology, this Excel crash course begins with the very basics of Excel and continues through PivotTables and VLOOKUP.
Learning Objectives
- Enter data into a worksheet
- Work with formulas and functions
- Create and used named ranges
- Work with Excel tables
- Imporve data entry with data validation
- Split and concatenate cell contents
- Import and clean source data
- Work with data across worksheets
- Combine worksheets
- Sort and filter data
- Create, modify, and format PivotTables
- Create filters and slicers
- Explore VLOOKUP
Prerequisite Skills
- Use a mouse
- Open and close windows
- Open and save files
- Switch between applications
Excel Crash Course Contents
Expand the accordion folds to see a detailed description of the content.
Explore the contents of Excel Crash Course:
Explore the Microsoft Excel interface.
Learn how to identify text and numeric data.
Learn about using formulas in Microsoft Excel, including syntax, operators, entering formulas, and copying and pasting formulas.
Explore various ways to enter functions.
Explore absolute cell references.
See the full content for Working with absolute cell references.
Learn how named ranges can be useful when working in Excel.
Learn about charts in Microsoft Excel and create a pie chart.
Explore what happens with data in the worksheet is updated or edited.
Learn how to add a new worksheet to the workbook and add data using the autofill feature.
See how to insert blank columns and rows into a worksheet.
See how to create an Excel table and how to use that table to sort and filter data.
Use the features of the Excel table to sort and filter the data.
Learn about and create a data validation rule.
Separate data in a single column to multiple columns.
See how to apply specialized cell formattings such as zip codes and custom number formats.
See how to bring external data into Excel.
See how to move and copy worksheets, rearrange worksheet tabs, and use data from another worksheet.
See how to copy and paste only visible data.
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.
Begin to learn about pivot tables in Microsoft Excel.
See how to create a table in Microsoft Excel.
Create a pivot table from data in a spreadsheet.
See how to filter a pivot table.
Learn how to create a multi-level sort within a pivot table.
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.
See how to add a percent of grand total calculation and a calculated field.
Learn how to create and filter a pivot chart.