Excel Data Analysis Full Course Tutorial (7+ Hours)

Excel Data Analysis Full Course Tutorial (7+ Hours)

Get Ad-Free Training by becoming a member today!

Who it's for: This course was built from the ground up for the advanced users and those in search of more than typical Excel tools and processes. Attendees of this course are recommended to have completed our standard Excel training, or at a minimum already be proficient in the skills referenced in that content.

What it is: Our Excel Data Analysis Full Course Tutorial is a compilation of our Excel Intro to Data Analysis, Excel Pivot Tables, Excel Copilot, and Excel Power User courses.

What you'll learn: At over 7 hours long, our Excel Data Analysis Full Course Tutorial introduces learners to the fundamentals of data analysis, before expanding on that to cover all the top advanced features Excel offers. From advanced functions, Pivot Tables, and Copilot integration to XLOOKUP, VBA, and macros, get the most out of Excel with this comprehensive mega-course.

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 - Excel Intro to Data Analysis 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 - Intro to Data Analysis 1:22:04
Introduction - Excel Pivot Tables 1:22:59
What are Pivot Tables? 1:24:05
Preparing Data for Analysis 1:29:39
Pivot Table Components 1:34:12
Building Pivot Tables to Show Different Values 1:40:30
Adding Fields to Pivot Tables 1:45:45
Using Built-In Filters 1:52:34
Filtering Data with Slicers 1:58:24
Displaying New Values from Data Sources 2:05:14
Inserting Pivot Charts 2:11:45
XLOOKUP 2:18:37
Joining Data Sets with XLOOKUP 2:26:48
Introduction to Advanced Pivot Tables 2:34:41
Inserting Pivot Tables from Tables 2:36:07
Calculated Fields 2:43:53
Using the Timeline Tool 2:49:43
Report Filter Pages 2:54:59
Pivot Table Layouts 3:01:42
Creating Pivot Table Designs 3:08:06
Adding Power Pivot Tabs to the Ribbon 3:15:32
Adding Tables to Power Pivot Data Model 3:18:15
Creating Table Relationships 3:23:17
Creating Columns with DAX Expressions 3:27:28
Displaying New Source Data in Power Pivot Tables 3:34:54
Data Mining with Flash Fill 3:37:45
Conclusion - Excel Pivot Tables 3:43:48
Introduction - Excel Copilot 3:44:39
What is Copilot? 3:45:04
Setting Up Copilot in Excel 3:49:05
Copilot Pane and Insights 3:51:54
Visualizing Data with Copilot 3:58:08
Sorting, Highlighting, and Filtering 4:06:16
Adding Formulas with Copilot 4:14:52
Asking Copilot Questions 4:20:37
Accessing Copilot Lab 4:29:44
Copilot Lab 4:30:58
Copilot with Excel Web Version 4:37:47
Conclusion - Excel Copilot 4:41:20
Introduction - Excel Power User 4:41:32
IF Function Basics 4:43:04
IF Functions with Calculations 4:49:20
Nesting AND with IF 4:53:43
Naming Ranges and COUNTIF 5:00:02
SUMIF and AVERAGEIF 5:05:59
SUMIFS 5:10:54
XLOOKUP 5:14:56
Populating Forms with XLOOKUP 5:23:21
Displaying Pivot Table Fields with COUNT Function 5:31:57
Calculated Fields 5:36:47
Slicers 5:43:33
Using the Timeline 5:49:42
Inserting Report Filter Pages 5:54:57
Flash Fill for Text Functions 5:59:38
Introduction to Advanced Conditional Formatting and Macros 6:05:55
Array Formula Basics 6:06:42
Looking Up Multiple Values with XLOOKUP 6:13:00
Array Functions 6:18:01
Advanced Conditional Formatting 6:25:08
Combo Charts 6:32:36
Developer Tab 6:40:18
Macro Basics 6:44:31
Relative Reference Macros 6:51:07
VBA Basics 6:55:07
Cleaning Up Macros 7:01:51
Conclusion - Excel Power User 7:10:22

#excel #exceltutorial #exceltips #exceltricks #dataanalytics #datavisualization

(C) 2024 Learnit, Inc.

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

[morgancrous]

I wish all YouTube tutorials were this easy to follow along. Thank you a million times. This has helped me so much. Thanks Mo Jones for your way of explaining thoroughly.

[anshikakashyap]

This video is amazing!! I have a request, please also create a 'Data Analysis Full Course for Google Sheets' as well, or provide a detailed short video of 'Data Analysis using Google Sheets'. Thanks!

[tech-n-data]

This is the one excel course to rule them all. Clear easy to follow instructions and well organized for easy follow along. Thank you.

[sumitkoshti]

Watched the whole tutorial in one go along with practice, I must say this is gold mine for data analyst to cover each and every part of the excel along with advance excel skills. Thank you Mo.jones and Learnit for this tutorial.

[develop]

Just started your course and I want to let you know that so far I like the way you talk and explain things

[geewill]

I am far from finished but I have to say the way you explain things are clear and very precise! Awesome job, thank you!

[shivakrishnan]

Being a Youtuber myself, I know it must have taken a lot of efforts to combine multiple videos into one video or even if you shoot a 7 hour long video, it still takes lot of efforts and of course appreciate that .. Most interesting part for me in this video is Power Pivot because I am getting started with Power Pivot and I am well versed with rest of the features . Good video, thank you for uploading video

[mcayindo]

I recently watched this Excel data analysis video and I was thoroughly impressed! The instructor did an outstanding job breaking down complex concepts into easy-to-understand steps. Whether you're a beginner or looking to polish your skills, this video covers it with clarity and precision.

The pacing was perfect, and the examples used were practical and relevant. I especially appreciated the tips and shortcuts to save time in everyday tasks. The visual aids and on-screen prompts made it easy to follow along and practice simultaneously.

This video has significantly boosted my confidence in using Excel, and I can now handle data more efficiently. Highly recommend it to anyone looking to enhance their Excel skills!
Good job Learnit!

[ihmuiN]

I have completed previous Excel Training 4h and it was amazing. Now I am on this one. I appreciate for all. I would love to see SQL lessons as well if possible. It is really important for Data Analysis :)

[pittyj]

In a word, thank you! I have much gratitude for your making things easier!

[maianhnguyen]

Thank you for teaching and sharing knowledges. You help so many people with no money to apply for a course. Thank you so much. Please keep sharing free education.

[SateshwariRawat-zs]

Thankyou so much for this video❤. This is what true content means. It was easy to follow and the reasoning for using functions was even easier to grasp.

[albedoguardian]

Hands down best learning channel on YouTube.

[theselfmade]

This course cover all the topics about data analysis using excel ! Thanks for it🤩

[ahgtrell]

Glad to have come across this Channel. Its very Helpful and Insightful. As a Youtuber Myself. Who has Plans on Data Analysis. This was a Goldmine.

[hanadhira]

6:28:26 The way I've been looking for. Thank You

[CodeingFreak]

Im starting the course. Hope I will learn a lot from it!!!

[chrisawoke_]

Thank you so much for this comprehensive course. It was all I wanted 😍😍

[stellinaukr]

What an excellent course! Thanks so much for creating it! Great lecturer. Material is well structured and easily explained. I ve leant a lot of new information already. Haven't finished the course yet. Cannot wait to use all the information i ve learnt in my data analysis. Must watch this course if you want to start learning Power BI after it. Lots of extremely useful information! Many thanks for your hard work!

[nihitaraj]

this is the best video I found for excel on YouTube. so articulately explained.😄