{"id":4967,"date":"2024-12-08T18:03:25","date_gmt":"2024-12-08T18:03:25","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel\/"},"modified":"2024-12-08T18:03:25","modified_gmt":"2024-12-08T18:03:25","slug":"tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/08\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel\/","title":{"rendered":"T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ee5c\u00a0\u0111\u00edch c\u1ee7a ch\u00fang ta khi h\u1ecdc\u00a0Excel\u00a0\u0111\u00f3 l\u00e0 c\u00f3 th\u1ec3 t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u t\u1ed1t, t\u1eeb\u00a0\u0111\u00f3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o theo y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c. Th\u1ebf nh\u01b0ng ch\u00fang ta c\u0169ng g\u1eb7p ph\u1ea3i v\u00f4 v\u00e0n nh\u1eefng th\u1eafc m\u1eafc nh\u01b0:<\/p>\n<ul>\n<li>T\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o l\u00e0 t\u1ed1t?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 ki\u1ec3m tra d\u1eef li\u1ec7u tr\u00ean\u00a0Excel\u00a0\u0111\u1ec3\u00a0\u0111\u1ea3m b\u1ea3o t\u00ednh ch\u00ednh x\u00e1c c\u1ee7a d\u1eef li\u1ec7u?<\/li>\n<li>L\u00e0m th\u1ebf n\u00e0o\u00a0\u0111\u1ec3 l\u1eadp\u00a0\u0111\u01b0\u1ee3c c\u00e1c b\u00e1o c\u00e1o tr\u00ean\u00a0Excel?<\/li>\n<li>B\u00e1o c\u00e1o th\u1ebf n\u00e0o l\u00e0\u00a0\u0111\u1eb9p, khoa h\u1ecdc?<\/li>\n<li>\u2026<\/li>\n<\/ul>\n<p>Nh\u1eb1m gi\u00fap c\u00e1c b\u1ea1n h\u00ecnh th\u00e0nh t\u01b0 duy t\u1ed1t trong vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel, H\u1ecdc\u00a0Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n seri b\u00e0i vi\u1ebft v\u1ec1 \u201cK\u1ef9 n\u0103ng t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel\u201d. B\u00e0i vi\u1ebft c\u1ee7a t\u00e1c gi\u1ea3 D\u01b0\u01a1ng M\u1ea1nh Qu\u00e2n \u2013 Gi\u1ea3ng vi\u00ean c\u1ee7a H\u1ecdc\u00a0Excel Online, d\u1ef1a tr\u00ean nh\u1eefng kinh nghi\u1ec7m gi\u1ea3ng d\u1ea1y trong th\u1ef1c t\u1ebf c\u1ee7a th\u1ea7y li\u00ean quan t\u1edbi n\u1ed9i dung n\u00e0y. M\u1eddi c\u00e1c b\u1ea1n c\u00f9ng t\u00ecm hi\u1ec3u 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-6755df6cdfd21\" 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\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html#Bai_1_Tim_hieu_ve_cac_dang_bao_cao_thuong_gap_tren_Excel\" title=\"B\u00e0i 1:\u00a0T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel\">B\u00e0i 1:\u00a0T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel<\/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\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html#1_Xet_theo_dac_diem_bao_cao\" title=\"1. X\u00e9t theo \u0111\u1eb7c \u0111i\u1ec3m\u00a0b\u00e1o c\u00e1o\">1. X\u00e9t theo \u0111\u1eb7c \u0111i\u1ec3m\u00a0b\u00e1o c\u00e1o<\/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\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html#2_Xet_ve_dang_bao_cao\" title=\"2. X\u00e9t v\u1ec1 d\u1ea1ng b\u00e1o c\u00e1o\">2. X\u00e9t v\u1ec1 d\u1ea1ng b\u00e1o c\u00e1o<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tim-hieu-ve-cac-dang-bao-cao-thuong-gap-tren-excel.html#3_Cau_truc_bao_cao\" title=\"3. C\u1ea5u tr\u00fac b\u00e1o c\u00e1o\">3. C\u1ea5u tr\u00fac b\u00e1o c\u00e1o<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Bai_1_Tim_hieu_ve_cac_dang_bao_cao_thuong_gap_tren_Excel\"><\/span>B\u00e0i 1:\u00a0T\u00ecm hi\u1ec3u v\u1ec1 c\u00e1c d\u1ea1ng b\u00e1o c\u00e1o th\u01b0\u1eddng g\u1eb7p tr\u00ean Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00f4ng th\u01b0\u1eddng\u00a0vi\u1ec7c l\u1eadp\u00a0b\u00e1o c\u00e1o tr\u00ean\u00a0Excel th\u01b0\u1eddng c\u00f3 m\u1ed9t s\u1ed1 y\u00eau c\u1ea7u c\u1ee5 th\u1ec3:<\/p>\n<h3><span class=\"ez-toc-section\" id=\"1_Xet_theo_dac_diem_bao_cao\"><\/span>1. X\u00e9t theo \u0111\u1eb7c \u0111i\u1ec3m\u00a0b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>B\u00e1o c\u00e1o\u00a0t\u1ed5ng h\u1ee3p<\/strong>: D\u00f9ng\u00a0\u0111\u1ec3 t\u1ed5ng k\u1ebft,\u00a0\u0111\u00e1nh gi\u00e1 t\u1ed5ng quan v\u1ec1 c\u00e1c n\u1ed9i dung c\u1ea7n b\u00e1o c\u00e1o. Th\u01b0\u1eddng g\u1eafn v\u1edbi nh\u1eefng y\u00eau c\u1ea7u nh\u01b0: T\u00ednh t\u1ed5ng,\u00a0\u0111\u1ebfm s\u1ed1 l\u1ea7n, t\u00ednh\u2026<\/li>\n<li><strong>B\u00e1o c\u00e1o\u00a0chi ti\u1ebft<\/strong>: D\u00f9ng\u00a0\u0111\u1ec3 tr\u00edch l\u1ecdc ra nh\u1eefng n\u1ed9i dung di\u1ec5n bi\u1ebfn chi ti\u1ebft li\u00ean quan t\u1edbi\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o. Th\u01b0\u1eddng g\u1eafn v\u1edbi nh\u1eefng y\u00eau c\u1ea7u nh\u01b0: th\u1ed1ng k\u00ea, li\u1ec7t k\u00ea, l\u1ecdc, t\u00ecm\u2026<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"2_Xet_ve_dang_bao_cao\"><\/span>2. X\u00e9t v\u1ec1 d\u1ea1ng b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul>\n<li><strong>B\u00e1o c\u00e1o d\u1ea1ng b\u1ea3ng<\/strong>: C\u00e1c n\u1ed9i dung trong b\u00e1o c\u00e1o\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n trong c\u00e1c b\u1ea3ng d\u1eef li\u1ec7u<\/li>\n<li><strong>B\u00e1o c\u00e1o d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3<\/strong>: C\u00e1c n\u1ed9i dung trong b\u00e1o c\u00e1o\u00a0\u0111\u01b0\u1ee3c bi\u1ec3u di\u1ec5n d\u01b0\u1edbi d\u1ea1ng bi\u1ec3u\u00a0\u0111\u1ed3<\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"3_Cau_truc_bao_cao\"><\/span>3. C\u1ea5u tr\u00fac b\u00e1o c\u00e1o<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u00f9y theo\u00a0y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c, c\u00e1c b\u00e1o c\u00e1o c\u00f3 c\u1ea5u tr\u00fac t\u1eeb\u00a0\u0111\u01a1n gi\u1ea3n t\u1edbi ph\u1ee9c t\u1ea1p. C\u00f3 m\u1ed9t s\u1ed1 l\u01b0u\u00a0\u00fd nh\u01b0 sau:<\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 1 chi\u1ec1u<\/strong>: l\u00e0 b\u00e1o c\u00e1o d\u1ef1a theo 1\u00a0\u0111i\u1ec1u ki\u1ec7n, 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng nh\u1ea5t\u00a0\u0111\u1ecbnh. C\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o th\u01b0\u1eddng l\u00e0\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u1ea7n b\u00e1o c\u00e1o n\u1eb1m\u00a0\u1edf c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean trong b\u1ea3ng b\u00e1o c\u00e1o. C\u00e1c c\u1ed9t c\u00f2n l\u1ea1i l\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16898\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-01-chieu.png\" width=\"272\" height=\"213\" title=\"bao-cao-01-chieu\"><\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 2 chi\u1ec1u<\/strong>: l\u00e0 b\u00e1o c\u00e1o d\u1ef1a theo 2\u00a0\u0111i\u1ec1u ki\u1ec7n. C\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o th\u01b0\u1eddng l\u00e0 1\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng n\u1eb1m\u00a0\u1edf c\u1ed9t\u00a0\u0111\u1ea7u ti\u00ean trong b\u1ea3ng b\u00e1o c\u00e1o, c\u00e1c\u00a0\u0111\u1ed1i t\u01b0\u1ee3ng c\u00f2n l\u1ea1i n\u1eb1m\u00a0\u1edf nhi\u1ec1u c\u1ed9t (tr\u00ean c\u00f9ng 1 h\u00e0ng). Giao\u00a0\u0111i\u1ec3m gi\u1eefa \u0111i\u1ec1u ki\u1ec7n n\u1eb1m \u1edf c\u00e1c h\u00e0ng v\u00e0 c\u00e1c c\u1ed9t l\u00e0 k\u1ebft qu\u1ea3 c\u1ea7n b\u00e1o c\u00e1o (ph\u1ee5 thu\u1ed9c 2\u00a0\u0111i\u1ec1u ki\u1ec7n)<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16899\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-02-chieu.png\" width=\"474\" height=\"238\" title=\"bao-cao-02-chieu\"><\/p>\n<ul>\n<li><strong>B\u00e1o c\u00e1o 3 chi\u1ec1u<\/strong>: l\u00e0 b\u00e1o c\u00e1o d\u1ef1a theo nhi\u1ec1u h\u01a1n 2\u00a0\u0111i\u1ec1u ki\u1ec7n. C\u1ea5u tr\u00fac c\u1ee7a b\u00e1o c\u00e1o n\u00e0y gi\u1ed1ng v\u1edbi b\u00e1o c\u00e1o 2 chi\u1ec1u nh\u01b0ng c\u00f3 th\u00eam c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n ph\u1ee5 b\u00ean ngo\u00e0i\u00a0\u0111\u1ec3 k\u1ebft h\u1ee3p v\u1edbi c\u00e1c\u00a0\u0111i\u1ec1u ki\u1ec7n trong b\u1ea3ng b\u00e1o c\u00e1o t\u1ea1o th\u00e0nh 3 chi\u1ec1u.<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-16900\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/bao-cao-03-chieu.png\" width=\"478\" height=\"268\" title=\"bao-cao-03-chieu\"><\/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\/2024\/12\/ex101_92019-nho-412.gif\" title=\"ex101_92019-nho-412\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch t\u1ed5 ch\u1ee9c\u00a0d\u1eef li\u1ec7u, c\u00e1ch qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 x\u00e2y d\u1ef1ng c\u00e1c b\u00e1o c\u00e1o n\u00e0y, m\u1eddi c\u00e1c b\u1ea1n t\u00ecm hi\u1ec3u trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo c\u1ee7a Seri n\u00e0y.<\/p>\n<p>B\u00e0i ti\u1ebfp theo:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-xay-dung-bang-du-lieu-chuan-de-lap-bao-cao-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch x\u00e2y d\u1ef1ng b\u1ea3ng d\u1eef li\u1ec7u chu\u1ea9n \u0111\u1ec3 l\u1eadp b\u00e1o c\u00e1o tr\u00ean Excel<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n \u201c<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>\u201c.\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\u00a0\u0111\u00e1p\u00a0\u1ee9ng y\u00eau c\u1ea7u c\u00f4ng vi\u1ec7c t\u1ed5 ch\u1ee9c, qu\u1ea3n l\u00fd d\u1eef li\u1ec7u v\u00e0 l\u1eadp b\u00e1o c\u00e1o tr\u00ean\u00a0Excel.<\/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\/2024\/12\/ex101_92019-nho-412.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4968,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4967","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\/4967","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=4967"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4967\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4968"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4967"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4967"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4967"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}