{"id":10541,"date":"2025-01-14T14:24:20","date_gmt":"2025-01-14T14:24:20","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/14\/tai-ve-mau-bang-ke-chi-tien-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/"},"modified":"2025-01-14T14:24:20","modified_gmt":"2025-01-14T14:24:20","slug":"tai-ve-mau-bang-ke-chi-tien-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-chi-tien-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018\/","title":{"rendered":"T\u1ea3i v\u1ec1 M\u1eabu B\u1ea3ng k\u00ea chi ti\u1ec1n 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 chi ti\u1ec1n 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<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-67867393a3d2f\" 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-chi-tien-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Mau_Bang_ke_chi_tien_theo_Thong_tu_200_tren_Excel\" title=\"M\u1eabu B\u1ea3ng\u00a0k\u00ea chi ti\u1ec1n\u00a0theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:\">M\u1eabu B\u1ea3ng\u00a0k\u00ea chi ti\u1ec1n\u00a0theo 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-chi-tien-theo-thong-tu-200-tren-excel-moi-nhat-nam-2018.html#Huong_dan_viet_Bang_ke_chi_tien_tren_theo_Thong_tu_200_tren_Excel\" title=\"H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng k\u00ea chi ti\u1ec1n\u00a0tr\u00ean theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:\">H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0B\u1ea3ng k\u00ea chi ti\u1ec1n\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-3\" href=\"https:\/\/blog.hocexcel.online\/tai-ve-mau-bang-ke-chi-tien-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=\"Mau_Bang_ke_chi_tien_theo_Thong_tu_200_tren_Excel\"><\/span>M\u1eabu B\u1ea3ng\u00a0k\u00ea chi ti\u1ec1n\u00a0theo Th\u00f4ng t\u01b0 200 tr\u00ean Excel:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-18238 size-full aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/bkct.png\" width=\"726\" height=\"505\" title=\"bkct\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Huong_dan_viet_Bang_ke_chi_tien_tren_theo_Thong_tu_200_tren_Excel\"><\/span>H\u01b0\u1edbng d\u1eabn vi\u1ebft\u00a0<strong>B\u1ea3ng k\u00ea chi ti\u1ec1n<\/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><strong>Ng\u00e0y \u2026 th\u00e1ng \u2026\u00a0 n\u0103m<\/strong>: L\u00e0 ng\u00e0y, th\u00e1ng, n\u0103m l\u1eadp b\u1ea3ng k\u00ea<\/li>\n<li><strong>H\u1ecd v\u00e0 t\u00ean ng\u01b0\u1eddi chi<\/strong>: Ghi r\u00f5 H\u1ecd v\u00e0 t\u00ean ng\u01b0\u1eddi chi<\/li>\n<li><strong>B\u1ed9 ph\u1eadn (ho\u1eb7c \u0111i\u1ea1 ch\u1ec9)<\/strong>: B\u1ed9 ph\u1eadn, \u0111\u1ecba ch\u1ec9 c\u1ee7a ng\u01b0\u1eddi chi<\/li>\n<li><strong>Chi cho c\u00f4ng vi\u1ec7c<\/strong>: Ghi r\u00f5 chi cho c\u00f4ng vi\u1ec7c g\u00ec<\/li>\n<li><strong>STT (C\u1ed9t A)<\/strong>: S\u1ed1 th\u1ee9 t\u1ef1 c\u1ee7a ch\u1ee9ng t\u1eeb<\/li>\n<li><strong>S\u1ed1 hi\u1ec7u ch\u1ee9ng t\u1eeb (C\u1ed9t B)<\/strong>: S\u1ed1 hi\u1ec7u c\u1ee7a ch\u1ee9ng t\u1eeb<\/li>\n<li><strong>Ng\u00e0y, th\u00e1ng ch\u1ee9ng t\u1eeb (C\u1ed9t C)<\/strong>: Ng\u00e0y, th\u00e1ng c\u1ee7a ch\u1ee9ng t\u1eeb<\/li>\n<li><strong>N\u1ed9i dung chi (C\u1ed9t D)<\/strong>: Di\u1ec5n gi\u1ea3i n\u1ed9i dung chi c\u1ee7a t\u1eebng ch\u1ee9ng t\u1eeb<\/li>\n<li><strong>S\u1ed1 ti\u1ec1n (C\u1ed9t 1)<\/strong>: S\u1ed1 ti\u1ec1n chi t\u01b0\u01a1ng \u1ee9ng<\/li>\n<li><strong>C\u1ed9ng<\/strong>: T\u1ed5ng s\u1ed1 ti\u1ec1n chi<\/li>\n<li><strong>S\u1ed1 ti\u1ec1n b\u1eb1ng ch\u1eef<\/strong>: Ghi t\u1ed5ng s\u1ed1 ti\u1ec1n chi\u00a0b\u1eb1ng ch\u1eef<\/li>\n<li><strong>(K\u00e8m theo \u2026 ch\u1ee9ng t\u1eeb)<\/strong>: Ghi s\u1ed1 l\u01b0\u1ee3ng ch\u1ee9ng t\u1eeb \u0111\u00ednh k\u00e8m<\/li>\n<li><strong>H\u1ecd, t\u00ean v\u00e0 ch\u1eef k\u00fd<\/strong> 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\u00a0B\u1ea3ng k\u00ea chi ti\u1ec1n l\u00e0 b\u1ea3ng li\u1ec7t k\u00ea c\u00e1c kho\u1ea3n ti\u1ec1n \u0111\u00e3 chi, l\u00e0m c\u0103n c\u1ee9 quy\u1ebft to\u00e1n c\u00e1c kho\u1ea3n ti\u1ec1n \u0111\u00e3 chi v\u00e0 ghi s\u1ed5 k\u1ebf to\u00e1n.<\/p>\n<p>\u2013\u00a0B\u1ea3ng k\u00ea chi ti\u1ec1n \u0111\u01b0\u1ee3c l\u1eadp th\u00e0nh 2 b\u1ea3n:<\/p>\n<ul>\n<li>1 b\u1ea3n l\u01b0u \u1edf th\u1ee7 qu\u1ef9<\/li>\n<li>1 b\u1ea3n l\u01b0u \u1edf k\u1ebf to\u00e1n qu\u1ef9<\/li>\n<\/ul>\n<p>\u2014<\/p>\n<p>Ch\u00fac c\u00e1c b\u1ea1n h\u1ecdc t\u1ed1t c\u00f9ng H\u1ecdc Excel Online!<\/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-185.gif\" title=\"ex101_92019-nho-185\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-185.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":10542,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-10541","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\/10541","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=10541"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/10541\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/10542"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=10541"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=10541"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=10541"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}