INTRODUCTION AND 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)
สูงสุดสู่สามัญ
จักรวาลไร้ขอบเขต
-
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)
