Excel 2019 Intro to Data Analysis Tutorial

Excel 2019 Intro to Data Analysis Tutorial

Get Ad-Free Training by becoming a member today!

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:

For Private Group Trainings please visit:

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.

[christophertarkaa]

This tutorial is amazing. I can't wait for the intermediate and advanced versions

[wumbeiemmanuel]

This is an amazing tutorial that I have ever watch, may the good lord be with you. I would need more from you. Thanks.

[enricosteyl]

Thank you for this! keep up the great work !

[martinsh]

Thanks for the tutorials. You did a great job. I will like to know the version of Microsoft Excel you are using.

[Shalomrutere]

I would really appreciate tutorials for the MacOS versions of these Microsoft Office programs

[mr.september]

I'm confused. When I open the exercise file I have 2 columns before the "Commision Paid" column. Did you merge them under "Phone"?

[agbejoyeolufunmi]

I am a high school teacher, I will love and appreciate you if I can know the type of screen recorder app you make use of for this great tutorial. Thanks

[m.]

I don’t want to be rude, but you speak way too fast. Otherwise you’re fab!