{"id":1506,"date":"2024-12-02T05:20:05","date_gmt":"2024-12-02T05:20:05","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge\/"},"modified":"2024-12-02T05:20:05","modified_gmt":"2024-12-02T05:20:05","slug":"tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge\/","title":{"rendered":"T\u1ea1o th\u01b0 t\u1ef1 \u0111\u1ed9ng t\u1eeb d\u1eef li\u1ec7u Excel sang Word \u2013 t\u00ednh n\u0103ng tr\u1ed9n th\u01b0 Mail Merge"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id=\"mail-merge-trong-excel\" cite=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html?mail-merge-trong-excel\">\n<p style=\"text-align: justify\">Tr\u1ed9n th\u01b0 (<strong><em>Mail Merge trong excel<\/em><\/strong>) l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 v\u00f4 c\u00f9ng ti\u1ebft ki\u1ec7m th\u1eddi gian khi ph\u1ea3i g\u1eedi m\u1ed9t l\u01b0\u1ee3ng th\u01b0 l\u1edbn. N\u00f3 gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u1ea1o m\u1ed9t l\u00e1 th\u01b0, email hay t\u1ef1a th\u01b0 trong Word b\u1eb1ng c\u00e1ch h\u1ee3p nh\u1ea5t th\u00f4ng tin b\u1ea1n c\u00f3 trong trang t\u00ednh Excel.\u00a0<strong>H\u1ecdc excel n\u00e2ng cao Online<\/strong> s\u1ebd cung c\u1ea5p cho b\u1ea1n t\u1ed5ng quan c\u1ee7a \u0111\u1eb7c t\u00ednh n\u00e0y v\u00e0 h\u01b0\u1edbng d\u1eabn tr\u1ed9n th\u01b0 theo t\u1eebng b\u01b0\u1edbc.<\/p>\n<\/blockquote>\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-674d4384821b7\" 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\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Nen_tang_tron_thu\" title=\"N\u1ec1n t\u1ea3ng tr\u1ed9n th\u01b0:\">N\u1ec1n t\u1ea3ng tr\u1ed9n th\u01b0:<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#_Chuan_bi_trang_tinh_Excel_cho_tron_thu\" title=\"\u00a0Chu\u1ea9n b\u1ecb trang t\u00ednh Excel cho tr\u1ed9n th\u01b0:\">\u00a0Chu\u1ea9n b\u1ecb trang t\u00ednh Excel cho tr\u1ed9n th\u01b0:<\/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-3\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Cach_tron_thu_tu_Excel_sang_Word\" title=\"C\u00e1ch tr\u1ed9n th\u01b0 t\u1eeb Excel sang Word:\">C\u00e1ch tr\u1ed9n th\u01b0 t\u1eeb Excel sang Word:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Cach_tron_thu_voi_ngay_thang_tien_te_va_cac_loai_so_khac\" title=\"C\u00e1ch tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng, ti\u1ec1n t\u1ec7 v\u00e0 c\u00e1c lo\u1ea1i s\u1ed1 kh\u00e1c:\">C\u00e1ch tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng, ti\u1ec1n t\u1ec7 v\u00e0 c\u00e1c lo\u1ea1i s\u1ed1 kh\u00e1c:<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Tron_thu_voi_ngay_thang_va_so_bang_Dynamic_Data_Exchange\" title=\"Tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 b\u1eb1ng Dynamic Data Exchange\">Tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 b\u1eb1ng Dynamic Data Exchange<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Dinh_dang_ngay_thang_gio_so_va_tien_te_khi_tron_thu_trong_Word\" title=\"\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, gi\u1edd, s\u1ed1 v\u00e0 ti\u1ec1n t\u1ec7 khi tr\u1ed9n th\u01b0 trong Word\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, gi\u1edd, s\u1ed1 v\u00e0 ti\u1ec1n t\u1ec7 khi tr\u1ed9n th\u01b0 trong Word<\/a><\/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\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Dinh_dang_so_luong_don_vi_tien_te_va_phan_tram\" title=\"\u0110\u1ecbnh d\u1ea1ng s\u1ed1 l\u01b0\u1ee3ng, \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u00e0 ph\u1ea7n tr\u0103m\">\u0110\u1ecbnh d\u1ea1ng s\u1ed1 l\u01b0\u1ee3ng, \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u00e0 ph\u1ea7n tr\u0103m<\/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\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Dinh_dang_ngay_thang_va_thoi_gian\" title=\"\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian\">\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian<\/a>\n<ul class=\"ez-toc-list-level-4\">\n<li class=\"ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Thay_doi_dinh_dang_cua_ngay_thang_va_gio_hien_tai\" title=\"Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i:\">Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i:<\/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-10\" href=\"https:\/\/blog.hocexcel.online\/tao-thu-tu-dong-tu-du-lieu-excel-sang-word-tinh-nang-tron-thu-mail-merge.html#Phim_tat_Mail_Merge\" title=\"Ph\u00edm t\u1eaft Mail Merge:\">Ph\u00edm t\u1eaft Mail Merge:<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Nen_tang_tron_thu\"><\/span><strong>N\u1ec1n t\u1ea3ng tr\u1ed9n th\u01b0:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tr\u1ed9n th\u01b0 <strong>(mail merge trong excel<\/strong>) c\u00f3 th\u1ec3 tr\u00f4ng kh\u00f3 kh\u0103n, nh\u01b0ng tr\u00ean th\u1ef1c t\u1ebf qu\u00e1 tr\u00ecnh n\u00e0y kh\u00e1 \u0111\u01a1n gi\u1ea3n.<\/p>\n<p style=\"text-align: justify\">D\u1ec3 gi\u00fap b\u1ea1n hi\u1ec3u s\u00e2u h\u01a1n, qu\u00e1 tr\u00ecnh tr\u1ed9n th\u01b0 g\u1ed3m 3 t\u00e0i li\u1ec7u:<\/p>\n<ol style=\"text-align: justify\">\n<li>V\u0103n b\u1ea3n Word ch\u1ee9a m\u00e3 \u1ee9ng v\u1edbi t\u1eebng ph\u1ea7n c\u1ee5 th\u1ec3.<\/li>\n<li>T\u1ec7p ngu\u1ed3n tr\u1ed9n th\u01b0 Excel ch\u1ee9a th\u00f4ng tin ng\u01b0\u1eddi nh\u1eadn, m\u1ed7i h\u00e0ng l\u00e0 m\u1ed9t ng\u01b0\u1eddi nh\u1eadn.<\/li>\n<li>B\u1ea3n Word cu\u1ed1i c\u00f9ng v\u1edbi th\u01b0, email, b\u00ec th\u01b0 ho\u00e0n ch\u1ec9nh.<\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"_Chuan_bi_trang_tinh_Excel_cho_tron_thu\"><\/span><strong>\u00a0Chu\u1ea9n b\u1ecb trang t\u00ednh Excel cho tr\u1ed9n th\u01b0:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<ul style=\"text-align: justify\">\n<li>Khi b\u1ea1n tr\u1ed9n th\u01b0 (<strong>mail merge trong excel<\/strong>), t\u1ec7p Excel s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft n\u1ed1i v\u1edbi t\u00e0i li\u1ec7u tr\u1ed9n th\u01b0 c\u1ee7a Word. Microsoft Word s\u1ebd l\u1ea5y t\u00ean, \u0111\u1ecba ch\u1ec9 v\u00e0 c\u00e1c chi ti\u1ebft kh\u00e1c c\u1ee7a ng\u01b0\u1eddi nh\u1eadn tr\u1ef1c ti\u1ebfp t\u1eeb b\u1ea3ng t\u00ednh Excel.<\/li>\n<li>V\u00ec v\u1eady, tr\u01b0\u1edbc khi b\u1eaft \u0111\u1ea7u, h\u00e3y ch\u1eafc ch\u1eafn r\u1eb1ng t\u1ec7p Excel \u0111\u00e3 c\u00f3 t\u1ea5t c\u1ea3 th\u00f4ng tin b\u1ea1n mu\u1ed1n bao g\u1ed3m t\u00ean, h\u1ecd, l\u1eddi ch\u00e0o, m\u00e3 b\u01b0u \u0111i\u1ec7n, \u0111\u1ecba ch\u1ec9\u2026 N\u1ebfu b\u1ea1n mu\u1ed1n th\u00eam nhi\u1ec1u \u0111\u1ecba ch\u1ec9 li\u00ean h\u1ec7 ho\u1eb7c th\u00f4ng tin kh\u00e1c, b\u1ea1n n\u00ean thay \u0111\u1ed5i ho\u1eb7c b\u1ed5 sung b\u00ean trang t\u00ednh Excel tr\u01b0\u1edbc khi tr\u1ed9n th\u01b0.<\/li>\n<li>Nh\u1eefng \u0111i\u1ec1u quan tr\u1ecdng c\u1ea7n ki\u1ec3m tra:<\/li>\n<li>C\u00e1c c\u1ed9t trong b\u1ea3ng t\u00ednh Excel ph\u1ea3i kh\u1edbp v\u1edbi c\u00e1c ph\u1ea7n b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng khi tr\u1ed9n th\u01b0. V\u00ed d\u1ee5: n\u1ebfu b\u1ea1n mu\u1ed1n x\u01b0ng h\u00f4 v\u1edbi ng\u01b0\u1eddi \u0111\u1ecdc b\u1eb1ng T\u00ean, h\u00e3y ch\u1eafc ch\u1eafn \u0111\u00e3 t\u1ea1o hai c\u1ed9t h\u1ecd v\u00e0 t\u00ean ri\u00eang bi\u1ec7t. N\u1ebfu b\u1ea1n mu\u1ed1n s\u1eafp x\u1ebfp t\u00ean ng\u01b0\u1eddi nh\u1eadn theo bang ho\u1eb7c th\u00e0nh ph\u1ed1, x\u00e1c \u0111\u1ecbnh r\u1eb1ng b\u1ea1n \u0111\u00e3 c\u00f3 hai c\u1ed9t Bang v\u00e0 Th\u00e0nh ph\u1ed1 ri\u00eang bi\u1ec7t.<\/li>\n<li>N\u1ebfu t\u1ec7p Excel bao g\u1ed3m ng\u00e0y, gi\u1edd, gi\u00e1 tr\u1ecb ti\u1ec1n t\u1ec7 ho\u1eb7c m\u00e3 b\u01b0u \u0111i\u1ec7n b\u1eaft \u0111\u1ea7u ho\u1eb7c k\u1ebft th\u00fac b\u1eb1ng 0, h\u00e3y \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang s\u1ed1, s\u1ed1 ng\u00e0y v\u00e0 \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7.<\/li>\n<li>N\u1ebfu b\u1ea1n t\u1ea1o trang t\u00ednh Excel b\u1eb1ng c\u00e1ch nh\u1eadp th\u00f4ng tin t\u1eeb t\u1ec7p .csv ho\u1eb7c t\u1ec7p .txt, h\u00e3y s\u1eed d\u1ee5ng <strong><em>Text Import Wizard<\/em><\/strong>.<\/li>\n<\/ul>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tron_thu_tu_Excel_sang_Word\"><\/span><strong>C\u00e1ch tr\u1ed9n th\u01b0 t\u1eeb Excel sang Word:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Khi ho\u00e0n th\u00e0nh v\u00e0 ki\u1ec3m tra l\u1ea1i trang t\u00ednh Excel, b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 tr\u1ed9n th\u01b0. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta s\u1ebd tr\u1ed9n th\u01b0 v\u1edbi m\u1ed9t danh s\u00e1ch ng\u01b0\u1eddi nh\u1eadn trong Wrd 2010, t\u01b0\u01a1ng t\u1ef1 cho Word 2013.<\/p>\n<ol style=\"text-align: justify\">\n<li>N\u1ebfu b\u1ea1n \u0111\u00e3 so\u1ea1n th\u01b0 s\u1eb5n m\u1ed9t l\u00e1 th\u01b0, b\u1ea1n c\u00f3 th\u1ec3 m\u1edf m\u1ed9t t\u00e0i li\u1ec7u Word hi\u1ec7n c\u00f3, ho\u1eb7c t\u1ea1o m\u1ed9t t\u00e0i li\u1ec7u m\u1edbi.<\/li>\n<li>Ch\u1ecdn lo\u1ea1i tr\u1ed9n th\u01b0 b\u1ea1n mu\u1ed1n. V\u00e0o th\u1ebb <strong><em>Mailings &gt; Start Mail Merge <\/em><\/strong>v\u00e0 ch\u1ecdn ki\u1ec3u tr\u1ed9n th\u01b0 \u2013 th\u01b0 (<strong><em>Letters<\/em><\/strong>), email (<strong><em>E-mail Messages<\/em><\/strong>), tem th\u01b0 (<strong><em>Labels\u2026<\/em><\/strong>), b\u00ec th\u01b0 (<strong><em>Envelopes\u2026<\/em><\/strong>) ho\u1eb7c t\u00e0i li\u1ec7u (<strong><em>Normal Word Document<\/em><\/strong>). Trong v\u00ed d\u1ee5, ch\u00fang ta ch\u1ecdn <strong><em>Letters<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mail-merge-word.png\" alt=\"Choose what kind of mail merge you want to run.\" title=\"mail-merge-word\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Ch\u1ecdn ng\u01b0\u1eddi nh\u1eadn. Trong th\u1ebb <strong><em>Mailings &gt; Select Recipients &gt; Use Existing List\u2026<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><em>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-recipients.png\" alt=\"Select the recipients.\" title=\"select-recipients\"><\/em><\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>K\u1ebft n\u1ed1i trang t\u00ednh Excel v\u00e0 b\u1ea3n Word. B\u1eb1ng vi\u1ec7c thi\u1ebft l\u1eadp k\u1ebft n\u1ed1i gi\u1eefa Excel v\u00e0 Word, h\u00e3y \u0111\u1ea3m b\u1ea3o r\u1eb1ng ngu\u1ed3n d\u1eef li\u1ec7u tr\u1ed9n th\u01b0 s\u1ebd \u0111\u01b0\u1ee3c t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt m\u1ed7i l\u1ea7n b\u1ea1n thay \u0111\u1ed5i d\u1eef li\u1ec7u ng\u01b0\u1eddi nh\u1eadn tr\u00ean t\u1ec7p Excel.<\/li>\n<\/ol>\n<blockquote>\n<p style=\"text-align: justify\">Ti\u0300m hi\u00ea\u0309u th\u00eam:\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">Kh\u00f3a h\u1ecdc excel online<\/a><\/p>\n<\/blockquote>\n<p style=\"text-align: justify\">Trong h\u1ed9p tho\u1ea1i <strong><em>Select Data Source<\/em><\/strong>, t\u00ecm trang t\u00ednh Excel v\u00e0 nh\u1ea5p <strong><em>Open<\/em><\/strong>. N\u1ebfu Word y\u00eau c\u1ea7u b\u1ea1n ch\u1ecdn t\u1eeb b\u1ea3ng, h\u00e3y ch\u1ecdn v\u00e0 nh\u1ea5p OK.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/select-table.png\" alt=\"connect your Excel spreadsheet to the Word mail merge document you are creating.\" title=\"select-table\"><\/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-44.gif\" title=\"vba101_92019-nho-44\"><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-110.gif\" title=\"ex101_92019-nho-110\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>N\u1ebfu b\u1ea1n ch\u1ec9 mu\u1ed1n th\u00eam m\u1ed9t s\u1ed1 ng\u01b0\u1eddi nh\u1eadn t\u1eeb b\u1ea3ng t\u00ednh Excel, nh\u1ea5p n\u00fat <strong><em>Edit Recipient List <\/em><\/strong>trong nh\u00f3m <strong><em>Start Mail Merge<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-recipients-list.png\" alt=\"click the edit recipient List button if you want to include only some of the recipients.\" title=\"edit-recipients-list\"><\/p>\n<p style=\"text-align: justify\">H\u1ed9p tho\u1ea1i <strong><em>Mail Merge Recipients<\/em><\/strong>\u00b8 \u0111\u00e1nh d\u1ea5u ch\u1ecdn ho\u1eb7c b\u1ecf ch\u1ecdn \u0111\u1ec3 th\u00eam ho\u1eb7c lo\u1ea1i b\u1ecf ng\u01b0\u1eddi nh\u1eadn t\u1eeb tr\u1ed9n th\u01b0.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6153\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-143.png\" width=\"600\" height=\"443\" title=\"excel-dialog-box-launcher-1-143\"><\/p>\n<p style=\"text-align: justify\"><strong>\u00a0Ch\u00fa \u00fd. <\/strong>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1eafp x\u1ebfp, l\u1ecdc danh s\u00e1ch ng\u01b0\u1eddi nh\u1eadn v\u00e0 x\u00e1c nh\u1eadn \u0111\u1ecba ch\u1ec9 email b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o t\u00f9y ch\u1ecdn <strong><em>Validate addresses\u2026 <\/em><\/strong>d\u01b0\u1edbi ph\u1ea7n <strong><em>Refine Recipients List<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">Nh\u01b0 v\u1eady, ch\u00fang ta \u0111\u00e3 ho\u00e0n th\u00e0nh danh s\u00e1ch ng\u01b0\u1eddi nh\u1eadn v\u00e0 s\u1eb5n sang \u0111i\u1ec1n ch\u00fang v\u00e0o th\u01b0. G\u00f5 th\u01b0 m\u1eabu v\u00e0o Word ho\u1eb7c sao ch\u00e9p\/d\u00e1n t\u1eeb m\u1ed9t ngu\u1ed3n kh\u00e1c.<\/p>\n<ol style=\"text-align: justify\" start=\"6\">\n<li><strong> Th\u00eam ch\u1ed7 \u0111i\u1ec1n.<\/strong> B\u1ea1n c\u1ea7n x\u00e1c \u0111\u1ecbnh v\u1ecb tr\u00ed \u0111i\u1ec1n \u0111\u1ecba ch\u1ec9 <strong><em>Address Block <\/em><\/strong>v\u00e0 d\u00f2ng ch\u00e0o h\u1ecfi <strong><em>Greeting Line<\/em><\/strong>. T\u1edbi ph\u1ea7n <strong><em>Write &amp; Insert Fields<\/em><\/strong> trong th\u1ebb <strong><em>Mailings<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-placeholder.png\" alt=\"Add placeholders for the Address Block and Greeting Line.\" title=\"add-placeholder\"><\/p>\n<p style=\"text-align: justify\">T\u00f9y theo v\u1ecb tr\u00ed c\u1ea7n \u0111i\u1ec1n, h\u1ed9p tho\u1ea1i s\u1ebd m\u1edf ra r\u1ea5t nhi\u1ec1u s\u1ef1 l\u1ef1a ch\u1ecdn. Ch\u1ecdn t\u00f9y ch\u1ecdn b\u1ea1n mu\u1ed1n, x\u00e1c nh\u1eadn k\u1ebft qu\u1ea3 d\u01b0\u1edbi ph\u1ea7n v\u00e0 nh\u1ea5n OK. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm m\u0169i t\u00ean tr\u00e1i\/ph\u1ea3i \u0111\u1ec3 chuy\u1ec3n sang ph\u1ea7n xem tr\u01b0\u1edbc c\u1ee7a ng\u01b0\u1eddi nh\u1eadn tr\u01b0\u1edbc\/sau.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6154\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-144.png\" width=\"600\" height=\"309\" title=\"excel-dialog-box-launcher-1-144\"><\/p>\n<p style=\"text-align: justify\">Sau khi ho\u00e0n th\u00e0nh, v\u1ecb tr\u00ed c\u1ea7n \u0111i\u1ec1n s\u1ebd xu\u1ea5t hi\u1ec7n trong v\u0103n b\u1ea3n c\u1ee7a b\u1ea1n nh\u01b0 trong h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/placeholders-added.png\" alt=\"The placeholders will appear in a Word document.\" title=\"placeholders-added\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ed1i v\u1edbi m\u1ed9t v\u00e0i l\u00e1 th\u01b0, ch\u1ec9 c\u1ea7n th\u00eam <strong><em>Address Block<\/em><\/strong> v\u00e0 <strong><em>Greeting Line<\/em><\/strong> l\u00e0 \u0111\u1ee7. Khi b\u1ee9c th\u01b0 \u0111\u01b0\u1ee3c in ra, t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n sao s\u1ebd gi\u1ed1ng h\u1ec7t nhau ngo\u1ea1i tr\u1eeb t\u00ean v\u00e0 \u0111\u1ecba ch\u1ec9 c\u1ee7a ng\u01b0\u1eddi nh\u1eadn.<\/p>\n<p style=\"text-align: justify\">Trong nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c, b\u1ea1n c\u00f3 th\u1ec3 \u0111\u1eb7t d\u1eef li\u1ec7u c\u1ee7a ng\u01b0\u1eddi nh\u1eadn v\u00e0o n\u1ed9i dung th\u01b0 \u0111\u1ec3 t\u00f9y ch\u1ec9nh ch\u00fang theo c\u00e1 nh\u00e2n. \u0110\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, nh\u1ea5p <strong><em>Insert Merge Field<\/em><\/strong> v\u00e0 ch\u1ecdn d\u1eef li\u1ec7u b\u1ea1n mu\u1ed1n ch\u00e8n t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/insert-message-field.png\" alt=\"Click Insert Merge Field and choose the data you want to insert\" title=\"insert-message-field\"><\/p>\n<ol style=\"text-align: justify\" start=\"7\">\n<li><strong>Xem tr\u01b0\u1edbc l\u00e1 th\u01b0. <\/strong>Ch\u1eafc ch\u1eafn r\u1eb1ng d\u1eef li\u1ec7u ng\u01b0\u1eddi nh\u1eadn xu\u1ea5t hi\u1ec7n ch\u00ednh x\u00e1c trong l\u00e1 th\u01b0, nh\u1ea5n n\u00fat <strong><em>Preview Results<\/em><\/strong> tr\u00ean th\u1ebb <strong><em>Mailing<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/preview-results.png\" alt=\"Preview the letter.\" title=\"preview-results\"><\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u00edm m\u0169i t\u00ean tr\u00e1i\/ph\u1ea3i \u0111\u1ec3 xem m\u1ed7i l\u00e1 th\u01b0 ch\u1ee9a d\u1eef li\u1ec7u ng\u01b0\u1eddi nh\u1eadn.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/view-each-letter.png\" alt=\"use the left and right arrows to view each letter with the recipient's data.\" title=\"view-each-letter\"><\/p>\n<ol style=\"text-align: justify\" start=\"8\">\n<li><strong> Ho\u00e0n t\u1ea5t tr\u1ed9n th\u01b0.<\/strong> Khi \u0111\u00e3 h\u00e0i l\u00f2ng, nh\u1ea5n n\u00fat <strong><em>Finish &amp; Merge<\/em><\/strong> trong nh\u00f3m <strong><em>Finish<\/em><\/strong> \u0111\u1ec3 ch\u1ecdn in th\u01b0 ho\u1eb7c g\u1eedi mail ch\u00fang.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/finish-mail-merge.png\" alt=\"Click Print Documents to finish the merge and print the letters.\" title=\"finish-mail-merge\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n ch\u1ec9nh s\u1eeda v\u00e0i th\u1ee9 tr\u01b0\u1edbc khi in ho\u1eb7c g\u1eedi email, nh\u1ea5p v\u00e0o <strong><em>Edit Individual Documents<\/em><\/strong>. M\u1ed9t c\u1eeda s\u1ed5 m\u1edbi s\u1ebd m\u1edf ra v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i t\u1eebng ph\u1ea7n c\u1ee7a l\u00e1 th\u01b0 t\u00f9y th\u00edch.<\/p>\n<ol style=\"text-align: justify\" start=\"9\">\n<li><strong>Sao l\u01b0u v\u0103n b\u1ea3n tr\u1ed9n th\u01b0.<\/strong> B\u1ea1n sao l\u01b0u t\u1ec7p tr\u1ed9n th\u01b0 nh\u01b0 t\u1ec7p Word th\u00f4ng th\u01b0\u1eddng b\u1eb1ng c\u00e1ch nh\u1ea5n n\u00fat <strong><em>Save<\/em><\/strong> ho\u1eb7c nh\u1ea5n ph\u00edm <strong><em>Ctrl +S<\/em><\/strong>.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1ed9t khi \u0111\u00e3 sao l\u01b0u, t\u1ec7p s\u1ebd lu\u00f4n k\u1ebft n\u1ed1i v\u1edbi danh s\u00e1ch trong Excel. Khi b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng v\u0103n b\u1ea3n tr\u1ed9n th\u01b0 l\u1ea7n n\u1eefa, m\u1edf n\u00f3 ra v\u00e0 nh\u1ea5n <strong><em>Yes <\/em><\/strong>khi Word y\u00eau c\u1ea7u b\u1ea1n ti\u1ebfp t\u1ee5c k\u1ebft n\u1ed1i.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/keep-connection.png\" alt=\"click Yes to keep the connection between the Excel file and Word document.\" title=\"keep-connection\"><\/p>\n<p style=\"text-align: justify\">Ngo\u00e0i t\u00f9y ch\u1ecdn <strong><em>Mail Merge<\/em><\/strong> tr\u00ean thanh c\u00f4ng c\u1ee5, Microsoft Excel c\u0169ng cung c\u1ea5p t\u00ednh n\u0103ng t\u01b0\u01a1ng t\u1ef1 trong <strong><em>Mail Merge Wizard<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 v\u00e0o th\u1ebb <strong><em>Mailings &gt; Start Mail Merge &gt; Step-by-Step Mail Merge Wizard\u2026<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mail-merge-wizard.png\" alt=\"Starting the Mail Merge Wizard\" title=\"mail-merge-wizard\"><\/p>\n<p style=\"text-align: justify\">Khi nh\u1ea5p v\u00e0o \u0111\u00f3, <strong><em>Mail Merge Wizard<\/em><\/strong> hi\u1ec3n th\u1ecb b\u00ean ph\u1ea3i b\u00e0n h\u00ecnh v\u00e0 h\u01b0\u1edbng d\u1eabn b\u1ea1n tr\u1ed9n th\u01b0 theo t\u1eebng b\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/mail-merge-pane.png\" alt=\"The Mail Merge pane can walk you through the merge process step-by-step.\" title=\"mail-merge-pane\"><\/strong><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Cach_tron_thu_voi_ngay_thang_tien_te_va_cac_loai_so_khac\"><\/span><strong>C\u00e1ch tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng, ti\u1ec1n t\u1ec7 v\u00e0 c\u00e1c lo\u1ea1i s\u1ed1 kh\u00e1c:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">Khi tr\u1ed9n th\u01b0, b\u1ea1n c\u1ea7n ch\u00fa \u00fd gi\u00e1 tr\u1ecb s\u1ed1 nh\u01b0 ng\u00e0y th\u00e1ng, ti\u1ec1n t\u1ec7 v\u00e0 s\u1ed1. Trong ph\u1ea7n n\u00e0y, ch\u00fang t\u00f4i s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch \u0111\u1ecbnh d\u1ea1ng nh\u1eefng gi\u00e1 tr\u1ecb nh\u01b0 v\u1eady.<\/p>\n<p style=\"text-align: justify\"><strong>\u0110\u1ecbnh d\u1ea1ng zip codes v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c ch\u1ee9a s\u1ed1 0 trong Excel<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 kh\u00f4ng l\u00e0m m\u1ea5t s\u1ed1 0 \u0111\u1ee9ng \u0111\u1ea7u khi tr\u1ed9n th\u01b0, b\u1ea1n ch\u1ec9 c\u1ea7n \u0111\u1ecbnh d\u1ea1ng c\u1ed9t ZIP code th\u00e0nh d\u1ea1ng text trong Excel.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn c\u1ed9t ZIP code, nh\u1ea5p ph\u1ea3i, ch\u1ecdn <strong><em>Format Cells\u2026 <\/em><\/strong>t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-format-cells.png\" alt=\"Select Format Cells... from the context menu.\" title=\"excel-format-cells\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Trong th\u1ebb <strong><em>Number<\/em><\/strong>, ch\u1ecdn <strong><em>Text<\/em><\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/format-as-text.png\" alt=\"On the Number tab, select Text and then click OK.\" title=\"format-as-text\"><\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tron_thu_voi_ngay_thang_va_so_bang_Dynamic_Data_Exchange\"><\/span><strong>Tr\u1ed9n th\u01b0 v\u1edbi ng\u00e0y th\u00e1ng v\u00e0 s\u1ed1 b\u1eb1ng Dynamic Data Exchange<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu trang t\u00ednh Excel ch\u1ee9a ng\u00e0y th\u00e1ng, s\u1ed1 th\u1eadp ph\u00e2n, \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng <strong><em>Dynamic Data Exchange<\/em><\/strong> \u0111\u1ec3 \u0111\u1ea3m b\u1ea3o r\u1eb1ng c\u00e1c gi\u00e1 tr\u1ecb n\u00e0y \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng \u0111\u00fang sau khi tr\u1ed9n th\u01b0.<\/p>\n<ol style=\"text-align: justify\">\n<li>V\u00e0o <strong><em>File &gt; Options &gt; Advanced<\/em><\/strong>.<\/li>\n<li>L\u0103n thanh cu\u1ed1n xu\u1ed1ng ph\u1ea7n <strong><em>General<\/em><\/strong>, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Confirm file format conversion on open<\/em><\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/dynamic-data-exchange.png\" alt=\"Select the\" title=\"dynamic-data-exchange\"><\/p>\n<p style=\"text-align: justify\">B\u1eaft \u0111\u1ea7u tr\u1ed9n th\u01b0 nh\u01b0 \u0111\u00e3 h\u01b0\u1edbng d\u1eabn \u1edf ph\u1ea7n tr\u01b0\u1edbc.<\/p>\n<p style=\"text-align: justify\">Khi <strong><em>Dynamic Data Exchange<\/em><\/strong> \u0111\u01b0\u1ee3c k\u00edch ho\u1ea1t, b\u1ea1n c\u00f3 th\u1ec3 nh\u1eadn \u0111\u01b0\u1ee3c m\u1ed9t v\u00e0i y\u00eau c\u1ea7u, ch\u1ec9 c\u1ea7n nh\u1ea5n Yes ho\u1eb7c Ok. \u0111i\u1ec3m kh\u00e1c bi\u1ec7t duy nh\u1ea5t do v\u1edbi tr\u1ed9n th\u01b0 th\u00f4ng th\u01b0\u1eddng l\u00e0 ch\u1ecdn ngu\u1ed3n d\u1eef li\u1ec7u, ti\u1ebfn h\u00e0nh theo c\u00e1c b\u01b0\u1edbc sau.<\/p>\n<ol style=\"text-align: justify\">\n<li>Khi ch\u1ecdn ng\u01b0\u1eddi nh\u1eadn, nh\u1ea5p v\u00e0o <strong><em>Mailings &gt; Select Recipients &gt; Use an Existing List<\/em><\/strong> nh\u01b0 th\u00f4ng th\u01b0\u1eddng.<\/li>\n<li>D\u00f2 t\u00ecm tr\u00ean trang t\u00ednh, nh\u1ea5n \u0111\u00fap chu\u1ed9t ch\u1ecdn <strong><em>MS Excel Worksheets via DDE (*.xls)<\/em><\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong>\u00a0<img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-sheet-dde.png\" alt=\"browse TO your spreadsheet, double-click it and select MS Excel Worksheets via DDE (*.xls).\" title=\"excel-sheet-dde\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> N\u1ebfu t\u00f9y ch\u1ecdn <strong><em>MS Excel Worksheets via DDE (*.xls)<\/em><\/strong> kh\u00f4ng hi\u1ec3n th\u1ecb, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Select All <\/em><\/strong>\u1edf g\u00f3c d\u01b0\u1edbi b\u00ean tr\u00e1i.<\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Nh\u1ea5n v\u00e0o <strong><em>Entire Spreadsheet<\/em><\/strong>, v\u00e0 OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/entire-spreadsheet.png\" alt=\"Click Entire Spreadsheet.\" title=\"entire-spreadsheet\"><\/p>\n<p style=\"text-align: justify\">B\u00e2y gi\u1edd b\u1ea1n c\u00f3 th\u1ec3 ti\u1ebfp t\u1ee5c tr\u1ed9n th\u01b0 nh\u01b0 c\u00e1ch th\u00f4ng th\u01b0\u1eddng.<\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> Ph\u00f2ng ng\u1eeba nh\u1eefng th\u00f4ng b\u00e1o hi\u1ec3n th\u1ecb m\u1ed7i l\u1ea7n b\u1ea1n m\u1edf t\u1ec7p d\u1eef li\u1ec7u, b\u1ecf ch\u1ecdn <strong><em>Confirm file format conversion on open<\/em><\/strong> (<strong><em>Word Options &gt;Advanced &gt;General<\/em><\/strong>) sau khi k\u1ebft n\u1ed1i v\u1edbi danh s\u00e1ch th\u01b0.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_gio_so_va_tien_te_khi_tron_thu_trong_Word\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng, gi\u1edd, s\u1ed1 v\u00e0 ti\u1ec1n t\u1ec7 khi tr\u1ed9n th\u01b0 trong Word<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n \u0111\u1ecbnh d\u1ea1ng s\u1ed1, ng\u00e0y th\u00e1ng hay ti\u1ec1n t\u1ec7 theo nhi\u1ec1u c\u00e1ch kh\u00e1c v\u1edbi t\u1ec7p ngu\u1ed3n tr\u1ed9n th\u01b0 Excel, b\u1ea1n c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n tr\u1ef1c ti\u1ebfp trong v\u0103n b\u1ea3n Word.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn v\u00f9ng tr\u1ed9n th\u01b0 mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng. Ch\u00fang c\u00f3 th\u1ec3 l\u00e0 <strong><em>Date, Currency, Percent<\/em><\/strong> ho\u1eb7c c\u00e1c v\u00f9ng kh\u00e1c.<\/li>\n<li>Nh\u1ea5n <strong><em>Shift + F9<\/em><\/strong> \u0111\u1ec3 hi\u1ec3n th\u1ecb m\u00e3 v\u00f9ng. V\u00ed d\u1ee5, b\u1ea1n ch\u1ecdn v\u00f9ng <strong><em>Currency<\/em><\/strong>, b\u1ea1n s\u1ebd th\u1ea5y <strong><em>{MERGEFIELD CURRENCY}.<\/em><\/strong><\/li>\n<li>Th\u00eam m\u1ed9t trong nh\u1eefng m\u00e3 h\u00ecnh trong c\u00e1c b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n mu\u1ed1n 3000 xu\u1ea5t hi\u1ec7n th\u00e0nh $3000, th\u00eam <strong><em># $,0<\/em><\/strong> v\u00e0 m\u00e3 sau s\u1ebd hi\u1ec3n th\u1ecb:<strong><em> {MERGEFIELD CURRENCY# $,0}<\/em><\/strong><\/li>\n<li>Nh\u1ea5n <strong><em>F9 <\/em><\/strong>\u0111\u1ec3 c\u1eadp nh\u1eadn v\u00f9ng. Sau \u0111\u00f3 nh\u1ea5n <strong><em>Shift + F9<\/em><\/strong> \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/li>\n<\/ol>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_so_luong_don_vi_tien_te_va_phan_tram\"><\/span><strong>\u0110\u1ecbnh d\u1ea1ng s\u1ed1 l\u01b0\u1ee3ng, \u0111\u01a1n v\u1ecb ti\u1ec1n t\u1ec7 v\u00e0 ph\u1ea7n tr\u0103m<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td width=\"145\"><strong>M\u00e3 h\u00ecnh<\/strong><\/td>\n<td width=\"185\"><strong>M\u00e3 v\u00f9ng \u0111\u1ea7y \u0111\u1ee7<\/strong><\/td>\n<td width=\"145\"><strong>V\u00ed d\u1ee5<\/strong><\/td>\n<td width=\"185\"><strong>M\u00f4 t\u1ea3<\/strong><\/td>\n<\/tr>\n<tr>\n<td># 0<\/td>\n<td>{MERGEFIELD CURRENCY# 0}<\/td>\n<td>3000<\/td>\n<td>L\u00e0m tr\u00f2n s\u1ed1<\/td>\n<\/tr>\n<tr>\n<td># ,0<\/td>\n<td>{MERGEFIELD CURRENCY# ,0}<\/td>\n<td>3,000<\/td>\n<td>L\u00e0m tr\u00f2n s\u1ed1 v\u1edbi ph\u00e2n s\u00e1ch ph\u1ea7n ng\u00e0n b\u1eb1ng d\u1ea5u ph\u1ea9y<\/td>\n<\/tr>\n<tr>\n<td># ,0.00<\/td>\n<td>{MERGEFIELD CURRENCY# ,0.00}<\/td>\n<td>3,000.00<\/td>\n<td>S\u1ed1 ch\u1ee9a hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 ph\u00e2n c\u00e1ch ph\u1ea7n ng\u00e0n b\u1eb1ng d\u1ea5u ph\u1ea9y<\/td>\n<\/tr>\n<tr>\n<td># $,0<\/td>\n<td>{MERGEFIELD CURRENCY# $,0}<\/td>\n<td>$3,000<\/td>\n<td>L\u00e0m tr\u00f2n \u0111\u00f4 la v\u00e0 d\u1ea5u ph\u1ea9y ph\u00e2n c\u00e1ch ph\u1ea7n ng\u00e0n<\/td>\n<\/tr>\n<tr>\n<td># $,0.00<\/td>\n<td>{MERGEFIELD CURRENCY# $,0.00}<\/td>\n<td>$3,000.00<\/td>\n<td>Dollar ch\u1ee9a hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n v\u00e0 ph\u00e2n c\u00e1ch ph\u1ea7n ng\u00e0n b\u1eb1ng d\u1ea5u ph\u1ea9y<\/td>\n<\/tr>\n<tr>\n<td># \u201c$,0.00;($,0.00);\u2019-\u2018\u201d<\/td>\n<td>{MERGEFIELD CURRENCY# \u201c$,0.00;($,0.00);\u2019-\u2018\u201d}<\/td>\n<td>($3,000.00)<\/td>\n<td>K\u00ed hi\u1ec7u \u0111\u1ed9-la, d\u1ea5u ngo\u1eb7c c\u00f3 ngh\u0129a l\u00e0 s\u1ed1 \u00e2m v\u00e0 m\u1ed9t d\u1ea5u g\u1ea1ch n\u1ed1i cho gi\u00e1 tr\u1ecb 0<\/td>\n<\/tr>\n<tr>\n<td># 0.00%<\/td>\n<td>{MERGEFIELD PERCENT# 0.00%}<\/td>\n<td>1.00%<\/td>\n<td>Ph\u1ea7n tr\u0103m ch\u1ee9a hai ch\u1eef s\u1ed1 th\u1eadp ph\u00e2n<\/td>\n<\/tr>\n<tr>\n<td># 0%<\/td>\n<td>{MERGEFIELD PERCENT# 0%}<\/td>\n<td>1%<\/td>\n<td>L\u00e0m tr\u00f2n ph\u1ea7n tram<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\"><strong>\u00a0<\/strong><strong>Ch\u00fa \u00fd.<\/strong> Thay v\u00ec k\u00ed hi\u1ec7u $, b\u1ea1n c\u00f3 th\u1ec3 thay b\u1eb1ng k\u00fd hi\u1ec7u ti\u1ec1n t\u1ec7 kh\u00e1c \u20ac ho\u1eb7c \u00a3.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Dinh_dang_ngay_thang_va_thoi_gian\"><\/span><a href=\"http:\/\/blog.ezworkapp.com\/dinh-dang-thoi-gian-trong-excel-cach-su-dung-ham-now-va-time-de-chen-thoi-gian.html\" target=\"_blank\" rel=\"noopener noreferrer\"><strong>\u0110\u1ecbnh d\u1ea1ng ng\u00e0y th\u00e1ng v\u00e0 th\u1eddi gian<\/strong><\/a><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td width=\"265\"><strong>M\u00e3 h\u00ecnh Ng\u00e0y th\u00e1ng\/Th\u1eddi gian<\/strong><\/td>\n<td width=\"220\"><strong>V\u00ed d\u1ee5<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201ddd\/MMM\/yyyy\u201d<\/td>\n<td>20\/May\/2014<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201dd\/MMM\/yy\u201d}<\/td>\n<td>20\/May\/14<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201dd MMMM yyyy\u201d}<\/td>\n<td>20 May 2014<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201dd, MMMM yyyy\u201d<\/td>\n<td>20, May 2014<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201ddddd, d MMMM yyyy\u201d<\/td>\n<td>Tuesday, 20 May 2014<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@\u201dddd, d MMMM yyyy\u201d<\/td>\n<td>Tue, 20 May 2014<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@ \u201ch:mm am\/pm\u201d<\/td>\n<td>10:45 PM<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@ \u201cHH:mm\u201d<\/td>\n<td>10:45<\/td>\n<\/tr>\n<tr>\n<td width=\"265\">@ \u201cHH:mm:ss\u201d<\/td>\n<td>10:45:32<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng d, M, y cho ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd, nh\u01b0ng nh\u1edb r\u1eb1ng M \u0111\u1ea1i di\u1ec7n cho th\u00e1ng c\u00f2n m \u0111\u1ea1i di\u1ec7n cho ph\u00fat.<\/p>\n<h4 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Thay_doi_dinh_dang_cua_ngay_thang_va_gio_hien_tai\"><\/span><strong>Thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ng\u00e0y th\u00e1ng v\u00e0 gi\u1edd hi\u1ec7n t\u1ea1i:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n th\u00eam v\u00f9ng <strong>DATE <\/strong>v\u00e0 <strong>TIME<\/strong> hi\u1ec3n th\u1ecb th\u1eddi gian hi\u1ec7n t\u1ea1i trong v\u0103n b\u1ea3n tr\u1ed9n th\u01b0, b\u1ea1n c\u00f3 th\u1ec3 thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng c\u1ee7a ch\u00fang.<\/p>\n<ol style=\"text-align: justify\">\n<li>Ch\u1ecdn v\u00f9ng <strong><em>Date<\/em><\/strong> ho\u1eb7c <strong><em>Time<\/em><\/strong> b\u1ea1n mu\u1ed1n thay \u0111\u1ed5i \u0111\u1ecbnh d\u1ea1ng.<\/li>\n<li>Nh\u1ea5n <strong><em>Shift + F9 <\/em><\/strong>\u0111\u1ec3 hi\u1ec3n th\u1ecb m\u00e3 v\u00f9ng. N\u1ebfu b\u1ea1n ch\u1ecdn v\u00f9ng <strong><em>Date<\/em><\/strong>, b\u1ea1n s\u1ebd th\u1ea5y <strong><em>{DATE @ \u201cM\/d\/yyyy\u201d}<\/em><\/strong><\/li>\n<li>Nh\u1ea5p ph\u1ea3i v\u00e0o v\u00f9ng v\u00e0 ch\u1ecdn <strong><em>Edit Fields<\/em><\/strong> t\u1eeb danh s\u00e1ch t\u00f9y ch\u1ecdn.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/edit-field.png\" alt=\"Right-click the field and choose Edit Field from the context menu.\" title=\"edit-field\"><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Field<\/em><\/strong>, \u0111\u1ea3m b\u1ea3o r\u1eb1ng \u00f4 <strong><em>Field names <\/em><\/strong>\u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng <strong><em>Date<\/em><\/strong>. Ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n trong <strong><em>Date formats<\/em><\/strong> v\u00e0 nh\u1ea5n OK.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><strong><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6155\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-145.png\" width=\"600\" height=\"434\" title=\"excel-dialog-box-launcher-1-145\"><\/strong><\/p>\n<p style=\"text-align: justify\"><strong>Ch\u00fa \u00fd.<\/strong> N\u1ebfu b\u1ea1n mu\u1ed1n gi\u1eef nguy\u00ean \u0111\u1ecbnh d\u1ea1ng khi c\u1eadp nh\u1eadt, \u0111\u00e1nh d\u1ea5u ch\u1ecdn <strong><em>Preserve formatting during updates <\/em><\/strong>\u1edf g\u00f3c tr\u00e1i b\u00ean d\u01b0\u1edbi c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Phim_tat_Mail_Merge\"><\/span><strong>Ph\u00edm t\u1eaft Mail Merge:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<table>\n<tbody>\n<tr>\n<td width=\"151\"><strong>Ph\u00edm t\u1eaft<\/strong><\/td>\n<td width=\"416\"><strong>Ch\u1ee9c n\u0103ng<\/strong><\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + F9<\/td>\n<td width=\"416\">M\u1edf t\u1ea5t c\u1ea3 v\u00f9ng c\u1ea7n \u0111i\u1ec1n v\u00e0 k\u1ebft qu\u1ea3 trong v\u0103n b\u1ea3n tr\u1ed9n th\u01b0<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Shift + F9<\/td>\n<td width=\"416\">Hi\u1ec7n ra m\u00e3 c\u1ee7a nh\u1eefng ch\u1ed7 tr\u1ed1ng<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">F9<\/td>\n<td width=\"416\">C\u1eadp nh\u1eadt ch\u1ed7 tr\u1ed1ng \u0111\u01b0\u1ee3c ch\u1ecdn. \u0111\u1eb7t con tr\u1ecf v\u00e0o b\u1ea5t c\u1ee9 \u00f4 tr\u1ed1ng n\u00e0o v\u00e0 nh\u1ea5n F9 \u0111\u1ec3 c\u1eadp nh\u1eadt<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">F11<\/td>\n<td width=\"416\">\u0110\u1ebfn ch\u1ed7 tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n sau<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Shift + F11<\/td>\n<td width=\"416\">\u0110\u1ebfn ch\u1ed7 tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n tr\u01b0\u1edbc<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + E<\/td>\n<td width=\"416\">Ch\u1ec9nh s\u1eeda v\u0103n b\u1ea3n tr\u1ed9n th\u01b0. Ch\u00fa \u00fd: \u0111i\u1ec1u n\u00e0y s\u1ebd ng\u1eaft k\u1ebft n\u1ed1i gi\u1eefa t\u1ec7p Excel v\u00e0 v\u0103n b\u1ea3n Word, ngu\u1ed3n tr\u1ed9n th\u01b0 s\u1ebd kh\u00f4ng t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt n\u1eefa.<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + F<\/td>\n<td width=\"416\">Ch\u00e8n v\u00f9ng tr\u1ed9n th\u01b0 m\u1edbi t\u1eeb ngu\u1ed3n tr\u1ed9n th\u01b0<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + M<\/td>\n<td width=\"416\">In v\u0103n b\u1ea3n tr\u1ed9n th\u01b0<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Ctrl + F9<\/td>\n<td width=\"416\">Ch\u00e8n th\u00eam m\u1ed9t ch\u1ed7 tr\u1ed1ng<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Ctrl + F11<\/td>\n<td width=\"416\">Kh\u00f3a ch\u1ed7 tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n. K\u1ebft qu\u1ea3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt khi th\u00f4ng tin ngu\u1ed3n c\u1ee7a Excel thay \u0111\u1ed5i.<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Ctrl + Shift + F11<\/td>\n<td width=\"416\">M\u1edf kh\u00f3a ch\u1ed7 tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n. K\u1ebft qu\u1ea3 ch\u1ed7 tr\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt l\u1ea7n n\u1eefa.<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Ctrl + Shift + F9<\/td>\n<td width=\"416\">B\u1ecf li\u00ean k\u1ebft ch\u1ed7 tr\u1ed1ng c\u1ea7n \u0111i\u1ec1n. Ch\u1ed7 tr\u1ed1ng s\u1ebd \u0111\u01b0\u1ee3c x\u00f3a v\u0129nh vi\u1ec5n kh\u1ecfi v\u0103n b\u1ea3n v\u00e0 thay th\u1ebf b\u1eb1ng gi\u00e1 tr\u1ecb hi\u1ec7n t\u1ea1i hi\u1ec3n th\u1ecb d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng b\u00ecnh th\u01b0\u1eddng.<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + D<\/td>\n<td width=\"416\">Ch\u00e8n ng\u00e0y th\u00e1ng hi\u1ec3n th\u1ecb theo ng\u00e0y th\u00e1ng hi\u1ec7n t\u1ea1i<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + P<\/td>\n<td width=\"416\">Ch\u00e8n s\u1ed1 trang<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + T<\/td>\n<td width=\"416\">Ch\u00e8n th\u1eddi gian hi\u1ec3n th\u1ecb theo th\u1eddi gian hi\u1ec7n t\u1ea1i<\/td>\n<\/tr>\n<tr>\n<td width=\"151\">Alt + Shift + L<\/td>\n<td width=\"416\">Ch\u00e8n s\u1ed1 th\u1ee9 t\u1ef1<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n<p style=\"text-align: justify\">Mong\u00a0r\u0103\u0300ng v\u01a1\u0301i ba\u0300i vi\u00ea\u0301t na\u0300y, se\u0303 giu\u0301p cho ca\u0301c ba\u0323n co\u0301 th\u00ea\u0309\u00a0t\u1ea1o th\u01b0 t\u1ef1 \u0111\u1ed9ng t\u1eeb d\u1eef li\u1ec7u Excel sang Word \u2013 T\u00ednh n\u0103ng tr\u1ed9n th\u01b0 Mail Merge m\u00f4\u0323t ca\u0301ch d\u00ea\u0303 da\u0300ng nh\u00e2\u0301t.\u00a0\u0110\u00ea\u0309 co\u0301 th\u00ea\u0309 trau d\u00f4\u0300i ki\u00ea\u0301n th\u01b0\u0301c t\u01b0\u0300 c\u01a1 ba\u0309n \u0111\u00ea\u0301n n\u00e2ng cao v\u00ea\u0300 Excel ca\u0301c ba\u0323n ha\u0303y \u0111\u0103ng ki\u0301 tham gia ngay nh\u01b0\u0303ng kho\u0301a <a href=\"http:\/\/blog.ezworkapp.com\">h\u1ecdc word excel c\u00e2\u0301p t\u00f4\u0301c<\/a> v\u01a1\u0301i ca\u0301c chuy\u00ean gia co\u0301 nhi\u00ea\u0300u n\u0103m kinh nghi\u00ea\u0323m v\u00ea\u0300 Excel se\u0303 h\u01b0\u01a1\u0301ng d\u00e2\u0303n ca\u0301c ba\u0323n m\u00f4\u0323t ca\u0301ch t\u00e2\u0323n ti\u0300nh nh\u00e2\u0301t v\u01a1\u0301i gia\u0301 tha\u0300nh c\u01b0\u0323c h\u00e2\u0301p d\u00e2\u0303n.<\/p>\n<p style=\"text-align: justify\"><strong><em>Ngu\u1ed3<\/em><\/strong><strong><em>n:<\/em><\/strong><em>\u00a0<\/em><em>Ablebits, d\u1ecb<\/em><em>ch v\u00e0 bi\u00ean t\u1ead<\/em><em>p b\u1edf<\/em><em>i Hocexcel Online.<\/em><\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 \u1ee9ng d\u1ee5ng Excel v\u00e0o c\u00f4ng vi\u1ec7c m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 th\u00ec b\u1ea1n c\u00f2n ph\u1ea3i s\u1eed d\u1ee5ng t\u1ed1t c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c c\u1ee7a Excel:<\/p>\n<p>M\u1ed9t s\u1ed1 h\u00e0m c\u01a1 b\u1ea3n th\u01b0\u1eddng g\u1eb7p nh\u01b0:<\/p>\n<ul>\n<li>SUMIF, SUMIFS \u0111\u1ec3 t\u00ednh t\u1ed5ng theo 1 \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>COUNTIF, COUNTIFS \u0111\u1ec3 th\u1ed1ng k\u00ea, \u0111\u1ebfm theo m\u1ed9t \u0111i\u1ec1u ki\u1ec7n, nhi\u1ec1u \u0111i\u1ec1u ki\u1ec7n<\/li>\n<li>C\u00e1c h\u00e0m x\u1eed l\u00fd d\u1eef li\u1ec7u d\u1ea1ng chu\u1ed7i, d\u1ea1ng ng\u00e0y th\u00e1ng, d\u1ea1ng s\u1ed1\u2026<\/li>\n<li>C\u00e1c h\u00e0m d\u00f2 t\u00ecm tham chi\u1ebfu Index+Match, h\u00e0m SUMPRODUCT\u2026<\/li>\n<\/ul>\n<p>M\u1ed9t s\u1ed1 c\u00f4ng c\u1ee5 hay s\u1eed d\u1ee5ng nh\u01b0:<\/p>\n<ul>\n<li>\u0110\u1ecbnh d\u1ea1ng theo \u0111i\u1ec1u ki\u1ec7n v\u1edbi Conditional formatting<\/li>\n<li>Thi\u1ebft l\u1eadp \u0111i\u1ec1u ki\u1ec7n nh\u1eadp d\u1eef li\u1ec7u v\u1edbi Data Validation<\/li>\n<li>C\u00e1ch \u0111\u1eb7t Name v\u00e0 s\u1eed d\u1ee5ng Name trong c\u00f4ng th\u1ee9c<\/li>\n<li>L\u1eadp b\u00e1o c\u00e1o v\u1edbi Pivot Table\u2026<\/li>\n<\/ul>\n<p>R\u1ea5t nhi\u1ec1u ki\u1ebfn th\u1ee9c ph\u1ea3i kh\u00f4ng n\u00e0o? To\u00e0n b\u1ed9 nh\u1eefng ki\u1ebfn th\u1ee9c n\u00e0y c\u00e1c b\u1ea1n \u0111\u1ec1u c\u00f3 th\u1ec3 h\u1ecdc \u0111\u01b0\u1ee3c trong kh\u00f3a h\u1ecdc\u00a0<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia<\/a>\u00a0c\u1ee7a H\u1ecdc Excel Online. \u0110\u00e2y l\u00e0 kh\u00f3a h\u1ecdc gi\u00fap b\u1ea1n h\u1ec7 th\u1ed1ng ki\u1ebfn th\u1ee9c m\u1ed9t c\u00e1ch \u0111\u1ea7y \u0111\u1ee7, chi ti\u1ebft. H\u01a1n n\u1eefa kh\u00f4ng h\u1ec1 c\u00f3 gi\u1edbi h\u1ea1n v\u1ec1 th\u1eddi gian h\u1ecdc t\u1eadp n\u00ean b\u1ea1n c\u00f3 th\u1ec3 tho\u1ea3i m\u00e1i h\u1ecdc b\u1ea5t c\u1ee9 l\u00fac n\u00e0o, d\u1ec5 d\u00e0ng tra c\u1ee9u l\u1ea1i ki\u1ebfn th\u1ee9c khi c\u1ea7n. Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn cho b\u1ea1n khi \u0111\u0103ng k\u00fd tham gia kh\u00f3a h\u1ecdc. Chi ti\u1ebft xem t\u1ea1i: <a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\" target=\"_blank\" rel=\"noopener noreferrer\">HocExcel.Online<\/a><\/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-44.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1507,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-1506","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\/1506","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=1506"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1506\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1507"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1506"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1506"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1506"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}