{"id":7477,"date":"2024-12-21T17:42:15","date_gmt":"2024-12-21T17:42:15","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tao-template-va-tai-template-xuong-trong-excel\/"},"modified":"2024-12-21T17:42:15","modified_gmt":"2024-12-21T17:42:15","slug":"huong-dan-tao-template-va-tai-template-xuong-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/huong-dan-tao-template-va-tai-template-xuong-trong-excel\/","title":{"rendered":"H\u01b0\u1edbng d\u1eabn t\u1ea1o template v\u00e0 t\u1ea3i template xu\u1ed1ng trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1ch t\u1ea1o <strong><em>template trong Microsoft Excel. <\/em><\/strong>M\u1ed9t khi b\u1ea1n \u0111\u00e3 t\u1ea1o ra m\u1ed9t <strong><em>template<\/em><\/strong>, n\u00f3 s\u1ebd ch\u1ec9 c\u1ea7n v\u00e0i ch\u1ec9nh s\u1eeda nh\u1ecf \u0111\u1ec3 ph\u00f9 h\u1ee3p v\u1edbi m\u1ee5c \u0111\u00edch hi\u1ec7n t\u1ea1i c\u1ee7a b\u1ea1n v\u00e0 do \u0111\u00f3 c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c \u00e1p d\u1ee5ng cho nhi\u1ec1u tr\u01b0\u1eddng h\u1ee3p kh\u00e1c nhau v\u00e0 ti\u1ebft ki\u1ec7m th\u1eddi gian cho b\u1ea1n. C\u00e1c <strong><em>template <\/em><\/strong>c\u1ee7a Excel c\u0169ng c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n t\u1ea1o ra c\u00e1c t\u1ec7p t\u00e0i li\u1ec7u ph\u00f9 h\u1ee3p v\u00e0 h\u1ea5p d\u1eabn, g\u00e2y \u1ea5n t\u01b0\u1ee3ng v\u1edbi \u0111\u1ed3ng nghi\u1ec7p ho\u1eb7c ng\u01b0\u1eddi gi\u00e1m s\u00e1t c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">C\u00e1c template \u0111\u1eb7c bi\u1ec7t c\u00f3 gi\u00e1 tr\u1ecb \u0111\u1ed1i v\u1edbi c\u00e1c lo\u1ea1i t\u00e0i li\u1ec7u th\u01b0\u1eddng \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng nh\u01b0 l\u1ecbch Excel, k\u1ebf ho\u1ea1ch cho ng\u00e2n s\u00e1ch, h\u00f3a \u0111\u01a1n, h\u00e0ng t\u1ed3n kho v\u00e0 b\u1ea3ng \u0111i\u1ec1u khi\u1ec3n.<\/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-6766fdf6ce451\" 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-tao-template-va-tai-template-xuong-trong-excel.html#Tao_ra_mot_bang_tinh_moi_tu_mot_template_Excel_co_san\" title=\"T\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi t\u1eeb m\u1ed9t template Excel c\u00f3 s\u1eb5n\">T\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi t\u1eeb m\u1ed9t template Excel c\u00f3 s\u1eb5n<\/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-tao-template-va-tai-template-xuong-trong-excel.html#Lam_cach_nao_de_tim_them_cac_template\" title=\"L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 t\u00ecm th\u00eam c\u00e1c template?\">L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 t\u00ecm th\u00eam c\u00e1c template?<\/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\/huong-dan-tao-template-va-tai-template-xuong-trong-excel.html#Lam_the_nao_de_tao_mot_template_Excel_tuy_chinh\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template Excel tu\u1ef3 ch\u1ec9nh:\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template Excel tu\u1ef3 ch\u1ec9nh:<\/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\/huong-dan-tao-template-va-tai-template-xuong-trong-excel.html#Co_the_tim_Personal_Templates_cua_toi_o_Excel_2013_o_dau\" title=\"C\u00f3 th\u1ec3 t\u00ecm Personal Templates c\u1ee7a t\u00f4i \u1edf Excel 2013 \u1edf \u0111\u00e2u?\">C\u00f3 th\u1ec3 t\u00ecm Personal Templates c\u1ee7a t\u00f4i \u1edf Excel 2013 \u1edf \u0111\u00e2u?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/huong-dan-tao-template-va-tai-template-xuong-trong-excel.html#Lam_the_nao_de_tao_mot_template_mac_dinh_cho_Excel\" title=\"L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template m\u1eb7c \u0111\u1ecbnh cho Excel\">L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template m\u1eb7c \u0111\u1ecbnh cho Excel<\/a><\/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\/huong-dan-tao-template-va-tai-template-xuong-trong-excel.html#Tai_template_Excel_o_dau\" title=\"T\u1ea3i template Excel \u1edf \u0111\u00e2u?\">T\u1ea3i template Excel \u1edf \u0111\u00e2u?<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tao_ra_mot_bang_tinh_moi_tu_mot_template_Excel_co_san\"><\/span><strong>T\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi t\u1eeb m\u1ed9t <em>template Excel <\/em>c\u00f3 s\u1eb5n<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Thay v\u00ec b\u1eaft \u0111\u1ea7u v\u1edbi m\u1ed9t trang t\u00ednh tr\u1ed1ng, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi d\u1ef1a tr\u00ean c\u00e1c template trong Excel. V\u1edbi m\u1ed9t <strong><em>template<\/em><\/strong> ph\u00f9 h\u1ee3p th\u00ec b\u1ea1n th\u1ef1c s\u1ef1 c\u00f3 th\u1ec3 \u0111\u01a1n gi\u1ea3n h\u00f3a cu\u1ed9c s\u1ed1ng c\u1ee7a b\u1ea1n, b\u1edfi v\u00ec n\u00f3 x\u1eed l\u00fd h\u1ea7u h\u1ebft c\u00e1c c\u00f4ng th\u1ee9c ph\u1ee9c t\u1ea1p v\u00e0 tinh vi, c\u00f9ng v\u1edbi c\u00e1c t\u00ednh n\u0103ng kh\u00e1c c\u1ee7a Microsoft Excel m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 kh\u00f4ng bi\u1ebft \u0111\u1ebfn.<\/p>\n<p style=\"text-align: justify\">R\u1ea5t nhi\u1ec1u template mi\u1ec5n ph\u00ed cho Excel hi\u1ec7n \u0111\u00e3 c\u00f3 s\u1eb5n, v\u00e0 \u0111ang ch\u1edd b\u1ea1n s\u1eed d\u1ee5ng. \u0110\u1ec3 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi d\u1ef1a tr\u00ean m\u1ed9t template Excel hi\u1ec7n c\u00f3, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau.<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong Excel 2013, chuy\u1ec3n sang tab <strong><em>File<\/em><\/strong> &gt; nh\u1ea5p v\u00e0o <strong><em>New<\/em><\/strong> v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y nhi\u1ec1u <strong><em>template<\/em><\/strong> do <strong><em>Microsoft<\/em><\/strong> cung c\u1ea5p.<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5725\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-50.png\" width=\"600\" height=\"627\" title=\"excel-dialog-box-launcher-1-50\">Trong Excel 2010, b\u1ea1n c\u00f3 th\u1ec3:<\/p>\n<ul style=\"text-align: justify\">\n<li>Ch\u1ecdn t\u1eeb <strong><em>Sample Templates<\/em><\/strong> \u2013 \u0111\u00e2y l\u00e0 nh\u1eefng template c\u1ee7a Excel c\u01a1 b\u1ea3n \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00e0i \u0111\u1eb7t s\u1eb5n tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n.<\/li>\n<li>T\u00ecm ph\u1ea7n <strong><em>com Templates<\/em><\/strong>, b\u1ea5m v\u00e0o m\u1ed9t s\u1ed1 danh m\u1ee5c \u0111\u1ec3 xem c\u00e1c h\u00ecnh thu nh\u1ecf c\u1ee7a template, v\u00e0 sau \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i v\u1ec1 nh\u1eefng template m\u00e0 b\u1ea1n mu\u1ed1n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel2010-templates.png\" alt=\"Creating a workbook from an existing template in Excel 2010\" title=\"excel2010-templates\"><\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>\u0110\u1ec3 xem tr\u01b0\u1edbc m\u1ed9t template nh\u1ea5t \u0111\u1ecbnh, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o n\u00f3. B\u1ea3n xem tr\u01b0\u1edbc c\u1ee7a template \u0111\u01b0\u1ee3c ch\u1ecdn s\u1ebd hi\u1ec3n th\u1ecb c\u00f9ng v\u1edbi t\u00ean nh\u00e0 xu\u1ea5t b\u1ea3n v\u00e0 chi ti\u1ebft b\u1ed5 sung v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng template.<\/li>\n<li>N\u1ebfu b\u1ea1n th\u00edch b\u1ea3n xem tr\u01b0\u1edbc c\u1ee7a m\u1eabu, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat <strong><em>Create<\/em><\/strong> \u0111\u1ec3 t\u1ea3i xu\u1ed1ng. V\u00ed d\u1ee5: T\u00f4i \u0111\u00e3 ch\u1ecdn m\u1ed9t <strong><em>template<\/em><\/strong> d\u1ea1ng l\u1ecbch r\u1ea5t \u0111\u1eb9p cho Excel:<\/li>\n<\/ol>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/make-excel-workbook-template.png\" alt=\"Downloading a calendar template for Excel\" title=\"make-excel-workbook-template\"><\/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-300.gif\" title=\"vba101_92019-nho-300\"><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-670.gif\" title=\"ex101_92019-nho-670\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">V\u00e0 \u0111\u00e2y \u2013 <strong><em>template<\/em><\/strong> m\u00e0 t\u00f4i \u0111\u00e3 ch\u1ecdn \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1ea3i xu\u1ed1ng v\u00e0 m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi \u0111\u01b0\u1ee3c t\u1ea1o d\u1ef1a tr\u00ean template n\u00e0y.<\/p>\n<h2 style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-calendar-template.png\" alt=\"A new workbook created with the selected template\" title=\"excel-calendar-template\"><\/h2>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_cach_nao_de_tim_them_cac_template\"><\/span><strong>L\u00e0m c\u00e1ch n\u00e0o \u0111\u1ec3 t\u00ecm th\u00eam c\u00e1c <em>template<\/em>?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 \u0111\u01b0\u1ee3c l\u1ef1a ch\u1ecdn nhi\u1ec1u h\u01a1n c\u00e1c <strong><em>template<\/em><\/strong> cho Excel c\u1ee7a b\u1ea1n, h\u00e3y g\u00f5 m\u1ed9t t\u1eeb kho\u00e1 t\u01b0\u01a1ng \u1ee9ng trong thanh t\u00ecm ki\u1ebfm:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5726\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-51.png\" width=\"600\" height=\"300\" title=\"excel-dialog-box-launcher-1-51\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t c\u00e1i g\u00ec \u0111\u00f3 c\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c <strong><em>template<\/em><\/strong> m\u00e0 Microsoft Excel c\u00f3 s\u1eb5n theo th\u1ec3 lo\u1ea1i. V\u00ed d\u1ee5 nh\u01b0, xem c\u00f3 bao nhi\u00eau <strong><em>template<\/em><\/strong> l\u1ecbch kh\u00e1c nhau m\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn t\u1eeb:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5727\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-52.png\" width=\"600\" height=\"470\" title=\"excel-dialog-box-launcher-1-52\"><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: Khi b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t template nh\u1ea5t \u0111\u1ecbnh, <strong><em>Microsoft Excel <\/em><\/strong>hi\u1ec3n th\u1ecb t\u1ea5t c\u1ea3 c\u00e1c template li\u00ean quan c\u00f3 s\u1eb5n tr\u00ean <strong><em>Office Store.<\/em><\/strong> Kh\u00f4ng ph\u1ea3i t\u1ea5t c\u1ea3 \u0111\u1ec1u do <strong><em>Microsoft Corporation <\/em><\/strong>t\u1ea1o ra, m\u1ed9t s\u1ed1 m\u1eabu \u0111\u01b0\u1ee3c t\u1ea1o b\u1edfi c\u00e1c nh\u00e0 cung c\u1ea5p b\u00ean th\u1ee9 ba ho\u1eb7c ng\u01b0\u1eddi d\u00f9ng c\u00e1 nh\u00e2n. \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y th\u00f4ng b\u00e1o y\u00eau c\u1ea7u n\u1ebfu b\u1ea1n tin t\u01b0\u1edfng ng\u01b0\u1eddi ph\u00e1t h\u00e0nh b\u1ea3n <strong><em>template<\/em><\/strong> \u0111\u00f3. Trong tr\u01b0\u1eddng h\u1ee3p tin t\u01b0\u1edfng, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat <strong>Trust this app<\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/new-app-office.png\" alt=\"To be able to use a template you may need to confirm that you trust the template's publisher.\" title=\"new-app-office\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tao_mot_template_Excel_tuy_chinh\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template Excel tu\u1ef3 ch\u1ec9nh:<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">T\u1ea1o ra m\u1ed9t template c\u1ee7a ri\u00eang b\u1ea1n trong Excel r\u1ea5t d\u1ec5 d\u00e0ng. B\u1ea1n ch\u1ec9 c\u1ea7n b\u1eaft \u0111\u1ea7u b\u1eb1ng v\u1edbi vi\u1ec7c t\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh theo c\u00e1ch th\u00f4ng th\u01b0\u1eddng, v\u00e0 ph\u1ea7n kh\u00f3 nh\u1ea5t l\u00e0 l\u00e0m cho n\u00f3 tr\u00f4ng ch\u00ednh x\u00e1c theo c\u00e1ch b\u1ea1n mu\u1ed1n. T\u1ea5t c\u1ea3 c\u00e1c \u0111\u1ecbnh d\u1ea1ng, ki\u1ec3u, v\u0103n b\u1ea3n v\u00e0 \u0111\u1ed3 ho\u1ea1 m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng trong b\u1ea3ng t\u00ednh ch\u1eafc ch\u1eafn \u0111\u00e1ng gi\u00e1 \u0111\u1ec3 \u0111\u1ea7u t\u01b0 th\u1eddi gian v\u00e0 c\u00f4ng s\u1ee9c, b\u1edfi v\u00ec t\u1ea5t c\u1ea3 s\u1ebd \u0111\u1ec1u xu\u1ea5t hi\u1ec7n tr\u00ean c\u00e1c b\u1ea3ng t\u00ednh m\u1edbi (c\u00f3 d\u1ef1a tr\u00ean <strong><em>template<\/em><\/strong> n\u00e0y).<\/p>\n<p style=\"text-align: justify\">Trong m\u1ed9t <strong><em>template<\/em><\/strong> c\u1ee7a <strong><em>Excel<\/em><\/strong>, b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng l\u01b0u c\u00e1c c\u00e0i \u0111\u1eb7t sau:<\/p>\n<ul style=\"text-align: justify\">\n<li>S\u1ed1 l\u01b0\u1ee3ng v\u00e0 lo\u1ea1i trang t\u00ednh<\/li>\n<li>C\u00e1c ki\u1ec3u v\u00e0 \u0111\u1ecbnh d\u1ea1ng c\u1ee7a \u00f4<\/li>\n<li>B\u1ed1 tr\u00ed trang v\u00e0 v\u00f9ng in cho m\u1ed7i trang t\u00ednh<\/li>\n<li>Khu v\u1ef1c \u1ea9n \u2013 l\u00e0m cho m\u1ed9t s\u1ed1 trang, h\u00e0ng, c\u1ed9t ho\u1eb7c \u00f4 n\u00e0o \u0111\u00f3 kh\u00f4ng nh\u00ecn th\u1ea5y \u0111\u01b0\u1ee3c<\/li>\n<li>C\u00e1c khu v\u1ef1c \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7 \u0111\u1ec3 ng\u0103n ng\u1eeba s\u1ef1 thay \u0111\u1ed5i trong m\u1ed9t s\u1ed1 \u00f4 nh\u1ea5t \u0111\u1ecbnh<\/li>\n<li>V\u0103n b\u1ea3n m\u00e0 b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n trong t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c t\u1ea1o d\u1ef1a tr\u00ean m\u1ed9t <strong><em>template <\/em><\/strong>nh\u1ea5t \u0111\u1ecbnh, ch\u1eb3ng h\u1ea1n nh\u01b0 nh\u00e3n cho c\u1ed9t ho\u1eb7c ti\u00eau \u0111\u1ec1 trang<\/li>\n<li>C\u00e1c c\u00f4ng th\u1ee9c, li\u00ean k\u1ebft, bi\u1ec3u \u0111\u1ed3, h\u00ecnh \u1ea3nh v\u00e0 \u0111\u1ed3 h\u1ecda kh\u00e1c<\/li>\n<li>T\u00f9y ch\u1ecdn x\u00e1c th\u1ef1c d\u1eef li\u1ec7u Excel nh\u01b0 danh s\u00e1ch k\u00e9o-th\u1ea3 xu\u1ed1ng, th\u00f4ng b\u00e1o x\u00e1c nh\u1eadn ho\u1eb7c c\u1ea3nh b\u00e1o, v.v.<\/li>\n<li>T\u00f9y ch\u1ecdn t\u00ednh to\u00e1n v\u00e0 c\u00e1c t\u00f9y ch\u1ecdn xem c\u1eeda s\u1ed5, v\u00ed d\u1ee5: \u0110\u00f3ng b\u0103ng d\u00f2ng ti\u00eau \u0111\u1ec1<\/li>\n<li>\u0110i\u1ec1u khi\u1ec3n <strong><em>Macro v\u00e0 ActiveX <\/em><\/strong>tr\u00ean c\u00e1c h\u00ecnh th\u1ee9c t\u00f9y ch\u1ec9nh<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111\u00e3 t\u1ea1o b\u1ea3ng t\u00ednh, b\u1ea1n ch\u1ec9 c\u1ea7n l\u01b0u n\u00f3 d\u01b0\u1edbi d\u1ea1ng t\u1ec7p .xlt ho\u1eb7c .xltx (t\u00f9y thu\u1ed9c v\u00e0o phi\u00ean b\u1ea3n Excel b\u1ea1n s\u1eed d\u1ee5ng) thay v\u00ec th\u00f4ng th\u01b0\u1eddng s\u1ebd l\u00e0 .xls ho\u1eb7c .xlsx. N\u1ebfu b\u1ea1n c\u1ea7n c\u00e1c b\u01b0\u1edbc chi ti\u1ebft, th\u00ec b\u1ea1n h\u00e3y:<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong Excel 2010 v\u00e0 2013, nh\u1ea5p v\u00e0o <strong><em>File &gt; Save as<\/em><\/strong>. Trong Excel 2007, b\u1ea5m v\u00e0o <strong><em>n\u00fat Office &gt; Save as<\/em><\/strong>.<\/li>\n<li>Trong h\u1ed9p tho\u1ea1i <strong><em>Save As<\/em><\/strong>, trong h\u1ed9p <strong><em>File name<\/em><\/strong>, nh\u1eadp t\u00ean <strong><em>template<\/em><\/strong>.<\/li>\n<li>Trong m\u1ee5c Save as, h\u00e3y <strong><em>ch\u1ecdn Excel Tamplate (* .xltx) <\/em><\/strong>n\u1ebfu b\u1ea1n \u0111ang s\u1eed d\u1ee5ng Excel 2013, 2010 ho\u1eb7c 2007.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc, ch\u1ecdn <strong><em>Excel 97-2003 Template (* .xlt)<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea3ng t\u00ednh c\u1ee7a b\u1ea1n ch\u1ee9a <strong><em>macro<\/em><\/strong>, sau \u0111\u00f3 ch\u1ecdn <strong><em>Excel Macro-Enabled Template (* .xltm).<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi b\u1ea1n ch\u1ecdn m\u1ed9t trong c\u00e1c ki\u1ec3u<strong><em> template<\/em><\/strong> \u1edf tr\u00ean, ph\u1ea7n m\u1edf r\u1ed9ng t\u1ec7p trong tr\u01b0\u1eddng <strong><em>File Name<\/em><\/strong> s\u1ebd thay \u0111\u1ed5i th\u00e0nh ph\u1ea7n m\u1edf r\u1ed9ng t\u01b0\u01a1ng \u1ee9ng.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5728\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-53.png\" width=\"600\" height=\"471\" title=\"excel-dialog-box-launcher-1-53\"><\/p>\n<p style=\"text-align: justify\"><strong>L\u01b0u \u00fd:<\/strong> L\u01b0u \u00fd r\u1eb1ng ngay khi b\u1ea1n ch\u1ecdn l\u01b0u b\u1ea3ng t\u00ednh d\u01b0\u1edbi d\u1ea1ng<strong><em> Excel Template (* .xltx)<\/em><\/strong>, th\u00ec <strong><em>Microsoft Excel<\/em><\/strong> s\u1ebd t\u1ef1 \u0111\u1ed9ng thay \u0111\u1ed5i th\u01b0 m\u1ee5c \u0111\u00edch th\u00e0nh th\u01b0 m\u1ee5c <strong><em>template<\/em><\/strong> m\u1eb7c \u0111\u1ecbnh, th\u00f4ng th\u01b0\u1eddng s\u1ebd l\u00e0:<\/p>\n<p style=\"text-align: justify\"><strong><em>C: Users&lt;User Name&gt;AppDataRoamingMicrosoftTemplates<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n l\u01b0u template v\u00e0o m\u1ed9t s\u1ed1 th\u01b0 m\u1ee5c kh\u00e1c, h\u00e3y nh\u1edb thay \u0111\u1ed5i v\u1ecb tr\u00ed sau khi ch\u1ecdn <strong><em>Excel Template (* .xltx)<\/em><\/strong> l\u00e0m lo\u1ea1i t\u00e0i li\u1ec7u. T\u1ea1i \u0111\u00f3, b\u1ea5t k\u1ec3 th\u01b0 m\u1ee5c \u0111\u00edch n\u00e0o b\u1ea1n ch\u1ecdn, m\u1ed9t b\u1ea3n sao m\u1eabu c\u1ee7a b\u1ea1n c\u0169ng s\u1ebd \u0111\u01b0\u1ee3c l\u01b0u v\u00e0o th\u01b0 m\u1ee5c m\u1eabu m\u1eb7c \u0111\u1ecbnh.<\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat <strong><em>Save<\/em><\/strong> \u0111\u1ec3 l\u01b0u template Excel m\u00e0 b\u1ea1n m\u1edbi t\u1ea1o.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd th\u00ec b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o c\u00e1c b\u1ea3ng t\u00ednh m\u1edbi d\u1ef1a tr\u00ean template n\u00e0y v\u00e0 chia s\u1ebb n\u00f3 v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c. B\u1ea1n c\u00f3 th\u1ec3 chia s\u1ebb c\u00e1c template Excel c\u1ee7a b\u1ea1n b\u1eb1ng nhi\u1ec1u c\u00e1ch, gi\u1ed1ng nh\u01b0 c\u00e1c t\u1ec7p Excel th\u00f4ng th\u01b0\u1eddng \u2013 v\u00ed d\u1ee5: L\u01b0u m\u1ed9t template trong m\u1ed9t th\u01b0 m\u1ee5c chia s\u1ebb ho\u1eb7c trong h\u1ec7 th\u1ed1ng m\u1ea1ng c\u1ee5c b\u1ed9 c\u1ee7a b\u1ea1n, l\u01b0u n\u00f3 v\u00e0o <strong><em>OneDrive (Excel Online)<\/em><\/strong> ho\u1eb7c th\u01b0 \u0111i\u1ec7n t\u1eed d\u01b0\u1edbi d\u1ea1ng t\u1ec7p \u0111\u00ednh k\u00e8m.<\/p>\n<p style=\"text-align: justify\"><strong>C\u00e1ch t\u00ecm c\u00e1c <em>template <\/em>t\u00f9y ch\u1ec9nh trong Excel 2013 v\u00e0 2010<\/strong><\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y ho\u00e0n to\u00e0n kh\u00f4ng ph\u1ea3i m\u1ed9t v\u1ea5n \u0111\u1ec1 l\u1edbn khi ch\u1ecdn b\u1ea5t k\u1ef3 m\u1eabu n\u00e0o \u0111\u00e3 s\u1eed d\u1ee5ng tr\u01b0\u1edbc \u0111\u00e2y trong Excel 2010 v\u00e0 c\u00e1c phi\u00ean b\u1ea3n c\u0169 h\u01a1n \u2013 ch\u1ec9 c\u1ea7n v\u00e0o <strong><em>tab File &gt; New<\/em><\/strong> v\u00e0 nh\u1ea5p v\u00e0o <strong><em>My templates.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5729\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-54.png\" width=\"600\" height=\"563\" title=\"excel-dialog-box-launcher-1-54\"><\/p>\n<p style=\"text-align: justify\">Kh\u00f4ng ai bi\u1ebft t\u1ea1i sao Microsoft quy\u1ebft \u0111\u1ecbnh ng\u1eebng t\u00ednh n\u0103ng n\u00e0y trong Excel 2013, nh\u01b0ng th\u1ef1c t\u1ebf l\u00e0 <strong><em>My templates<\/em><\/strong> kh\u00f4ng hi\u1ec3n th\u1ecb trong Excel 2013 theo m\u1eb7c \u0111\u1ecbnh.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Co_the_tim_Personal_Templates_cua_toi_o_Excel_2013_o_dau\"><\/span><strong>C\u00f3 th\u1ec3 t\u00ecm <em>Personal Templates <\/em>c\u1ee7a t\u00f4i \u1edf Excel 2013 \u1edf \u0111\u00e2u?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">M\u1ed9t s\u1ed1 ng\u01b0\u1eddi d\u00f9ng Excel 2013 tr\u1edf l\u00ean c\u00f3 th\u1ec3 \u0111\u00e3 \u0111\u01b0\u1ee3c t\u1eadn h\u01b0\u1edfng vi\u1ec7c nh\u00ecn th\u1ea5y b\u1ed9 s\u01b0u t\u1eadp c\u00e1c template \u0111\u01b0\u1ee3c \u0111\u1ec1 xu\u1ea5t b\u1edfi Microsoft m\u1ed7i khi h\u1ecd m\u1edf Excel. Nh\u01b0ng n\u1ebfu b\u1ea1n lu\u00f4n mu\u1ed1n m\u1eabu c\u1ee7a b\u1ea1n v\u00e0 kh\u00f4ng bao gi\u1edd mu\u1ed1n xem nh\u1eefng g\u00ec m\u00e0 Microsoft \u0111\u1ec1 ngh\u1ecb th\u00ec sao? H\u01a1n n\u1eefa, n\u1ebfu b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 template \u0111\u1eb9p trong c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3 v\u00e0 mu\u1ed1n xem l\u1ea1i ch\u00fang trong Excel sau khi n\u00e2ng c\u1ea5p l\u00ean phi\u00ean b\u1ea3n 2013?<\/p>\n<p style=\"text-align: justify\">Tin vui l\u00e0 c\u00e1c m\u1eabu b\u1ea1n t\u1ea1o ra trong c\u00e1c phi\u00ean b\u1ea3n Excel tr\u01b0\u1edbc \u0111\u00f3 v\u1eabn c\u00f2n \u1edf \u0111\u00f3. Gi\u1ed1ng nh\u01b0 c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc, Excel 2013 t\u1ef1 \u0111\u1ed9ng l\u01b0u m\u1ed9t b\u1ea3n sao c\u1ee7a m\u1ed7i m\u1eabu m\u1edbi trong th\u01b0 m\u1ee5c m\u1eabu m\u1eb7c \u0111\u1ecbnh. T\u1ea5t c\u1ea3 b\u1ea1n c\u1ea7n l\u00e0m l\u00e0 mang <strong><em>tab Personal<\/em><\/strong> tr\u1edf l\u1ea1i trong Excel 2013, nh\u01b0 sau:<\/p>\n<p style=\"text-align: justify\"><strong>Ph\u01b0\u01a1ng ph\u00e1p 1 \u2013 T\u1ea1o m\u1ed9t th\u01b0 m\u1ee5c <em>template<\/em> t\u00f9y ch\u1ec9nh<\/strong><\/p>\n<p style=\"text-align: justify\">C\u00e1ch d\u1ec5 nh\u1ea5t \u0111\u1ec3 l\u00e0m cho tab Personal xu\u1ea5t hi\u1ec7n trong Excel 2013 l\u00e0 t\u1ea1o ra m\u1ed9t th\u01b0 m\u1ee5c \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 l\u01b0u tr\u1eef c\u00e1c <strong><em>template Excel<\/em><\/strong> c\u1ee7a b\u1ea1n.<\/p>\n<ol style=\"text-align: justify\">\n<li>T\u1ea1o m\u1ed9t th\u01b0 m\u1ee5c m\u1edbi n\u01a1i b\u1ea1n mu\u1ed1n l\u01b0u c\u00e1c template c\u1ee7a b\u1ea1n. B\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o n\u00f3 \u1edf b\u1ea5t k\u1ef3 v\u1ecb tr\u00ed n\u00e0o b\u1ea1n ch\u1ecdn, v\u00ed d\u1ee5: <strong><em>C: Users&lt;User Name&gt;My Excel Templates<\/em><\/strong><\/li>\n<li>\u0110\u1eb7t th\u01b0 m\u1ee5c n\u00e0y l\u00e0m v\u1ecb tr\u00ed l\u01b0u tr\u1eef c\u00e1c template c\u00e1 nh\u00e2n m\u1eb7c \u0111\u1ecbnh c\u1ee7a b\u1ea1n. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y \u0111i\u1ec1u h\u01b0\u1edbng \u0111\u1ebfn <strong><em>tab File&gt; Options&gt; Save <\/em><\/strong>v\u00e0 nh\u1eadp \u0111\u01b0\u1eddng d\u1eabn \u0111\u1ebfn th\u01b0 m\u1ee5c <strong><em>template<\/em><\/strong> trong khung v\u1ecb tr\u00ed l\u01b0u tr\u1eef template c\u00e1 nh\u00e2n m\u1eb7c \u0111\u1ecbnh:<\/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-templates-folder.png\" alt=\"Setting up the Default personal templates location\" title=\"excel-templates-folder\"><\/p>\n<ol style=\"text-align: justify\" start=\"3\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat OK v\u00e0 b\u1ea1n \u0111\u00e3 ho\u00e0n t\u1ea5t. T\u1eeb gi\u1edd tr\u1edf \u0111i, t\u1ea5t c\u1ea3 c\u00e1c template t\u00f9y ch\u1ec9nh b\u1ea1n l\u01b0u v\u00e0o th\u01b0 m\u1ee5c n\u00e0y s\u1ebd t\u1ef1 \u0111\u1ed9ng xu\u1ea5t hi\u1ec7n d\u01b0\u1edbi <strong><em>tab Personal <\/em><\/strong>tr\u00ean trang <strong><em>New (File &gt; New).<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y, \u0111\u00e2y l\u00e0 m\u1ed9t c\u00e1ch l\u00e0m r\u1ea5t nhanh v\u00e0 d\u1ec5 th\u1ef1c hi\u1ec7n. Tuy nhi\u00ean, n\u00f3 c\u00f3 m\u1ed9t gi\u1edbi h\u1ea1n r\u1ea5t \u0111\u00e1ng k\u1ec3 \u2013 m\u1ed7i khi b\u1ea1n l\u00e0m m\u1ed9t template trong Excel, b\u1ea1n ph\u1ea3i nh\u1edb \u0111\u1ec3 l\u01b0u n\u00f3 v\u00e0o th\u01b0 m\u1ee5c c\u1ee5 th\u1ec3 n\u00e0y. V\u00e0 \u0111\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao t\u00f4i th\u00edch c\u00e1ch th\u1ee9 hai h\u01a1n \ud83d\ude42<\/p>\n<p style=\"text-align: justify\"><strong>Ph\u01b0\u01a1ng ph\u00e1p 2 \u2013 T\u00ecm th\u01b0 m\u1ee5c m\u1eabu m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel<\/strong><\/p>\n<p style=\"text-align: justify\">Thay v\u00ec t\u1ea1o m\u1ed9t th\u01b0 m\u1ee5c t\u00f9y ch\u1ec9nh \u0111\u1ec3 l\u01b0u c\u00e1c template Excel c\u00e1 nh\u00e2n c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm ki\u1ebfm c\u00e1c <strong><em>template<\/em><\/strong> m\u00e0 Microsoft Excel l\u01b0u m\u1ed9t c\u00e1ch t\u1ef1 \u0111\u1ed9ng v\u00e0 \u0111\u1eb7t n\u00f3 l\u00e0m <strong><em>Default personal templates location<\/em><\/strong> (v\u1ecb tr\u00ed template c\u00e1 nh\u00e2n m\u1eb7c \u0111\u1ecbnh). Khi b\u1ea1n th\u1ef1c hi\u1ec7n vi\u1ec7c n\u00e0y, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c template \u0111\u01b0\u1ee3c t\u1ea1o m\u1edbi v\u00e0 \u0111\u00e3 t\u1ea3i xu\u1ed1ng c\u0169ng nh\u01b0 nh\u1eefng template b\u1ea1n \u0111\u00e3 t\u1ea1o tr\u01b0\u1edbc \u0111\u00f3 tr\u00ean tab Personal.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong><em>Trong Windows Explorer, v\u00e0o <\/em><\/strong><strong><em>C:Users&lt;User Name&gt;AppDataRoamingMicrosoftTemplates<\/em><\/strong>. Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o thanh \u0111\u1ecba ch\u1ec9 (<strong><em>address<\/em><\/strong>), sau \u0111\u00f3 nh\u1ea5p <strong><em>Copy address as text<\/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\/excel-templates-folder-path.png\" alt=\"Find the path to the default folder where Excel templates are stored.\" title=\"excel-templates-folder-path\"><\/p>\n<p style=\"text-align: justify\">M\u1eb9o nh\u1ecf: N\u1ebfu b\u1ea1n g\u1eb7p kh\u00f3 kh\u0103n trong vi\u1ec7c \u0111\u1ecbnh v\u1ecb th\u01b0 m\u1ee5c n\u00e0y, h\u00e3y nh\u1ea5p v\u00e0o <strong><em>Start <\/em><\/strong>v\u00e0 nh\u1eadp (ho\u1eb7c th\u1eadm ch\u00ed t\u1ed1t h\u01a1n l\u00e0 sao ch\u00e9p\/ d\u00e1n) l\u1ec7nh sau trong h\u1ed9p t\u00ecm ki\u1ebfm:<\/p>\n<p style=\"text-align: justify\"><strong><em>%appdata%MicrosoftTemplates<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Th\u01b0 m\u1ee5c Template s\u1ebd xu\u1ea5t hi\u1ec7n trong k\u1ebft qu\u1ea3 t\u00ecm ki\u1ebfm, v\u00ec v\u1eady b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o n\u00f3 v\u00e0 sao ch\u00e9p \u0111\u01b0\u1eddng d\u1eabn nh\u01b0 \u0111\u00e3 gi\u1ea3i th\u00edch \u1edf tr\u00ean.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li>Trong Microsoft Excel, v\u00e0o <strong><em>File&gt; Options&gt; Save <\/em><\/strong>v\u00e0 d\u00e1n \u0111\u01b0\u1eddng d\u1eabn \u0111\u00e3 sao ch\u00e9p v\u00e0o h\u1ed9p <strong><em>Defalt Personal templates<\/em><\/strong> <strong><em>Location <\/em><\/strong>m\u1eb7c \u0111\u1ecbnh, \u0111\u00fang nh\u01b0 ch\u00fang ta \u0111\u00e3 l\u00e0m trong b\u01b0\u1edbc 2 c\u1ee7a Ph\u01b0\u01a1ng ph\u00e1p 1.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea5t c\u1ee9 khi n\u00e0o b\u1ea1n nh\u1ea5p v\u00e0o <strong><em>File &gt; New<\/em><\/strong> trong Excel 2013, s\u1ebd th\u1ea5y <strong><em>tab Personal<\/em><\/strong> \u1edf \u0111\u00f3 v\u00e0 c\u00e1c template Excel t\u00f9y ch\u1ec9nh c\u1ee7a b\u1ea1n c\u00f3 s\u1eb5n \u0111\u1ec3 s\u1eed d\u1ee5ng.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/personal-templates-excel2013.png\" alt=\"The Personal tab with custom templates in Excel 2013\" title=\"personal-templates-excel2013\"><\/p>\n<p style=\"text-align: justify\"><strong>Ph\u01b0\u01a1ng ph\u00e1p 3 \u2013 h\u00e3y \u0111\u1ec3 Microsoft kh\u1eafc ph\u1ee5c \u0111i\u1ec1u n\u00e0y cho b\u1ea1n<\/strong><\/p>\n<p style=\"text-align: justify\">D\u01b0\u1eddng nh\u01b0 Microsoft \u0111\u00e3 nh\u1eadn \u0111\u01b0\u1ee3c qu\u00e1 nhi\u1ec1u than phi\u1ec1n v\u1ec1 s\u1ef1 bi\u1ebfn m\u1ea5t b\u00ed \u1ea9n c\u1ee7a c\u00e1c template c\u00e1 nh\u00e2n trong Excel 2013, r\u1eb1ng h\u1ecd \u0111\u00e3 t\u1ea1o ra m\u1ed9t b\u1ea3n s\u1eeda l\u1ed7i. B\u1ea3n s\u1eeda l\u1ed7i \u0111\u00e3 t\u1ef1 \u0111\u1ed9ng \u00e1p d\u1ee5ng gi\u1ea3i ph\u00e1p \u0111\u01b0\u1ee3c m\u00f4 t\u1ea3 trong Ph\u01b0\u01a1ng ph\u00e1p 2, v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea3i xu\u1ed1ng <a href=\"https:\/\/support.office.com\/en-in\/article\/Where-are-my-custom-templates-88ed77ca-df34-49e9-9087-3f01ae296e6e\">t\u1ea1i \u0111\u00e2y<\/a>.<\/p>\n<p style=\"text-align: justify\">\u01afu th\u1ebf ch\u00ednh c\u1ee7a c\u00e1ch n\u00e0y l\u00e0 n\u00f3 ho\u1ea1t \u0111\u1ed9ng cho t\u1ea5t c\u1ea3 c\u00e1c \u1ee9ng d\u1ee5ng <strong><em>Office 2013<\/em><\/strong>, kh\u00f4ng ch\u1ec9 ri\u00eang Excel, c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ch\u1ec9 \u0111\u1ecbnh v\u1ecb tr\u00ed template m\u1eb7c \u0111\u1ecbnh trong m\u1ed7i ch\u01b0\u01a1ng tr\u00ecnh ri\u00eang l\u1ebb.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Lam_the_nao_de_tao_mot_template_mac_dinh_cho_Excel\"><\/span><strong>L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o m\u1ed9t template m\u1eb7c \u0111\u1ecbnh cho Excel<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">N\u1ebfu trong s\u1ed1 c\u00e1c template c\u1ee7a Microsoft Excel c\u1ee7a b\u1ea1n c\u00f3 m\u1ed9t m\u1eabu m\u00e0 b\u1ea1n s\u1eed d\u1ee5ng th\u01b0\u1eddng xuy\u00ean nh\u1ea5t, b\u1ea1n c\u00f3 th\u1ec3 mu\u1ed1n \u0111\u1eb7t n\u00f3 l\u00e0m template m\u1eb7c \u0111\u1ecbnh v\u00e0 t\u1ef1 \u0111\u1ed9ng m\u1edf ra khi b\u1eaft \u0111\u1ea7u Excel.<\/p>\n<p style=\"text-align: justify\">Microsoft Excel cho ph\u00e9p t\u1ea1o ra hai ki\u1ec3u <strong><em>template<\/em><\/strong> \u0111\u1eb7c bi\u1ec7t \u2013 <strong><em>Book.xltx v\u00e0 Sheet.xltx<\/em><\/strong> \u2013 \u0111\u00f3 l\u00e0 c\u01a1 s\u1edf cho t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh m\u1edbi v\u00e0 t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh m\u1edbi, t\u01b0\u01a1ng \u1ee9ng. V\u00ec v\u1eady, \u0111i\u1ec3m m\u1ea5u ch\u1ed1t l\u00e0 quy\u1ebft \u0111\u1ecbnh ki\u1ec3u template m\u00e0 b\u1ea1n mu\u1ed1n:<\/p>\n<ul style=\"text-align: justify\">\n<li><strong>Template b\u1ea3ng t\u00ednh Excel<\/strong>: Lo\u1ea1i template n\u00e0y bao g\u1ed3m nhi\u1ec1u trang. V\u00ec v\u1eady, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t b\u1ea3ng t\u00ednh c\u00f3 ch\u1ee9a c\u00e1c trang b\u1ea1n mu\u1ed1n, nh\u1eadp v\u00e0o v\u1ecb tr\u00ed b\u1ea1n mu\u1ed1n ch\u00e8n v\u00e0 c\u00e1c m\u1ee5c m\u1eb7c \u0111\u1ecbnh (v\u00ed d\u1ee5 ti\u00eau \u0111\u1ec1 trang, nh\u00e3n c\u1ed9t v\u00e0 h\u00e0ng, v.v \u2026), th\u00eam c\u00f4ng th\u1ee9c ho\u1eb7c macro, \u00e1p d\u1ee5ng c\u00e1c ki\u1ec3u v\u00e0 \u0111\u1ecbnh d\u1ea1ng kh\u00e1c m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng.<\/li>\n<li><strong>Template trang t\u00ednh Excel<\/strong>: Ki\u1ec3u template n\u00e0y gi\u1ea3 \u0111\u1ecbnh r\u1eb1ng ch\u1ec9 c\u00f3 m\u1ed9t trang. V\u00ec v\u1eady, h\u00e3y x\u00f3a 2 c\u1ee7a m\u1eb7c \u0111\u1ecbnh 3 trang trong m\u1ed9t b\u1ea3ng t\u00ednh v\u00e0 sau \u0111\u00f3 t\u00f9y ch\u1ec9nh t\u1edd c\u00f2n l\u1ea1i theo \u00fd th\u00edch c\u1ee7a b\u1ea1n. \u00c1p d\u1ee5ng c\u00e1c ki\u1ec3u v\u00e0 \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n v\u00e0 nh\u1eadp th\u00f4ng tin b\u1ea1n mu\u1ed1n xu\u1ea5t hi\u1ec7n tr\u00ean t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh m\u1edbi d\u1ef1a tr\u00ean template n\u00e0y.<\/li>\n<\/ul>\n<p style=\"text-align: justify\">Khi b\u1ea1n \u0111\u00e3 quy\u1ebft \u0111\u1ecbnh lo\u1ea1i template m\u1eb7c \u0111\u1ecbnh c\u1ee7a m\u00ecnh, h\u00e3y th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau.<\/p>\n<ol style=\"text-align: justify\">\n<li>Trong b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n chuy\u1ec3nth\u00e0nh template m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel, h\u00e3y nh\u1ea5p v\u00e0o <strong><em>File&gt; Save as<\/em><\/strong><\/li>\n<li>Trong h\u1ed9p <strong><em>Save as type<\/em><\/strong>, ch\u1ecdn <strong><em>Excel Template (* .xltx)<\/em><\/strong> t\u1eeb danh s\u00e1ch th\u1ea3 xu\u1ed1ng.<\/li>\n<li>Trong khung Save in, ch\u1ecdn th\u01b0 m\u1ee5c \u0111\u00edch cho template tr\u00ean. \u0110i\u1ec1u n\u00e0y y\u00eau c\u1ea7u ph\u1ea3i l\u00e0 th\u01b0 m\u1ee5c XLStart, v\u00ec kh\u00f4ng c\u00f3 lo\u1ea1i th\u01b0 m\u1ee5c n\u00e0o s\u1ebd l\u00e0m \u0111\u01b0\u1ee3c.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong Vista, Windows 7 v\u00e0 Windows 8, th\u01b0 m\u1ee5c <strong>XLStart<\/strong> th\u01b0\u1eddng n\u1eb1m trong:<\/p>\n<p style=\"text-align: justify\"><strong>C:Users&lt;User name&gt;AppDataLocalMicrosoftExcelXLStart<\/strong><\/p>\n<p style=\"text-align: justify\">Trong Windows XP, n\u00f3 th\u01b0\u1eddng n\u1eb1m trong:<\/p>\n<p style=\"text-align: justify\"><strong>C:Documents and Settings&lt;User name&gt;Application DataMicrosoftExcelXLStart<\/strong><\/p>\n<ol style=\"text-align: justify\" start=\"4\">\n<li>Cu\u1ed1i c\u00f9ng l\u00e0 \u0111\u1eb7t \u0111\u00fang t\u00ean cho <strong>template<\/strong> tr\u00ean:<\/li>\n<\/ol>\n<ul style=\"text-align: justify\">\n<li>N\u1ebfu b\u1ea1n \u0111ang t\u1ea1o m\u1eabu b\u1ea3ng t\u00ednh, h\u00e3y nh\u1eadp <strong>Book<\/strong> trong <strong>File name<\/strong><\/li>\n<li>N\u1ebfu b\u1ea1n \u0111ang t\u1ea1o m\u1eabu trang t\u00ednh, h\u00e3y nh\u1eadp <strong>Sheet<\/strong> trong <strong>File name<\/strong><\/li>\n<\/ul>\n<p style=\"text-align: justify\">H\u00ecnh sau \u0111\u00e2y th\u1ec3 hi\u1ec7n vi\u1ec7c t\u1ea1o ra <strong>template<\/strong> b\u1ea3ng t\u00ednh m\u1eb7c \u0111\u1ecbnh:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5731\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-56.png\" width=\"600\" height=\"463\" title=\"excel-dialog-box-launcher-1-56\"><\/p>\n<ol style=\"text-align: justify\" start=\"5\">\n<li>Nh\u1ea5p v\u00e0o n\u00fat <strong>Save<\/strong> \u0111\u1ec3 k\u1ebft th\u00fac qu\u00e1 tr\u00ecnh v\u00e0 \u0111\u00f3ng c\u1eeda s\u1ed5.<\/li>\n<\/ol>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, b\u1ea1n c\u00f3 th\u1ec3 kh\u1edfi \u0111\u1ed9ng l\u1ea1i Excel v\u00e0 xem n\u00f3 c\u00f3 t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi d\u1ef1a tr\u00ean <strong>template<\/strong> m\u1eb7c \u0111\u1ecbnh m\u00e0 b\u1ea1n \u0111\u00e3 thi\u1ebft l\u1eadp hay kh\u00f4ng.<\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o: L\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 nhanh ch\u00f3ng t\u00ecm th\u1ea5y th\u01b0 m\u1ee5c XLStart tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n<\/strong><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng ch\u1eafc v\u1ecb tr\u00ed ch\u00ednh x\u00e1c th\u01b0 m\u1ee5c <strong>XLStart<\/strong> n\u1eb1m tr\u00ean m\u00e1y t\u00ednh c\u1ee7a m\u00ecnh, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y n\u00f3 b\u1eb1ng hai c\u00e1ch.<\/p>\n<ol style=\"text-align: justify\">\n<li><strong>Trusted Location:<\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">Trong <strong>Microsoft Excel<\/strong>, chuy\u1ec3n \u0111\u1ebfn <strong>File&gt; Options<\/strong>, sau \u0111\u00f3 nh\u1ea5p v\u00e0o <strong>Trust Center&gt; Trust Center Settings<\/strong>:<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trust-center-settings.png\" alt=\"Go to Excel's Trust Center Settings\" title=\"trust-center-settings\"><\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o <strong>Trusted Locations<\/strong>, t\u00ecm th\u01b0 m\u1ee5c <strong>XLStart<\/strong> trong danh s\u00e1ch v\u00e0 nh\u1ea5p v\u00e0o n\u00f3. \u0110\u01b0\u1eddng d\u1eabn \u0111\u1ea7y \u0111\u1ee7 \u0111\u1ebfn th\u01b0 m\u1ee5c s\u1ebd hi\u1ec3n th\u1ecb b\u00ean d\u01b0\u1edbi danh s\u00e1ch \u0111\u1ecba \u0111i\u1ec3m \u0111\u00e1ng tin c\u1eady.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/trusted-locations.png\" alt=\"Getting the full path to the XLStart folder\" title=\"trusted-locations\"><\/p>\n<p style=\"text-align: justify\">Xin l\u01b0u \u00fd r\u1eb1ng danh s\u00e1ch v\u1ecb tr\u00ed \u0111\u00e1ng tin c\u1eady th\u1ef1c s\u1ef1 ch\u1ee9a hai th\u01b0 m\u1ee5c <strong><em>XLStart:<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Th\u01b0 m\u1ee5c c\u00e1 nh\u00e2n: S\u1eed d\u1ee5ng th\u01b0 m\u1ee5c n\u00e0y n\u1ebfu b\u1ea1n mu\u1ed1n l\u00e0m template m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel cho t\u00e0i kho\u1ea3n ng\u01b0\u1eddi d\u00f9ng c\u1ee7a b\u1ea1n. V\u1ecb tr\u00ed th\u00f4ng th\u01b0\u1eddng c\u1ee7a th\u01b0 m\u1ee5c XLStart c\u00e1 nh\u00e2n l\u00e0:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>C: Users&lt;T\u00ean ng\u01b0\u1eddi d\u00f9ng&gt;AppDataRoamingMicrosoftExcelXLStart<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Th\u01b0 m\u1ee5c c\u1ee7a M\u00e1y t\u00ednh: L\u01b0u c\u00e1c template c\u00f3 .xltx ho\u1eb7c Sheet.xltx v\u00e0o th\u01b0 m\u1ee5c n\u00e0y s\u1ebd l\u00e0m cho template m\u1eb7c \u0111\u1ecbnh c\u1ee7a Excel c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng cho t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng c\u1ee7a m\u1ed9t m\u00e1y t\u00ednh nh\u1ea5t \u0111\u1ecbnh. Khi l\u01b0u m\u1ed9t template v\u00e0o th\u01b0 m\u1ee5c n\u00e0y s\u1ebd c\u1ea7n y\u00eau c\u1ea7u quy\u1ec1n qu\u1ea3n tr\u1ecb. Th\u01b0 m\u1ee5c XLStart c\u1ee7a m\u00e1y th\u01b0\u1eddng n\u1eb1m \u1edf \u0111\u00e2y:<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><strong><em>C: Program FilesMicrosoft Office&lt;V\u0102N PH\u00d2NG V\u0102N PH\u00d2NG&gt;XLSTART<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">Khi sao ch\u00e9p \u0111\u01b0\u1eddng d\u1eabn c\u1ee7a th\u01b0 m\u1ee5c XLStart, vui l\u00f2ng ki\u1ec3m tra l\u1ea1i xem b\u1ea1n \u0111\u00e3 ch\u1ecdn \u0111\u01b0\u1ee3c \u0111\u00fang \u0111\u01b0\u1eddng d\u1eabn c\u1ee7a th\u01b0 m\u1ee5c XLStart hay kh\u00f4ng.<\/p>\n<ol style=\"text-align: justify\" start=\"2\">\n<li><strong><em> Visual Basic Editor:<\/em><\/strong><\/li>\n<\/ol>\n<p style=\"text-align: justify\">M\u1ed9t c\u00e1ch kh\u00e1c \u0111\u1ec3 ph\u00e1t hi\u1ec7n th\u01b0 m\u1ee5c <strong><em>XLStart<\/em><\/strong> l\u00e0 s\u1eed d\u1ee5ng c\u1eeda s\u1ed5 <strong><em>Immediate <\/em><\/strong>trong <strong><em>Visual Basic Editor:<\/em><\/strong><\/p>\n<ul style=\"text-align: justify\">\n<li>Trong Microsoft Excel, nh\u1ea5n <strong><em>Alt + F11 <\/em><\/strong>\u0111\u1ec3 kh\u1edfi \u0111\u1ed9ng <strong><em>Visual Basic Editor.<\/em><\/strong><\/li>\n<li>N\u1ebfu c\u1eeda s\u1ed5 <strong><em>Immediate <\/em><\/strong>kh\u00f4ng hi\u1ec3n th\u1ecb, nh\u1ea5n Ctrl + G.<\/li>\n<li>Khi c\u1eeda s\u1ed5 <strong><em>Immediate<\/em><\/strong> xu\u1ea5t hi\u1ec7n, g\u00f5 ? <strong><em>StartupPath<\/em><\/strong> r\u1ed3inh\u1ea5n <strong><em>Enter<\/em><\/strong> v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y \u0111\u01b0\u1eddng d\u1eabn ch\u00ednh x\u00e1c \u0111\u1ebfn th\u01b0 m\u1ee5c <strong><em>XLStart<\/em><\/strong> tr\u00ean m\u00e1y c\u1ee7a b\u1ea1n.<\/li>\n<\/ul>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/xlstart-folder-path.png\" alt=\"Finding the XLStart folder by using the Immediate window in the Visual Basic Editor\" title=\"xlstart-folder-path\"><\/p>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n th\u1ea5y trong h\u00ecnh \u1edf tr\u00ean, ph\u01b0\u01a1ng ph\u00e1p n\u00e0y lu\u00f4n tr\u1ea3 v\u1ec1 v\u1ecb tr\u00ed c\u1ee7a th\u01b0 m\u1ee5c c\u00e1 nh\u00e2n XLSTART.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"Tai_template_Excel_o_dau\"><\/span><strong>T\u1ea3i template Excel \u1edf \u0111\u00e2u?<\/strong><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Nh\u01b0 b\u1ea1n \u0111\u00e3 bi\u1ebft, n\u01a1i t\u1ed1t nh\u1ea5t \u0111\u1ec3 t\u00ecm template Excel l\u00e0 <strong><em>Office.com<\/em><\/strong>. T\u1ea1i \u0111\u00e2y b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm th\u1ea5y r\u1ea5t nhi\u1ec1u m\u1eabu Excel mi\u1ec5n ph\u00ed \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo c\u00e1c danh m\u1ee5c kh\u00e1c nhau nh\u01b0 c\u00e1c template l\u1ecbch, template ng\u00e2n s\u00e1ch, h\u00f3a \u0111\u01a1n, th\u1eddi h\u1ea1n, template ki\u1ec3m k\u00ea, template qu\u1ea3n l\u00fd d\u1ef1 \u00e1n v\u00e0 nhi\u1ec1u h\u01a1n n\u1eefa.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean th\u1ef1c t\u1ebf, \u0111\u00e2y l\u00e0 c\u00e1c <strong><em>template<\/em><\/strong> gi\u1ed1ng nh\u01b0 b\u1ea1n th\u1ea5y trong Excel khi nh\u1ea5p v\u00e0o <strong><em>File&gt; New<\/em><\/strong>. Tuy nhi\u00ean, t\u00ecm ki\u1ebfm tr\u00ean trang <strong><em>web<\/em><\/strong> c\u00f3 th\u1ec3 hi\u1ec7u qu\u1ea3 h\u01a1n, \u0111\u1eb7c bi\u1ec7t l\u00e0 khi b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm c\u00e1i g\u00ec c\u1ee5 th\u1ec3.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-5732\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/excel-dialog-box-launcher-1-57.png\" width=\"600\" height=\"568\" title=\"excel-dialog-box-launcher-1-57\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea3i xu\u1ed1ng <strong><em>m\u1ed9t template Excel<\/em><\/strong> c\u1ee5 th\u1ec3, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o n\u00f3. Thao t\u00e1c n\u00e0y s\u1ebd hi\u1ec3n th\u1ecb m\u00f4 t\u1ea3 ng\u1eafn g\u1ecdn v\u1ec1 template c\u0169ng nh\u01b0 n\u00fat <strong><em>Open<\/em><\/strong> trong <strong><em>Excel online<\/em><\/strong>. V\u00e0 vi\u1ec7c nh\u1ea5p v\u00e0o n\u00fat n\u00e0y s\u1ebd t\u1ea1o m\u1ed9t b\u1ea3ng t\u00ednh d\u1ef1a tr\u00ean template \u0111\u00e3 ch\u1ecdn trong <strong><em>Excel Online<\/em><\/strong>.<\/p>\n<p style=\"text-align: justify\"><img decoding=\"async\" class=\"aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/template-excel-online.png\" alt=\"Opening a template in Excel Online\" title=\"template-excel-online\"><\/p>\n<p style=\"text-align: justify\">\u0110\u1ec3 t\u1ea3i template xu\u1ed1ng Excel cho m\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n c\u1ee7a b\u1ea1n, h\u00e3y nh\u1ea5p v\u00e0o <strong>File &gt; Save as &gt; Download a copy<\/strong>. Thao t\u00e1c n\u00e0y s\u1ebd m\u1edf c\u1eeda s\u1ed5 h\u1ed9p tho\u1ea1i quen thu\u1ed9c c\u1ee7a <strong><em>Windows \u2013 Save as \u2013<\/em><\/strong> n\u01a1i m\u00e0 b\u1ea1n sau \u0111\u00f3 s\u1ebd ch\u1ecdn th\u01b0 m\u1ee5c \u0111\u00edch v\u00e0 nh\u1ea5p v\u00e0o <strong><em>n\u00fat Save.<\/em><\/strong><\/p>\n<p style=\"text-align: justify\">L\u01b0u \u00fd: T\u1ec7p \u0111\u00e3 t\u1ea3i xu\u1ed1ng l\u00e0 m\u1ed9t b\u1ea3ng t\u00ednh Excel th\u00f4ng th\u01b0\u1eddng (.xlsx). N\u1ebfu b\u1ea1n mu\u1ed1n c\u00f3 m\u1ed9t template cho Excel, h\u00e3y m\u1edf b\u1ea3ng t\u00ednh v\u00e0 l\u01b0u l\u1ea1i n\u00f3 d\u01b0\u1edbi d\u1ea1ng <strong><em>Excel Template (* .xltx).<\/em><\/strong><\/p>\n<p style=\"text-align: justify\"><em><strong>Ngu\u1ed3n:<\/strong> Ablebits, d\u1ecbch v\u00e0 bi\u00ean t\u1eadp b\u1edfi Hocexcel Online.<\/em><\/p>\n<p style=\"text-align: justify\">C\u1ea3m \u01a1n b\u1ea1n \u0111\u00e3 quan t\u00e2m v\u00e0 theo d\u00f5i c\u00e1c b\u00e0i vi\u1ebft c\u1ee7a H\u1ecdc Excel Online!<\/p>\n<p style=\"text-align: justify\">Excel r\u1ea5t r\u1ed9ng l\u1edbn v\u00e0 c\u00f2n v\u00f4 v\u00e0n \u0111i\u1ec1u b\u1ea1n s\u1ebd mu\u1ed1n vi\u1ebft \u0111\u1ec3 \u0111\u1ea1t hi\u1ec7u qu\u1ea3 l\u00e0m vi\u1ec7c cao h\u01a1n. Tuy nhi\u00ean, n\u1ebfu kh\u00f4ng \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp v\u00e0 h\u1ec7 th\u1ed1ng c\u00e1c ki\u1ebfn th\u1ee9c logic, \u0111\u1ea7y \u0111\u1ee7 th\u00ec r\u1ea5t kh\u00f3 \u0111\u1ec3 b\u1ea1n h\u1ecdc \u0111\u01b0\u1ee3c Excel.\u00a0To\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=\"http:\/\/bit.ly\/2w6YAe8\">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\" target=\"_blank\">HocExcel.Online<\/a><\/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\/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-300.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":7478,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[3],"tags":[],"class_list":["post-7477","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\/7477","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=7477"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/7477\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/7478"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=7477"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=7477"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=7477"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}