Nội dung khóa học

Loading

Course Overview
0/3
Course Introduction 👈 HỌC MIỄN PHÍ
02:35
All about Excel
07:24
Slide_Introduction.pdf
00:00
Module 1 Understanding Data Types in Excel
0/7
Slide_Module_1.pdf
00:00
What Is Data Type in Business Statistics (1) 👈 HỌC MIỄN PHÍ
06:16
What Is Data Type in Business Statistics (2)
05:30
Common Data Types in Excel
03:36
1.1.xlsx
00:00
1.2.xlsx
00:00
Practice Identifying and Fixing Data Type Issues in Excel
06:16
Module 2 Core Functions for Data Analysis
0/16
Introduction to Excel Functions for Data Analysis 👈 HỌC MIỄN PHÍ
02:29
Slide_Module_2.pdf
00:00
Mathematical Functions Concepts and Use Cases 👈 HỌC MIỄN PHÍ
03:48
2.1 – Math & Aggregation.xlsx
00:00
Mathematical Functions Hands-on Practice
11:26
Text Functions Concepts and Business Applications
03:22
2.2 – Text Funtions.xlsx
00:00
Text Functions Hands-on Practice
11:54
2.3 – Logical Funtions.xlsx
00:00
Logical Functions for Analytical Decision-Making and Hands-on Practice
07:33
2.4 – Date & Time Funtions.xlsx
00:00
Date & Time Functions for Business Metrics and Hands-on Practice
07:39
Lookup & Reference Functions Concepts and Use Cases
06:20
2.5 Lookup Funtions.rar
00:00
Lookup & Reference Functions Hands-on Practice (1)
09:30
Lookup & Reference Functions Hands-on Practice (2)
12:24
Module 3 Database Normalization for Data Analysis
0/6
Introduction to Database Normalization 👈 HỌC MIỄN PHÍ
05:54
Slide_Module_3.pdf
00:00
Primary Key & Foreign Key in Analytical Data
06:56
Normal Forms (1NF, 2NF, 3NF) Explained
08:18
3. Normalized Data (1NF, 2NF, 3NF) Before vs After.xlsx
00:00
Normalized Data (1NF, 2NF, 3NF) Before vs After
05:43
Module 4 Data Manipulation & Analysis in Excel
0/29
4.5 Pivot Table.pdf
00:00
4.1 Introduction to Data Manipulation Fundamentals.pdf
00:00
4.3 Pivot Table – Practice.xlsx
00:00
4.3 Pivot Table – Solution.xlsx
00:00
Introduction to Data Manipulation & Pivot Table 👈 HỌC MIỄN PHÍ
04:08
4.2 Data Cleaning.pdf
00:00
Data Cleaning Fundamentals From Data Issues to Excel Solutions 👈 HỌC MIỄN PHÍ
04:00
4.1- Data Cleaning.xlsx
00:00
Data Cleaning Hands-on Practice 👈 HỌC MIỄN PHÍ
10:35
4.3 Data Validation.pdf
00:00
4.6 Pivot Chart.pdf
00:00
Data Validation Fundamentals Ensuring Data Integrity & Accuracy
03:20
4.2 – Data Validation & Conditional Formatting.xlsx
00:00
4.2.xlsx
00:00
4.4 Pivot Chart – Practice.xlsx
00:00
4.4 Pivot Chart – Solution.xlsx
00:00
Data Validation Hands-on Practice (1)
08:49
Data Validation Hands-on Practice (2)
03:03
4.4 Conditional Formatting.pdf
00:00
Conditional Formatting Fundamentals Visual Analysis Techniques
04:24
4.2 – Data Validation & Conditional Formatting.xlsx
00:00
Conditional Formatting Hands-on Practice (1)
03:59
Conditional Formatting Hands-on Practice (2)
05:10
Pivot Tables Fundamentals From Raw Data to Business Insights
03:59
Pivot Tables Hands-on Practice (1)
09:18
Pivot Tables Hands-on Practice (2)
08:07
Advanced Pivot Tables Calculated Fields, Slicers & Timelines – Hands-on Practice (3)
10:16
Pivot Charts Fundamentals Storytelling with Analytical Visualization
03:08
Pivot Charts Hands-on Practice
08:48
Module 5 Power Query in Data Analysis
0/13
Introduction to Power Query & Data Transformation Workflow 👈 HỌC MIỄN PHÍ
01:41
Slide_Module 5.pdf
00:00
5.2 – Importing Data from Multiple Sources.rar
00:00
Importing Data from Multiple Sources (1) 👈 HỌC MIỄN PHÍ
07:58
Importing Data from Multiple Sources (2)
09:04
5.3 – Data Cleaning & Transformation with Power Query.rar
00:00
Data Cleaning & Transformation with Power Query (1)
05:58
Data Cleaning & Transformation with Power Query (2)
06:09
Data Cleaning & Transformation with Power Query (3)
09:37
Data Cleaning & Transformation with Power Query (4)
05:45
Data Cleaning & Transformation with Power Query (5)
05:37
5.4 Load To Function (Output Data).rar
00:00
Load To Function (Output Data)
10:07
Khóa học AI-Powered Excel for Data Analytics – THE FUTURE ANALYST – LÀM CHỦ TƯ DUY PHÂN TÍCH DỮ LIỆU & TỰ ĐỘNG HÓA WORKFLOW VĂN PHÒNG NHỜ AI
Vui lòng đăng nhập để xem video miễn phí.
0% Hoàn thành
Trang chủ
Tài khoản
0
Giỏ hàng
Facebook
Zalo
0
Giỏ hàng
  • Không có sản phẩm trong giỏ hàng
Tổng:
0 ₫
THANH TOÁN