Overview
-
Learn how to work with functions and formulas in Microsoft Excel. This course covers creating formulas, managing named ranges and tables, importing, exporting, and more.
Syllabus
-
Introduction
- Welcome
- What you should know
- Using the exercise files
- Familiarize yourself with functions and formulas
- Create a formula
- Introduce arithmetic operators
- Use cell references in formulas
- Use absolute and relative references in formulas
- Copy and paste formulas and values
- Edit a formula
- Get help using Excel functions
- Create a SUM or AVERAGE formula
- Create an AutoSum formula
- Create MIN, MAX, MEDIAN, and MODE formulas
- Create formulas to count cells
- Create formulas to summarize cells conditionally
- Summarize data on the Status bar
- Round cell values up and down
- Summarize data using named ranges
- Create a dynamic named range
- Edit and delete named ranges
- Summarize list data by creating subtotals
- Group and outline list data
- Summarize data using an Excel table
- Refer to Excel table cells in formulas
- Find data using VLOOKUP formulas
- Import data into Excel
- Connect to an external data source
- Clean data imported into Excel
- Convert text to columns
- Create data validation rules
- Use lists to limit values entered into a cell
- Manage Excel formula error indicators
- Trace formula precedents and dependents
- Identify and trace errors
- Evaluate Excel formulas step by step
- Watch cell values
- Create and apply scenarios to an Excel worksheet
- Edit, delete, and summarize scenarios
- Create a single-input data table
- Create a two-input data table
- Find target values using Goal Seek
- Next steps
