_Banner_Intro_Formulas_Functions-Blue.webp)
Chapter 0
Welcome
What You Should Know
Chapter 1
Functions and Formulas
Familiarize Yourself with Functions & Formulas
Chapter 1
Functions and Formulas
Create a Formula
Chapter 1
Functions and Formulas
Introduce Arithmetic Operators
Chapter 1
Functions and Formulas
Use Cell References in Formulas
Chapter 1
Functions and Formulas
Use Absolute & Relative References in Rormulas
Chapter 1
Functions and Formulas
Copy and Paste Formulas and Values
Chapter 1
Functions and Formulas
Edit a Formula
Chapter 1
Functions and Formulas
Get Help using Excel Functions
Chapter 2
Basic Summary Formulas
Create a SUM or AVERAGE Formula
Chapter 2
Basic Summary Formulas
Create an AutoSum Formula
Chapter 2
Basic Summary Formulas
Create MIN, MAX, MEDIAN & MODE Formulas
Chapter 2
Basic Summary Formulas
Create Formulas to Count Cells
Chapter 2
Basic Summary Formulas
Formulas to Summarize Cells Conditionally
Chapter 2
Basic Summary Formulas
Summarize Data on the Status Bar
Chapter 2
Basic Summary Formulas
Round Cell Values Up and Down
Chapter 3
Managing Named Ranges & Excel Tables
Summarize Data using Named Ranges
Chapter 3
Managing Named Ranges & Excel Tables
Create a Dynamic Named Range
Chapter 3
Managing Named Ranges & Excel Tables
Edit and Delete Named Ranges
Chapter 3
Managing Named Ranges & Excel Tables
Summarize List Data by Creating Subtotals
Chapter 3
Managing Named Ranges & Excel Tables
Group and Outline List Data
Chapter 3
Managing Named Ranges & Excel Tables
Summarize Data Using an Excel tTable
Chapter 3
Managing Named Ranges & Excel Tables
Refer to Excel Table Cells in Formulas
Chapter 3
Managing Named Ranges & Excel Tables
Find Data using VLOOKUP Formulas
