Nội dung khóa học

Loading

Course Overview
0/2
Course Introduction
01:51
Course Introduction.pdf
00:00
Module 1 Google Sheets Fundamentals
0/17
Lesson 1.0 Module Overview.pdf
00:00
Module Overview 👈 HỌC MIỄN PHÍ
01:55
What is Google Sheets 👈 HỌC MIỄN PHÍ
07:02
Lesson 1.1 What is Google Sheets.pdf
00:00
Workspace Setup Hands-on Practice (1)
10:50
Workspace Setup.xlsx
00:00
Workspace Setup Hands-on Practice (2)
05:42
Access Control & Data Protection Hands-on Practice
03:09
Access Control & Data Protection.xlsx
00:00
Collaboration & Tracking .xlsx
00:00
Collaboration & Tracking Hands-on Practice
06:30
Workspace Setup & Team Collaboration
10:30
Lesson 1.2 Workspace & Collaboration.pdf
00:00
– From Raw Data to Clarity & Readability.xlsx
00:00
From Raw Data to Clarity & Readability Hands-on Practice
07:42
From Raw Data to Clarity & Readability
02:40
Lesson 1.3 From Raw Data to Clarity & Readability.pdf
00:00
Module 2 Functions & Data Thinking
0/23
Lesson 2.0 Module Overview.pdf
00:00
Module Overview 👈 HỌC MIỄN PHÍ
00:47
Funtion Ecosytem Overview 👈 HỌC MIỄN PHÍ
02:04
Lesson 2.1 Function Ecosystem Overview.pdf
00:00
– Math & Aggregation.xlsx
00:00
Math & Aggregation 👈 HỌC MIỄN PHÍ
06:59
Lesson 2.2 Core Function Groups.pdf
00:00
– Text Funtion.xlsx
00:00
Text Funtions
08:32
– Date & Time Funtion.xlsx
00:00
Date & Time Funtions
06:26
– Logical Funtion.xlsx
00:00
Logical Funtions
02:26
– Lookup & Reference Funtion.xlsx
00:00
Lookup & Reference Funtions
09:27
Dynamic Array
09:54
Dynamic Array – Unique, Filter, Sort.xlsx
00:00
– Array Formula – Pratice.xlsx
00:00
Array Formula (Basic) Hands-on Practice
04:35
Array Formula (If) Hands-on Practice
05:01
Array Formula (Array Joining & Vlookup) Hands-on Practice
04:25
Array Formula
07:06
Lesson 2.3 ARRAYFORMULA.pdf
00:00
Module 3 Importrange, Query & Multi-Source Analytics
0/20
Importrange Hands-on Practice 👈 HỌC MIỄN PHÍ
07:02
Importrange.zip
00:00
Importrange Connect, Merge, Stay in Sync 👈 HỌC MIỄN PHÍ
04:08
Lesson 3.1 Importrange Connect, Merge, Stay in Sync.pdf
00:00
– Basic Select & Where.xlsx
00:00
Basic Select & Where Hands-on Practice
06:51
– Group By & Sum.xlsx
00:00
Group By & Sum Hands-on Practice
07:22
– Group By Multiple Columns & Pivot.xlsx
00:00
Group By Multiple Columns & Pivot Hands-on Practice
05:13
– Query with Text & Dropdown Lists.xlsx
00:00
Query with Text & Dropdown Lists (1) Hands-on Practice
05:37
Query with Text & Dropdown Lists (2) Hands-on Practice
06:18
– Query with Date & Time.xlsx
00:00
Query with Date & Time Hands-on Practice
07:54
Query – Analyze like a Data Analyst
06:43
Lesson 3.2 Query_Analyze like a Data Analyst.pdf
00:00
– Importrange & Query.zip
00:00
Importrange, Query & Multi-Source Analytics
11:22
Lesson 3.3 Importrange, Query & Multi_Source Analytics.pdf
00:00
Module 4 Data Quality & Preparation
0/16
Data Validation Hands-on Practice (1) 👈 HỌC MIỄN PHÍ
09:31
Data Validation Hands-on Practice (2) 👈 HỌC MIỄN PHÍ
11:23
– Data Validation.xlsx
00:00
Data Validation
08:32
Lesson 4.1 Data Validation.pdf
00:00
Contitional Formatting Hands-on Practice (1)
08:55
Contitional Formatting Hands-on Practice (2)
03:26
Contitional Formatting Hands-on Practice (3)
06:26
– Conditional Formatting.xlsx
00:00
Contitional Formatting
04:31
Lesson 4.2 Conditional Formatting.pdf
00:00
Data Cleaning Hands-on Practice (1)
12:53
Data_Cleaning – Practice.xlsx
00:00
Data Cleaning Hands-on Practice (2)
10:44
Data Cleaning
04:41
Lesson 4.3 Data Cleaning.pdf
00:00
Module 5 Interactive Dashboard
0/13
Lesson 5. Interactive Dashboard.pdf
00:00
Module Overview 👈 HỌC MIỄN PHÍ
01:23
– Pivot Table – Practice.xlsx
00:00
Pivot Table Hands-on Practice (1) 👈 HỌC MIỄN PHÍ
09:00
Pivot Table Hands-on Practice (2)
08:47
– Chart – Practice.xlsx
00:00
Charts Hands-on Practice (1)
11:30
Charts Hands-on Practice (2)
11:00
– Interactive Dashboard – Practice.xlsx
00:00
Interactive Dashboard Hands-on Practice (1)
07:16
Interactive Dashboard Hands-on Practice (2)
15:06
Interactive Dashboard Hands-on Practice (3)
11:35
Interactive Dashboard Hands-on Practice (4)
08:51
Module 6 Automation with Apps Scripts & Germini
0/9
From Formulas To Automation Hands-on Practice (1) 👈 HỌC MIỄN PHÍ
19:02
From Formulas To Automation Hands-on Practice (2)
05:49
Automation with Apps Scripts & Germini
08:01
Automation with Apps Scripts & Germini.zip
00:00
Lesson 6 Automation with Apps Scripts & Germini.pdf
00:00
Data Cleaning with Apps Scripts & Germini Hands-on Practice
12:52
Data Cleaning with Apps Scripts & Germini Hands-on Practice.zip
00:00
Interactive Dashboard with Apps Scripts & Germini Hands-on Practice
12:16
Interactive Dashboard with Apps Scripts & Germini Hands-on Practice.zip
00:00
Module 7 Capstone Project
0/1
Capstone Project – Dashboard Completion
02:30
Module 8 Google Sheets Tips for Real Work (Ongoing Updates)
0/7
Auto-Translating Text in Google Sheets 👈 HỌC MIỄN PHÍ
03:33
Translate Trong Google Sheets.xlsx
00:00
Fast Lookup Techniques in Google Sheets
02:29
Top5_Product_By_Region.xlsx
00:00
Automatically Updating FMCG Dashboard in Google Sheets with Claude AI
02:50
FMCG_Warehouse_Dataset.xlsx
00:00
Finding Your Top 5 Products Using QUERY in Google Sheets
02:11
Khóa học AI-Powered Google Sheet 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