Excel Intro to Data Analysis Tutorial

Excel 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:09
List Design Basics 1:25
Inserting Tables for Analysis 4:59
Filtering Data in Tables 9:57
Using the Total Row 15:10
Conditional Formatting 18:57
IF Function 25:23
SUMIF and AVERAGEIF 31:52
SUMIFS 39:22
Inserting Recommended Charts 42:37
Adjusting Charts 48:24
Sparklines 50:41
Inserting Pivot Tables 57:25
Displaying Data as Count 1:05:18
Filtering Pivot Tables 1:09:06
Inserting Pivot Charts 1:17:47
Conclusion 1:22:04

#excel #exceltutorial #exceltips #exceltricks #datavisualization

(C) 2024 Learnit, Inc.

Any illegal reproduction of this content will result in immediate legal action.

[Aybmhm]

I like the way i just download the prepared file data and the way i go get back to here, fascinating.🥇

[basantmokhtar]

Excellent curriculum and professional explanation

[Benito-Malamute]

Thank you very much. You explain clearly and simply how to start data analysis with Excel. I would like to advance applied statistics a little more complex, which video do you recommend, thanks? I hope your channel continues to grow!

[burchi]

Good video :) Question How did you move the content of the cell lover "ALT +F1 - 48:33 minutes?

[rezwan.ipe.]

can I get a certificate after completion of my course?

[heshamramadan]

SOS, the web site that have excel data, cant open for me because ssl issue if any one can upload the file i will be grateful <3

[noushinganjizadeh]

The exercise files don't work unless I pay the Microsoft subscription

[ashwathraj]

Hi, I am hearing a thumping sound when you type the keys. So it is hard to follow your voice, quite annoying. Is this rectifiable? Kindly assist.

[akintobioluwatobi]

Anyone with the answers to the LAB section

[ferozex.]

Plz leave the controlling of green/ 7/ butterfly. So so Teddy and harmful. Not Holly. Miss guided and miss leaded. Much disturbing. I can't it. Sorry.