Start

Introduction - Excel Intro to Data Analysis

List Design Basics

Inserting Tables for Analysis

Filtering Data in Tables

Using the Total Row

Conditional Formatting

IF Function

SUMIF and AVERAGEIF

SUMIFS

Inserting Recommended Charts

Adjusting Charts

Sparklines

Inserting Pivot Tables

Displaying Data as Count

Filtering Pivot Tables

Inserting Pivot Charts

Conclusion - Intro to Data Analysis

Introduction - Excel Pivot Tables

What are Pivot Tables?

Preparing Data for Analysis

Pivot Table Components

Building Pivot Tables to Show Different Values

Adding Fields to Pivot Tables

Using Built-In Filters

Filtering Data with Slicers

Displaying New Values from Data Sources

XLOOKUP

Joining Data Sets with XLOOKUP

Introduction to Advanced Pivot Tables

Inserting Pivot Tables from Tables

Calculated Fields

Using the Timeline Tool

Report Filter Pages

Pivot Table Layouts

Creating Pivot Table Designs

Adding Power Pivot Tabs to the Ribbon

Adding Tables to Power Pivot Data Model

Creating Table Relationships

Creating Columns with DAX Expressions

Displaying New Source Data in Power Pivot Tables

Data Mining with Flash Fill

Conclusion - Excel Pivot Tables

Introduction - Excel Copilot

What is Copilot?

Setting Up Copilot in Excel

Copilot Pane and Insights

Visualizing Data with Copilot

Sorting, Highlighting, and Filtering

Adding Formulas with Copilot

Asking Copilot Questions

Accessing Copilot Lab

Copilot Lab

Copilot with Excel Web Version

Conclusion - Excel Copilot

Introduction - Excel Power User

IF Function Basics

IF Functions with Calculations

Nesting AND with IF

Naming Ranges and COUNTIF

Populating Forms with XLOOKUP

Displaying Pivot Table Fields with COUNT Function

Slicers

Using the Timeline

Inserting Report Filter Pages

Flash Fill for Text Functions

Introduction to Advanced Conditional Formatting and Macros

Array Formula Basics

Looking Up Multiple Values with XLOOKUP

Array Functions

Advanced Conditional Formatting

Combo Charts

Developer Tab

Macro Basics

Relative Reference Macros

VBA Basics

Cleaning Up Macros

Conclusion - Excel Power User

Learnit Training

Excel Data Analysis Full Course Tutorial (7+ Hours)

Get 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 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:
https://www.learnitanytime.com

For Private Group Trainings please visit:
https://www.learnit.com/private-group-classes-workshops

Manuals: https://bit.ly/30xZb59
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.

Excel Data Analysis Full Course Tutorial (7+ Hours)

Excel Data Analysis Full Course Tutorial (7+ Hours)

Get Full Course Access

Highly Recommended Courses

Explore top skills

In-demand Careers

Popular Topics

Creative Skills

Business Skills

Choose your learning path