{"id":7437,"date":"2024-12-21T17:37:11","date_gmt":"2024-12-21T17:37:11","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lam-viec-voi-ban-do-trong-excel-2016-2010\/"},"modified":"2024-12-21T17:37:11","modified_gmt":"2024-12-21T17:37:11","slug":"lam-viec-voi-ban-do-trong-excel-2016-2010","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lam-viec-voi-ban-do-trong-excel-2016-2010\/","title":{"rendered":"L\u00e0m vi\u1ec7c v\u1edbi b\u1ea3n \u0111\u1ed3 trong Excel 2016-2010"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <a href=\"https:\/\/hocexcel.online\">H\u1ecdc Excel Online<\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n t\u1ea1o m\u1ed9t b\u00e1o c\u00e1o tuy\u1ec7t v\u1eddi hi\u1ec3n th\u1ecb nh\u1eefng \u0111\u1ea5t n\u01b0\u1edbc, th\u00e0nh ph\u1ed1, nh\u1eefng \u0111\u1ecba \u0111i\u1ec3m \u0111\u1ecba l\u00fd c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\"><strong>Kh\u1edfi \u0111\u1ed9ng<\/strong><\/p>\n<p style=\"text-align: justify\">H\u00e3y b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t trang t\u00ednh Excel \u0111\u01a1n gi\u1ea3n.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sample-sheet.png\" alt=\"Start with a simple Excel sheet\" title=\"excel-sample-sheet\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fang ta c\u00f3 \u0111\u1ea5t n\u01b0\u1edbc, doanh thu v\u00e0 s\u1ed1 l\u01b0\u1ee3ng kh\u00e1ch h\u00e0ng trong trang t\u00ednh Excel. Ch\u00fang ta mu\u1ed1n th\u1ea5y doanh thu c\u1ee7a m\u1ed7i \u0111\u1ea5t n\u01b0\u1edbc tr\u00ean b\u1ea3n \u0111\u1ed3 th\u1ebf gi\u1edbi th\u00f4ng qua Excel. V\u1eady, h\u00e3y l\u1eadp m\u1ed9t b\u00e1o c\u00e1o c\u00f3 ch\u1ee9a b\u1ea3n \u0111\u1ed3 trong \u0111\u00f3.<\/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-6766fcc6980fd\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/lam-viec-voi-ban-do-trong-excel-2016-2010.html#Cong_cu_Power_View\" title=\"C\u00f4ng c\u1ee5\u00a0Power View\">C\u00f4ng c\u1ee5\u00a0Power View<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lam-viec-voi-ban-do-trong-excel-2016-2010.html#Cach_hien_thi_dat_nuoc_va_thanh_pho_cu_the_bang_Power_View\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb \u0111\u1ea5t n\u01b0\u1edbc v\u00e0 th\u00e0nh ph\u1ed1 c\u1ee5 th\u1ec3 b\u1eb1ng Power View\">C\u00e1ch hi\u1ec3n th\u1ecb \u0111\u1ea5t n\u01b0\u1edbc v\u00e0 th\u00e0nh ph\u1ed1 c\u1ee5 th\u1ec3 b\u1eb1ng Power View<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/lam-viec-voi-ban-do-trong-excel-2016-2010.html#Cach_hien_thi_toa_do_dia_ly_tren_ban_do\" title=\"C\u00e1ch hi\u1ec3n th\u1ecb t\u1ecda \u0111\u1ed9 \u0111\u1ecba l\u00fd tr\u00ean b\u1ea3n \u0111\u1ed3\">C\u00e1ch hi\u1ec3n th\u1ecb t\u1ecda \u0111\u1ed9 \u0111\u1ecba l\u00fd tr\u00ean b\u1ea3n \u0111\u1ed3<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cong_cu_Power_View\"><\/span>C\u00f4ng c\u1ee5\u00a0<strong><em>Power View<\/em><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ea7u ti\u00ean, ch\u1ecdn d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. Nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng <strong><em>Format as Table <\/em><\/strong>v\u00e0 ch\u1ecdn m\u1ed9t ki\u1ec3u b\u1ea3ng bi\u1ec3u (<strong><em>table style)<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5887\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-93.png\" width=\"600\" height=\"208\" title=\"excel-dialog-box-launcher-1-93\"><\/p>\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-298.gif\" title=\"vba101_92019-nho-298\"><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-667.gif\" title=\"ex101_92019-nho-667\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">B\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd tr\u00f4ng nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-view-table-sample.png\" alt=\"A sample table for a Power View report\" title=\"power-view-table-sample\"><\/p>\n<p style=\"text-align: justify\">B\u01b0\u1edbc ti\u1ebfp theo l\u00e0 t\u1ea1o bi\u1ec3u \u0111\u1ed3 v\u1edbi <strong><em>Power View<\/em><\/strong>. \u0110\u1ec3 th\u1ef1c hi\u1ec7n \u0111i\u1ec1u n\u00e0y, ch\u1ecdn th\u1ebb <strong><em>INSERT &gt; Power View<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5888\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-94.png\" width=\"600\" height=\"102\" title=\"excel-dialog-box-launcher-1-94\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu \u0111\u00e2y l\u00e0 l\u1ea7n \u0111\u1ea7u ti\u00ean b\u1ea1n s\u1eed d\u1ee5ng <strong><em>Power View<\/em><\/strong>, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u k\u00edch ho\u1ea1t t\u00ednh n\u0103ng n\u00e0y. V\u00ec v\u1eady, ch\u1ec9 c\u1ea7n nh\u1ea5n n\u00fat <strong><em>Enable<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5890\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-96.png\" width=\"600\" height=\"102\" title=\"excel-dialog-box-launcher-1-96\"><\/p>\n<p style=\"text-align: justify\">Ch\u00fa \u00fd r\u1eb1ng b\u1ea1n c\u1ea7n c\u00e0i \u0111\u1eb7t <strong><em>Silverlight \u2013 <\/em><\/strong>m\u1ed9t c\u00f4ng c\u1ee5 t\u1ea1o \u1ee9ng d\u1ee5ng t\u01b0\u01a1ng t\u00e1c b\u1eaft bu\u1ed9c \u0111\u1ec3 <strong><em>Power View <\/em><\/strong>ho\u1ea1t \u0111\u1ed9ng. B\u1ea1n s\u1ebd th\u1ea5y th\u00f4ng b\u00e1o y\u00eau c\u1ea7u c\u00e0i \u0111\u1eb7t ch\u01b0\u01a1ng tr\u00ecnh. Nh\u1ea5n <strong><em>Install Silverlight <\/em><\/strong>\u0111\u1ec3 ti\u1ebfn h\u00e0nh c\u00e0i \u0111\u1eb7t.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5889\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-95.png\" width=\"600\" height=\"37\" title=\"excel-dialog-box-launcher-1-95\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n nh\u1eadn th\u00f4ng b\u00e1o r\u1eb1ng c\u00e0i \u0111\u1eb7t b\u1ea3o m\u1eadt hi\u1ec7n t\u1ea1i kh\u00f4ng cho ph\u00e9p t\u1ec7p n\u00e0y \u0111\u01b0\u1ee3c t\u1ea3i xu\u1ed1ng, h\u00e3y truy c\u1eadp v\u00e0o <strong><em>Your current security settings do not allow this file to be downloaded <\/em><\/strong>\u0111\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t khi \u0111\u00e3 k\u00edch ho\u1ea1t, trang t\u00ednh m\u1edbi s\u1ebd \u0111\u01b0\u1ee3c t\u1ea1o tr\u00ean b\u00e1o c\u00e1o <strong><em>Power View<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-view-sheet-excel.jpg\" alt=\"A new sheet will be created for our Power View reports\" title=\"power-view-sheet-excel\"><\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn t\u00f9y ch\u1ecdn <strong><em>Map<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/map-option-excel2013.jpg\" alt=\"Choose the Map option\" title=\"map-option-excel2013\"><br \/>\n\u0110\u1ec3 ph\u00f3ng to b\u1ea3n \u0111\u1ed3, nh\u1ea5p v\u00e0o g\u00f3c d\u01b0\u1edbi b\u00ean ph\u1ea3i v\u00e0 k\u00e9o th\u1ea3 v\u1ec1 b\u00ean ph\u1ea3i xu\u1ed1ng d\u01b0\u1edbi.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/enlarge-map-excel2013.jpg\" alt=\"Click in the bottom right corner and move your mouse cursor to the right and down\" title=\"enlarge-map-excel2013\"><br \/>\nB\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y nh\u1eefng \u0111\u1ea5t n\u01b0\u1edbc trong trang t\u00ednh Excel (Nam Phi, Ph\u00e1p, \u00dd v\u00e0 Bolivia) b\u00e2y gi\u1edd \u0111ang hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3n \u0111\u1ed3:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/countries-map-excel2013.jpg\" alt=\"Countries from your Excel Sheet are on the map\" title=\"countries-map-excel2013\"><br \/>\n<strong>C\u00e1c v\u00f2ng tr\u00f2n m\u00e0u xanh c\u00f3 ngh\u0129a l\u00e0 g\u00ec?<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1c v\u00f2ng tr\u00f2n m\u00e0u xanh tr\u00ean b\u1ea3n \u0111\u1ed3 \u0111\u1ea1i di\u1ec7n cho doanh thu. V\u00f2ng tr\u00f2n c\u00e0ng l\u1edbn, doanh thu c\u00e0ng nhi\u1ec1u. V\u1edbi <strong><em>Power View <\/em><\/strong>b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn nh\u1eefng ti\u00eau ch\u00ed \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n tr\u00ean b\u1ea3n \u0111\u1ed3 b\u1eb1ng trong h\u1ed9p <strong><em>SIZE <\/em><\/strong>trong b\u1ea3ng <strong><em>Power View Fields<\/em><\/strong>:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/power-view-fields-excel.jpg\" alt=\"See the Power View Fields pane\" title=\"power-view-fields-excel\"><\/p>\n<p style=\"text-align: justify\"><strong>Power View c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb th\u00e0nh ph\u1ed1 kh\u00f4ng?<\/strong><\/p>\n<p style=\"text-align: justify\"><strong><em>Power View <\/em><\/strong>c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb th\u00e0nh ph\u1ed1. H\u00e3y th\u1eed t\u00ednh n\u0103ng n\u00e0y v\u1edbi b\u1ea3ng d\u1eef li\u1ec7u sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-table-sample.jpg\" alt=\"Sample table in Excel 2013\" title=\"excel-table-sample\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n mu\u1ed1n th\u1ea5y doanh thu c\u1ee7a m\u1ed7i th\u00e0nh ph\u1ed1 tr\u00ean b\u1ea3n \u0111\u1ed3, h\u00e3y th\u1ef1c hi\u1ec7n t\u01b0\u01a1ng t\u1ef1 c\u00e1c b\u01b0\u1edbc t\u1ea1o b\u00e1o c\u00e1o \u0111\u1ed1i v\u1edbi qu\u1ed1c gia. L\u1ea7n n\u00e0y s\u1ebd d\u1ec5 d\u00e0ng h\u01a1n v\u00ec b\u1ea1n kh\u00f4ng ph\u1ea3i c\u00e0i \u0111\u1eb7t hay k\u00edch ho\u1ea1t th\u00eam b\u1ea5t c\u1ee9 g\u00ec.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n s\u1ebd t\u1ea1o m\u1ed9t trang t\u00ednh <strong><em>Power View <\/em><\/strong>m\u1edbi v\u00e0 ch\u1ecdn t\u00f9y ch\u1ecdn b\u1ea3n \u0111\u1ed3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5891\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-97.png\" width=\"600\" height=\"276\" title=\"excel-dialog-box-launcher-1-97\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, <strong><em>Power View <\/em><\/strong>\u0111\u00e1nh d\u1ea5u c\u00e1c th\u00e0nh ph\u1ed1 v\u00e0 hi\u1ec3n th\u1ecb Houston, San Jose v\u00e0 Des Moines.<\/p>\n<p style=\"text-align: justify\">\u0110\u00f4i khi, c\u00f3 nh\u1eefng th\u00e0nh ph\u1ed1 c\u00f9ng t\u00ean nh\u01b0ng thu\u1ed9c c\u00e1c qu\u1ed1c gia kh\u00e1c nhau. V\u00ed d\u1ee5, M\u1ef9, Chile, T\u00e2y Ban Nha v\u00e0 Bolivia \u0111\u1ec1u c\u00f3 th\u00e0nh ph\u1ed1 Santa Cruz. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, b\u1ea1n c\u1ea7n m\u00f4 t\u1ea3 chi ti\u1ebft h\u01a1n \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u00fang th\u00e0nh ph\u1ed1 b\u1ea1n c\u1ea7n.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_dat_nuoc_va_thanh_pho_cu_the_bang_Power_View\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb \u0111\u1ea5t n\u01b0\u1edbc v\u00e0 th\u00e0nh ph\u1ed1 c\u1ee5 th\u1ec3 b\u1eb1ng Power View<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 gi\u1ea3i quy\u1ebft v\u1ea5n \u0111\u1ec1 v\u1edbi c\u00e1c th\u00e0nh ph\u1ed1 \u0111\u01b0\u1ee3c \u0111\u1eb7t t\u00ean gi\u1ed1ng nhau, b\u1ea1n c\u1ea7n ch\u1ec9 \u0111\u1ecbnh c\u1ea3 t\u00ean c\u1ee7a th\u00e0nh ph\u1ed1 v\u00e0 qu\u1ed1c gia trong Excel:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cities-sample-excel-table.jpg\" alt=\"Specify both the name of the city and country in Excel\" title=\"cities-sample-excel-table\"><\/p>\n<p style=\"text-align: justify\">Trong c\u1ed9t th\u00e0nh ph\u1ed1, g\u00f5 t\u00ean th\u00e0nh ph\u1ed1 v\u00e0 qu\u1ed1c gia ng\u0103n c\u00e1ch nhau b\u1eb1ng d\u1ea5u ph\u1ea9y.<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p ph\u1ea3i v\u00e0o b\u1ea3n \u0111\u1ed3 v\u00e0 ch\u1ecdn <strong><em>Refresh Sheet <\/em><\/strong>\u0111\u1ec3 c\u1eadp nh\u1eadt th\u00f4ng tin.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/refresh-sheet-option-excel.jpg\" alt=\"To update the information right click on the map and select the option Refresh Sheet\" title=\"refresh-sheet-option-excel\"><\/p>\n<p style=\"text-align: justify\">B\u1eb1ng vi\u1ec7c ch\u1ec9 ra qu\u1ed1c gia c\u1ee5 th\u1ec3, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1eafc ch\u1eafn r\u1eb1ng t\u1ea5t c\u1ea3 c\u00e1c th\u00e0nh ph\u1ed1 trong b\u1ea3ng Excel \u0111\u1ec1u thu\u1ed9c n\u01b0\u1edbc M\u1ef9.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/cities-map-excel.jpg\" alt=\"Cities on the map in Excel 2013\" title=\"cities-map-excel\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_hien_thi_toa_do_dia_ly_tren_ban_do\"><\/span><strong>C\u00e1ch hi\u1ec3n th\u1ecb t\u1ecda \u0111\u1ed9 \u0111\u1ecba l\u00fd tr\u00ean b\u1ea3n \u0111\u1ed3<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Excel 2013 c\u0169ng c\u00f3 th\u1ec3 hi\u1ec3n th\u1ecb t\u1ecda \u0111\u1ed9 \u0111\u1ecba l\u00fd tr\u00ean b\u1ea3n \u0111\u1ed3. Ch\u00fang ta c\u1ea7n kinh \u0111\u1ed9 v\u00e0 v\u0129 \u0111\u1ed9 \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c \u0111i\u1ec3m tr\u00ean b\u1ea3n \u0111\u1ed3.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n ch\u01b0a bi\u1ebft v\u1ec1 v\u0129 \u0111\u1ed9 v\u00e0 kinh \u0111\u1ed9, h\u00e3y xem b\u00e0i vi\u1ebft H\u1ec7 th\u1ed1ng t\u1ecda \u0111\u1ed9 \u0111\u1ecba l\u00fd.<\/p>\n<p style=\"text-align: justify\">Trong Excel, b\u1ea1n s\u1ebd c\u1ea7n v\u0129 \u0111\u1ed9 v\u00e0 kinh \u0111\u1ed9 \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c \u0111i\u1ec3m c\u1ee5 th\u1ec3. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong><em>Google Earth<\/em><\/strong> tr\u00ean \u0111i\u1ec7n tho\u1ea1i c\u1ee7a m\u00ecnh ho\u1eb7c b\u1ea5t k\u1ef3 c\u00f4ng c\u1ee5 n\u00e0o kh\u00e1c.<\/p>\n<p style=\"text-align: justify\">Trong v\u00ed d\u1ee5 n\u00e0y, t\u00f4i s\u1ebd s\u1eed d\u1ee5ng website satelliteview.com<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5893\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-98.png\" width=\"600\" height=\"295\" title=\"excel-dialog-box-launcher-1-98\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, kinh \u0111\u1ed9 v\u00e0 v\u0129 \u0111\u1ed9 \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n trong b\u1ea5t k\u1ef3 b\u00e0i vi\u1ebft n\u00e0o tr\u00ean trang web n\u00e0y.<\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, b\u1ea1n s\u1ebd c\u1ea7n m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u ch\u1ee9a c\u1ed9t kinh \u0111\u1ed9 (Longtitude) v\u00e0 v\u0129 \u0111\u1ed9 (Latitude):<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/latitude-longitude-sample-table.jpg\" alt=\"Table with the Latitude and Longitude columns in Excel 2013\" title=\"latitude-longitude-sample-table\"><\/p>\n<p style=\"text-align: justify\">V\u00e0o <strong><em>INSERT &gt; Power View <\/em><\/strong>v\u00e0 t\u1ea1o b\u1ea3n \u0111\u1ed3.<\/p>\n<p style=\"text-align: justify\"><strong><em>Power View <\/em><\/strong>s\u1ebd d\u00f2 t\u00ecm tr\u00ean c\u1ed9t Longtitude v\u00e0 Latitude. Ch\u00fang ta ph\u1ea3i th\u00eam ti\u00eau ch\u00ed Revenue (Doanh thu) b\u1eb1ng h\u1ed9p <strong><em>LOCATIONS<\/em><\/strong> \u0111\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb doanh thu c\u1ee7a m\u1ed7i c\u1eeda h\u00e0ng tr\u00ean b\u1ea3n \u0111\u1ed3.<br \/>\n<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/06\/locations-revenue-power-view.jpg\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-32332\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/locations-revenue-power-view.jpg\" width=\"260\" height=\"485\" title=\"locations-revenue-power-view\"><\/a><\/p>\n<p style=\"text-align: justify\">\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd, c\u00e1c c\u1eeda h\u00e0ng \u0111\u00e3 \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb tr\u00ean b\u1ea3n \u0111\u1ed3.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel2013-report-map.jpg\" alt=\"See your report in Excel with Power View\" title=\"excel2013-report-map\"><\/p>\n<p style=\"text-align: justify\">Ngu\u1ed3n: Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel 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\/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-298.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7438,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7437","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\/7437","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=7437"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7437\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7438"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7437"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7437"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7437"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}