Главная
Study mode:
on
1
Start
2
Introduction
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
Description:
Dive into a comprehensive tutorial on data analysis using Microsoft Excel. Learn essential techniques for organizing, analyzing, and visualizing data, including table formatting, conditional functions, charting, and Pivot Tables. Master list design basics, data filtering, conditional formatting, and advanced functions like IF, SUMIF, and AVERAGEIF. Explore recommended charts, adjust visualizations, create sparklines, and harness the power of Pivot Tables for in-depth data exploration. Ideal for Excel users with basic knowledge seeking to enhance their data analysis skills and draw meaningful insights from their datasets.

Excel Introduction to Data Analysis Tutorial

Learnit Training
Add to list
0:00 / 0:00