Autoplay
Autocomplete
Previous Chapter
Complete and Continue
Excel 2019 Intro to Data Analysis
Exercise Files - Download Before Starting the Course
Exercise Files
Course
Introduction (0:50)
Preparing Data for Tables (2:12)
Removing Blank Rows and Duplicates (4:16)
Using Flash Fill to Apply Table Styles (2:48)
Applying Table Styles (3:14)
Auto Sorting and Filtering in Tables (4:12)
Applying a Custom AutoFilter in Excel Tables (3:28)
Adjusting Table Style Formats and Options (2:37)
Applying Total Rows (2:50)
Adding New Data and Turning Off Table Styles (2:48)
Applying Conditional Formats (3:45)
Editing and Turning Off Conditional Formats (2:23)
IF Functions (4:45)
SUMIF Functions (4:06)
COUNTIF Functions (3:32)
AVERAGEIF Functions (3:31)
Creating Charts (3:56)
Editing and Reformatting Charts (4:26)
Creating Sparklines (3:05)
Creating Win-Loss Sparklines (1:53)
Creating Pivot Tables Using the Recommended Pivot Tables Button (3:05)
Creating Pivot Tables from Scratch (3:28)
Editing Summary Function and Format of Pivot Table Value Fields (3:08)
Filtering, Sorting, and Editing Pivot Table Fields (4:14)
Grouping Column Labels in Pivot Tables (2:52)
Creating Slicers (2:35)
Refreshing Pivot Table Data (1:44)
Creating and Updating Pivot Charts (4:57)
Conclusion (0:30)
Removing Blank Rows and Duplicates
Chapter content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock