{"id":8380,"date":"2024-12-22T14:22:02","date_gmt":"2024-12-22T14:22:02","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select\/"},"modified":"2024-12-22T14:22:02","modified_gmt":"2024-12-22T14:22:02","slug":"series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/22\/series-%e2%96%b6-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select\/","title":{"rendered":"SERIES \u25b6 L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 1 \u2013 SELECT"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><strong>N\u1ed9i dung ch\u00ednh<\/strong><\/p>\n<ul id=\"markdown-toc\">\n<li><a id=\"markdown-toc-sql-l-ci-g\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#sql-l-ci-g\">SQL l\u00e0 c\u00e1i g\u00ec?<\/a><\/li>\n<li><a id=\"markdown-toc-cc-v-d-v-vic-s-dng-sql-vi-select\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#cc-v-d-v-vic-s-dng-sql-vi-select\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SQL v\u1edbi SELECT<\/a>\n<ul>\n<li><a id=\"markdown-toc-truy-cp-ton-b-d-liu-t-bng-tnh-excel-bng-sql\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#truy-cp-ton-b-d-liu-t-bng-tnh-excel-bng-sql\">1. Truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<\/a><\/li>\n<li><a id=\"markdown-toc-truy-cp-d-liu-t-bng-tnh-excel-theo-ct\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#truy-cp-d-liu-t-bng-tnh-excel-theo-ct\">2. Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel theo c\u1ed9t<\/a><\/li>\n<li><a id=\"markdown-toc-tnh-ton-trc-tip-da-trn-cu-lnh-sql-trong-excel\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#tnh-ton-trc-tip-da-trn-cu-lnh-sql-trong-excel\">3. T\u00ednh to\u00e1n tr\u1ef1c ti\u1ebfp d\u1ef1a tr\u00ean c\u00e2u l\u1ec7nh SQL trong Excel<\/a><\/li>\n<li><a id=\"markdown-toc-cc-php-ton-c-th-c-s-dng-trong-sql\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#cc-php-ton-c-th-c-s-dng-trong-sql\">4. C\u00e1c ph\u00e9p to\u00e1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong SQL<\/a><\/li>\n<\/ul>\n<\/li>\n<li><a id=\"markdown-toc-chng-ta--lm-g-trong-bi-vit-ny\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#chng-ta--lm-g-trong-bi-vit-ny\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<li><a id=\"markdown-toc-download-ti-liu-km-theo-video\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#download-ti-liu-km-theo-video\">Download t\u00e0i li\u1ec7u k\u00e8m theo video<\/a><\/li>\n<li><a id=\"markdown-toc-cc-kin-thc-lin-quan\" href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-1.html#cc-kin-thc-lin-quan\">C\u00e1c ki\u1ebfn th\u1ee9c li\u00ean quan<\/a><\/li>\n<\/ul>\n<hr>\n<p>\u0110\u00e3 bao gi\u1edd c\u00e1c b\u1ea1n nghe n\u00f3i v\u1ec1 <code class=\"highlighter-rouge\">SQL<\/code>? <code class=\"highlighter-rouge\">SQL<\/code> c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u nh\u01b0 th\u1ebf n\u00e0o? L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">SQL<\/code> \u1edf trong <code class=\"highlighter-rouge\">Excel<\/code>? \u2026<\/p>\n<p>\u0110\u00f3 l\u00e0 nh\u1eefng c\u00e2u h\u1ecfi c\u00f3 th\u1ec3 trong m\u1ed9t th\u1eddi \u0111i\u1ec3m n\u00e0o \u0111\u00f3 trong c\u00f4ng vi\u1ec7c, c\u00e1c b\u1ea1n \u0111\u00e3 \u0111\u1eb7t ra. To\u00e0n l\u00e0 nh\u1eefng c\u00e2u h\u1ecfi ch\u00ednh \u0111\u00e1ng c\u1ea3, n\u1ebfu c\u00e1c b\u1ea1n v\u1eabn th\u1eafc m\u1eafc <code class=\"highlighter-rouge\">SQL<\/code> l\u00e0 g\u00ec v\u00e0 mu\u1ed1n t\u00ecm hi\u1ec3u v\u1ec1 ng\u00f4n ng\u1eef n\u00e0y th\u00ec \u0111\u00e2y ch\u00ednh l\u00e0 nh\u1eefng b\u00e0i vi\u1ebft d\u00e0nh cho b\u1ea1n. Vi\u1ec7c \u0111\u1ea7u ti\u00ean c\u00e1c b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 xem video sau \u0111\u00e2y \u0111\u1ec3 c\u00f3 th\u1ec3 c\u00f3 m\u1ed9t ch\u00fat kh\u00e1i ni\u1ec7m v\u1ec1 <code class=\"highlighter-rouge\">SQL<\/code>. Sau khi xem video n\u00e0y th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc ti\u1ebfp b\u00e0i vi\u1ebft n\u00e0y. C\u00e1c v\u00ed d\u1ee5 minh ho\u1ea1 cho vi\u1ec7c s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n ngay trong Excel v\u1edbi m\u1ee5c \u0111\u00edch t\u1ed1i gi\u1ea3n c\u00f4ng s\u1ee9c ph\u1ea3i c\u00e0i th\u00eam ph\u1ea7n m\u1ec1m tr\u00ean m\u00e1y t\u00ednh. M\u1eddi c\u00e1c b\u1ea1n xem video \u2026 v\u00e0 h\u1eb9n g\u1eb7p l\u1ea1i ngay sau video.<\/p>\n<p style=\"text-align: center\"><iframe loading=\"lazy\" src=\"https:\/\/www.youtube.com\/embed\/-gsMj4seais?list=PLALCv46JuKELXd5Ie81UqaFqAfsoXQSQt&amp;wmode=transparent\" width=\"560\" height=\"315\" frameborder allowfullscreen=\"allowfullscreen\"><\/iframe><\/p>\n<p style=\"text-align: center\"><a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\">Download excel file k\u00e8m theo video<\/a><\/p>\n<p>C\u00e1c b\u1ea1n \u0111ang \u0111\u1ecdc d\u00f2ng n\u00e0y, m\u00ecnh cho r\u1eb1ng video \u0111\u00e3 \u0111\u01b0\u1ee3c xem v\u00e0 file excel \u0111i k\u00e8m theo c\u0169ng \u0111\u00e3 \u0111\u01b0\u1ee3c download xu\u1ed1ng. Vi\u1ec7c \u0111\u1ea7u ti\u00ean ch\u00fang ta th\u1eed \u0111\u1ed1i v\u1edbi file excel n\u00e0y l\u00e0 m\u1edf ra v\u00e0 th\u1eed m\u1ed9t v\u00ed d\u1ee5 nh\u01b0 \u0111\u00e3 \u0111\u01b0\u1ee3c h\u01b0\u1edbng d\u1eabn trong video. N\u1ebfu t\u1ea5t c\u1ea3 ho\u1ea1t \u0111\u1ed9ng ch\u00ednh x\u00e1c nh\u01b0 video th\u00ec xin ch\u00fac m\u1eebng b\u1ea1n, b\u1ea1n \u0111\u00e3 s\u1eed d\u1ee5ng SQL trong Excel m\u1ed9t c\u00e1ch th\u00e0nh c\u00f4ng. V\u00e0 b\u00e2y gi\u1edd th\u1ef1c s\u1ef1 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c \u2026 \u0111\u1ecdc ti\u1ebfp.<\/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-676820895ce50\" 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\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#SQL_la_cai_gi\" title=\"SQL l\u00e0 c\u00e1i g\u00ec?\">SQL l\u00e0 c\u00e1i g\u00ec?<\/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\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#Cac_vi_du_ve_viec_su_dung_SQL_voi_SELECT\" title=\"C\u00e1c v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SQL v\u1edbi SELECT\">C\u00e1c v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SQL v\u1edbi SELECT<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\">\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#1_Truy_cap_toan_bo_du_lieu_tu_bang_tinh_Excel_bang_SQL\" title=\"1. Truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL\">1. Truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#2_Truy_cap_du_lieu_tu_bang_tinh_Excel_theo_cot\" title=\"2. Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel theo c\u1ed9t\">2. Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel theo c\u1ed9t<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#3_Tinh_toan_truc_tiep_dua_tren_cau_lenh_SQL_trong_Excel\" title=\"3. T\u00ednh to\u00e1n tr\u1ef1c ti\u1ebfp d\u1ef1a tr\u00ean c\u00e2u l\u1ec7nh SQL trong Excel\">3. T\u00ednh to\u00e1n tr\u1ef1c ti\u1ebfp d\u1ef1a tr\u00ean c\u00e2u l\u1ec7nh SQL trong Excel<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#4_Cac_phep_toan_co_the_duoc_su_dung_trong_SQL\" title=\"4. C\u00e1c ph\u00e9p to\u00e1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong SQL\">4. C\u00e1c ph\u00e9p to\u00e1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong SQL<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/series-lam-quen-voi-ngon-ngu-sql-va-ap-dung-trong-excel-phan-1-select.html#Chung_ta_da_lam_gi_trong_bai_viet_nay\" title=\"Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?\">Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 id=\"sql-l-ci-g\"><span class=\"ez-toc-section\" id=\"SQL_la_cai_gi\"><\/span>SQL l\u00e0 c\u00e1i g\u00ec?<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><strong>SQL<\/strong> l\u00e0 t\u1eeb vi\u1ebft t\u1eaft ti\u1ebfng Anh c\u1ee7a <strong>Structured Query Language<\/strong>, l\u00e0 m\u1ed9t ng\u00f4n ng\u1eef \u0111\u01b0\u1ee3c ph\u00e1t tri\u1ec3n chuy\u00ean \u0111\u1ec3 truy v\u1ea5n d\u1eef li\u1ec7u t\u1eeb m\u1ed9t h\u1ec7 th\u1ed1ng qu\u1ea3n tr\u1ecb c\u01a1 s\u1edf d\u1eef li\u1ec7u (<a href=\"https:\/\/vi.wikipedia.org\/wiki\/SQL\" target=\"_blank\" rel=\"noopener noreferrer\">Wikipedia<\/a>).<\/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-766.gif\" title=\"ex101_92019-nho-766\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>N\u00f3i m\u1ed9t c\u00e1ch \u0111\u01a1n gi\u1ea3n h\u01a1n th\u00ec <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd gi\u00fap ch\u00fang ta l\u1ea5y d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh n\u00e0y sang b\u1ea3ng t\u00ednh kh\u00e1c ho\u1eb7c <code class=\"highlighter-rouge\">SQL<\/code> s\u1ebd gi\u00fap ch\u00fang ta l\u1ecdc d\u1eef li\u1ec7u theo nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n kh\u00e1c nhau theo c\u00e1ch m\u00e0 c\u00e1c c\u00f4ng c\u1ee5 truy\u1ec1n th\u1ed1ng nh\u01b0 <a href=\"https:\/\/blog.hocexcel.online\/2014\/06\/03\/b41-su-dung-advanced-filter-de-trich-loc-du-lieu-bang-tinh-excel.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>Advanced Filter<\/strong><\/a> hay <a href=\"https:\/\/blog.hocexcel.online\/2015\/04\/25\/series-pivot-cach-dung-bang-pivot-trong-excel.html\"><strong>B\u1ea3ng Pivot<\/strong><\/a> c\u00f3 th\u1ec3 g\u1eb7p kh\u00f3 kh\u0103n khi x\u1eed l\u00fd r\u1ea5t nhi\u1ec1u d\u1eef li\u1ec7u. Khi \u0111\u00e3 s\u1eed d\u1ee5ng \u0111\u01b0\u1ee3c <code class=\"highlighter-rouge\">SQL<\/code> th\u00ec ch\u1eafc ch\u1eafn c\u00e1c b\u1ea1n s\u1ebd c\u00f3 nhi\u1ec1u \u00fd t\u01b0\u1edfng h\u01a1n khi t\u1ea1o m\u1ed9t b\u00e1o c\u00e1o (\u0111\u1ed9ng) trong Excel.<\/p>\n<h2 id=\"cc-v-d-v-vic-s-dng-sql-vi-select\"><span class=\"ez-toc-section\" id=\"Cac_vi_du_ve_viec_su_dung_SQL_voi_SELECT\"><\/span>C\u00e1c v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c s\u1eed d\u1ee5ng SQL v\u1edbi SELECT<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Trong ph\u1ea7n n\u00e0y, c\u00e1c b\u1ea1n s\u1ebd l\u00e0m quen v\u1edbi c\u00e1ch truy v\u1ea5n, truy c\u1eadp hay l\u1ea5y d\u1eef li\u1ec7u b\u1eb1ng SQL \u1edf ngay trong Excel. C\u00e1c v\u00ed d\u1ee5 n\u00e0y \u0111\u1ec1u c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n \u0111\u01b0\u1ee3c n\u1ebfu c\u00e1c b\u1ea1n \u0111\u00e3 <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>download file excel \u0111i k\u00e8m<\/strong><\/a>. Trong b\u00e0i vi\u1ebft n\u00e0y, ch\u00fang ta s\u1ebd \u0111i t\u00ecm hi\u1ec3u c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SELECT<\/code>. Vi\u1ec7c \u0111\u1ea7u ti\u00ean ch\u00fang ta s\u1ebd \u0111i xem x\u00e9t b\u1ea3ng d\u1eef li\u1ec7u hay file excel m\u00e0 ch\u00fang ta \u0111\u00e3 download v\u1ec1.<\/p>\n<p><strong>B\u1ea3ng d\u1eef li\u1ec7u trong Video<\/strong><\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 b\u1ea3ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i tr\u1ef1c ti\u1ebfp t\u1eeb <strong>Excel Online<\/strong>, b\u1ea1n c\u1ea7n s\u1eed d\u1ee5ng m\u1ed9t tr\u00ecnh duy\u1ec7t Web hi\u1ec7n \u0111\u1ea1i (Google Chrome, Firefox, Safari) \u0111\u1ec3 c\u00f3 th\u1ec3 xem \u0111\u01b0\u1ee3c b\u1ea3ng Excel n\u00e0y tr\u1ef1c ti\u1ebfp. T\u00e0i li\u1ec7u Excel n\u00e0y c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c download <a href=\"http:\/\/adf.ly\/6897436\/2015-10-27-excel67\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>t\u1ea1i \u0111\u00e2y<\/strong><\/a><\/p>\n<p style=\"text-align: center\"><\/p>\n<p>Tr\u01b0\u1edbc khi x\u1eed l\u00fd b\u1ea5t k\u00ec d\u1eef li\u1ec7u n\u00e0o, ch\u00fang ta c\u1ea7n \u0111i t\u00ecm hi\u1ec3u c\u1ea5u tr\u00fac c\u1ee7a b\u1ea3ng d\u1eef li\u1ec7u \u0111\u00f3:<\/p>\n<ul>\n<li>B\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta bao g\u1ed3m 7 c\u1ed9t t\u1eeb c\u1ed9t A cho \u0111\u1ebfn c\u1ed9t G.<\/li>\n<li>V\u00f9ng d\u1eef li\u1ec7u \u0111\u01b0\u1ee3c l\u01b0u l\u00e0 <code class=\"highlighter-rouge\">A1:G20000<\/code><\/li>\n<li>M\u1ed7i c\u1ed9t ch\u1ee9a m\u1ed9t thu\u1ed9c t\u00ednh c\u1ee7a d\u1eef li\u1ec7u:\n<ol>\n<li>C\u1ed9t A: <code class=\"highlighter-rouge\">Ng\u00e0y b\u00e1n<\/code> (OrderDate) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng<\/li>\n<li>C\u1ed9t B: <code class=\"highlighter-rouge\">V\u00f9ng b\u00e1n<\/code> (Region) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i<\/li>\n<li>C\u1ed9t C: <code class=\"highlighter-rouge\">Ng\u01b0\u1eddi b\u00e1n<\/code> (Rep) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i<\/li>\n<li>C\u1ed9t D: <code class=\"highlighter-rouge\">M\u00f3n h\u00e0ng<\/code>(Item) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u chu\u1ed7i<\/li>\n<li>C\u1ed9t E: <code class=\"highlighter-rouge\">S\u1ed1 l\u01b0\u1ee3ng<\/code> (Units) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1<\/li>\n<li>C\u1ed9t F: <code class=\"highlighter-rouge\">\u0110\u01a1n gi\u00e1<\/code> (Unit Cost) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1<\/li>\n<li>C\u1ed9t G: <code class=\"highlighter-rouge\">Th\u00e0nh ti\u1ec1n<\/code> (Total) c\u00f3 ki\u1ec3u d\u1eef li\u1ec7u s\u1ed1<\/li>\n<\/ol>\n<\/li>\n<\/ul>\n<p>Sau khi x\u00e1c \u0111\u1ecbnh \u0111\u01b0\u1ee3c b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta tr\u00f4ng nh\u01b0 th\u1ebf n\u00e0o, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong>SQL<\/strong> \u0111\u1ec3 truy c\u1eadp d\u1eef li\u1ec7u n\u00e0y v\u1edbi nh\u1eefng c\u00e2u l\u1ec7nh\u00a0<code class=\"highlighter-rouge\">SQL<\/code> sau \u0111\u00e2y.<\/p>\n<blockquote>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-lap-trinh-vba-trong-excel\">H\u1ecdc\u00a0VBA\u00a0Excel Online<\/a><\/p>\n<\/blockquote>\n<h4><span class=\"ez-toc-section\" id=\"1_Truy_cap_toan_bo_du_lieu_tu_bang_tinh_Excel_bang_SQL\"><\/span>1. Truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel b\u1eb1ng SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 truy c\u1eadp to\u00e0n b\u1ed9 d\u1eef li\u1ec7u t\u1eeb 1 v\u00f9ng d\u1eef li\u1ec7u, ch\u00fang ta s\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh sau<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"o\">*<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>T\u1eeb <strong><code class=\"highlighter-rouge\">SELECT<\/code><\/strong> trong c\u00e2u l\u1ec7nh tr\u00ean l\u00e0 m\u1ed9t t\u1eeb kho\u00e1 c\u1ee7a ng\u00f4n ng\u1eef <code class=\"highlighter-rouge\">SQL<\/code>. D\u1ea5u <code class=\"highlighter-rouge\">*<\/code> \u1edf trong c\u00e2u l\u1ec7nh n\u00e0y ngh\u0129a l\u00e0 ch\u00fang ta mu\u1ed1n d\u1eef li\u1ec7u c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c c\u1ed9t. T\u1eeb <code class=\"highlighter-rouge\">FROM<\/code> c\u0169ng l\u00e0 m\u1ed9t t\u1eeb kho\u00e1 c\u1ee7a ng\u00f4n ng\u1eef <code class=\"highlighter-rouge\">SQL<\/code>, t\u1eeb n\u00e0y th\u00f4ng b\u00e1o cho b\u1ed9 x\u1eed l\u00fd <code class=\"highlighter-rouge\">SQL<\/code> l\u00e0 ch\u00fang ta mu\u1ed1n truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb v\u00f9ng d\u1eef li\u1ec7u n\u00e0o. V\u00e0 ch\u1eafc ch\u1eafn c\u00e1c b\u1ea1n \u0111\u00e3 \u0111o\u00e1n ra <code class=\"highlighter-rouge\">[A1:G20000]<\/code> ch\u00ednh l\u00e0 v\u00f9ng d\u1eef li\u1ec7u \u0111\u00e3 \u0111\u01b0\u1ee3c n\u00f3i \u0111\u1ebfn trong video. N\u1ebfu c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng file Excel trong video \u0111\u1ec3 th\u1ef1c hi\u1ec7n nh\u1eefng c\u00e2u l\u1ec7nh SQL n\u00e0y, b\u1ea1n c\u1ea7n th\u00eam <code class=\"highlighter-rouge\">mi_sql<\/code> v\u00e0o \u0111\u1eb1ng tr\u01b0\u1edbc c\u00e2u l\u1ec7nh nh\u01b0 sau:<\/p>\n<p><code class=\"highlighter-rouge\">mi_sql SELECT * FROM [A1:G20000]<\/code><\/p>\n<ul>\n<li>Trong th\u1ef1c t\u1ebf s\u1eed d\u1ee5ng th\u00ec ch\u00fang ta r\u1ea5t \u00edt khi ph\u1ea3i s\u1eed d\u1ee5ng \u0111\u1ebfn c\u00e2u l\u1ec7nh SQL n\u00e0y.<\/li>\n<li>Ch\u1ec9 trong file Excel c\u00e1c b\u1ea1n download v\u1ec1 \u1edf b\u00e0i n\u00e0y, ch\u00fang ta m\u1edbi c\u1ea7n th\u00eam <code class=\"highlighter-rouge\">mi_sql<\/code> v\u00e0o \u0111\u1ea7u m\u1ed7i c\u00e2u l\u1ec7nh.<\/li>\n<\/ul>\n<h4 id=\"truy-cp-d-liu-t-bng-tnh-excel-theo-ct\"><span class=\"ez-toc-section\" id=\"2_Truy_cap_du_lieu_tu_bang_tinh_Excel_theo_cot\"><\/span>2. Truy c\u1eadp d\u1eef li\u1ec7u t\u1eeb b\u1ea3ng t\u00ednh Excel theo c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ec3 truy c\u1eadp d\u1eef li\u1ec7u c\u1ee7a m\u1ed9t s\u1ed1 c\u1ed9t nh\u1ea5t \u0111\u1ecbnh: ch\u00fang ta ghi t\u00ean c\u1ed9t ra sau t\u1eeb kho\u00e1 <code class=\"highlighter-rouge\">SELECT<\/code> v\u00e0 vi\u1ebft c\u00e1c c\u1ed9t ng\u0103n c\u00e1ch nhau b\u1eb1ng d\u1ea5u ph\u1ea9y <code class=\"highlighter-rouge\">,<\/code><\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"n\">OrderDate<\/span><span class=\"p\">,<\/span> <span class=\"n\">Region<\/span><span class=\"p\">,<\/span> <span class=\"n\">Rep<\/span><span class=\"p\">,<\/span> <span class=\"n\">Item<\/span> <span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a c\u00e2u <code class=\"highlighter-rouge\">SQL<\/code> n\u00e0y nh\u01b0 sau:<\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>+---+-----------+--------+--------+--------+\r\n|   |     A     |    B   |    C   |    D   |\r\n+---+-----------+--------+--------+--------+\r\n| 1 | OrderDate | Region |   Rep  |  Item  |\r\n+---+-----------+--------+--------+--------+\r\n| 2 |  1\/6\/2014 | Hanoi  | Jones  | Pencil |\r\n+---+-----------+--------+--------+--------+\r\n| 3 | 1\/23\/2014 | Danang | Kivell | Binder |\r\n+---+-----------+--------+--------+--------+\r\n|   |    ...    |   ...  |   ...  |   ...  |\r\n+---+-----------+--------+--------+--------+\r\n<\/code><\/pre>\n<\/div>\n<p>N\u1ebfu mu\u1ed1n \u201c\u0111\u1eb7t t\u00ean l\u1ea1i\u201d cho c\u00e1c c\u1ed9t <code class=\"highlighter-rouge\">OrderDate<\/code>, <code class=\"highlighter-rouge\">Region<\/code>, <code class=\"highlighter-rouge\">Rep<\/code>, <code class=\"highlighter-rouge\">Item<\/code> th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng:<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\">\t<span class=\"k\">SELECT<\/span> <span class=\"n\">OrderDate<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">NgayBan<\/span>\r\n\t\t <span class=\"p\">,<\/span> <span class=\"n\">Region<\/span>    <span class=\"k\">AS<\/span> <span class=\"n\">Vung<\/span>\r\n\t\t <span class=\"p\">,<\/span> <span class=\"n\">Rep<\/span>       <span class=\"k\">AS<\/span> <span class=\"n\">NhanVien<\/span>\r\n\t\t <span class=\"p\">,<\/span> <span class=\"n\">Item<\/span>      <span class=\"k\">AS<\/span> <span class=\"n\">MatHang<\/span>\r\n\t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>Khi vi\u1ebft c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SQL<\/code> n\u00e0y v\u00e0o Excel, c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 vi\u1ebft tr\u00ean c\u00f9ng 1 d\u00f2ng, kh\u00f4ng c\u1ea7n xu\u1ed1ng d\u00f2ng nh\u01b0 \u1edf \u0111\u00e2y (Xu\u1ed1ng d\u00f2ng \u0111\u1ec3 cho d\u1ec5 nh\u00ecn). Sau khi ch\u1ea1y l\u1ec7nh <code class=\"highlighter-rouge\">SQL<\/code> n\u00e0y ch\u00fang ta nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>+---+-----------+--------+-----------+-----------+\r\n|   |     A     |    B   |    C      |    D      |\r\n+---+-----------+--------+-----------+-----------+\r\n| 1 | NgayBan   | Vung   | NhanVien  |  MatHang  |\r\n+---+-----------+--------+-----------+-----------+\r\n| 2 |  1\/6\/2014 | Hanoi  | Jones     | Pencil    |\r\n+---+-----------+--------+-----------+-----------+\r\n| 3 | 1\/23\/2014 | Danang | Kivell    | Binder    |\r\n+---+-----------+--------+-----------+-----------+\r\n|   |    ...    |   ...  |   ...     |   ...     |\r\n+---+-----------+--------+-----------+-----------+\r\n<\/code><\/pre>\n<\/div>\n<h4 id=\"tnh-ton-trc-tip-da-trn-cu-lnh-sql-trong-excel\"><span class=\"ez-toc-section\" id=\"3_Tinh_toan_truc_tiep_dua_tren_cau_lenh_SQL_trong_Excel\"><\/span>3. T\u00ednh to\u00e1n tr\u1ef1c ti\u1ebfp d\u1ef1a tr\u00ean c\u00e2u l\u1ec7nh SQL trong Excel<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Gi\u1ea3 s\u1eed trong b\u1ea3ng d\u1eef li\u1ec7u c\u1ee7a ch\u00fang ta ch\u01b0a c\u00f3 c\u1ed9t G \u2013 <code class=\"highlighter-rouge\">Th\u00e0nh ti\u1ec1n<\/code> (Total), ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <code class=\"highlighter-rouge\">SQL<\/code> nh\u01b0 sau \u0111\u1ec3 c\u00f3 th\u1ec3 t\u00ednh \u0111\u01b0\u1ee3c c\u1ed9t<code class=\"highlighter-rouge\">Th\u00e0nh ti\u1ec1n<\/code> n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng<\/p>\n<figure class=\"highlight\">\n<pre><code class=\"language-sql\" data-lang=\"sql\"> \t<span class=\"k\">SELECT<\/span> <span class=\"n\">Item<\/span>\r\n \t\t<span class=\"p\">,<\/span> <span class=\"n\">Units<\/span>\r\n \t\t<span class=\"p\">,<\/span> <span class=\"p\">[<\/span><span class=\"n\">Unit<\/span> <span class=\"n\">Cost<\/span><span class=\"p\">]<\/span><span class=\"o\">*<\/span><span class=\"n\">Units<\/span> <span class=\"k\">AS<\/span> <span class=\"n\">total_sql<\/span>\r\n \t\t<span class=\"p\">,<\/span> <span class=\"n\">Total<\/span> \r\n \t<span class=\"k\">FROM<\/span> <span class=\"p\">[<\/span><span class=\"n\">A1<\/span><span class=\"p\">:<\/span><span class=\"n\">G20000<\/span><span class=\"p\">]<\/span>\r\n<\/code><\/pre>\n<\/figure>\n<p>V\u00e0 k\u1ebft qu\u1ea3 ch\u00ednh x\u00e1c nh\u01b0 ch\u00fang ta \u0111\u00e3 mong \u0111\u1ee3i:<\/p>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>+---+--------+-------+-----------+--------+\r\n|   |    A   |   B   |     C     |    D   |\r\n+---+--------+-------+-----------+--------+\r\n| 1 |  Item  | Units | total_sql |  Total |\r\n+---+--------+-------+-----------+--------+\r\n| 2 | Pencil |    95 |    189.05 | 189.05 |\r\n+---+--------+-------+-----------+--------+\r\n| 3 | Binder |    50 |    999.50 | 999.50 |\r\n+---+--------+-------+-----------+--------+\r\n|   |   ...  |   ... |       ... |    ... |\r\n+---+--------+-------+-----------+--------+\r\n<\/code><\/pre>\n<\/div>\n<h4 id=\"cc-php-ton-c-th-c-s-dng-trong-sql\"><span class=\"ez-toc-section\" id=\"4_Cac_phep_toan_co_the_duoc_su_dung_trong_SQL\"><\/span>4. C\u00e1c ph\u00e9p to\u00e1n c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng trong SQL<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<div class=\"highlighter-rouge\">\n<pre class=\"highlight\"><code>+-----------+-------------------+-------------------+\r\n| Ph\u00e9p to\u00e1n |      \u00dd ngh\u0129a      |       V\u00ed d\u1ee5       |\r\n+-----------+-------------------+-------------------+\r\n|     +     | C\u1ed9ng              | SELECT 181 + 234  |\r\n+-----------+-------------------+-------------------+\r\n|     -     | Tr\u1eeb               | SELECT 234 - 181  |\r\n+-----------+-------------------+-------------------+\r\n|     *     | Nh\u00e2n              | SELECT 234 * 181  |\r\n+-----------+-------------------+-------------------+\r\n|     \/     | Chia              | SELECT 234 \/ 181  |\r\n+-----------+-------------------+-------------------+\r\n|     &gt;     | L\u1edbn h\u01a1n           | SELECT 234 &gt; 181  |\r\n+-----------+-------------------+-------------------+\r\n|     &lt;     | Nh\u1ecf h\u01a1n           | SELECT 234 &lt; 181  |\r\n+-----------+-------------------+-------------------+\r\n|     &gt;=    | L\u1edbn h\u01a1n ho\u1eb7c b\u1eb1ng | SELECT 234 &gt;= 181 |\r\n+-----------+-------------------+-------------------+\r\n|     &lt;=    | Nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng | SELECT 234 &lt;= 181 |\r\n+-----------+-------------------+-------------------+\r\n<\/code><\/pre>\n<\/div>\n<h3 id=\"chng-ta--lm-g-trong-bi-vit-ny\"><span class=\"ez-toc-section\" id=\"Chung_ta_da_lam_gi_trong_bai_viet_nay\"><\/span>Ch\u00fang ta \u0111\u00e3 l\u00e0m g\u00ec trong b\u00e0i vi\u1ebft n\u00e0y?<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Nh\u01b0 c\u00e1c b\u1ea1n \u0111\u00e3 th\u1ea5y, trong b\u00e0i n\u00e0y ch\u00fang ta \u0111\u00e3 l\u00e0m quen v\u1edbi <code class=\"highlighter-rouge\">SQL<\/code> v\u00e0 c\u00e2u l\u1ec7nh <code class=\"highlighter-rouge\">SELECT<\/code> \u0111\u1ec3 c\u00f3 th\u1ec3 l\u1ea5y d\u1eef li\u1ec7u \u0111\u01a1n gi\u1ea3n trong Excel. Trong b\u00e0i h\u00f4m sau ch\u00fang ta s\u1ebd t\u00ecm hi\u1ec3u l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u d\u1ef1a tr\u00ean m\u1ed9t hay nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n. \u0110\u1eebng qu\u00ean Subscribe \u0111\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c update m\u1edbi nh\u1ea5t v\u1ec1 b\u00e0i vi\u1ebft n\u00e0y.<\/p>\n<p>Trong l\u00fac \u0111\u00f3, c\u00f3 th\u1ec3 c\u00e1c b\u1ea1n mu\u1ed1n xem c\u00e1c b\u00e0i ti\u1ebfp theo:<\/p>\n<ul>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-2.html\" target=\"_blank\" rel=\"noopener noreferrer\">L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 2 \u2013 l\u1ecdc theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi WHERE<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/02\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-3.html\" target=\"_blank\" rel=\"noopener noreferrer\">L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 3 \u2013 l\u1ecdc n\u00e2ng cao v\u1edbi LIKE<\/a><\/li>\n<li><a href=\"https:\/\/blog.hocexcel.online\/2015\/11\/03\/series-sql-lam-quen-voi-ngon-ngu-sql-hoc-sql-ap-dung-sql-trong-excel-phan-4.html\" target=\"_blank\" rel=\"noopener noreferrer\">L\u00e0m quen v\u1edbi ng\u00f4n ng\u1eef SQL v\u00e0 \u00e1p d\u1ee5ng trong Excel \u2013 ph\u1ea7n 4 \u2013 S\u1eed d\u1ee5ng Order By<\/a><\/li>\n<\/ul>\n<p style=\"text-align: justify\">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\">ho\u0323c Excel c\u01a1 ba\u0309n<\/a>\u00a0cho \u0111\u00ea\u0301n n\u00e2ng cao v\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\u01b0\u0300ng 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-766.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":8381,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-8380","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\/8380","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=8380"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/8380\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/8381"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=8380"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=8380"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=8380"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}