{"id":223712,"date":"2023-06-26T09:43:49","date_gmt":"2023-06-26T02:43:49","guid":{"rendered":"https:\/\/hoanghamobile.com\/tin-tuc\/?p=223712"},"modified":"2023-06-26T09:43:49","modified_gmt":"2023-06-26T02:43:49","slug":"cac-ham-excel-co-ban-ma-ban-can-nam-ro","status":"publish","type":"post","link":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/","title":{"rendered":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5"},"content":{"rendered":"<p><span style=\"font-weight: 400;\">B\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel h\u00e0ng ng\u00e0y v\u00e0 mu\u1ed1n t\u0103ng hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c? \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, vi\u1ec7c n\u1eafm v\u1eefng <strong>c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n<\/strong> l\u00e0 m\u1ed9t y\u1ebfu t\u1ed1 v\u00f4 c\u00f9ng quan tr\u1ecdng. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua m\u1ed9t s\u1ed1 h\u00e0m excel th\u00f4ng d\u1ee5ng ng\u00e0y trong b\u00e0i vi\u1ebft sau \u0111\u00e2y.<\/span><\/p>\n<h2><b>T\u1ea7m quan tr\u1ecdng c\u1ee7a vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">Excel kh\u00f4ng ch\u1ec9 \u0111\u01a1n thu\u1ea7n l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 b\u1ea3ng t\u00ednh th\u00f4ng th\u01b0\u1eddng, m\u00e0 n\u00f3 c\u00f2n l\u00e0 m\u1ed9t m\u00f4i tr\u01b0\u1eddng m\u1ea1nh m\u1ebd \u0111\u1ec3 b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p c\u0169ng nh\u01b0 ti\u1ebfn h\u00e0nh ph\u00e2n t\u00edch d\u1eef li\u1ec7u. Theo \u0111\u00f3, <strong>c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n<\/strong> ch\u00ednh l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 quan tr\u1ecdng m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft nh\u01b0 t\u00ednh t\u1ed5ng, t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t\/nh\u1ecf nh\u1ea5t, t\u00ednh trung b\u00ecnh hay \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng,&#8230;<\/span><\/p>\n<figure id=\"attachment_223714\" aria-describedby=\"caption-attachment-223714\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/2-15.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/2-15-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/2-15-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/2-15-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/2-15-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img fetchpriority=\"high\" decoding=\"async\" class=\"wp-image-223714 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 1\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/2-15-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223714\" class=\"wp-caption-text\">C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n ch\u00ednh l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 quan tr\u1ecdng<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">B\u1eb1ng c\u00e1ch \u00e1p d\u1ee5ng <strong>c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n<\/strong> n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p ch\u1ec9 trong v\u00e0i thao t\u00e1c \u0111\u01a1n gi\u1ea3n. \u0110\u1ed3ng th\u1eddi, vi\u1ec7c n\u1eafm v\u1eefng ch\u00fang gi\u00fap b\u1ea1n tr\u00e1nh \u0111\u01b0\u1ee3c nh\u1eefng sai s\u00f3t kh\u00f4ng \u0111\u00e1ng c\u00f3 v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3 sau c\u00f9ng.<\/span><\/p>\n<h2><b>C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n c\u1ea7n ph\u1ea3i n\u1eafm<\/b><\/h2>\n<h3><b>Nh\u1eefng h\u00e0m t\u00ednh to\u00e1n Logic<\/b><\/h3>\n<h4><b>SUM<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUM \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c s\u1ed1 trong m\u1ed9t d\u00e3y, c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t c\u1ed9t-h\u00e0ng, ho\u1eb7c t\u00ednh t\u1ed5ng c\u00e1c \u00f4 d\u1ef1a tr\u00ean m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=SUM(range)&#8221;\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3: \u201crange\u201d l\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/span><\/li>\n<\/ul>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng:<\/b><span style=\"font-weight: 400;\">\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n ch\u1ec9 c\u1ea7n ch\u1ecdn \u00f4 m\u00e0 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3 t\u1ed5ng v\u00e0 nh\u1eadp c\u00f4ng th\u1ee9c &#8220;=SUM()&#8221; v\u00e0o.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Sau \u0111\u00f3, ch\u1ecdn ph\u1ea1m vi c\u00e1c \u00f4 mu\u1ed1n t\u00ednh t\u1ed5ng v\u00e0 k\u1ebft th\u00fac b\u1eb1ng c\u00e1ch nh\u1ea5n Enter. K\u1ebft qu\u1ea3 s\u1ebd \u0111\u01b0\u1ee3c h\u1ec7 th\u1ed1ng t\u1ef1 \u0111\u1ed9ng hi\u1ec3n th\u1ecb.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223715\" aria-describedby=\"caption-attachment-223715\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/3-13.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/3-13-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/3-13-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/3-13-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/3-13-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-223715 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 2\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/3-13-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223715\" class=\"wp-caption-text\">H\u00e0m SUM<\/figcaption><\/figure>\n<h4><b>MIN\/MAX<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m MIN\/MAX \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t\/l\u1edbn nh\u1ea5t trong m\u1ed9t danh s\u00e1ch. C\u1ee5 th\u1ec3 nh\u01b0 theo d\u00f5i bi\u1ebfn \u0111\u1ed9ng gi\u00e1 c\u1ed5 phi\u1ebfu, t\u00ecm gi\u00e1 tr\u1ecb c\u1ef1c \u0111\u1ea1i\/c\u1ef1c ti\u1ec3u c\u1ee7a m\u1ed9t d\u00e3y s\u1ed1 trong m\u1ed9t kho\u1ea3ng th\u1eddi gian nh\u1ea5t \u0111\u1ecbnh,&#8230;.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=MIN(range)&#8221;\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3: &#8220;Range&#8221; \u0111\u1ea1i di\u1ec7n cho ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ecm gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m MAX, b\u1ea1n nh\u1eadp &#8220;=MAX(range)&#8221; v\u00e0 ch\u1ecdn ph\u1ea1m vi t\u01b0\u01a1ng \u1ee9ng.<\/span><\/p>\n<figure id=\"attachment_223716\" aria-describedby=\"caption-attachment-223716\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/4-5.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/4-5-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/4-5-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/4-5-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/4-5-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img decoding=\"async\" class=\"wp-image-223716 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 3\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/4-5-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223716\" class=\"wp-caption-text\">H\u00e0m MIN\/MAX<\/figcaption><\/figure>\n<h4><b>COUNT\/COUNTA<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNT\/COUNTA gi\u00fap b\u1ea1n nhanh ch\u00f3ng x\u00e1c \u0111\u1ecbnh s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb trong d\u1eef li\u1ec7u m\u00e0 kh\u00f4ng c\u1ea7n \u0111\u1ebfm th\u1ee7 c\u00f4ng. \u0110i\u1ec1u n\u00e0y gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m nhi\u1ec1u th\u1eddi gian v\u00e0 \u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=COUNT(range)&#8221;\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3: &#8220;Range&#8221; \u0111\u1ea1i di\u1ec7n cho ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n \u0111\u1ebfm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 c\u00f3 gi\u00e1 tr\u1ecb s\u1ed1 trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">T\u01b0\u01a1ng t\u1ef1, \u0111\u1ec3 s\u1eed d\u1ee5ng h\u00e0m COUNTA, b\u1ea1n nh\u1eadp &#8220;=COUNTA(range)&#8221;.\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y s\u1ebd \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u00f4 kh\u00f4ng tr\u1ed1ng trong ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn, bao g\u1ed3m c\u1ea3 c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb v\u0103n b\u1ea3n, s\u1ed1 v\u00e0 c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223717\" aria-describedby=\"caption-attachment-223717\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/5-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/5-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/5-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/5-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/5-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223717 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 4\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/5-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223717\" class=\"wp-caption-text\">H\u00e0m COUNT\/COUNTA<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng h\u1ecdc vi\u00ean, nh\u00e2n vi\u00ean, s\u1ea3n ph\u1ea9m ho\u1eb7c b\u1ea5t k\u1ef3 danh s\u00e1ch d\u1eef li\u1ec7u n\u00e0o. H\u01a1n n\u1eefa, b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p h\u00e0m n\u00e0y v\u1edbi c\u00e1c \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 \u0111\u1ebfm c\u00e1c \u00f4 th\u1ecfa m\u00e3n \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh.<\/span><\/p>\n<h4><b>AVERAGE<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m AVERAGE gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ednh to\u00e1n gi\u00e1 tr\u1ecb trung b\u00ecnh m\u00e0 kh\u00f4ng c\u1ea7n ph\u1ea3i t\u00ednh to\u00e1n th\u1ee7 c\u00f4ng.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=AVERAGE(range)&#8221;\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Trong \u0111\u00f3: &#8220;Range&#8221; \u0111\u1ea1i di\u1ec7n cho ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">H\u00e0m n\u00e0y s\u1ebd t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong ph\u1ea1m vi v\u00e0 chia cho s\u1ed1 l\u01b0\u1ee3ng c\u00e1c \u00f4 c\u00f3 gi\u00e1 tr\u1ecb trong ph\u1ea1m vi \u0111\u00f3.<\/span><\/li>\n<\/ul>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng:<\/b><span style=\"font-weight: 400;\"> t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a m\u1ed9t danh s\u00e1ch s\u1ed1, gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a doanh thu h\u00e0ng th\u00e1ng, \u0111i\u1ec3m trung b\u00ecnh c\u1ee7a h\u1ecdc vi\u00ean v\u00e0 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c.<\/span><\/p>\n<figure id=\"attachment_223718\" aria-describedby=\"caption-attachment-223718\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/6-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/6-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/6-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/6-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/6-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223718 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 5\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/6-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223718\" class=\"wp-caption-text\">H\u00e0m AVERAGE<\/figcaption><\/figure>\n<h3><b>Nh\u1eefng h\u00e0m \u0111i\u1ec1u ki\u1ec7n Logic<\/b><\/h3>\n<h4><b>COUNTIF<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m COUNTIF \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng \u0111\u1ed1i t\u01b0\u1ee3ng th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n n\u00e0o \u0111\u00f3. V\u00ed d\u1ee5 nh\u01b0 s\u1ed1 h\u1ecdc vi\u00ean \u0111\u1ea1t \u0111i\u1ec3m cao h\u01a1n m\u1ed9t ng\u01b0\u1ee1ng nh\u1ea5t \u0111\u1ecbnh, \u0111\u1ebfm s\u1ed1 l\u01b0\u1ee3ng s\u1ea3n ph\u1ea9m b\u00e1n ra trong m\u1ed9t th\u00e1ng c\u1ee5 th\u1ec3 hay s\u1ed1 l\u01b0\u1ee3ng kh\u00e1ch h\u00e0ng mua nhi\u1ec1u h\u01a1n 1 s\u1ea3n ph\u1ea9m trong th\u00e1ng.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=COUNTIF(range, criteria)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Range&#8221; \u0111\u1ea1i di\u1ec7n cho ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra v\u00e0 \u0111\u1ebfm.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Criteria&#8221; l\u00e0 \u0111i\u1ec1u ki\u1ec7n m\u00e0 \u00f4 c\u1ea7n tho\u1ea3 m\u00e3n \u0111\u1ec3 \u0111\u01b0\u1ee3c \u0111\u1ebfm, c\u00f3 th\u1ec3 l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb, m\u1ed9t bi\u1ec3u th\u1ee9c ho\u1eb7c m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223719\" aria-describedby=\"caption-attachment-223719\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/7-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/7-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/7-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/7-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/7-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223719 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 6\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/7-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223719\" class=\"wp-caption-text\">H\u00e0m COUNTIF<\/figcaption><\/figure>\n<p><b>IF<\/b><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m IF l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 quan tr\u1ecdng gi\u00fap b\u1ea1n th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p \u0111\u00e1nh gi\u00e1 \u0111i\u1ec1u ki\u1ec7n v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean k\u1ebft qu\u1ea3 \u0111\u00e1nh gi\u00e1 \u0111\u00f3.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=IF(condition, value_if_true, value_if_false)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Condition&#8221; l\u00e0 bi\u1ec3u th\u1ee9c ho\u1eb7c \u0111i\u1ec1u ki\u1ec7n m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu \u0111i\u1ec1u ki\u1ec7n \u0111\u00fang, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 &#8220;value_if_true&#8221;, n\u1ebfu \u0111i\u1ec1u ki\u1ec7n sai, h\u00e0m s\u1ebd tr\u1ea3 v\u1ec1 &#8220;value_if_false&#8221;.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223720\" aria-describedby=\"caption-attachment-223720\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/8-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/8-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/8-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/8-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/8-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223720 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 7\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/8-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223720\" class=\"wp-caption-text\">H\u00e0m IF<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">th\u1ef1c hi\u1ec7n ki\u1ec3m tra v\u00e0 tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 d\u1ef1a tr\u00ean \u0111i\u1ec1u ki\u1ec7n nh\u01b0:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n m\u1ed9t gi\u1edbi h\u1ea1n n\u00e0o \u0111\u00f3, hi\u1ec3n th\u1ecb &#8220;\u0110\u1ea1t&#8221;.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">N\u1ebfu gi\u00e1 tr\u1ecb nh\u1ecf h\u01a1n, hi\u1ec3n th\u1ecb &#8220;Kh\u00f4ng \u0111\u1ea1t&#8221;.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t c\u00f4ng th\u1ee9c c\u00f3 nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n ph\u1ee9c t\u1ea1p h\u01a1n.<\/span><\/p>\n<h4><b>SUMIF<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m SUMIF gi\u00fap t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb th\u1ecfa m\u00e3n m\u1ed9t \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5 nh\u01b0 t\u00ednh t\u1ed5ng doanh thu t\u1eeb kh\u00e1ch h\u00e0ng trong m\u1ed9t khu v\u1ef1c c\u1ee5 th\u1ec3, t\u00ednh t\u1ed5ng s\u1ed1 ti\u1ec1n t\u1eeb c\u00e1c \u0111\u01a1n h\u00e0ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n nh\u1ea5t \u0111\u1ecbnh,&#8230;.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=SUMIF(range, criteria, sum_range)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Range&#8221; \u0111\u1ea1i di\u1ec7n cho ph\u1ea1m vi c\u00e1c \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ki\u1ec3m tra theo \u0111i\u1ec1u ki\u1ec7n.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Criteria&#8221; l\u00e0 \u0111i\u1ec1u ki\u1ec7n m\u00e0 \u00f4 c\u1ea7n tho\u1ea3 m\u00e3n \u0111\u1ec3 \u0111\u01b0\u1ee3c t\u00ednh v\u00e0o t\u1ed5ng.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Sum_range&#8221; l\u00e0 ph\u1ea1m vi c\u00e1c \u00f4 ch\u1ee9a c\u00e1c gi\u00e1 tr\u1ecb m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223721\" aria-describedby=\"caption-attachment-223721\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/9-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/9-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/9-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/9-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/9-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223721 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 8\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/9-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223721\" class=\"wp-caption-text\">H\u00e0m SUMIF<\/figcaption><\/figure>\n<h3><b>Nh\u1eefng h\u00e0m s\u1eed d\u1ee5ng trong v\u0103n b\u1ea3n<\/b><\/h3>\n<h4><b>LEFT\/RIGHT\/MID<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">C\u00e1c h\u00e0m LEFT, RIGHT v\u00e0 MID \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ch\u00fang \u0111\u1ec3 tr\u00edch xu\u1ea5t t\u00ean ri\u00eang t\u1eeb h\u1ecd v\u00e0 t\u00ean, l\u1ea5y ng\u00e0y th\u00e1ng t\u1eeb m\u1ed9t chu\u1ed7i ng\u00e0y th\u00e1ng, t\u00e1ch c\u00e1c th\u00e0nh ph\u1ea7n c\u1ee7a m\u1ed9t \u0111\u1ecba ch\u1ec9 email,&#8230;..<\/span><\/p>\n<p><span style=\"font-weight: 400;\">H\u00e0m LEFT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u00ean tr\u00e1i c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=LEFT(text, num_chars)&#8221;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Text&#8221; l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;num_chars&#8221; l\u00e0 s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y t\u1eeb b\u00ean tr\u00e1i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">H\u00e0m RIGHT \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u00ean ph\u1ea3i c\u1ee7a m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.\u00a0<\/span><\/p>\n<figure id=\"attachment_223722\" aria-describedby=\"caption-attachment-223722\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/10-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/10-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/10-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/10-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/10-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223722 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 9\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/10-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223722\" class=\"wp-caption-text\">H\u00e0m LEFT\/RIGHT\/MID<\/figcaption><\/figure>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=RIGHT(text, num_chars)&#8221; v\u00e0o \u00f4 mu\u1ed1n hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Text&#8221; l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;num_chars&#8221; l\u00e0 s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y t\u1eeb b\u00ean ph\u1ea3i.<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">H\u00e0m MID \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 tr\u00edch xu\u1ea5t m\u1ed9t s\u1ed1 k\u00fd t\u1ef1 t\u1eeb v\u1ecb tr\u00ed b\u1ea5t k\u1ef3 trong m\u1ed9t chu\u1ed7i k\u00fd t\u1ef1.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=MID(text, start_num, num_chars)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Text&#8221; l\u00e0 chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;start_num&#8221; l\u00e0 v\u1ecb tr\u00ed b\u1eaft \u0111\u1ea7u tr\u00edch xu\u1ea5t.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;num_chars&#8221; l\u00e0 s\u1ed1 k\u00fd t\u1ef1 mu\u1ed1n l\u1ea5y.<\/span><\/li>\n<\/ul>\n<h4><b>CONCAT<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m CONCAT c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p t\u00ean v\u00e0 h\u1ecd th\u00e0nh t\u00ean \u0111\u1ea7y \u0111\u1ee7, c\u00e1c x\u00e3 huy\u1ec7n t\u1ec9nh th\u00e0nh \u0111\u1ecba ch\u1ec9 ho\u00e0n ch\u1ec9nh v\u00e0 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=CONCAT(text1, text2, &#8230;)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Text1, text2, &#8230;&#8221; l\u00e0 c\u00e1c chu\u1ed7i k\u00fd t\u1ef1 m\u00e0 b\u1ea1n mu\u1ed1n k\u1ebft h\u1ee3p th\u00e0nh m\u1ed9t chu\u1ed7i duy nh\u1ea5t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp c\u00e1c chu\u1ed7i tr\u1ef1c ti\u1ebfp ho\u1eb7c tham chi\u1ebfu \u0111\u1ebfn c\u00e1c \u00f4 ch\u1ee9a chu\u1ed7i.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223723\" aria-describedby=\"caption-attachment-223723\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/11-1.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/11-1-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/11-1-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/11-1-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/11-1-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223723 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 10\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/11-1-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223723\" class=\"wp-caption-text\">H\u00e0m CONCAT<\/figcaption><\/figure>\n<h3><b>Nh\u1eefng h\u00e0m ng\u00e0y th\u00e1ng<\/b><\/h3>\n<h4><b>NOW<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m NOW \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 theo d\u00f5i th\u1eddi gian trong c\u00e1c b\u1ea3ng t\u00ednh Excel. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng n\u00f3 \u0111\u1ec3 ghi l\u1ea1i th\u1eddi gian khi m\u1ed9t s\u1ef1 ki\u1ec7n x\u1ea3y ra, t\u00ednh to\u00e1n kho\u1ea3ng th\u1eddi gian gi\u1eefa hai th\u1eddi \u0111i\u1ec3m, ho\u1eb7c \u0111\u01a1n gi\u1ea3n l\u00e0 \u0111\u1ec3 hi\u1ec3n th\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=NOW()&#8221;\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">Khi b\u1ea1n nh\u1eadp c\u00f4ng th\u1ee9c n\u00e0y, Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i, bao g\u1ed3m c\u1ea3 ng\u00e0y v\u00e0 gi\u1edd.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223724\" aria-describedby=\"caption-attachment-223724\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/12-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/12-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/12-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/12-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/12-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223724 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 11\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/12-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223724\" class=\"wp-caption-text\">H\u00e0m NOW<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o m\u1ed9t h\u1ec7 th\u1ed1ng \u0111\u00e1nh d\u1ea5u th\u1eddi gian khi ghi nh\u1eadn c\u00e1c giao d\u1ecbch, t\u1ea1o b\u00e1o c\u00e1o v\u1ec1 th\u1eddi gian ph\u1ea3n h\u1ed3i c\u1ee7a kh\u00e1ch h\u00e0ng hay theo d\u00f5i th\u1eddi gian th\u1ef1c hi\u1ec7n c\u00e1c c\u00f4ng vi\u1ec7c.<\/span><\/p>\n<h4><b>DATE<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m DATE \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng \u0111\u1ec3 t\u1ea1o ng\u00e0y th\u00e1ng cho c\u00e1c b\u1ea3ng t\u00ednh, t\u00ednh to\u00e1n tu\u1ed5i d\u1ef1a tr\u00ean ng\u00e0y sinh v\u00e0 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c li\u00ean quan \u0111\u1ebfn x\u1eed l\u00fd d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c: <\/b><span style=\"font-weight: 400;\">&#8220;=DATE(year, month, day)&#8221;<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Year&#8221; l\u00e0 gi\u00e1 tr\u1ecb n\u0103m.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;month&#8221; l\u00e0 gi\u00e1 tr\u1ecb th\u00e1ng.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;day&#8221; l\u00e0 gi\u00e1 tr\u1ecb ng\u00e0y m\u00e0 b\u1ea1n mu\u1ed1n t\u1ea1o ra.\u00a0<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223725\" aria-describedby=\"caption-attachment-223725\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/13-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/13-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/13-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/13-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/13-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223725 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 12\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/13-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223725\" class=\"wp-caption-text\">H\u00e0m DATE<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">t\u00ednh s\u1ed1 ng\u00e0y c\u00f2n l\u1ea1i cho \u0111\u1ebfn m\u1ed9t s\u1ef1 ki\u1ec7n quan tr\u1ecdng, t\u00ednh tu\u1ed5i cho t\u1eebng th\u00e0nh vi\u00ean trong danh s\u00e1ch, x\u00e1c \u0111\u1ecbnh ng\u00e0y h\u1ebft h\u1ea1n c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m,&#8230;.<\/span><\/p>\n<h3><b>Nh\u1eefng h\u00e0m tra c\u1ee9u d\u1eef li\u1ec7u<\/b><\/h3>\n<h4><b>VLOOKUP<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m VLOOKUP c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 tra c\u1ee9u th\u00f4ng tin t\u1eeb m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u l\u1edbn, tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng ch\u1ee9a th\u00f4ng tin kh\u00e1ch h\u00e0ng v\u00e0 nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c li\u00ean quan \u0111\u1ebfn t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c: <\/b><span style=\"font-weight: 400;\">&#8220;=VLOOKUP(lookup_value, table_array, col_index_num, range_lookup)&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Lookup_value&#8221; l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;table_array&#8221; l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm trong<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;col_index_num&#8221; l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a c\u1ed9t ch\u1ee9a d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;range_lookup&#8221; l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang ho\u1eb7c ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223726\" aria-describedby=\"caption-attachment-223726\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/14-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/14-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/14-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/14-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/14-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223726 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 13\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/14-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223726\" class=\"wp-caption-text\">H\u00e0m VLOOKUP<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">t\u00ecm ki\u1ebfm m\u00e3 nh\u00e2n vi\u00ean v\u00e0 tr\u00edch xu\u1ea5t th\u00f4ng tin li\u00ean quan, t\u00ecm gi\u00e1 tr\u1ecb trong b\u1ea3ng l\u01b0\u01a1ng d\u1ef1a tr\u00ean m\u00e3 nh\u00e2n vi\u00ean ho\u1eb7c tra c\u1ee9u d\u1eef li\u1ec7u t\u1eeb m\u1ed9t danh s\u00e1ch s\u1ea3n ph\u1ea9m.<\/span><\/p>\n<h4><b>INDEX<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m INDEX c\u00f3 th\u1ec3 truy xu\u1ea5t gi\u00e1 tr\u1ecb t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u ph\u1ee9c t\u1ea1p, t\u1ea1o b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n \u0111\u1ed9ng, truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb nhi\u1ec1u b\u1ea3ng t\u00ednh kh\u00e1c nhau v\u00e0 c\u00e1c tr\u01b0\u1eddng h\u1ee3p kh\u00e1c li\u00ean quan \u0111\u1ebfn truy xu\u1ea5t d\u1eef li\u1ec7u.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:\u00a0 <\/b><span style=\"font-weight: 400;\">&#8220;=INDEX(array, row_num, [column_num])&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Array&#8221; l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u ho\u1eb7c m\u1ea3ng m\u00e0 b\u1ea1n mu\u1ed1n truy xu\u1ea5t gi\u00e1 tr\u1ecb t\u1eeb.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;row_num&#8221; l\u00e0 ch\u1ec9 s\u1ed1 h\u00e0ng c\u1ee7a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;[column_num]&#8221; (t\u00f9y ch\u1ecdn) l\u00e0 ch\u1ec9 s\u1ed1 c\u1ed9t c\u1ee7a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;[column_num]&#8221;, h\u00e0m INDEX s\u1ebd tr\u1ea3 v\u1ec1 c\u1ea3 h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb \u0111\u01b0\u1ee3c tr\u00edch xu\u1ea5t.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223727\" aria-describedby=\"caption-attachment-223727\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/15-2.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/15-2-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/15-2-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/15-2-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/15-2-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223727 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 14\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/15-2-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223727\" class=\"wp-caption-text\">H\u00e0m INDEX<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng:<\/b><span style=\"font-weight: 400;\"> truy xu\u1ea5t s\u1ed1 li\u1ec7u t\u1eeb b\u1ea3ng theo ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t, t\u1ea1o danh s\u00e1ch t\u1eeb c\u00e1c t\u1ec7p d\u1eef li\u1ec7u kh\u00e1c nhau ho\u1eb7c x\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 t\u1eeb c\u00e1c d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c l\u1ecdc.<\/span><\/p>\n<h4><b>MATCH<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m MATCH c\u00f3 nhi\u1ec1u \u1ee9ng d\u1ee5ng trong vi\u1ec7c x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t danh s\u00e1ch, k\u1ebft h\u1ee3p v\u1edbi h\u00e0m INDEX \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng d\u1ef1a tr\u00ean ch\u1ec9 s\u1ed1 t\u00ecm th\u1ea5y,&#8230;.<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c:<\/b><span style=\"font-weight: 400;\"> &#8220;=MATCH(lookup_value, lookup_array, [match_type])&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Lookup_value&#8221; l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;lookup_array&#8221; l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm trong.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;[match_type]&#8221; (t\u00f9y ch\u1ecdn) l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb \u0111\u1ec3 x\u00e1c \u0111\u1ecbnh ki\u1ec3u t\u00ecm ki\u1ebfm:\u00a0<\/span>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">0 ho\u1eb7c kh\u00f4ng c\u00f3 g\u00ec (t\u00ecm ki\u1ebfm ch\u00ednh x\u00e1c)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">1 ho\u1eb7c b\u1ea5t k\u1ef3 s\u1ed1 d\u01b0\u01a1ng (t\u00ecm ki\u1ebfm x\u1ea5p x\u1ec9 l\u1edbn nh\u1ea5t kh\u00f4ng v\u01b0\u1ee3t qu\u00e1 gi\u00e1 tr\u1ecb)<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">-1 ho\u1eb7c b\u1ea5t k\u1ef3 s\u1ed1 \u00e2m (t\u00ecm ki\u1ebfm x\u1ea5p x\u1ec9 nh\u1ecf nh\u1ea5t kh\u00f4ng nh\u1ecf h\u01a1n gi\u00e1 tr\u1ecb).<\/span><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<figure id=\"attachment_223728\" aria-describedby=\"caption-attachment-223728\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/16.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/16-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/16-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/16-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/16-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223728 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 15\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/16-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223728\" class=\"wp-caption-text\">H\u00e0m MATCH<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">t\u00ecm v\u1ecb tr\u00ed c\u1ee7a m\u1ed9t s\u1ea3n ph\u1ea9m trong danh s\u00e1ch gi\u00e1, t\u00ecm ki\u1ebfm ch\u1ec9 s\u1ed1 h\u00e0ng v\u00e0 c\u1ed9t c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong b\u1ea3ng d\u1eef li\u1ec7u ho\u1eb7c x\u00e1c \u0111\u1ecbnh th\u1ee9 t\u1ef1 c\u1ee7a m\u1ed9t gi\u00e1 tr\u1ecb trong m\u1ed9t danh s\u00e1ch s\u1eafp x\u1ebfp.<\/span><\/p>\n<h4><b>HLOOKUP<\/b><\/h4>\n<p><span style=\"font-weight: 400;\">H\u00e0m HLOOKUP d\u00f9ng \u0111\u1ec3 truy xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng ch\u1ee9a th\u00f4ng tin v\u1edbi c\u00e1c ti\u00eau \u0111\u1ec1 h\u00e0ng.\u00a0<\/span><\/p>\n<p><b>C\u00f4ng th\u1ee9c: <\/b><span style=\"font-weight: 400;\">&#8220;=HLOOKUP(lookup_value, table_array, row_index_num, [range_lookup])&#8221;\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;Lookup_value&#8221; l\u00e0 gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;table_array&#8221; l\u00e0 ph\u1ea1m vi d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n t\u00ecm ki\u1ebfm trong.<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;row_index_num&#8221; l\u00e0 s\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a h\u00e0ng ch\u1ee9a gi\u00e1 tr\u1ecb b\u1ea1n mu\u1ed1n tr\u00edch xu\u1ea5t<\/span><\/li>\n<li style=\"font-weight: 400;\"><span style=\"font-weight: 400;\">&#8220;[range_lookup]&#8221; (t\u00f9y ch\u1ecdn) l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb TRUE ho\u1eb7c FALSE \u0111\u1ec3 ch\u1ec9 \u0111\u1ecbnh t\u00ecm ki\u1ebfm g\u1ea7n \u0111\u00fang ho\u1eb7c ch\u00ednh x\u00e1c.<\/span><\/li>\n<\/ul>\n<figure id=\"attachment_223729\" aria-describedby=\"caption-attachment-223729\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/17.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/17-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/17-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/17-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/17-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223729 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 16\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/17-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223729\" class=\"wp-caption-text\">H\u00e0m HLOOKUP<\/figcaption><\/figure>\n<p><b>C\u00e1ch s\u1eed d\u1ee5ng: <\/b><span style=\"font-weight: 400;\">t\u00ecm gi\u00e1 tr\u1ecb c\u1ee7a m\u1ed9t m\u1ee5c trong m\u1ed9t b\u1ea3ng gi\u00e1, truy xu\u1ea5t th\u00f4ng tin t\u1eeb m\u1ed9t b\u1ea3ng l\u01b0\u01a1ng d\u1ef1a tr\u00ean ti\u00eau \u0111\u1ec1 h\u00e0ng c\u1ee7a c\u00e1c c\u1ed9t, ho\u1eb7c tr\u00edch xu\u1ea5t d\u1eef li\u1ec7u t\u1eeb m\u1ed9t b\u1ea3ng ch\u1ee9a th\u00f4ng tin h\u00e0ng h\u00f3a.<\/span><\/p>\n<h2><b>C\u00e1ch t\u00ecm hi\u1ec3u v\u00e0 n\u00e2ng cao k\u1ef9 n\u0103ng v\u1ec1 c\u00e1c h\u00e0m Excel<\/b><\/h2>\n<h3><b>B\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng b\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Trong c\u00e1c b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c h\u00e0nh s\u1eed d\u1ee5ng c\u00e1c h\u00e0m t\u00ednh to\u00e1n nh\u01b0 SUM, AVERAGE, MIN, MAX,&#8230; \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh \u0111\u01a1n gi\u1ea3n tr\u00ean c\u00e1c t\u1eadp d\u1eef li\u1ec7u. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng s\u1ebd t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 \u0111\u1ecbnh d\u1ea1ng \u0111\u1ec3 l\u00e0m cho b\u1ea3ng t\u00ednh c\u1ee7a m\u00ecnh tr\u1edf n\u00ean d\u1ec5 \u0111\u1ecdc v\u00e0 chuy\u00ean nghi\u1ec7p.<\/span><\/p>\n<figure id=\"attachment_223730\" aria-describedby=\"caption-attachment-223730\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/18.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/18-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/18-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/18-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/18-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223730 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 17\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/18-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223730\" class=\"wp-caption-text\">B\u00e0i t\u1eadp excel c\u01a1 b\u1ea3n<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Vi\u1ec7c t\u00ecm ki\u1ebfm b\u00e0i t\u1eadp Excel c\u01a1 b\u1ea3n kh\u00f4ng h\u1ec1 kh\u00f3. B\u1ea1n ch\u1ec9 c\u1ea7n search y\u00eau c\u1ea7u n\u00e0y l\u00ean Google th\u00ec s\u1ebd c\u00f3 h\u00e0ng ng\u00e0n k\u1ebft qu\u1ea3 hi\u1ec7n ra. Ngo\u00e0i ra, b\u1eb1ng vi\u1ec7c b\u1eaft \u0111\u1ea7u v\u1edbi c\u00e1c b\u00e0i t\u1eadp c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng s\u1eed d\u1ee5ng Excel c\u1ee7a m\u00ecnh v\u00e0 kh\u00e1m ph\u00e1 th\u00eam nhi\u1ec1u c\u00f4ng c\u1ee5 h\u1eefu \u00edch kh\u00e1c.<\/span><\/p>\n<h3><b>H\u1ecdc c\u00e1c kh\u00f3a h\u1ecdc Excel c\u01a1 b\u1ea3n tr\u1ef1c tuy\u1ebfn<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Trong th\u1eddi \u0111\u1ea1i c\u00f4ng ngh\u1ec7 hi\u1ec7n nay, vi\u1ec7c h\u1ecdc tr\u1ef1c tuy\u1ebfn mang l\u1ea1i r\u1ea5t nhi\u1ec1u l\u1ee3i \u00edch t\u1eeb s\u1ef1 linh ho\u1ea1t v\u1ec1 th\u1eddi gian cho \u0111\u1ebfn s\u1ef1 \u0111a d\u1ea1ng v\u1ec1 t\u00e0i li\u1ec7u v\u00e0 ngu\u1ed3n h\u1ecdc. Theo \u0111\u00f3, c\u00e1c kh\u00f3a h\u1ecdc Excel c\u01a1 b\u1ea3n tr\u1ef1c tuy\u1ebfn cung c\u1ea5p cho b\u1ea1n c\u01a1 h\u1ed9i h\u1ecdc t\u1eadp t\u1eeb c\u00e1c chuy\u00ean gia v\u00e0 gi\u1ea3ng vi\u00ean c\u00f3 kinh nghi\u1ec7m.\u00a0<\/span><\/p>\n<figure id=\"attachment_223731\" aria-describedby=\"caption-attachment-223731\" style=\"width: 800px\" class=\"wp-caption aligncenter\"><picture><source srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/19.jpg.webp 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/19-300x169.jpg.webp 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/19-768x432.jpg.webp 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/19-696x392.jpg.webp 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/webp-express\/webp-images\/uploads\/2023\/06\/19-747x420.jpg.webp 747w\" sizes=\"(max-width: 800px) 100vw, 800px\" type=\"image\/webp\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-223731 size-full webpexpress-processed\" src=\"https:\/\/cdn1.hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19.jpg\" alt=\"c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n - \u1ea3nh 18\" width=\"800\" height=\"450\" srcset=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19.jpg 800w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19-300x169.jpg 300w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19-768x432.jpg 768w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19-696x392.jpg 696w, https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/19-747x420.jpg 747w\" sizes=\"(max-width: 800px) 100vw, 800px\"><\/picture><figcaption id=\"caption-attachment-223731\" class=\"wp-caption-text\">Kh\u00f3a h\u1ecdc Excel tr\u1ef1c tuy\u1ebfn<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi ho\u00e0n th\u00e0nh c\u00e1c kh\u00f3a h\u1ecdc Excel tr\u1ef1c tuy\u1ebfn, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t \u201cngu\u1ed3n v\u1ed1n\u201d ki\u1ebfn th\u1ee9c v\u00e0 k\u1ef9 n\u0103ng th\u1ef1c t\u1ebf \u0111\u1ec3 x\u1eed l\u00fd c\u00e1c t\u00e1c v\u1ee5 Excel ph\u1ee9c t\u1ea1p. \u0110i\u1ec1u n\u00e0y s\u1ebd m\u1edf ra nhi\u1ec1u c\u01a1 h\u1ed9i ngh\u1ec1 nghi\u1ec7p v\u00e0 gi\u00fap b\u1ea1n n\u00e2ng cao hi\u1ec7u su\u1ea5t trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y.\u00a0<\/span><\/p>\n<h3><b>Th\u1ef1c h\u00e0nh v\u00e0 \u00e1p d\u1ee5ng trong c\u00f4ng vi\u1ec7c th\u1ef1c t\u1ebf<\/b><\/h3>\n<p><span style=\"font-weight: 400;\">Thay v\u00ec ch\u1ec9 h\u1ecdc l\u00fd thuy\u1ebft, vi\u1ec7c th\u1ef1c h\u00e0nh v\u00e0 \u00e1p d\u1ee5ng c\u00e1c h\u00e0m v\u00e0o c\u00e1c t\u00ecnh hu\u1ed1ng th\u1ef1c t\u1ebf s\u1ebd gi\u00fap b\u1ea1n x\u00e2y d\u1ef1ng s\u1ef1 t\u1ef1 tin v\u00e0 th\u00e0nh th\u1ea1o trong vi\u1ec7c s\u1eed d\u1ee5ng Excel trong c\u00f4ng vi\u1ec7c.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Th\u00eam v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 c\u01a1 h\u1ed9i ti\u1ebfp c\u1eadn v\u1edbi c\u00e1c b\u00e0i t\u1eadp v\u00e0 v\u00ed d\u1ee5 th\u1ef1c t\u1ebf t\u1eeb vi\u1ec7c t\u00ednh to\u00e1n s\u1ed1 li\u1ec7u, ph\u00e2n t\u00edch d\u1eef li\u1ec7u \u0111\u1ebfn tr\u00ecnh b\u00e0y th\u00f4ng tin m\u1ed9t c\u00e1ch r\u00f5 r\u00e0ng. B\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c th\u1eed nghi\u1ec7m v\u00e0 t\u00ecm hi\u1ec3u c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c h\u00e0m nh\u01b0 SUM, AVERAGE, MIN, MAX, COUNT,&#8230; v\u00e0 nhi\u1ec1u h\u00e0m kh\u00e1c \u0111\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c t\u00e1c v\u1ee5 v\u00e0 t\u00ednh to\u00e1n ph\u1ee9c t\u1ea1p.<\/span><\/p>\n<h2><b>K\u1ebft lu\u1eadn<\/b><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1edbi <strong>c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n<\/strong> m\u00e0 Ho\u00e0ng H\u00e0 Mobile \u0111\u00e3 t\u1ed5ng h\u1ee3p ch\u00ednh l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 h\u1eefu \u00edch cho vi\u1ec7c t\u00ednh to\u00e1n, th\u1ed1ng k\u00ea v\u00e0 t\u00ecm ki\u1ebfm d\u1eef li\u1ec7u d\u1ec5 d\u00e0ng h\u01a1n. \u0110i\u1ec1u n\u00e0y c\u00f2n c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n tr\u1edf th\u00e0nh m\u1ed9t chuy\u00ean gia Excel, c\u00f3 kh\u1ea3 n\u0103ng thao t\u00e1c linh ho\u1ea1t tr\u00ean b\u1ea3ng t\u00ednh v\u00e0 \u0111\u1ea1t \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 t\u1ed1t nh\u1ea5t trong c\u00f4ng vi\u1ec7c. B\u00ean c\u1ea1nh \u0111\u00f3, b\u1ea1n c\u0169ng \u0111\u1eebng qu\u00ean t\u00ecm hi\u1ec3u th\u00eam nh\u1eefng th\u00f4ng tin, th\u1ee7 thu\u1eadt h\u1eefu \u00edch h\u01a1n trong cu\u1ed9c s\u1ed1ng v\u00e0 c\u00f4ng vi\u1ec7c ng\u00e0y t\u1ea1i: <strong><a href=\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/kham-pha\">https:\/\/hoanghamobile.com\/tin-tuc\/category\/kham-pha<\/a><\/strong><\/span><\/p>\n","protected":false},"excerpt":{"rendered":"<p>B\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi Excel h\u00e0ng ng\u00e0y v\u00e0 mu\u1ed1n t\u0103ng hi\u1ec7u su\u1ea5t c\u00f4ng vi\u1ec7c? \u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c ph\u00e9p t\u00ednh ph\u1ee9c t\u1ea1p v\u00e0 x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c, vi\u1ec7c n\u1eafm v\u1eefng c\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 m\u1ed9t y\u1ebfu t\u1ed1 v\u00f4 c\u00f9ng quan tr\u1ecdng. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng [&hellip;]<\/p>\n","protected":false},"author":65,"featured_media":223713,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[16],"tags":[],"class_list":["post-223712","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","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>C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 - Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile<\/title>\n<meta name=\"description\" content=\"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y\" \/>\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\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5\" \/>\n<meta property=\"og:description\" content=\"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y\" \/>\n<meta property=\"og:url\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\" \/>\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:author\" content=\"https:\/\/www.facebook.com\/hoanghamobilecom\" \/>\n<meta property=\"article:published_time\" content=\"2023-06-26T02:43:49+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"800\" \/>\n\t<meta property=\"og:image:height\" content=\"450\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Vo Giang\" \/>\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=\"Vo Giang\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\n\t<meta name=\"twitter:data2\" content=\"21 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\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\"},\"author\":{\"name\":\"Vo Giang\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/1dbf45f7c12e8c56d4c60fdc934ee23c\"},\"headline\":\"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5\",\"datePublished\":\"2023-06-26T02:43:49+00:00\",\"dateModified\":\"2023-06-26T02:43:49+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\"},\"wordCount\":4202,\"publisher\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg\",\"articleSection\":[\"Th\u1ee7 thu\u1eadt\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2023\",\"copyrightHolder\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#organization\"}},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\",\"name\":\"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 - Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile\",\"isPartOf\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg\",\"datePublished\":\"2023-06-26T02:43:49+00:00\",\"dateModified\":\"2023-06-26T02:43:49+00:00\",\"description\":\"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y\",\"breadcrumb\":{\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage\",\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg\",\"contentUrl\":\"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg\",\"width\":800,\"height\":450,\"caption\":\"1\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Trang ch\u1ee7\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Th\u1ee7 thu\u1eadt\",\"item\":\"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/\"},{\"@type\":\"ListItem\",\"position\":3,\"name\":\"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5\"}]},{\"@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\/1dbf45f7c12e8c56d4c60fdc934ee23c\",\"name\":\"Vo Giang\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g\",\"caption\":\"Vo Giang\"},\"description\":\"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.\",\"sameAs\":[\"https:\/\/www.facebook.com\/hoanghamobilecom\"],\"url\":\"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 - Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","description":"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y","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\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/","og_locale":"vi_VN","og_type":"article","og_title":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5","og_description":"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y","og_url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/","og_site_name":"Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","article_publisher":"https:\/\/www.facebook.com\/hoanghamobilecom","article_author":"https:\/\/www.facebook.com\/hoanghamobilecom","article_published_time":"2023-06-26T02:43:49+00:00","og_image":[{"width":800,"height":450,"url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg","type":"image\/jpeg"}],"author":"Vo Giang","twitter_card":"summary_large_image","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Vo Giang","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"21 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#article","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/"},"author":{"name":"Vo Giang","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/1dbf45f7c12e8c56d4c60fdc934ee23c"},"headline":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5","datePublished":"2023-06-26T02:43:49+00:00","dateModified":"2023-06-26T02:43:49+00:00","mainEntityOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/"},"wordCount":4202,"publisher":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg","articleSection":["Th\u1ee7 thu\u1eadt"],"inLanguage":"vi","copyrightYear":"2023","copyrightHolder":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#organization"}},{"@type":"WebPage","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/","url":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/","name":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5 - Tin t\u1ee9c c\u00f4ng ngh\u1ec7 - HoangHaMobile","isPartOf":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage"},"image":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage"},"thumbnailUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg","datePublished":"2023-06-26T02:43:49+00:00","dateModified":"2023-06-26T02:43:49+00:00","description":"C\u00e1c h\u00e0m Excel c\u01a1 b\u1ea3n l\u00e0 ki\u1ebfn th\u1ee9c m\u00e0 b\u1ea5t k\u1ef3 ai l\u00e0m c\u00f4ng vi\u1ec7c v\u0103n ph\u00f2ng c\u0169ng n\u00ean bi\u1ebft. V\u00ec v\u1eady, h\u00e3y c\u00f9ng Ho\u00e0ng H\u00e0 Mobile \u0111i\u1ec3m qua ch\u00fang trong b\u00e0i vi\u1ebft sau \u0111\u00e2y","breadcrumb":{"@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#primaryimage","url":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg","contentUrl":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-content\/uploads\/2023\/06\/1-15.jpg","width":800,"height":450,"caption":"1"},{"@type":"BreadcrumbList","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/cac-ham-excel-co-ban-ma-ban-can-nam-ro\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Trang ch\u1ee7","item":"https:\/\/hoanghamobile.com\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"Th\u1ee7 thu\u1eadt","item":"https:\/\/hoanghamobile.com\/tin-tuc\/category\/thu-thuat\/"},{"@type":"ListItem","position":3,"name":"C\u00e1c h\u00e0m excel c\u01a1 b\u1ea3n m\u00e0 b\u1ea1n c\u1ea7n n\u1eafm r\u00f5"}]},{"@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\/1dbf45f7c12e8c56d4c60fdc934ee23c","name":"Vo Giang","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/hoanghamobile.com\/tin-tuc\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/b985c49235fa8fa4ce5f8cc9fa149e97?s=96&d=mm&r=g","caption":"Vo Giang"},"description":"M\u00ecnh l\u00e0 Giang, m\u1ed9t ng\u01b0\u1eddi k\u1ec3 chuy\u1ec7n c\u00f4ng ngh\u1ec7, ch\u1ecdn c\u00e1ch tr\u1ea3i nghi\u1ec7m v\u00e0 chia s\u1ebb nh\u1eefng gi\u1ea3i ph\u00e1p th\u1ef1c t\u1ebf. V\u1edbi m\u00ecnh, m\u1ed9t thi\u1ebft b\u1ecb t\u1ed1t ch\u1ec9 khi n\u00f3 th\u1ef1c s\u1ef1 l\u00e0m cho cu\u1ed9c s\u1ed1ng h\u00e0ng ng\u00e0y c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng v\u00e0 th\u00fa v\u1ecb h\u01a1n.","sameAs":["https:\/\/www.facebook.com\/hoanghamobilecom"],"url":"https:\/\/hoanghamobile.com\/tin-tuc\/author\/giang-vo\/"}]}},"_links":{"self":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/223712","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\/65"}],"replies":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/comments?post=223712"}],"version-history":[{"count":0,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/posts\/223712\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media\/223713"}],"wp:attachment":[{"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/media?parent=223712"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/categories?post=223712"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/hoanghamobile.com\/tin-tuc\/wp-json\/wp\/v2\/tags?post=223712"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}