{"id":18307,"date":"2026-04-20T15:53:37","date_gmt":"2026-04-20T08:53:37","guid":{"rendered":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/?p=18307"},"modified":"2026-07-16T13:41:20","modified_gmt":"2026-07-16T06:41:20","slug":"cach-tao-bang-trong-excel","status":"publish","type":"post","link":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/goc-ky-nang\/cach-tao-bang-trong-excel","title":{"rendered":"C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel: H\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc, format \u0111\u1eb9p v\u00e0 m\u1eb9o n\u00e2ng cao"},"content":{"rendered":"

T\u1ea1o b\u1ea3ng (Table) trong Excel l\u00e0 k\u1ef9 n\u0103ng c\u01a1 b\u1ea3n nh\u01b0ng c\u1ef1c k\u1ef3 h\u1eefu \u00edch \u2013 gi\u00fap d\u1eef li\u1ec7u t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng, t\u00ednh t\u1ed5ng nhanh, l\u1ecdc linh ho\u1ea1t v\u00e0 format \u0111\u1eb9p m\u00e0 kh\u00f4ng c\u1ea7n ch\u1ec9nh tay t\u1eebng \u00f4. Nhi\u1ec1u nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng v\u1eabn ch\u1ec9 nh\u1eadp d\u1eef li\u1ec7u v\u00e0o \u00f4 b\u00ecnh th\u01b0\u1eddng m\u00e0 kh\u00f4ng bi\u1ebft t\u00ednh n\u0103ng Table<\/strong> (Insert \u2192 Table) m\u1ea1nh m\u1ebd h\u01a1n r\u1ea5t nhi\u1ec1u. B\u00e0i vi\u1ebft h\u01b0\u1edbng d\u1eabn t\u1eebng b\u01b0\u1edbc t\u1ea1o b\u1ea3ng, format v\u00e0 c\u00e1c m\u1eb9o n\u00e2ng cao.<\/p>\n\n\n\n

\"\"<\/figure>\n\n\n\n
\n

T\u1ed5ng quan nhanh v\u1ec1 Table trong Excel<\/strong><\/p>\n

\u2013 T\u1ea1o nhanh: ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u \u2192 Ctrl+T ho\u1eb7c Insert \u2192 Table.<\/p>\n

\u2013 \u01afu \u0111i\u1ec3m: t\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng khi th\u00eam d\u00f2ng, ti\u00eau \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n, AutoFilter s\u1eb5n, Structured References.<\/p>\n

\u2013 \u00c1p d\u1ee5ng: m\u1ecdi phi\u00ean b\u1ea3n Excel 2010, 2013, 2016, 2019, 2021, Microsoft 365.<\/p>\n

\u2013 Kh\u00e1c “v\u1ebd \u0111\u01b0\u1eddng k\u1ebb”: Table l\u00e0 object c\u00f3 t\u00ean, c\u00f4ng th\u1ee9c tham chi\u1ebfu theo c\u1ed9t, t\u1ef1 \u0111\u1ed9ng t\u1ed5ng\/\u0111\u1ebfm.<\/p>\n<\/div>\n\n\n

1. C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel \u2013 t\u1eebng b\u01b0\u1edbc<\/h2>\n

B\u01b0\u1edbc 1: Chu\u1ea9n b\u1ecb d\u1eef li\u1ec7u<\/h3>\n

Nh\u1eadp d\u1eef li\u1ec7u theo d\u1ea1ng b\u1ea3ng: h\u00e0ng 1 l\u00e0 ti\u00eau \u0111\u1ec1 c\u1ed9t, c\u00e1c h\u00e0ng ti\u1ebfp theo l\u00e0 d\u1eef li\u1ec7u. M\u1ed7i c\u1ed9t n\u00ean c\u00f3 1 lo\u1ea1i d\u1eef li\u1ec7u (s\u1ed1\/text\/ng\u00e0y). Kh\u00f4ng \u0111\u1ec3 h\u00e0ng tr\u1ed1ng gi\u1eefa d\u1eef li\u1ec7u \u2013 Excel s\u1ebd nh\u1eadn nh\u1ea7m v\u00f9ng.<\/p>\n

B\u01b0\u1edbc 2: Ch\u1ecdn v\u00f9ng v\u00e0 t\u1ea1o Table<\/h3>\n

\u2013 Click v\u00e0o b\u1ea5t k\u1ef3 \u00f4 n\u00e0o trong v\u00f9ng d\u1eef li\u1ec7u.<\/p>\n

\u2013 Nh\u1ea5n Ctrl+T<\/strong> (ho\u1eb7c v\u00e0o Insert \u2192 Table).<\/p>\n

\u2013 H\u1ed9p tho\u1ea1i “Create Table” hi\u1ec7n ra, t\u1ef1 detect v\u00f9ng d\u1eef li\u1ec7u. Tick “My table has headers” n\u1ebfu h\u00e0ng \u0111\u1ea7u l\u00e0 ti\u00eau \u0111\u1ec1.<\/p>\n

\u2013 Nh\u1ea5n OK \u2192 b\u1ea3ng \u0111\u01b0\u1ee3c t\u1ea1o v\u1edbi format zebra t\u1ef1 \u0111\u1ed9ng.<\/p>\n

B\u01b0\u1edbc 3: \u0110\u1eb7t t\u00ean b\u1ea3ng<\/h3>\n

Sau khi t\u1ea1o, click v\u00e0o b\u1ea3ng \u2192 tab Table Design xu\u1ea5t hi\u1ec7n \u2192 \u00f4 “Table Name” (g\u00f3c tr\u00e1i) \u2192 nh\u1eadp t\u00ean c\u00f3 \u00fd ngh\u0129a (v\u00ed d\u1ee5: “BangLuong”, “DanhSachNV”). T\u00ean b\u1ea3ng gi\u00fap tham chi\u1ebfu trong c\u00f4ng th\u1ee9c v\u00e0 PivotTable d\u1ec5 h\u01a1n.<\/p>\n

\n

“Ctrl+T l\u00e0 ph\u00edm t\u1eaft b\u1ecb underrated nh\u1ea5t trong Excel. Ch\u1ec9 2 gi\u00e2y b\u1ea1n bi\u1ebfn d\u1eef li\u1ec7u th\u00f4 th\u00e0nh b\u1ea3ng chuy\u00ean nghi\u1ec7p v\u1edbi AutoFilter, zebra striping v\u00e0 Structured References.” \u2013 Chia s\u1ebb ph\u1ed5 bi\u1ebfn trong c\u1ed9ng \u0111\u1ed3ng Excel Vi\u1ec7t Nam.<\/p>\n<\/blockquote>\n

2. T\u00ednh n\u0103ng n\u1ed5i b\u1eadt c\u1ee7a Table trong Excel<\/h2>\n\n\n\n\n\n\n\n\n\n\n\n
T\u00ednh n\u0103ng<\/th>\nM\u00f4 t\u1ea3<\/th>\nL\u1ee3i \u00edch th\u1ef1c t\u1ebf<\/th>\n<\/tr>\n<\/thead>\n
T\u1ef1 \u0111\u1ed9ng m\u1edf r\u1ed9ng<\/td>\nTh\u00eam d\u00f2ng m\u1edbi \u1edf cu\u1ed1i \u2192 Table t\u1ef1 bao g\u1ed3m, format + c\u00f4ng th\u1ee9c t\u1ef1 copy<\/td>\nKh\u00f4ng c\u1ea7n k\u00e9o c\u00f4ng th\u1ee9c th\u1ee7 c\u00f4ng khi th\u00eam data<\/td>\n<\/tr>\n
AutoFilter s\u1eb5n<\/td>\nM\u1ed7i c\u1ed9t c\u00f3 dropdown filter ngay ti\u00eau \u0111\u1ec1<\/td>\nL\u1ecdc nhanh kh\u00f4ng c\u1ea7n b\u1eadt Data \u2192 Filter ri\u00eang<\/td>\n<\/tr>\n
Ti\u00eau \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh<\/td>\nCu\u1ed9n d\u1ecdc \u2192 ti\u00eau \u0111\u1ec1 c\u1ed9t thay th\u1ebf ch\u1eef c\u00e1i A\/B\/C<\/td>\nKh\u00f4ng c\u1ea7n Freeze Panes cho h\u00e0ng ti\u00eau \u0111\u1ec1<\/td>\n<\/tr>\n
Structured References<\/td>\nC\u00f4ng th\u1ee9c d\u00f9ng t\u00ean c\u1ed9t thay v\u00ec \u0111\u1ecba ch\u1ec9 \u00f4: =SUM(BangLuong[LuongGross])<\/td>\nC\u00f4ng th\u1ee9c d\u1ec5 \u0111\u1ecdc, \u00edt l\u1ed7i khi th\u00eam\/x\u00f3a c\u1ed9t<\/td>\n<\/tr>\n
Total Row<\/td>\nTable Design \u2192 tick “Total Row” \u2192 d\u00f2ng t\u1ed5ng t\u1ef1 \u0111\u1ed9ng (SUM, AVERAGE, COUNT…)<\/td>\nT\u00ednh t\u1ed5ng\/trung b\u00ecnh nhanh kh\u00f4ng c\u1ea7n vi\u1ebft c\u00f4ng th\u1ee9c<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n\n\n

3. Format b\u1ea3ng \u0111\u1eb9p chuy\u00ean nghi\u1ec7p<\/h2>\n

Ch\u1ecdn Table Style<\/h3>\n

Click v\u00e0o b\u1ea3ng \u2192 tab Table Design \u2192 gallery Table Styles \u2192 ch\u1ecdn ki\u1ec3u ph\u00f9 h\u1ee3p. Excel c\u00f3 s\u1eb5n ~60 style chia 3 nh\u00f3m: Light, Medium, Dark. Khuy\u1ebfn ngh\u1ecb:<\/p>\n

\u2013 B\u00e1o c\u00e1o n\u1ed9i b\u1ed9:<\/strong> Light Blue ho\u1eb7c Medium Blue \u2013 chuy\u00ean nghi\u1ec7p, d\u1ec5 \u0111\u1ecdc.<\/p>\n

\u2013 Dashboard:<\/strong> Dark style \u2013 n\u1ed5i b\u1eadt tr\u00ean n\u1ec1n t\u1ed1i.<\/p>\n

\u2013 In \u1ea5n:<\/strong> Light style \u2013 ti\u1ebft ki\u1ec7m m\u1ef1c, r\u00f5 n\u00e9t tr\u00ean gi\u1ea5y tr\u1eafng.<\/p>\n

T\u00f9y ch\u1ec9nh th\u00eam<\/h3>\n

\u2013 Banded Rows\/Columns:<\/strong> tick trong Table Design \u0111\u1ec3 b\u1eadt\/t\u1eaft zebra striping.<\/p>\n

\u2013 First\/Last Column:<\/strong> bold c\u1ed9t \u0111\u1ea7u\/cu\u1ed1i \u0111\u1ec3 nh\u1ea5n m\u1ea1nh.<\/p>\n

\u2013 Header Row:<\/strong> lu\u00f4n gi\u1eef tick \u0111\u1ec3 ti\u00eau \u0111\u1ec1 hi\u1ec3n th\u1ecb.<\/p>\n

T\u1ea1o style ri\u00eang<\/h3>\n

Table Design \u2192 New Table Style \u2192 t\u00f9y ch\u1ec9nh m\u00e0u header, zebra, border \u2192 Save. D\u00f9ng khi doanh nghi\u1ec7p c\u00f3 brand color c\u1ea7n nh\u1ea5t qu\u00e1n trong m\u1ecdi b\u00e1o c\u00e1o.<\/p>\n\n\n

\n

L\u01b0u \u00fd khi d\u00f9ng Table<\/strong><\/p>\n

\u2013 Table kh\u00f4ng h\u1ed7 tr\u1ee3 merge cell (g\u1ed9p \u00f4) \u2013 n\u1ebfu c\u1ea7n merge, ph\u1ea3i Convert to Range tr\u01b0\u1edbc.<\/p>\n

\u2013 M\u1ed9t s\u1ed1 h\u00e0m c\u0169 (INDIRECT, OFFSET) ho\u1ea1t \u0111\u1ed9ng kh\u00e1c khi tham chi\u1ebfu Table \u2013 n\u00ean d\u00f9ng Structured References.<\/p>\n

\u2013 File c\u00f3 nhi\u1ec1u Table l\u1edbn c\u00f3 th\u1ec3 ch\u1eadm \u2013 n\u1ebfu data tr\u00ean 500.000 d\u00f2ng, c\u00e2n nh\u1eafc Power Query\/Power Pivot.<\/p>\n<\/div>\n\n\n

4. M\u1eb9o n\u00e2ng cao v\u1edbi Table<\/h2>\n

S\u1eed d\u1ee5ng Slicer \u0111\u1ec3 l\u1ecdc tr\u1ef1c quan<\/h3>\n

Click v\u00e0o Table \u2192 Table Design \u2192 Insert Slicer \u2192 ch\u1ecdn c\u1ed9t c\u1ea7n l\u1ecdc \u2192 OK. Slicer t\u1ea1o c\u00e1c n\u00fat b\u1ea5m tr\u1ef1c quan (gi\u1ed1ng dashboard) \u0111\u1ec3 l\u1ecdc nhanh \u2013 r\u1ea5t h\u1eefu \u00edch khi tr\u00ecnh b\u00e0y tr\u00ean m\u00e1y chi\u1ebfu ho\u1eb7c chia s\u1ebb file cho ng\u01b0\u1eddi kh\u00f4ng quen d\u00f9ng Filter.<\/p>\n

K\u1ebft n\u1ed1i Table v\u1edbi PivotTable<\/h3>\n

Click v\u00e0o Table \u2192 Insert \u2192 PivotTable \u2192 ch\u1ecdn “From Table\/Range”. V\u00ec Table t\u1ef1 m\u1edf r\u1ed9ng, PivotTable c\u0169ng t\u1ef1 c\u1eadp nh\u1eadt khi th\u00eam data m\u1edbi \u2013 ch\u1ec9 c\u1ea7n Refresh. \u0110\u00e2y l\u00e0 c\u00e1ch t\u1ed1t nh\u1ea5t \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt.<\/p>\n

C\u00f4ng th\u1ee9c Structured References<\/h3>\n

Thay v\u00ec `=SUM(C2:C100)`, trong Table b\u1ea1n vi\u1ebft `=SUM(BangLuong[LuongGross])` \u2013 Excel t\u1ef1 hi\u1ec3u l\u1ea5y to\u00e0n b\u1ed9 c\u1ed9t LuongGross trong b\u1ea3ng BangLuong. Khi th\u00eam d\u00f2ng m\u1edbi, c\u00f4ng th\u1ee9c t\u1ef1 bao g\u1ed3m d\u00f2ng \u0111\u00f3. \u0110\u00e2y l\u00e0 \u01b0u \u0111i\u1ec3m l\u1edbn nh\u1ea5t c\u1ee7a Table so v\u1edbi range th\u00f4ng th\u01b0\u1eddng.<\/p>\n

Convert Table v\u1ec1 Range<\/h3>\n

N\u1ebfu c\u1ea7n merge cell ho\u1eb7c kh\u00f4ng mu\u1ed1n d\u00f9ng Table n\u1eefa: click v\u00e0o Table \u2192 Table Design \u2192 Convert to Range. Data v\u00e0 format gi\u1eef nguy\u00ean, ch\u1ec9 m\u1ea5t t\u00ednh n\u0103ng Table (AutoFilter, auto-expand, Structured References).<\/p>\n

N\u1ebfu mu\u1ed1n luy\u1ec7n th\u00eam k\u1ef9 n\u0103ng Excel, tham kh\u1ea3o b\u00e0i c\u00e1c h\u00e0m trong Excel th\u00f4ng d\u1ee5ng d\u00e0nh cho nh\u00e2n vi\u00ean v\u0103n ph\u00f2ng<\/a>. T\u00ecm vi\u1ec7c y\u00eau c\u1ea7u Excel t\u1ea1i vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \u2013 ki\u1ec3m to\u00e1n<\/a>.<\/p>\n\n\n

\n

L\u1eddi khuy\u00ean s\u1eed d\u1ee5ng Table hi\u1ec7u qu\u1ea3<\/strong><\/p>\n

\u2013 Bi\u1ebfn M\u1eccI b\u1ea3ng d\u1eef li\u1ec7u th\u00e0nh Table (Ctrl+T) ngay khi b\u1eaft \u0111\u1ea7u \u2013 ti\u1ebft ki\u1ec7m nhi\u1ec1u thao t\u00e1c sau n\u00e0y.<\/p>\n

\u2013 \u0110\u1eb7t t\u00ean b\u1ea3ng r\u00f5 r\u00e0ng (BangLuong, DanhSachKH) thay v\u00ec \u0111\u1ec3 m\u1eb7c \u0111\u1ecbnh Table1, Table2.<\/p>\n

\u2013 D\u00f9ng Total Row thay v\u00ec vi\u1ebft SUM th\u1ee7 c\u00f4ng \u1edf d\u00f2ng cu\u1ed1i \u2013 g\u1ecdn v\u00e0 t\u1ef1 c\u1eadp nh\u1eadt.<\/p>\n

\u2013 K\u1ebft n\u1ed1i Table v\u1edbi PivotTable \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o t\u1ef1 \u0111\u1ed9ng \u2013 k\u1ef9 n\u0103ng n\u00e0y \u0111\u01b0\u1ee3c nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111\u00e1nh gi\u00e1 r\u1ea5t cao.<\/p>\n<\/div>\n\n\n\n

T\u1ea1o b\u1ea3ng chuy\u00ean nghi\u1ec7p cho t\u1eebng m\u1ee5c \u0111\u00edch c\u1ee5 th\u1ec3<\/h3>\n\n\n\n

M\u1ed7i lo\u1ea1i b\u1ea3ng c\u00f3 c\u00e1ch thi\u1ebft k\u1ebf t\u1ed1i \u01b0u kh\u00e1c nhau. B\u1ea3ng l\u01b0\u01a1ng n\u00ean c\u00f3 c\u1ed9t STT + H\u1ecd t\u00ean c\u1ed1 \u0111\u1ecbnh (Freeze), c\u00e1c c\u1ed9t s\u1ed1 ti\u1ec1n format Accounting, d\u00f2ng Total Row t\u00ednh SUM t\u1ef1 \u0111\u1ed9ng, style Medium Blue cho formal.<\/p>\n\n\n\n

B\u1ea3ng ch\u1ea5m c\u00f4ng n\u00ean c\u00f3 31 c\u1ed9t ng\u00e0y, Conditional Formatting t\u00f4 xanh\/\u0111\u1ecf\/v\u00e0ng cho \u0111i\/ngh\u1ec9\/tr\u1ec5, header c\u1ed1 \u0111\u1ecbnh, filter theo ph\u00f2ng ban. B\u1ea3ng t\u1ed3n kho n\u00ean d\u00f9ng ph\u00e2n v\u00f9ng ABC (A = h\u00e0ng nhanh, B = trung b\u00ecnh, C = ch\u1eadm), Total Row \u0111\u1ebfm COUNT + t\u1ed5ng VALUE, Slicer l\u1ecdc theo kho v\u00e0 nh\u00f3m h\u00e0ng.<\/p>\n\n\n\n

B\u1ea3ng KPI n\u00ean c\u00f3 c\u1ed9t Target vs Actual, Conditional Formatting so s\u00e1nh b\u1eb1ng Data Bars ho\u1eb7c Icon Sets (m\u0169i t\u00ean xanh\/\u0111\u1ecf), \u0111\u00ednh k\u00e8m Sparkline chart mini trong \u00f4 cu\u1ed1i c\u00f9ng.<\/p>\n\n\n\n

X\u1eed l\u00fd l\u1ed7i th\u01b0\u1eddng g\u1eb7p khi d\u00f9ng Table<\/h3>\n\n\n\n

L\u1ed7i 1: “Cannot shift objects” khi th\u00eam d\u00f2ng m\u1edbi v\u00e0o Table \u2013 nguy\u00ean nh\u00e2n: c\u00f3 comment ho\u1eb7c shape ch\u1ed3ng l\u00ean v\u00f9ng Table, ho\u1eb7c c\u1ed9t b\u00ean c\u1ea1nh c\u00f3 data. Gi\u1ea3i ph\u00e1p: x\u00f3a comment\/shape th\u1eeba, ho\u1eb7c m\u1edf r\u1ed9ng v\u00f9ng tr\u1ed1ng b\u00ean ph\u1ea3i\/d\u01b0\u1edbi Table.<\/p>\n\n\n\n

L\u1ed7i 2: c\u00f4ng th\u1ee9c sai khi copy paste d\u1eef li\u1ec7u t\u1eeb ngo\u00e0i v\u00e0o Table \u2013 nguy\u00ean nh\u00e2n: Structured References t\u1ef1 thay \u0111\u1ed5i. Gi\u1ea3i ph\u00e1p: paste b\u1eb1ng Ctrl+Shift+V (Paste Special \u2192 Values) thay v\u00ec Ctrl+V. L\u1ed7i 3: Table b\u1ecb “v\u1ee1” khi m\u1edf tr\u00ean m\u00e1y kh\u00e1c \u2013 nguy\u00ean nh\u00e2n: phi\u00ean b\u1ea3n Excel kh\u00e1c nhau ho\u1eb7c file b\u1ecb corrupt.<\/p>\n\n\n\n

Gi\u1ea3i ph\u00e1p: save file \u1edf format .xlsx (kh\u00f4ng d\u00f9ng .xls), v\u00e0 ki\u1ec3m tra Compatibility Mode. L\u1ed7i 4: AutoFilter m\u1ea5t sau khi unprotect sheet \u2013 c\u1ea7n re-apply Data \u2192 Filter ho\u1eb7c click v\u00e0o Table \u2192 Table Design \u0111\u1ec3 k\u00edch ho\u1ea1t l\u1ea1i.<\/p>\n\n\n\n

K\u1ebft h\u1ee3p Table v\u1edbi Power Query cho data l\u1edbn<\/h3>\n\n\n\n

Khi d\u1eef li\u1ec7u v\u01b0\u1ee3t 100.000 d\u00f2ng ho\u1eb7c c\u1ea7n k\u1ebft h\u1ee3p nhi\u1ec1u ngu\u1ed3n (CSV, database, API), Power Query l\u00e0 b\u01b0\u1edbc ti\u1ebfn t\u1ef1 nhi\u00ean t\u1eeb Table. C\u00e1ch k\u1ebft n\u1ed1i: Data \u2192 Get Data \u2192 From Table\/Range \u2192 Power Query Editor m\u1edf ra. T\u1ea1i \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 l\u1ecdc, merge, pivot, unpivot d\u1eef li\u1ec7u r\u1ed3i Load v\u1ec1 sheet m\u1edbi d\u01b0\u1edbi d\u1ea1ng Table.<\/p>\n\n\n\n

\u01afu \u0111i\u1ec3m: d\u1eef li\u1ec7u g\u1ed1c kh\u00f4ng b\u1ecb thay \u0111\u1ed5i, quy tr\u00ecnh transform c\u00f3 th\u1ec3 Refresh t\u1ef1 \u0111\u1ed9ng khi data ngu\u1ed3n c\u1eadp nh\u1eadt. \u0110\u00e2y l\u00e0 k\u1ef9 n\u0103ng n\u00e2ng cao m\u00e0 nh\u00e0 tuy\u1ec3n d\u1ee5ng \u0111\u00e1nh gi\u00e1 r\u1ea5t cao cho c\u00e1c v\u1ecb tr\u00ed data analyst, k\u1ebf to\u00e1n qu\u1ea3n tr\u1ecb, v\u00e0 business intelligence.<\/p>\n\n\n\n

So s\u00e1nh Table trong Excel v\u1edbi Google Sheets v\u00e0 Notion<\/h3>\n\n\n\n

Google Sheets kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng Table ch\u00ednh th\u1ee9c nh\u01b0 Excel, nh\u01b0ng c\u00f3 t\u00ednh n\u0103ng g\u1ea7n t\u01b0\u01a1ng \u0111\u01b0\u01a1ng: Named Range + Filter Views + ARRAYFORMULA.<\/p>\n\n\n\n

Khi t\u1ea1o Table trong Excel r\u1ed3i upload l\u00ean Google Drive, Table t\u1ef1 chuy\u1ec3n th\u00e0nh Named Range \u2013 m\u1ea5t m\u1ed9t s\u1ed1 t\u00ednh n\u0103ng (Structured References, Total Row) nh\u01b0ng gi\u1eef \u0111\u01b0\u1ee3c AutoFilter v\u00e0 format.<\/p>\n\n\n\n

Notion Database c\u0169ng l\u00e0 m\u1ed9t d\u1ea1ng “Table” nh\u01b0ng thi\u00ean v\u1ec1 qu\u1ea3n l\u00fd d\u1ef1 \u00e1n h\u01a1n ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u2013 ph\u00f9 h\u1ee3p cho task tracking nh\u01b0ng kh\u00f4ng thay th\u1ebf Excel cho t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p.<\/p>\n\n\n\n

Airtable l\u00e0 hybrid gi\u1eefa spreadsheet v\u00e0 database \u2013 c\u00f3 t\u00ednh n\u0103ng Table t\u01b0\u01a1ng t\u1ef1 Excel nh\u01b0ng th\u00eam Kanban view, Calendar view, ph\u00f9 h\u1ee3p cho team collaboration. N\u1ebfu b\u1ea1n l\u00e0m vi\u1ec7c \u0111a n\u1ec1n t\u1ea3ng, h\u00e3y th\u00e0nh th\u1ea1o Table trong Excel tr\u01b0\u1edbc r\u1ed3i m\u1edf r\u1ed9ng sang c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c \u2013 logic c\u01a1 b\u1ea3n l\u00e0 gi\u1ed1ng nhau.<\/p>\n\n\n\n

5. Th\u1ecb tr\u01b0\u1eddng tuy\u1ec3n d\u1ee5ng th\u01b0 k\u00fd \/ h\u00e0nh ch\u00ednh (c\u1ea7n Excel) tr\u00ean CareerLink (Th\u00e1ng 5\/2026)<\/h2>\n\n

Theo d\u1eef li\u1ec7u c\u1eadp nh\u1eadt tr\u00ean CareerLink th\u00e1ng 5\/2026, m\u1ea3ng Th\u01b0 k\u00fd \/ H\u00e0nh ch\u00ednh<\/strong> hi\u1ec7n c\u00f3 kho\u1ea3ng 554 tin tuy\u1ec3n d\u1ee5ng<\/strong> \u0111ang m\u1edf. H\u1ea7u h\u1ebft JD \u0111\u1ec1u y\u00eau c\u1ea7u \u1ee9ng vi\u00ean th\u00e0nh th\u1ea1o Microsoft Excel \u1edf m\u1ee9c trung b\u00ecnh \u2013 kh\u00e1, \u0111\u1eb7c bi\u1ec7t thao t\u00e1c t\u1ea1o b\u1ea3ng, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n, PivotTable v\u00e0 c\u00e1c h\u00e0m t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u c\u01a1 b\u1ea3n.<\/p>\n\n\n

\n

T\u1ed5ng quan d\u1eef li\u1ec7u tuy\u1ec3n d\u1ee5ng th\u01b0 k\u00fd \/ h\u00e0nh ch\u00ednh (CareerLink, T5\/2026)<\/strong><\/p>\n

\u2013 T\u1ed5ng tin tuy\u1ec3n: 554 tin \u0111ang m\u1edf (to\u00e0n ng\u00e0nh).<\/p>\n

\u2013 M\u1ee9c l\u01b0\u01a1ng Th\u01b0 k\u00fd \/ H\u00e0nh ch\u00ednh (1\u20133 n\u0103m): 8\u201314 tri\u1ec7u\/th\u00e1ng.<\/p>\n

\u2013 M\u1ee9c l\u01b0\u01a1ng Tr\u1ee3 l\u00fd \u0111i\u1ec1u h\u00e0nh \/ Office Manager: 18\u201335 tri\u1ec7u\/th\u00e1ng.<\/p>\n

\u2013 Khu v\u1ef1c tuy\u1ec3n nhi\u1ec1u: TP.HCM, H\u00e0 N\u1ed9i, \u0110\u00e0 N\u1eb5ng, H\u1ea3i Ph\u00f2ng, \u0110\u1ed3ng Nai.<\/p>\n<\/div>\n\n\n

Kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng Excel th\u00e0nh th\u1ea1o (bao g\u1ed3m t\u1ea1o b\u1ea3ng, conditional formatting, PivotTable, VLOOKUP\/XLOOKUP, INDEX\/MATCH) \u0111ang tr\u1edf th\u00e0nh ti\u00eau chu\u1ea9n t\u1ed1i thi\u1ec3u. Doanh nghi\u1ec7p l\u1edbn ng\u00e0y c\u00e0ng \u01b0u ti\u00ean \u1ee9ng vi\u00ean c\u00f3 ch\u1ee9ng ch\u1ec9 MOS Excel Associate \/ Expert<\/strong> (Microsoft Office Specialist do Certiport \/ Pearson VUE c\u1ea5p), ho\u1eb7c \u0111\u00e3 l\u00e0m quen v\u1edbi c\u00e1c n\u1ec1n t\u1ea3ng c\u1ed9ng t\u00e1c Microsoft 365 (Excel Online, SharePoint), Google Workspace (Google Sheets, AppSheet) v\u00e0 Power BI cho b\u00e1o c\u00e1o n\u00e2ng cao. Nh\u00f3m v\u0103n ph\u00f2ng thu\u1ed9c t\u1eadp \u0111o\u00e0n n\u01b0\u1edbc ngo\u00e0i (Samsung VN, Foxconn, LG, Bosch) c\u00f2n y\u00eau c\u1ea7u s\u1eed d\u1ee5ng macro VBA c\u01a1 b\u1ea3n ho\u1eb7c Power Query \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u00e1o c\u00e1o tu\u1ea7n \/ th\u00e1ng.<\/p>\n\n\n\n\n\n\n
C\u1ea5p b\u1eadc<\/th>\nM\u1ee9c l\u01b0\u01a1ng<\/th>\nY\u00eau c\u1ea7u Excel c\u1ed1t l\u00f5i<\/th>\nCh\u1ee9ng ch\u1ec9 \/ Tool<\/th>\n<\/tr>\n<\/thead>\n
L\u1ec5 t\u00e2n \/ Admin Officer<\/td>8\u201311 tri\u1ec7u<\/td>T\u1ea1o b\u1ea3ng, format, h\u00e0m SUM\/AVERAGE<\/td>Excel c\u01a1 b\u1ea3n, MOS Excel<\/td><\/tr>\n
Th\u01b0 k\u00fd \/ Tr\u1ee3 l\u00fd ph\u00f2ng ban<\/td>10\u201316 tri\u1ec7u<\/td>PivotTable, VLOOKUP, conditional format<\/td>MOS Excel Associate<\/td><\/tr>\n
Tr\u1ee3 l\u00fd T\u1ed5ng Gi\u00e1m \u0111\u1ed1c<\/td>18\u201330 tri\u1ec7u<\/td>B\u00e1o c\u00e1o dashboard, INDEX\/MATCH, Power Query<\/td>MOS Excel Expert, Power BI<\/td><\/tr>\n
Office Manager \/ Admin Lead<\/td>22\u201335 tri\u1ec7u<\/td>VBA macro, automation b\u00e1o c\u00e1o<\/td>VBA, Power BI, Microsoft 365 Admin<\/td><\/tr>\n<\/tbody>\n<\/table>\n\n\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c v\u1ecb tr\u00ed \u0111ang tuy\u1ec3n d\u1ee5ng t\u1ea1i chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m th\u01b0 k\u00fd<\/a> \u0111\u1ec3 hi\u1ec3u r\u00f5 JD, m\u1ee9c l\u01b0\u01a1ng v\u00e0 y\u00eau c\u1ea7u Excel c\u1ee5 th\u1ec3 c\u1ee7a t\u1eebng c\u1ea5p b\u1eadc trong kh\u1ed1i v\u0103n ph\u00f2ng t\u1ea1i doanh nghi\u1ec7p Vi\u1ec7t Nam v\u00e0 FDI n\u0103m 2026.<\/p>\n\n\n

\n

L\u1eddi khuy\u00ean n\u00e2ng k\u1ef9 n\u0103ng t\u1ea1o b\u1ea3ng Excel cho d\u00e2n v\u0103n ph\u00f2ng n\u0103m 2026<\/strong><\/p>\n

\u2013 H\u1ecdc PivotTable + conditional formatting trong 3\u20134 bu\u1ed5i (Microsoft Learn mi\u1ec5n ph\u00ed) \u2014 \u0111\u00e2y l\u00e0 2 k\u1ef9 n\u0103ng ph\u00e2n bi\u1ec7t gi\u1eefa th\u01b0 k\u00fd junior 8 tri\u1ec7u v\u00e0 tr\u1ee3 l\u00fd cao c\u1ea5p 18 tri\u1ec7u\/th\u00e1ng.<\/p>\n

\u2013 \u0110\u0103ng k\u00fd thi MOS Excel Associate<\/strong> (chi ph\u00ed ~2.5 tri\u1ec7u, 50 ph\u00fat thi) t\u1ea1i Certiport Vi\u1ec7t Nam \u2014 ch\u1ee9ng ch\u1ec9 n\u00e0y \u0111\u01b0\u1ee3c h\u1ea7u h\u1ebft MNC ch\u1ea5p nh\u1eadn v\u00e0 l\u00e0m t\u0103ng l\u01b0\u01a1ng kh\u1edfi \u0111i\u1ec3m 10\u201315%.<\/p>\n

\u2013 H\u1ecdc th\u00eam Power Query \u0111\u1ec3 t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u00e1o c\u00e1o tu\u1ea7n \u2014 k\u1ef9 n\u0103ng n\u00e0y hi\u1ebfm trong nh\u00f3m th\u01b0 k\u00fd n\u00ean gi\u00fap b\u1ea1n n\u1ed5i b\u1eadt khi \u1ee9ng tuy\u1ec3n v\u1ecb tr\u00ed Tr\u1ee3 l\u00fd TG\u0110 ho\u1eb7c Office Manager.<\/p>\n<\/div>\n\n\n\n\n

6. C\u00e2u h\u1ecfi th\u01b0\u1eddng g\u1eb7p<\/h2>\n\n\n\n

1. Table kh\u00e1c Range (v\u00f9ng d\u1eef li\u1ec7u th\u01b0\u1eddng) \u1edf \u0111i\u1ec3m n\u00e0o?<\/em><\/strong><\/p>\n\n\n\n

Range l\u00e0 t\u1eadp h\u1ee3p \u00f4 th\u00f4ng th\u01b0\u1eddng, kh\u00f4ng c\u00f3 t\u00ednh n\u0103ng \u0111\u1eb7c bi\u1ec7t. Table l\u00e0 object c\u00f3 t\u00ean, t\u1ef1 m\u1edf r\u1ed9ng khi th\u00eam d\u00f2ng, c\u00f3 AutoFilter s\u1eb5n, ti\u00eau \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh khi cu\u1ed9n, h\u1ed7 tr\u1ee3 Structured References v\u00e0 Total Row. Table m\u1ea1nh h\u01a1n Range \u1edf m\u1ecdi kh\u00eda c\u1ea1nh qu\u1ea3n l\u00fd d\u1eef li\u1ec7u.<\/p>\n\n\n\n

2. C\u00f3 gi\u1edbi h\u1ea1n s\u1ed1 d\u00f2ng trong Table kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

Gi\u1ed1ng gi\u1edbi h\u1ea1n sheet: 1.048.576 d\u00f2ng \u00d7 16.384 c\u1ed9t (Excel 2007+). Tuy nhi\u00ean, tr\u00ean 500.000 d\u00f2ng, Table c\u00f3 th\u1ec3 ch\u1eadm \u2013 n\u00ean chuy\u1ec3n sang Power Query\/Power Pivot cho data l\u1edbn.<\/p>\n\n\n\n

3. Table c\u00f3 \u1ea3nh h\u01b0\u1edfng \u0111\u1ebfn macro VBA kh\u00f4ng?<\/em><\/strong><\/p>\n\n\n\n

C\u00f3. VBA c\u1ea7n d\u00f9ng ListObject thay v\u00ec Range khi thao t\u00e1c v\u1edbi Table. V\u00ed d\u1ee5: `ActiveSheet.ListObjects(“BangLuong”).DataBodyRange` thay v\u00ec `Range(“A2:F100”)`. N\u1ebfu macro hi\u1ec7n t\u1ea1i d\u00f9ng Range c\u1ee9ng, c\u1ea7n s\u1eeda khi chuy\u1ec3n sang Table.<\/p>\n\n\n\n

C\u00e1ch t\u1ea1o b\u1ea3ng trong Excel<\/strong> \u0111\u01a1n gi\u1ea3n ch\u1ec9 b\u1eb1ng Ctrl+T nh\u01b0ng m\u1edf ra nhi\u1ec1u t\u00ednh n\u0103ng m\u1ea1nh m\u1ebd: t\u1ef1 m\u1edf r\u1ed9ng, AutoFilter s\u1eb5n, ti\u00eau \u0111\u1ec1 c\u1ed1 \u0111\u1ecbnh, Structured References v\u00e0 k\u1ebft n\u1ed1i PivotTable t\u1ef1 \u0111\u1ed9ng. H\u00e3y bi\u1ebfn m\u1ecdi b\u1ea3ng d\u1eef li\u1ec7u th\u00e0nh Table ngay t\u1eeb \u0111\u1ea7u \u2013 \u0111\u00e2y l\u00e0 th\u00f3i quen nh\u1ecf nh\u01b0ng t\u1ea1o kh\u00e1c bi\u1ec7t l\u1edbn trong hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c v\u1edbi Excel.<\/p>\n\n\n\n\n

Minh An<\/strong><\/p>\n\n\n\n

B\u00e0i vi\u1ebft mang t\u00ednh tham kh\u1ea3o, giao di\u1ec7n v\u00e0 ch\u1ee9c n\u0103ng c\u00f3 th\u1ec3 kh\u00e1c nhau t\u00f9y phi\u00ean b\u1ea3n Excel.<\/em><\/p>","protected":false},"excerpt":{"rendered":"

H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o b\u1ea3ng trong Excel b\u1eb1ng Insert Table, format b\u1ea3ng \u0111\u1eb9p, th\u00eam c\u00f4ng th\u1ee9c t\u1ef1 \u0111\u1ed9ng. Xem ngay \u0111\u1ec3 t\u1ea1o b\u1ea3ng d\u1eef li\u1ec7u chuy\u00ean nghi\u1ec7p trong 5 ph\u00fat.<\/p>\n","protected":false},"author":58,"featured_media":18369,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-18307","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-goc-ky-nang"],"_links":{"self":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/18307","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/users\/58"}],"replies":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/comments?post=18307"}],"version-history":[{"count":14,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/18307\/revisions"}],"predecessor-version":[{"id":25902,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/18307\/revisions\/25902"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media\/18369"}],"wp:attachment":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media?parent=18307"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/categories?post=18307"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/tags?post=18307"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}