Teach Reality

Teach Reality ๐„๐ฑ๐œ๐ž๐ฅ ๐๐š๐ฌ๐ข๐œ แ€€แ€”แ€ฑ แ€…แ€แ€„แ€บแ€•แ€ผแ€ฎแ€ธ ๐„๐ฑ๐œ๐ž๐ฅ ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ข๐ฌ แ€–แ€ผแ€…แ€บแ€žแ€Šแ€บแ€กแ€‘แ€ญ แ€แ€…แ€บแ€†แ€„แ€บแ€ทแ€แ€ปแ€„แ€บแ€ธ แ€‘แ€ญแ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€›แ€ฑแ€ฌแ€€แ€บแ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€žแ€Šแ€ทแ€บ ๐™๐จ๐จ๐ฆ ๐‚๐ฅ๐š๐ฌ๐ฌ แ€žแ€„แ€บแ€แ€”แ€บแ€ธแ‹Excel แ€žแ€ฎแ€ธแ€žแ€”แ€ทแ€บแ€•แ€ฒแ€žแ€„แ€บแ€•แ€ซแ€แ€šแ€บแ€›แ€พแ€„แ€ทแ€บแ‹
(3)

20/08/2026

100% ๐…๐ซ๐ž๐ž ๐‘๐ž๐œ๐จ๐ซ๐๐ข๐ง๐  ๐•๐ข๐๐ž๐จ ๐‚๐ฅ๐š๐ฌ๐ฌ๐ŸŽ“

แ€žแ€„แ€บแ€แ€”แ€บแ€ธแ€แ€€แ€บแ€›แ€ฑแ€ฌแ€€แ€บแ€–แ€ฐแ€ธแ€žแ€ฐแ€แ€ญแ€ฏแ€„แ€บแ€ธแ€กแ€แ€ฝแ€€แ€บ ๐Ÿ’š

แ€€แ€ปแ€ฝแ€”แ€บแ€™แ€†แ€ฎแ€™แ€พแ€ฌ แ€žแ€„แ€บแ€แ€”แ€บแ€ธแ€แ€€แ€บแ€›แ€ฑแ€ฌแ€€แ€บแ€–แ€ฐแ€ธแ€žแ€ฐ แ€™แ€Šแ€บแ€žแ€ฐแ€™แ€†แ€ญแ€ฏ

แ€กแ€แ€”แ€บแ€ธแ€žแ€…แ€บแ€™แ€ปแ€ฌแ€ธแ New Recording Video Class แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€กแ€แ€™แ€ฒแ€ท แ€•แ€ผแ€”แ€บแ€œแ€Šแ€บแ€œแ€ฑแ€ทแ€œแ€ฌแ€”แ€ญแ€ฏแ€„แ€บแ€•แ€ซแ€แ€šแ€บแ€›แ€พแ€„แ€ทแ€บแ‹

Excel แ€”แ€ฒแ€ทแ€•แ€แ€บแ€žแ€€แ€บแ€แ€ฒแ€ท แ€กแ€žแ€…แ€บแ€กแ€žแ€…แ€บแ€žแ€ฑแ€ฌ Knowledge แ€™แ€ปแ€ฌแ€ธแŠ แ€•แ€ญแ€ฏแ€™แ€ญแ€ฏแ€œแ€ฝแ€šแ€บแ€€แ€ฐแ€•แ€ผแ€ฎแ€ธ แ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€แ€ฒแ€ท แ€œแ€ฑแ€ทแ€œแ€ฌแ€”แ€Šแ€บแ€ธแ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€กแ€™แ€ผแ€ฒ Update แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€”แ€ฑแ€แ€ฒแ€ทแ€กแ€แ€ฝแ€€แ€บ

แ€žแ€„แ€บแ€แ€”แ€บแ€ธแ€žแ€ฐ/แ€žแ€ฌแ€ธแ€Ÿแ€ฑแ€ฌแ€„แ€บแ€ธแ€™แ€ปแ€ฌแ€ธแ€œแ€Šแ€บแ€ธ แ€†แ€€แ€บแ€œแ€€แ€บแ€œแ€ฑแ€ทแ€œแ€ฌแ€•แ€ผแ€ฎแ€ธ Skill แ€™แ€ปแ€ฌแ€ธ แ€แ€ญแ€ฏแ€ธแ€แ€€แ€บแ€”แ€ญแ€ฏแ€„แ€บแ€…แ€ฑแ€–แ€ญแ€ฏแ€ท แ€›แ€Šแ€บแ€›แ€ฝแ€šแ€บแ€•แ€ผแ€ฎแ€ธ แ€™แ€ปแ€พแ€แ€ฑแ€•แ€ฑแ€ธแ€แ€ผแ€„แ€บแ€ธแ€–แ€ผแ€…แ€บแ€•แ€ซแ€แ€šแ€บแ€›แ€พแ€„แ€ทแ€บ ๐Ÿ’š

