Class Central is learner-supported. When you buy through links on our site, we may earn an affiliate commission.

YouTube

Excel 2019 - Intro to Data Analysis Tutorial

Learnit Training via YouTube

Overview

Dive into data analysis with Microsoft Excel 2019 in this comprehensive 1.5-hour tutorial. Learn to prepare and format data, apply table styles, use conditional functions, create charts and pivot tables, and leverage tools like Flash Fill and Sparklines. Master essential skills for analyzing, summarizing, and visualizing data, including removing duplicates, custom filtering, IF functions, and creating slicers. Ideal for Excel users with basic knowledge seeking to enhance their data analysis capabilities and draw meaningful insights from their datasets.

Syllabus

Start
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

Reviews

Start your review of Excel 2019 - Intro to Data Analysis Tutorial

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Someone learning on their laptop while sitting on the floor.