{"id":242433,"date":"2023-08-10T22:56:05","date_gmt":"2023-08-10T15:56:05","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=242433"},"modified":"2025-12-31T20:40:36","modified_gmt":"2025-12-31T13:40:36","slug":"thu-thuat-excel","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/","title":{"rendered":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &#038; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">L\u00e0 d\u00e2n v\u0103n ph\u00f2ng hay k\u1ebf to\u00e1n, b\u1ea1n \u0111ang m\u1ea5t h\u00e0ng gi\u1edd cho Excel? 50+ <\/span><b>th\u1ee7 thu\u1eadt Excel<\/b><span style=\"font-weight: 400;\"> c\u01a1 b\u1ea3n &amp; n\u00e2ng cao d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c 200%: ph\u00edm t\u1eaft th\u1ea7n t\u1ed1c, PivotTable ph\u00e2n t\u00edch d\u1eef li\u1ec7u, x\u00f3a tr\u00f9ng l\u1eb7p nhanh, t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u00e1o c\u00e1o. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 l\u00e0m ch\u1ee7 Excel 2025, ti\u1ebft ki\u1ec7m th\u1eddi gian &amp; chuy\u00ean nghi\u1ec7p h\u01a1n!<\/span><\/p>\n<h2><b>Quick Access &#8211; c\u00f4ng c\u1ee5 t\u1ea1o l\u1ec7nh truy c\u1eadp nhanh<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">M\u1ed9t trong nh\u1eefng <\/span><b>th\u1ee7 thu\u1eadt Excel <\/b><span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi quan t\u00e2m l\u00e0 t\u1ea1o ph\u00edm truy c\u1eadp nhanh t\u1ea1i Quick Access. C\u00f4ng c\u1ee5 n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi d\u00f9ng d\u1ec5 d\u00e0ng th\u00eam thao t\u00e1c, t\u0103ng t\u1ed1c truy c\u1eadp excel nhanh ch\u00f3ng. C\u00e1c b\u01b0\u1edbc t\u1ea1o ph\u00edm nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Truy c\u1eadp Excel tr\u00ean laptop ho\u1eb7c m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Tr\u00ean thanh Toolbar, click chu\u1ed9t \u0111\u1ec3 ch\u1ecdn ph\u1ea7n m\u0169i t\u00ean ch\u0129a xu\u1ed1ng =&gt; click v\u00e0o \u00f4 More Commands \u0111\u1ec3 th\u00eam c\u00e1c t\u00f9y ch\u1ecdn ch\u1ee9c n\u0103ng. Trong c\u1eeda s\u1ed5 Quick Access Toolbar, b\u1ea1n ch\u1ecdn nh\u1eefng t\u00ednh n\u0103ng mu\u1ed1n hi\u1ec3n th\u1ecb l\u00ean thanh c\u00f4ng c\u1ee5 \u0111\u1ec3 truy c\u1eadp nhanh &gt; nh\u1ea5n v\u00e0o &#8220;Add&#8221; \u0111\u1ec3 th\u00eam.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-1-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"alignnone size-full wp-image-242391 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-1.jpg\" alt=\"thu-thuat-Excel-1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-1-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p>B\u01b0\u1edbc 3: Nh\u1ea5n OK \u0111\u1ec3 l\u01b0u.<\/p>\n<h2><b>Th\u1ee7 thu\u1eadt Excel &#8211; th\u00eam \u0111\u01b0\u1eddng ch\u00e9o v\u00e0o \u00f4<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c \u00f4 v\u1edbi \u0111\u01b0\u1eddng ch\u00e9o \u1edf gi\u1eefa \u0111\u1ec3 ng\u0103n c\u00e1ch \u00f4 th\u00e0nh 2 ph\u1ea7n. H\u01b0\u1edbng d\u1eabn chi ti\u1ebft:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean trang t\u00ednh \u0111ang l\u00e0m vi\u1ec7c c\u1ee7a b\u1ea1n, ch\u1ecdn \u00f4 c\u1ea7n ch\u1ec9nh s\u1eeda v\u00e0 click chu\u1ed9t ph\u1ea3i.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn Format Cell &gt; m\u1ed9t c\u1eeda s\u1ed5 m\u1edf ra &gt; ch\u1ecdn v\u00e0o tab &#8220;Border&#8221; v\u00e0 nh\u1ea5n v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng \u0111\u01b0\u1eddng ch\u00e9o (tr\u00e1i ho\u1eb7c ph\u1ea3i, t\u00f9y v\u00e0o nhu c\u1ea7u c\u1ee7a b\u1ea1n).<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-2-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-242392 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-2.jpg\" alt=\"thu-thuat-Excel-2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-2-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n ch\u1ecdn OK \u0111\u1ec3 k\u1ebft th\u00fac vi\u1ec7c t\u1ea1o \u0111\u01b0\u1eddng ch\u00e9o cho \u00f4.<\/span><\/p>\n<h2><b>Th\u00eam c\u1ed9t, h\u00e0ng b\u1eb1ng b\u00e0n ph\u00edm \u0111\u01a1n gi\u1ea3n<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Ch\u1ec9 v\u1edbi v\u00e0i <\/span><b>th\u1ee7 thu\u1eadt Excel <\/b><span style=\"font-weight: 400;\">c\u01a1 b\u1ea3n, ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 c\u00f3 th\u1ec3 th\u00eam ho\u1eb7c b\u1edbt d\u00f2ng c\u1ed9t. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Tr\u00ean trang t\u00ednh hi\u1ec7n t\u1ea1i, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t ho\u1eb7c nhi\u1ec1u h\u00e0ng\/c\u1ed9t b\u1eb1ng c\u00e1ch click chu\u1ed9t, ho\u1eb7c s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm sau \u0111\u00e2y:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n ch\u1ecdn d\u00f2ng, h\u00e3y \u0111\u01b0a con tr\u1ecf chu\u1ed9t \u0111\u1ebfn m\u1ed9t \u00f4 thu\u1ed9c d\u00f2ng \u0111\u00f3 v\u00e0 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u201cshift + space\u201d.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u1ebfu mu\u1ed1n ch\u1ecdn c\u1ed9t, b\u1ea1n c\u0169ng \u0111\u01b0a tr\u1ecf chu\u1ed9t \u0111\u1ebfn \u00f4 thu\u1ed9c c\u1ed9t \u0111\u00f3 v\u00e0 nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u201cctrl + space\u201d.<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-3.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-3-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-3-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"alignnone size-full wp-image-242393 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-3.jpg\" alt=\"thu-thuat-Excel-3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-3.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-3-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-3-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u201cctrl + shift +\u201d \u0111\u1ec3 th\u00eam c\u1ed9t ho\u1eb7c h\u00e0ng ngay c\u1ea1nh c\u1ed9t\/h\u00e0ng \u0111\u00e3 ch\u1ecdn.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-4.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-4-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-4-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242394 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-4.jpg\" alt=\"thu-thuat-Excel-4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-4.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-4-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-4-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u1edbi c\u00e1ch l\u00e0m n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u d\u00f2ng ho\u1eb7c nhi\u1ec1u c\u1ed9t c\u00f9ng 1 l\u00fac b\u1eb1ng c\u00e1ch nh\u1ea5n v\u00e0o n\u00fat m\u0169i t\u00ean di chuy\u1ec3n theo c\u00e1c h\u01b0\u1edbng. Khi \u0111\u00e3 ch\u1ecdn \u0111\u1ee7 c\u00e1c d\u00f2ng\/c\u1ed9t th\u00ec d\u1eebng l\u1ea1i.<\/span><\/p>\n<h2><b>Th\u1ee7 thu\u1eadt sao ch\u00e9p &#8211; di chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u<\/b><\/h2>\n<p>M\u1ed9t th\u1ee7 thu\u1eadt kh\u00e1c trong Excel <span style=\"font-weight: 400;\">\u0111\u01b0\u1ee3c nhi\u1ec1u ng\u01b0\u1eddi s\u1eed d\u1ee5ng ch\u00ednh l\u00e0 sao ch\u00e9p &#8211; di chuy\u1ec3n v\u00f9ng d\u1eef li\u1ec7u. C\u00e1ch th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: T\u1ea1i b\u1ea3ng d\u1eef li\u1ec7u, b\u1ea1n ch\u1ecdn c\u1ed9t d\u1eef li\u1ec7u c\u1ea7n sao ch\u00e9p &gt; di chuy\u1ec3n tr\u1ecf chu\u1ed9t \u0111\u1ebfn v\u00f9ng r\u00eca c\u1ee7a \u00f4 d\u1eef li\u1ec7u \u0111\u1ebfn khi th\u1ea5y bi\u1ec3u t\u01b0\u1ee3ng m\u0169i t\u00ean 4 h\u01b0\u1edbng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242395 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-5.jpg\" alt=\"thu-thuat-Excel-5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: C\u00f3 hai tr\u01b0\u1eddng h\u1ee3p:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n di chuy\u1ec3n c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u th\u00ec c\u1ea7n gi\u1eef chu\u1ed9t v\u00e0 di chuy\u1ec3n \u0111\u1ebfn \u00f4 mu\u1ed1n thi\u1ebft l\u1eadp d\u1eef li\u1ec7u \u0111\u1ebfn.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">N\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p d\u1eef li\u1ec7u th\u00ec nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u201cCtrl\u201d tr\u01b0\u1edbc khi ti\u1ebfn h\u00e0nh k\u00e9o.<\/span><\/li>\n<\/ul>\n<h2><b>Th\u1ee7 thu\u1eadt Excel x\u00f3a \u00f4 tr\u1ed1ng trong v\u00f9ng d\u1eef li\u1ec7u<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi, v\u00f9ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 th\u1ec3 c\u00f3 c\u00e1c \u00f4 tr\u1ed1ng n\u1eb1m xen k\u1ebd v\u1edbi c\u00e1c \u00f4 ch\u1ee9a d\u1eef li\u1ec7u. \u0110\u1ec3 x\u00f3a \u00f4 tr\u1ed1ng n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1ea5n ch\u1ecdn khu v\u1ef1c ch\u1ee9a nh\u1eefng \u00f4 tr\u1ed1ng c\u1ea7n x\u00f3a =&gt; kh\u1edfi ch\u1ea1y hi\u1ec7u \u1ee9ng l\u1ecdc Fiter =&gt; ch\u1ecdn v\u00e0o c\u1ed9t c\u00f3 \u00f4 tr\u1ed1ng c\u1ea7n x\u00f3a v\u00e0 sort =&gt; t\u1ea1i m\u1ee5c Select All, nh\u1ea5n b\u1ecf d\u1ea5u t\u00edch =&gt; nh\u1ea5n d\u1ea5u t\u00edch \u0111\u1ec3 ch\u1ecdn Blank.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-6.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-6-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-6-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242396 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-6.jpg\" alt=\"thu-thuat-Excel-6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-6.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-6-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-6-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: B\u00f4i \u0111en t\u1ea1i v\u1ecb tr\u00ed c\u00f3 \u00f4 tr\u1ed1ng xu\u1ea5t hi\u1ec7n =&gt; nh\u1ea5n ch\u1ecdn chu\u1ed9t ph\u1ea3i v\u00e0 ch\u1ecdn ti\u1ebfp v\u00e0o Delete Rows.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-7.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-7-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-7-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242397 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-7.jpg\" alt=\"thu-thuat-Excel-7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-7.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-7-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-7-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: H\u1ee7y ch\u1ebf \u0111\u1ed9 l\u1ecdc Fiter v\u00e0 nh\u1eadn v\u1ec1 k\u1ebft qu\u1ea3 l\u00e0 v\u00f9ng d\u1eef li\u1ec7u ho\u00e0n thi\u1ec7n.<\/span><\/p>\n<h2><b>S\u1eed d\u1ee5ng Data Validation gi\u00fap gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb nh\u1eadp<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">T\u00e1c d\u1ee5ng c\u1ee7a vi\u1ec7c gi\u1edbi h\u1ea1n gi\u00e1 tr\u1ecb nh\u1eadp l\u00e0 gi\u00fap b\u1ea1n h\u1ea1n ch\u1ebf nh\u1eadp d\u1eef li\u1ec7u sai. <\/span><b>Th\u1ee7 thu\u1eadt Excel<\/b><span style=\"font-weight: 400;\"> c\u01a1 b\u1ea3n n\u00e0y th\u1ef1c hi\u1ec7n nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n =&gt; ch\u1ecdn th\u1ebb Data tr\u00ean thanh c\u00f4ng c\u1ee5 =&gt; ch\u1ecdn v\u00e0o t\u00ednh n\u0103ng Data Validation.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-8.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-8-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-8-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242398 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-8.jpg\" alt=\"thu-thuat-Excel-8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-8.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-8-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-8-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i h\u1ed9p tho\u1ea1i Data Validation:<\/span><\/p>\n<ul>\n<li><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 Allow ch\u1ecdn \u201cWhole Number\u201d \u0111\u1ec3 nh\u1eadp \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb gi\u1edbi h\u1ea1n tr\u00ean v\u00e0 d\u01b0\u1edbi.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 Data ch\u1ecdn \u201cBetwheen\u201d.<\/span><\/li>\n<li><span style=\"font-weight: 400;\">T\u1ea1i \u00f4 Minimum v\u00e0 Maximum, nh\u1eadp gi\u00e1 tr\u1ecb tr\u00ean v\u00e0 d\u01b0\u1edbi (v\u00ed d\u1ee5: 1 \u0111\u1ebfn 20000).<\/span><\/li>\n<\/ul>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-9.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-9-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-9-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242399 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-9.jpg\" alt=\"thu-thuat-Excel-9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-9.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-9-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-9-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1ea5n OK. Khi \u0111\u00f3, s\u1ed1 l\u01b0\u1ee3ng \u00f4 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c gi\u1edbi h\u1ea1n t\u1eeb 1 \u0111\u1ebfn 20000. M\u00e1y s\u1ebd b\u00e1o l\u1ed7i n\u1ebfu ng\u01b0\u1eddi d\u00f9ng nh\u1eadp qu\u00e1 s\u1ed1 l\u01b0\u1ee3ng tr\u00ean.<\/span><\/p>\n<h2><b>T\u0103ng t\u1ed1c \u0111\u1ed9 nh\u1eadp li\u1ec7u b\u1eb1ng c\u00e1ch vi\u1ebft t\u1eaft<\/b><\/h2>\n<p><b>Th\u1ee7 thu\u1eadt Excel <\/b><span style=\"font-weight: 400;\">gi\u00fap t\u0103ng t\u1ed1c \u0111\u1ed9 nh\u1eadp li\u1ec7u r\u1ea5t \u0111\u01a1n gi\u1ea3n, gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m \u0111\u00e1ng k\u1ec3 th\u1eddi gian. Thay v\u00ec ph\u1ea3i g\u00f5 m\u1ed9t c\u00e2u d\u00e0i, ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 thay th\u1ebf b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng g\u00f5 t\u1eaft. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: V\u00e0o File &gt; Options &gt; nh\u1ea5n v\u00e0o tab &#8220;Proofing&#8221; &gt; click ti\u1ebfp v\u00e0o n\u00fat &#8220;AutoCorrect Options&#8221;.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-10.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-10-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-10-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242400 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-10.jpg\" alt=\"thu-thuat-Excel-10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-10.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-10-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-10-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: T\u1ea1i \u00f4 &#8220;With&#8221;, nh\u1eadp n\u1ed9i dung b\u1ea1n mu\u1ed1n thay th\u1ebf b\u1eb1ng t\u1eeb vi\u1ebft t\u1eaft. T\u1ea1i \u00f4 &#8220;Replace&#8221;, nh\u1eadp ch\u1eef vi\u1ebft t\u1eaft t\u01b0\u01a1ng \u1ee9ng.\u00a0<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242407 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg\" alt=\"thu-thuat-Excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">V\u00ed d\u1ee5, b\u1ea1n mu\u1ed1n vi\u1ebft t\u1eaft c\u00e2u \u201cK\u1ebf to\u00e1n\u201d theo d\u1ea1ng &#8220;KT&#8221;. Khi \u0111\u00f3, t\u1ea1i \u00f4 &#8220;With&#8221; s\u1ebd \u0111i\u1ec1n \u201cK\u1ebf to\u00e1n\u201d. T\u1ea1i \u00f4 &#8220;Replace&#8221; s\u1ebd \u0111i\u1ec1n \u201cKT\u201d. Nh\u01b0 v\u1eady, t\u1eeb nay tr\u1edf \u0111i, n\u1ebfu b\u1ea1n mu\u1ed1n nh\u1eadp \u201cK\u1ebf to\u00e1n\u201d th\u00ec ch\u1ec9 c\u1ea7n nh\u1eadp \u201cKT\u201d v\u00e0 nh\u1ea5n Enter, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng chuy\u1ec3n t\u1eeb vi\u1ebft t\u1eaft th\u00e0nh t\u1eeb \u0111\u1ee7 ngh\u0129a.<\/span><\/p>\n<h2><b>Th\u1ee7 thu\u1eadt ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ed9t v\u00e0 h\u00e0ng<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi copy n\u1ed9i dung t\u1eeb sheet n\u00e0y sang sheet kh\u00e1c trong excel, \u0111\u1ed9 r\u1ed9ng d\u00f2ng v\u00e0 c\u1ed9t s\u1ebd b\u1ecb thay \u0111\u1ed5i. Khi \u0111\u00f3, b\u1ea1n h\u00e3y \u00e1p d\u1ee5ng <\/span><b>th\u1ee7 thu\u1eadt Excel<\/b><span style=\"font-weight: 400;\"> nh\u1ecf sau \u0111\u00e2y \u0111\u1ec3 thi\u1ebft l\u1eadp l\u1ea1i k\u00edch th\u01b0\u1edbc:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn c\u1ed9t ho\u1eb7c h\u00e0ng b\u1ea1n mu\u1ed1n t\u00f9y ch\u1ec9nh &gt; v\u00e0o tab &#8220;Home&#8221; &gt; ch\u1ecdn v\u00e0o &#8220;Format&#8221;.<\/span><\/p>\n<p>B\u01b0\u1edbc 2: Ch\u1ecdn v\u00e0o &#8220;Row Height&#8221; n\u1ebfu mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 cao c\u1ee7a h\u00e0ng, v\u00e0 ch\u1ecdn v\u00e0o &#8220;Column Width&#8221; n\u1ebfu mu\u1ed1n \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t.<\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-12.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-12-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-12-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242402 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-12.jpg\" alt=\"thu-thuat-Excel-12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-12.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-12-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-12-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>Th\u1ee7 thu\u1eadt Excel &#8211; x\u00f3a c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u00f4i khi, d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n c\u00f3 nh\u1eefng gi\u00e1 tr\u1ecb d\u1eef li\u1ec7u tr\u00f9ng nhau, v\u00e0 n\u1ebfu b\u1ea1n mu\u1ed1n lo\u1ea1i b\u1ecf c\u00e1c d\u1eef li\u1ec7u tr\u00f9ng l\u1eb7p n\u00e0y, h\u00e3y l\u00e0m theo c\u00e1ch sau \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn v\u00e0 b\u00f4i \u0111en to\u00e0n b\u1ed9 v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n x\u00f3a n\u1ed9i dung tr\u00f9ng l\u1eb7p.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n t\u1ed5 h\u1ee3p ph\u00edm \u201cAlt + A + M\u201d \u0111\u1ec3 m\u1edf h\u1ee3p tho\u1ea1i Remove Dupliacates.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-13-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242403 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-13.jpg\" alt=\"thu-thuat-Excel-13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-13-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Ch\u1ecdn v\u00e0o c\u1ed9t d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n x\u00f3a th\u00f4ng tin tr\u00f9ng l\u1eb7p. Nh\u1ea5n OK l\u00e0 xong.<\/span><\/p>\n<h2><b>Th\u1ee7 thu\u1eadt co gi\u00e3n \u0111\u1ed9 r\u1ed9ng c\u1ed9t v\u00e0 d\u00f2ng khi nh\u1eadp<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi nh\u1eadp d\u1eef li\u1ec7u, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng xuy\u00ean ph\u1ea3i \u0111i\u1ec1u ch\u1ec9nh \u0111\u1ed9 r\u1ed9ng c\u1ed9t v\u00e0 d\u00f2ng ph\u00f9 h\u1ee3p. Thay v\u00ec \u0111i\u1ec1u ch\u1ec9nh sau khi \u0111\u00e3 ho\u00e0n th\u00e0nh vi\u1ec7c c\u1eadp nh\u1eadt th\u00f4ng tin, b\u1ea1n c\u00f3 th\u1ec3 kh\u1edfi \u0111\u1ed9ng ch\u1ebf \u0111\u1ed9 t\u1ef1 \u0111\u1ed9ng co gi\u00e3n d\u00f2ng v\u00e0 c\u1ed9t theo n\u1ed9i dung m\u00ecnh mu\u1ed1n. <\/span><b>Th\u1ee7 thu\u1eadt Excel<\/b><span style=\"font-weight: 400;\"> n\u00e0y l\u00e0m nh\u01b0 sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Click chu\u1ed9t ph\u1ea3i v\u00e0o t\u00ean sheet c\u1ea7n th\u1ef1c hi\u1ec7n =&gt; nh\u1ea5n ch\u1ecdn View code.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-14.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-14-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-14-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242404 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-14.jpg\" alt=\"thu-thuat-Excel-14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-14.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-14-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-14-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n ch\u1ecdn m\u1ee5c Genaral, ch\u1ecdn Worksheet.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: G\u00f5 d\u00f2ng ch\u1eef \u201ccells.EntireColumn. AutoFit\u201d v\u00e0o ch\u1ed7 tr\u1ed1ng. L\u00fac n\u00e0y, \u0111\u1ed9 r\u1ed9ng c\u1ed9t s\u1ebd t\u1ef1 \u0111\u1ed9ng co gi\u00e3n theo d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c nh\u1eadp.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-15-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242405 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-15.jpg\" alt=\"thu-thuat-Excel-15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-15-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn \u0111\u1ed5i ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng trong 3 gi\u00e2y<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Trong Excel, ng\u01b0\u1eddi d\u00f9ng <\/span><span style=\"font-weight: 400;\">c\u00f2n c\u00f3 th\u1ec3 \u0111\u1ed5i ch\u1eef hoa, ch\u1eef th\u01b0\u1eddng nhanh ch\u00f3ng ch\u1ec9 v\u1edbi v\u00e0i h\u00e0m \u0111\u01a1n gi\u1ea3n. C\u00fa ph\u00e1p chuy\u1ec3n \u0111\u1ed5i nh\u01b0 sau:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef c\u00e1i th\u00e0nh ch\u1eef th\u01b0\u1eddng: \u201c=LOWER (&#8230;)\u201d<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 chuy\u1ec3n \u0111\u1ed5i ch\u1eef c\u00e1i th\u00e0nh ch\u1eef in hoa: \u201c=UPPER(&#8230;)\u201d.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">\u0110\u1ec3 vi\u1ebft hoa ch\u1eef c\u00e1i \u0111\u1ea7u trong t\u00ean ri\u00eang: \u201c=PROPER(&#8230;)\u201d.<\/span><\/li>\n<\/ul>\n<h2><b>C\u00e1ch c\u1ed1 \u0111\u1ecbnh d\u00f2ng &#8211; th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi c\u00e1c d\u00f2ng ti\u00eau \u0111\u1ec1, ng\u01b0\u1eddi d\u00f9ng th\u01b0\u1eddng c\u1ed1 \u0111\u1ecbnh d\u00f2ng n\u00e0y cho d\u1ec5 nh\u00ecn. Khi c\u1ed1 \u0111\u1ecbnh d\u00f2ng, d\u00f2ng \u0111\u00f3 s\u1ebd v\u1eabn \u0111\u1ee9ng y\u00ean khi b\u1ea1n l\u01b0\u1edbt chu\u1ed9t l\u00ean xu\u1ed1ng tr\u00ean trang t\u00ednh.<\/span><\/p>\n<p><strong>N\u1ebfu b\u1ea1n mu\u1ed1n c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u1ea7u ti\u00ean trong b\u1ea3ng:<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn m\u1ed9t \u00f4 b\u1ea5t k\u1ef3 trong b\u1ea3ng t\u00ednh c\u1ea7n c\u1ed1 \u0111\u1ecbnh d\u00f2ng.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n ch\u1ecdn View tr\u00ean thanh c\u00f4ng c\u1ee5 =&gt; ch\u1ecdn Freeze Panes =&gt; ch\u1ecdn Freeze Top Row. Sau khi th\u1ef1c hi\u1ec7n, d\u00f2ng \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh s\u1ebd c\u00f3 \u0111\u01b0\u1eddng k\u1ebb \u0111en \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c d\u00f2ng d\u1eef li\u1ec7u kh\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-16-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242406 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-16.jpg\" alt=\"thu-thuat-Excel-16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-16-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>C\u00e1ch c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u d\u00f2ng:<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: K\u00e9o chu\u1ed9t \u0111\u1ebfn t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh. Sau \u0111\u00f3, ch\u1ecdn v\u00e0o \u00f4 \u0111\u1ea7u ti\u00ean n\u1eb1m ph\u00eda d\u01b0\u1edbi c\u1ee7a nh\u00f3m d\u00f2ng c\u1ea7n c\u1ed1 \u0111\u1ecbnh \u0111\u00f3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn th\u1ebb View tr\u00ean thanh ti\u00eau \u0111\u1ec1 =&gt; ch\u1ecdn Freeze Panes =&gt; ch\u1ecdn Freeze Panes. Nh\u01b0 v\u1eady l\u00e0 vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng \u0111\u00e3 xong. C\u00e1c d\u00f2ng n\u00e0y s\u1ebd c\u00f3 \u0111\u01b0\u1eddng k\u1ebb \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c h\u00e0ng kh\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-17-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242407 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg\" alt=\"thu-thuat-Excel-17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-17-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>C\u00e1ch c\u1ed1 \u0111\u1ecbnh c\u1ed9t trong Excel &#8211; th\u1ee7 thu\u1eadt c\u01a1 b\u1ea3n<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">B\u00ean c\u1ea1nh vi\u1ec7c c\u1ed1 \u0111\u1ecbnh d\u00f2ng,<\/span><b> b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 c\u1ed1 \u0111\u1ecbnh h\u00e0ng b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng th\u1ee7 thu\u1eadt Excel <\/b><span style=\"font-weight: 400;\">c\u01a1 b\u1ea3n sau \u0111\u00e2y:<\/span><\/p>\n<p><strong>\u0110\u1ec3 c\u1ed1 \u0111\u1ecbnh c\u1ed9t \u0111\u1ea7u ti\u00ean:\u00a0<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn v\u00e0o \u00f4 b\u1ea5t k\u1ef3 trong sheet b\u1ea3ng t\u00ednh c\u1ea7n c\u1ed1 \u0111\u1ecbnh c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n ch\u1ecdn View tr\u00ean thanh c\u00f4ng c\u1ee5 =&gt; ch\u1ecdn Freeze Panes =&gt; ch\u1ecdn Freeze First Column. Khi \u0111\u00e3 c\u1ed1 \u0111\u1ecbnh xong, \u0111\u01b0\u1eddng k\u1ebb c\u1ee7a c\u1ed9t n\u00e0y s\u1ebd \u0111\u1eadm h\u01a1n so v\u1edbi c\u00e1c c\u1ed9t kh\u00e1c.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-18-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242408 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-18.jpg\" alt=\"thu-thuat-Excel-18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-18-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><strong>\u0110\u1ed1i v\u1edbi vi\u1ec7c c\u1ed1 \u0111\u1ecbnh nhi\u1ec1u c\u1ed9t:<\/strong><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Ch\u1ecdn nh\u00f3m c\u1ed9t c\u1ea7n c\u1ed1 \u0111\u1ecbnh tr\u00ean trang t\u00ednh.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u1ea5n ch\u1ecdn th\u1ebb View tr\u00ean thanh ti\u00eau \u0111\u1ec1 =&gt; ch\u1ecdn Freeze Panes =&gt; ch\u1ecdn Freeze Panes.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-19-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242409 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-19.jpg\" alt=\"thu-thuat-Excel-19\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-19-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>H\u01b0\u1edbng d\u1eabn \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 trong b\u1ea3ng Excel<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Thay v\u00ec \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 th\u1ee7 c\u00f4ng, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1ch \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 t\u1ef1 \u0111\u1ed9ng b\u1eb1ng <\/span><b>th\u1ee7 thu\u1eadt Excel <\/b><span style=\"font-weight: 400;\">c\u01a1 b\u1ea3n sau:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Nh\u1ea5n ch\u1ecdn \u00f4 \u0111\u1ea7u ti\u00ean trong c\u1ed9t mu\u1ed1n \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1 v\u00e0 nh\u1ea5n s\u1ed1 1.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn Fill tr\u00ean thanh \u0111\u1ecbnh d\u1ea1ng =&gt; ch\u1ecdn ti\u1ebfp Series =&gt; tick v\u00e0o \u00f4 Columns n\u1ebfu mu\u1ed1n \u0111i\u1ec1n s\u1ed1 theo h\u00e0ng &#8211; tick v\u00e0o \u00f4 Row n\u1ebfu mu\u1ed1n \u0111i\u1ec1n s\u1ed1 theo c\u1ed9t.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-20.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-20-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-20-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242410 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-20.jpg\" alt=\"thu-thuat-Excel-20\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-20.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-20-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-20-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: Nh\u1eadp gi\u00e1 tr\u1ecb t\u1eeb 1 \u0111\u1ebfn gi\u00e1 tr\u1ecb cu\u1ed1i m\u00e0 b\u1ea1n c\u1ea7n v\u00e0o \u00f4 Step value &#8211; Stop value. Nh\u1ea5n OK \u0111\u1ec3 k\u1ebft th\u00fac quy tr\u00ecnh.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-21.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-21-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-21-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242411 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-21.jpg\" alt=\"thu-thuat-Excel-21\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-21.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-21-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-21-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<h2><b>M\u1eb9o hay t\u00ednh t\u1ed5ng ti\u1ebft ki\u1ec7m th\u1eddi gian<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Thay v\u00ec s\u1eed d\u1ee5ng d\u1ea5u (+) ho\u1eb7c h\u00e0m SUM(), vi\u1ec7c t\u00ednh t\u1ed5ng trong b\u1ea3ng t\u00ednh s\u1ebd \u0111\u01a1n gi\u1ea3n h\u01a1n r\u1ea5t nhi\u1ec1u n\u1ebfu b\u1ea1n bi\u1ebft <\/span>th\u1ee7 thu\u1eadt <span style=\"font-weight: 400;\">sau \u0111\u00e2y:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: B\u00f4i \u0111en v\u00f9ng d\u1eef li\u1ec7u c\u1ea7n t\u00ednh t\u1ed5ng.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-22.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-22-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/08\/thu-thuat-Excel-22-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-242412 aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-22.jpg\" alt=\"thu-thuat-Excel-22\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-22.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-22-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel-22-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Nh\u00ecn v\u00e0o thanh \u1edf cu\u1ed1i tr\u00ean b\u1ea3ng t\u00ednh, b\u1ea1n s\u1ebd bi\u1ebft \u0111\u01b0\u1ee3c t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong v\u00f9ng d\u1eef li\u1ec7u \u0111\u00f3 (Sum), gi\u00e1 tr\u1ecb trung b\u00ecnh (Average) v\u00e0 s\u1ed1 gi\u00e1 tr\u1ecb (Count).<\/span><\/p>\n<h2><b>Th\u1ee7 thu\u1eadt Excel &#8211; H\u01b0\u1edbng d\u1eabn c\u0103n l\u1ec1<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Khi tr\u00ecnh b\u00e0y n\u1ed9i dung trong b\u1ea3ng t\u00ednh, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00e1c th\u1ee7 thu\u1eadt c\u0103n l\u1ec1 \u0111\u1ec3 gi\u00fap n\u1ed9i dung hi\u1ec3n th\u1ecb tr\u1ef1c quan, \u0111\u1eb9p m\u1eaft h\u01a1n. H\u01b0\u1edbng d\u1eabn:<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 1: Chuy\u1ec3n \u0111\u01a1n v\u1ecb \u0111o th\u00e0nh cm: Ch\u1ecdn m\u1ee5c File =&gt; ch\u1ecdn More =&gt; Options =&gt; ch\u1ecdn Advanced =&gt; ch\u1ecdn Centimeters t\u1ea1i Rule units =&gt; nh\u1ea5n OK.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 2: Ch\u1ecdn m\u1ee5c Page Layout =&gt; ch\u1ecdn Margins =&gt; ch\u1ecdn Custom Margins.<\/span><\/p>\n<p><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/Thu-thuat-Excel.5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/Thu-thuat-Excel.5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/07\/Thu-thuat-Excel.5-768x432.jpg.webp 768w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-228663 size-full aligncenter webpexpress-processed\" src=\"http:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/Thu-thuat-Excel.5.jpg\" alt=\"Thu-thuat-Excel.5.jpg\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/Thu-thuat-Excel.5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/Thu-thuat-Excel.5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/07\/Thu-thuat-Excel.5-768x432.jpg 768w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><\/p>\n<p><span style=\"font-weight: 400;\">B\u01b0\u1edbc 3: C\u0103n ch\u1ec9nh l\u1ec1 b\u1eb1ng c\u00e1ch \u0111i\u1ec1n v\u00e0o c\u00e1c th\u00f4ng s\u1ed1 c\u1ea7n thi\u1ebft =&gt; nh\u1ea5n OK \u0111\u1ec3 k\u1ebft th\u00fac quy tr\u00ecnh.<\/span><\/p>\n<h2><span style=\"font-weight: 400;\">50+ Ph\u00edm t\u1eaft Excel th\u00f4ng d\u1ee5ng nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng &amp; k\u1ebf to\u00e1n<\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Ph\u00edm t\u1eaft l\u00e0 &#8220;v\u0169 kh\u00ed b\u00ed m\u1eadt&#8221; gi\u00fap t\u0103ng t\u1ed1c 5x. L\u01b0u ngay danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7:<\/span><\/p>\n<p><b>C\u01a1 b\u1ea3n:<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + A: Ch\u1ecdn to\u00e0n b\u1ed9 d\u1eef li\u1ec7u<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + C\/V\/X: Copy\/Paste\/Cut<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Z\/Y: Undo\/Redo<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + S: L\u01b0u file<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + F\/H: T\u00ecm ki\u1ebfm\/Thay th\u1ebf<\/span><\/li>\n<\/ul>\n<p><b>N\u00e2ng cao (k\u1ebf to\u00e1n hay d\u00f9ng):<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + T: T\u1ea1o Table \u0111\u1ed9ng (PivotTable nhanh)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + =: T\u00ednh t\u1ed5ng t\u1ef1 \u0111\u1ed9ng (SUM nhanh)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + L: L\u1ecdc d\u1eef li\u1ec7u (Filter)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">F4: L\u1eb7p c\u00f4ng th\u1ee9c (Absolute reference)<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + ; \/ Ctrl + Shift + ;: Ng\u00e0y\/gi\u1edd hi\u1ec7n t\u1ea1i<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + F1: T\u1ea1o bi\u1ec3u \u0111\u1ed3 c\u1ed9t nhanh<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + 1: Format Cells<\/span><\/li>\n<\/ul>\n<p><b>VBA &amp; Pivot (pro):<\/b><\/p>\n<ul>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Alt + F11: M\u1edf VBA Editor<\/span><\/li>\n<li style=\"font-weight: 400;\" aria-level=\"1\"><span style=\"font-weight: 400;\">Ctrl + Shift + Enter: Array Formula<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u00c1p d\u1ee5ng ngay \u0111\u1ec3 b\u00e1o c\u00e1o k\u1ebf to\u00e1n si\u00eau t\u1ed1c!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u00a050+ th\u1ee7 thu\u1eadt Excel tr\u00ean gi\u00fap d\u00e2n v\u0103n ph\u00f2ng\/k\u1ebf to\u00e1n l\u00e0m ch\u1ee7 d\u1eef li\u1ec7u. \u00c1p d\u1ee5ng ngay &amp; theo d\u00f5i Ho\u00e0ng H\u00e0 Mobile \u0111\u1ec3 c\u1eadp nh\u1eadt th\u00eam!<\/span><\/p>\n<p><strong>XEM TH\u00caM:<\/strong><\/p>\n<ul>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/cach-ve-bieu-do-tron-trong-excel-don-gian-de-hieu\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 tr\u00f2n trong Excel \u0111\u01a1n gi\u1ea3n, d\u1ec5 hi\u1ec3u<\/a><\/strong><\/li>\n<li><strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/tong-hop-cac-cach-tu-hoc-excel-online\"> T\u1ed5ng h\u1ee3p c\u00e1c c\u00e1ch t\u1ef1 h\u1ecdc Excel online<\/a><\/strong><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>L\u00e0 d\u00e2n v\u0103n ph\u00f2ng hay k\u1ebf to\u00e1n, b\u1ea1n \u0111ang m\u1ea5t h\u00e0ng gi\u1edd cho Excel? 50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &amp; n\u00e2ng cao d\u01b0\u1edbi \u0111\u00e2y s\u1ebd gi\u00fap b\u1ea1n t\u0103ng t\u1ed1c 200%: ph\u00edm t\u1eaft th\u1ea7n t\u1ed1c, PivotTable ph\u00e2n t\u00edch d\u1eef li\u1ec7u, x\u00f3a tr\u00f9ng l\u1eb7p nhanh, t\u1ef1 \u0111\u1ed9ng h\u00f3a b\u00e1o c\u00e1o. \u00c1p d\u1ee5ng ngay \u0111\u1ec3 l\u00e0m ch\u1ee7 [&hellip;]<\/p>\n","protected":false},"author":83,"featured_media":242390,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[28955,16],"tags":[],"class_list":["post-242433","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel","category-thu-thuat"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v24.2 (Yoast SEO v24.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &amp; n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n 2025<\/title>\n<meta name=\"description\" content=\"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &amp; n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &amp; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n\" \/>\n<meta property=\"og:description\" content=\"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &amp; n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-08-10T15:56:05+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2025-12-31T13:40:36+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1200\" \/>\n\t<meta property=\"og:image:height\" content=\"628\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Do Tuyet Nhi\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Do Tuyet Nhi\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"17 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\"},\"author\":{\"name\":\"Do Tuyet Nhi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/528372c2f356ecb548178b99edacaa78\"},\"headline\":\"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &#038; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n\",\"datePublished\":\"2023-08-10T15:56:05+00:00\",\"dateModified\":\"2025-12-31T13:40:36+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\"},\"wordCount\":3162,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg\",\"articleSection\":[\"Excel\",\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#respond\"]}],\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\",\"name\":\"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n 2025\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg\",\"datePublished\":\"2023-08-10T15:56:05+00:00\",\"dateModified\":\"2025-12-31T13:40:36+00:00\",\"description\":\"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg\",\"width\":1200,\"height\":628,\"caption\":\"thu-thuat-Excel\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &#038; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"description\":\"\",\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\",\"name\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png\",\"width\":256,\"height\":37,\"caption\":\"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/528372c2f356ecb548178b99edacaa78\",\"name\":\"Do Tuyet Nhi\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g\",\"caption\":\"Do Tuyet Nhi\"},\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n 2025","description":"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n","og_description":"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-08-10T15:56:05+00:00","article_modified_time":"2025-12-31T13:40:36+00:00","og_image":[{"width":1200,"height":628,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg","type":"image\/jpeg"}],"author":"Do Tuyet Nhi","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Do Tuyet Nhi","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"17 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/"},"author":{"name":"Do Tuyet Nhi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/528372c2f356ecb548178b99edacaa78"},"headline":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &#038; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n","datePublished":"2023-08-10T15:56:05+00:00","dateModified":"2025-12-31T13:40:36+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/"},"wordCount":3162,"commentCount":0,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg","articleSection":["Excel","Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#respond"]}],"copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/","name":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n 2025","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg","datePublished":"2023-08-10T15:56:05+00:00","dateModified":"2025-12-31T13:40:36+00:00","description":"50+ th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n & n\u00e2ng cao cho d\u00e2n v\u0103n ph\u00f2ng, k\u1ebf to\u00e1n: ph\u00edm t\u1eaft nhanh, PivotTable, x\u00f3a tr\u00f9ng l\u1eb7p, t\u1ef1 \u0111\u1ed9ng h\u00f3a. T\u0103ng t\u1ed1c c\u00f4ng vi\u1ec7c 200%! \u00c1p d\u1ee5ng ngay 2025","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/08\/thu-thuat-Excel.jpg","width":1200,"height":628,"caption":"thu-thuat-Excel"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/thu-thuat-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"50+ Th\u1ee7 thu\u1eadt Excel c\u01a1 b\u1ea3n &#038; n\u00e2ng cao nh\u1ea5t 2025 cho d\u00e2n v\u0103n ph\u00f2ng v\u00e0 k\u1ebf to\u00e1n"}]},{"@type":"WebSite","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"","publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/hoanghamobile.com\/tin-tuc\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization","name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","url":"https:\/\/hoanghamobile.com\/tin-tuc\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2021\/12\/logo-text.png","width":256,"height":37,"caption":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"]},{"@type":"Person","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/528372c2f356ecb548178b99edacaa78","name":"Do Tuyet Nhi","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/12dd398f8abe479231672d9ef7fb0a0c?s=96&d=mm&r=g","caption":"Do Tuyet Nhi"},"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/do-tuyet-nhi\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/242433","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/users\/83"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=242433"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/242433\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/242390"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=242433"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=242433"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=242433"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}