{"id":10955,"date":"2025-01-15T00:51:35","date_gmt":"2025-01-15T00:51:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-chi-tiet-cach-tao-lap-ban-do-nhiet-trong-excel\/"},"modified":"2025-01-15T00:51:35","modified_gmt":"2025-01-15T00:51:35","slug":"huong-dan-chi-tiet-cach-tao-lap-ban-do-nhiet-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/huong-dan-chi-tiet-cach-tao-lap-ban-do-nhiet-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch t\u1ea1o l\u1eadp b\u1ea3n \u0111\u1ed3 nhi\u1ec7t trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi b\u1ea1n kh\u00e1i ni\u1ec7m b\u1ea3n \u0111\u1ed3 nhi\u1ec7t trong Excel v\u00e0 c\u00e1ch b\u01b0\u1edbc chi ti\u1ebft \u0111\u1ec3 t\u1ea1o l\u1eadp b\u1ea3n \u0111\u1ed3 nhi\u1ec7t. M\u00e0u s\u1eafc c\u1ee7a b\u1ea3n \u0111\u1ed3 nhi\u1ec7t s\u1ebd \u1ea3nh h\u01b0\u1edfng r\u1ea5t l\u1edbn \u0111\u1ec3 t\u00ednh hi\u1ec7u qu\u1ea3 m\u00e0 bi\u1ec3u \u0111\u1ed3 mang l\u1ea1i.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9879 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/step-by-step-guide-to-creating-excel-heat-map.png\" width=\"560\" height=\"315\" title=\"step-by-step-guide-to-creating-excel-heat-map\"><\/p>\n<p style=\"text-align: justify\"><strong>Kh\u00e1i ni\u1ec7m b\u1ea3n \u0111\u1ed3 nhi\u1ec7t<\/strong><\/p>\n<p style=\"text-align: justify\">Theo \u0111\u1ecbnh ngh\u0129a c\u1ee7a Wikipedia, b\u1ea3n \u0111\u1ed3 nhi\u1ec7t l\u00e0 m\u1ed9t d\u1ea1ng bi\u1ec3u \u0111\u1ed3 minh h\u1ecda s\u1ed1 li\u1ec7u trong \u0111\u00f3 t\u1eebng gi\u00e1 tr\u1ecb \u0111\u1ea1i l\u01b0\u1ee3ng \u0111\u01b0\u1ee3c bi\u1ec3u th\u1ecb b\u1eb1ng 1 lo\u1ea1i m\u00e0u s\u1eafc kh\u00e1c nhau. N\u00f3i c\u00e1ch kh\u00e1c, \u0111\u00e2y l\u00e0 m\u1ed9t d\u1ea1ng bi\u1ec3u \u0111\u1ed3 ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u c\u00f3 s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a m\u00e0u s\u1eafc v\u00e0 c\u00e1c ti\u00eau ch\u00ed \u0111i\u1ec1u ki\u1ec7n r\u00e0ng bu\u1ed9c.<\/p>\n<p style=\"text-align: justify\">Tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u x\u00e2y d\u1ef1ng bi\u1ec3u \u0111\u1ed3 n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i n\u1eafm v\u1eefng m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c li\u00ean quan \u0111\u1ebfn vi\u1ec7c co d\u00e3n chi\u1ec1u r\u1ed9ng c\u1ee7a c\u1ed9t\/h\u00e0ng, \u0111\u1ecbnh d\u1ea1ng bi\u1ec3u \u0111\u1ed3 c\u01a1 b\u1ea3n, c\u00e1ch s\u1eafp x\u1ebfp s\u1ed1 li\u1ec7u theo b\u1ea3ng, \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 c\u00e1ch s\u1eed d\u1ee5ng, ngo\u00e0i ra n\u1ebfu nh\u01b0 s\u1ed1 li\u1ec7u \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp kh\u00f4ng theo th\u1ee9 t\u1ef1 c\u1ee5 th\u1ec3 th\u00ec b\u1ea1n c\u00f2n c\u1ea7n ph\u1ea3i n\u1eafm \u0111\u01b0\u1ee3c c\u00e1c c\u00f4ng th\u1ee9c quy \u0111\u1ecbnh k\u00fd t\u1ef1 ch\u1eef trong Excel.<\/p>\n<p style=\"text-align: justify\">H\u01b0\u1edbng d\u1eabn chi ti\u1ebft c\u00e1ch l\u1eadp bi\u1ec3u \u0111\u1ed3:<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, ta s\u1ebd s\u1eed d\u1ee5ng s\u1ed1 li\u1ec7u v\u1ec1 chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng kinh doanh c\u1ee7a ng\u00e0nh b\u00e1n l\u1ebb \u1edf M\u1ef9 v\u00e0 nhi\u1ec7m v\u1ee5 c\u1ee7a ch\u00fang ta l\u00e0 x\u00e1c \u0111\u1ecbnh nh\u1eefng \u0111\u1eb7c \u0111i\u1ec3m v\u00e0 xu h\u01b0\u1edbng n\u1ed5i b\u1eadt \u0111\u1ec3 ph\u00e2n t\u00edch.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 1: \u0110\u1ec3 n\u1eafm \u0111\u01b0\u1ee3c xu h\u01b0\u1edbng ph\u00e2n b\u1ed1 s\u1ed1 li\u1ec7u theo t\u1eebng n\u0103m, ta c\u1ea7n ph\u1ea3i s\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch ch\u1ec9 l\u1ef1a ch\u1ecdn d\u1eef li\u1ec7u theo h\u00e0ng m\u00e0 th\u00f4i.<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-245.gif\" title=\"ex101_92019-nho-245\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">Ch\u1eb3ng h\u1ea1n, \u0111\u1ec3 ki\u1ec3m tra t\u00ecnh h\u00ecnh chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng kinh doanh c\u1ee7a GAFO, b\u1ea1n ch\u1ec9 c\u1ea7n b\u00f4i \u0111en d\u1ea3i \u00f4 t\u1eeb C5 \u0111\u1ebfn K5<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9880 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-1.png\" width=\"996\" height=\"118\" title=\"excel-heat-map-example-1\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 2: B\u1eaft \u0111\u1ea7u v\u1edbi h\u00e0ng \u0111\u1ea7u ti\u00ean: C3:K3<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn Conditional Formatting -&gt; Color Scales -&gt; Ch\u1ecdn b\u1ea3ng m\u00e0u \u0110\u1ecf-V\u00e0ng-Xanh l\u00e1<\/p>\n<p style=\"text-align: justify\">M\u00e0u \u0111\u1ecf \u0111\u1ea1i di\u1ec7n cho gi\u00e1 tr\u1ecb cao nh\u1ea5t<\/p>\n<p style=\"text-align: justify\">M\u00e0u v\u00e0ng \u0111\u1ea1i di\u1ec7n cho gi\u00e1 tr\u1ecb n\u1eb1m gi\u1eefa<\/p>\n<p style=\"text-align: justify\">M\u00e0u xanh l\u00e1 \u0111\u1ea1i di\u1ec7n cho gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9882 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-1-2.png\" width=\"730\" height=\"366\" title=\"excel-heat-map-example-1-2\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 3: M\u1eb7c \u0111\u1ecbnh ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng Excel th\u01b0\u1eddng t\u1eadn d\u1ee5ng c\u00e1c m\u00e0u t\u1ed1i, v\u00ec v\u1eady khi b\u1ea1n ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng cho t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng th\u00ec b\u1ea3n \u0111\u1ed3 nhi\u1ec7t s\u1ebd tr\u1edf n\u00ean kh\u00e1 kh\u00f3 nh\u00ecn.<\/p>\n<p style=\"text-align: justify\">V\u00ec v\u1eady, h\u00e3y th\u1eed thay \u0111\u1ed5i m\u1ed9t ch\u00fat b\u1eb1ng c\u00e1ch \u0111\u1ea9y m\u00e0u s\u00e1ng h\u01a1n v\u00e0 nh\u1ea1t \u0111i.<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn d\u1ea3i \u00f4 C3:K3 -&gt; T\u00ecm \u0111\u1ebfn ph\u00edm Conditional Formatting -&gt; Manage Rules -&gt; Edit Rule<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9885 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-3.png\" width=\"522\" height=\"364\" title=\"excel-heat-map-example-3\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi gi\u00e1 tr\u1ecb th\u1ea5p nh\u1ea5t, Click v\u00e0o h\u1ed9p tho\u1ea3i x\u1ed5 xu\u1ed1ng -&gt; Ch\u1ecdn b\u1ea5t c\u1ee9 m\u00e0u s\u1eafc n\u00e0o m\u00e0 b\u1ea1n th\u00edch, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ta ch\u1ecdn m\u00e0u xanh l\u00e1 c\u00e2y nh\u1ea1t<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi gi\u00e1 tr\u1ecb trung b\u00ecnh, Ta ch\u1ecdn m\u00e0u v\u00e0ng nh\u1ea1t<\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi gi\u00e1 tr\u1ecb cao nh\u1ea5t l\u00e0 m\u00e0u \u0111\u1ecf nh\u1ea1t.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 4: Sau khi ho\u00e0n t\u1ea5t vi\u1ec7c thi\u1ebft l\u1eadp m\u00e0u s\u1eafc cho ph\u00f9 h\u1ee3p, ta s\u1ebd \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n cho to\u00e0n b\u1ed9 t\u1ea5t c\u1ea3 c\u00e1c d\u00f2ng.<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn l\u1ea1i d\u1ea3i \u00f4 C3:K3 -&gt; Click \u0111\u00fap v\u00e0o l\u1ef1a ch\u1ecdn Format Painter. Ti\u1ebfp \u0111\u1ebfn b\u1ea1n t\u00ecm \u0111\u1ebfn t\u1eebng d\u00f2ng, b\u00f4i \u0111\u1eadm v\u00e0 click chu\u1ed9t tr\u00e1i \u0111\u1ec3 \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng m\u1edbi. C\u1ee9 th\u1ebf cho \u0111\u1ebfn d\u00f2ng cu\u1ed1i c\u00f9ng.<\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: Kh\u00f4ng n\u00ean l\u1ef1a ch\u1ecdn to\u00e0n b\u1ed9 d\u1ea3i \u00f4 c\u00f9ng 1 l\u00fac trong qu\u00e1 tr\u00ecnh sao ch\u00e9p \u0111\u1ecbnh d\u1ea1ng, v\u00ec \u0111i\u1ec1u \u0111\u00f3 s\u1ebd l\u00e0m \u0111\u1ea3o l\u1ed9n tr\u1eadt t\u1ef1 ph\u00e9p to\u00e1n logic.<\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 5: Ta s\u1ebd thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng g\u1ed1c m\u1ed9t ch\u00fat<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9886 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-4.png\" width=\"1022\" height=\"298\" title=\"excel-heat-map-example-4\"><\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn to\u00e0n b\u1ed9 d\u1ea3i \u00f4 v\u00e0 x\u00f3a \u0111i \u0111\u01b0\u1eddng k\u1ebb vi\u1ec1n.<\/li>\n<li>Click v\u00e0o ph\u1ea7n Thick Box Border v\u00e0 ch\u1ec9 l\u1ef1a ch\u1ecdn vi\u1ec1n bao ngo\u00e0i th\u00f4i<\/li>\n<li>B\u00f4i \u0111\u1eadm to\u00e0n b\u1ed9 c\u00e1c c\u1ed9t C:K -&gt; \u0110\u1eb7t \u0111\u1ed9 r\u1ed9ng c\u1ee7a c\u1ed9t l\u00e0 7.<\/li>\n<li>B\u00f4i \u0111\u1eadm c\u00e1c d\u00f2ng t\u1eeb 3 \u2013 49 -&gt; Ch\u1ecdn \u0111\u1ed9 cao c\u1ee7a d\u00f2ng l\u00e0 25<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9887 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-5.png\" width=\"834\" height=\"296\" title=\"excel-heat-map-example-5\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc 6: Ta s\u1ebd ch\u1ec9nh s\u1eeda th\u00eam 1 ch\u00fat v\u1ec1 font ch\u1eef c\u0169ng nh\u01b0 k\u00edch c\u1ee1 ch\u1eef<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn d\u1ea3i \u00f4 B3:K49 -&gt; T\u00ean font ch\u1eef -&gt; Ch\u1ecdn font l\u00e0 Bell MT (ho\u1eb7c b\u1ea5t c\u1ee9 font ch\u1eef n\u00e0o c\u00f3 n\u00e9t thanh m\u00e0 b\u1ea1n th\u00edch) -&gt; C\u1ee1 ch\u1eef \u0111\u1ec3 l\u00e0 12<\/li>\n<li>Ch\u1ecdn d\u1ea3i \u00f4 C3: K49 -&gt; Ch\u1ecdn Alignment -&gt; C\u0103n l\u1ec1 gi\u1eefa<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Sau khi ho\u00e0n t\u1ea5t, ta s\u1ebd c\u00f3 m\u1ed9t b\u1ea3n \u0111\u1ed3 nhi\u1ec7t ho\u00e0n ch\u1ec9nh nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9888 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/creating-excel-heat-map.png\" width=\"813\" height=\"1633\" title=\"creating-excel-heat-map\"><\/p>\n<p><strong>Ph\u00e2n t\u00edch s\u1ed1 li\u1ec7u v\u00e0 l\u00fd gi\u1ea3i nguy\u00ean nh\u00e2n<\/strong><\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 1: D\u1ef1a tr\u00ean bi\u1ec3u \u0111\u1ed3 tr\u00ean, ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng kinh doanh c\u1ee7a c\u00e1c c\u1eeda h\u00e0ng d\u01b0\u1ee3c ph\u1ea9m v\u00e0 ch\u0103m s\u00f3c s\u1ee9c kh\u1ecfe (Health and personal care stores) c\u00f3 xu h\u01b0\u1edbng t\u0103ng l\u00ean d\u1ea7n \u0111\u1ec1u (\u0111\u01b0\u1ee3c b\u00f4i \u0111\u1eadm m\u00e0u \u0111\u1ecf)<\/li>\n<\/ul>\n<p>L\u00fd gi\u1ea3i: \u0110\u00e2y l\u00e0 ng\u00e0nh ngh\u1ec1 kinh doanh b\u1eaft bu\u1ed9c ph\u1ea3i ch\u1ea1y \u0111ua theo nhu c\u1ea7u v\u00e0 xu th\u1ebf c\u1ee7a th\u1ecb tr\u01b0\u1eddng. \u0110\u1ec3 t\u0103ng th\u1ecb ph\u1ea7n th\u00ec c\u00e1c c\u00f4ng ty ph\u1ea3i b\u1ecf th\u00eam nhi\u1ec1u ti\u1ec1n h\u01a1n qua t\u1eebng n\u0103m cho c\u00e1c chi ph\u00ed li\u00ean quan \u0111\u1ebfn \u0111\u0103ng k\u00fd quy\u1ec1n th\u01b0\u01a1ng hi\u1ec7u, thi\u1ebft b\u1ecb y t\u1ebf v\u00e0 b\u1ed3i d\u01b0\u1ee1ng \u0111\u00e0o t\u1ea1o.<\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 2: Chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng kinh doanh c\u1ee7a d\u1ecbch v\u1ee5 c\u01b0 tr\u00fa v\u00e0 \u0103n u\u1ed1ng (Accomodation and food services) c\u00f3 xu h\u01b0\u1edbng t\u0103ng l\u00ean d\u1ea7n \u0111\u1ec1u<\/li>\n<\/ul>\n<p>L\u00fd gi\u1ea3i: Th\u1ecb tr\u01b0\u1eddng kh\u00e1ch s\u1ea1n nh\u00e0 ngh\u1ec9 v\u00e0 nh\u00e0 h\u00e0ng \u0111ang ng\u00e0y c\u00e0ng c\u1ea1nh tranh gay g\u1eaft t\u1ea1i M\u1ef9. Ph\u1ea7n l\u1edbn c\u00e1c kh\u00e1ch s\u1ea1n ng\u00e0y nay \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng d\u1ef1a tr\u00ean ch\u00ednh s\u00e1ch khuy\u1ebfn m\u1ea1i gi\u1ea3m gi\u00e1 cho kh\u00e1ch h\u00e0ng, t\u1eeb \u0111\u00f3 gia tang chi ph\u00ed kinh doanh l\u00ean.<\/p>\n<ul>\n<li>K\u1ebft qu\u1ea3 3: T\u1ea5t c\u1ea3 c\u00e1c l\u0129nh v\u1ef1c kinh doanh \u0111\u1ec1u tr\u1ea3i qua m\u1ed9t giai \u0111o\u1ea1n ph\u00e1t tri\u1ec3n kh\u00e1 k\u1ef3 l\u1ea1 trong n\u0103m 2009. Ph\u1ea7n l\u1edbn c\u00e1c ch\u1ec9 s\u1ed1 \u0111\u1ec1u \u0111\u01b0\u1ee3c t\u00f4 \u0111\u1eadm m\u00e0u xanh l\u00e1<\/li>\n<\/ul>\n<p>L\u00fd gi\u1ea3i: Cu\u1ed9c \u0111\u1ea1i suy tho\u00e1i t\u00e0i ch\u00ednh 2007-2009 \u0111\u00e3 khi\u1ebfn nhi\u1ec1u doanh nghi\u1ec7p ph\u1ea3i c\u1eaft gi\u1ea3m chi ti\u00eau, d\u1eabn \u0111\u1ebfn vi\u1ec7c c\u00e1c ch\u1ec9 s\u1ed1 v\u1ec1 chi ph\u00ed kinh doanh \u0111\u01b0\u1ee3c gi\u1ea3m xu\u1ed1ng.<\/p>\n<p>Ph\u00e2n t\u00edch k\u1ef9 c\u00e0ng h\u01a1n, ta c\u00f3 th\u1ec3 th\u1ea5y r\u1eb1ng ng\u00e0nh kinh doanh nhu y\u1ebfu ph\u1ea9m v\u00e0 \u0111\u1ed3 gia d\u1ee5ng kh\u00f4ng ho\u00e0n to\u00e0n th\u1ec3 hi\u1ec7n m\u00e0u xanh tr\u00ean b\u1ea3n \u0111\u1ed3. \u0110i\u1ec1u n\u00e0y l\u00e0 b\u1edfi c\u00e1c m\u1eb7t h\u00e0ng ch\u1ee7 y\u1ebfu \u0111\u1ec1u l\u00e0 c\u00e1c nhu y\u1ebfu ph\u1ea9m thi\u1ebft y\u1ebfu trong cu\u1ed9c s\u1ed1ng nh\u01b0 th\u1ee9c \u0103n, qu\u1ea7n \u00e1o v\u00e0 \u0111\u1ed3 gia d\u1ee5ng, v\u00ec v\u1eady ng\u01b0\u1eddi ti\u00eau d\u00f9ng kh\u00f4ng v\u00ec l\u00fd do suy tho\u00e1i m\u00e0 ng\u1eebng chi ti\u1ec1n mua c\u00e1c m\u1eb7t h\u00e0ng n\u00e0y.<\/p>\n<p><strong>C\u00e1c kh\u00eda c\u1ea1nh kh\u00e1c c\u1ee7a bi\u1ec3u \u0111\u1ed3 b\u1ea3n \u0111\u1ed3 nhi\u1ec7t<\/strong><\/p>\n<ul>\n<li>T\u1ea1o b\u1ea3n \u0111\u1ed3 nhi\u1ec7t v\u1edbi ch\u1ec9 m\u00e0u s\u1eafc (kh\u00f4ng c\u00f3 s\u1ed1 li\u1ec7u hi\u1ec3n th\u1ecb)\n<ul>\n<li>B\u01b0\u1edbc 1: B\u00f4i \u0111\u1eadm d\u1ea3i \u00f4 C3:K49 -&gt; B\u1ea5m t\u1ed5 h\u1ee3p ph\u00edm t\u1eaft Ctrl+1 \u0111\u1ec3 kh\u1edfi \u0111\u1ed9ng h\u1ed9p tho\u1ea1i format cell<\/li>\n<li>B\u01b0\u1edbc 2: D\u01b0\u1edbi ph\u1ea7n tab Number -&gt; Ch\u1ecdn Custom -&gt; Type -&gt; \u0110i\u1ec1n ba d\u1ea5u ch\u1ea5m ph\u1ea9y v\u00e0o \u201c;;;\u201d -&gt; Sau \u0111\u00f3 click OK<\/li>\n<li><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9889 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-7.png\" width=\"558\" height=\"488\" title=\"excel-heat-map-example-7\"><\/li>\n<li>V\u00e0 th\u1ebf l\u00e0 xong. B\u1ea3n \u0111\u1ed3 nhi\u1ec7t l\u00fac n\u00e0y s\u1ebd ch\u1ec9 hi\u1ec3n th\u1ecb m\u00e0u s\u1eafc c\u1ee7a \u00f4 t\u00ednh v\u00e0 \u1ea9n \u0111\u1ecbnh s\u1ed1 li\u1ec7u. Bi\u1ec3u \u0111\u1ed3 ki\u1ec3u n\u00e0y r\u1ea5t hi\u1ec7u qu\u1ea3 \u0111\u1ec3 h\u00ecnh dung ra \u0111\u01b0\u1ee3c \u0111\u1eb7c \u0111i\u1ec3m thay \u0111\u1ed5i. Ch\u1eb3ng h\u1ea1n ta c\u00f3 th\u1ec3 \u0111\u1eb7t m\u00e0u xanh l\u00e1 cho to\u00e0n b\u1ed9 d\u1eef li\u1ec7u theo n\u0103m 2009 \u0111\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c t\u00e1c \u0111\u1ed9ng c\u1ee7a cu\u1ed9c suy tho\u00e1i n\u0103m \u0111\u00f3<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9890 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-8.png\" width=\"800\" height=\"278\" title=\"excel-heat-map-example-8\"><\/p>\n<ul>\n<li>T\u1ea1o bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t th\u1ec3 hi\u1ec7n m\u1ee9c thay \u0111\u1ed5i m\u1ea1nh nh\u1ea5t\n<ul>\n<li>Lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0y s\u1ebd th\u00edch h\u1ee3p trong ph\u00e2n t\u00edch web v\u00e0 d\u00f9ng \u0111\u1ec3 minh h\u1ecda h\u00e0nh vi click chu\u1ed9t l\u1ef1a ch\u1ecdn c\u1ee7a ng\u01b0\u1eddi d\u00f9ng khi l\u00ean m\u1ea1ng. R\u1ea5t \u0111\u01a1n gi\u1ea3n, b\u1ea1n ch\u1ec9 c\u1ea7n quy \u0111\u1ecbnh m\u00e0u s\u1eafc cho c\u00e1c gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t l\u00e0 \u0111\u1ecf, c\u00f2n l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb th\u1ea5p h\u01a1n s\u1ebd \u0111\u1ec3 l\u00e0 m\u00e0u v\u00e0ng l\u00e0 xong.<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-9891 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-9.png\" width=\"813\" height=\"321\" title=\"excel-heat-map-example-9\"><\/p>\n<ul>\n<li>T\u1ea1o bi\u1ec3u \u0111\u1ed3 nhi\u1ec7t th\u1ec3 hi\u1ec7n m\u1ee9c thay \u0111\u1ed5i y\u1ebfu nh\u1ea5t\n<ul>\n<li>Lo\u1ea1i bi\u1ec3u \u0111\u1ed3 n\u00e0y s\u1ebd th\u00edch h\u1ee3p trong vi\u1ec7c ph\u00e2n t\u00edch chi ph\u00ed ho\u1ea1t \u0111\u1ed9ng theo th\u00e1ng. T\u01b0\u01a1ng t\u1ef1 nh\u01b0 tr\u00ean, b\u1ea1n ch\u1ec9 c\u1ea7n quy \u0111\u1ecbnh m\u00e0u s\u1eafc cho c\u00e1c gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t l\u00e0 xanh, c\u00f2n l\u1ea1i c\u00e1c gi\u00e1 tr\u1ecb cao h\u01a1n s\u1ebd \u0111\u1ec3 l\u00e0 m\u00e0u v\u00e0ng l\u00e0 xong<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-9892\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/excel-heat-map-example-10.png\" width=\"800\" height=\"244\" title=\"excel-heat-map-example-10\"><\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-245.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10956,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10955","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10955","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/comments?post=10955"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10955\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10956"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10955"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10955"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10955"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}