{"id":10553,"date":"2025-01-14T15:18:28","date_gmt":"2025-01-14T15:18:28","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tai-ve-mau-bang-ke-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/"},"modified":"2025-01-14T15:18:28","modified_gmt":"2025-01-14T15:18:28","slug":"tai-ve-mau-bang-ke-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tai-ve-mau-bang-ke-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/","title":{"rendered":"T\u1ea3i v\u1ec1 M\u1eabu B\u1ea3ng k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7 theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel m\u1edbi nh\u1ea5t n\u0103m 2018"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch trong k\u1ebf to\u00e1n. X\u00e2y d\u1ef1ng\u00a0c\u00e1c m\u1eabu ch\u1ee9ng t\u1eeb\u00a0tr\u00ean Excel l\u00e0 m\u1ed9t trong nh\u1eefng y\u00eau c\u1ea7u k\u1ebf to\u00e1n th\u01b0\u1eddng g\u1eb7p trong c\u00f4ng vi\u1ec7c k\u1ebf to\u00e1n tr\u00ean Excel.<\/p>\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y,\u00a0<strong>H\u1ecdc Excel Online<\/strong>\u00a0s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n v\u1ec1\u00a0<strong>C\u00e1ch t\u1ea1o v\u00e0 t\u1ea3i m\u1eabu B\u1ea3ng k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7 theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel\u00a0theo<\/strong>\u00a0<strong>m\u1eabu m\u1edbi nh\u1ea5t n\u0103m 2018<\/strong>. Ch\u00fang ta c\u00f9ng t\u00ecm hi\u1ec3u c\u00e1ch l\u00e0m nh\u00e9:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18194 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bk-vtt.png\" width=\"641\" height=\"464\" title=\"bk-vtt\"><\/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-678680435e925\" 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\/tai-ve-mau-bang-ke-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Huong_dan_viet_Bang_ke_vang_tien_te_tren_theo_Thong_tu_200_tren_Excel\" title=\"H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:\">H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<\/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\/tai-ve-mau-bang-ke-vang-tien-te-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Chu_y\" title=\"Ch\u00fa \u00fd:\">Ch\u00fa \u00fd:<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_viet_Bang_ke_vang_tien_te_tren_theo_Thong_tu_200_tren_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0<strong>B\u1ea3ng k\u00ea v\u00e0ng ti\u1ec1n t\u1ec7<\/strong><strong>\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"list-style-type: square\">\n<li><strong>\u0110\u01a1n v\u1ecb,\u00a0\u0110\u1ecba ch\u1ec9<\/strong>: Ghi r\u00f5 T\u00ean \u0111\u01a1n v\u1ecb, b\u1ed9 ph\u1eadn<\/li>\n<li>\u0110\u00ednh k\u00e8m phi\u1ebfu<\/li>\n<li><strong>Ng\u00e0y, th\u00e1ng, n\u0103m:\u00a0\u00a0<\/strong>l\u00e0 ng\u00e0y, th\u00e1ng, n\u0103m l\u1eadp b\u1ea3ng<\/li>\n<li><strong>Quy\u1ec3n s\u1ed1, s\u1ed1<\/strong>: Ghi t\u00ean quy\u1ec3n v\u00e0 s\u1ed1 trong quy\u1ec3n s\u1ed5 s\u1eed d\u1ee5ng<\/li>\n<li><strong>STT (C\u1ed9t A)<\/strong>: Ghi c\u00e1c lo\u1ea1i v\u00e0ng, \u0111\u00e1 qu\u00fd, \u2026<\/li>\n<li><strong>T\u00ean, lo\u1ea1i, qui c\u00e1ch, ph\u1ea9m ch\u1ea5t (C\u1ed9t B):<\/strong>\u00a0Ghi r\u00f5 t\u00ean,\u00a0lo\u1ea1i, qui c\u00e1ch, ph\u1ea9m ch\u1ea5t c\u1ee7a t\u1eebng lo\u1ea1i v\u00e0ng, \u0111\u00e1 qu\u00fd, \u2026<\/li>\n<li><strong>\u0110\u01a1n v\u1ecb t\u00ednh (C\u1ed9t C):<\/strong> Ghi \u0111\u01a1n v\u1ecb t\u00ednh cu\u1ea3 v\u00e0ng ti\u1ec1n t\u1ec7, th\u01b0\u1eddng l\u00e0 gam, ch\u1ec9,\u2026<\/li>\n<li><strong>S\u1ed1 l\u01b0\u1ee3ng(C\u1ed9t 1):<\/strong> S\u1ed1 l\u01b0\u1ee3ng t\u1eebng lo\u1ea1i v\u00e0ng ti\u1ec1n t\u1ec7<\/li>\n<li><strong>\u0110\u01a1n gi\u00e1\u00a0(C\u1ed9t 2):<\/strong> Ghi \u0111\u01a1n gi\u00e1 c\u1ee7a t\u1eebng lo\u1ea1i v\u00e0ng ti\u1ec1n t\u1ec7<\/li>\n<li><strong>Th\u00e0nh ti\u1ec1n (C\u1ed9t 3): <\/strong>Th\u00e0nh ti\u1ec1n (C\u1ed9t 3) = S\u1ed1 l\u01b0\u1ee3ng (C\u1ed9t 1) x \u0110\u01a1n gi\u00e1 (C\u1ed9t 2)<\/li>\n<li><strong>Ghi ch\u00fa\u00a0(C\u1ed9t D)<\/strong><\/li>\n<li>H\u1ecd t\u00ean, ch\u1eef k\u00fd c\u1ee7a nh\u1eefng ng\u01b0\u1eddi li\u00ean quan<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Chu_y\"><\/span>Ch\u00fa \u00fd:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u2013 B\u1ea3ng k\u00ea do Ng\u01b0\u1eddi ki\u1ec3m nghi\u1ec7m l\u1eadp th\u00e0nh 02 li\u00ean:<br \/>\n+ M\u1ed9t li\u00ean \u0111\u00ednh k\u00e8m v\u1edbi Phi\u1ebfu thu, Phi\u1ebfu chi, r\u1ed3i chuy\u1ec3n cho th\u1ee7 qu\u1ef9 \u0111\u1ec3 th\u1ee7 qu\u1ef9 l\u00e0m th\u1ee7 t\u1ee5c xu\u1ea5t qu\u1ef9, nh\u1eadp qu\u1ef9<\/p>\n<p>+ M\u1ed9t li\u00ean: Giao cho ng\u01b0\u1eddi n\u1ed9p, ng\u01b0\u1eddi nh\u1eadn<\/p>\n<p>\u2013 Ph\u1ea3i c\u00f3 \u0111\u1ea7y \u0111\u1ee7 t\u00ean v\u00e0 ch\u1eef k\u00fd c\u1ee7a nh\u1eefng ng\u01b0\u1eddi li\u00ean quan<\/p>\n<p>\u2014<\/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-188.gif\" title=\"ex101_92019-nho-188\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online!<\/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-188.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10554,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10553","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\/10553","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=10553"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10553\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10554"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10553"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10553"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10553"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}