แ€กแ€†แ€„แ€บแ€™แ€•แ€ผแ€ฑแ€แ€ฌแŠแ€”แ€ฌแ€ธแ€™แ€œแ€Šแ€บแ€›แ€พแ€ญแ€œแ€ฒแ€™แ€ฑแ€ธแ€œแ€ญแ€ฏแ€ทแ€›แ€•แ€ซแ€แ€šแ€บแ€›แ€พแ€„แ€ทแ€บแ‹๐Ÿ“Š

20/08/2026

๐„๐ฑ๐œ๐ž๐ฅ ๐…๐จ๐ซ ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ข๐ฌ
Zoom Live Group Class

๐Ÿ“ˆ Data แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€•แ€ผแ€ฎแ€ธ Report แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Professional แ€กแ€†แ€„แ€ทแ€บแ€–แ€ผแ€„แ€ทแ€บ แ€–แ€”แ€บแ€แ€ฎแ€ธแ€แ€แ€บแ€แ€ปแ€„แ€บแ€•แ€ซแ€žแ€œแ€ฌแ€ธ?

Teach Reality แ Excel for Data Analysis Zoom Live Group Class แ€แ€ฝแ€„แ€บ Excel Foundation แ€™แ€พ Data AnalysisแŠ Pivot TableแŠ Power Query แ€”แ€พแ€„แ€ทแ€บ Professional Dashboard แ€กแ€‘แ€ญ แ€œแ€€แ€บแ€แ€ฝแ€ฑแ€ทแ€กแ€žแ€ฏแ€ถแ€ธแ€แ€ปแ€”แ€ญแ€ฏแ€„แ€บแ€žแ€ฑแ€ฌ Skill แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Step by Step แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€žแ€ฝแ€ฌแ€ธแ€™แ€Šแ€บ แ€–แ€ผแ€…แ€บแ€•แ€ซแ€žแ€Šแ€บแ‹

๐Ÿ“ƒ Certificate แ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹
๐ŸŽฅ Telegram แ€™แ€พ Recording Video แ€™แ€ปแ€ฌแ€ธแ€•แ€ผแ€”แ€บแ€•แ€ญแ€ฏแ€ทแ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹

๐Ÿ“š Course Outline
๐ŸŸข Level 1 โ€“ Excel Foundation

Excel Workbook แ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€žแ€ญแ€™แ€บแ€ธแ€†แ€Šแ€บแ€ธแ€”แ€Šแ€บแ€ธ
Quick Access Toolbar & Ribbon แ€€แ€ญแ€ฏ แ€•แ€ผแ€„แ€บแ€†แ€„แ€บแ€”แ€Šแ€บแ€ธ
Excel Settings
Home Tab แ€€แ€ญแ€ฏ แ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€…แ€ฝแ€ฌ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Data Entry
Data Management
แƒ แ€œแ€…แ€ฌ แ€แ€„แ€บแ€„แ€ฝแ€ฑ แŠแ€กแ€žแ€ฏแ€ถแ€ธแ€…แ€›แ€ญแ€แ€บแ€แ€…แ€บแ€•แ€ผแ€ญแ€ฏแ€„แ€บแ€‘แ€ฒแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
แ†แ€œแ€…แ€ฌ แ€€แ€ฏแ€”แ€บแ€•แ€…แ€นแ€…แ€Šแ€บแ€ธ แ€กแ€แ€„แ€บแŠแ€กแ€‘แ€ฝแ€€แ€บแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ

๐Ÿ”ต Level 2 โ€“ Excel Functions& Advanced Function

Basic Excel Functions
Advanced Excel Functions
SUMIF / SUMIFS
COUNTIF / COUNTIFS
AVERAGEIF / AVERAGEIFS
VLOOKUP / HLOOKUP / XLOOKUP
INDEX + MATCH
IF / Nested IF / IFS
Text Functions.....
Math & Trig Functions ......
Other Functions ....

