Excel Data Analysis Basics π
Learn Excel data analysis fundamentals with this tutorial. Join for ad-free training and enhance your skills!

Learn Skills Daily
190.9K views β’ May 24, 2024

About this video
Excel Intro to Data Analysis Tutorial
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/467h9ar7
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.
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
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Get Ad-Free Training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Join Learnit Anytime for ad-free training, exams, certificates, and exclusive content:
https://www.learnitanytime.com
Exercise Files: https://tinyurl.com/467h9ar7
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.
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
Learnit is no longer associated with this channel/video.
(C) 2025 Bomberry Productions
Any illegal reproduction of this content will result in immediate legal action.
Tags and Topics
Browse our collection to discover more content in these categories.
Video Information
Views
190.9K
Likes
3.3K
Duration
01:22:57
Published
May 24, 2024
User Reviews
4.7
(38) Related Trending Topics
LIVE TRENDSRelated trending topics. Click any trend to explore more videos.
Trending Now