{"id":9438,"date":"2025-01-02T06:20:16","date_gmt":"2025-01-02T06:20: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-3\/"},"modified":"2025-01-02T06:20:16","modified_gmt":"2025-01-02T06:20:16","slug":"tong-hop-nhanh-nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-phan-3","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-3\/","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 3"},"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 cho b\u00e0i thi MOS Excel hi\u1ec7u qu\u1ea3 v\u00e0 c\u00e1ch \u1ee9ng d\u1ee5ng th\u1eadt t\u1ed1t. 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\u00a0<strong>Specialist\u00a02013<\/strong>\u00a0, 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>Danh s\u00e1ch b\u00e0i vi\u1ebft tr\u01b0\u1edbc:<\/p>\n<ul>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-1.html\">Ph\u1ea7n 1<\/a><\/li>\n<li><a href=\"http:\/\/blog.ezworkapp.com\/nhung-ki-nang-can-thiet-cho-bai-thi-mos-excel-2.html\">Ph\u1ea7n 2<\/a><\/li>\n<\/ul>\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-6776301fa14b9\" 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-3.html#Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_%E2%80%93_phan_3\" title=\"K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 3\">K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 3<\/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-3.html#Tao_lap_bang_tinh\" title=\"T\u1ea1o l\u1eadp b\u1ea3ng t\u00ednh\">T\u1ea1o l\u1eadp b\u1ea3ng 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-3.html#Hieu_chinh_cac_chuc_nang_bang_tinh\" title=\"Hi\u1ec7u ch\u1ec9nh c\u00e1c ch\u1ee9c n\u0103ng b\u1ea3ng t\u00ednh\">Hi\u1ec7u ch\u1ec9nh c\u00e1c ch\u1ee9c n\u0103ng b\u1ea3ng 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-3.html#Loc_va_sap_xep_du_lieu\" title=\"L\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u\">L\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ki_nang_can_thiet_cho_bai_thi_MOS_Excel_%E2%80%93_phan_3\"><\/span>K\u0129 n\u0103ng c\u1ea7n thi\u1ebft cho b\u00e0i thi MOS Excel \u2013 ph\u1ea7n 3<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong ph\u1ea7n 3 n\u00e0y, \u0111\u1ed1i t\u01b0\u1ee3ng ta nh\u1eafm \u0111\u1ebfn s\u1ebd l\u00e0 c\u00e1c\u00a0<strong>b\u1ea3ng t\u00ednh.<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24274\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-3-1.png\" width=\"772\" height=\"210\" title=\"tong-hop-mos-3-1\"><\/p>\n<p>Nh\u1eefng k\u0129 n\u0103ng trong ph\u1ea7n n\u00e0y bao g\u1ed3m:<\/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-53.gif\" title=\"ex101_92019-nho-53\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<h4><span class=\"ez-toc-section\" id=\"Tao_lap_bang_tinh\"><\/span>T\u1ea1o l\u1eadp b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>B\u1ea1n c\u1ea7n hi\u1ec3u \u0111\u01b0\u1ee3c c\u00e1ch:<\/p>\n<ul>\n<li>Chuy\u1ec3n \u0111\u1ed5i gi\u1eefa b\u1ea3ng t\u00ednh (Table) v\u00e0 v\u00f9ng (Range)<\/li>\n<li>Th\u00eam\/s\u1eeda\/x\u00f3a h\u00e0ng\/c\u1ed9t<\/li>\n<li>\u0110\u1ecbnh ti\u00eau \u0111\u1ec1 cho b\u1ea3ng<\/li>\n<\/ul>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24276\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-3-2.png\" width=\"379\" height=\"447\" title=\"tong-hop-mos-3-2\"><\/p>\n<h4><span class=\"ez-toc-section\" id=\"Hieu_chinh_cac_chuc_nang_bang_tinh\"><\/span>Hi\u1ec7u ch\u1ec9nh c\u00e1c ch\u1ee9c n\u0103ng b\u1ea3ng t\u00ednh<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>T\u1ea1i \u0111\u00e2y b\u1ea1n c\u1ea7n:<\/p>\n<ul>\n<li>Hi\u1ec7u ch\u1ec9nh style cho b\u1ea3ng<\/li>\n<li>Nh\u00f3m c\u00e1c h\u00e0ng\/c\u1ed9t<\/li>\n<li>Th\u00eam d\u00f2ng t\u00ednh t\u1ed5ng \u1edf cu\u1ed1i<\/li>\n<li>X\u00f3a style<\/li>\n<\/ul>\n<p>\u0110\u1ec3 th\u1ef1c hi\u1ec7n c\u00e1c thao t\u00e1c n\u00e0y, b\u1ea1n h\u00e3y quan s\u00e1t trong th\u1ebb\u00a0<strong>Design<\/strong> sau khi t\u1ea1o b\u1ea3ng nh\u00e9. T\u1ea5t c\u1ea3 c\u00f4ng c\u1ee5 ch\u1ec9 xung quanh \u0111\u00f3 th\u00f4i!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-24277\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-3-3-1024x398-1.png\" width=\"1024\" height=\"398\" title=\"tong-hop-mos-3-3-1024x398-1\"><\/p>\n<p>\u00a0<\/p>\n<h4><span class=\"ez-toc-section\" id=\"Loc_va_sap_xep_du_lieu\"><\/span>L\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u<span class=\"ez-toc-section-end\"><\/span><\/h4>\n<p>\u0110\u1ed1i v\u1edbi l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp d\u1eef li\u1ec7u, b\u1ea1n c\u1ea7n ph\u1ea3i hi\u1ec3u c\u00e1c ch\u1ee9c n\u0103ng n\u00e0y, c\u0169ng nh\u01b0 c\u00e1c ki\u1ec3u s\u1eafp x\u1ebfp, VD: l\u1ecdc nh\u1eefng gi\u00e1 tr\u1ecb l\u1edbn h\u01a1n 3, l\u1ecdc nh\u1eefng gi\u00e1 tr\u1ecb ch\u1ee9a k\u00ed t\u1ef1 \u201ca\u201d\u2026<\/p>\n<p>B\u1ea5m v\u00e0o m\u0169i t\u00ean s\u1ed5 xu\u1ed1ng \u1edf b\u1ea3ng \u0111\u1ec3 tr\u1ecf \u0111\u1ebfn thao t\u00e1c l\u1ecdc v\u00e0 s\u1eafp x\u1ebfp<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-24278\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/tong-hop-mos-3-4.png\" width=\"309\" height=\"431\" title=\"tong-hop-mos-3-4\"><\/p>\n<p>Trong ph\u1ea7n 3 n\u00e0y, H\u1ecdc Excel Online \u0111\u01b0a ra nh\u1eefng ki\u1ebfn th\u1ee9c ph\u1ee5c v\u1ee5 cho c\u00f4ng vi\u1ec7c \u0111\u1ed1i v\u1edbi b\u1ea3ng t\u00ednh c\u1ee7a b\u00e0i thi MOS. \u0110\u1eebng coi th\u01b0\u1eddng v\u00ec s\u1ed1 l\u01b0\u1ee3ng \u00edt nh\u00e9! Ch\u1ea5t l\u01b0\u1ee3ng v\u00e0 y\u00eau c\u1ea7u c\u1ee7a ph\u1ea7n n\u00e0y kh\u00f4ng k\u00e9m ph\u1ea7n kh\u00f3 nh\u1eb1n v\u00e0 l\u1eaft l\u00e9o \u0111\u00e2u.<\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 tham kh\u1ea3o th\u00eam b\u00e0i vi\u1ebft v\u1ec1 b\u1ea3ng t\u1ea1i\u00a0<strong><a href=\"http:\/\/blog.ezworkapp.com\/cong-thuc-dem-lan-xuat-hien-trong-table.html\">\u0111\u00e2y<\/a>.\u00a0<\/strong>V\u00e0 \u0111\u1eebng qu\u00ean, h\u00e3y \u0111\u00f3n ch\u1edd ph\u1ea7n 4 c\u1ee7a series b\u00e0i vi\u1ebft s\u1ebd xu\u1ea5t hi\u1ec7n s\u1edbm th\u00f4i.<\/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-53.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":9439,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-9438","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\/9438","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=9438"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/9438\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/9439"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=9438"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=9438"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=9438"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}