Excel 2019 Intro to Data Analysis Tutorial

Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join

Exercise Files: https://bit.ly/34Q5s3D

Who it's for: Excel users needing to analyze, summarize, and visualize their data. Basic knowledge of Excel (familiarity with formulas, cell referencing, simple functions like SUM and AVERAGE) is recommended.

What it is: Microsoft Excel is the perfect program for viewing and analyzing data.

What you'll learn: Beyond simple averages and totals, Microsoft Excel offers many features to help you draw insights from your data. Sometimes those observations come from a particular formatting or visualization of the data; other times a specific summary function will generate a surprisingly significant result. In this full-length introductory course, learn all about data analytics in Excel with tools like table formatting, conditional functions, charting, pivot tables, and much more.

Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password

Start 0:00
Introduction 0:03
Preparing Data for Tables 1:22
Removing Blank Rows and Duplicates 3:35
Using Flash Fill to Apply Table Styles 7:52
Applying Table Styles 10:40
Auto Sorting and Filtering in Tables 13:55
Applying a Custom AutoFilter in Excel Tables 18:08
Adjusting Table Style Formats and Options 21:36
Applying Total Rows 24:13
Adding New Data and Turning Off Table Styles 27:04
Applying Conditional Formats 29:53
Editing and Turning Off Conditional Formats 33:38
IF Functions 36:01
SUMIF Functions 40:47
COUNTIF Functions 44:54
AVERAGEIF Functions 48:27
Creating Charts 51:58
Editing and Reformatting Charts 55:54
Creating Sparklines 1:00:20
Creating Win-Loss Sparklines 1:03:25
Creating Pivot Tables Using the Recommended Pivot Tables Button 1:05:19
Creating Pivot Tables from Scratch 1:08:25
Editing Summary Function and Format of Pivot Table Value Fields 1:11:53
Filtering, Sorting, and Editing Pivot Table Fields 1:15:02
Grouping Column Labels in Pivot Tables 1:19:17
Creating Slicers 1:22:09
Refreshing Pivot Table Data 1:24:45
Creating and Updating Pivot Charts 1:26:29
Conclusion 1:31:27

#Excel #Data #Analysis #Microsoft #Training

(C) 2022 Learnit, Inc.
Any illegal reproduction of this content will result in immediate legal action.