{"id":9485,"date":"2025-01-02T08:16:16","date_gmt":"2025-01-02T08:16:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-1\/"},"modified":"2025-01-02T08:16:16","modified_gmt":"2025-01-02T08:16:16","slug":"tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-1","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/02\/tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-1\/","title":{"rendered":"T\u1ed5ng h\u1ee3p nhanh nh\u1eefng k\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 Ph\u1ea7n 1"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong b\u00e0i vi\u1ebft n\u00e0y, H\u1ecdc Excel Online s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n nh\u1eefng k\u0129 n\u0103ng c\u1ea7n thi\u1ebft\u00a0cho b\u00e0i thi MOS Excel m\u1ed9t c\u00e1ch t\u1ed1t nh\u1ea5t. Nh\u1eefng k\u0129 n\u0103ng n\u00e0y s\u1ebd d\u1ef1a tr\u00ean y\u00eau c\u1ea7u c\u1ee7a Microsoft \u0111\u1ed1i v\u1edbi phi\u00ean b\u1ea3n <strong>Specialist\u00a02013<\/strong> , tuy nhi\u00ean b\u1ea1n c\u0169ng c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng t\u01b0\u01a1ng t\u1ef1 \u0111\u1ed1i v\u1edbi c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c.<\/p>\n<p>\u0110\u1ec3 xem c\u00e1c y\u00eau c\u1ea7u c\u1ee7a Microsoft b\u1ea1n tham kh\u1ea3o link sau:<\/p>\n<p><a href=\"https:\/\/www.microsoft.com\/en-us\/learning\/exam-77-420.aspx\">Y\u00eau c\u1ea7u v\u1ec1 k\u0129 n\u0103ng b\u00e0i thi MOS Specialist 2013\u00a0<\/a><\/p>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u series b\u00e0i vi\u1ebft, ta s\u1ebd \u0111\u1ebfn v\u1edbi\u00a0y\u00eau c\u1ea7u\u00a0\u0111\u1ea7u ti\u00ean:<\/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-67764b4fabb8d\" 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-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Tao_lap_quan_ly_so_tinh_va_trang_tinh\" title=\"T\u1ea1o l\u1eadp, qu\u1ea3n l\u00fd s\u1ed5 t\u00ednh v\u00e0 trang t\u00ednh\">T\u1ea1o l\u1eadp, qu\u1ea3n l\u00fd s\u1ed5 t\u00ednh v\u00e0 trang t\u00ednh<\/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-2\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Ki_nang_tao_lap_so_tinhtrang_tinh\" title=\"K\u0129 n\u0103ng t\u1ea1o l\u1eadp s\u1ed5 t\u00ednh\/trang t\u00ednh\">K\u0129 n\u0103ng t\u1ea1o l\u1eadp s\u1ed5 t\u00ednh\/trang t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Dinh_vi_trang_tinh_so_tinh\" title=\"\u0110\u1ecbnh v\u1ecb trang t\u00ednh, s\u1ed5 t\u00ednh\">\u0110\u1ecbnh v\u1ecb trang t\u00ednh, s\u1ed5 t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Dinh_dang_trang_tinh_so_tinh\" title=\"\u0110\u1ecbnh d\u1ea1ng trang t\u00ednh, s\u1ed5 t\u00ednh\">\u0110\u1ecbnh d\u1ea1ng trang t\u00ednh, s\u1ed5 t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Tuy_chinh_thong_so_va_cac_che_do_cho_trang_tinhso_tinh\" title=\"T\u00f9y ch\u1ec9nh th\u00f4ng s\u1ed1 v\u00e0 c\u00e1c ch\u1ebf \u0111\u1ed9 cho trang t\u00ednh\/s\u1ed5 t\u00ednh\">T\u00f9y ch\u1ec9nh th\u00f4ng s\u1ed1 v\u00e0 c\u00e1c ch\u1ebf \u0111\u1ed9 cho trang t\u00ednh\/s\u1ed5 t\u00ednh<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-4\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html#Thiet_lap_trang_tinh_cho_muc_dich_in_an\" title=\"Thi\u1ebft l\u1eadp trang t\u00ednh cho m\u1ee5c \u0111\u00edch in \u1ea5n\">Thi\u1ebft l\u1eadp trang t\u00ednh cho m\u1ee5c \u0111\u00edch in \u1ea5n<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Tao_lap_quan_ly_so_tinh_va_trang_tinh\"><\/span>T\u1ea1o l\u1eadp, qu\u1ea3n l\u00fd s\u1ed5 t\u00ednh v\u00e0 trang t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi\u00a0y\u00eau c\u1ea7u\u00a0n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i thu\u1ea7n th\u1ee5c nh\u1eefng k\u0129 n\u0103ng trong h\u00ecnh sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24234\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-1.png\" width=\"801\" height=\"509\" title=\"tong-hop-mos-1-1\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Ki_nang_tao_lap_so_tinhtrang_tinh\"><\/span>K\u0129 n\u0103ng t\u1ea1o l\u1eadp s\u1ed5 t\u00ednh\/trang t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi k\u0129 n\u0103ng n\u00e0y b\u1ea1n c\u1ea7n ph\u1ea3i:<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-60.gif\" title=\"ex101_92019-nho-60\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>1. Bi\u1ebft c\u00e1ch t\u1ea1o m\u1ed9t s\u1ed5 t\u00ednh m\u1edbi ho\u1eb7c t\u1eeb templates c\u00f3 s\u1eb5n<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24235\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-2-1024x608-1.png\" width=\"1024\" height=\"608\" title=\"tong-hop-mos-1-2-1024x608-1\"><\/p>\n<p>\u0110\u1ec3 t\u1ea1o m\u1ed9t s\u1ed5 t\u00ednh m\u1edbi bao g\u1ed3m c\u00e1c trang t\u00ednh, ta v\u00e0o th\u1ebb File, ch\u1ecdn New, sau \u0111\u00f3 ch\u1ecdn ki\u1ec3u s\u1ed5 t\u00ednh c\u1ea7n thi\u1ebft.<\/p>\n<p>\u00a0<\/p>\n<p>2. M\u1edf file trong Excel<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24238\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-3-1024x648-1.png\" width=\"1024\" height=\"648\" title=\"tong-hop-mos-1-3-1024x648-1\"><\/p>\n<p>\u0110\u1ec3 m\u1edf file c\u00f3 t\u1eeb tr\u01b0\u1edbc, ta v\u00e0o File, ch\u1ecdn Open. Trong \u0111\u00f3 ta c\u00f3 c\u00e1c t\u00f9y ch\u1ecdn nh\u01b0 m\u1edf file t\u1eeb ngu\u1ed3n tr\u00ean m\u1ea1ng, t\u1eeb m\u00e1y t\u00ednh, m\u1edf c\u00e1c file g\u1ea7n \u0111\u00e2y\u2026<\/p>\n<p>\u00a0<\/p>\n<p>3. Th\u00eam, x\u00f3a, copy trang t\u00ednh<\/p>\n<p>\u0110\u1ec3 l\u00e0m nh\u1eefng thao t\u00e1c li\u00ean quan t\u1edbi trang t\u00ednh, ta ch\u00fa \u00fd t\u1edbi c\u00e1c ch\u1ee9c n\u0103ng \u1edf nh\u00f3m Cells thu\u00f4c th\u1ebb\u00a0<strong>Home<\/strong>, v\u00e0 c\u00e1c thao t\u00e1c qua click chu\u1ed9t ph\u1ea3i trang t\u00ednh:<\/p>\n<figure id=\"attachment_24241\" aria-describedby=\"caption-attachment-24241\" style=\"width: 458px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24241\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-4.png\" width=\"458\" height=\"263\" title=\"tong-hop-mos-1-4\"><figcaption id=\"caption-attachment-24241\" class=\"wp-caption-text\">Nh\u00f3m Cells, th\u1ebb Home<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<figure id=\"attachment_24242\" aria-describedby=\"caption-attachment-24242\" style=\"width: 282px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24242\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-5.png\" width=\"282\" height=\"322\" title=\"tong-hop-mos-1-5\"><figcaption id=\"caption-attachment-24242\" class=\"wp-caption-text\">Chu\u1ed9t ph\u1ea3i<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_vi_trang_tinh_so_tinh\"><\/span>\u0110\u1ecbnh v\u1ecb trang t\u00ednh, s\u1ed5 t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1ea1i \u0111\u00e2y b\u1ea1n c\u1ea7n bi\u1ebft:<\/p>\n<p>1. T\u00ecm ki\u1ebfm d\u1eef li\u1ec7u trong trang t\u00ednh<\/p>\n<figure id=\"attachment_24245\" aria-describedby=\"caption-attachment-24245\" style=\"width: 314px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24245\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-6.png\" width=\"314\" height=\"352\" title=\"tong-hop-mos-1-6\"><figcaption id=\"caption-attachment-24245\" class=\"wp-caption-text\">Ta t\u00ecm ki\u1ebfm b\u1eb1ng ch\u1ee9c n\u0103ng Find, n\u1eb1m trong nh\u00f3m Editing, th\u1ebb Home<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>2. \u0110\u1eb7t Hyperlink<\/p>\n<figure id=\"attachment_24246\" aria-describedby=\"caption-attachment-24246\" style=\"width: 527px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24246\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-7.png\" width=\"527\" height=\"231\" title=\"tong-hop-mos-1-7\"><figcaption id=\"caption-attachment-24246\" class=\"wp-caption-text\">Hyperlink trong phi\u00ean b\u1ea3n 365. Tuy giao di\u1ec7n h\u01a1i kh\u00e1c, nh\u01b0ng v\u1ecb tr\u00ed th\u00ec v\u1eabn \u1edf th\u1ebb Insert<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>3. Thay \u0111\u1ed5i th\u1ee9 t\u1ef1 trang t\u00ednh<\/p>\n<figure id=\"attachment_24247\" aria-describedby=\"caption-attachment-24247\" style=\"width: 194px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24247\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-8.png\" width=\"194\" height=\"64\" title=\"tong-hop-mos-1-8\"><figcaption id=\"caption-attachment-24247\" class=\"wp-caption-text\">Ta k\u00e9o v\u00e0 th\u1ea3 nha!<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>4. S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Go To<\/p>\n<p>Go To cho ph\u00e9p ta \u0111i \u0111\u1ebfn nh\u1eefng \u00f4 ho\u1eb7c v\u00f9ng theo \u00fd mu\u1ed1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24248\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-6-1.png\" width=\"314\" height=\"352\" title=\"tong-hop-mos-1-6-1\"><\/p>\n<p>V\u1ec1 v\u1ecb tr\u00ed, n\u00f3 n\u1eb1m trong nh\u00f3m ch\u1ee9c n\u0103ng Find &amp; Select \u0111\u00e3 n\u00f3i \u1edf tr\u00ean.<\/p>\n<p>\u00a0<\/p>\n<p>5. S\u1eed d\u1ee5ng Namebox<\/p>\n<p>Namebox l\u00e0 n\u01a1i t\u00ean \u00f4, t\u00ean v\u00f9ng \u0111\u01b0\u1ee3c th\u1ec3 hi\u1ec7n ra cho ng\u01b0\u1eddi s\u1eed d\u1ee5ng. Th\u00e0nh th\u1ea1o Namebox s\u1ebd gi\u00fap thao t\u00e1c c\u1ee7a b\u1ea1n nhanh h\u01a1n nhi\u1ec1u.<\/p>\n<figure id=\"attachment_24249\" aria-describedby=\"caption-attachment-24249\" style=\"width: 134px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-24249 size-full\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-9.png\" width=\"134\" height=\"147\" title=\"tong-hop-mos-1-9\"><figcaption id=\"caption-attachment-24249\" class=\"wp-caption-text\">\u0110\u00e2y l\u00e0 namebox (A1)<\/figcaption><\/figure>\n<p>C\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 xem c\u00e1c b\u00e0i vi\u1ebft sau:<\/p>\n<p>\u00a0<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-trang-tinh-mos-excel.html\">H\u01b0\u1edbng d\u1eabn thao t\u00e1c v\u1edbi trang t\u00ednh trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/su-dung-hyperlinks-lien-ket-du-lieu-hieu-qua.html\">H\u01b0\u1edbng d\u1eabn s\u1eed d\u1ee5ng Hyperlinks li\u00ean k\u1ebft d\u1eef li\u1ec7u hi\u1ec7u qu\u1ea3<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/mos-2010-di-chuyen-dinh-vi-trong-trang-tinh.html\">C\u00e1ch di chuy\u1ec3n v\u00e0 \u0111\u1ecbnh v\u1ecb trong m\u1ed9t trang t\u00ednh Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-va-ap-dung-named-ranges-mos.html\">C\u00e1ch thi\u1ebft l\u1eadp v\u00e0 \u00e1p d\u1ee5ng Named Ranges trong b\u00e0i thi MOS<\/a><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Dinh_dang_trang_tinh_so_tinh\"><\/span>\u0110\u1ecbnh d\u1ea1ng trang t\u00ednh, s\u1ed5 t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi k\u0129 n\u0103ng n\u00e0y, b\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m ch\u1ee7 \u0111\u01b0\u1ee3c nh\u1eefng y\u1ebfu t\u1ed1 xoay quanh \u0111\u1ecbnh d\u1ea1ng trang t\u00ednh v\u00e0 s\u1ed5 t\u00ednh g\u1ed3m c\u00f3:<\/p>\n<p>1. \u0110\u1ed5i m\u00e0u th\u1ebb trang t\u00ednh<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24251\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-10.png\" width=\"287\" height=\"88\" title=\"tong-hop-mos-1-10\"><\/p>\n<p>2. C\u0103n ch\u1ec9nh page setup<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24252\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-11.png\" width=\"445\" height=\"455\" title=\"tong-hop-mos-1-11\"><\/p>\n<p>3. Tinh ch\u1ec9nh ch\u1ee7 \u0111\u1ec1<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24254\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-12.png\" width=\"346\" height=\"550\" title=\"tong-hop-mos-1-12\"><\/p>\n<p>4. Thao t\u00e1c v\u1edbi c\u1ed9t v\u00e0 h\u00e0ng (\u1ea9n, hi\u1ec7n, th\u00eam, x\u00f3a, c\u0103n ch\u1ec9nh)<\/p>\n<p>5. \u0110\u1eb7t watermark, header &amp; footer<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24256\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-13.png\" width=\"271\" height=\"205\" title=\"tong-hop-mos-1-13\"><\/p>\n<p>6. Hi\u1ec3u v\u1ec1 data validation<\/p>\n<figure id=\"attachment_24257\" aria-describedby=\"caption-attachment-24257\" style=\"width: 252px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24257\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-14.png\" width=\"252\" height=\"161\" title=\"tong-hop-mos-1-14\"><figcaption id=\"caption-attachment-24257\" class=\"wp-caption-text\">Ch\u1ee9c n\u0103ng data validation trong th\u1ebb Data, nh\u00f3m Data Tools<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>\u0110\u1ed1i v\u1edbi k\u0129 n\u0103ng n\u00e0y, H\u1ecdc Excel Online c\u00f3 cung c\u1ea5p h\u1ec7 th\u1ed1ng b\u00e0i vi\u1ebft. B\u1ea1n c\u00f3 th\u1ec3 \u0111\u1ecdc trong nh\u1eefng link sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-header-footer-trong-mos-excel.html\">C\u00e1ch thi\u1ebft l\u1eadp Header and Footer trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/quan-ly-page-va-margin-page-setup.html\">H\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd th\u1ebb Page v\u00e0 Margin trong h\u1ed9p tho\u1ea1i Page Setup<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-hang-va-cot-mos-excel.html\">C\u00e1ch thao t\u00e1c v\u1edbi h\u00e0ng v\u00e0 c\u1ed9t hi\u1ec7u qu\u1ea3 trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-trang-tinh-mos-excel.html\">H\u01b0\u1edbng d\u1eabn thao t\u00e1c v\u1edbi trang t\u00ednh trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Tuy_chinh_thong_so_va_cac_che_do_cho_trang_tinhso_tinh\"><\/span>T\u00f9y ch\u1ec9nh th\u00f4ng s\u1ed1 v\u00e0 c\u00e1c ch\u1ebf \u0111\u1ed9 cho trang t\u00ednh\/s\u1ed5 t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>Sau khi \u0111\u00e3 \u0111\u1ecbnh v\u1ecb v\u00e0 \u0111\u1ecbnh d\u1ea1ng trang t\u00ednh, ta c\u1ea7n ph\u1ea3i bi\u1ebft c\u00e1ch thi\u1ebft l\u1eadp c\u00e1c th\u00f4ng s\u1ed1. Trong m\u1ee5c n\u00e0y, H\u1ecdc Excel Online \u0111\u00e3 x\u00e2y d\u1ef1ng nh\u1eefng b\u00e0i h\u1ed7 tr\u1ee3 t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao m\u1ed9t c\u00e1ch chi ti\u1ebft. C\u1ee5 th\u1ec3:<\/p>\n<p>1. \u1ea8n\/hi\u1ec7n trang t\u00ednh, \u1ea9n\/hi\u1ec7n c\u1ed9t\/h\u00e0ng trong trang t\u00ednh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-trang-tinh-mos-excel.html\">H\u01b0\u1edbng d\u1eabn thao t\u00e1c v\u1edbi trang t\u00ednh trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thao-tac-voi-hang-va-cot-mos-excel.html\">C\u00e1ch thao t\u00e1c v\u1edbi h\u00e0ng v\u00e0 c\u1ed9t hi\u1ec7u qu\u1ea3 trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<p>2. T\u00ecm hi\u1ec3u v\u1ec1 Ribbon, thanh Quick Access<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/backstage-view-ribbon-va-quick-access-toolbar-excel-2010.html\">T\u00ecm hi\u1ec3u Backstage View, Ribbon v\u00e0 Quick Access Toolbar trong MOS<\/a><\/p>\n<p>\u00a0<\/p>\n<p>3. Qu\u1ea3n l\u00fd c\u00e1c th\u00f4ng s\u1ed1 trong trang t\u00ednh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/quan-ly-thong-tin-co-ban-cua-so-tinh-tren-tuy-chon-info.html\">H\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd th\u00f4ng tin c\u01a1 b\u1ea3n c\u1ee7a s\u1ed5 t\u00ednh tr\u00ean t\u00f9y ch\u1ecdn Info<\/a><\/p>\n<p>\u00a0<\/p>\n<p>4. Ch\u1ebf \u0111\u1ed9 developer v\u00e0 m\u1ed9t macro \u0111\u01a1n gi\u1ea3n.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cach-hien-developer-de-ghi-macro-hoac-viet-code-vba-trong-excel.html\">Hi\u1ec7n th\u1ebb developer trong Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<p>5. Thay \u0111\u1ed5i c\u00e1c ch\u1ebf \u0111\u1ed9 view trong Excel, thu v\u00e0 ph\u00f3ng l\u1edbn.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/thiet-lap-custom-views-3-che-hien-thi-trang-tinh.html\">Thi\u1ebft l\u1eadp custom views t\u1eeb 3 ch\u1ebf \u0111\u1ed9 hi\u1ec3n th\u1ecb c\u1ee7a m\u1ed9t trang t\u00ednh Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<p>6. Split (chia t\u00e1ch) v\u00e0 freeze (\u0111\u00f3ng b\u0103ng) h\u00e0ng\/c\u1ed9t trong trang t\u00ednh.<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/chuc-nang-split-arrange-hide-unhide.html\">S\u1eed d\u1ee5ng ch\u1ee9c n\u0103ng Split \u0111\u1ec3 chia c\u1eaft; s\u1eafp x\u1ebfp hi\u1ec3n th\u1ecb c\u00e1c s\u1ed5 t\u00ednh hi\u1ec7u qu\u1ea3 trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/tinh-nang-freeze-trong-bai-thi-mos-excel.html\">C\u00e1ch d\u00f9ng t\u00ednh n\u0103ng Freeze trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>7. S\u1eed d\u1ee5ng c\u00e1c ph\u00edm t\u1eaft<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/cac-phim-tat-thuong-dung-trong-excel-ap-dung-cho-2007-2010-2013-2016.html\">C\u00e1c ph\u00edm t\u1eaft th\u00f4ng d\u1ee5ng trong Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Thiet_lap_trang_tinh_cho_muc_dich_in_an\"><\/span>Thi\u1ebft l\u1eadp trang t\u00ednh cho m\u1ee5c \u0111\u00edch in \u1ea5n<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u00e2y l\u00e0 b\u1ed9 k\u0129 n\u0103ng li\u00ean quan t\u1edbi in \u1ea5n m\u00e0 b\u1ea5t k\u00ec ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel c\u01a1 b\u1ea3n n\u00e0o c\u0169ng n\u00ean bi\u1ebft:<\/p>\n<p>1. Thi\u1ebft l\u1eadp v\u00f9ng in b\u1eb1ng Print Area<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24264\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-15.png\" width=\"367\" height=\"202\" title=\"tong-hop-mos-1-15\"><\/p>\n<p>\u00a0<\/p>\n<p>2. L\u01b0u, xu\u1ea5t file Excel d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng t\u00f9y ch\u1ec9nh nh\u01b0 PDF\/XPS<\/p>\n<figure id=\"attachment_24265\" aria-describedby=\"caption-attachment-24265\" style=\"width: 669px\" class=\"wp-caption aligncenter\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-24265\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-1-16.png\" width=\"669\" height=\"316\" title=\"tong-hop-mos-1-16\"><figcaption id=\"caption-attachment-24265\" class=\"wp-caption-text\">Ngo\u00e0i Change file type khi b\u1ea1n ch\u1ecdn Save As, Export c\u00f9ng gi\u00fap t\u1ea1o ra file PDF thu\u1eadn ti\u1ec7n cho in \u1ea5n<\/figcaption><\/figure>\n<p>\u00a0<\/p>\n<p>3. Hi\u1ec7u ch\u1ec9nh c\u00e1c thi\u1ebft l\u1eadp khi in<\/p>\n<p>\u00a0<\/p>\n<p>H\u00e3y tham kh\u1ea3o nh\u1eefng b\u00e0i vi\u1ebft sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/quan-ly-thiet-lap-co-ban-voi-hop-thoai-excel-options.html\">H\u01b0\u1edbng d\u1eabn qu\u1ea3n l\u00fd thi\u1ebft l\u1eadp c\u01a1 b\u1ea3n v\u1edbi h\u1ed9p tho\u1ea1i Excel Options<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/mos-2010-in-trang-tinh-so-tinh-ngat-trang.html\">C\u00e1ch in trang t\u00ednh, s\u1ed5 t\u00ednh v\u00e0 ng\u1eaft trang trong b\u00e0i thi MOS Excel 2010<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/luu-file-voi-cac-dinh-dang-khac-nhau-save-save-as.html\">H\u01b0\u1edbng d\u1eabn l\u01b0u file v\u1edbi c\u00e1c \u0111\u1ecbnh d\u1ea1ng kh\u00e1c nhau s\u1eed d\u1ee5ng Save v\u00e0 Save As<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/4-yeu-cau-co-ban-in-trang-tinh-so-tinh-hoac-ngat-trang-mos-excel.html\">H\u01b0\u1edbng d\u1eabn 4 y\u00eau c\u1ea7u c\u01a1 b\u1ea3n nh\u1ea5t v\u1ec1 in trang t\u00ednh, s\u1ed5 t\u00ednh ho\u1eb7c ng\u1eaft trang trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<p>V\u00e0 \u0111\u00f3 l\u00e0 nh\u1eefng k\u0129 n\u0103ng c\u01a1 b\u1ea3n nh\u1ea5t ng\u01b0\u1eddi s\u1eed d\u1ee5ng Excel c\u1ea7n \u0111\u1ea1t \u0111\u01b0\u1ee3c \u0111\u1ed1i v\u1edbi y\u00eau c\u1ea7u \u0111\u1ea7u ti\u00ean \u2013 y\u00eau c\u1ea7u li\u00ean quan t\u1edbi t\u1ea1o l\u1eadp v\u00e0 qu\u1ea3n l\u00fd trang t\u00ednh c\u0169ng nh\u01b0 s\u1ed5 t\u00ednh. Trong nh\u1eefng b\u00e0i vi\u1ebft ti\u1ebfp theo, ta s\u1ebd \u0111i v\u00e0o c\u00e1c y\u00eau c\u1ea7u kh\u00e1c \u0111\u01b0\u1ee3c \u0111\u1eb7t ra \u0111\u1ed1i v\u1edbi b\u00e0i thi n\u00e0y.<\/p>\n<p>Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u00ecm \u0111\u1ecdc th\u00eam nh\u1eefng b\u00e0i vi\u1ebft li\u00ean quan t\u1edbi MOS d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/mos-va-nhung-dieu-can-biet.html\">TIN H\u1eccC V\u0102N PH\u00d2NG: NH\u1eeeNG \u0110I\u1ec0U C\u1ea6N BI\u1ebeT V\u1ec0 B\u00c0I THI MOS<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/loi-khuyen-co-ban-huu-ich-de-dat-ket-qua-tot-trong-bai-thi-mos-excel.html\">Nh\u1eefng l\u1eddi khuy\u00ean c\u01a1 b\u1ea3n m\u00e0 h\u1eefu \u00edch \u0111\u1ec3 \u0111\u1ea1t k\u1ebft qu\u1ea3 t\u1ed1t trong b\u00e0i thi MOS Excel<\/a><\/p>\n<p>\u00a0<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<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\/2025\/01\/ex101_92019-nho-60.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9486,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9485","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel-co-ban"],"_links":{"self":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9485","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=9485"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9485\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9486"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9485"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9485"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9485"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}