Benefit from ad-free training by becoming a member today!
https://www.youtube.com/channel/UCqyBfm_H9ugGirk1ufYA2YA/join
Exercise files: https://learnitanytime.com/p/exercise-files-excel-data-analysis-full-course-tutorial-2024
Who is it for: This course was designed from the ground up for advanced users and those looking for more than just typical Excel tools and processes. It is recommended that participants in this course have completed our standard Excel training or, at a minimum, already master the skills referenced in this content.
What is it: Our comprehensive Excel Data Analysis tutorial is a compilation of our Excel Introduction to Data Analysis, Excel PivotTables, Excel Copilot, and Excel courses. Excel Power User.
What you'll learn: Lasting over 7 hours, our comprehensive Excel Data Analysis tutorial introduces learners to the fundamentals of data analysis, before expanding to cover all the key advanced features offered by Excel. 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:
https://www.learnitanytime.com
For private group training, please visit:
https://www.learnit.com/private-group-classes-workshops
Manuals: https://bit.ly/30xZb59
Username: manuals
Password: password
Start 0:00
Introduction – Excel Introduction 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 15:10 line
Conditional formatting 18:57
SI Function 25:23
SUMIF and MOYENNEIF 31:52
SUMIFS 39:22
Insert recommended graphics 42:37
Adjust tables 48:24
Glittering lines 50:41
Insert pivot tables 57:25
Displaying data as a number 1:05:18
Filtering pivot tables 1:09:06
Inserting PivotCharts 1:17:47
Conclusion – Introduction 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
Create pivot tables to display different values 1:40:30
Add fields to pivot tables 1:45:45
Use built-in filters 1:52:34
Filtering data with slicers 1:58:24
Showing new values from data sources 2:05:14
Inserting PivotCharts 2:11:45
SEARCHXL 2:18:37
Join datasets with XLOOKUP 2:26:48
Introduction to Advanced PivotTables 2:34:41
Inserting pivot tables from tables 2:36:07
Calculated fields 2:43:53
Use the Timeline tool 2:49:43
Report Filter Pages 2:54:59
Pivot Table Layouts 3:01:42
Creating pivot table templates 3:08:06
Adding Power Pivot tabs to the ribbon 3:15:32
Adding tables to the Power Pivot data model 3:18:15
Creating relationships between tables 3:23:17
Creating columns with expressions DAX 3:27:28
Showing new source data in pivot tables 3:34:54
Exploring data with Flash Fill 3:37:45
Conclusion – Excel Pivot Tables 3:43:48
Introduction – Excel Copilot 3:44:39
What is Copilot? 15:45:04
Configuring Copilot in Excel 3:49:05
Copilot and Insights 3:51:54
Visualizing data with Copilot 3:58:08
Sorting, highlighting and filtering 4:06:16
Add formulas with Copilot 4:14:52
Ask questions to the co-pilot 4:20:37
Access the Copilot laboratory 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
Basics of SI Function 4:43:04
SI functions with calculations 4:49:20
AND nesting with SI 4:53:43
Naming ranges and COUNTIF 5:00:02
SUMIF and MEDIUM 5:05:59
SUMIF 5:10:54
SEARCHXL 5:14:56
Filling out forms with XLOOKUP 5:23:21
Displaying PivotTable Fields with the COUNT Function 5:31:57
Calculated fields 5:36:47
Slicers 5:43:33
Use 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
Finding multiple values with XLOOKUP 6:13:00
Array Functions 6:18:01
Advanced conditional formatting 6:25:08
Combined graphics 6:32:36
Developer Tab 6:40:18
Macro Basics 6:44:31
Relative Reference Macros 6:51:07
VBA Basics 6:55:07
Clean 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.
Please take the opportunity to connect and share this video with your friends and family if you find it useful.
No Comments