๐ŸŸฃ Level 3 โ€“ Data Preparation
Table
Sort Filter
Filter + Check Box
Filter+ Macro
Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Excel File แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Update แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€Šแ€บแ€ธ
Macro แ€กแ€แ€ผแ€ฑแ€แ€ถแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Excel แ€–แ€ผแ€„แ€ทแ€บ Data Analysis
Macro แ€€แ€ญแ€ฏ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ Data Analysis
Macro & Filter Function
Macro & Advanced Filter
Data แ€™แ€ปแ€ฌแ€ธ แ€…แ€€แ€นแ€€แ€”แ€ทแ€บแ€•แ€ญแ€ฏแ€„แ€บแ€ธแ€กแ€แ€ฝแ€„แ€บแ€ธ Pro แ€€แ€ปแ€€แ€ป แ€…แ€…แ€บแ€‘แ€ฏแ€”แ€Šแ€บแ€ธ

๐ŸŸก Level 4 โ€“ Data Analysis & Reporting
Advanced Charts

Function แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€แ€ฝแ€ฒแ€–แ€€แ€บแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€•แ€ผแ€ฎแ€ธ
แ€œแ€กแ€œแ€ญแ€ฏแ€€แ€บแŠแ€”แ€ฑแ€ทแ€กแ€œแ€ญแ€ฏแ€€แ€บ แ€แ€„แ€บแ€„แ€ฝแ€ฑแŠแ€‘แ€ฝแ€€แ€บโ€Œแ€„แ€ฝแ€ฑแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€™แ€ปแ€ฌแ€ธ
Pro แ€†แ€”แ€บแ€†แ€”แ€บ Chart แ€™แ€ปแ€ฌแ€ธแ€–แ€ผแ€„แ€ทแ€บแ€•แ€ผแ€”แ€Šแ€บแ€ธ
Stock In/Stock Out Magement
Basic & Advanced Pivot Table
Power Pivot (Relationship)
Professional Report แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ
Attendance แ€…แ€ฌแ€›แ€„แ€บแ€ธ แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
Classic Pivot Table
Professional Dashboard แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ

Weekend Class
๐Ÿ“…Start Date - 22/8/2026
โฐTime - 11 AM to 1 PM
๐Ÿ“…Total - 10 Weeks (20 Sessions)
๐Ÿ“…Day - Saturday, Sunday

๐Ÿ’ธFees - 190,000 KS


20/08/2026

Excel Shortcut Keys Part 1 ๐Ÿ“Œ

๐„๐ฑ๐œ๐ž๐ฅ ๐…๐จ๐ซ ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ข๐ฌ
Zoom Live Group Class

๐Ÿ“ˆ Data แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€•แ€ผแ€ฎแ€ธ Report แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Professional แ€กแ€†แ€„แ€ทแ€บแ€–แ€ผแ€„แ€ทแ€บ แ€–แ€”แ€บแ€แ€ฎแ€ธแ€แ€แ€บแ€แ€ปแ€„แ€บแ€•แ€ซแ€žแ€œแ€ฌแ€ธ?

Teach Reality แ Excel for Data Analysis Zoom Live Group Class แ€แ€ฝแ€„แ€บ Excel Foundation แ€™แ€พ Data AnalysisแŠ Pivot TableแŠ Power Query แ€”แ€พแ€„แ€ทแ€บ Professional Dashboard แ€กแ€‘แ€ญ แ€œแ€€แ€บแ€แ€ฝแ€ฑแ€ทแ€กแ€žแ€ฏแ€ถแ€ธแ€แ€ปแ€”แ€ญแ€ฏแ€„แ€บแ€žแ€ฑแ€ฌ Skill แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Step by Step แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€žแ€ฝแ€ฌแ€ธแ€™แ€Šแ€บ แ€–แ€ผแ€…แ€บแ€•แ€ซแ€žแ€Šแ€บแ‹

๐Ÿ“ƒ Certificate แ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹
๐ŸŽฅ Telegram แ€™แ€พ Recording Video แ€™แ€ปแ€ฌแ€ธแ€•แ€ผแ€”แ€บแ€•แ€ญแ€ฏแ€ทแ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹

๐Ÿ“š Course Outline
๐ŸŸข Level 1 โ€“ Excel Foundation

