{"id":3864,"date":"2024-07-23T18:11:54","date_gmt":"2024-07-23T11:11:54","guid":{"rendered":"http:\/\/htttdn.com\/?post_type=ht_kb&#038;p=3864"},"modified":"2025-03-28T14:48:46","modified_gmt":"2025-03-28T07:48:46","slug":"38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi","status":"publish","type":"ht_kb","link":"https:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/","title":{"rendered":"38 ph\u00edm t\u1eaft gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel nhanh g\u1ea5p \u0111\u00f4i"},"content":{"rendered":"<p style=\"text-align: right;\"><span style=\"font-weight: 400;\">Ngu\u1ed3n: <\/span><span style=\"color: #008080;\"><a style=\"color: #008080;\" href=\"https:\/\/www.facebook.com\/groups\/ketoandoanhnghiep.vn\/posts\/6611274145579377\/\" target=\"_blank\" rel=\"noopener noreferrer\"><span style=\"font-weight: 400;\">S\u01b0u t\u1ea7m<\/span><\/a><\/span><span style=\"font-weight: 400;\">, 2021<\/span><\/p>\n<p><img loading=\"lazy\" class=\"alignnone size-full wp-image-3865\" src=\"http:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06.jpg\" alt=\"\" width=\"1200\" height=\"627\" srcset=\"https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06.jpg 1200w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-300x157.jpg 300w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-1024x535.jpg 1024w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-768x401.jpg 768w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-50x26.jpg 50w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-60x31.jpg 60w, https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06-100x52.jpg 100w\" sizes=\"(max-width: 1200px) 100vw, 1200px\" \/><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 c\u00e1c thao t\u00e1c t\u00ednh to\u00e1n, l\u1eadp b\u1ea3ng bi\u1ec3u ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c, b\u1ea1n n\u00ean bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft c\u01a1 b\u1ea3n trong excel. D\u01b0\u1edbi \u0111\u00e2y, ch\u00fang t\u00f4i\u00a0 xin t\u1ed5ng h\u1ee3p l\u1ea1i c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n trong excel m\u00e0 b\u1ea1n c\u1ea7n bi\u1ebft:\u00a0<\/span><\/p>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft gi\u00fap \u0111\u1ecbnh d\u1ea1ng \u00f4<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + 1: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Format.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + B (ho\u1eb7c Ctrl + 2): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng ch\u1eef \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + I (ho\u1eb7c Ctrl + 3): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng in nghi\u00eang.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + U (ho\u1eb7c Ctrl + 4): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf m\u1ed9t g\u1ea1ch d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + 5: \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng g\u1ea1ch ngang.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + &#8216; (d\u1ea5u nh\u00e1y \u0111\u01a1n) : Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Style.<\/span><\/li>\n<\/ul>\n<p><strong>Ph\u00edm t\u1eaft gi\u00fap \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + $: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ~: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u General.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + #: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y theo ki\u1ec3u: ng\u00e0y, th\u00e1ng v\u00e0 n\u0103m.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + \\t: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u1edbi gi\u1edd, ph\u00fat v\u00e0 ch\u1ec9 ra AM ho\u1eb7c PM.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ^: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 khoa h\u1ecdc v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F4: L\u1eb7p l\u1ea1i l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cu\u1ed1i c\u00f9ng.<\/span><\/li>\n<\/ul>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft gi\u00fap thao t\u00e1c c\u0103n \u00f4<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + H, A, R: C\u0103n \u00f4 sang ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + H , A, C: C\u0103n gi\u1eefa \u00f4.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Alt + H , A, I: C\u0103n \u00f4 sang tr\u00e1i.<\/span><\/p>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft c\u00f4ng th\u1ee9c<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">=: B\u1eaft \u0111\u1ea7u m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F3: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Insert Function.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + A: Hi\u1ec3n th\u1ecb c\u00e1ch th\u1ee9c nh\u1eadp sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + A: Ch\u00e8n c\u00e1c \u0111\u1ed1i s\u1ed1 trong c\u00f4ng th\u1ee9c sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F3: Ch\u00e8n m\u1ed9t h\u00e0m th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + Enter: Nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F9: T\u00ednh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F9: T\u00ednh to\u00e1n b\u1ea3ng t\u00ednh ho\u1ea1t \u0111\u1ed9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + U: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 m\u1edf r\u1ed9ng ho\u1eb7c thu g\u1ecdn thanh c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + &#8216;: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 Hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 thay v\u00ec gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Pg Dn (PageDown): Ph\u00edm t\u1eaft chuy\u1ec3n Sheet sang sheet ngay b\u00ean ph\u1ea3i sheet \u0111ang m\u1edf<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Pg Up (PageUp): Chuy\u1ec3n sang sheet b\u00ean tr\u00e1i sheet \u0111ang m\u1edf.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ph\u00edm m\u0169i t\u00ean: di chuy\u1ec3n t\u1edbi d\u00f2ng tr\u00ean c\u00f9ng, d\u01b0\u1edbi c\u00f9ng, c\u1ea1nh tr\u00e1i, c\u1ea1nh ph\u1ea3i c\u1ee7a b\u1ea3ng t\u00ednh. Ph\u00edm t\u1eaft n\u00e0y s\u1ebd gi\u00fap ch\u00fang ta kh\u00f4ng ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn chu\u1ed9t k\u00e9o thanh tr\u01b0\u1ee3t \u0111\u1ec3 t\u00ecm t\u1edbi \u00f4 cu\u1ed1i b\u1ea3ng, nh\u1ea5t l\u00e0 v\u1edbi b\u1ea3ng t\u00ednh d\u00e0i. Khi s\u1eed d\u1ee5ng ph\u00edm Ctrl v\u1edbi b\u1ea5t c\u1ee9 ph\u00edm m\u0169i t\u00ean theo h\u01b0\u1edbng mu\u1ed1n di chuy\u1ec3n, b\u1ea1n s\u1ebd nhanh ch\u00f3ng t\u1edbi \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ea7n t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ph\u00edm m\u0169i t\u00ean + Shift: khoanh ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1edbi cu\u1ed1i b\u1ea3ng thay v\u00ec ch\u1ec9 di chuy\u1ec3n \u00f4 ch\u1ecdn xu\u1ed1ng cu\u1ed1i b\u1ea3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Click \u0111\u00fap chu\u1ed9t tr\u00e1i t\u1ea1i \u00f4: copy c\u00f4ng th\u1ee9c xu\u1ed1ng cu\u1ed1i b\u1ea3ng. Thao t\u00e1c th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 copy xu\u1ed1ng c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi \u0111\u00f3 khi xu\u1ea5t hi\u1ec7n d\u1ea5u +, th\u00ec gi\u1eef v\u00e0 k\u00e9o chu\u1ed9t cho t\u1edbi cu\u1ed1i b\u1ea3ng. Tuy nhi\u00ean nhanh h\u01a1n, b\u1ea1n \u0111\u1eb7t chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed d\u1ea5u c\u1ed9ng, click \u0111\u00fap chu\u1ed9t tr\u00e1i v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c copy xu\u1ed1ng d\u01b0\u1edbi.Ctrl + Shift + 1 (!): \u0111\u1ecbnh d\u1ea1ng \u00f4 d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n v\u1edbi 2 s\u1ed1 sau d\u1ea5u ph\u1ea9y.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + 4 ($): \u0111\u1ecbnh d\u1ea1ng \u00f4 ti\u1ec1n t\u1ec7 $.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + 5 (%): \u0111\u1ecbnh d\u1ea1ng \u00f4 l\u00e0 s\u1ed1 %.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F4: bi\u1ebfn m\u1ed9t \u00f4 th\u00e0nh gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i. Khi ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb nh\u1eefng v\u1ecb tr\u00ed \u00f4 kh\u00e1c nhau nh\u01b0 B1, C2,&#8230; s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i khi copy xu\u1ed1ng d\u00f2ng d\u01b0\u1edbi tr\u1edf th\u00e0nh B2, C3. \u0110\u1ec3 kh\u00f4ng cho c\u00f4ng th\u1ee9c t\u1ef1 nh\u1ea3y s\u1ed1 nh\u01b0 tr\u00ean, d\u00f9ng kh\u00f3a $ v\u00e0o tr\u01b0\u1edbc v\u00e0 sau c\u1ee7a k\u00fd t\u1ef1 \u00f4 \u0111\u1ec3 kh\u00f3a l\u1ea1i. V\u00e0 kh\u00f3a nhanh m\u1ed9t \u00f4 c\u00f3 th\u1ec3 d\u00f9ng F4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&amp;: k\u1ebft h\u1ee3p n\u1ed9i dung hai \u00f4. Nh\u1ea3y sang c\u1ed9t th\u1ee9 3 v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c =\u00f4 1&amp;&#8221; &#8220;&amp;\u00f4 2, trong \u0111\u00f3 ph\u1ea7n &#8221; &#8221; \u0111\u1ec3 t\u1ea1o 1 d\u1ea5u c\u00e1ch gi\u1eefa n\u1ed9i dung 2 \u00f4 sau khi gh\u00e9p. Sau \u0111\u00f3 copy c\u00f4ng th\u1ee9c xu\u1ed1ng cu\u1ed1i b\u1ea3ng s\u1ebd xu\u1ea5t hi\u1ec7n c\u1ed9t c\u00f3 n\u1ed9i dung gh\u00e9p t\u1eeb c\u1ed9t 1 v\u00e0 c\u1ed9t 2.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + =: t\u00ednh t\u1ed5ng nhanh m\u1ed9t c\u1ed9t. B\u00f4i \u0111en v\u00f9ng c\u1ea7n t\u00ednh v\u00e0 b\u00f4i th\u00eam 1 \u00f4 tr\u1ed1ng b\u00ean d\u01b0\u1edbi sau \u0111\u00f3 nh\u1ea5n Alt+=, gi\u00e1 tr\u1ecb \u00f4 cu\u1ed1i l\u00e0 t\u1ed5ng c\u00e1c c\u00e1c \u00f4 trong v\u00f9ng ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ; (d\u1ea5u ch\u1ea5m ph\u1ea9y): \u0111i\u1ec1n nhanh th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o \u00f4 trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ; (d\u1ea5u ch\u1ea5m ph\u1ea9y): \u0111i\u1ec1n ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ~ (c\u1ea1nh s\u1ed1 1): xem to\u00e0n b\u1ed9 c\u00e1c \u00f4 \u1edf d\u1ea1ng c\u00f4ng th\u1ee9c.<\/span><\/li>\n<\/ul>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft gi\u00fap \u0111\u1ecbnh d\u1ea1ng \u00f4<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + 1: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Format.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + B (ho\u1eb7c Ctrl + 2): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng ch\u1eef \u0111\u1eadm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + I (ho\u1eb7c Ctrl + 3): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng in nghi\u00eang.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + U (ho\u1eb7c Ctrl + 4): \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf m\u1ed9t g\u1ea1ch d\u01b0\u1edbi.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + 5: \u00c1p d\u1ee5ng ho\u1eb7c h\u1ee7y b\u1ecf \u0111\u1ecbnh d\u1ea1ng g\u1ea1ch ngang.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + &#8216; (d\u1ea5u nh\u00e1y \u0111\u01a1n) : Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Style.<\/span><\/li>\n<\/ul>\n<p><strong>Ph\u00edm t\u1eaft gi\u00fap \u0111\u1ecbnh d\u1ea1ng s\u1ed1<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + $: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ti\u1ec1n t\u1ec7 v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ~: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 ki\u1ec3u General.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + #: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng ng\u00e0y theo ki\u1ec3u: ng\u00e0y, th\u00e1ng v\u00e0 n\u0103m.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + \\t: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng th\u1eddi gian v\u1edbi gi\u1edd, ph\u00fat v\u00e0 ch\u1ec9 ra AM ho\u1eb7c PM.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ^: \u00c1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng s\u1ed1 khoa h\u1ecdc v\u1edbi hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F4: L\u1eb7p l\u1ea1i l\u1ef1a ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cu\u1ed1i c\u00f9ng.<\/span><\/li>\n<\/ul>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft gi\u00fap thao t\u00e1c c\u0103n \u00f4<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + H, A, R: C\u0103n \u00f4 sang ph\u1ea3i.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + H , A, C: C\u0103n gi\u1eefa \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + H , A, I: C\u0103n \u00f4 sang tr\u00e1i.<\/span><\/li>\n<\/ul>\n<p><strong>C\u00e1c ph\u00edm t\u1eaft c\u00f4ng th\u1ee9c<\/strong><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">=: B\u1eaft \u0111\u1ea7u m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F3: Hi\u1ec3n th\u1ecb h\u1ed9p tho\u1ea1i Insert Function.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + A: Hi\u1ec3n th\u1ecb c\u00e1ch th\u1ee9c nh\u1eadp sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + A: Ch\u00e8n c\u00e1c \u0111\u1ed1i s\u1ed1 trong c\u00f4ng th\u1ee9c sau khi nh\u1eadp t\u00ean c\u1ee7a c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F3: Ch\u00e8n m\u1ed9t h\u00e0m th\u00e0nh m\u1ed9t c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + Enter: Nh\u1eadp c\u00f4ng th\u1ee9c l\u00e0 m\u1ed9t c\u00f4ng th\u1ee9c m\u1ea3ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F9: T\u00ednh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Shift + F9: T\u00ednh to\u00e1n b\u1ea3ng t\u00ednh ho\u1ea1t \u0111\u1ed9ng.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + U: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 m\u1edf r\u1ed9ng ho\u1eb7c thu g\u1ecdn thanh c\u00f4ng th\u1ee9c.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + &#8216;: Chuy\u1ec3n ch\u1ebf \u0111\u1ed9 Hi\u1ec3n th\u1ecb c\u00f4ng th\u1ee9c trong \u00f4 thay v\u00ec gi\u00e1 tr\u1ecb.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Pg Dn (PageDown): Ph\u00edm t\u1eaft chuy\u1ec3n Sheet sang sheet ngay b\u00ean ph\u1ea3i sheet \u0111ang m\u1edf<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Pg Up (PageUp): Chuy\u1ec3n sang sheet b\u00ean tr\u00e1i sheet \u0111ang m\u1edf.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ph\u00edm m\u0169i t\u00ean: di chuy\u1ec3n t\u1edbi d\u00f2ng tr\u00ean c\u00f9ng, d\u01b0\u1edbi c\u00f9ng, c\u1ea1nh tr\u00e1i, c\u1ea1nh ph\u1ea3i c\u1ee7a b\u1ea3ng t\u00ednh. Ph\u00edm t\u1eaft n\u00e0y s\u1ebd gi\u00fap ch\u00fang ta kh\u00f4ng ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn chu\u1ed9t k\u00e9o thanh tr\u01b0\u1ee3t \u0111\u1ec3 t\u00ecm t\u1edbi \u00f4 cu\u1ed1i b\u1ea3ng, nh\u1ea5t l\u00e0 v\u1edbi b\u1ea3ng t\u00ednh d\u00e0i. Khi s\u1eed d\u1ee5ng ph\u00edm Ctrl v\u1edbi b\u1ea5t c\u1ee9 ph\u00edm m\u0169i t\u00ean theo h\u01b0\u1edbng mu\u1ed1n di chuy\u1ec3n, b\u1ea1n s\u1ebd nhanh ch\u00f3ng t\u1edbi \u0111\u01b0\u1ee3c v\u1ecb tr\u00ed c\u1ea7n t\u00ecm.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ph\u00edm m\u0169i t\u00ean + Shift: khoanh ch\u1ecdn v\u00f9ng d\u1eef li\u1ec7u t\u1edbi cu\u1ed1i b\u1ea3ng thay v\u00ec ch\u1ec9 di chuy\u1ec3n \u00f4 ch\u1ecdn xu\u1ed1ng cu\u1ed1i b\u1ea3ng.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Click \u0111\u00fap chu\u1ed9t tr\u00e1i t\u1ea1i \u00f4: copy c\u00f4ng th\u1ee9c xu\u1ed1ng cu\u1ed1i b\u1ea3ng. Thao t\u00e1c th\u00f4ng th\u01b0\u1eddng \u0111\u1ec3 copy xu\u1ed1ng c\u00e1c h\u00e0ng b\u00ean d\u01b0\u1edbi \u0111\u00f3 khi xu\u1ea5t hi\u1ec7n d\u1ea5u +, th\u00ec gi\u1eef v\u00e0 k\u00e9o chu\u1ed9t cho t\u1edbi cu\u1ed1i b\u1ea3ng. Tuy nhi\u00ean nhanh h\u01a1n, b\u1ea1n \u0111\u1eb7t chu\u1ed9t v\u00e0o v\u1ecb tr\u00ed d\u1ea5u c\u1ed9ng, click \u0111\u00fap chu\u1ed9t tr\u00e1i v\u00e0 c\u00f4ng th\u1ee9c s\u1ebd \u0111\u01b0\u1ee3c copy xu\u1ed1ng d\u01b0\u1edbi.Ctrl + Shift + 1 (!): \u0111\u1ecbnh d\u1ea1ng \u00f4 d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n v\u1edbi 2 s\u1ed1 sau d\u1ea5u ph\u1ea9y.<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + 4 ($): \u0111\u1ecbnh d\u1ea1ng \u00f4 ti\u1ec1n t\u1ec7 $.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + 5 (%): \u0111\u1ecbnh d\u1ea1ng \u00f4 l\u00e0 s\u1ed1 %.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F4: bi\u1ebfn m\u1ed9t \u00f4 th\u00e0nh gi\u00e1 tr\u1ecb tuy\u1ec7t \u0111\u1ed1i. Khi ch\u00e9p c\u00f4ng th\u1ee9c t\u1eeb nh\u1eefng v\u1ecb tr\u00ed \u00f4 kh\u00e1c nhau nh\u01b0 B1, C2,&#8230; s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i khi copy xu\u1ed1ng d\u00f2ng d\u01b0\u1edbi tr\u1edf th\u00e0nh B2, C3. \u0110\u1ec3 kh\u00f4ng cho c\u00f4ng th\u1ee9c t\u1ef1 nh\u1ea3y s\u1ed1 nh\u01b0 tr\u00ean, d\u00f9ng kh\u00f3a $ v\u00e0o tr\u01b0\u1edbc v\u00e0 sau c\u1ee7a k\u00fd t\u1ef1 \u00f4 \u0111\u1ec3 kh\u00f3a l\u1ea1i. V\u00e0 kh\u00f3a nhanh m\u1ed9t \u00f4 c\u00f3 th\u1ec3 d\u00f9ng F4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">&amp;: k\u1ebft h\u1ee3p n\u1ed9i dung hai \u00f4. Nh\u1ea3y sang c\u1ed9t th\u1ee9 3 v\u00e0 g\u00f5 c\u00f4ng th\u1ee9c =\u00f4 1&amp;&#8221; &#8220;&amp;\u00f4 2, trong \u0111\u00f3 ph\u1ea7n &#8221; &#8221; \u0111\u1ec3 t\u1ea1o 1 d\u1ea5u c\u00e1ch gi\u1eefa n\u1ed9i dung 2 \u00f4 sau khi gh\u00e9p. Sau \u0111\u00f3 copy c\u00f4ng th\u1ee9c xu\u1ed1ng cu\u1ed1i b\u1ea3ng s\u1ebd xu\u1ea5t hi\u1ec7n c\u1ed9t c\u00f3 n\u1ed9i dung gh\u00e9p t\u1eeb c\u1ed9t 1 v\u00e0 c\u1ed9t 2.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + =: t\u00ednh t\u1ed5ng nhanh m\u1ed9t c\u1ed9t. B\u00f4i \u0111en v\u00f9ng c\u1ea7n t\u00ednh v\u00e0 b\u00f4i th\u00eam 1 \u00f4 tr\u1ed1ng b\u00ean d\u01b0\u1edbi sau \u0111\u00f3 nh\u1ea5n Alt+=, gi\u00e1 tr\u1ecb \u00f4 cu\u1ed1i l\u00e0 t\u1ed5ng c\u00e1c c\u00e1c \u00f4 trong v\u00f9ng ch\u1ecdn.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + ; (d\u1ea5u ch\u1ea5m ph\u1ea9y): \u0111i\u1ec1n nhanh th\u1eddi gian hi\u1ec7n t\u1ea1i v\u00e0o \u00f4 trong b\u1ea3ng t\u00ednh.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ; (d\u1ea5u ch\u1ea5m ph\u1ea9y): \u0111i\u1ec1n ng\u00e0y hi\u1ec7n t\u1ea1i v\u00e0o \u00f4.<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ~ (c\u1ea1nh s\u1ed1 1): xem to\u00e0n b\u1ed9 c\u00e1c \u00f4 \u1edf d\u1ea1ng c\u00f4ng th\u1ee9c.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y l\u00e0 t\u1ed5ng h\u1ee3p c\u00e1c ph\u00edm t\u1eaft Excel th\u00f4ng d\u1ee5ng gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c nhanh ch\u00f3ng, \u0111\u1ea1t hi\u1ec7u qu\u1ea3 cao. N\u1ebfu b\u1ea1n th\u1ea5y h\u1eefu \u00edch th\u00ec \u0111\u1eebng qu\u00ean chia s\u1ebb b\u00e0i vi\u1ebft n\u00e0y cho ng\u01b0\u1eddi th\u00e2n v\u00e0 b\u1ea1n b\u00e8 m\u00ecnh c\u00f9ng bi\u1ebft nh\u00e9!<\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<div class='heateorSssClear'><\/div><div  class='heateor_sss_sharing_container heateor_sss_horizontal_sharing' heateor-sss-data-href='https:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/'><div class='heateor_sss_sharing_title' style=\"font-weight:bold\" ><\/div><ul class=\"heateor_sss_sharing_ul\"><li style=\"padding:4.2px 0 !important\" class=\"heateor_sss_facebook_like\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><div class=\"fb-like\" data-href=\"https:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\" data-layout=\"button_count\" data-action=\"like\" data-show-faces=\"false\" data-share=\"false\"><\/div><\/li><li style=\"padding:4.2px 0 !important\" class=\"heateor_sss_facebook_share\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><div class=\"fb-share-button\" data-href=\"https:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\" data-layout=\"button_count\"><\/div><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Instagram\" Title=\"Instagram\" class=\"heateorSssSharing heateorSssInstagramBackground\"><a href=\"https:\/\/www.instagram.com\/\" rel=\"nofollow noopener\" target=\"_blank\"><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssInstagramSvg\"><\/ss><\/a><\/i><ss class=\"heateor_sss_square_count heateor_sss_instagram_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Twitter\" Title=\"Twitter\" class=\"heateorSssSharing heateorSssTwitterBackground\" onclick='heateorSssPopup(\"http:\/\/twitter.com\/intent\/tweet?text=38%20ph%C3%ADm%20t%E1%BA%AFt%20gi%C3%BAp%20b%E1%BA%A1n%20l%C3%A0m%20vi%E1%BB%87c%20v%E1%BB%9Bi%20Excel%20nhanh%20g%E1%BA%A5p%20%C4%91%C3%B4i&url=https%3A%2F%2Fhtttdn.com%2Findex.php%2Ftin-tuc%2F38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi%2F\")'><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssTwitterSvg\"><\/ss><\/i><ss class=\"heateor_sss_square_count heateor_sss_twitter_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><i style=\"width:20px;height:20px;border-radius:999px;\" alt=\"Pinterest\" Title=\"Pinterest\" class=\"heateorSssSharing heateorSssPinterestBackground\" onclick=\"javascript:void( (function() {var e=document.createElement('script' );e.setAttribute('type','text\/javascript' );e.setAttribute('charset','UTF-8' );e.setAttribute('src','\/\/assets.pinterest.com\/js\/pinmarklet.js?r='+Math.random()*99999999);document.body.appendChild(e)})());\"><ss style=\"display:block;border-radius:999px;\" class=\"heateorSssSharingSvg heateorSssPinterestSvg\"><\/ss><\/i><ss class=\"heateor_sss_square_count heateor_sss_pinterest_count\">&nbsp;<\/ss><\/li><li class=\"heateorSssSharingRound\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><i style=\"width:20px;height:20px;border-radius:999px;\" title=\"More\" alt=\"More\" class=\"heateorSssSharing heateorSssMoreBackground\" onclick=\"heateorSssMoreSharingPopup(this, 'https:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/', '38%20ph%C3%ADm%20t%E1%BA%AFt%20gi%C3%BAp%20b%E1%BA%A1n%20l%C3%A0m%20vi%E1%BB%87c%20v%E1%BB%9Bi%20Excel%20nhanh%20g%E1%BA%A5p%20%C4%91%C3%B4i', '' )\" ><ss style=\"display:block\" class=\"heateorSssSharingSvg heateorSssMoreSvg\"><\/ss><\/i><\/li><li class=\"heateorSssSharingRound\"><ss class=\"heateor_sss_square_count\">&nbsp;<\/ss><i style=\"width:20px;height:20px;border-radius:999px;margin-left:9px !important;\" title=\"Total Shares\" class=\"heateorSssSharing heateorSssTCBackground\"><\/i><\/li><\/ul><div class=\"heateorSssClear\"><\/div><\/div><div class='heateorSssClear'><\/div><p>Ngu\u1ed3n: S\u01b0u t\u1ea7m, 2021 \u0110\u1ec3 c\u00e1c thao t\u00e1c t\u00ednh to\u00e1n, l\u1eadp b\u1ea3ng bi\u1ec3u ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c, b\u1ea1n n\u00ean bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft c\u01a1 b\u1ea3n trong excel. D\u01b0\u1edbi \u0111\u00e2y, ch\u00fang t\u00f4i\u00a0 xin t\u1ed5ng h\u1ee3p l\u1ea1i c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n&#8230;<\/p>\n","protected":false},"author":1,"comment_status":"closed","ping_status":"closed","template":"","format":"standard","meta":[],"ht-kb-category":[94],"ht-kb-tag":[],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v15.2.1 - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\r\n<title>38 ph\u00edm t\u1eaft gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel nhanh g\u1ea5p \u0111\u00f4i - H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p<\/title>\r\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\r\n<link rel=\"canonical\" href=\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\" \/>\r\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\r\n<meta property=\"og:type\" content=\"article\" \/>\r\n<meta property=\"og:title\" content=\"38 ph\u00edm t\u1eaft gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel nhanh g\u1ea5p \u0111\u00f4i - H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p\" \/>\r\n<meta property=\"og:description\" content=\"Ngu\u1ed3n: S\u01b0u t\u1ea7m, 2021 \u0110\u1ec3 c\u00e1c thao t\u00e1c t\u00ednh to\u00e1n, l\u1eadp b\u1ea3ng bi\u1ec3u ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 t\u0103ng hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c, b\u1ea1n n\u00ean bi\u1ebft c\u00e1ch s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 ph\u00edm t\u1eaft c\u01a1 b\u1ea3n trong excel. D\u01b0\u1edbi \u0111\u00e2y, ch\u00fang t\u00f4i\u00a0 xin t\u1ed5ng h\u1ee3p l\u1ea1i c\u00e1c ph\u00edm t\u1eaft c\u01a1 b\u1ea3n...\" \/>\r\n<meta property=\"og:url\" content=\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\" \/>\r\n<meta property=\"og:site_name\" content=\"H\u1ec7 th\u1ed1ng th\u00f4ng tin doanh nghi\u1ec7p\" \/>\r\n<meta property=\"article:modified_time\" content=\"2025-03-28T07:48:46+00:00\" \/>\r\n<meta property=\"og:image\" content=\"https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06.jpg\" \/>\r\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\r\n\t<meta property=\"og:image:height\" content=\"627\" \/>\r\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\r\n<meta name=\"twitter:label1\" content=\"Written by\">\n\t<meta name=\"twitter:data1\" content=\"admin\">\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\">\n\t<meta name=\"twitter:data2\" content=\"10 ph\u00fat\">\r\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"WebSite\",\"@id\":\"https:\/\/htttdn.com\/#website\",\"url\":\"https:\/\/htttdn.com\/\",\"name\":\"H\\u1ec7 th\\u1ed1ng th\\u00f4ng tin doanh nghi\\u1ec7p\",\"description\":\"\",\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":\"https:\/\/htttdn.com\/?s={search_term_string}\",\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/htttdn.com\/wp-content\/uploads\/2024\/07\/38-06.jpg\",\"width\":1200,\"height\":627},{\"@type\":\"WebPage\",\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/#webpage\",\"url\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\",\"name\":\"38 ph\\u00edm t\\u1eaft gi\\u00fap b\\u1ea1n l\\u00e0m vi\\u1ec7c v\\u1edbi Excel nhanh g\\u1ea5p \\u0111\\u00f4i - H\\u1ec7 th\\u1ed1ng th\\u00f4ng tin doanh nghi\\u1ec7p\",\"isPartOf\":{\"@id\":\"https:\/\/htttdn.com\/#website\"},\"primaryImageOfPage\":{\"@id\":\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/#primaryimage\"},\"datePublished\":\"2024-07-23T11:11:54+00:00\",\"dateModified\":\"2025-03-28T07:48:46+00:00\",\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"http:\/\/htttdn.com\/index.php\/tin-tuc\/38-phim-tat-giup-ban-lam-viec-voi-excel-nhanh-gap-doi\/\"]}]}]}<\/script>\r\n<!-- \/ Yoast SEO plugin. -->","_links":{"self":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/3864"}],"collection":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb"}],"about":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/types\/ht_kb"}],"author":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/comments?post=3864"}],"version-history":[{"count":2,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/3864\/revisions"}],"predecessor-version":[{"id":3867,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb\/3864\/revisions\/3867"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/media\/3865"}],"wp:attachment":[{"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/media?parent=3864"}],"wp:term":[{"taxonomy":"ht_kb_category","embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb-category?post=3864"},{"taxonomy":"ht_kb_tag","embeddable":true,"href":"https:\/\/htttdn.com\/index.php\/wp-json\/wp\/v2\/ht-kb-tag?post=3864"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}