Excel 2019 - Intro to Data Analysis Tutorial
Offered By: Learnit Training via YouTube
Course Description
Overview
Syllabus
Start 
Introduction 
Preparing Data for Tables 
Removing Blank Rows and Duplicates 
Using Flash Fill to Apply Table Styles 
Applying Table Styles 
Auto Sorting and Filtering in Tables 
Applying a Custom AutoFilter in Excel Tables 
Adjusting Table Style Formats and Options 
Applying Total Rows 
Adding New Data and Turning Off Table Styles 
Applying Conditional Formats 
Editing and Turning Off Conditional Formats 
IF Functions 
SUMIF Functions 
COUNTIF Functions 
AVERAGEIF Functions 
Creating Charts 
Editing and Reformatting Charts 
Creating Sparklines 
Creating Win-Loss Sparklines 
Creating Pivot Tables Using the Recommended Pivot Tables Button 
Creating Pivot Tables from Scratch 
Editing Summary Function and Format of Pivot Table Value Fields 
Filtering, Sorting, and Editing Pivot Table Fields 
Grouping Column Labels in Pivot Tables 
Creating Slicers 
Refreshing Pivot Table Data 
Creating and Updating Pivot Charts 
Conclusion 
Taught by
Learnit Training
Related Courses
Microsoft Excel 2013 - Be the Excel master !!Udemy Excel 2013 Tips and Tricks
LinkedIn Learning Excel: Productivity Tips
LinkedIn Learning Excel: You Can Do This
LinkedIn Learning Introduction to Microsoft Excel 2013
Udemy