Excel Workbook แ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€žแ€ญแ€™แ€บแ€ธแ€†แ€Šแ€บแ€ธแ€”แ€Šแ€บแ€ธ
Quick Access Toolbar & Ribbon แ€€แ€ญแ€ฏ แ€•แ€ผแ€„แ€บแ€†แ€„แ€บแ€”แ€Šแ€บแ€ธ
Excel Settings
Home Tab แ€€แ€ญแ€ฏ แ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€…แ€ฝแ€ฌ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Data Entry
Data Management
แƒ แ€œแ€…แ€ฌ แ€แ€„แ€บแ€„แ€ฝแ€ฑ แŠแ€กแ€žแ€ฏแ€ถแ€ธแ€…แ€›แ€ญแ€แ€บแ€แ€…แ€บแ€•แ€ผแ€ญแ€ฏแ€„แ€บแ€‘แ€ฒแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
แ†แ€œแ€…แ€ฌ แ€€แ€ฏแ€”แ€บแ€•แ€…แ€นแ€…แ€Šแ€บแ€ธ แ€กแ€แ€„แ€บแŠแ€กแ€‘แ€ฝแ€€แ€บแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ

๐Ÿ”ต Level 2 โ€“ Excel Functions& Advanced Function

Basic Excel Functions
Advanced Excel Functions
SUMIF / SUMIFS
COUNTIF / COUNTIFS
AVERAGEIF / AVERAGEIFS
VLOOKUP / HLOOKUP / XLOOKUP
INDEX + MATCH
IF / Nested IF / IFS
Text Functions.....
Math & Trig Functions ......
Other Functions ....

๐ŸŸฃ Level 3 โ€“ Data Preparation
Table
Sort Filter
Filter + Check Box
Filter+ Macro
Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Excel File แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Update แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€Šแ€บแ€ธ
Macro แ€กแ€แ€ผแ€ฑแ€แ€ถแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Excel แ€–แ€ผแ€„แ€ทแ€บ Data Analysis
Macro แ€€แ€ญแ€ฏ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ Data Analysis
Macro & Filter Function
Macro & Advanced Filter
Data แ€™แ€ปแ€ฌแ€ธ แ€…แ€€แ€นแ€€แ€”แ€ทแ€บแ€•แ€ญแ€ฏแ€„แ€บแ€ธแ€กแ€แ€ฝแ€„แ€บแ€ธ Pro แ€€แ€ปแ€€แ€ป แ€…แ€…แ€บแ€‘แ€ฏแ€”แ€Šแ€บแ€ธ

๐ŸŸก Level 4 โ€“ Data Analysis & Reporting
Advanced Charts

Function แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€แ€ฝแ€ฒแ€–แ€€แ€บแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€•แ€ผแ€ฎแ€ธ
แ€œแ€กแ€œแ€ญแ€ฏแ€€แ€บแŠแ€”แ€ฑแ€ทแ€กแ€œแ€ญแ€ฏแ€€แ€บ แ€แ€„แ€บแ€„แ€ฝแ€ฑแŠแ€‘แ€ฝแ€€แ€บโ€Œแ€„แ€ฝแ€ฑแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€™แ€ปแ€ฌแ€ธ
Pro แ€†แ€”แ€บแ€†แ€”แ€บ Chart แ€™แ€ปแ€ฌแ€ธแ€–แ€ผแ€„แ€ทแ€บแ€•แ€ผแ€”แ€Šแ€บแ€ธ
Stock In/Stock Out Magement
Basic & Advanced Pivot Table
Power Pivot (Relationship)
Professional Report แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ
Attendance แ€…แ€ฌแ€›แ€„แ€บแ€ธ แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
Classic Pivot Table
Professional Dashboard แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ

Weekend Class
๐Ÿ“…Start Date - 22/8/2026
โฐTime - 11 AM to 1 PM
๐Ÿ“…Total - 10 Weeks (20 Sessions)
๐Ÿ“…Day - Saturday, Sunday

๐Ÿ’ธFees - 190,000 KS


20/08/2026

Excel For Data Analysis Zoom Group Class แ€™แ€พแ€ฌ แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€™แ€Šแ€ทแ€บ Dashboard ๐Ÿ“Š

๐„๐ฑ๐œ๐ž๐ฅ ๐…๐จ๐ซ ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ข๐ฌ
Zoom Live Group Class

