Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel Intro to Data Analysis
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (0:47)
List Design Basics (3:33)
Inserting Tables for Analysis (4:58)
Filtering Data in Tables (5:12)
Using the Total Row (3:46)
Conditional Formatting (6:26)
IF Function (6:28)
SUMIF and AVERAGEIF (7:30)
SUMIFS (3:14)
Inserting Recommended Charts (5:46)
Updating Chart Data, Design, and Placement (2:17)
Sparklines (6:44)
Inserting Pivot Tables (7:53)
Displaying Data as Count (3:48)
Filtering Pivot Tables (8:40)
Inserting Pivot Charts (4:16)
Conclusion (0:55)
SUMIF and AVERAGEIF
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock