{"id":4226,"date":"2024-12-04T15:23:46","date_gmt":"2024-12-04T15:23:46","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-mot-so-de-cach-tinh-luy-tien-trong-excel\/"},"modified":"2024-12-04T15:23:46","modified_gmt":"2024-12-04T15:23:46","slug":"huong-dan-mot-so-de-cach-tinh-luy-tien-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-mot-so-de-cach-tinh-luy-tien-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 \u0111\u1ec3 c\u00e1ch t\u00ednh lu\u1ef9 ti\u1ebfn trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>V\u1edbi b\u00e0i vi\u1ebft n\u00e0y, <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a><\/strong> s\u1ebd h\u01b0\u1edbng d\u1eabn m\u1ed9t s\u1ed1 <a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html\"><strong>c\u00e1ch \u0111\u1ec3 t\u00ednh ra lu\u1ef9 ti\u1ebfn trong Excel<\/strong> <\/a>gi\u00fap cho vi\u1ec7c theo d\u00f5i \u0111\u01b0\u1ee3c nh\u1eefng bi\u1ebfn \u0111\u1ed9ng m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, ch\u00ednh x\u00e1c.<\/em><\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c t\u00ednh lu\u1ef9 ti\u1ebfn th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng khi b\u1ea1n mu\u1ed1n xem x\u00e9t bi\u1ebfn \u0111\u1ed9ng mang t\u00ednh t\u00edch lu\u1ef9 qua t\u1eebng th\u1eddi \u0111i\u1ec3m, qua m\u1ed7i m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng th\u00ec con s\u1ed1 t\u1ed5ng hay s\u1ed1 d\u01b0 t\u1ea1i th\u1eddi \u0111i\u1ec3m \u0111\u00f3 l\u00e0 bao nhi\u00eau.<\/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-67507401f2696\" 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-mot-cach-tinh-luy-tien-trong-excel.html#Mot_so_kieu_luy_tien_don_gian\" title=\"M\u1ed9t s\u1ed1\u00a0ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn \u0111\u01a1n gi\u1ea3n\">M\u1ed9t s\u1ed1\u00a0ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn \u0111\u01a1n gi\u1ea3n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html#Cach_1\" title=\"C\u00e1ch 1\">C\u00e1ch 1<\/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-mot-cach-tinh-luy-tien-trong-excel.html#Cach_2\" title=\"C\u00e1ch 2\">C\u00e1ch 2<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html#Mot_so_kieu_luy_tien_nang_cao_hon\" title=\"M\u1ed9t s\u1ed1 ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn n\u00e2ng cao h\u01a1n\">M\u1ed9t s\u1ed1 ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn n\u00e2ng cao h\u01a1n<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html#Vi_du_1\" title=\"V\u00ed d\u1ee5 1\">V\u00ed d\u1ee5 1<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html#Vi_du_2\" title=\"V\u00ed d\u1ee5 2\">V\u00ed d\u1ee5 2<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-mot-cach-tinh-luy-tien-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_kieu_luy_tien_don_gian\"><\/span>M\u1ed9t s\u1ed1\u00a0ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn \u0111\u01a1n gi\u1ea3n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_1\"><\/span>C\u00e1ch 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1edbi c\u00e1ch n\u00e0y th\u00ec ta c\u00f3 c\u00f4ng th\u1ee9c nh\u01b0 sau \u0111\u1ec3 t\u00ednh lu\u1ef9 ti\u1ebfn.<\/p>\n<p style=\"text-align: justify\">\u00f4 \u0111\u1ea7u ti\u00ean: <strong>B3 = A3<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c \u00f4 c\u00f2n l\u1ea1i s\u1ebd \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c: <strong>B3 + A4<\/strong> (b\u1ea1n c\u00f3 th\u1ec3 hi\u1ec3u \u0111\u00e2y l\u00e0 \u00f4 li\u1ec1n tr\u01b0\u1edbc c\u1ee7a c\u1ed9t lu\u1ef9 ti\u1ebfn c\u1ed9ng v\u1edbi s\u1ed1 ph\u00e1t sinh ti\u1ebfp theo c\u1ee7a s\u1ed1 l\u01b0\u1ee3ng, k\u1ebft qu\u1ea3 s\u1ebd l\u00e0 s\u1ed1 l\u01b0\u1ee3ng lu\u1ef9 ti\u1ebfn t\u00ednh t\u1edbi \u0111\u00fang th\u1eddi \u0111i\u1ec3m \u0111ang x\u00e9t.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/1-9.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30139 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-9-2.png\" alt=\"huong-dan-mot-so-cach-tinh-luy-tien-trong-excel-1\" width=\"555\" height=\"513\" title=\"1-9-2\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_2\"><\/span>C\u00e1ch 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">C\u00e1ch n\u00e0y c\u0169ng l\u1ea5y v\u00ed d\u1ee5 tr\u00ean. Tuy nhi\u00ean thay v\u00ec ph\u1ea3i 2 c\u00f4ng th\u1ee9c nh\u01b0 tr\u00ean th\u00ec c\u00e1ch n\u00e0y b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng 1 h\u00e0m duy nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c nh\u01b0 sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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\/2024\/12\/ex101_92019-nho-338.gif\" title=\"ex101_92019-nho-338\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<div class=\"code-block code-block-2\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/vba101-tu-dong-hoa-excel-voi-lap-trinh-vba-cho-nguoi-moi-bat-dau\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vba101_92019-nho-145.gif\" title=\"vba101_92019-nho-145\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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\/2024\/12\/ex101_92019-nho-338.gif\" title=\"ex101_92019-nho-338\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<blockquote>\n<p><strong>=SUM($A$3:A3)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">V\u1edbi \u0111i\u1ec3m\u00a0<strong>$A$3 <\/strong>\u0111\u1ea7u ta c\u1ea7n c\u1ed1 \u0111\u1ecbnh l\u1ea1i (\u1ea5n F4 ho\u1eb7c Fn + F4), v\u00e0 kh\u00f4ng c\u1ed1 \u0111\u1ecbnh \u0111i\u1ec3m A3 sau. Khi b\u1ea1n <strong>FillDown<\/strong> c\u00f4ng th\u1ee9c n\u00e0y xu\u1ed1ng th\u00ec v\u00f9ng SUM n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng d\u1ea7n d\u1ea7n.<\/p>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>VD:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;padding-left: 30px\">\u2013 Khi c\u00f4ng th\u1ee9c \u1edf \u00f4\u00a0<strong>B4<\/strong>\u00a0th\u00ec s\u1ebd\u00a0<strong>SUM($A$3:A4)<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\">\u2013 Khi c\u00f4ng th\u1ee9c \u1edf \u00f4\u00a0<strong>B5<\/strong>\u00a0th\u00ec s\u1ebd\u00a0<strong>SUM($A$3:A5)<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\">\u2013 Khi c\u00f4ng th\u1ee9c \u1edf \u00f4 <strong>B6<\/strong>\u00a0th\u00ec s\u1ebd <strong>SUM($A$3:A6)<\/strong><\/p>\n<p style=\"text-align: justify;padding-left: 30px\">\u2013 \u2026\u2026\u2026<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30140 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-8-2.png\" alt=\"huong-dan-mot-so-cach-tinh-luy-tien-trong-excel-2\" width=\"681\" height=\"514\" title=\"2-8-2\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mot_so_kieu_luy_tien_nang_cao_hon\"><\/span>M\u1ed9t s\u1ed1 ki\u1ec3u\u00a0lu\u1ef9 ti\u1ebfn n\u00e2ng cao h\u01a1n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u1ede ph\u1ea7n n\u00e0y, <strong>H\u1ecdc Excel Online <\/strong>s\u1ebd \u0111\u1ec1 c\u1eadp t\u1edbi m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p, m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 c\u0169ng c\u1ea7n t\u00ednh lu\u1ef9 ti\u1ebfn nh\u01b0ng n\u00e2ng cao h\u01a1n. C\u1ee5 th\u1ec3 b\u1ea1n tham kh\u1ea3o c\u00e1c v\u00ed d\u1ee5 sau.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_1\"><\/span>V\u00ed d\u1ee5 1<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p v\u1edbi nh\u1eefng ai l\u00e0m k\u1ebf to\u00e1n kho l\u00e0 t\u00ednh lu\u1ef9 ti\u1ebfn s\u1ed1 l\u01b0\u1ee3ng t\u1ed3n kho. Sau m\u1ed7i l\u1ea7n nh\u1eadp xu\u1ea5t v\u00e0 ghi v\u00e0o th\u1ebb kho th\u00ec c\u1ea7n ph\u1ea3i x\u00e1c \u0111\u1ecbnh ch\u00ednh x\u00e1c t\u1ea1i th\u1eddi \u0111i\u1ec3m \u0111\u00f3 s\u1ed1 l\u01b0\u1ee3ng h\u00e0ng ho\u00e1 c\u00f2n t\u1ed3n trong kho l\u00e0 bao nhi\u00eau.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-theo-kho-so-kho-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp th\u1ebb kho, s\u1ed5 kho tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">Xu\u1ea5t ph\u00e1t t\u1eeb nguy\u00ean t\u1eafc: <strong>S\u1ed1 t\u1ed3n kho = t\u1ed3n kho \u0111\u1ea7u k\u1ef3 + s\u1ed1 nh\u1eadp \u2013 s\u1ed1 xu\u1ea5t <\/strong>ta c\u00f3 c\u00f4ng th\u1ee9c \u1edf v\u00ed d\u1ee5 d\u01b0\u1edbi nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=$J$16+SUM($H$17:H17) \u2013 SUM($I$17:I17)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><span style=\"font-size: 14pt\"><strong>Trong \u0111\u00f3:<\/strong><\/span><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong>$J$16:<\/strong> L\u00e0 s\u1ed1 t\u1ed3n kho \u0111\u1ea7u k\u1ef3.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong>SUM($H$17:H17)<\/strong>: S\u1ed1 nh\u1eadp trong k\u1ef3.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><strong>SUM($I$17:I17):<\/strong> S\u1ed1 xu\u1ea5t trong k\u1ef3.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/3-7.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30143 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-7-1024x492-1.png\" alt=\"huong-dan-mot-so-cach-tinh-luy-tien-trong-excel-3\" width=\"1024\" height=\"492\" title=\"3-7-1024x492-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Vi_du_2\"><\/span>V\u00ed d\u1ee5 2<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">M\u1ed9t v\u00ed d\u1ee5 n\u1eefa v\u1ec1 t\u00ednh lu\u1ef9 ti\u1ebfn trong k\u1ebf to\u00e1n l\u00e0 t\u00ednh s\u1ed1 d\u01b0 (d\u01b0 N\u1ee3 v\u00e0 d\u01b0 C\u00f3) c\u1ee7a s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft v\u1edbi c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng nh\u01b0: Kh\u00e1ch h\u00e0ng, nh\u00e0 cung c\u1ea5p, nh\u00e2n vi\u00ean,\u2026.<\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lan-so-ke-toan-chi-tiet-cong-no-phai-thu.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u00ed d\u1ee5 sau s\u1ebd t\u00ednh lu\u1ef9 ti\u1ebfn cho c\u1ed9t s\u1ed1 d\u01b0 c\u1ee7a s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng (s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft c\u00f4ng n\u1ee3 ph\u1ea3i thu). Lu\u1ef9 ti\u1ebfn \u0111\u01b0\u1ee3c t\u00ednh tr\u00ean 2 c\u1ed9t s\u1ed1 d\u01b0 N\u1ee3 v\u00e0 s\u1ed1 d\u01b0 C\u00f3. Do \u0111\u00f3, ta s\u1ebd c\u1ea7n t\u1edbi 2 c\u00f4ng th\u1ee9c, c\u1ee5 th\u1ec3 nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 <strong>I17<\/strong> (t\u00ednh s\u1ed1 d\u01b0 b\u00ean N\u1ee3):<\/p>\n<blockquote>\n<p><strong>=MAX($I$15+SUM($G$17:G17)-$J$15-SUM($H$17:H17),0)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c t\u1ea1i \u00f4 <strong>J17<\/strong> (t\u00ednh s\u1ed1 d\u01b0 b\u00ean C\u00f3):<\/p>\n<blockquote>\n<p><strong>=-MIN($I$15 + SUM($G$17:G17) -$J$15 \u2013 SUM($H$17:H17),0)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">S\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng (ng\u01b0\u1eddi mua) ta theo d\u00f5i ph\u00e1t sinh tr\u00ean TK 131. B\u1ea1n c\u0169ng \u0111\u00e3 bi\u1ebft th\u00ec TK n\u00e0y c\u00f3 th\u1ec3 c\u00f3 s\u1ed1 d\u01b0 b\u00ean N\u1ee3, c\u0169ng c\u00f3 c\u00f3 th\u1ec3 c\u00f3 s\u1ed1 d\u01b0 b\u00ean C\u00f3. V\u1edbi \u0111i\u1ec1u \u0111\u00f3 n\u00ean s\u1ed1 d\u01b0 t\u1ea1i 1 th\u1eddi \u0111i\u1ec3m n\u00f3 c\u00f3 th\u1ec3 b\u00ean N\u1ee3, c\u0169ng c\u00f3 th\u1ec3 b\u00ean c\u00f3 v\u00e0 ta kh\u00f4ng bi\u1ebft tr\u01b0\u1edbc \u0111\u01b0\u1ee3c t\u1ea1i 1 th\u1eddi \u0111i\u1ec3m b\u1ea5t k\u1ef3 n\u00f3 l\u00e0 d\u01b0 N\u1ee3 hay d\u01b0 C\u00f3.<\/p>\n<p style=\"text-align: justify\">Do \u0111\u00f3, khi t\u00ednh lu\u1ef9 ti\u1ebfn \u0111\u00fang t\u1ea1i m\u1ed9t th\u1eddi \u0111i\u1ec3m b\u1ea5t\u00a0k\u1ef3\u00a0th\u00ec ta c\u1ea7n 2 c\u00f4ng th\u1ee9c chung nh\u01b0 tr\u00ean, \u0111\u1ec3 c\u00f3 th\u1ec3 <strong>FillDown<\/strong> xu\u1ed1ng cho c\u00e1c d\u00f2ng c\u00f2n l\u1ea1i th\u00ec v\u1eabn \u0111\u1ea3m b\u1ea3o lu\u00f4n \u0111\u00fang.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/09\/4-8.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-30144 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-8-1024x385-1.png\" alt=\"huong-dan-mot-so-cach-tinh-luy-tien-trong-excel-4\" width=\"1024\" height=\"385\" title=\"4-8-1024x385-1\"><\/a><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Qua b\u00e0i vi\u1ebft n\u00e0y,\u00a0<strong>H\u1ecdc Excel Online<\/strong> hy v\u1ecdng b\u1ea1n \u0111\u00e3 n\u1eafm \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 c\u00e1ch \u0111\u1ec3 c\u00f3 th\u1ec3 <strong>t\u00ednh<\/strong> <strong>lu\u1ef9 ti\u1ebfn trong Excel<\/strong> v\u00e0 v\u1eadn d\u1ee5ng v\u00e0o c\u00f4ng vi\u1ec7c t\u00ednh to\u00e1n h\u00e0ng ng\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng, hi\u1ec7u qu\u1ea3.<\/p>\n<hr>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-lap-theo-kho-so-kho-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u1eadp th\u1ebb kho, s\u1ed5 kho tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-ke-toan-chi-tiet-vat-tu-san-pham-hang-hoa-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft v\u1eadt t\u01b0, s\u1ea3n ph\u1ea9m, h\u00e0ng ho\u00e1 tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lan-so-ke-toan-chi-tiet-cong-no-phai-thu.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft thanh to\u00e1n v\u1edbi kh\u00e1ch h\u00e0ng trong excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-chi-tiet-tien-gui-ngan-hang-trong-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bang-tong-hop-tk-ngan-hang-tren-excel.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u1ea3ng t\u1ed5ng h\u1ee3p c\u00e1c t\u00e0i kho\u1ea3n ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify;padding-left: 30px\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/?p=29254&amp;preview=true\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 qu\u1ef9 ti\u1ec1n m\u1eb7t, s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n m\u1eb7t tr\u00ean Excel<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 Nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a><\/strong><\/em><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><em><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-cai-bang-ham-heosql.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp S\u1ed5 C\u00e1i b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d<\/a><\/strong><\/em><\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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\/2024\/12\/ex101_92019-nho-338.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4227,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4226","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-nang-cao"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4226","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=4226"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4226\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4227"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4226"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4226"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4226"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}