Get a beginner-level introduction to Excel formulas and functions. Learn how to summarize and analyze data using these powerful data analysis features.
Overview
Syllabus
Introduction
- Create powerful Excel formulas
- What you should know before starting
- 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
- Create a SUM or AVERAGE formula
- Create an AutoSum formula
- Create formulas to count cells
- Create formulas to summarize cells conditionally
- Summarize data on the status bar
- Summarize data using named ranges
- Edit and delete named ranges
- Summarize data using an Excel table
- Refer to Excel table cells in formulas
- Manage data using text functions
- Separate data using Flash Fill
- Create data validation rules
- Restrict data entry using lists
- Trace formula precedents and dependents
- Evaluate Excel formulas step by step
- Identify and trace errors
- Manage Excel formula error indicators
- Further resources
Taught by
Curt Frye