This course was created with the
course builder. Create your online course today.
Start now
Create your course
with
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)
52 Freeze Pane Group Print Title Print Direction
Lesson content locked
If you're already enrolled,
you'll need to login
.
Enroll in Course to Unlock