๐Ÿ“ˆ Data แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€•แ€ผแ€ฎแ€ธ Report แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Professional แ€กแ€†แ€„แ€ทแ€บแ€–แ€ผแ€„แ€ทแ€บ แ€–แ€”แ€บแ€แ€ฎแ€ธแ€แ€แ€บแ€แ€ปแ€„แ€บแ€•แ€ซแ€žแ€œแ€ฌแ€ธ?

Teach Reality แ Excel for Data Analysis Zoom Live Group Class แ€แ€ฝแ€„แ€บ Excel Foundation แ€™แ€พ Data AnalysisแŠ Pivot TableแŠ Power Query แ€”แ€พแ€„แ€ทแ€บ Professional Dashboard แ€กแ€‘แ€ญ แ€œแ€€แ€บแ€แ€ฝแ€ฑแ€ทแ€กแ€žแ€ฏแ€ถแ€ธแ€แ€ปแ€”แ€ญแ€ฏแ€„แ€บแ€žแ€ฑแ€ฌ Skill แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Step by Step แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€žแ€ฝแ€ฌแ€ธแ€™แ€Šแ€บ แ€–แ€ผแ€…แ€บแ€•แ€ซแ€žแ€Šแ€บแ‹

๐Ÿ“ƒ Certificate แ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹
๐ŸŽฅ Telegram แ€™แ€พ Recording Video แ€™แ€ปแ€ฌแ€ธแ€•แ€ผแ€”แ€บแ€•แ€ญแ€ฏแ€ทแ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹

๐Ÿ“š Course Outline
๐ŸŸข Level 1 โ€“ Excel Foundation

Excel Workbook แ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€žแ€ญแ€™แ€บแ€ธแ€†แ€Šแ€บแ€ธแ€”แ€Šแ€บแ€ธ
Quick Access Toolbar & Ribbon แ€€แ€ญแ€ฏ แ€•แ€ผแ€„แ€บแ€†แ€„แ€บแ€”แ€Šแ€บแ€ธ
Excel Settings
Home Tab แ€€แ€ญแ€ฏ แ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€…แ€ฝแ€ฌ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Data Entry
Data Management
แƒ แ€œแ€…แ€ฌ แ€แ€„แ€บแ€„แ€ฝแ€ฑ แŠแ€กแ€žแ€ฏแ€ถแ€ธแ€…แ€›แ€ญแ€แ€บแ€แ€…แ€บแ€•แ€ผแ€ญแ€ฏแ€„แ€บแ€‘แ€ฒแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
แ†แ€œแ€…แ€ฌ แ€€แ€ฏแ€”แ€บแ€•แ€…แ€นแ€…แ€Šแ€บแ€ธ แ€กแ€แ€„แ€บแŠแ€กแ€‘แ€ฝแ€€แ€บแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ

๐Ÿ”ต Level 2 โ€“ Excel Functions& Advanced Function

Basic Excel Functions
Advanced Excel Functions
SUMIF / SUMIFS
COUNTIF / COUNTIFS
AVERAGEIF / AVERAGEIFS
VLOOKUP / HLOOKUP / XLOOKUP
INDEX + MATCH
IF / Nested IF / IFS
Text Functions.....
Math & Trig Functions ......
Other Functions ....

๐ŸŸฃ Level 3 โ€“ Data Preparation
Table
Sort Filter
Filter + Check Box
Filter+ Macro
Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Excel File แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Update แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€Šแ€บแ€ธ
Macro แ€กแ€แ€ผแ€ฑแ€แ€ถแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Excel แ€–แ€ผแ€„แ€ทแ€บ Data Analysis
Macro แ€€แ€ญแ€ฏ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ Data Analysis
Macro & Filter Function
Macro & Advanced Filter
Data แ€™แ€ปแ€ฌแ€ธ แ€…แ€€แ€นแ€€แ€”แ€ทแ€บแ€•แ€ญแ€ฏแ€„แ€บแ€ธแ€กแ€แ€ฝแ€„แ€บแ€ธ Pro แ€€แ€ปแ€€แ€ป แ€…แ€…แ€บแ€‘แ€ฏแ€”แ€Šแ€บแ€ธ

๐ŸŸก Level 4 โ€“ Data Analysis & Reporting
Advanced Charts

