Главная
Study mode:
on
1
Start
2
Introduction - Excel Intro to Data Analysis
3
List Design Basics
4
Inserting Tables for Analysis
5
Filtering Data in Tables
6
Using the Total Row
7
Conditional Formatting
8
IF Function
9
SUMIF and AVERAGEIF
10
SUMIFS
11
Inserting Recommended Charts
12
Adjusting Charts
13
Sparklines
14
Inserting Pivot Tables
15
Displaying Data as Count
16
Filtering Pivot Tables
17
Inserting Pivot Charts
18
Conclusion - Intro to Data Analysis
19
Introduction - Excel Pivot Tables
20
What are Pivot Tables?
21
Preparing Data for Analysis
22
Pivot Table Components
23
Building Pivot Tables to Show Different Values
24
Adding Fields to Pivot Tables
25
Using Built-In Filters
26
Filtering Data with Slicers
27
Displaying New Values from Data Sources
28
Inserting Pivot Charts
29
XLOOKUP
30
Joining Data Sets with XLOOKUP
31
Introduction to Advanced Pivot Tables
32
Inserting Pivot Tables from Tables
33
Calculated Fields
34
Using the Timeline Tool
35
Report Filter Pages
36
Pivot Table Layouts
37
Creating Pivot Table Designs
38
Adding Power Pivot Tabs to the Ribbon
39
Adding Tables to Power Pivot Data Model
40
Creating Table Relationships
41
Creating Columns with DAX Expressions
42
Displaying New Source Data in Power Pivot Tables
43
Data Mining with Flash Fill
44
Conclusion - Excel Pivot Tables
45
Introduction - Excel Copilot
46
What is Copilot?
47
Setting Up Copilot in Excel
48
Copilot Pane and Insights
49
Visualizing Data with Copilot
50
Sorting, Highlighting, and Filtering
51
Adding Formulas with Copilot
52
Asking Copilot Questions
53
Accessing Copilot Lab
54
Copilot Lab
55
Copilot with Excel Web Version
56
Conclusion - Excel Copilot
57
Introduction - Excel Power User
58
IF Function Basics
59
IF Functions with Calculations
60
Nesting AND with IF
61
Naming Ranges and COUNTIF
62
SUMIF and AVERAGEIF
63
SUMIFS
64
XLOOKUP
65
Populating Forms with XLOOKUP
66
Displaying Pivot Table Fields with COUNT Function
67
Calculated Fields
68
Slicers
69
Using the Timeline
70
Inserting Report Filter Pages
71
Flash Fill for Text Functions
72
Introduction to Advanced Conditional Formatting and Macros
73
Array Formula Basics
74
Looking Up Multiple Values with XLOOKUP
75
Array Functions
76
Advanced Conditional Formatting
77
Combo Charts
78
Developer Tab
79
Macro Basics
80
Relative Reference Macros
81
VBA Basics
82
Cleaning Up Macros
83
Conclusion - Excel Power User
Description:
Embark on a comprehensive 7-hour tutorial covering advanced Excel data analysis techniques. Master list design, table manipulation, and conditional formatting. Explore powerful functions like IF, SUMIF, and XLOOKUP. Dive deep into Pivot Tables, learning to build, filter, and visualize data effectively. Discover the capabilities of Excel Copilot for enhanced data insights and automation. Advance your skills with array formulas, macros, and VBA basics. Perfect for experienced Excel users seeking to elevate their data analysis proficiency, this course covers everything from fundamental concepts to advanced features, ensuring you can leverage Excel's full potential for complex data tasks.

Excel Data Analysis Full Course Tutorial

Learnit Training
Add to list
#Data Science #Data Analysis #Data Visualization #Spreadsheets #Pivot Tables #Macros #Power Pivot #XLOOKUP
0:00 / 0:00
1 of 83

Start