Autoplay
Autocomplete
Previous Lesson
Complete and Continue
Excel ฉบับแจ้งเกิด
INTRODUCTION AND RESOURCES
00 Promo (9:16)
Resources
ก้าวแรกสู่สังเวียน
01 Open Excel (2:56)
02 Excel Interface (6:15)
03 Quick Menu (6:34)
04 WorkSheet and Cells (2:23)
05 Save (5:29)
06 Open (2:19)
07 Short Cut Keys (2:00)
08 Key Text (4:26)
09 Numeric (2:31)
10 Date (4:35)
11 Cellls Reference (6:18)
12 Formula (3:02)
13 Relative and Absolute Ref (7:18)
14 Cal Order (5:30)
15 Function Sum Min Max Count (6:29)
16 Ajacent Cells Error (2:21)
17 AutoSum (4:42)
18 Autosum Shortcut (3:45)
19 Cut Copy Paste Move Undo (7:39)
20 Insert Row Column and Auto Adjust Formula (4:32)
21 Wide High Cells (3:39)
22 Hide Unhide not show Heading (2:07)
23 Add Rename Move Copy Delete Worksheet (6:01)
24 Move Copy Create to another workbook (4:14)
25 Format Font BG and Border (5:02)
26 Percent (2:19)
27 Format Painter (2:36)
28 Merge Center (2:54)
29 Condition Format (4:00)
30 Image and Shape (7:24)
31 Smart Art (6:03)
32 Basic Chart (11:10)
33 Print Orient Margin Scale (3:53)
34 Pagelayout Header Footer Print Area (6:12)
35 Template (5:19)
ท่องยุทธภพ
36 Sort (10:38)
37 Filter (8:30)
38 SubTotal (5:32)
39 Table (10:27)
40 Condition Find Dup and Remove Dup (5:15)
41 DSum (10:16)
42 DAverage DCount DCountA which Date as number (7:34)
43 Function Subtotal (5:12)
44 Data Validation (10:07)
45 Import Export Text (10:30)
46 Import From Access (4:23)
47 Pivot (12:32)
48 Pivot2 (9:48)
49 Pivot3 (8:17)
50 Pivot4 (4:36)
51 PowerPivot (13:00)
52 Freeze Pane Group Print Title Print Direction (10:17)
53 Cal Across Sheet and Consolidate (7:45)
ยอดฝีมือ
54 Name Range (8:39)
55 If (10:17)
56 Nesting If And Min (9:23)
57 CountIf SumIf (4:58)
58 IfError (2:05)
59 VLookup (12:21)
60 HLookup (4:15)
61 IndexMatch (12:08)
62 Left Right Mid Search Len (13:05)
63 Concatenate (2:33)
64 Flash Fill (5:18)
65 Text To Column (5:04)
66 Auditing (9:31)
67 Protection (9:54)
68 Goalseek (10:29)
69 Solver (7:17)
70 DataTable (3:14)
71 Scenarios Manager (3:20)
72 Macro Basic (11:22)
73 Macro on Job (11:09)
ปรมาจารย์
74-0 Set Configure for VBA (3:06)
74 VBA (10:13)
75 VBA Coding (6:46)
76 VBA Variable (3:55)
77 VBA IF (3:32)
78 VBA Loop (8:13)
79 InputBox (9:45)
80 MsgBox (8:40)
81 Last Row (14:07)
82 Last Row XLup (8:06)
83 Console1 (13:22)
84 Console2 (12:35)
85 Sale Console with Adjustment (6:01)
86 Sale Console with Adjustment 1 (12:51)
87 Sale Console with Adjustment 2 (10:33)
88 Sale Console with Adjustment 3 (7:44)
89 Sale Console with Adjustment 4 (8:09)
90-1 Sale Console Correction (15:32)
92 Convert Rep to Data Dump (13:22)
93 Convert Rep to Data Dump (8:39)
94 Convert Rep to Data Dump (14:20)
95 Filter Contain (9:32)
96 Double Click Set Value (10:12)
97 Double Click Set Value (8:32)
98 Double Click Set Value (7:23)
99 Invoice Intro (5:22)
100 Invoice 1 (9:35)
101 Invoice 2 (5:49)
102 Invoice 3 (7:33)
103 Invoice 4 (9:53)
104 Invoice 5 (14:44)
105 Invoice 6 (8:55)
105-1 Invoice 6 (6:42)
สูงสุดสู่สามัญ
106 Normal (11:15)
107 Normal 1 (7:36)
108 Normal 2 (11:02)
109 Normal 3 (4:56)
110 Normal Sample (7:29)
จักรวาลไร้ขอบเขต
111 Add New Invoice (5:34)
112 Add New Invoice1 (7:25)
113 Add New Invoice2 (11:15)
114 EditInvoice (9:11)
115 EditInvoice1 (7:36)
116 DoubleClickProdForInv (12:02)
117 Quotation (7:06)
118 Quotation Add New (7:34)
119 Quotation Edit (6:56)
120 PurchaseOrder (5:33)
121 PurchaseOrder1 (10:20)
122 PurchaseOrder2 (12:03)
123 PurchaseOrder3 (10:25)
124 Menu Smart Art (6:09)
125 MoveColumn (1:29)
126 Pivot with 2 Col on same row (2:10)
127 Error On Data Imported (3:44)
128 RANDBETWEEN (2:35)
129 RANDBETWEEN for Date (1:59)
130 Date Filter (4:47)
131 Date Filter By DoubleClick (7:14)
132 Extract and Convert Date (14:49)
133 Run Month End Date (2:23)
134 Bar Chart vs Line Chart (6:45)
135 Transform Query แปลงข้อมูลจากแนวนอนเป็นแนวตั้ง (6:52)
136 Due Date Control (15:12)
Teach online with
13 Relative and Absolute Ref
Download
Download
Relative and Absolute.xlsx
Complete and Continue