Function แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€แ€ฝแ€ฒแ€–แ€€แ€บแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€•แ€ผแ€ฎแ€ธ
แ€œแ€กแ€œแ€ญแ€ฏแ€€แ€บแŠแ€”แ€ฑแ€ทแ€กแ€œแ€ญแ€ฏแ€€แ€บ แ€แ€„แ€บแ€„แ€ฝแ€ฑแŠแ€‘แ€ฝแ€€แ€บโ€Œแ€„แ€ฝแ€ฑแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€™แ€ปแ€ฌแ€ธ
Pro แ€†แ€”แ€บแ€†แ€”แ€บ Chart แ€™แ€ปแ€ฌแ€ธแ€–แ€ผแ€„แ€ทแ€บแ€•แ€ผแ€”แ€Šแ€บแ€ธ
Stock In/Stock Out Magement
Basic & Advanced Pivot Table
Power Pivot (Relationship)
Professional Report แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ
Attendance แ€…แ€ฌแ€›แ€„แ€บแ€ธ แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
Classic Pivot Table
Professional Dashboard แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ

Weekend Class
๐Ÿ“…Start Date - 22/8/2026
โฐTime - 11 AM to 1 PM
๐Ÿ“…Total - 10 Weeks (20 Sessions)
๐Ÿ“…Day - Saturday, Sunday

๐Ÿ’ธFees - 190,000 KS


20/08/2026

SEP 22 แ€กแ€แ€ฝแ€€แ€บแ€กแ€แ€”แ€บแ€ธLink แ€œแ€ฑแ€ธแ€žแ€„แ€บแ€แ€”แ€บแ€ธแ€กแ€•แ€บแ€‘แ€ฌแ€ธแ€•แ€ผแ€ฎแ€ธแ€™แ€›แ€žแ€ฑแ€ธแ€›แ€„แ€บ แ€œแ€ฌแ€šแ€ฐแ€•แ€ซแ€”แ€ฑแ€ฌแ€บ๐Ÿฅณ

#

20/08/2026

*แ€’แ€ฎแ€œแ€™แ€พแ€ฌแ€แ€€แ€บแ€œแ€ญแ€ฏแ€ทแ€›แ€แ€ฒแ€ทแ€”แ€ฑแ€ฌแ€€แ€บแ€†แ€ฏแ€ถแ€ธแ€กแ€แ€”แ€บแ€ธแ€œแ€ฑแ€ธ

๐Ÿ“Š ๐„๐ฑ๐œ๐ž๐ฅ ๐…๐จ๐ซ ๐ƒ๐š๐ญ๐š ๐€๐ง๐š๐ฅ๐ฒ๐ฌ๐ข๐ฌ
Zoom Live Group Class

๐Ÿ“ˆ Data แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€•แ€ผแ€ฎแ€ธ Report แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Professional แ€กแ€†แ€„แ€ทแ€บแ€–แ€ผแ€„แ€ทแ€บ แ€–แ€”แ€บแ€แ€ฎแ€ธแ€แ€แ€บแ€แ€ปแ€„แ€บแ€•แ€ซแ€žแ€œแ€ฌแ€ธ?

Teach Reality แ Excel for Data Analysis Zoom Live Group Class แ€แ€ฝแ€„แ€บ Excel Foundation แ€™แ€พ Data AnalysisแŠ Pivot TableแŠ Power Query แ€”แ€พแ€„แ€ทแ€บ Professional Dashboard แ€กแ€‘แ€ญ แ€œแ€€แ€บแ€แ€ฝแ€ฑแ€ทแ€กแ€žแ€ฏแ€ถแ€ธแ€แ€ปแ€”แ€ญแ€ฏแ€„แ€บแ€žแ€ฑแ€ฌ Skill แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Step by Step แ€žแ€„แ€บแ€€แ€ผแ€ฌแ€ธแ€•แ€ฑแ€ธแ€žแ€ฝแ€ฌแ€ธแ€™แ€Šแ€บ แ€–แ€ผแ€…แ€บแ€•แ€ซแ€žแ€Šแ€บแ‹

๐Ÿ“ƒ Certificate แ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹
๐ŸŽฅ Telegram แ€™แ€พ Recording Video แ€™แ€ปแ€ฌแ€ธแ€•แ€ผแ€”แ€บแ€•แ€ญแ€ฏแ€ทแ€•แ€ฑแ€ธแ€•แ€ซแ€แ€šแ€บแ‹

