{"id":8808,"date":"2024-12-29T05:34:48","date_gmt":"2024-12-29T05:34:48","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/tong-hop-bao-cao-va-bieu-do-dong-trong-excel\/"},"modified":"2024-12-29T05:34:48","modified_gmt":"2024-12-29T05:34:48","slug":"tong-hop-bao-cao-va-bieu-do-dong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/29\/tong-hop-bao-cao-va-bieu-do-dong-trong-excel\/","title":{"rendered":"T\u1ed5ng h\u1ee3p b\u00e1o c\u00e1o v\u00e0 bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>B\u00e1o c\u00e1o \u0111\u1ed9ng hay c\u00e1c bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u01b0\u01a1ng t\u00e1c \u0111\u01b0\u1ee3c v\u1edbi c\u00e1c th\u00e0nh ph\u1ea7n trong b\u1ea3ng t\u00ednh v\u00ed d\u1ee5 nh\u01b0 Dropdown, n\u00fat l\u1ec7nh , hyperlinks \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 Dashboard. Dashboard cho ch\u00fang ta bi\u1ebft \u0111\u01b0\u1ee3c nh\u1eefng th\u00f4ng tin thi\u1ebft y\u1ebfu nh\u01b0 KPI, c\u00e1c ch\u1ec9 s\u1ed1 c\u1ea7n l\u01b0u \u00fd khi kh\u1ed1i l\u01b0\u1ee3ng d\u1eef li\u1ec7u nhi\u1ec1u v\u00e0 thay \u0111\u1ed5i li\u00ean t\u1ee5c. Thay v\u00ec nh\u00ecn v\u00e0o c\u00e1c con s\u1ed1 kh\u00f4 khan tr\u00ean b\u1ea3ng t\u00ednh th\u00ec Dashboard gi\u00fap ch\u00fang ta c\u00f3 1 c\u00e1i nh\u00ecn r\u1ea5t tr\u1ef1c quan v\u1ec1 d\u1eef li\u1ec7u. B\u00e0i vi\u1ebft n\u00e0y s\u1ebd t\u1ed5ng h\u1ee3p c\u00e1c Dashboard \u0111\u1ec3 c\u00e1c b\u1ea1n tham kh\u1ea3o. Trong video l\u00e0 demo c\u1ee7a 9 Dashboard \u0111\u1ea7u ti\u00ean. C\u00e1c Dashboards n\u00e0y \u0111\u1ec1u ho\u1ea1t \u0111\u1ed9ng t\u1ed1t v\u1edbi Excel 2010 tr\u1edf l\u00ean, m\u1ed9t s\u1ed1 Dashboards c\u00f3 ch\u1ee9a <strong>Macro<\/strong>.<\/p>\n<p><strong>H\u00e3y chia s\u1ebb b\u00e0i vi\u1ebft \u0111\u1ec3 download c\u1ea3 9 dashboards<\/strong><\/p>\n<div class=\"videowrapper\" style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/48H5zfSyrVM?wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/div>\n<div class=\"videowrapper\"><\/div>\n<div class=\"videowrapper\">Download:<\/div>\n<div class=\"videowrapper\"><a href=\"https:\/\/drive.google.com\/folderview?id=0B5Bngmqc66xCTG04U3RjZUU0MmM&amp;usp=sharing\">https:\/\/drive.google.com\/folderview?id=0B5Bngmqc66xCTG04U3RjZUU0MmM&amp;usp=sharing<\/a><\/div>\n<div class=\"videowrapper\"><\/div>\n<div class=\"videowrapper\">Hi\u1ec7n t\u1ea1i, Blog Ho\u0323c Excel Online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/div>\n<div class=\"videowrapper\"><\/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":"<p>B\u00e1o c\u00e1o \u0111\u1ed9ng hay c\u00e1c bi\u1ec3u \u0111\u1ed3 \u0111\u1ed9ng m\u00e0 ng\u01b0\u1eddi d\u00f9ng c\u00f3 th\u1ec3 t\u01b0\u01a1ng t\u00e1c..<\/p>\n","protected":false},"author":1,"featured_media":8809,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8808","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\/8808","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=8808"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8808\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8809"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8808"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8808"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8808"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}