{"id":7697,"date":"2024-12-21T18:17:42","date_gmt":"2024-12-21T18:17:42","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel\/"},"modified":"2024-12-21T18:17:42","modified_gmt":"2024-12-21T18:17:42","slug":"lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel\/","title":{"rendered":"L\u1ea5y d\u1eef li\u1ec7u t\u00e0i ch\u00ednh t\u1ef1 \u0111\u1ed9ng v\u00e0o b\u1ea3ng t\u00ednh Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Vi\u1ec7c l\u1ea5y d\u1eef li\u1ec7u t\u1eeb 1 s\u1ed1 Website v\u1ec1 b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng ph\u00e2n t\u00edch v\u00e0 d\u1ef1 \u0111oan s\u00e2u h\u01a1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n 1 c\u00e1ch t\u1ef1 \u0111\u1ed9ng ngay trong Excel. Excel c\u00f3 th\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u \u0111\u00f3 1 c\u00e1ch ho\u00e0n to\u00e0n t\u1ef1 \u0111\u1ed9ng.<\/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-676706453cbdb\" 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\/lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel.html#Lay_du_lieu_vao_Excel_tu_Google_Finance\" title=\"L\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel t\u1eeb Google Finance\">L\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel t\u1eeb Google Finance<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/lay-du-lieu-tai-chinh-tu-dong-vao-bang-tinh-excel.html#Cap_nhat_du_lieu_trong_Excel\" title=\"C\u1eadp nh\u1eadt d\u1eef li\u1ec7u trong Excel\">C\u1eadp nh\u1eadt d\u1eef li\u1ec7u trong Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Lay_du_lieu_vao_Excel_tu_Google_Finance\"><\/span>L\u1ea5y d\u1eef li\u1ec7u v\u00e0o Excel t\u1eeb Google Finance<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ea3 s\u1eed ch\u00fang ta mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u t\u1eeb trang Google Finance sau \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/1-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-5857\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-data-webpage-excel.png\" alt=\"1-Data-Webpage-Excel\" width=\"990\" height=\"724\" title=\"1-data-webpage-excel\"><\/a><\/p>\n<p>Trong Excel, b\u1ea1n c\u1ea7n m\u1edf th\u1ebb <strong>Data<\/strong>, ch\u1ecdn n\u00fat <strong>From Web<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/2-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5858\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-data-webpage-excel.png\" width=\"753\" height=\"347\" title=\"2-data-webpage-excel\"><\/a><\/p>\n<p>H\u1ed9p tho\u1ea1i <strong>New Web Query<\/strong> xu\u1ea5t hi\u1ec7n<\/p>\n<p>Trong \u00f4 \u0111\u1ecba ch\u1ec9 Web, ch\u00fang ta c\u1ea7n g\u00f5 v\u00e0o \u0111\u1ecba ch\u1ec9 sau \u0111\u00e2y:\u00a0https:\/\/www.google.com\/finance<\/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-691.gif\" title=\"ex101_92019-nho-691\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Sau \u0111\u00f3 b\u1ea5m n\u00fat <strong>Go<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/3-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5859\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-data-webpage-excel.png\" width=\"913\" height=\"664\" title=\"3-data-webpage-excel\"><\/a><\/p>\n<p>B\u00e2y gi\u1edd b\u1ea1n c\u1ea7n ch\u00fa \u00fd \u0111\u1ebfn c\u00e1c m\u0169i t\u00ean m\u00e0u v\u00e0ng \u1edf tr\u00ean h\u00ecnh sau \u0111\u00e2y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/4-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5860\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-data-webpage-excel.png\" width=\"914\" height=\"535\" title=\"4-data-webpage-excel\"><\/a><\/p>\n<p>di chu\u1ed9t l\u00ean ph\u00eda tr\u00ean m\u0169i t\u00ean m\u00e0u v\u00e0ng n\u00e0y, ph\u1ea7n b\u1ea3ng ch\u1ee9a d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u1ecdn<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/5-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5861\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-data-webpage-excel.png\" width=\"1226\" height=\"710\" title=\"5-data-webpage-excel\"><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/6-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5862\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-data-webpage-excel.png\" width=\"1009\" height=\"701\" title=\"6-data-webpage-excel\"><\/a><\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn nhi\u1ec1u h\u01a1n 1 v\u00f9ng tr\u00ean trang web, v\u00ed d\u1ee5 nh\u01b0\u00a0World Markets data, Currency Data, v\u00e0 Summary.<\/p>\n<p>Sau \u0111\u00f3 ch\u00fang ta c\u1ea7n b\u1ea5m n\u00fat <strong>Import.\u00a0<\/strong>H\u1ed9p tho\u1ea1i\u00a0<strong>Import Data\u00a0<\/strong>\u0111\u01b0\u1ee3c m\u1edf ra, h\u1ecfi ch\u00fang ta mu\u1ed1n l\u01b0u d\u1eef li\u1ec7u v\u00e0o \u00f4 n\u00e0o. \u1ede \u0111\u00e2y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn \u00f4 A1<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/7-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5863\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-data-webpage-excel.png\" width=\"449\" height=\"629\" title=\"7-data-webpage-excel\"><\/a><\/p>\n<p>Nh\u01b0 v\u1eady l\u00e0 ch\u00fang ta \u0111\u00e3 l\u1ea5y \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u1eeb Website v\u00e0o trong Excel. V\u1ea5n \u0111\u1ec1 khi d\u1eef li\u1ec7u n\u00e0y thay \u0111\u1ed5i th\u00ec l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 ch\u00fang ta c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng trong Excel?<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/excel-co-ban\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel c\u01a1 b\u1ea3n<\/a>\u00a0Online mi\u1ec5n ph\u00ed<\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Cap_nhat_du_lieu_trong_Excel\"><\/span>C\u1eadp nh\u1eadt d\u1eef li\u1ec7u trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>B\u1ea1n c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u b\u1eb1ng tay ho\u1eb7c t\u1ef1 \u0111\u1ed9ng. \u0110\u1ec3 c\u1eadp nh\u1eadt b\u1eb1ng tay, b\u1ea1n s\u1ebd c\u1ea7n v\u00e0o th\u1ebb <strong>Data\u00a0<\/strong>r\u1ed3i b\u1ea5m n\u00fat\u00a0<strong>Refresh All\u00a0<\/strong>(ph\u00edm t\u1eaft l\u00e0 CTRL + SHIFT + F5)<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/9-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5864\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-data-webpage-excel.png\" width=\"755\" height=\"508\" title=\"9-data-webpage-excel\"><\/a><\/p>\n<p>\u0111\u1ec3 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u 1 c\u00e1ch t\u1ef1 \u0111\u1ed9ng sau 1 kho\u1ea3ng th\u1eddi gian, ta c\u00f3 th\u1ec3 l\u00e0m nh\u01b0 sau:<\/p>\n<p>Trong th\u1ebb <strong>Data<\/strong>, nh\u00f3m l\u1ec7nh <strong>Connections,\u00a0<\/strong>b\u1ea5m\u00a0<strong>Properties<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/11-Data-Webpage-Excel.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5865\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-data-webpage-excel.png\" width=\"994\" height=\"493\" title=\"11-data-webpage-excel\"><\/a><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o m\u1ee5c\u00a0<strong>Refresh Every,\u00a0<\/strong>v\u00e0 ch\u1ecdn sau bao l\u00e2u th\u00ec Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt d\u1eef li\u1ec7u cho b\u1ea1n ho\u1eb7c \u0111\u00e1nh d\u1ea5u t\u00edch v\u00e0o m\u1ee5c\u00a0<strong>Refresh data when opening the file\u00a0<\/strong>\u0111\u1ec3 c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt d\u1eef li\u1ec7u t\u1ef1 \u0111\u00f4ng khi m\u1edf file. V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 y\u00ean t\u00e2m t\u1ea1o c\u1ea3 <a href=\"https:\/\/hocexcel.online\/course\/preview\/dv101-hieu-va-phan-tich-du-lieu-ra-quyet-dinh-voi-bieu-do-excel\" target=\"_blank\" rel=\"noopener noreferrer\">1 Dashboard hay nhi\u1ec1u b\u00e1o c\u00e1o kh\u00e1c v\u1ec1 s\u1ed1 li\u1ec7u n\u00e0y d\u1ef1a tr\u00ean s\u1ed1 li\u1ec7u<\/a> \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt 1 c\u00e1ch t\u1ef1 \u0111\u1ed9ng n\u00e0y.<\/p>\n<p style=\"text-align: left\">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\u00ea\u0309u 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:<\/p>\n<p style=\"text-align: justify\">\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-691.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7698,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7697","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\/7697","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=7697"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7697\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7698"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7697"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7697"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7697"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}