{"id":28325,"date":"2026-08-06T11:39:20","date_gmt":"2026-08-06T04:39:20","guid":{"rendered":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/?p=28325"},"modified":"2026-08-07T15:39:47","modified_gmt":"2026-08-07T08:39:47","slug":"google-sheets-cho-dan-van-phong","status":"publish","type":"post","link":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/goc-ky-nang\/google-sheets-cho-dan-van-phong","title":{"rendered":"Google Sheets cho d\u00e2n v\u0103n ph\u00f2ng: h\u00e0m c\u1ea7n bi\u1ebft v\u00e0 gi\u1edbi h\u1ea1n n\u00ean tr\u00e1nh"},"content":{"rendered":"

M\u1ed9t b\u1ea3ng c\u00f4ng n\u1ee3 g\u1eedi qua email, ba ng\u01b0\u1eddi s\u1eeda ba b\u1ea3n kh\u00e1c nhau, \u0111\u1ebfn cu\u1ed1i tu\u1ea7n kh\u00f4ng ai bi\u1ebft b\u1ea3n n\u00e0o \u0111\u00fang. T\u00ecnh hu\u1ed1ng \u0111\u00f3 l\u00e0 l\u00fd do google sheets cho d\u00e2n v\u0103n ph\u00f2ng<\/strong> tr\u1edf th\u00e0nh c\u00f4ng c\u1ee5 m\u1eb7c \u0111\u1ecbnh \u1edf nhi\u1ec1u ph\u00f2ng ban. Nh\u01b0ng c\u00f4ng c\u1ee5 n\u00e0y m\u1ea1nh \u1edf \u0111\u00e2u, y\u1ebfu ch\u1ed7 n\u00e0o v\u00e0 l\u00fac n\u00e0o n\u00ean tr\u1ea3 vi\u1ec7c v\u1ec1 Excel th\u00ec \u00edt ng\u01b0\u1eddi n\u00f3i r\u00f5.<\/p>\n

\"Google<\/p>\n

\n

T\u1ed5ng quan nhanh<\/strong><\/p>\n

\u2013 Kh\u00e1c bi\u1ec7t g\u1ed1c r\u1ec5 so v\u1edbi Excel l\u00e0 file s\u1ed1ng tr\u00ean n\u1ec1n web, kh\u00f4ng ph\u1ea3i \u1edf b\u1ed9 h\u00e0m.<\/p>\n

\u2013 Vi\u1ec7c h\u1eb1ng ng\u00e0y ch\u1ee7 y\u1ebfu c\u1ea7n ba nh\u00f3m h\u00e0m: tra c\u1ee9u, l\u00e0m s\u1ea1ch d\u1eef li\u1ec7u v\u00e0 nh\u00f3m ri\u00eang c\u1ee7a Google.<\/p>\n

\u2013 \u0110i\u1ec3m y\u1ebfu th\u1eadt s\u1ef1 l\u00e0 t\u1ed1c \u0111\u1ed9 khi file ph\u00ecnh to v\u00e0 r\u1ee7i ro chia s\u1ebb nh\u1ea7m quy\u1ec1n.<\/p>\n

\u2013 K\u1ef9 n\u0103ng b\u1ea3ng t\u00ednh gi\u1edd l\u00e0 y\u00eau c\u1ea7u m\u1eb7c \u0111\u1ecbnh \u1edf kh\u1ed1i k\u1ebf to\u00e1n, h\u00e0nh ch\u00ednh.<\/p>\n<\/div>\n

1. B\u1ea3n ch\u1ea5t kh\u00e1c Excel n\u1eb1m \u1edf \u0111\u00e2u<\/h2>\n

Excel theo m\u00f4 h\u00ecnh t\u1ec7p: m\u1ed7i ng\u01b0\u1eddi gi\u1eef m\u1ed9t b\u1ea3n, s\u1eeda xong g\u1eedi l\u1ea1i, ng\u01b0\u1eddi t\u1ed5ng h\u1ee3p g\u1ed9p th\u1ee7 c\u00f4ng. Google Sheets b\u1ecf h\u1eb3n kh\u00e1i ni\u1ec7m “b\u1ea3n c\u1ee7a t\u00f4i” v\u00ec b\u1ea3ng t\u00ednh (spreadsheet) n\u1eb1m tr\u00ean Google Drive, ai \u0111\u01b0\u1ee3c c\u1ea5p quy\u1ec1n th\u00ec m\u1edf \u0111\u00fang m\u1ed9t t\u00e0i li\u1ec7u. N\u1ec1n t\u1ea3ng web sinh ra ba th\u1ee9 Excel kh\u00f4ng c\u00f3 s\u1eb5n: c\u1ed9ng t\u00e1c th\u1eddi gian th\u1ef1c (real-time collaboration), l\u1ecbch s\u1eed phi\u00ean b\u1ea3n (version history) t\u1ef1 l\u01b0u \u0111\u1ec3 kh\u00f4i ph\u1ee5c tr\u1ea1ng th\u00e1i file v\u00e0i ng\u00e0y tr\u01b0\u1edbc, v\u00e0 chia s\u1ebb b\u1eb1ng \u0111\u01b0\u1eddng li\u00ean k\u1ebft k\u00e8m ph\u00e2n quy\u1ec1n Ng\u01b0\u1eddi xem, Ng\u01b0\u1eddi nh\u1eadn x\u00e9t ho\u1eb7c Ng\u01b0\u1eddi ch\u1ec9nh s\u1eeda. C\u1ea3 ph\u00f2ng nh\u00ecn v\u00e0o m\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u duy nh\u1ea5t n\u00ean h\u1ebft c\u1ea3nh \u0111\u1ed1i chi\u1ebfu hai b\u1ea3n.<\/p>\n

2. Nh\u00f3m h\u00e0m Google Sheets cho d\u00e2n v\u0103n ph\u00f2ng d\u00f9ng h\u1eb1ng ng\u00e0y<\/h2>\n

1. Tra c\u1ee9u v\u00e0 t\u1ed5ng h\u1ee3p c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/h3>\n

VLOOKUP ho\u1eb7c XLOOKUP d\u00f9ng khi ph\u1ea3i gh\u00e9p d\u1eef li\u1ec7u hai b\u1ea3ng, ch\u1eb3ng h\u1ea1n l\u1ea5y t\u00ean nh\u00e2n vi\u00ean sang b\u1ea3ng ch\u1ea5m c\u00f4ng theo m\u00e3 s\u1ed1; XLOOKUP t\u00ecm \u0111\u01b0\u1ee3c c\u1ea3 hai chi\u1ec1u n\u00ean linh ho\u1ea1t h\u01a1n. SUMIF v\u00e0 COUNTIF tr\u1ea3 l\u1eddi nh\u1eefng c\u00e2u quen thu\u1ed9c nh\u01b0 th\u00e1ng n\u00e0y chi ph\u00ed marketing bao nhi\u00eau; SUMIFS v\u00e0 COUNTIFS x\u1eed l\u00fd nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n c\u00f9ng l\u00fac.<\/p>\n

B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \/ ki\u1ec3m to\u00e1n<\/a> \u0111ang tuy\u1ec3n d\u1ee5ng tr\u00ean CareerLink \u0111\u1ec3 n\u1eafm r\u00f5 nhu c\u1ea7u th\u1ef1c t\u1ebf v\u00e0 y\u00eau c\u1ea7u c\u1ee7a nh\u00e0 tuy\u1ec3n d\u1ee5ng.<\/p>\n

2. L\u00e0m s\u1ea1ch d\u1eef li\u1ec7u: TRIM v\u00e0 ARRAYFORMULA<\/h3>\n

D\u1eef li\u1ec7u nh\u1eadp tay h\u1ea7u nh\u01b0 lu\u00f4n c\u00f3 kho\u1ea3ng tr\u1eafng th\u1eeba khi\u1ebfn h\u00e0m tra c\u1ee9u b\u00e1o l\u1ed7i d\u00f9 hai \u00f4 nh\u00ecn gi\u1ed1ng h\u1ec7t nhau, v\u00e0 TRIM x\u1eed l\u00fd \u0111\u00fang ch\u1ed7 n\u00e0y. ARRAYFORMULA thay vi\u1ec7c k\u00e9o c\u00f4ng th\u1ee9c xu\u1ed1ng h\u00e0ng ngh\u00ecn d\u00f2ng b\u1eb1ng m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t.<\/p>\n

3. Nh\u00f3m ch\u1ec9 Google Sheets m\u1edbi c\u00f3<\/h3>\n

IMPORTRANGE k\u00e9o d\u1eef li\u1ec7u t\u1eeb file kh\u00e1c sang m\u00e0 kh\u00f4ng c\u1ea7n sao ch\u00e9p, h\u1ee3p khi m\u1ed7i b\u1ed9 ph\u1eadn gi\u1eef file ri\u00eang nh\u01b0ng c\u1ea7n b\u1ea3ng t\u1ed5ng h\u1ee3p chung. QUERY l\u1ecdc v\u00e0 nh\u00f3m d\u1eef li\u1ec7u b\u1eb1ng c\u00fa ph\u00e1p g\u1ea7n gi\u1ed1ng ng\u00f4n ng\u1eef truy v\u1ea5n c\u01a1 s\u1edf d\u1eef li\u1ec7u, c\u00f2n GOOGLETRANSLATE d\u1ecbch ngay trong \u00f4.<\/p>\n

\n

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

\u2013 H\u00e0m n\u00e0y k\u00e9o d\u1eef li\u1ec7u ch\u1ee9 kh\u00f4ng k\u00e9o quy\u1ec1n: ng\u01b0\u1eddi xem b\u1ea3ng t\u1ed5ng h\u1ee3p \u0111\u1ecdc \u0111\u01b0\u1ee3c c\u1ea3 d\u1eef li\u1ec7u l\u1ea5y v\u1ec1 d\u00f9 kh\u00f4ng c\u00f3 quy\u1ec1n v\u00e0o file ngu\u1ed3n.<\/p>\n

\u2013 File ngu\u1ed3n b\u1ecb ch\u00e8n th\u00eam c\u1ed9t ho\u1eb7c \u0111\u1ed5i t\u00ean sheet l\u00e0 c\u00f4ng th\u1ee9c g\u00e3y m\u00e0 kh\u00f4ng ai b\u00e1o.<\/p>\n<\/div>\n

3. Ph\u1ed1i h\u1ee3p nh\u00f3m m\u00e0 kh\u00f4ng gi\u1eabm ch\u00e2n nhau<\/h2>\n

\u0110i\u1ec3m m\u1ea1nh l\u1edbn nh\u1ea5t c\u1ee7a Google Sheets cho d\u00e2n v\u0103n ph\u00f2ng n\u1eb1m \u1edf nh\u00f3m t\u00ednh n\u0103ng ph\u1ed1i h\u1ee3p ch\u1ee9 kh\u00f4ng ph\u1ea3i \u1edf h\u00e0m. Ch\u1ee9c n\u0103ng nh\u1eadn x\u00e9t cho ph\u00e9p g\u1eafn th\u1ebb \u0111\u1ed3ng nghi\u1ec7p b\u1eb1ng k\u00fd hi\u1ec7u @ k\u00e8m email, h\u1ec7 th\u1ed1ng g\u1eedi th\u00f4ng b\u00e1o v\u00e0 gi\u1eef tr\u1ea1ng th\u00e1i t\u1edbi khi ng\u01b0\u1eddi \u0111\u00f3 \u0111\u00e1nh d\u1ea5u \u0111\u00e3 xong. Nh\u1edd v\u1eady m\u1ed9t \u00f4 s\u1ed1 li\u1ec7u \u0111ang tranh c\u00e3i bi\u1ebfn th\u00e0nh \u0111\u1ea7u vi\u1ec7c c\u00f3 ng\u01b0\u1eddi ph\u1ee5 tr\u00e1ch.<\/p>\n

B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 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> \u0111\u1ec3 chu\u1ea9n b\u1ecb k\u1ef9 h\u01a1n cho t\u00ecnh hu\u1ed1ng c\u1ee7a m\u00ecnh.<\/p>\n

\u2013 Ph\u00e2n quy\u1ec1n ba m\u1ee9c gi\u00fap ng\u01b0\u1eddi ngo\u00e0i b\u1ed9 ph\u1eadn \u0111\u1ecdc b\u00e1o c\u00e1o m\u00e0 kh\u00f4ng s\u1eeda \u0111\u01b0\u1ee3c s\u1ed1.<\/p>\n

\u2013 B\u1ea3o v\u1ec7 trang t\u00ednh v\u00e0 ph\u1ea1m vi kh\u00f3a v\u00f9ng c\u00f4ng th\u1ee9c, ch\u1ec9 m\u1edf \u00f4 nh\u1eadp li\u1ec7u.<\/p>\n

\u2013 Nh\u1eadt k\u00fd ch\u1ec9nh s\u1eeda t\u1eebng \u00f4 cho bi\u1ebft ai \u0111\u1ed5i gi\u00e1 tr\u1ecb n\u00e0o l\u00fac n\u00e0o.<\/p>\n

Ba thi\u1ebft l\u1eadp n\u00e0y n\u00ean l\u00e0m ngay l\u00fac t\u1ea1o file, kh\u00f4ng ph\u1ea3i sau s\u1ef1 c\u1ed1.<\/p>\n

\n

B\u1ea3ng t\u00ednh d\u00f9ng chung kh\u00f4ng h\u1ecfng v\u00ec thi\u1ebfu h\u00e0m hay, n\u00f3 h\u1ecfng v\u00ec kh\u00f4ng ai bi\u1ebft ai \u0111\u00e3 s\u1eeda g\u00ec.<\/em><\/p>\n<\/blockquote>\n

4. Ba gi\u1edbi h\u1ea1n v\u00e0 m\u1ed9t r\u1ee7i ro \u00edt \u0111\u01b0\u1ee3c nh\u1eafc t\u1edbi<\/h2>\n

Ph\u1ea7n l\u1edbn b\u00e0i h\u01b0\u1edbng d\u1eabn ch\u1ec9 li\u1ec7t k\u00ea t\u00ednh n\u0103ng hay, nh\u01b0ng ng\u01b0\u1eddi d\u00f9ng l\u00e2u n\u0103m \u0111\u1ec1u g\u1eb7p ba gi\u1edbi h\u1ea1n. Th\u1ee9 nh\u1ea5t l\u00e0 t\u1ed1c \u0111\u1ed9: file c\u00e0ng nhi\u1ec1u d\u00f2ng, c\u00e0ng nhi\u1ec1u c\u00f4ng th\u1ee9c m\u1ea3ng v\u00e0 li\u00ean k\u1ebft ch\u00e9o th\u00ec c\u00e0ng \u00ec, t\u1eeb l\u00e2u tr\u01b0\u1edbc khi ch\u1ea1m ng\u01b0\u1ee1ng gi\u1edbi h\u1ea1n \u00f4. Th\u1ee9 hai l\u00e0 ph\u00e2n t\u00edch n\u1eb7ng, n\u01a1i Excel v\u01b0\u1ee3t tr\u1ed9i v\u1edbi Power Query \u0111\u1ec3 chu\u1ea9n h\u00f3a d\u1eef li\u1ec7u th\u00f4 v\u00e0 Power Pivot \u0111\u1ec3 d\u1ef1ng m\u00f4 h\u00ecnh nhi\u1ec1u b\u1ea3ng. Th\u1ee9 ba l\u00e0 ph\u1ee5 thu\u1ed9c k\u1ebft n\u1ed1i m\u1ea1ng, v\u00ec ch\u1ebf \u0111\u1ed9 ngo\u1ea1i tuy\u1ebfn c\u00f3 nh\u01b0ng h\u1ea1n ch\u1ebf.<\/p>\n

R\u1ee7i ro th\u1ee9 t\u01b0 nghi\u00eam tr\u1ecdng h\u01a1n c\u1ea3 ba \u0111i\u1ec1u tr\u00ean. Khi chia s\u1ebb, nhi\u1ec1u ng\u01b0\u1eddi ch\u1ecdn nhanh t\u00f9y ch\u1ecdn “B\u1ea5t k\u1ef3 ai c\u00f3 \u0111\u01b0\u1eddng li\u00ean k\u1ebft”, ngh\u0129a l\u00e0 ai c\u1ea7m link \u0111\u1ec1u m\u1edf \u0111\u01b0\u1ee3c. V\u1edbi b\u1ea3ng l\u01b0\u01a1ng hay h\u1ed3 s\u01a1 \u1ee9ng vi\u00ean, \u0111\u00e2y l\u00e0 d\u1eef li\u1ec7u c\u00e1 nh\u00e2n c\u1ea7n \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 theo quy \u0111\u1ecbnh hi\u1ec7n h\u00e0nh, n\u00ean m\u1ed9t li\u00ean k\u1ebft chuy\u1ec3n ti\u1ebfp nh\u1ea7m c\u00f3 th\u1ec3 th\u00e0nh s\u1ef1 c\u1ed1 l\u1ed9 l\u1ecdt.<\/p>\n

5. Khi n\u00e0o d\u00f9ng Sheets, khi n\u00e0o quay l\u1ea1i Excel<\/h2>\n\n\n\n\n\n\n
T\u00ecnh hu\u1ed1ng c\u00f4ng vi\u1ec7c<\/th>\nN\u00ean d\u00f9ng<\/th>\nL\u00fd do<\/th>\n<\/tr>\n
Nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng c\u1eadp nh\u1eadt m\u1ed9t b\u1ea3ng theo d\u00f5i<\/td>\nGoogle Sheets<\/td>\nM\u1ed9t ngu\u1ed3n d\u1eef li\u1ec7u duy nh\u1ea5t<\/td>\n<\/tr>\n
L\u00e0m s\u1ea1ch d\u1eef li\u1ec7u th\u00f4 h\u00e0ng tr\u0103m ngh\u00ecn d\u00f2ng<\/td>\nExcel<\/td>\nPower Query x\u1eed l\u00fd theo quy tr\u00ecnh l\u1eb7p l\u1ea1i<\/td>\n<\/tr>\n
D\u1ef1ng m\u00f4 h\u00ecnh nhi\u1ec1u b\u1ea3ng, b\u00e1o c\u00e1o \u0111\u1ed9ng<\/td>\nExcel<\/td>\nPower Pivot ch\u01b0a c\u00f3 t\u01b0\u01a1ng \u0111\u01b0\u01a1ng<\/td>\n<\/tr>\n
D\u1eef li\u1ec7u l\u01b0\u01a1ng, h\u1ed3 s\u01a1 nh\u00e2n s\u1ef1 n\u1ed9i b\u1ed9<\/td>\nT\u00f9y ch\u00ednh s\u00e1ch c\u00f4ng ty<\/td>\nC\u1ea7n ki\u1ec3m so\u00e1t quy\u1ec1n ch\u1eb7t<\/td>\n<\/tr>\n<\/table>\n

Ranh gi\u1edbi \u1edf \u0111\u00e2y kh\u00e1 r\u00f5. Vi\u1ec7c theo d\u00f5i h\u1eb1ng ng\u00e0y n\u00ean \u0111\u1eb7t tr\u00ean n\u1ec1n web, c\u00f2n ph\u00e2n t\u00edch cu\u1ed1i k\u1ef3 th\u00ec x\u1eed l\u00fd b\u1eb1ng Excel. Nhi\u1ec1u ph\u00f2ng ban d\u00f9ng song song c\u1ea3 hai.<\/p>\n

\"Google<\/p>\n

6. K\u1ef9 n\u0103ng b\u1ea3ng t\u00ednh trong y\u00eau c\u1ea7u tuy\u1ec3n d\u1ee5ng<\/h2>\n

Trong m\u00f4 t\u1ea3 c\u00f4ng vi\u1ec7c, k\u1ef9 n\u0103ng b\u1ea3ng t\u00ednh hi\u1ebfm khi \u0111\u01b0\u1ee3c ghi th\u00e0nh d\u00f2ng ri\u00eang m\u00e0 n\u1eb1m \u1ea9n sau c\u00e1c y\u00eau c\u1ea7u nh\u01b0 t\u1ed5ng h\u1ee3p b\u00e1o c\u00e1o \u0111\u1ecbnh k\u1ef3 hay theo d\u00f5i c\u00f4ng n\u1ee3. Kh\u1ed1i k\u1ebf to\u00e1n v\u00e0 h\u00e0nh ch\u00ednh th\u01b0\u1eddng ki\u1ec3m tra b\u1eb1ng b\u00e0i th\u1ef1c h\u00e0nh ng\u1eafn, v\u00e0 th\u1ee9 h\u1ecd nh\u00ecn l\u00e0 c\u00e1ch \u1ee9ng vi\u00ean t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u.<\/p>\n

V\u1ec1 nhu c\u1ea7u tuy\u1ec3n d\u1ee5ng, chuy\u00ean m\u1ee5c vi\u1ec7c l\u00e0m k\u1ebf to\u00e1n \/ ki\u1ec3m to\u00e1n tr\u00ean CareerLink hi\u1ec7n c\u00f3 2.004 tin tuy\u1ec3n d\u1ee5ng, m\u1ee9c l\u01b0\u01a1ng ph\u1ed5 bi\u1ebfn 7\u201345 tri\u1ec7u \u0111\u1ed3ng\/th\u00e1ng t\u00f9y v\u1ecb tr\u00ed, quy m\u00f4 doanh nghi\u1ec7p v\u00e0 kinh nghi\u1ec7m \u1ee9ng vi\u00ean. \u0110\u00e2y l\u00e0 nh\u00f3m ng\u00e0nh m\u00e0 thao t\u00e1c b\u1ea3ng t\u00ednh chi\u1ebfm ph\u1ea7n l\u1edbn th\u1eddi gian m\u1ed7i ng\u00e0y, v\u00e0 v\u1ecb tr\u00ed nh\u00e2n vi\u00ean h\u00e0nh ch\u00ednh (administrative staff) c\u0169ng v\u1eady.<\/p>\n

Mu\u1ed1n c\u00f3 b\u1eb1ng ch\u1ee9ng tr\u00ean h\u1ed3 s\u01a1, ch\u1ee9ng ch\u1ec9 Microsoft Office Specialist (MOS) ph\u1ea7n Excel l\u00e0 l\u1ef1a ch\u1ecdn ph\u1ed5 bi\u1ebfn t\u1ea1i Vi\u1ec7t Nam. Nh\u01b0ng v\u1edbi nh\u00e0 tuy\u1ec3n d\u1ee5ng, m\u1ed9t b\u1ea3ng theo d\u00f5i b\u1ea1n t\u1eebng d\u1ef1ng v\u1eabn thuy\u1ebft ph\u1ee5c h\u01a1n.<\/p>\n

\n

L\u1eddi khuy\u00ean khi b\u1eaft \u0111\u1ea7u<\/strong><\/p>\n

\u2013 H\u00e3y h\u1ecdc theo b\u00e0i to\u00e1n c\u00f3 th\u1eadt \u1edf c\u00f4ng vi\u1ec7c hi\u1ec7n t\u1ea1i thay v\u00ec h\u1ecdc h\u1ebft danh m\u1ee5c h\u00e0m.<\/p>\n

\u2013 Tr\u01b0\u1edbc khi b\u1ea5m chia s\u1ebb, h\u00e3y xem quy\u1ec1n \u0111ang m\u1edf cho ng\u01b0\u1eddi c\u1ee5 th\u1ec3 hay cho b\u1ea5t k\u1ef3 ai.<\/p>\n

\u2013 Khi file b\u1eaft \u0111\u1ea7u ch\u1eadm, h\u00e3y t\u00e1ch d\u1eef li\u1ec7u l\u1ecbch s\u1eed sang file ri\u00eang.<\/p>\n<\/div>\n

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

1. Google Sheets c\u00f3 thay th\u1ebf ho\u00e0n to\u00e0n Excel \u0111\u01b0\u1ee3c kh\u00f4ng?<\/em><\/strong><\/p>\n

Ch\u01b0a, \u00edt nh\u1ea5t v\u1edbi c\u00f4ng vi\u1ec7c ph\u00e2n t\u00edch n\u1eb7ng. \u1ede m\u1ea3ng theo d\u00f5i v\u00e0 c\u1ed9ng t\u00e1c nh\u00f3m th\u00ec c\u00f4ng c\u1ee5 n\u00e0y \u0111\u00e1p \u1ee9ng t\u1ed1t, c\u00f2n d\u1eef li\u1ec7u th\u00f4 quy m\u00f4 l\u1edbn th\u00ec Excel ph\u00f9 h\u1ee3p h\u01a1n.<\/p>\n

2. Chia s\u1ebb b\u1ea3ng l\u01b0\u01a1ng qua b\u1ea3ng t\u00ednh tr\u1ef1c tuy\u1ebfn th\u1ebf n\u00e0o cho an to\u00e0n?<\/em><\/strong><\/p>\n

N\u00ean chia s\u1ebb \u0111\u00edch danh t\u1eebng \u0111\u1ecba ch\u1ec9 email thay v\u00ec t\u1ea1o li\u00ean k\u1ebft m\u1edf, \u0111\u1eb7t quy\u1ec1n Ng\u01b0\u1eddi xem v\u1edbi ng\u01b0\u1eddi ch\u1ec9 c\u1ea7n \u0111\u1ecdc v\u00e0 kh\u00f3a v\u00f9ng c\u00f4ng th\u1ee9c. M\u1ed7i k\u1ef3 n\u00ean r\u00e0 l\u1ea1i ng\u01b0\u1eddi c\u00f2n quy\u1ec1n.<\/p>\n

3. Ng\u01b0\u1eddi m\u1edbi n\u00ean h\u1ecdc nh\u00f3m h\u00e0m n\u00e0o tr\u01b0\u1edbc?<\/em><\/strong><\/p>\n

B\u1eaft \u0111\u1ea7u b\u1eb1ng XLOOKUP ho\u1eb7c VLOOKUP, sau \u0111\u00f3 t\u1edbi SUMIFS v\u00e0 COUNTIFS. Khi \u0111\u00e3 quen, h\u1ecdc ti\u1ebfp QUERY v\u00e0 IMPORTRANGE v\u00ec \u0111\u00e2y l\u00e0 hai h\u00e0m t\u1ea1o kh\u00e1c bi\u1ec7t l\u1edbn nh\u1ea5t.<\/p>\n

Nh\u00ecn t\u1ed5ng th\u1ec3, gi\u00e1 tr\u1ecb c\u1ee7a Google Sheets cho d\u00e2n v\u0103n ph\u00f2ng<\/strong> kh\u00f4ng n\u1eb1m \u1edf vi\u1ec7c thay th\u1ebf Excel m\u00e0 \u1edf ch\u1ed7 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n nhi\u1ec1u ng\u01b0\u1eddi c\u00f9ng l\u00e0m tr\u00ean m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u. Ai n\u1eafm \u0111\u01b0\u1ee3c v\u00e0i nh\u00f3m h\u00e0m c\u01a1 b\u1ea3n, bi\u1ebft ph\u00e2n quy\u1ec1n c\u1ea9n th\u1eadn v\u00e0 nh\u1eadn ra l\u00fac n\u00e0o n\u00ean chuy\u1ec3n vi\u1ec7c sang c\u00f4ng c\u1ee5 kh\u00e1c s\u1ebd ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian, \u0111\u1ed3ng th\u1eddi tr\u00e1nh nh\u1eefng s\u1ef1 c\u1ed1 d\u1eef li\u1ec7u kh\u00f3 kh\u1eafc ph\u1ee5c.<\/p>\n

N\u1ed9i dung trong b\u00e0i mang t\u00ednh tham kh\u1ea3o, kh\u00f4ng thay th\u1ebf t\u01b0 v\u1ea5n chuy\u00ean m\u00f4n; m\u1ee9c thu nh\u1eadp v\u00e0 c\u01a1 h\u1ed9i ngh\u1ec1 nghi\u1ec7p thay \u0111\u1ed5i theo n\u0103ng l\u1ef1c, kinh nghi\u1ec7m v\u00e0 th\u1eddi \u0111i\u1ec3m tuy\u1ec3n d\u1ee5ng.<\/em><\/p>\n

Minh An<\/em><\/p>\n","protected":false},"excerpt":{"rendered":"

M\u1ed9t b\u1ea3ng c\u00f4ng n\u1ee3 g\u1eedi qua email, ba ng\u01b0\u1eddi s\u1eeda ba b\u1ea3n kh\u00e1c nhau, \u0111\u1ebfn cu\u1ed1i tu\u1ea7n kh\u00f4ng ai bi\u1ebft b\u1ea3n n\u00e0o \u0111\u00fang. T\u00ecnh hu\u1ed1ng …<\/p>\n","protected":false},"author":58,"featured_media":28323,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[15],"tags":[],"class_list":["post-28325","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\/28325","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=28325"}],"version-history":[{"count":1,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/28325\/revisions"}],"predecessor-version":[{"id":28326,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/posts\/28325\/revisions\/28326"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media\/28323"}],"wp:attachment":[{"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/media?parent=28325"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/categories?post=28325"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.careerlink.vn\/cam-nang-viec-lam\/wp-json\/wp\/v2\/tags?post=28325"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}