Play all

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

Description:

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.

Excel 2019 - Intro to Data Analysis Tutorial

Learnit Training

Add to list

#Data Science #Data Analysis #Spreadsheets #Pivot Tables #Data Visualization #Data Preparation #Flash Fill

0:00 / 0:00