{"id":10150,"date":"2025-01-09T04:22:45","date_gmt":"2025-01-09T04:22:45","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-dinh-dang-theo-dieu-kien-cho-bieu-do-tren-excel\/"},"modified":"2025-01-09T04:22:45","modified_gmt":"2025-01-09T04:22:45","slug":"huong-dan-cach-dinh-dang-theo-dieu-kien-cho-bieu-do-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/09\/huong-dan-cach-dinh-dang-theo-dieu-kien-cho-bieu-do-tren-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn c\u00e1ch \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n cho bi\u1ec3u \u0111\u1ed3 tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ch\u00fang ta th\u01b0\u1eddng nghe n\u00f3i t\u1edbi vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n b\u1eb1ng c\u00e1ch d\u00f9ng Conditional Formatting trong Excel. Nh\u01b0ng \u0111\u00f3 l\u00e0 \u0111\u1ecbnh d\u1ea1ng cho c\u00e1c \u00f4, v\u00f9ng d\u1eef li\u1ec7u trong b\u1ea3ng t\u00ednh. V\u1eady b\u1ea1n \u0111\u00e3 nghe n\u00f3i t\u1edbi vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n cho bi\u1ec3u \u0111\u1ed3 ch\u01b0a? Nh\u01b0 l\u00e0 t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i m\u00e0u cho c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t tr\u00ean bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t? H\u00e3y c\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\"><strong>H\u1ecdc Excel Online<\/strong><\/a> t\u00ecm hi\u1ec3u c\u00e1ch th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y nh\u00e9.<\/p>\n<p>V\u00ed d\u1ee5 ch\u00fang ta c\u00f3 1 y\u00eau c\u1ea7u v\u1ebd bi\u1ec3u \u0111\u1ed3 b\u00e1o c\u00e1o doanh thu theo tu\u1ea7n d\u1ef1a theo b\u1ea3ng d\u1eef li\u1ec7u nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21253\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-data-ve-bieu-do.png\" width=\"374\" height=\"331\" title=\"cf-chart-data-ve-bieu-do\"><\/p>\n<p>Trong \u0111\u00f3 tr\u00ean bi\u1ec3u \u0111\u1ed3 c\u1ea7n th\u1ec3 hi\u1ec7n c\u1ed9t c\u00f3 doanh thu cao nh\u1ea5t s\u1ebd t\u00f4 m\u00e0u kh\u00e1c so v\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i.<\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_61 counter-hierarchy ez-toc-counter ez-toc-transparent ez-toc-container-direction\">\n<p class=\"ez-toc-title\">Xem nhanh<\/p>\n<p><label for=\"ez-toc-cssicon-toggle-item-677f4f14e946b\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dinh-dang-bieu-theo-dieu-kien-cho-bieu-do-tren-excel.html#Buoc_1_Ve_bieu_do_hinh_cot\" title=\"B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t\">B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dinh-dang-bieu-theo-dieu-kien-cho-bieu-do-tren-excel.html#Buoc_2_Tuy_bien_du_lieu_bieu_do_theo_dieu_kien\" title=\"B\u01b0\u1edbc 2: T\u00f9y bi\u1ebfn d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 theo \u0111i\u1ec1u ki\u1ec7n\">B\u01b0\u1edbc 2: T\u00f9y bi\u1ebfn d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 theo \u0111i\u1ec1u ki\u1ec7n<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-cach-dinh-dang-bieu-theo-dieu-kien-cho-bieu-do-tren-excel.html#Buoc_3_Ve_them_noi_dung_da_tuy_bien_vao_bieu_do\" title=\"B\u01b0\u1edbc 3: V\u1ebd th\u00eam n\u1ed9i dung \u0111\u00e3 t\u00f9y bi\u1ebfn v\u00e0o bi\u1ec3u \u0111\u1ed3\">B\u01b0\u1edbc 3: V\u1ebd th\u00eam n\u1ed9i dung \u0111\u00e3 t\u00f9y bi\u1ebfn v\u00e0o bi\u1ec3u \u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_1_Ve_bieu_do_hinh_cot\"><\/span>B\u01b0\u1edbc 1: V\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Tr\u01b0\u1edbc ti\u00ean ch\u00fang ta s\u1ebd <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-trong-excel-2010-2013-2016.html\"><strong>v\u1ebd bi\u1ec3u \u0111\u1ed3 trong Excel<\/strong><\/a> d\u1ea1ng c\u1ed9t v\u00e0 tr\u00ecnh b\u00e0y n\u1ed9i dung t\u1eeb b\u1ea3ng d\u1eef li\u1ec7u tr\u00ean sang d\u1ea1ng bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t. C\u00e1ch l\u00e0m nh\u01b0 sau:<\/p>\n<p>Ch\u1ecdn b\u1ea3ng d\u1eef li\u1ec7u (A2:B9), sau \u0111\u00f3 ch\u1ecdn th\u1ebb <strong>Insert\/ Chart\/ 2D column\/ Clustered Column<\/strong><\/p>\n<p>Thi\u1ebft l\u1eadp c\u00e1c t\u00f9y ch\u1ecdn cho bi\u1ec3u \u0111\u1ed3 nh\u01b0 sau:<\/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-137.gif\" title=\"ex101_92019-nho-137\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ul>\n<li>Style: ch\u1ecdn <strong>style 10<\/strong><\/li>\n<li>B\u1ecf tr\u1ee5c tung (chi\u1ec1u d\u1ecdc): b\u1ea5m chu\u1ed9t v\u00e0o s\u1ed1 bi\u1ec3u di\u1ec5n tr\u1ee5c tung \u0111\u1ec3 ch\u1ecdn tr\u1ee5c, sau \u0111\u00f3 b\u1ea5m ph\u00edm <strong>Delete<\/strong><\/li>\n<li>Th\u00eam s\u1ed1 tr\u00ean m\u1ed7i c\u1ed9t: trong th\u1ebb <strong>Design<\/strong> ch\u1ecdn <strong>Add chart Element\/ Data Labels\/ Outside End<\/strong><\/li>\n<li>T\u00ean bi\u1ec3u \u0111\u1ed3: trong ph\u1ea7n Chart Title c\u1ee7a bi\u1ec3u \u0111\u1ed3 b\u1ea5m ph\u00edm F2 r\u1ed3i nh\u1eadp =A1 \u0111\u1ec3 l\u1ea5y t\u00ean bi\u1ec3u \u0111\u1ed3 theo t\u00ean t\u1ea1i \u00f4 A1<\/li>\n<\/ul>\n<p>K\u1ebft qu\u1ea3 ch\u00fang ta c\u00f3 \u0111\u01b0\u1ee3c 1 bi\u1ec3u \u0111\u1ed3 nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21255\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-bieu-do-mau-01.png\" width=\"566\" height=\"348\" title=\"cf-chart-bieu-do-mau-01\"><\/p>\n<p>N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t th\u00ec c\u00f3 th\u1ec3 tham kh\u1ea3o b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/10-cach-ve-bieu-hinh-cot-trong-excel.html\">C\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_2_Tuy_bien_du_lieu_bieu_do_theo_dieu_kien\"><\/span>B\u01b0\u1edbc 2: T\u00f9y bi\u1ebfn d\u1eef li\u1ec7u bi\u1ec3u \u0111\u1ed3 theo \u0111i\u1ec1u ki\u1ec7n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb n\u00e0o l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, ch\u00fang ta kh\u00f4ng th\u1ec3 y\u00eau c\u1ea7u bi\u1ec3u \u0111\u1ed3 t\u1ef1 hi\u1ec3u \u0111i\u1ec1u n\u00e0y. H\u00e3y t\u1ea1o th\u00eam 1 c\u1ed9t ph\u1ee5 v\u00e0 s\u1eed d\u1ee5ng h\u00e0m \u0111\u1ec3 gi\u00fap x\u00e1c \u0111\u1ecbnh gi\u00e1 tr\u1ecb n\u00e0o l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n<p>T\u1ea1i c\u1ed9t C, b\u1eaft \u0111\u1ea7u t\u1eeb d\u00f2ng 3 ch\u00fang ta s\u1eed d\u1ee5ng h\u00e0m nh\u01b0 sau:<\/p>\n<p>C3=IF(B3=MAX($B$3:$B$9),B3,\u201d\u201d)<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<ul>\n<li>B3 l\u00e0 gi\u00e1 tr\u1ecb doanh thu t\u01b0\u01a1ng \u1ee9ng tr\u00ean d\u00f2ng \u0111ang thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>Max(B3:B9) l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t trong v\u00f9ng B3:B9. V\u00f9ng n\u00e0y c\u1ea7n c\u1ed1 \u0111\u1ecbnh l\u1ea1i \u0111\u1ec3 kh\u00f4ng thay \u0111\u1ed5i t\u1ecda \u0111\u1ed9 khi FillDown c\u00f4ng th\u1ee9c<\/li>\n<\/ul>\n<p>=&gt; C\u00f4ng th\u1ee9c n\u00e0y hi\u1ec3u l\u00e0: N\u1ebfu gi\u00e1 tr\u1ecb \u1edf B3 b\u1eb1ng v\u1edbi gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t th\u00ec l\u1ea5y theo gi\u00e1 tr\u1ecb \u0111\u00f3, c\u00f2n kh\u00f4ng ph\u1ea3i l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb r\u1ed7ng.<\/p>\n<p>K\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21256\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-data-them-ham-xac-dinh-gia-tri-max.png\" width=\"518\" height=\"329\" title=\"cf-chart-data-them-ham-xac-dinh-gia-tri-max\"><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-4-cach-tim-gia-tri-lon-nhat-va-nho-nhat-trong-excel.html\">H\u01b0\u1edbng d\u1eabn 4 c\u00e1ch t\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t v\u00e0 nh\u1ecf nh\u1ea5t trong excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Buoc_3_Ve_them_noi_dung_da_tuy_bien_vao_bieu_do\"><\/span>B\u01b0\u1edbc 3: V\u1ebd th\u00eam n\u1ed9i dung \u0111\u00e3 t\u00f9y bi\u1ebfn v\u00e0o bi\u1ec3u \u0111\u1ed3<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u00eam n\u1ed9i dung v\u00e0o bi\u1ec3u \u0111\u1ed3, ch\u00fang ta th\u1ef1c hi\u1ec7n l\u1ea7n l\u01b0\u1ee3t nh\u01b0 sau:<\/p>\n<ul>\n<li>B\u1ea5m ch\u1ecdn bi\u1ec3u \u0111\u1ed3. Khi ch\u1ecdn bi\u1ec3u \u0111\u1ed3 ch\u00fang ta s\u1ebd th\u1ea5y xu\u1ea5t hi\u1ec7n th\u1ebb <strong>Chart Tools<\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5<\/li>\n<li>Trong th\u1ebb <strong>Chart Tools\/ Design<\/strong> \/ ch\u1ecdn m\u1ee5c <strong>Select Data<\/strong><\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21257\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-select-data-de-them-noi-dung-vao-bieu-do.png\" width=\"1254\" height=\"641\" title=\"cf-chart-select-data-de-them-noi-dung-vao-bieu-do\"><\/p>\n<p>Trong c\u1eeda s\u1ed5 Select Data ch\u00fang ta s\u1ebd Add th\u00eam d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch b\u1ea5m v\u00e0o n\u00fat <strong>Add<\/strong> trong ph\u1ea7n <strong>Legend Entires (Series)<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21258\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-select-data-add-du-lieu.png\" width=\"1133\" height=\"536\" title=\"cf-chart-select-data-add-du-lieu\"><\/p>\n<p>Khi th\u00eam d\u1eef li\u1ec7u nh\u01b0 v\u1eady th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u00f3 2 c\u1ed9t th\u1ec3 hi\u1ec7n gi\u00e1 tr\u1ecb 680 l\u00e0 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t. Hai c\u1ed9t n\u00e0y c\u00f3 2 m\u00e0u kh\u00e1c nhau.<\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 \u0111\u1eb7t 2 c\u1ed9t n\u00e0y l\u1ed3ng v\u00e0o nhau, ch\u00fang ta s\u1ebd b\u1ea5m chu\u1ed9t v\u00e0o c\u1ed9t m\u00e0u v\u00e0ng, b\u1ea5m ti\u1ebfp chu\u1ed9t ph\u1ea3i ch\u1ecdn Format Data Series.<\/p>\n<p>Trong c\u1eeda s\u1ed5 Format Data Series b\u00ean tay ph\u1ea3i m\u00e0n h\u00ecnh Excel, ch\u00fang ta thi\u1ebft l\u1eadp m\u1ee5c Series Overlap l\u00e0 100%<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21259\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-format-data-series-overlap-100.png\" width=\"961\" height=\"385\" title=\"cf-chart-format-data-series-overlap-100\"><\/p>\n<p>Khi \u0111\u00f3 k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c ch\u00ednh l\u00e0 2 bi\u1ec3u \u0111\u1ed3 l\u1ed3ng v\u00e0o nhau, trong \u0111\u00f3 c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t \u0111\u00e3 c\u00f3 m\u00e0u kh\u00e1c so v\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i.<\/p>\n<p>\u0110\u1ec3 x\u00f3a b\u1ecf c\u00e1c s\u1ed1 0 th\u1eeba \u1edf ph\u00eda d\u01b0\u1edbi c\u00e1c c\u1ed9t, ch\u00fang ta b\u1ea5m v\u00e0o v\u1ecb tr\u00ed s\u1ed1 0 \u0111\u1ec3 ch\u1ecdn to\u00e0n b\u1ed9 c\u00e1c Data tr\u00ean c\u1ed9t th\u1ee9 2 (c\u1ed9t m\u1edbi th\u00eam v\u00e0o), sau \u0111\u00f3 b\u1ea5m ph\u00edm Delete<\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh \u0111\u01b0\u1ee3c bi\u1ec3u \u0111\u1ed3 h\u00ecnh c\u1ed9t m\u00e0 trong \u0111\u00f3 c\u1ed9t c\u00f3 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u1ed5i m\u00e0u so v\u1edbi c\u00e1c c\u1ed9t c\u00f2n l\u1ea1i r\u1ed3i.<\/p>\n<p>B\u00e2y gi\u1edd th\u1eed thay \u0111\u1ed5i gi\u00e1 tr\u1ecb doanh thu ng\u00e0y ch\u1ee7 nh\u1eadt sang 720 v\u00e0 xem bi\u1ec3u \u0111\u1ed3 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n ra sao nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-21260\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/cf-chart-ket-qua-khi-thay-doi-gia-tri-max.png\" width=\"1043\" height=\"330\" title=\"cf-chart-ket-qua-khi-thay-doi-gia-tri-max\"><\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-do-cot-ket-hop-duong-bieu-dien-tren-excel-chi-tiet-nhat.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 c\u1ed9t k\u1ebft h\u1ee3p \u0111\u01b0\u1eddng bi\u1ec3u di\u1ec5n tr\u00ean Excel chi ti\u1ebft nh\u1ea5t<\/a><\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-ve-bieu-hinh-tron-thuc-hien-ke-hoach-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3 h\u00ecnh tr\u00f2n % th\u1ef1c hi\u1ec7n k\u1ebf ho\u1ea1ch tr\u00ean Excel<\/a><\/p>\n<p>Ki\u1ebfn th\u1ee9c v\u1ec1 Excel r\u1ea5t phong ph\u00fa v\u00e0 th\u00fa v\u1ecb\u00a0ph\u1ea3i kh\u00f4ng n\u00e0o. N\u1ebfu b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 trong Excel th\u00ec h\u00e3y tham gia ngay kh\u00f3a h\u1ecdc\u00a0<a href=\"http:\/\/bit.ly\/2MjDvHi\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. Kh\u00f3a h\u1ecdc n\u00e0y gi\u00fap b\u1ea1n n\u1eafm v\u1eefng c\u00e1c ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m, t\u1eeb h\u00e0m c\u01a1 b\u1ea3n t\u1edbi h\u00e0m n\u00e2ng cao, hi\u1ec3u r\u00f5 c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 trong Excel nh\u01b0 Conditional formatting, Data Validation, Filter, Pivot Table, v\u1ebd bi\u1ec3u \u0111\u1ed3\u2026 Nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y \u0111\u1ec1u r\u1ea5t c\u1ea7n thi\u1ebft trong c\u00f4ng vi\u1ec7c h\u00e0ng ng\u00e0y tr\u00ean Excel.<\/p>\n<p>Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 nhi\u1ec1u \u01b0u \u0111\u00e3i h\u1ea5p d\u1eabn khi \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. H\u00e3y tham gia ngay \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c \u01b0u \u0111\u00e3i n\u00e0y nh\u00e9. Chi ti\u1ebft xem t\u1ea1i:<\/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-137.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10151,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10150","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\/10150","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=10150"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10150\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10151"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10150"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10150"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10150"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}