{"id":10459,"date":"2025-01-14T08:29:11","date_gmt":"2025-01-14T08:29:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel\/"},"modified":"2025-01-14T08:29:11","modified_gmt":"2025-01-14T08:29:11","slug":"huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn 3 c\u00e1ch t\u00ednh ti\u1ec1n th\u01b0\u1edfng doanh thu tr\u00ean b\u1ea3ng l\u01b0\u01a1ng Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Ti\u1ec1n th\u01b0\u1edfng l\u00e0 m\u1ed9t y\u1ebfu t\u1ed1 quan tr\u1ecdng trong ti\u1ec1n l\u01b0\u01a1ng c\u1ee7a nh\u00e2n s\u1ef1. V\u1eady trong Excel th\u01b0\u1eddng d\u00f9ng c\u00f4ng th\u1ee9c n\u00e0o \u0111\u1ec3 t\u00ednh ti\u1ec1n th\u01b0\u1edfng? Sau \u0111\u00e2y H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n 3 c\u00e1ch\u00a0t\u00ednh\u00a0ti\u1ec1n th\u01b0\u1edfng doanh thu tr\u00ean b\u1ea3ng l\u01b0\u01a1ng Excel.<\/p>\n<p>Ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u n\u1ed9i dung n\u00e0y th\u00f4ng qua m\u1ed9t v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p>Trong b\u1ea3ng l\u01b0\u01a1ng d\u01b0\u1edbi \u0111\u00e2y c\u00f3 bao g\u1ed3m ti\u1ec1n Doanh s\u1ed1 cho b\u1ed9 ph\u1eadn kinh doanh. H\u00e3y x\u00e1c \u0111\u1ecbnh th\u01b0\u1edfng doanh s\u1ed1 bi\u1ebft ti\u00eau ch\u00ed x\u00e1c \u0111\u1ecbnh m\u1ee9c th\u01b0\u1edfng \u0111\u01b0\u1ee3c quy \u0111\u1ecbnh \u1edf b\u1ea3ng Th\u01b0\u1edfng doanh s\u1ed1 (B14:C19):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19581\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-luong-tinh-thuong-doanh-so-de-bai.png\" width=\"1011\" height=\"516\" title=\"bang-luong-tinh-thuong-doanh-so-de-bai\"><\/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-67862056cd485\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel.html#Cach_thu_1_Dung_ham_IF\" title=\"C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m IF\">C\u00e1ch th\u1ee9 1: D\u00f9ng h\u00e0m IF<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel.html#Cach_thu_2_Su_dung_ham_VLOOKUP\" title=\"C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng h\u00e0m VLOOKUP\">C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng h\u00e0m VLOOKUP<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-3-cach-tinh-tien-thuong-doanh-thu-tren-bang-luong-excel.html#Cach_thu_3_Su_dung_ham_INDEX_ket_hop_ham_MATCH\" title=\"C\u00e1ch th\u1ee9 3: S\u1eed d\u1ee5ng h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH\">C\u00e1ch th\u1ee9 3: S\u1eed d\u1ee5ng h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_1_Dung_ham_IF\"><\/span>C\u00e1ch th\u1ee9 1: D\u00f9ng <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-trong-excel-cong-thuc-cho-ky-tu-du-lieu-va-o-trong.html\">h\u00e0m IF<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch c\u01a1 b\u1ea3n v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong tr\u01b0\u1eddng h\u1ee3p ch\u00fang ta ch\u1ec9 bi\u1ebft v\u1ec1 h\u00e0m IF. C\u00e1ch n\u00e0y l\u00e0m d\u1ef1a v\u00e0o vi\u1ec7c di\u1ec5n gi\u1ea3i l\u1ea1i logic b\u1eb1ng h\u00e0m IF. Do \u0111\u00f3 \u0111i\u1ec1u quan tr\u1ecdng l\u00e0 ph\u1ea3i di\u1ec5n gi\u1ea3i \u0111\u00fang logic b\u1eb1ng l\u1eddi tr\u01b0\u1edbc khi vi\u1ebft c\u00f4ng th\u1ee9c. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y logic \u0111\u01b0\u1ee3c di\u1ec5n \u0111\u1ea1t nh\u01b0 sau:<\/p>\n<ul>\n<li>N\u1ebfu doanh s\u1ed1 d\u01b0\u1edbi 100 tri\u1ec7u th\u00ec % doanh s\u1ed1 = 0% (kh\u00f4ng \u0111\u01b0\u1ee3c th\u01b0\u1edfng)<\/li>\n<li>N\u1ebfu doanh s\u1ed1 t\u1eeb 100 tri\u1ec7u \u0111\u1ebfn d\u01b0\u1edbi 150 tri\u1ec7u th\u00ec % doanh s\u1ed1 = 1% (l\u1ea5y 1% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/li>\n<li>N\u1ebfu doanh s\u1ed1 t\u1eeb 150 tri\u1ec7u \u0111\u1ebfn d\u01b0\u1edbi 200 tri\u1ec7u\u00a0th\u00ec % doanh s\u1ed1 = 1,5% (l\u1ea5y 1,5% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/li>\n<li>C\u00f2n l\u1ea1i n\u1ebfu doanh s\u1ed1 t\u1eeb\u00a0200 tri\u1ec7u tr\u1edf l\u00ean th\u00ec % doanh s\u1ed1 = 2% (l\u1ea5y 2% nh\u00e2n v\u1edbi doanh s\u1ed1 \u0111\u1ec3 ra s\u1ed1 th\u01b0\u1edfng)<\/li>\n<\/ul>\n<p>Nh\u01b0 v\u1eady c\u1ea7n t\u1edbi 3 h\u00e0m IF l\u1ed3ng nhau. T\u1ea1i \u00f4 J7 ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft c\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">IF(I7&lt;$B$17,$C$16,IF(I7&lt;$B$18,$C$17,IF(I7&lt;$B$19,$C$18,$C$19)))*I7<\/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-172.gif\" title=\"ex101_92019-nho-172\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19582\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-luong-tinh-thuong-doanh-so-ham-if.png\" width=\"1040\" height=\"390\" title=\"bang-luong-tinh-thuong-doanh-so-ham-if\"><\/p>\n<p>\u00c1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u1eeb J7 t\u1edbi c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi t\u1edbi J12. L\u01b0u \u00fd: \u0111\u1ec3 c\u00f3 th\u1ec3 copy c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng b\u00ean d\u01b0\u1edbi th\u00ec trong c\u00f4ng th\u1ee9c c\u1ea7n l\u01b0u \u00fd c\u1ed1 \u0111\u1ecbnh t\u1ecda \u0111\u1ed9 c\u00e1c tham chi\u1ebfu. Trong b\u00e0i n\u00e0y c\u00f3 s\u1eb5n b\u1ea3ng ph\u1ee5 n\u00ean ch\u00fang ta c\u00f3 th\u1ec3 tham chi\u1ebfu tr\u1ef1c ti\u1ebfp t\u1edbi b\u1ea3ng m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft c\u1ee5 th\u1ec3 gi\u00e1 tr\u1ecb trong h\u00e0m IF.<\/p>\n<p>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/ham-long-ghep-ket-hop-nhieu-dieu-kien-trong-mot-cong-thuc-duy-nhat.html\">H\u00e0m IF l\u1ed3ng gh\u00e9p, k\u1ebft h\u1ee3p nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n trong m\u1ed9t c\u00f4ng th\u1ee9c duy nh\u1ea5t<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_2_Su_dung_ham_VLOOKUP\"><\/span>C\u00e1ch th\u1ee9 2: S\u1eed d\u1ee5ng h\u00e0m <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">VLOOKUP<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e0m VLOOKUP l\u00e0 h\u00e0m ph\u1ed5 bi\u1ebfn d\u00f9ng \u0111\u1ec3 tham chi\u1ebfu gi\u00e1 tr\u1ecb t\u1eeb 1 b\u1ea3ng d\u1eef li\u1ec7u. \u0110\u1ec3 s\u1eed d\u1ee5ng h\u00e0m Vlookup trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y th\u00ec ch\u00fang ta x\u00e1c \u0111\u1ecbnh c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng trong h\u00e0m nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>Lookup_Value<\/strong>: l\u00e0 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm. Trong y\u00eau c\u1ea7u n\u00e0y ch\u00fang ta c\u1ea7n tham chi\u1ebfu <strong>Doanh s\u1ed1<\/strong> t\u1edbi b\u1ea3ng <strong>Th\u01b0\u1edfng doanh s\u1ed1<\/strong>, do \u0111\u00f3 gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm s\u1ebd l\u00e0 gi\u00e1 tr\u1ecb doanh s\u1ed1 t\u01b0\u01a1ng \u1ee9ng tr\u00ean c\u00f9ng d\u00f2ng \u0111\u1eb7t k\u1ebft qu\u1ea3.<\/li>\n<li><strong>Table_array<\/strong>: l\u00e0 b\u1ea3ng ch\u1ee9a gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm v\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm. B\u1ea3ng n\u00e0y ch\u00ednh l\u00e0 b\u1ea3ng Th\u01b0\u1edfng doanh s\u1ed1, v\u00f9ng B16:C19<\/li>\n<li><strong>Col_index_num<\/strong>: C\u1ed9t ch\u1ee9a k\u1ebft qu\u1ea3 l\u00e0 c\u1ed9t th\u1ee9 m\u1ea5y trong table_array. T\u1ea1i \u0111\u00e2y c\u00f3 th\u1ec3 x\u00e1c \u0111\u1ecbnh c\u1ed9t th\u1ee9 2 (% doanh s\u1ed1) l\u00e0 gi\u00e1 tr\u1ecb c\u1ea7n t\u00ecm.<\/li>\n<li><strong>[range_lookup]<\/strong>: ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm. \u1ede \u0111\u00e2y b\u1ea3ng table_array \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh theo d\u1ea1ng kho\u1ea3ng v\u00e0 t\u0103ng d\u1ea7n, n\u00ean ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm l\u00e0 t\u01b0\u01a1ng \u0111\u1ed1i. C\u00f3 th\u1ec3 nh\u1eadp gi\u00e1 tr\u1ecb l\u00e0 1 ho\u1eb7c kh\u00f4ng nh\u1eadp gi\u00e1 tr\u1ecb.<\/li>\n<\/ul>\n<p>C\u00f4ng th\u1ee9c <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">VLOOKUP<\/a> t\u1ea1i J7 c\u00f3 th\u1ec3 vi\u1ebft nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">J7=VLOOKUP(I7,$B$16:$C$19,2,1)*I7<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19587\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-luong-tinh-thuong-doanh-so-ham-vlookup.png\" width=\"1207\" height=\"453\" title=\"bang-luong-tinh-thuong-doanh-so-ham-vlookup\"><\/p>\n<p>V\u1edbi c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m Vlookup, ch\u00fang ta th\u1ea5y c\u00e1ch vi\u1ebft d\u1ec5 h\u01a1n nhi\u1ec1u so v\u1edbi d\u00f9ng h\u00e0m IF.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Cach_thu_3_Su_dung_ham_INDEX_ket_hop_ham_MATCH\"><\/span>C\u00e1ch th\u1ee9 3: S\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">h\u00e0m INDEX k\u1ebft h\u1ee3p h\u00e0m MATCH<\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">INDEX v\u00e0 MATCH<\/a> l\u00e0 hai h\u00e0m t\u00ecm ki\u1ebfm, tham chi\u1ebfu r\u1ea5t m\u1ea1nh trong Excel. D\u00f9ng INDEX v\u00e0 MATCH c\u00f3 th\u1ec3 thay th\u1ebf ho\u00e0n to\u00e0n cho h\u00e0m VLOOKUP, th\u1eadm ch\u00ed c\u00f2n \u01b0u vi\u1ec7t h\u01a1n. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m b\u1eb1ng INDEX v\u00e0 MATCH nh\u00e9:<\/p>\n<p>\u0110\u1ec3 t\u00ecm hi\u1ec3u k\u1ef9 h\u01a1n v\u1ec1 2 h\u00e0m n\u00e0y, m\u1eddi c\u00e1c b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/vi-sao-dung-index-va-match-tot-hon-dung-vlookup-trong-excel.html\">V\u00ec sao d\u00f9ng INDEX v\u00e0 MATCH t\u1ed1t h\u01a1n d\u00f9ng VLOOKUP trong Excel<\/a><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ea7n t\u00ecm \u1edf c\u1ed9t % doanh s\u1ed1. Do \u0111\u00f3 \u0111\u1ed1i t\u01b0\u1ee3ng \u0111\u1ea7u ti\u00ean trong h\u00e0m INDEX l\u00e0 C16:C19<\/p>\n<p>\u0110\u1ec3 x\u00e1c \u0111\u1ecbnh m\u1ee9c doanh s\u1ed1 c\u1ea7n t\u00ecm n\u1eb1m \u1edf v\u1ecb tr\u00ed d\u00f2ng n\u00e0o trong v\u00f9ng B16:B19 th\u00ec ch\u00fang ta d\u00f9ng h\u00e0m MATCH. L\u01b0u \u00fd trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 tham chi\u1ebfu t\u01b0\u01a1ng \u0111\u1ed1i theo th\u1ee9 t\u1ef1 t\u0103ng d\u1ea7n:<\/p>\n<ul>\n<li><strong>Lookup_value<\/strong>: gi\u00e1 tr\u1ecb t\u00ecm ki\u1ebfm l\u00e0 gi\u00e1 tr\u1ecb doanh s\u1ed1 I7 (khi \u0111\u1eb7t c\u00f4ng th\u1ee9c \u1edf d\u00f2ng 7)<\/li>\n<li><strong>Lookup_array<\/strong>: v\u00f9ng tham chi\u1ebfu l\u00e0 v\u00f9ng B16:B19<\/li>\n<li><strong>[match_type]<\/strong>: ph\u01b0\u01a1ng th\u1ee9c t\u00ecm ki\u1ebfm t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 t\u0103ng d\u1ea7n n\u00ean nh\u1eadp l\u00e0 s\u1ed1 1<\/li>\n<\/ul>\n<p>C\u00e1ch vi\u1ebft h\u00e0m n\u00e0y nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">J7=INDEX($C$16:$C$19,MATCH(I7,$B$16:$B$19,1))*I7<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19588\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bang-luong-tinh-thuong-doanh-so-ham-index-match.png\" width=\"1348\" height=\"517\" title=\"bang-luong-tinh-thuong-doanh-so-ham-index-match\"><\/p>\n<p>C\u1ea3 3 c\u00e1ch \u0111\u1ec1u cho ch\u00fang ta k\u1ebft qu\u1ea3 gi\u1ed1ng nhau. Khi s\u1eed d\u1ee5ng tham chi\u1ebfu t\u1edbi c\u00e1c b\u1ea3ng t\u00ednh ph\u1ee5 (nh\u01b0 b\u1ea3ng B16:C19) th\u00ec c\u00e1c tham chi\u1ebfu \u0111\u00f3 \u0111\u1ec1u ph\u1ea3i \u0111\u01b0\u1ee3c c\u1ed1 \u0111\u1ecbnh b\u1eb1ng d\u1ea5u $ trong c\u00f4ng th\u1ee9c. B\u1edfi khi \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c xu\u1ed1ng c\u00e1c d\u00f2ng ti\u1ebfp theo s\u1ebd c\u00f3 th\u1ec3 sai k\u1ebft qu\u1ea3 do tham chi\u1ebfu b\u1ecb thay \u0111\u1ed5i khi kh\u00f4ng c\u1ed1 \u0111\u1ecbnh v\u00f9ng tham chi\u1ebfu.<\/p>\n<p>Ngo\u00e0i 3 c\u00e1ch n\u00e0y, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u00eam m\u1ed9t s\u1ed1 c\u00e1ch kh\u00e1c kh\u00f4ng? V\u00ed d\u1ee5 nh\u01b0 s\u1eed d\u1ee5ng h\u00e0m LOOKUP thay cho VLOOKUP c\u00f3 \u0111\u01b0\u1ee3c kh\u00f4ng? H\u00e3y chia s\u1ebb nh\u1eefng c\u00e1ch kh\u00e1c m\u00e0 b\u1ea1n kh\u00e1m ph\u00e1 \u0111\u01b0\u1ee3c nh\u00e9.<\/p>\n<p>Xem th\u00eam:<\/p>\n<p style=\"padding-left: 30px\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xac-dinh-co-che-tinh-luong-theo-phuong-phap-3p.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e1c \u0111\u1ecbnh c\u01a1 ch\u1ebf t\u00ednh l\u01b0\u01a1ng theo ph\u01b0\u01a1ng ph\u00e1p 3P<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2K5SC62\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. 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-172.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10460,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10459","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\/10459","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=10459"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10459\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10460"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10459"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10459"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10459"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}