{"id":4334,"date":"2024-12-04T19:26:50","date_gmt":"2024-12-04T19:26:50","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-lap-so-nhat-ky-chung-bang-ham-heosql\/"},"modified":"2024-12-04T19:26:50","modified_gmt":"2024-12-04T19:26:50","slug":"huong-dan-lap-so-nhat-ky-chung-bang-ham-heosql","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/04\/huong-dan-lap-so-nhat-ky-chung-bang-ham-heosql\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\"><em>S\u1ed5 Nh\u1eadt k\u00fd chung l\u00e0 m\u1ed9t trong nh\u1eefng s\u1ed5 s\u00e1ch k\u1ebf to\u00e1n r\u1ea5t quan tr\u1ecdng, ph\u1ea3n \u00e1nh ph\u00e1t sinh c\u1ee7a c\u00e1c nghi\u1ec7p v\u1ee5 kinh t\u1ebf trong k\u1ef3. B\u00e0i vi\u1ebft n\u00e0y <strong><a href=\"http:\/\/blog.ezworkapp.com\">H\u1ecdc Excel Online<\/a> <\/strong>s\u1ebd h\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung trong k\u1ebf to\u00e1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m <strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\">\u201cHeoSQL\u201d trong b\u1ed9 h\u00e0m c\u1ee7a Add \u2013 ins HocExcelOnline.<\/a><\/strong><\/em><\/p>\n<p style=\"text-align: justify\">V\u1edbi h\u00e0m n\u00e0y kh\u00f4ng nh\u1eefng b\u1ea1n l\u00e0m \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung m\u00e0 s\u1ed5 c\u00f2n ho\u00e0n to\u00e0n linh ho\u1ea1t theo kho\u1ea3ng th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n l\u1ea5y d\u1eef li\u1ec7u<\/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-6750acf9827e5\" 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\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html#Muc_dich_va_vai_tro_cua_so_Nhat_ky_chung\" title=\"M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 Nh\u1eadt k\u00fd chung\">M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 Nh\u1eadt k\u00fd chung<\/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\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html#Su_dung_ham_%E2%80%9CHeoSQL%E2%80%9D_de_lap_so_Nhat_ky_chung\" title=\"S\u1eed d\u1ee5ng h\u00e0m \u201cHeoSQL\u201d \u0111\u1ec3 l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung\">S\u1eed d\u1ee5ng h\u00e0m \u201cHeoSQL\u201d \u0111\u1ec3 l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html#Mau_so_Nhat_ky_chung\" title=\"M\u1eabu s\u1ed5 Nh\u1eadt k\u00fd chung\">M\u1eabu s\u1ed5 Nh\u1eadt k\u00fd chung<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-lap-nhat-ky-chung-bang-ham-heosql.html#Cach_thuc_thuc_hien_voi_ham_%E2%80%9CHeoSQL%E2%80%9D\" title=\"C\u00e1ch th\u1ef1c th\u1ef1c hi\u1ec7n v\u1edbi h\u00e0m \u201cHeoSQL\u201d\">C\u00e1ch th\u1ef1c th\u1ef1c hi\u1ec7n v\u1edbi h\u00e0m \u201cHeoSQL\u201d<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Muc_dich_va_vai_tro_cua_so_Nhat_ky_chung\"><\/span>M\u1ee5c \u0111\u00edch v\u00e0 vai tr\u00f2 c\u1ee7a s\u1ed5 Nh\u1eadt k\u00fd chung<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u2013 S\u1ed5 Nh\u1eadt k\u00fd chung l\u00e0 s\u1ed5 k\u1ebf to\u00e1n t\u1ed5ng h\u1ee3p d\u00f9ng \u0111\u1ec3 ghi ch\u00e9p c\u00e1c nghi\u1ec7p v\u1ee5 kinh t\u1ebf, t\u00ecnh h\u00ecnh t\u00e0i ch\u00ednh ph\u00e1t sinh trong k\u1ef3 theo tr\u00ecnh t\u1ef1 th\u1eddi gian \u0111\u1ed3ng th\u1eddi ph\u1ea3n \u00e1nh theo quan h\u1ec7 \u0111\u1ed1i \u1ee9ng t\u00e0i kho\u1ea3n (\u0110\u1ecbnh kho\u1ea3n k\u1ebf to\u00e1n) \u0111\u1ec3 ph\u1ee5c v\u1ee5 vi\u1ec7c ghi S\u1ed5 C\u00e1i.<\/p>\n<p style=\"text-align: justify\">\u2013 S\u1ed1 li\u1ec7u ghi tr\u00ean s\u1ed5 Nh\u1eadt k\u00fd chung \u0111\u01b0\u1ee3c d\u00f9ng l\u00e0m c\u0103n c\u1ee9 \u0111\u1ec3 ghi v\u00e0o S\u1ed5 C\u00e1i.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Su_dung_ham_%E2%80%9CHeoSQL%E2%80%9D_de_lap_so_Nhat_ky_chung\"><\/span>S\u1eed d\u1ee5ng h\u00e0m \u201cHeoSQL\u201d \u0111\u1ec3 l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Trong ph\u1ea7n n\u00e0y ch\u00fang ta s\u1ebd ti\u1ebfn h\u00e0nh l\u1eadp s\u1ed5 Nh\u1eadt k\u00fd chung b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m \u201cHeoSQL\u201d \u2013 m\u1ed9t trong s\u1ed1 nh\u1eefng h\u00e0m trong Add \u2013 ins HocExcelOnline. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i Add \u2013 ins n\u00e0y \u1edf link ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cai-dat-add-ins-hocexcelonline.html\"><em><strong>H\u01b0\u1edbng d\u1eabn c\u00e0i \u0111\u1eb7t add ins hocexcelonline<\/strong><\/em><\/a><\/p>\n<p style=\"text-align: justify\">\u1ede \u0111\u00e2y m\u00ecnh c\u00f3 DATA m\u1eabu nh\u01b0 sau, DATA n\u00e0y b\u1ea1n s\u1ebd nh\u1eadp li\u1ec7u h\u00e0ng ng\u00e0y.\u00a0Ta s\u1ebd c\u0103n c\u1ee9 v\u00e0o DATA n\u00e0y \u0111\u1ec3 l\u1ea5y d\u1eef li\u1ec7u l\u00ean s\u1ed5 nh\u1eadt k\u00fd chung.<\/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-347.gif\" title=\"ex101_92019-nho-347\"><br \/>\n<\/a>\n<\/div>\n<\/div>\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-150.gif\" title=\"vba101_92019-nho-150\"><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-347.gif\" title=\"ex101_92019-nho-347\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/08\/1-30.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29772 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-30-1024x519-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-su-dung-ham-heosql-1\" width=\"1024\" height=\"519\" title=\"1-30-1024x519-1\"><\/a><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Mau_so_Nhat_ky_chung\"><\/span>M\u1eabu s\u1ed5 Nh\u1eadt k\u00fd chung<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1ec1 m\u1eabu s\u1ed5 nh\u1eadt k\u00fd chung th\u00ec c\u00f3 kh\u00e1 nhi\u1ec1u, c\u00e1c \u0111\u01a1n v\u1ecb c\u00f3 th\u1ec3 tu\u1ef3 bi\u1ebfn th\u00eam c\u00e1c ch\u1ec9 ti\u00eau kh\u00e1c nhau \u0111\u1ec3 ph\u00f9 h\u1ee3p. Tuy nhi\u00ean v\u1eabn ph\u1ea3i \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c k\u1ebft c\u1ea5u l\u00e0 ph\u1ea3n \u00e1nh \u0111\u01b0\u1ee3c c\u00e1c th\u00f4ng tin li\u00ean quan t\u1edbi t\u00ecnh h\u00ecnh c\u00e1c nghi\u1ec7p v\u1ee5 kinh t\u1ebf ph\u00e1t sinh trong k\u1ef3 m\u1ed9t c\u00e1ch ch\u00ednh x\u00e1c.<\/p>\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, <strong>H\u1ecdc Excel Online<\/strong> s\u1ebd s\u1eed d\u1ee5ng m\u1eabu S\u1ed5 Nh\u1eadt k\u00fd chung nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29728 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-28-1024x760-1.png\" alt=\"huong-dan-lap-so-nhat-ky-chung-su-dung-ham-heosql-2\" width=\"1024\" height=\"760\" title=\"2-28-1024x760-1\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_thuc_thuc_hien_voi_ham_%E2%80%9CHeoSQL%E2%80%9D\"><\/span>C\u00e1ch th\u1ef1c th\u1ef1c hi\u1ec7n v\u1edbi h\u00e0m \u201cHeoSQL\u201d<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">V\u1edbi h\u00e0m n\u00e0y ch\u00fang ta th\u1ef1c hi\u1ec7n vi\u1ebft c\u00e2u truy v\u1ea5n SQL, c\u1ee5 th\u1ec3 \u0111\u1ec3 l\u1ead p \u0111\u01b0\u1ee3c s\u1ed5 Nh\u1eadt k\u00fd chung th\u00ec trong b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n s\u1eed d\u1ee5ng c\u00e2u truy v\u1ea5n nh\u01b0 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>=\u201dSELECT SO_PHIEU, NGAY, KYHIEUHD, SO_HD, DIEN_GIAI, TK_NO, TK_CO, SO_TIEN FROM DATA WHERE NGAY &gt;= \u201d &amp; Heorange(E8,2) &amp; \u201d AND NGAY &lt;= \u201d &amp; Heorange(E9,2)<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">V\u1edbi ph\u1ea7n tu\u1ef3 ch\u1ecdn (\u0111\u1ed1i s\u1ed1 th\u1ee9 2 c\u1ee7a h\u00e0m \u201cHeoSQL\u201d) b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ec3 nh\u01b0 sau:<\/p>\n<blockquote>\n<p><strong>STT = Y, TIEUDE = N, CHEN = Y<\/strong><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\"><strong>Trong \u0111\u00f3:<\/strong><\/p>\n<ul>\n<li><strong>STT = Y:<\/strong> T\u1ee9c l\u00e0 cho ph\u00e9p \u0111\u00e1nh s\u1ed1 th\u1ee9 t\u1ef1.<\/li>\n<li><strong>TIEUDE = N:<\/strong> C\u00e2u truy v\u1ea5n tr\u1ea3 v\u1ec1 kh\u00f4ng bao g\u1ed3m ti\u00eau \u0111\u1ec1.<\/li>\n<li><strong>CHEN = Y:<\/strong> Cho ph\u00e9p t\u1ef1 \u0111\u1ed9ng co d\u00e3n, ch\u00e8n d\u00f2ng khi d\u1eef li\u1ec7u thay \u0111\u1ed5i.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady l\u00e0 xong r\u1ed3i, kh\u00f4ng qu\u00e1 kh\u00f3 ph\u1ea3i kh\u00f4ng n\u00e0o \u0111\u1eb7c bi\u1ec7t, n\u1ebfu nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft t\u1edbi SQL th\u00ec l\u1ea1i c\u00e0ng d\u1ec5 d\u00e0ng.<\/p>\n<p style=\"text-align: justify\"><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2019\/08\/3.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-29729 size-large\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-1024x500-1.gif\" alt=\"huong-dan-lap-so-nhat-ky-chung-su-dung-ham-heosql-3\" width=\"1024\" height=\"500\" title=\"3-1024x500-1\"><\/a><\/p>\n<p style=\"text-align: justify\">Ch\u1ec9 c\u1ea7n 1 c\u00f4ng th\u1ee9c v\u1edbi c\u00e2u truy v\u1ea5n SQL nh\u01b0 tr\u00ean l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 \u0111\u01b0\u1ee3c S\u1ed5 Nh\u1eadt k\u00fd chung m\u1ed9t c\u00e1ch nhanh ch\u00f3ng v\u00e0 s\u1ed5 n\u00e0y ho\u00e0n to\u00e0n linh \u0111\u1ed9ng khi b\u1ea1n thay \u0111\u1ed5i kho\u1ea3ng th\u1eddi gian t\u1eeb ng\u00e0y <strong>(\u00f4 E8)<\/strong>, \u0111\u1ebfn ng\u00e0y <strong>(\u00f4 E9).<\/strong><\/p>\n<p style=\"text-align: justify\">Hy v\u1ecdng qua b\u00e0i vi\u1ebft n\u00e0y c\u1ee7a <strong>H\u1ecdc Excel Online<\/strong> b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u1ef1 t\u1ea1o cho m\u00ecnh \u0111\u01b0\u1ee3c <strong>S\u1ed5 Nh\u1eadt k\u00fd chung<\/strong> trong k\u1ebf to\u00e1n m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng 1 c\u00e2u truy v\u1ea5n trong h\u00e0m \u201cHeoSQL\u201d. V\u00e0 s\u1ed5 s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt theo kho\u1ea3ng th\u1eddi gian m\u00e0 b\u1ea1n mu\u1ed1n xem t\u00ecnh h\u00ecnh ph\u00e1t sinh. File \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft n\u00e0y b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 \u1edf Link ngay d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">Download file \u0111\u00ednh k\u00e8m b\u00e0i vi\u1ebft \u1edf \u0111\u00e2y:\u00a0<a href=\"https:\/\/drive.google.com\/file\/d\/15ZFJkSEPUW9SlUGsyNUijYcYE4IkErpP\/view?usp=sharing\"><em><strong>H\u01b0\u1edbng d\u1eabn l\u1eadp s\u1ed5 nh\u1eadt k\u00fd chung b\u1eb1ng h\u00e0m \u201cHeoSQL\u201d trong Excel<\/strong><\/em><\/a><\/p>\n<hr>\n<p style=\"padding-left: 30px;text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-ke-toan-chi-tiet-vat-tu-san-pham-hang-hoa-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft v\u1eadt t\u01b0, s\u1ea3n ph\u1ea9m, h\u00e0ng ho\u00e1 tr\u00ean excel<\/a><\/strong><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-lam-chi-tiet-tien-gui-ngan-hang-trong-excel.html\">h\u01b0\u1edbng d\u1eabn c\u00e1ch l\u00e0m s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n g\u1eedi ng\u00e2n h\u00e0ng tr\u00ean excel<\/a><\/strong><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-lam-quy-tien-mat-trong-excel.html\">H\u01b0\u1edbng d\u1eabn l\u00e0m s\u1ed5 qu\u1ef9 ti\u1ec1n m\u1eb7t, s\u1ed5 k\u1ebf to\u00e1n chi ti\u1ebft ti\u1ec1n m\u1eb7t tr\u00ean excel<\/a><\/strong><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-cach-tao-phieu-thu-chi-tren-excel.html\">H\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o phi\u1ebfu thu, phi\u1ebfu chi tr\u00ean excel<\/a><\/strong><\/p>\n<p style=\"padding-left: 30px;text-align: justify\"><strong><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-su-dung-ham-heongaychu-de-doc.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng h\u00e0m \u201cheongaychu\u201d \u0111\u1ec3 chuy\u1ec3n d\u1eef li\u1ec7u ng\u00e0y th\u00e1ng v\u1ec1 d\u1ea1ng ch\u1eef<\/a><\/strong><\/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-347.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":4335,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-4334","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\/4334","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=4334"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/4334\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/4335"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=4334"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=4334"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=4334"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}