๐Ÿ“š Course Outline
๐ŸŸข Level 1 โ€“ Excel Foundation

Excel Workbook แ€€แ€ญแ€ฏ แ€…แ€”แ€…แ€บแ€แ€€แ€ป แ€žแ€ญแ€™แ€บแ€ธแ€†แ€Šแ€บแ€ธแ€”แ€Šแ€บแ€ธ
Quick Access Toolbar & Ribbon แ€€แ€ญแ€ฏ แ€•แ€ผแ€„แ€บแ€†แ€„แ€บแ€”แ€Šแ€บแ€ธ
Excel Settings
Home Tab แ€€แ€ญแ€ฏ แ€‘แ€ญแ€›แ€ฑแ€ฌแ€€แ€บแ€…แ€ฝแ€ฌ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Data Entry
Data Management
แƒ แ€œแ€…แ€ฌ แ€แ€„แ€บแ€„แ€ฝแ€ฑ แŠแ€กแ€žแ€ฏแ€ถแ€ธแ€…แ€›แ€ญแ€แ€บแ€แ€…แ€บแ€•แ€ผแ€ญแ€ฏแ€„แ€บแ€‘แ€ฒแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
แ†แ€œแ€…แ€ฌ แ€€แ€ฏแ€”แ€บแ€•แ€…แ€นแ€…แ€Šแ€บแ€ธ แ€กแ€แ€„แ€บแŠแ€กแ€‘แ€ฝแ€€แ€บแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€›แ€ฑแ€ธแ€†แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ

๐Ÿ”ต Level 2 โ€“ Excel Functions& Advanced Function

Basic Excel Functions
Advanced Excel Functions
SUMIF / SUMIFS
COUNTIF / COUNTIFS
AVERAGEIF / AVERAGEIFS
VLOOKUP / HLOOKUP / XLOOKUP
INDEX + MATCH
IF / Nested IF / IFS
Text Functions.....
Math & Trig Functions ......
Other Functions ....

๐ŸŸฃ Level 3 โ€“ Data Preparation
Table
Sort Filter
Filter + Check Box
Filter+ Macro
Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Data Cleaning
Power Query แ€–แ€ผแ€„แ€ทแ€บ Excel File แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ Update แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€Šแ€บแ€ธ
Macro แ€กแ€แ€ผแ€ฑแ€แ€ถแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€”แ€Šแ€บแ€ธ
Excel แ€–แ€ผแ€„แ€ทแ€บ Data Analysis
Macro แ€€แ€ญแ€ฏ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ Data Analysis
Macro & Filter Function
Macro & Advanced Filter
Data แ€™แ€ปแ€ฌแ€ธ แ€…แ€€แ€นแ€€แ€”แ€ทแ€บแ€•แ€ญแ€ฏแ€„แ€บแ€ธแ€กแ€แ€ฝแ€„แ€บแ€ธ Pro แ€€แ€ปแ€€แ€ป แ€…แ€…แ€บแ€‘แ€ฏแ€”แ€Šแ€บแ€ธ

๐ŸŸก Level 4 โ€“ Data Analysis & Reporting
Advanced Charts

Function แ€™แ€ปแ€ฌแ€ธแ€€แ€ญแ€ฏ แ€แ€ฝแ€ฒแ€–แ€€แ€บแ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€•แ€ผแ€ฎแ€ธ
แ€œแ€กแ€œแ€ญแ€ฏแ€€แ€บแŠแ€”แ€ฑแ€ทแ€กแ€œแ€ญแ€ฏแ€€แ€บ แ€แ€„แ€บแ€„แ€ฝแ€ฑแŠแ€‘แ€ฝแ€€แ€บโ€Œแ€„แ€ฝแ€ฑแ€…แ€ฌแ€›แ€„แ€บแ€ธแ€™แ€ปแ€ฌแ€ธ
Pro แ€†แ€”แ€บแ€†แ€”แ€บ Chart แ€™แ€ปแ€ฌแ€ธแ€–แ€ผแ€„แ€ทแ€บแ€•แ€ผแ€”แ€Šแ€บแ€ธ
Stock In/Stock Out Magement
Basic & Advanced Pivot Table
Power Pivot (Relationship)
Professional Report แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ
Attendance แ€…แ€ฌแ€›แ€„แ€บแ€ธ แ€…แ€ฎแ€™แ€ถแ€แ€”แ€ทแ€บแ€แ€ฝแ€ฒแ€”แ€Šแ€บแ€ธ
Classic Pivot Table
Professional Dashboard แ€–แ€”แ€บแ€แ€ฎแ€ธแ€”แ€Šแ€บแ€ธ

