{"id":3859,"date":"2024-12-03T09:45:21","date_gmt":"2024-12-03T09:45:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel\/"},"modified":"2024-12-03T09:45:21","modified_gmt":"2024-12-03T09:45:21","slug":"gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/03\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel\/","title":{"rendered":"G\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau s\u1eed d\u1ee5ng SQL trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>Vi\u1ec7c t\u1ed5 ch\u1ee9c d\u1eef li\u1ec7u c\u1ef1c k\u1ef3 quan tr\u1ecdng \u0111\u1ec3 t\u1ea1o ra c\u00e1c lo\u1ea1i b\u00e1o c\u00e1o, t\u00f9y thu\u1ed9c v\u00e0o \u0111\u1eb7c th\u00f9 c\u1ee7a doanh nghi\u1ec7p, n\u00ean ch\u00fang ta kh\u00f4ng ph\u1ea3i l\u00fac n\u00e0o c\u0169ng c\u00f3 d\u1eef li\u1ec7u chu\u1ea9n \u0111\u1ec3 t\u1ed5ng h\u1ee3p, \u0111\u1ec3 gi\u1ea3i quy\u1ebft b\u00e0i to\u00e1n n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>Hoc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html\"><strong>g\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng SQL trong Excel<\/strong> <\/a>nh\u00e9<\/em><\/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-674ed3310328b\" 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\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Muc_tieu_dat_duoc\" title=\"M\u1ee5c ti\u00eau \u0111\u1ea1t \u0111\u01b0\u1ee3c\">M\u1ee5c ti\u00eau \u0111\u1ea1t \u0111\u01b0\u1ee3c<\/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\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Chuan_bi\" title=\"Chu\u1ea9n b\u1ecb\">Chu\u1ea9n b\u1ecb<\/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\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Nguyen_tac_gop_bang_du_lieu\" title=\"Nguy\u00ean t\u1eafc g\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u\">Nguy\u00ean t\u1eafc g\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Cach_thuc_hien_gop_bang_bang_SQL\" title=\"C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p b\u1ea3ng b\u1eb1ng SQL\">C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p b\u1ea3ng b\u1eb1ng SQL<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Buoc_1_Dat_ten_cho_bang_tinh\" title=\"B\u01b0\u1edbc 1: \u0110\u1eb7t t\u00ean cho b\u1ea3ng t\u00ednh\">B\u01b0\u1edbc 1: \u0110\u1eb7t t\u00ean cho b\u1ea3ng t\u00ednh<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Viet_cau_lenh_SQL\" title=\"Vi\u1ebft c\u00e2u l\u1ec7nh SQL\">Vi\u1ebft c\u00e2u l\u1ec7nh SQL<\/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-7\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Cu_phap_cau_lenh_lay_du_lieu\" title=\"C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u.\">C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u.<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Cu_phap_cau_lenh_lay_du_lieu_va_tinh_toan\" title=\"C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n.\">C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n.<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/gop-bang-du-lieu-co-cau-truc-giong-nhau-su-dung-sql-trong-excel.html#Ket_luan\" title=\"K\u1ebft lu\u1eadn\">K\u1ebft lu\u1eadn<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Muc_tieu_dat_duoc\"><\/span>M\u1ee5c ti\u00eau \u0111\u1ea1t \u0111\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30925 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tonghop.png\" alt=\"gop-bang-du-lieu-cau-truc-trung-nhau-su-dung-sql-trong-excel-1\" width=\"1647\" height=\"794\" title=\"tonghop\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Chuan_bi\"><\/span>Chu\u1ea9n b\u1ecb<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u1ede \u0111\u00e2y m\u00ecnh s\u1eed d\u1ee5ng d\u1eef li\u1ec7u \u0111\u1ec3 t\u1ed5ng h\u1ee3p l\u01b0\u01a1ng c\u1ee7a 12 th\u00e1ng c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i file m\u1eabu <a href=\"https:\/\/drive.google.com\/file\/d\/1juYcW2ZldhMT69TCQM4Yw4U8I54v1CvH\/view?usp=sharing\">t\u1ea1i \u0111\u00e2y.<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f4ng vi\u1ec7c c\u1ee7a c\u00e1c b\u1ea1n tr\u1edf n\u00ean \u0111\u01a1n gi\u1ea3n h\u01a1n m\u00e0 kh\u00f4ng c\u1ea7n vi\u1ebft code tr\u00ean vba c\u00e1c b\u1ea1n h\u00e3y t\u1ea3i v\u1ec1 v\u00e0 c\u00e0i \u0111\u1eb7t Addins-HocExcelOnline\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">t\u1ea1i \u0111\u00e2y nh\u00e9<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nguyen_tac_gop_bang_du_lieu\"><\/span>Nguy\u00ean t\u1eafc g\u1ed9p b\u1ea3ng d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 tr\u00e1nh c\u00e1c l\u1ed7i x\u1ea3y ra trong qu\u00e1 tr\u00ecnh g\u1ed9p d\u1eef li\u1ec7u ta c\u1ea7n tu\u00e2n th\u1ee7 quy t\u1eafc sau:<\/p>\n<ul>\n<li>D\u1eef li\u1ec7u ph\u1ea3i c\u00f3 t\u00ednh n\u1ed1i ti\u1ebfp nhau<\/li>\n<li>C\u00e1c b\u1ea3ng t\u00ednh c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau v\u1ec1 s\u1ed1 l\u01b0\u1ee3ng c\u1ed9t, t\u00ean c\u1ed9t\u2026<\/li>\n<li>Trong b\u1ea3ng t\u00ednh c\u1ea7n \u0111\u01b0\u1ee3c \u0111\u1ed3ng b\u1ed9 d\u1eef li\u1ec7u \u1edf c\u00e1c c\u1ed9t(\u0111\u1ea3m b\u1ea3o c\u1ea5u tr\u00fac d\u1eef li\u1ec7u).<\/li>\n<\/ul>\n<h2><span class=\"ez-toc-section\" id=\"Cach_thuc_hien_gop_bang_bang_SQL\"><\/span>C\u00e1ch th\u1ef1c hi\u1ec7n g\u1ed9p b\u1ea3ng b\u1eb1ng SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Buoc_1_Dat_ten_cho_bang_tinh\"><\/span>B\u01b0\u1edbc 1: \u0110\u1eb7t t\u00ean cho b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u00e1c b\u1ea1n c\u1ea7n \u0111\u1eb7t t\u00ean cho b\u1ea3ng t\u00ednh t\u1ea1i c\u00e1c Sheets l\u1ea1i v\u1edbi nhau v\u00e0 khi \u0111\u1eb7t t\u00ean l\u00e0 ti\u1ebfng vi\u1ec7t kh\u00f4ng d\u1ea5u v\u00e0 kh\u00f4ng n\u00ean \u0111\u1ec3 kho\u1ea3ng tr\u1ed1ng c\u00e1ch \u0111\u1eb7t t\u00ean cho v\u00f9ng d\u1eef li\u1ec7u<a href=\"http:\/\/blog.ezworkapp.com\/32-%e2%97%8f-cach-su-dung-name-range-trong-excel-dat-ten-cho-vung-du-lieu.html\"> t\u1ea1i \u0111\u00e2y<\/a><\/p>\n<p>sau khi c\u00e1c b\u1ea1n \u0111\u1eb7t t\u00ean d\u1eef li\u1ec7u c\u00f3 d\u1ea1ng nh\u01b0 h\u00ecnh sau:<\/p>\n<div class=\"code-block code-block-3\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-305.gif\" title=\"ex101_92019-nho-305\"><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-305.gif\" title=\"ex101_92019-nho-305\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-full wp-image-30926\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/namerange.png\" width=\"828\" height=\"643\" title=\"namerange\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Viet_cau_lenh_SQL\"><\/span>Vi\u1ebft c\u00e2u l\u1ec7nh SQL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n g\u1ed9p c\u00e1c b\u1ea3ng t\u00ednh c\u00f3 c\u1ea5u tr\u00fac gi\u1ed1ng nhau trong SQL ta s\u1eed d\u1ee5ng t\u1eeb kh\u00f3a \u201cUNION\u201d v\u00e0 \u201cUNION ALL\u201d<\/p>\n<ul>\n<li><strong>UNION l\u00e0 g\u1ed9p d\u1eef li\u1ec7u v\u00e0 lo\u1ea1i b\u1ecf d\u1eef li\u1ec7u tr\u00f9ng nhau<\/strong><\/li>\n<li><strong>UNION ALL l\u00e0 g\u1ed9p d\u1eef li\u1ec7u v\u00e0 l\u1ea5y to\u00e0n b\u1ed9 d\u1eef li\u1ec7u (bao g\u1ed3m c\u1ea3 d\u1eef li\u1ec7u tr\u00f9ng)<\/strong><\/li>\n<\/ul>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_cau_lenh_lay_du_lieu\"><\/span>C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT bang1.[cot 1],bang1.[cot2]\u2026 FROM BANG1 UNION ALL\u00a0SELECT bang2.[cot 1],bang2.[cot2]\u2026 FROM BANG2\u00a0<\/strong><\/p>\n<\/blockquote>\n<h3><span class=\"ez-toc-section\" id=\"Cu_phap_cau_lenh_lay_du_lieu_va_tinh_toan\"><\/span>C\u00fa ph\u00e1p c\u00e2u l\u1ec7nh l\u1ea5y d\u1eef li\u1ec7u v\u00e0 t\u00ednh to\u00e1n.<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<blockquote>\n<p><strong>SELECT TH.[cot1],Sum(TH.[Cot2]) as [C\u1ed9t 2] FROM (SELECT bang1.[cot 1],sum(bang1.[cot2])\u2026 FROM BANG1 UNION ALL\u00a0SELECT bang2.[cot 1],bang2.[cot2]\u2026 FROM BANG2 ) AS TH GROUP BY TH.[cot1]<\/strong><\/p>\n<\/blockquote>\n<p>\u1ede \u0111\u00e2y c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 thay th\u1ebf t\u1eeb kh\u00f3a \u201cUNION\u201d ho\u1eb7c \u201cUNION ALL\u201d t\u00f9y v\u00e0o c\u00e1ch c\u00e1c b\u1ea1n d\u00f9ng \u0111\u1ec3 t\u1ed5ng h\u1ee3p d\u1eef li\u1ec7u. \u0110\u1ec3 hi\u1ec3u r\u00f5 v\u1ec1 c\u00e2u l\u1ec7nh SQL h\u01a1n c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham d\u1ef1 c\u00e1c kh\u00f3a h\u1ecdc \u0111\u1ec3 hi\u1ec3u h\u01a1n nh\u00e9.<\/p>\n<p>Sau khi c\u00e1c b\u1ea1n vi\u1ebft xong c\u00f4ng th\u1ee9c th\u00ec\u00a0 vi\u1ec7c l\u00e0m \u0111\u01a1n gi\u1ea3n ch\u1ec9 l\u00e0 g\u1ecdi c\u00e2u truy v\u1ea5n ra th\u00f4i.<\/p>\n<blockquote>\n<p><strong>=Heosql(C\u00e2u truy v\u1ea5n, \u201cTieude = y, chen = y, stt = y\u201d)<\/strong><\/p>\n<\/blockquote>\n<p>K\u1ebft qu\u1ea3 \u0111\u1ea1t \u0111\u01b0\u1ee3c s\u1ebd nh\u01b0 sau.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30927 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/union-all.png\" alt=\"gop-bang-du-lieu-cau-truc-trung-nhau-su-dung-sql-trong-excel-2\" width=\"1920\" height=\"707\" title=\"union-all\"><\/p>\n<p>Khi c\u00e1c b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u t\u1ea1i c\u00e1c \u00f4 m\u00e0 mu\u1ed1n c\u1eadp nh\u1eadt k\u1ebft qu\u1ea3 th\u00ec c\u00e1c b\u1ea1n v\u00e0o Menu c\u1ee7a Add-Ins HocExcel Online v\u00e0 th\u1ef1c hi\u1ec7n \u1ea5n n\u00fat \u201cT\u00ednh to\u00e1n l\u1ea1i\u201d l\u00e0 d\u1eef li\u1ec7u c\u1ee7a c\u00e1c b\u1ea1n \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt l\u1ea1i.<\/p>\n<p>Th\u1eadt \u0111\u01a1n gi\u1ea3n ph\u1ea3i kh\u00f4ng n\u00e0o?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone wp-image-30928\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-ins-hocexcelonline.png\" alt=\"gop-bang-du-lieu-cau-truc-trung-nhau-su-dung-sql-trong-excel-3\" width=\"503\" height=\"234\" title=\"add-ins-hocexcelonline\"><\/p>\n<p>Ngo\u00e0i c\u00e1ch s\u1eed d\u1ee5ng SQL c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o c\u00e1c g\u1ed9p b\u1ea3ng s\u1eed d\u1ee5ng<strong><a href=\"http:\/\/blog.ezworkapp.com\/cach-gop-du-lieu-tu-nhieu-bang-vao-1-bang-su-dung-power-query.html\"> Power Query<\/a><\/strong><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ket_luan\"><\/span>K\u1ebft lu\u1eadn<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Qua b\u00e0i vi\u1ebft tr\u00ean <strong>Hoc Excel Online<\/strong> hy v\u1ecdng c\u00e1c b\u1ea1n v\u1eadn d\u1ee5ng c\u00e1c lo\u1ea1i \u201cUNION\u201d v\u00e0 \u201cUNION ALL\u201d m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 nh\u1ea5t \u0111\u1ec3 t\u1ea1o ra nh\u1eefng b\u1ea3ng b\u00e1o c\u00e1o nhanh ch\u00f3ng v\u00e0 ch\u00ednh x\u00e1c nh\u1ea5t<\/p>\n<p>n\u1ebfu th\u1ea5y hay h\u00e3y \u1ee7ng h\u1ed9, chia s\u1ebb b\u00e0i vi\u1ebft \u0111\u1ec3 nhi\u1ec1u ng\u01b0\u1eddi bi\u1ebft \u0111\u1ebfn v\u00e0 HocExcel Online c\u00f3 \u0111\u1ed9ng l\u1ef1c \u0111\u1ec3 ph\u00e1t tri\u1ec3n b\u00e0i vi\u1ebft t\u1ed1t h\u01a1n.<\/p>\n<hr>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-chuyen-cac-front-chu-khac-nhau-trong-excel-su-dung-add-ins-hocexcelonline.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch chuy\u1ec3n c\u00e1c front ch\u1eef kh\u00e1c nhau trong excel s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lap-bao-cao-tinh-hinh-su-dung-hoa-don-bc26ac-phan-2.html\">H\u01b0\u1edbng d\u1eabn l\u1eadp b\u00e1o c\u00e1o t\u00ecnh h\u00ecnh s\u1eed d\u1ee5ng h\u00f3a \u0111\u01a1n BC26\/AC s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-heounique-loc-khong-trung.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m Heounique l\u1ecdc kh\u00f4ng tr\u00f9ng<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-hien-thong-bao-trong-excel-su-dung-add-ins-hocexcel-online.html\">H\u00e0m hi\u1ec7n th\u1ecb th\u00f4ng b\u00e1o trong Excel s\u1eed d\u1ee5ng Add ins HocExcel Online<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tim-ten-va-dia-chi-doanh-nghiep-trong-excel-su-dung-add-ins-hocexcelonline.html\">T\u00ecm ki\u1ebfm t\u00ean c\u00f4ng ty v\u00e0 \u0111\u1ecba ch\u1ec9 c\u00f4ng ty d\u1ef1a v\u00e0o m\u00e3 s\u1ed1 thu\u1ebf<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/noi-du-lieu-trong-hai-bang-su-dung-sql.html\">N\u1ed1i b\u1ea3ng d\u1eef li\u1ec7u trong Excel s\u1eed d\u1ee5ng SQL<\/a><\/p>\n<h2><\/h2>\n<p>\u00a0<\/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<p>D\u00f9 \u0111\u00e3 c\u00f3 ph\u1ea7n m\u1ec1m, nh\u01b0ng k\u1ef9 n\u0103ng Excel v\u1eabn c\u1ef1c k\u1ef3 quan tr\u1ecdng v\u1edbi k\u1ebf to\u00e1n, b\u1ea1n \u0111\u00e3 v\u1eefng Excel ch\u01b0a? H\u00e3y \u0111\u1ec3 t\u00f4i gi\u00fap b\u1ea1n, \u0111\u0103ng k\u00fd kho\u00e1 h\u1ecdc Excel:<\/p>\n<p><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-305.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":3860,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-3859","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\/3859","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=3859"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/3859\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/3860"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=3859"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=3859"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=3859"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}