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.
- 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
- Use a mouse
- Open and close windows
- Open and save files
- Switch between applications
Expand the accordion folds to see a detailed description of the content.
Explore the contents of Excel Crash Course:
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.
View a summary of selected data on the status bar.
Learn about and create data validation rules.
Work with existing data validation rules.
Separate data in a single column into multiple columns.
Use column headers to create named ranges.
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.
Use named ranges in a function.
Explore the benefits of using an Excel table.
Work with table features such as the total row, fill options, and filters.
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.
Explore ways to work with data in multiple worksheets, including copying and pasting data, correcting the #REF! error, and linking data between worksheets.
Use the worksheet tabs to place the worksheets in chronological order.
Select multiple worksheets and format these worksheets simultaneously.
Review the benefits and procedures for working with Excel tables.
Use the built-in filter in an Excel table to filter the data.
Review how to hide columns then learn how to select only the visible data.
Utilize the Remove Duplicates dialog box to remove duplicate data.
Use the Sort dialog box to sort the data alphabetically.
Open a file in Excel and begin to learn about PivotTables.
Review how to create an Excel table.
Explore how to create and work with a PivotTable.
Explore how to filter and format a PivotTable, view the hidden details behind data, and work with built-in calculations.
Use Excel's search feature to add fields to the PivotTable.
Explore ways to make your PivotTable more understandable, including renaming and rearranging fields and pivoting rows and columns.
See how to add a total field and an average field to a PivotTable.
Continue building the PivotTable by adding the Max and Min fields.
Use filters to view specific data in the PivotTable.
Utilize the Recommended PivotTable feature to create a PivotTable. Then format and copy the PivotTable and use the Difference From calculation to compare data.
Create and format a PivotTable.
Practice creating a PivotTable.
Create and filter a PivotChart.
Learn about the different parts of a chart.
Utilize the Recommended Charts feature to create a column chart. Then modify the style, layout, and orientation of the chart.
Add alternative text to a chart.
Explore the features of a pie chart including data labels, chart titles, and the legend. Then see how to emphasize parts of the chart by "exploding" a single section or adding a secondary bar chart.
Create a line chart and then add a second data series to the chart.
Practice creating a line chart.