Weekend Class
Start Date - 22/8/2026
Time - 11 AM to 1 PM
Total - 10 Weeks (20 Sessions)
Day - Saturday, Sunday

Fees - 190,000 KS


20/08/2026

Admin position แ€กแ€แ€ฝแ€€แ€บ แ€žแ€ญแ€žแ€„แ€ทแ€บแ€แ€ฒแ€ท Excel Skills

โœ… แ. แ€กแ€แ€ผแ€ฑแ€แ€ถ Excel Skill

Data Entry โœ”๏ธ Keyboard shortcut แ€™แ€ปแ€ฌแ€ธ แ€กแ€žแ€ฏแ€ถแ€ธแ€•แ€ผแ€ฏแ€•แ€ผแ€ฎแ€ธ แ€กแ€œแ€ฝแ€šแ€บแ€แ€€แ€ฐ input แ€œแ€ฏแ€•แ€บแ€”แ€ญแ€ฏแ€„แ€บแ€›แ€™แ€šแ€บ

Formatting โœ”๏ธ Table format, Font, Color, Borders, Conditional Formatting

Sorting & Filtering โœ”๏ธ Data แ€€แ€ญแ€ฏ แ€œแ€ญแ€ฏแ€แ€ปแ€„แ€บแ€แ€ฒแ€ทแ€กแ€แ€ญแ€ฏแ€„แ€บแ€ธ แ€กแ€œแ€ฝแ€šแ€บแ€แ€€แ€ฐ แ€…แ€ฎแ€…แ€‰แ€บแ€”แ€ญแ€ฏแ€„แ€บแ€›แ€™แ€šแ€บ

---

โœ… แ‚. Formula & Functions (แ€žแ€ญแ€‘แ€ฌแ€ธแ€žแ€„แ€ทแ€บแ€แ€ฌแ€™แ€ปแ€ฌแ€ธ)

SUM, AVERAGE, MIN, MAX

COUNT, COUNTA, COUNTIF

IF, AND, OR (Logic functions)

VLOOKUP / XLOOKUP

TEXT functions (LEFT, RIGHT, MID, LEN, TRIM, CONCATENATE / TEXTJOIN)

DATE functions (TODAY, NOW, DATEDIF, EOMONTH)

---

โœ… แƒ. Report & Data Management

Data Validation (Dropdown list แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€ญแ€ฏแ€„แ€บแ€›แ€™แ€šแ€บ)

Pivot Table (Summary & Report แ€•แ€ผแ€ฏแ€œแ€ฏแ€•แ€บแ€”แ€ญแ€ฏแ€„แ€บแ€›แ€™แ€šแ€บ)

Charts (Column, Line, Pie โ€“ Report แ€แ€ฝแ€ฑแ€กแ€แ€ฝแ€€แ€บ แ€กแ€žแ€ฏแ€ถแ€ธแ€™แ€ปแ€ฌแ€ธ)

Page Setup (Printing A4, Landscape/Portrait, Fit to Page)

---

โœ… แ„. Admin แ€œแ€ญแ€ฏแ€กแ€•แ€บแ€แ€ปแ€€แ€บแ€†แ€ญแ€ฏแ€„แ€บแ€›แ€ฌ แ€กแ€žแ€ฏแ€ถแ€ธแ€แ€„แ€บแ€žแ€ฑแ€ฌ Excel แ€กแ€žแ€ฏแ€ถแ€ธแ€™แ€ปแ€ฌแ€ธ

Attendance Sheet โœ”๏ธ

Salary Calculation โœ”๏ธ

Petty Cash & Expense Record โœ”๏ธ

Stock / Inventory Record โœ”๏ธ

Contact List & Task List โœ”๏ธ

20/08/2026

๐Ÿ˜๐Ÿ˜๐Ÿ˜

Address

Minglar Taung Nyunt Township
Yangon
1111

Telephone

+959773486442

Website

Alerts

Be the first to know and let us send you an email when Teach Reality posts news and promotions. Your email address will not be used for any other purpose, and you can unsubscribe at any time.

Contact The School

Send a message to Teach Reality:

Shortcuts

Share

Category