{"id":1704,"date":"2024-12-02T05:55:16","date_gmt":"2024-12-02T05:55:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/chen-hop-kiem-checkbox-vao-excel\/"},"modified":"2024-12-02T05:55:16","modified_gmt":"2024-12-02T05:55:16","slug":"chen-hop-kiem-checkbox-vao-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/chen-hop-kiem-checkbox-vao-excel\/","title":{"rendered":"Ch\u00e8n h\u1ed9p ki\u1ec3m\/checkbox v\u00e0o Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p><em>B\u00e0i vi\u1ebft n\u00e0y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch t\u1ea1o \u00f4 tick trong Excel r\u1ed3i s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0o c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o b\u1ea3ng li\u1ec7t k\u00ea nh\u1eefng m\u1ee5c c\u1ea7n ki\u1ec3m tra, b\u1ea3ng li\u1ec7t k\u00ea nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m, b\u1ea3ng b\u00e1o c\u00e1o hay bi\u1ec3u \u0111\u1ed3 mang t\u00ednh t\u01b0\u01a1ng t\u00e1c.<\/em><\/p>\n<p>Ch\u00fang ta \u0111\u1ec1u c\u0169ng bi\u1ebft h\u1ed9p \u0111\u00e1nh d\u1ea5u l\u00e0 g\u00ec, ch\u1eafc ch\u1eafn b\u1ea1n \u0111\u00e3 nh\u00ecn th\u1ea5y r\u1ea5t nhi\u1ec1u h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u1edbi c\u00e1c h\u00ecnh d\u1ea1ng kh\u00e1c nhau tr\u00ean m\u1ea1ng. Tuy v\u1eady, \u0111\u1ec3 r\u00f5 r\u00e0ng, h\u00e3y \u0111\u1ec3 t\u00f4i \u0111\u01b0a cho b\u1ea1n m\u1ed9t \u0111\u1ecbnh ngh\u0129a ng\u1eafn g\u1ecdn.<\/p>\n<p>H\u1ed9p \u0111\u00e1nh d\u1ea5u, hay c\u00f2n g\u1ecdi l\u00e0 h\u1ed9p l\u1ef1a ch\u1ecdn, l\u00e0 m\u1ed9t h\u1ed9p h\u00ecnh vu\u00f4ng nh\u1ecf n\u01a1i b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn hay b\u1ecf ch\u1ecdn c\u00e1c l\u1ef1a ch\u1ecdn c\u00f3 s\u1eb5n.<\/p>\n<p>Ch\u00e8n h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0o Excel nghe c\u00f3 v\u1ebb b\u00ecnh th\u01b0\u1eddng, nh\u01b0ng n\u00f3 t\u1ea1o ra r\u1ea5t nhi\u1ec1u kh\u1ea3 n\u0103ng cho trang t\u00ednh c\u1ee7a b\u1ea1n, vi\u1ec7c n\u00e0y s\u1ebd gi\u00fap b\u1ea1n lu\u00f4n h\u01b0\u1edbng t\u1edbi m\u1ee5c ti\u00eau, l\u00e0m vi\u1ec7c theo th\u1eddi kh\u00f3a bi\u1ec3u, ho\u00e0n th\u00e0nh b\u00e0i t\u1eadp,\u2026<\/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-674d4bc39c107\" 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\/chen-hop-kiem-checkbox-vao-excel.html#CACH_CHEN_HOP_DANH_DAU_VAO_EXCEL\" title=\"C\u00c1CH CH\u00c8N H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O EXCEL\">C\u00c1CH CH\u00c8N H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O EXCEL<\/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\/chen-hop-kiem-checkbox-vao-excel.html#HIEN_THI_TAB_DEVELOPER_TREN_RIBBON\" title=\"HI\u1ec2N TH\u1eca TAB DEVELOPER TR\u00caN RIBBON\">HI\u1ec2N TH\u1eca TAB DEVELOPER TR\u00caN RIBBON<\/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\/chen-hop-kiem-checkbox-vao-excel.html#THEM_HOP_DANH_DAU\" title=\"TH\u00caM H\u1ed8P \u0110\u00c1NH D\u1ea4U\">TH\u00caM H\u1ed8P \u0110\u00c1NH D\u1ea4U<\/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\/chen-hop-kiem-checkbox-vao-excel.html#SAO_CHEP_HOP_DANH_DAU_VAO_CAC_O_KHAC\" title=\"SAO CH\u00c9P H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O C\u00c1C \u00d4 KH\u00c1C\">SAO CH\u00c9P H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O C\u00c1C \u00d4 KH\u00c1C<\/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\/chen-hop-kiem-checkbox-vao-excel.html#VI_DU_VE_VIEC_SU_DUNG_HOP_DANH_DAU_TRONG_EXCEL\" title=\"V\u00cd D\u1ee4 V\u1ec0 VI\u1ec6C S\u1eec D\u1ee4NG H\u1ed8P \u0110\u00c1NH D\u1ea4U TRONG EXCEL\">V\u00cd D\u1ee4 V\u1ec0 VI\u1ec6C S\u1eec D\u1ee4NG H\u1ed8P \u0110\u00c1NH D\u1ea4U TRONG 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\/chen-hop-kiem-checkbox-vao-excel.html#CACH_LIEN_KET_HOP_DANH_DAU_VOI_O\" title=\"C\u00c1CH LI\u00caN K\u1ebeT H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u1edaI \u00d4\">C\u00c1CH LI\u00caN K\u1ebeT H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u1edaI \u00d4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-7\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CACH_TAO_DANH_SACH_NHUNG_VIEC_CAN_KIEM_TRA_TRONG_EXCEL_VOI_BANG_TOM_TAT_DU_LIEU\" title=\"C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N KI\u1ec2M TRA TRONG EXCEL V\u1edaI B\u1ea2NG T\u00d3M T\u1eaeT D\u1eee LI\u1ec6U\">C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N KI\u1ec2M TRA TRONG EXCEL V\u1edaI B\u1ea2NG T\u00d3M T\u1eaeT D\u1eee LI\u1ec6U<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-8\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CONG_THUC_TINH_TONG_NHIEM_VU\" title=\"C\u00d4NG TH\u1ee8C T\u00cdNH T\u1ed4NG NHI\u1ec6M V\u1ee4\">C\u00d4NG TH\u1ee8C T\u00cdNH T\u1ed4NG NHI\u1ec6M V\u1ee4<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-9\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CONG_THUC_TINH_SO_NHIEM_VU_DA_HOAN_THANH\" title=\"C\u00d4NG TH\u1ee8C T\u00cdNH S\u1ed0 NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH\">C\u00d4NG TH\u1ee8C T\u00cdNH S\u1ed0 NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-10\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CONG_THUC_TINH_PHAN_TRAM_CAC_NHIEM_VU_DA_HOAN_THANH\" title=\"C\u00d4NG TH\u1ee8C T\u00cdNH PH\u1ea6N TR\u0102M C\u00c1C NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH\">C\u00d4NG TH\u1ee8C T\u00cdNH PH\u1ea6N TR\u0102M C\u00c1C NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-11\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#THEM_NHIEU_MAU_DANH_SACH_NHUNG_VIEC_CAN_HOAN_THANH\" title=\"TH\u00caM NHI\u1ec0U M\u1eaaU DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N HO\u00c0N TH\u00c0NH\">TH\u00caM NHI\u1ec0U M\u1eaaU DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N HO\u00c0N TH\u00c0NH<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-12\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CACH_TAO_DANH_SACH_NHUNG_VIEC_CAN_LAM_CUNG_VOI_DINH_DANG_CO_DIEU_KIEN\" title=\"C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N L\u00c0M C\u00d9NG V\u1edaI \u0110\u1ecaNH D\u1ea0NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N\">C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N L\u00c0M C\u00d9NG V\u1edaI \u0110\u1ecaNH D\u1ea0NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-13\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#CACH_DUNG_HOP_DANH_DAU_TAO_BANG_BAO_CAO_MANG_TINH_TUONG_TAC\" title=\"C\u00c1CH D\u00d9NG H\u1ed8P \u0110\u00c1NH D\u1ea4U T\u1ea0O B\u1ea2NG B\u00c1O C\u00c1O MANG T\u00cdNH T\u01af\u01a0NG T\u00c1C\">C\u00c1CH D\u00d9NG H\u1ed8P \u0110\u00c1NH D\u1ea4U T\u1ea0O B\u1ea2NG B\u00c1O C\u00c1O MANG T\u00cdNH T\u01af\u01a0NG T\u00c1C<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-14\" href=\"https:\/\/blog.hocexcel.online\/chen-hop-kiem-checkbox-vao-excel.html#TAO_BIEU_DO_SINH_DONG_DUA_TREN_TINH_TRANG_HOP_DANH_DAU\" title=\"T\u1ea0O BI\u1ec2U \u0110\u1ed2 SINH \u0110\u1ed8NG D\u1ef0A TR\u00caN T\u00ccNH TR\u1ea0NG H\u1ed8P \u0110\u00c1NH D\u1ea4U\">T\u1ea0O BI\u1ec2U \u0110\u1ed2 SINH \u0110\u1ed8NG D\u1ef0A TR\u00caN T\u00ccNH TR\u1ea0NG H\u1ed8P \u0110\u00c1NH D\u1ea4U<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"CACH_CHEN_HOP_DANH_DAU_VAO_EXCEL\"><\/span>C\u00c1CH CH\u00c8N H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Gi\u1ed1ng nh\u01b0 c\u00e1c quy\u1ec1n ki\u1ec3m so\u00e1t h\u00ecnh th\u1ee9c kh\u00e1c, quy\u1ec1n ki\u1ec3m so\u00e1t H\u1ed9p \u0111\u00e1nh d\u1ea5u n\u1eb1m tr\u00ean tab Ng\u01b0\u1eddi ph\u00e1t tri\u1ec3n, tab n\u00e0y kh\u00f4ng c\u00f3 tr\u00ean thanh ribbon Excel theo m\u1eb7c \u0111\u1ecbnh. V\u00ec th\u1ebf, b\u1ea1n c\u1ea7n ph\u1ea3i b\u1eadt n\u00f3 l\u00ean tr\u01b0\u1edbc \u0111\u00e3.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"HIEN_THI_TAB_DEVELOPER_TREN_RIBBON\"><\/span>HI\u1ec2N TH\u1eca TAB DEVELOPER TR\u00caN RIBBON<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 th\u00eam tab Developer v\u00e0o ribbon tr\u00ean Excel, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o b\u1ea5t c\u1ee9 \u0111\u00e2u tr\u00ean ribbon, r\u1ed3i nh\u1ea5p Customize the Ribbon\u2026hay nh\u1ea5p File&gt;Options&gt;Customize Ribbon.<\/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\/2024\/12\/ex101_92019-nho-124.gif\" title=\"ex101_92019-nho-124\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>B\u00ean d\u01b0\u1edbi Customize the Ribbon, h\u00e3y ch\u1ecdn Main Tabs (th\u00f4ng th\u01b0\u1eddng th\u00ec n\u00f3 \u0111\u01b0\u1ee3c ch\u1ecdn m\u1ed9t c\u00e1ch m\u1eb7c \u0111\u1ecbnh), h\u00e3y ki\u1ec3m tra h\u1ed9p Developer, r\u1ed3i nh\u1ea5p OK.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6591 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/301-300x241-1.png\" width=\"300\" height=\"241\" title=\"301-300x241-1\"><\/p>\n<p>B\u00e2y gi\u1edd, v\u1edbi tab Developer tr\u00ean thanh ribbon, b\u1ea1n c\u00f3 quy\u1ec1n truy c\u1eadp v\u00f4 s\u1ed1 c\u00e1c quy\u1ec1n ki\u1ec3m so\u00e1t t\u01b0\u01a1ng t\u00e1c, k\u1ec3 c\u1ea3 H\u1ed9p \u0110\u00e1nh d\u1ea5u.<\/p>\n<p>S\u1eafp x\u1ebfp d\u1eef li\u1ec7u<\/p>\n<p>N\u1ebfu b\u1ea1n \u0111ang t\u1ea1o b\u1ea3ng li\u1ec7t k\u00ea nh\u1eefng m\u1ee5c c\u1ea7n ki\u1ec3m tra hay b\u1ea3ng li\u1ec7t k\u00ea nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m, th\u00ec b\u01b0\u1edbc \u0111\u1ea7u ti\u00ean l\u00e0 l\u1eadp danh s\u00e1ch c\u00e1c nhi\u1ec7m v\u1ee5 hay c\u00e1c m\u1ee5c kh\u00e1c \u2013 c\u00e1c m\u1ee5c \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o h\u1ed9p \u0111\u00e1nh d\u1ea5u.<\/p>\n<p>\u0110\u1ed1i v\u1edbi v\u00ed d\u1ee5 n\u00e0y, t\u00f4i \u0111\u00e3 t\u1ea1o ra b\u1ea3ng li\u1ec7t k\u00ea nh\u1eefng k\u1ebf ho\u1ea1ch c\u1ea7n l\u00e0m cho b\u1eefa ti\u1ec7c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6592 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/302.png\" width=\"261\" height=\"260\" title=\"302\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"THEM_HOP_DANH_DAU\"><\/span>TH\u00caM H\u1ed8P \u0110\u00c1NH D\u1ea4U<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u01b0\u1edbc chu\u1ea9n b\u1ecb \u0111\u00e3 xong, v\u00e0 b\u00e2y gi\u1edd ch\u00fang ta \u0111i v\u00e0o ph\u1ea7n ch\u00ednh th\u00f4i \u2013 th\u00eam h\u1ed9p \u0111\u00e1nh d\u1ea5u\/ c\u00e1ch t\u1ea1o \u00f4 tick trong Excel cho danh s\u00e1ch nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m cho b\u1eefa ti\u1ec7c.<\/p>\n<p>\u0110\u1ec3 ch\u00e8n h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0o Excel, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>Tr\u00ean tab Developer, trong nh\u00f3m Controls, nh\u1ea5p Insert, r\u1ed3i ch\u1ecdn h\u1ed9p \u0111\u00e1nh d\u1ea5u b\u00ean d\u01b0\u1edbi Form Controls.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6593 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/303.png\" width=\"228\" height=\"234\" title=\"303\"><\/p>\n<p>Nh\u1ea5p v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n ch\u00e8n h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u1ea7u ti\u00ean (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 \u00f4 B2). Quy\u1ec1n ki\u1ec3m so\u00e1t h\u1ed9p \u0111\u00e1nh d\u1ea5u s\u1ebd xu\u1ea5t hi\u1ec7n g\u1ea7n \u0111\u00f3, kh\u00f4ng c\u1ea7n ph\u1ea3i ch\u00ednh x\u00e1c l\u00e0 \u1edf trong \u00f4 \u0111\u00f3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6594 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/304-300x111-1.png\" width=\"300\" height=\"111\" title=\"304-300x111-1\"><\/p>\n<p>\u0110\u1ec3 \u0111\u1eb7t h\u1ed9p \u0111\u00e1nh d\u1ea5u m\u1ed9t c\u00e1ch th\u00edch h\u1ee3p, h\u00e3y di chuy\u1ec3n chu\u1ed9t sao cho ch\u1eef h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u01b0\u1ee3c \u0111\u00f3ng khung v\u00e0 ngay khi con tr\u1ecf \u0111\u1ed5i th\u00e0nh 4 m\u0169i t\u00ean, th\u00ec h\u00e3y k\u00e9o h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u1ebfn v\u1ecb tr\u00ed mong mu\u1ed1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6595 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/305-300x79-1.png\" width=\"300\" height=\"79\" title=\"305-300x79-1\"><\/p>\n<p>\u0110\u1ec3 x\u00f3a ch\u1eef \u2018H\u1ed9p \u0111\u00e1nh d\u1ea5u 1\u2019, nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p \u0111\u00e1nh d\u1ea5u, ch\u1ecdn k\u00fd t\u1ef1 r\u1ed3i ch\u1ecdn x\u00f3a. Hay, h\u00e3y nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o h\u1ed9p \u0111\u00e1nh d\u1ea5u, ch\u1ecdn Ch\u1ec9nh s\u1eeda K\u00fd t\u1ef1 trong b\u1ea3ng ch\u1ecdn k\u00fd t\u1ef1, r\u1ed3i x\u00f3a k\u00fd t\u1ef1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6596 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/306-300x191-1.png\" width=\"300\" height=\"191\" title=\"306-300x191-1\"><\/p>\n<p>H\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u1ea7u ti\u00ean trong Excel \u0111\u00e3 s\u1eb5n s\u00e0ng, b\u1ea1n ch\u1ec9 c\u1ea7n sao ch\u00e9p n\u00f3 v\u00e0o c\u00e1c \u00f4 kh\u00e1c.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"SAO_CHEP_HOP_DANH_DAU_VAO_CAC_O_KHAC\"><\/span>SAO CH\u00c9P H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u00c0O C\u00c1C \u00d4 KH\u00c1C<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Ch\u1ecdn \u00f4 c\u00f3 h\u1ed9p \u0111\u00e1nh d\u1ea5u b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00e1c ph\u00edm m\u0169i t\u00ean tr\u00ean b\u00e0n ph\u00edm r\u1ed3i \u0111\u1eb7t con tr\u1ecf \u1edf g\u00f3c ph\u1ea3i b\u00ean d\u01b0\u1edbi \u00f4. Khi con tr\u1ecf thay \u0111\u1ed5i th\u00e0nh d\u1ea5u c\u1ed9ng m\u00e0u \u0111en \u0111\u1eadm, h\u00e3y k\u00e9o n\u00f3 \u0111\u1ebfn \u00f4 cu\u1ed1i c\u00f9ng n\u01a1i m\u00e0 b\u1ea1n mu\u1ed1n sao ch\u00e9p h\u1ed9p \u0111\u00e1nh d\u1ea5u.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6598 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/307-1-300x170-1.png\" width=\"300\" height=\"170\" title=\"307-1-300x170-1\"><\/p>\n<p>Xong r\u1ed3i! H\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u00e3 c\u00f3 \u0111\u1ea7y \u0111\u1ee7 danh s\u00e1ch c\u00e1c m\u1ee5c c\u1ea7n ki\u1ec3m tra:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6599 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/308.png\" width=\"236\" height=\"241\" title=\"308\"><\/p>\n<p>Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean, danh s\u00e1ch c\u00e1c m\u1ee5c c\u1ea7n ki\u1ec3m tra trong Excel g\u1ea7n nh\u01b0 s\u1eafp xong r\u1ed3i. T\u1ea1i sao l\u1ea1i l\u00e0 g\u1ea7n nh\u01b0? M\u1eb7c d\u00f9 c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u00e3 \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn hay b\u1ecf ch\u1ecdn ch\u00fang, nh\u01b0ng Microsoft Excel kh\u00f4ng c\u00f3 kh\u1ea3 n\u0103ng nh\u1eadn bi\u1ebft c\u00e1c thay \u0111\u1ed5i n\u00e0y b\u1edfi v\u00ec c\u00e1c \u00f4 v\u1eabn ch\u01b0a \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u1edbi c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u.<\/p>\n<p>Ph\u1ea7n ti\u1ebfp theo trong b\u00e0i h\u01b0\u1edbng d\u1eabn h\u1ed9p \u0111\u00e1nh d\u1ea5u trong Excel s\u1ebd ch\u1ec9 b\u1ea1n c\u00e1ch l\u01b0u gi\u1eef ng\u01b0\u1eddi d\u00f9ng \u2013 ng\u01b0\u1eddi \u0111\u00e3 ch\u1ecdn hay b\u1ecf ch\u1ecdn m\u1ed9t h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0 c\u00e1ch d\u00f9ng th\u00f4ng tin \u0111\u00f3 trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"VI_DU_VE_VIEC_SU_DUNG_HOP_DANH_DAU_TRONG_EXCEL\"><\/span>V\u00cd D\u1ee4 V\u1ec0 VI\u1ec6C S\u1eec D\u1ee4NG H\u1ed8P \u0110\u00c1NH D\u1ea4U TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Khi \u0111\u00e3 bi\u1ebft c\u00e1ch t\u1ea1o \u00f4 tick trong Excel, h\u00e3y th\u1eed xem qua m\u1ed9t s\u1ed1 tr\u01b0\u1eddng h\u1ee3p s\u1eed d\u1ee5ng n\u00f3 nh\u00e9. B\u00ean d\u01b0\u1edbi, b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y v\u00e0i v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng h\u1ed9p \u0111\u00e1nh d\u1ea5u trong Excel \u0111\u1ec3 t\u1ea1o danh s\u00e1ch c\u00e1c m\u1ee5c c\u1ea7n ki\u1ec3m tra, danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n l\u00e0m, b\u1ea3ng b\u00e1o c\u00e1o hay bi\u1ec3u \u0111\u1ed3 mang t\u00ednh t\u01b0\u01a1ng t\u00e1c. Nh\u01b0ng tr\u01b0\u1edbc h\u1ebft, h\u00e3y h\u1ecdc c\u00e1ch li\u00ean k\u1ebft c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u1edbi c\u00e1c \u00f4. K\u1ef9 thu\u1eadt r\u1ea5t \u0111\u01a1n gi\u1ea3n, nh\u01b0ng n\u00f3 l\u1ea1i l\u00e0 n\u1ec1n t\u1ea3ng c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng k\u1ebft qu\u1ea3 t\u1eeb h\u1ed9p \u0111\u00e1nh d\u1ea5u trong c\u00f4ng th\u1ee9c c\u1ee7a b\u1ea1n.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CACH_LIEN_KET_HOP_DANH_DAU_VOI_O\"><\/span>C\u00c1CH LI\u00caN K\u1ebeT H\u1ed8P \u0110\u00c1NH D\u1ea4U V\u1edaI \u00d4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Nh\u01b0 \u0111\u00e3 \u0111\u1ec1 c\u1eadp t\u1eeb tr\u01b0\u1edbc, \u0111\u1ec3 c\u00f3 kh\u1ea3 n\u0103ng l\u01b0u gi\u1eef t\u00ecnh tr\u1ea1ng h\u1ed9p \u0111\u00e1nh d\u1ea5u (\u0111\u01b0\u1ee3c ch\u1ecdn hay b\u1ecf ch\u1ecdn) b\u1ea1n c\u1ea7n ph\u1ea3i li\u00ean k\u1ebft h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u1edbi m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh. \u0110\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>Nh\u1ea5p chu\u1ed9t ph\u1ea3i v\u00e0o \u00f4 \u0111\u00e1nh d\u1ea5u, r\u1ed3i nh\u1ea5p Format Control.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6600 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/309-300x188-1.png\" width=\"300\" height=\"188\" title=\"309-300x188-1\"><\/p>\n<p>Trong h\u1ed9p h\u1ed9i tho\u1ea1i Format Control, h\u00e3y \u0111\u1ed5i th\u00e0nh Control tab, nh\u1ea5p v\u00e0o h\u1ed9p Cell link r\u1ed3i ch\u1ecdn m\u1ed9t \u00f4 tr\u1ed1ng tr\u00ean trang t\u00ednh \u2013 \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n li\u00ean k\u1ebft v\u1edbi h\u1ed9p \u0111\u00e1nh d\u1ea5u, hay nh\u1eadp tham chi\u1ebfu \u00f4 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6601 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/310-300x264-1.png\" width=\"300\" height=\"264\" title=\"310-300x264-1\"><\/p>\n<p>L\u1eb7p l\u1ea1i c\u00e1c b\u01b0\u1edbc tr\u00ean \u0111\u1ed1i v\u1edbi c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u kh\u00e1c.<\/p>\n<p>M\u1eb9o. \u0110\u1ec3 x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng, h\u00e3y ch\u1ecdn ch\u00fang \u1edf c\u1ed9t k\u1ebf b\u00ean \u2013 c\u1ed9t kh\u00f4ng ch\u1ee9a d\u1eef li\u1ec7u n\u00e0o. B\u1eb1ng c\u00e1ch n\u00e0y, b\u1ea1n c\u00f3 th\u1ec3 \u1ea9n c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft m\u1ed9t c\u00e1ch an to\u00e0n \u0111\u1ec3 ch\u00fang kh\u00f4ng c\u1ea3n tr\u1edf trang t\u00ednh c\u1ee7a b\u1ea1n.<\/p>\n<p>Cu\u1ed1i c\u00f9ng, h\u00e3y nh\u1ea5p v\u00e0o m\u1ed7i h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u00e3 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft. Trong c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft, TRUE xu\u1ea5t hi\u1ec7n khi c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u01b0\u1ee3c ch\u1ecdn, v\u00e0 FALSE xu\u1ea5t hi\u1ec7n khi c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u c\u00f2n tr\u1ed1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6602 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/311.png\" width=\"295\" height=\"241\" title=\"311\"><\/p>\n<p>\u1ede th\u1eddi \u0111i\u1ec3m n\u00e0y, c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft c\u00f3 l\u1ebd ch\u1eb3ng c\u00f2n t\u00e1c d\u1ee5ng g\u00ec n\u1eefa, nh\u01b0ng h\u00e3y ki\u00ean nh\u1eabn th\u00eam ch\u00fat n\u1eefa nh\u00e9 v\u00e0 b\u1ea1n s\u1ebd th\u1ea5y n\u00f3 s\u1ebd t\u1ea1o cho b\u1ea1n r\u1ea5t nhi\u1ec1u c\u01a1 h\u1ed9i.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CACH_TAO_DANH_SACH_NHUNG_VIEC_CAN_KIEM_TRA_TRONG_EXCEL_VOI_BANG_TOM_TAT_DU_LIEU\"><\/span>C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N KI\u1ec2M TRA TRONG EXCEL V\u1edaI B\u1ea2NG T\u00d3M T\u1eaeT D\u1eee LI\u1ec6U<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u1eadt ra, ch\u00fang ta \u0111\u00e3 l\u00e0m xong ph\u1ea7n ch\u00ednh c\u1ee7a nhi\u1ec7m v\u1ee5 b\u1eb1ng c\u00e1ch th\u00eam c\u00e1c h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0 li\u00ean k\u1ebft ch\u00fang v\u1edbi c\u00e1c \u00f4. B\u00e2y gi\u1edd, ch\u00fang ta ch\u1ec9 l\u1eadp v\u00e0i c\u00f4ng th\u1ee9c \u0111\u1ec3 t\u1ea1o b\u1ea3ng t\u00f3m t\u1eaft d\u1eef li\u1ec7u cho danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n ki\u1ec3m tra trong Excel.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONG_THUC_TINH_TONG_NHIEM_VU\"><\/span>C\u00d4NG TH\u1ee8C T\u00cdNH T\u1ed4NG NHI\u1ec6M V\u1ee4<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u00e2y l\u00e0 c\u00e1i d\u1ec5 nh\u1ea5t \u2013 h\u00e3y s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/tag\/ham-counta\">h\u00e0m COUNTA<\/a> \u0111\u1ec3 \u0111\u1ebfm s\u1ed1 \u00f4 tr\u1ed1ng trong danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n l\u00e0m:<\/p>\n<p>=COUNTA(A2:A12)<\/p>\n<p>Trong \u0111\u00f3, A2:A12 l\u00e0 c\u00e1c m\u1ee5c trong danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n ki\u1ec3m tra.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONG_THUC_TINH_SO_NHIEM_VU_DA_HOAN_THANH\"><\/span>C\u00d4NG TH\u1ee8C T\u00cdNH S\u1ed0 NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>M\u1ed9t nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh c\u00f3 ngh\u0129a l\u00e0 h\u1ed9p \u0111\u00e1nh d\u1ea5u \u0111\u01b0\u1ee3c ch\u1ecdn, c\u00f3 ngh\u0129a l\u00e0 gi\u00e1 tr\u1ecb TRUE trong \u00f4 li\u00ean k\u1ebft. V\u00ec th\u1ebf, h\u00e3y \u0111\u1ebfm t\u1ea5t c\u1ea3 gi\u00e1 tr\u1ecb TRUE b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c COUNTIF n\u00e0y:<\/p>\n<p>=COUNTIF(C2:C12,TRUE)<\/p>\n<p>Trong \u0111\u00f3, C2:C12 l\u00e0 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft.<\/p>\n<p>\u0110\u1ec3 khi\u1ebfn c\u00f4ng th\u1ee9c tr\u00f4ng th\u1eed th\u00e1ch h\u01a1n m\u1ed9t ch\u00fat, b\u1ea1n s\u1eed d\u1ee5ng h\u00e0m COUNTIFS thay v\u00ec h\u00e0m COUNTIF \u0111\u1ec3 ki\u1ec3m tra \u00f4 tr\u1ed1ng trong danh s\u00e1ch (c\u1ed9t A):<\/p>\n<p>=COUNTIFS(A2:A12, \u201c&lt;&gt;\u201d, C2:C12, TRUE)<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, n\u1ebfu b\u1ea1n x\u00f3a c\u00e1c m\u1ee5c c\u00f3 li\u00ean quan ra kh\u1ecfi danh s\u00e1ch ki\u1ec3m tra c\u1ee7a Excel, nh\u01b0ng l\u1ea1i kh\u00f4ng b\u1ecf ch\u1ecdn h\u1ed9p t\u01b0\u01a1ng \u1ee9ng, nh\u1eefng h\u1ed9p \u0111\u01b0\u1ee3c ch\u1ecdn \u0111\u00f3 s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c t\u00ednh.<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CONG_THUC_TINH_PHAN_TRAM_CAC_NHIEM_VU_DA_HOAN_THANH\"><\/span>C\u00d4NG TH\u1ee8C T\u00cdNH PH\u1ea6N TR\u0102M C\u00c1C NHI\u1ec6M V\u1ee4 \u0110\u00c3 HO\u00c0N TH\u00c0NH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 t\u00ednh ph\u1ea7n tr\u0103m c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh, h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m th\u00f4ng d\u1ee5ng n\u00e0y:<\/p>\n<p>M\u1ed9t ph\u1ea7n\/T\u1ed5ng = Ph\u1ea7n tr\u0103m<\/p>\n<p>Trong tr\u01b0\u1eddng h\u1ee3p c\u1ee7a ch\u00fang ta, h\u00e3y chia s\u1ed1 nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh cho t\u1ed5ng s\u1ed1 nhi\u1ec7m v\u1ee5, gi\u1ed1ng nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p>=COUNTIF(C2:C12,TRUE)\/COUNTA(A2:A12)<\/p>\n<p>\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y cho th\u1ea5y t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean khi \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng s\u1ebd ho\u1ea1t \u0111\u1ed9ng \u00a0nh\u01b0 th\u1ebf n\u00e0o:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6603 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/312-300x198-1.png\" width=\"300\" height=\"198\" title=\"312-300x198-1\"><\/p>\n<p>Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u1eeb \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean, ch\u00fang ta \u0111\u00e3 ch\u00e8n th\u00eam m\u1ed9t c\u00f4ng th\u1ee9c v\u00e0o \u00f4 B18. C\u00f4ng th\u1ee9c n\u00e0y \u0111\u01b0\u1ee3c d\u1ef1a tr\u00ean h\u00e0m IF \u2013 c\u00f4ng th\u1ee9c tr\u1ea3 v\u1ec1 \u201cYes\u201d n\u1ebfu s\u1ed1 nhi\u1ec7m v\u1ee5 ho\u00e0n th\u00e0nh b\u1eb1ng t\u1ed5ng s\u1ed1 nhi\u1ec7m v\u1ee5, n\u1ebfu kh\u00f4ng th\u00ec s\u1ebd tr\u1ea3 v\u1ec1 \u201cNo\u201d:<\/p>\n<p>=IF(B14=B15, \u201cYep!\u201d, \u201cNope :(\u201c)<\/p>\n<p>\u0110\u1ec3 th\u00eam th\u1eaft cho danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n ki\u1ec3m tra, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t v\u00e0i quy lu\u1eadt \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u2013 nh\u1eefng quy lu\u1eadt n\u00e0y s\u1ebd thay \u0111\u1ed5i m\u00e0u c\u1ee7a \u00f4 B18 t\u00f9y v\u00e0o gi\u00e1 tr\u1ecb c\u1ee7a n\u00f3.<\/p>\n<p>Khi xong r\u1ed3i, h\u00e3y \u1ea9n c\u1ed9t n\u00e0y c\u00f9ng v\u1edbi c\u00e1c \u00f4 li\u00ean k\u1ebft, v\u00e0 danh s\u00e1ch c\u00e1c vi\u1ec7c c\u1ea7n ki\u1ec3m tra trong Excel \u0111\u00e3 ho\u00e0n t\u1ea5t r\u1ed3i \u0111\u1ea5y!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6604 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/313-300x175-1.png\" width=\"300\" height=\"175\" title=\"313-300x175-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"THEM_NHIEU_MAU_DANH_SACH_NHUNG_VIEC_CAN_HOAN_THANH\"><\/span>TH\u00caM NHI\u1ec0U M\u1eaaU DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N HO\u00c0N TH\u00c0NH<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 nhanh ch\u00f3ng ch\u1ecdn c\u00e1c m\u1eabu danh s\u00e1ch trong Excel, h\u00e3y ch\u1ecdn File&gt;New, g\u00f5 \u201cdanh s\u00e1ch c\u1ea7n ki\u1ec3m tra\u201d v\u00e0o \u00f4 t\u00ecm ki\u1ebfm, r\u1ed3i nh\u1ea5p Enter.<\/p>\n<p>N\u1ebfu kh\u00f4ng c\u00f3 m\u1eabu n\u00e0o trong Excel \u0111\u00e1p \u1ee9ng nhu c\u1ea7u c\u1ee7a b\u1ea1n, th\u00ec c\u00f3 l\u1ebd b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y c\u00e1i b\u1ea1n mu\u1ed1n trong c\u00e1c ngu\u1ed3n h\u1eefu \u00edch b\u00ean d\u01b0\u1edbi:<\/p>\n<h2><span class=\"ez-toc-section\" id=\"CACH_TAO_DANH_SACH_NHUNG_VIEC_CAN_LAM_CUNG_VOI_DINH_DANG_CO_DIEU_KIEN\"><\/span>C\u00c1CH T\u1ea0O DANH S\u00c1CH NH\u1eeeNG VI\u1ec6C C\u1ea6N L\u00c0M C\u00d9NG V\u1edaI \u0110\u1ecaNH D\u1ea0NG C\u00d3 \u0110I\u1ec0U KI\u1ec6N<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1ec1 c\u01a1 b\u1ea3n, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0 c\u00f4ng th\u1ee9c cho danh s\u00e1ch nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m theo c\u00e1ch m\u00e0 b\u1ea1n \u0111\u00e3 th\u1ef1c hi\u1ec7n v\u1edbi danh s\u00e1ch c\u1ea7n ki\u1ec3m tra. B\u1ea1n c\u00f3 th\u1ec3 h\u1ecfi t\u00f4i, \u201cV\u1eady vi\u1ebft ph\u1ea7n n\u00e0y \u0111\u1ec3 l\u00e0m g\u00ec?\u201d \u00c0 th\u00ec, trong m\u1ed9t danh s\u00e1ch nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m th\u00f4ng th\u01b0\u1eddng, nh\u1eefng nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh s\u1ebd \u0111\u01b0\u1ee3c g\u1ea1ch ngang nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6605 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/314.png\" width=\"209\" height=\"141\" title=\"314\"><\/p>\n<p>B\u1ea1n c\u00f3 th\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c hi\u1ec7u \u1ee9ng n\u00e0y m\u1ed9t c\u00e1ch d\u1ec5 d\u00e0ng b\u1eb1ng c\u00e1ch t\u1ea1o quy lu\u1eadt \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. D\u01b0\u1edbi \u0111\u00e2y l\u00e0 c\u00e1c b\u01b0\u1edbc chi ti\u1ebft.<\/p>\n<p>\u0110\u1ec3 b\u1eaft \u0111\u1ea7u, h\u00e3y vi\u1ebft danh s\u00e1ch c\u00e1c nhi\u1ec7m v\u1ee5, ch\u00e8n h\u1ed9p \u0111\u00e1nh d\u1ea5u r\u1ed3i li\u00ean k\u1ebft ch\u00fang v\u1edbi c\u00e1c \u00f4:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6606 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/315-300x225-1.png\" width=\"300\" height=\"225\" title=\"315-300x225-1\"><\/p>\n<p>V\u00e0 b\u00e2y gi\u1edd, h\u00e3y \u00e1p d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u2013 c\u00e1i m\u00e0 s\u1ebd cho b\u1ea1n \u0111\u1ecbnh d\u1ea1ng g\u1ea1ch ngang v\u00e0, t\u00f9y \u00fd, m\u00e0u h\u00ecnh n\u1ec1n hay ph\u00f4ng ch\u1eef kh\u00e1c \u0111\u1ed1i v\u1edbi c\u00e1c m\u1ee5c \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>Ch\u1ecdn danh s\u00e1ch c\u00e1c nhi\u1ec7m v\u1ee5 (trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 A2:A11).<\/p>\n<p>\u0110i \u0111\u1ebfn tab Home&gt;nh\u00f3m Styles, r\u1ed3i ch\u1ecdn Conditional Formatting&gt;New Rule\u2026<\/p>\n<p>Trong h\u1ed9p h\u1ed9i tho\u1ea1i New Formatting Rule, h\u00e3y ch\u1ecdn Use a formula to determine which cells to format.<\/p>\n<p>Trong h\u1ed9p Format values where this formula is true, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c sau:<\/p>\n<p>=$C2=TRUE<\/p>\n<p>Trong \u0111\u00f3, C2 l\u00e0 \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft tr\u00ean c\u00f9ng.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6607 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/316-300x288-1.png\" width=\"300\" height=\"288\" title=\"316-300x288-1\"><\/p>\n<p>Nh\u1ea5n n\u00fat Format, c\u00e0i \u0111\u1eb7t phong c\u00e1ch \u0111\u1ecbnh d\u1ea1ng mong mu\u1ed1n, r\u1ed3i nh\u1ea5p OK. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta ch\u1ecdn hi\u1ec7u \u1ee9ng Strikethrough v\u00e0 m\u00e0u ph\u00f4ng ch\u1eef l\u00e0 x\u00e1m nh\u1ea1t:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6608 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/317-300x249-1.png\" width=\"300\" height=\"249\" title=\"317-300x249-1\"><\/p>\n<p>B\u00e2y gi\u1edd, khi m\u1ed9t \u00f4 nh\u1ea5t \u0111\u1ecbnh \u0111\u01b0\u1ee3c ch\u1ecdn, m\u1ee5c t\u01b0\u01a1ng \u1ee9ng \u0111\u01b0\u1ee3c \u0111\u1ecbnh d\u1ea1ng th\u00e0nh m\u00e0u x\u00e1m nh\u1ea1t v\u00e0 \u0111\u01b0\u1ee3c g\u1ea1ch ngang.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6609 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/318-300x228-1.png\" width=\"300\" height=\"228\" title=\"318-300x228-1\"><\/p>\n<p>V\u00e0 sau \u0111\u00e2y, th\u00eam m\u1ed9t \u00fd t\u01b0\u1edfng m\u1edbi v\u1ec1 vi\u1ec7c \u0111\u1ecbnh d\u1ea1ng danh s\u00e1ch c\u1ea7n ki\u1ec3m tra trong Excel. Thay v\u00ec g\u1ea1ch ngang c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh, b\u1ea1n c\u00f3 th\u1ec3 ch\u00e8n th\u00eam m\u1ed9t c\u1ed9t c\u00f9ng v\u1edbi h\u00e0m IF:<\/p>\n<p>=IF(E2=TRUE, \u201c\u0110\u00e3 xong\u201d, \u201cCh\u01b0a xong\u201d)<\/p>\n<p>Trong \u0111\u00f3, E2 l\u00e0 \u00f4 li\u00ean k\u1ebft n\u1eb1m tr\u00ean c\u00f9ng.<\/p>\n<p>Nh\u01b0 \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y, c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 k\u1ebft qu\u1ea3 \u201c\u0110\u00e3 xong\u201d n\u1ebfu \u00f4 li\u00ean k\u1ebft ch\u1ee9a gi\u00e1 tr\u1ecb TRUE, k\u1ebft qu\u1ea3 \u201cCh\u01b0a xong\u201d n\u1ebfu ch\u1ee9a gi\u00e1 tr\u1ecb FALSE:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6610 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/319-300x111-1.png\" width=\"300\" height=\"111\" title=\"319-300x111-1\"><\/p>\n<p>Sau \u0111\u00f3, h\u00e3y s\u1eed d\u1ee5ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n mong mu\u1ed1n cho c\u1ed9t T\u00ecnh tr\u1ea1ng d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c n\u00e0y:<\/p>\n<p>=$C2=\u201d\u0110\u00e3 xong\u201d<\/p>\n<p>K\u1ebft qu\u1ea3 s\u1ebd tr\u00f4ng nh\u01b0 th\u1ebfn\u00e0y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6611 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/320-300x240-1.png\" width=\"300\" height=\"240\" title=\"320-300x240-1\"><\/p>\n<p>Cu\u1ed1i c\u00f9ng, h\u00e3y th\u00eam v\u00e0i c\u00f4ng th\u1ee9c t\u00ednh c\u00e1c nhi\u1ec7m v\u1ee5 \u0111\u00e3 ho\u00e0n th\u00e0nh (gi\u1ed1ng nh\u01b0 nh\u1eefng g\u00ec ta \u0111\u00e3 th\u1ef1c hi\u1ec7n \u0111\u1ed1i v\u1edbi danh s\u00e1ch c\u1ea7n ki\u1ec3m tra), h\u00e3y \u1ea9n c\u00e1c \u00f4 li\u00ean k\u1ebft, v\u00e0 danh s\u00e1ch nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m trong Excel c\u1ee7a b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6612 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/321-300x271-1.png\" width=\"300\" height=\"271\" title=\"321-300x271-1\"><\/p>\n<p>Bi\u1ec3u \u0111\u1ed3 c\u1ed9t n\u1eb1m tr\u00ean c\u00f9ng danh s\u00e1ch nh\u1eefng vi\u1ec7c c\u1ea7n l\u00e0m \u0111\u01b0\u1ee3c d\u1ef1a tr\u00ean c\u00f4ng th\u1ee9c ph\u1ea7n tr\u0103m trong \u00f4 B2.<\/p>\n<blockquote>\n<p><a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\">H\u01b0\u1edbng d\u1eabn h\u1ecdc Excel 2020<\/a><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"CACH_DUNG_HOP_DANH_DAU_TAO_BANG_BAO_CAO_MANG_TINH_TUONG_TAC\"><\/span>C\u00c1CH D\u00d9NG H\u1ed8P \u0110\u00c1NH D\u1ea4U T\u1ea0O B\u1ea2NG B\u00c1O C\u00c1O MANG T\u00cdNH T\u01af\u01a0NG T\u00c1C<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f4ng d\u1ee5ng h\u1eefu \u00edch kh\u00e1c c\u1ee7a h\u1ed9p \u0111\u00e1nh d\u1ea5u trong Excel \u0111\u00f3 l\u00e0 t\u1ea1o b\u1ea3ng b\u00e1o c\u00e1o mang t\u00ednh t\u01b0\u01a1ng t\u00e1c.<\/p>\n<p>Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u1ea3ng b\u00e1o c\u00e1o doanh thu c\u1ee7a 4 v\u00f9ng: B\u1eafc, Nam, \u0110\u00f4ng v\u00e0 T\u00e2y. M\u1ee5c \u0111\u00edch c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh t\u1ed5ng c\u1ee7a m\u1ed9t hay nhi\u1ec1u v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn. T\u1ea5t nhi\u00ean, vi\u1ec7c n\u00e0y c\u00f3 th\u1ec3 ho\u00e0n th\u00e0nh b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng t\u00ednh n\u0103ng Slicer c\u1ee7a b\u1ea3ng Excel hay PivotTable, hay b\u1eb1ng c\u00e1ch th\u00eam t\u1ed5ng c\u1ee7a t\u1eebng v\u00f9ng. Nh\u01b0ng t\u1ea1i sao ch\u00fang ta l\u1ea1i kh\u00f4ng t\u1ea1o b\u1ea3ng b\u00e1o c\u00e1o mang t\u00ednh t\u01b0\u01a1ng t\u00e1c b\u1eb1ng c\u00e1ch ch\u00e8n 4 h\u1ed9p \u0111\u00e1nh d\u1ea5u l\u00ean tr\u00ean c\u00f9ng?<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6613 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/322-300x206-1.png\" width=\"300\" height=\"206\" title=\"322-300x206-1\"><\/p>\n<p>Tr\u00f4ng \u0111\u1eb9p m\u1eaft, \u0111\u00fang kh\u00f4ng n\u00e0o? \u0110\u1ec3 t\u1ea1o ra b\u1ea3ng b\u00e1o c\u00e1o t\u01b0\u01a1ng t\u1ef1 tr\u00ean trang t\u00ednh, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>Th\u00eam 4 h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0o \u0111\u1ea7u trang t\u00ednh, cho c\u00e1c khu v\u1ef1c mi\u1ec1n B\u1eafc, Nam, \u0110\u00f4ng v\u00e0 T\u00e2y.<\/p>\n<p>T\u1ea1o v\u00f9ng \u0111i\u1ec1u ki\u1ec7n tr\u00ean b\u1ea5t k\u1ef3 ph\u1ea7n n\u00e0o ch\u01b0a \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng c\u1ee7a trang t\u00ednh, r\u1ed3i li\u00ean k\u1ebft h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u1edbi c\u00e1c \u00f4 tr\u1ed1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6614 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/323-300x85-1.png\" width=\"300\" height=\"85\" title=\"323-300x85-1\"><\/p>\n<p>Trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh tr\u00ean, I2:I5 l\u00e0 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft v\u00e0 H2:H5 ch\u00ednh l\u00e0 t\u00ean c\u00e1c v\u00f9ng c\u0169ng gi\u1ed1ng nh\u01b0 t\u00ean c\u1ee7a ch\u00fang trong b\u1ea3ng b\u00e1o c\u00e1o.<\/p>\n<p>Th\u00eam m\u1ed9t c\u1ed9t n\u1eefa cho v\u00f9ng \u0111i\u1ec1u ki\u1ec7n c\u00f3 c\u00f4ng th\u1ee9c IF \u2013 c\u00f4ng th\u1ee9c n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 t\u00ean v\u00f9ng n\u1ebfu \u00f4 li\u00ean k\u1ebft c\u00f3 gi\u00e1 tr\u1ecb TRUE, n\u1ebfu kh\u00f4ng th\u00ec l\u00e0 d\u1ea5u g\u1ea1ch ngang (\u201c-\u201c):<\/p>\n<p>=IF(I2=TRUE, H2, \u201c-\u201c)<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6615 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/324-300x100-1.png\" width=\"300\" height=\"100\" title=\"324-300x100-1\"><\/p>\n<p>G\u00f5 ti\u00eau \u0111\u1ec1 cho c\u1ed9t c\u00f4ng th\u1ee9c \u2013 ti\u00eau \u0111\u1ec1 ph\u1ea3i kh\u1edbp v\u1edbi ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t t\u01b0\u01a1ng \u1ee9ng trong b\u1ea3ng b\u00e1o c\u00e1o (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 c\u1ed9t Khu v\u1ef1c). S\u1ef1 tr\u00f9ng kh\u1edbp r\u1ea5t quan tr\u1ecdng v\u00e0 \u1edf b\u01b0\u1edbc ti\u1ebfp theo, b\u1ea1n s\u1ebd hi\u1ec3u l\u00fd do.<\/p>\n<p>Ti\u1ebfp theo, h\u00e3y l\u1eadp c\u00f4ng th\u1ee9c t\u00ednh t\u1ed5ng c\u00e1c v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn. V\u1ec1 vi\u1ec7c n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m DSUM \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong c\u01a1 s\u1edf d\u1eef li\u1ec7u \u2013 c\u00e1c gi\u00e1 tr\u1ecb \u0111\u00e1p \u1ee9ng \u0111i\u1ec1u ki\u1ec7n x\u00e1c \u0111\u1ecbnh:<\/p>\n<p>DSUM(database, field, criteria)<\/p>\n<p>Trong \u0111\u00f3:<\/p>\n<p>Database l\u00e0 b\u1ea3ng hay d\u1ea3i \u00f4 c\u1ee7a b\u1ea1n bao g\u1ed3m ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t (trong v\u00ed d\u1ee5 n\u00e0y l\u00e0 A5:F48).<\/p>\n<p>Field l\u00e0 c\u1ed9t m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng. B\u1ea1n c\u00f3 th\u1ec3 nh\u1eadp n\u00f3 ho\u1eb7c d\u01b0\u1edbi d\u1ea1ng ti\u00eau \u0111\u1ec1 c\u1ed9t \u0111\u00f3ng khung trong d\u1ea5u ngo\u1eb7c k\u00e9p, ho\u1eb7c m\u1ed9t con s\u1ed1 n\u00f3i l\u00ean v\u1ecb tr\u00ed c\u1ee7a c\u1ed9t trong c\u01a1 s\u1edf d\u1eef li\u1ec7u. Trong v\u00ed d\u1ee5 n\u00e0y, ch\u00fang ta t\u00ednh t\u1ed5ng trong c\u1ed9t T\u1ed5ng t\u1eebng khu v\u1ef1c, n\u00ean c\u00e2u l\u1ec7nh th\u1ee9 hai c\u1ee7a ch\u00fang ta l\u00e0 \u201cT\u1ed5ng t\u1eebng khu v\u1ef1c\u201d.<\/p>\n<p>Criteria l\u00e0 d\u1ea3i \u00f4 ch\u1ee9a \u0111i\u1ec1u ki\u1ec7n, bao g\u1ed3m ti\u00eau \u0111\u1ec1 c\u1ed9t (J1:J5). \u0110\u00e2y l\u00e0 l\u00fd do t\u1ea1i sao ti\u00eau \u0111\u1ec1 c\u1ee7a c\u1ed9t c\u00f4ng th\u1ee9c trong v\u00f9ng \u0111i\u1ec1u ki\u1ec7n n\u00ean kh\u1edbp v\u1edbi ti\u00eau \u0111\u1ec1 c\u1ed9t trong b\u1ea3ng b\u00e1o c\u00e1o.<\/p>\n<p>K\u1ebft h\u1ee3p c\u00e1c c\u00e2u l\u1ec7nh tr\u00ean, v\u00e0 c\u00f4ng th\u1ee9c DSUM c\u1ee7a b\u1ea1n c\u00f3 d\u1ea1ng nh\u01b0 sau:<\/p>\n<p>=DSUM(A5:F48, \u201ct\u1ed5ng t\u1eebng v\u00f9ng\u201d, J1:J5)<\/p>\n<p>v\u00e0 ch\u1ea1y m\u1ed9t c\u00e1ch ho\u00e0n h\u1ea3o!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6616 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/325-300x124-1.png\" width=\"300\" height=\"124\" title=\"325-300x124-1\"><\/p>\n<p>N\u1ebfu b\u00ean c\u1ea1nh vi\u1ec7c t\u00ednh t\u1ed5ng, b\u1ea3ng b\u00e1o c\u00e1o c\u1ee7a b\u1ea1n c\u00f2n t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh m\u1ed7i h\u00e0ng, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m DAVERAGE (database, field, criteria) \u0111\u1ec3 t\u00ednh doanh thu trung b\u00ecnh c\u1ee7a c\u00e1c v\u00f9ng \u0111\u01b0\u1ee3c ch\u1ecdn.<\/p>\n<p>Cu\u1ed1i c\u00f9ng, h\u00e3y \u1ea9n, c\u00f3 l\u1ebd l\u00e0 kh\u00f3a v\u00f9ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 tr\u00e1nh c\u00e1c thay \u0111\u1ed5i ng\u1eabu nhi\u00ean, v\u00e0 b\u1ea3ng b\u00e1o c\u00e1o mang t\u00ednh t\u01b0\u01a1ng t\u00e1c c\u1ee7a b\u1ea1n \u0111\u00e3 xong r\u1ed3i \u0111\u1ea5y!<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6617 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/326-300x164-1.png\" width=\"300\" height=\"164\" title=\"326-300x164-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"TAO_BIEU_DO_SINH_DONG_DUA_TREN_TINH_TRANG_HOP_DANH_DAU\"><\/span>T\u1ea0O BI\u1ec2U \u0110\u1ed2 SINH \u0110\u1ed8NG D\u1ef0A TR\u00caN T\u00ccNH TR\u1ea0NG H\u1ed8P \u0110\u00c1NH D\u1ea4U<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ed d\u1ee5 n\u00e0y s\u1ebd ch\u1ec9 b\u1ea1n c\u00e1ch t\u1ea1o bi\u1ec3u \u0111\u1ed3 sinh \u0111\u1ed9ng trong Excel \u2013 bi\u1ec3u \u0111\u1ed3 s\u1ebd thay \u0111\u1ed5i theo t\u00ecnh tr\u1ea1ng c\u1ee7a h\u1ed9p \u0111\u00e1nh d\u1ea5u (ch\u1ecdn hay b\u1ecf ch\u1ecdn):<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6618 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/327-300x112-1.png\" width=\"300\" height=\"112\" title=\"327-300x112-1\"><\/p>\n<p>D\u1eef li\u1ec7u ngu\u1ed3n cho v\u00ed d\u1ee5 n\u00e0y \u0111\u01a1n gi\u1ea3n nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6619 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/328.png\" width=\"206\" height=\"101\" title=\"328\"><\/p>\n<p>\u0110\u1ec3 bi\u1ebfn n\u00f3 th\u00e0nh m\u1ed9t bi\u1ec3u \u0111\u1ed3 Excel sinh \u0111\u1ed9ng, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p>T\u1ea1o h\u1ed9p \u0111\u00e1nh d\u1ea5u v\u00e0 li\u00ean k\u1ebft ch\u00fang v\u1edbi c\u00e1c \u00f4 tr\u1ed1ng.<\/p>\n<p>C\u1ee5 th\u1ec3, h\u00e3y ch\u00e8n 2 h\u1ed9p \u0111\u00e1nh d\u1ea5u cho n\u0103m 2013 v\u00e0 n\u0103m 2014, r\u1ed3i l\u1ea7n l\u01b0\u1ee3t li\u00ean k\u1ebft ch\u00fang v\u1edbi c\u00e1c \u00f4 G2 v\u00e0 G3:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6620 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/329-300x131-1.png\" width=\"300\" height=\"131\" title=\"329-300x131-1\"><\/p>\n<p>T\u1ea1o chu\u1ed7i d\u1eef li\u1ec7u cho bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u ngu\u1ed3n v\u00e0 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c li\u00ean k\u1ebft (h\u00e3y nh\u00ecn h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi):<\/p>\n<p>\u0110\u1ed1i v\u1edbi n\u0103m 2013 (J4:J7), h\u00e3y s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau:<\/p>\n<p>=IF($G$2=TRUE, B4, NA())<\/p>\n<p>N\u1ebfu h\u1ed9p \u0111\u00e1nh d\u1ea5u 2013 \u0111\u01b0\u1ee3c ch\u1ecdn (\u00f4 G2 c\u00f3 gi\u00e1 tr\u1ecb TRUE), th\u00ec c\u00f4ng th\u1ee9c s\u1ebd l\u1ea5y gi\u00e1 tr\u1ecb g\u1ed1c t\u1eeb \u00f4 B4, n\u1ebfu kh\u00f4ng th\u00ec c\u00f4ng th\u1ee9c s\u1ebd tr\u1ea3 v\u1ec1 l\u1ed7i #N\/A.<\/p>\n<p>\u0110\u1ed1i v\u1edbi n\u0103m 2014 (K4:K7), h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c t\u01b0\u01a1ng t\u1ef1 \u0111\u1ec3 l\u1ea5y c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t C n\u1ebfu h\u1ed9p \u0111\u00e1nh d\u1ea5u 2014 \u0111\u01b0\u1ee3c ch\u1ecdn:<\/p>\n<p>=IF($G$2=TRUE, C4, NA())<\/p>\n<p>\u1ede \u00f4 L4, h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c\u00a0=$D4, r\u1ed3i sao ch\u00e9p v\u00e0o \u00f4 L7. B\u1edfi v\u00ec d\u1eef li\u1ec7u cho n\u0103m 2015 n\u00ean lu\u00f4n \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb trong bi\u1ec3u \u0111\u1ed3,v\u00e0 c\u00f4ng th\u1ee9c IF kh\u00f4ng c\u1ea7n thi\u1ebft cho c\u1ed9t n\u00e0y.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6621 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/330-300x98-1.png\" width=\"300\" height=\"98\" title=\"330-300x98-1\"><\/p>\n<p>H\u00e3y t\u1ea1o bi\u1ec3u \u0111\u1ed3 k\u1ebft h\u1ee3p d\u1ef1a tr\u00ean chu\u1ed7i d\u1eef li\u1ec7u ph\u1ee5 thu\u1ed9c (I3:L7). V\u00ec ch\u00fang ta \u0111\u00e3 li\u00ean k\u1ebft t\u1ea5t c\u1ea3 c\u00e1c \u00f4 trong b\u1ea3ng ph\u1ee5 thu\u1ed9c v\u1edbi d\u1eef li\u1ec7u ngu\u1ed3n, n\u00ean bi\u1ec3u \u0111\u1ed3 s\u1ebd t\u1ef1 \u0111\u1ed9ng c\u1eadp nh\u1eadt ngay khi chu\u1ed7i d\u1eef li\u1ec7u g\u1ed1c c\u00f3 b\u1ea5t k\u1ef3 s\u1ef1 thay \u0111\u1ed5i n\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6622 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/331-300x231-1.png\" width=\"300\" height=\"231\" title=\"331-300x231-1\"><\/p>\n<p>\u0110\u00e2y l\u00e0 c\u00e1ch t\u1ea1o \u00f4 tick trong Excel\/t\u1ea1o v\u00e0 s\u1eed d\u1ee5ng h\u1ed9p \u0111\u00e1nh d\u1ea5u trong Excel. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n v\u00ec \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y!<\/p>\n<p>\u2014\u2014\u2014<\/p>\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\/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-124.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1705,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1704","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\/1704","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=1704"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1704\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1705"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1704"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1704"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1704"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}