{"id":6539,"date":"2024-12-21T15:35:10","date_gmt":"2024-12-21T15:35:10","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel\/"},"modified":"2024-12-21T15:35:10","modified_gmt":"2024-12-21T15:35:10","slug":"cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/21\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel\/","title":{"rendered":"C\u00e1ch t\u00ecm ra \u0111i\u1ec3m kh\u00e1c bi\u1ec7t gi\u1eefa hai t\u1eadp tin trong Excel"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>Trong h\u01b0\u1edbng d\u1eabn n\u00e0y, H\u1ecdc Excel Online s\u1ebd gi\u1edbi thi\u1ec7u \u0111\u1ebfn c\u00e1c b\u1ea1n nhi\u1ec1u ph\u01b0\u01a1ng ph\u00e1p \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel v\u00e0 x\u00e1c \u0111\u1ecbnh s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang. Ngo\u00e0i ra c\u00f2n c\u00f3 c\u00e1ch m\u1edf hai c\u1eeda s\u1ed5 Excel c\u1ea1nh nhau, c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c Excel \u0111\u1ec3 t\u1ea1o b\u00e1o c\u00e1o kh\u00e1c bi\u1ec7t, l\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n v\u00e0 h\u01a1n th\u1ebf n\u1eefa.<\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Khi b\u1ea1n c\u00f3 hai b\u1ea3ng t\u00ednh Excel t\u01b0\u01a1ng t\u1ef1, ho\u1eb7c c\u00f3 th\u1ec3 n\u00f3i l\u00e0 hai phi\u00ean b\u1ea3n c\u1ee7a c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh, \u0111i\u1ec1u \u0111\u1ea7u ti\u00ean b\u1ea1n mu\u1ed1n l\u00e0m v\u1edbi ch\u00fang l\u00e0 g\u00ec? Ph\u1ea3i, so s\u00e1nh c\u00e1c t\u1ec7p n\u00e0y \u0111\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c nh\u1eefng s\u1ef1 kh\u00e1c bi\u1ec7t, sau \u0111\u00f3 c\u00f3 th\u1ec3 h\u1ee3p nh\u1ea5t ch\u00fang v\u00e0o m\u1ed9t t\u1ec7p duy nh\u1ea5t. Ngo\u00e0i ra, so s\u00e1nh workbook c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n ph\u00e1t hi\u1ec7n c\u00e1c v\u1ea5n \u0111\u1ec1 ti\u1ec1m \u1ea9n nh\u01b0 li\u00ean k\u1ebft b\u1ecb h\u1ecfng, h\u1ed3 s\u01a1 tr\u00f9ng l\u1eb7p, c\u00e1c c\u00f4ng th\u1ee9c kh\u00f4ng ph\u00f9 h\u1ee3p ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng sai.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ec v\u1eady, ch\u00fang ta h\u00e3y c\u00f9ng xem x\u00e9t c\u00e1c ph\u01b0\u01a1ng ph\u00e1p kh\u00e1c nhau \u0111\u1ec3 so s\u00e1nh hai b\u1ea3ng t\u00ednh Excel ho\u1eb7c to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh v\u00e0 x\u00e1c \u0111\u1ecbnh s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang.<\/span><\/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-6766e02d5e990\" 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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Cach_so_sanh_hai_tap_tin_Excel_bang_cach_xem_song_song\" title=\"C\u00e1ch so s\u00e1nh hai t\u1eadp tin Excel b\u1eb1ng c\u00e1ch xem song song\">C\u00e1ch so s\u00e1nh hai t\u1eadp tin Excel b\u1eb1ng c\u00e1ch xem song song<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#So_sanh_2_bang_tinh_Excel\" title=\"So s\u00e1nh 2 b\u1ea3ng t\u00ednh Excel\">So s\u00e1nh 2 b\u1ea3ng t\u00ednh Excel<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#De_mo_hai_tep_Excel_canh_nhau_hay_lam_nhu_sau\" title=\"\u0110\u1ec3 m\u1edf hai t\u1ec7p Excel c\u1ea1nh nhau, h\u00e3y l\u00e0m nh\u01b0 sau:\">\u0110\u1ec3 m\u1edf hai t\u1ec7p Excel c\u1ea1nh nhau, h\u00e3y l\u00e0m nh\u01b0 sau:<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#So_sanh_hai_to_trong_cung_mot_bang_tinh\" title=\"So s\u00e1nh hai t\u1edd trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh\">So s\u00e1nh hai t\u1edd trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Cach_so_sanh_hai_to_Excel_de_tim_ra_cac_gia_tri_su_khac_biet\" title=\"C\u00e1ch so s\u00e1nh hai t\u1edd Excel \u0111\u1ec3 t\u00ecm ra c\u00e1c gi\u00e1 tr\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t\">C\u00e1ch so s\u00e1nh hai t\u1edd Excel \u0111\u1ec3 t\u00ecm ra c\u00e1c gi\u00e1 tr\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Lam_noi_bat_su_khac_biet_giua_2_to_voi_dinh_dang_co_dieu_kien\" title=\"L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 2 t\u1edd v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n\">L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 2 t\u1edd v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#So_sanh_va_hop_nhat_cac_ban_sao_cua_mot_bang_tinh_dung_chung\" title=\"So s\u00e1nh v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3n sao c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh d\u00f9ng chung\">So s\u00e1nh v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3n sao c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh d\u00f9ng chung<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Cac_cong_cu_khac_dung_de_so_sanh_cac_tep_Excel\" title=\"C\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c d\u00f9ng \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel\">C\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c d\u00f9ng \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#So_sanh_hai_tep_Excel_de_tim_su_khac_biet\" title=\"So s\u00e1nh hai t\u1ec7p Excel \u0111\u1ec3 t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t\">So s\u00e1nh hai t\u1ec7p Excel \u0111\u1ec3 t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#So_sanh_tat_ca_cac_bang_tinh_trong_hai_bang_tinh_cung_mot_luc\" title=\"So s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh trong hai b\u1ea3ng t\u00ednh c\u00f9ng m\u1ed9t l\u00fac\">So s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh trong hai b\u1ea3ng t\u00ednh c\u00f9ng m\u1ed9t l\u00fac<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Lam_noi_bat_su_khac_biet_giua_cac_trang\" title=\"L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c trang\">L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c trang<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Cap_nhat_va_hop_nhat_cac_trang\" title=\"C\u1eadp nh\u1eadt v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c trang\">C\u1eadp nh\u1eadt v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c trang<\/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\/cach-tim-ra-diem-khac-biet-giua-hai-tap-tin-trong-excel.html#Cac_dich_vu_truc_tuyen_de_so_sanh_cac_tep_Excel\" title=\"C\u00e1c d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel\">C\u00e1c d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cach_so_sanh_hai_tap_tin_Excel_bang_cach_xem_song_song\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch so s\u00e1nh hai t\u1eadp tin Excel b\u1eb1ng c\u00e1ch xem song song<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n kh\u00f4ng qu\u00e1 l\u1edbn v\u00e0 b\u1ea1n c\u00f3 kh\u1ea3 n\u0103ng xem x\u00e9t d\u1eef li\u1ec7u t\u1ed1t b\u1eb1ng m\u1eaft th\u01b0\u1eddng, c\u00e1ch nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel th\u00ec View Side by Side l\u00e0 l\u1ef1a ch\u1ecdn th\u00edch h\u1ee3p cho b\u1ea1n, n\u00f3 cho ph\u00e9p b\u1ea1n s\u1eafp x\u1ebfp hai c\u1eeda s\u1ed5 Excel c\u1ea1nh nhau. B\u1ea1n c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y \u0111\u1ec3 so s\u00e1nh tr\u1ef1c quan hai b\u1ea3ng t\u00ednh ho\u1eb7c hai trang trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_2_bang_tinh_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">So s\u00e1nh 2 b\u1ea3ng t\u00ednh Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 b\u00e1o c\u00e1o b\u00e1n h\u00e0ng trong hai th\u00e1ng v\u00e0 b\u1ea1n mu\u1ed1n xem c\u1ea3 hai b\u00e1o c\u00e1o \u0111\u00f3 c\u00f9ng m\u1ed9t l\u00fac \u0111\u1ec3 hi\u1ec3u s\u1ea3n ph\u1ea9m n\u00e0o ho\u1ea1t \u0111\u1ed9ng t\u1ed1t h\u01a1n trong th\u00e1ng n\u00e0y v\u00e0 th\u00e1ng tr\u01b0\u1edbc.<\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"De_mo_hai_tep_Excel_canh_nhau_hay_lam_nhu_sau\"><\/span><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 m\u1edf hai t\u1ec7p Excel c\u1ea1nh nhau, h\u00e3y l\u00e0m nh\u01b0 sau:<\/span><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. M\u1edf s\u1ed5 l\u00e0m vi\u1ec7c b\u1ea1n mu\u1ed1n so s\u00e1nh.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. V\u00e0o tab View &gt;Window, v\u00e0 nh\u1ea5p v\u00e0o View Side by Side.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7760\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/1-4-2.png\" width=\"480\" height=\"128\" title=\"1-4-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Theo m\u1eb7c \u0111\u1ecbnh, hai c\u1eeda s\u1ed5 Excel ri\u00eang bi\u1ec7t \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb theo chi\u1ec1u ngang.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 t\u00e1ch c\u1eeda s\u1ed5 Excel theo chi\u1ec1u d\u1ecdc, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Arrange All v\u00e0 ch\u1ecdn Vertical:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7761\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/2-4-2.png\" width=\"501\" height=\"375\" title=\"2-4-2\"><\/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-586.gif\" title=\"ex101_92019-nho-586\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><span style=\"font-family: 'Times New Roman', Times\">K\u1ebft qu\u1ea3 l\u00e0, hai c\u1eeda s\u1ed5 Excel ri\u00eang bi\u1ec7t s\u1ebd \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp c\u1ea1nh nhau, nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n mu\u1ed1n cu\u1ed9n qua c\u1ea3 hai b\u1ea3ng t\u00ednh c\u00f9ng m\u1ed9t l\u00fac \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u t\u1eebng h\u00e0ng, th\u00ec ph\u1ea3i b\u1eadt t\u00f9y ch\u1ecdn Synchronous Scrolling. Tu\u1ef3 ch\u1ecdn n\u00e0y n\u1eb1m tr\u00ean tab View tab &gt; Window, ngay b\u00ean d\u01b0\u1edbi n\u00fat View Side by Side v\u00e0 th\u01b0\u1eddng \u0111\u01b0\u1ee3c b\u1eadt t\u1ef1 \u0111\u1ed9ng ngay khi b\u1ea1n k\u00edch ho\u1ea1t Ch\u1ebf \u0111\u1ed9 View Side by Side.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7762\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/3-3-1.png\" width=\"497\" height=\"460\" title=\"3-3-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> S\u1eafp x\u1ebfp nhi\u1ec1u c\u1eeda s\u1ed5 Excel c\u1ea1nh nhau<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 xem nhi\u1ec1u h\u01a1n 2 t\u1ec7p Excel c\u00f9ng m\u1ed9t l\u00fac, h\u00e3y m\u1edf t\u1ea5t c\u1ea3 c\u00e1c t\u1ec7p m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh, v\u00e0 nh\u1ea5p v\u00e0o n\u00fat View Side by Side. H\u1ed9p tho\u1ea1i Compare Side by Side s\u1ebd xu\u1ea5t hi\u1ec7n, v\u00e0 b\u1ea1n ch\u1ecdn c\u00e1c t\u1ec7p s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb c\u00f9ng v\u1edbi b\u1ea3ng t\u00ednh \u0111ang ho\u1ea1t \u0111\u1ed9ng.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7763\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/4-4-1.png\" width=\"324\" height=\"236\" title=\"4-4-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 xem t\u1ea5t c\u1ea3 c\u00e1c t\u1ec7p Excel \u0111ang m\u1edf c\u00f9ng m\u1ed9t l\u00fac, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Arrange All tr\u00ean tab View &gt; Window v\u00e0 ch\u1ecdn s\u1eafp x\u1ebfp \u01b0a th\u00edch c\u1ee7a b\u1ea1n.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_hai_to_trong_cung_mot_bang_tinh\"><\/span><span style=\"font-family: 'Times New Roman', Times\">So s\u00e1nh hai t\u1edd trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00f4i khi, 2 t\u1edd m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh n\u1eb1m trong c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh. \u0110\u1ec3 xem ch\u00fang song song, h\u00e3y th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 1. M\u1edf t\u1ec7p Excel c\u1ee7a b\u1ea1n, v\u00e0o tab View &gt; Window, v\u00e0 nh\u1ea5p v\u00e0o New Window<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7764\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/5-4-1.png\" width=\"377\" height=\"132\" title=\"5-4-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Thao t\u00e1c n\u00e0y s\u1ebd m\u1edf t\u1ec7p Excel t\u01b0\u01a1ng t\u1ef1 trong m\u1ed9t c\u1eeda s\u1ed5 kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> B\u1eadt Ch\u1ebf \u0111\u1ed9 View Side by Side b\u1eb1ng c\u00e1ch nh\u1ea5p v\u00e0o n\u00fat t\u01b0\u01a1ng \u1ee9ng tr\u00ean thanh th\u1ef1c \u0111\u01a1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ch\u1ecdn trang 1 trong c\u1eeda s\u1ed5 \u0111\u1ea7u ti\u00ean v\u00e0 trang 2 trong c\u1eeda s\u1ed5 th\u1ee9 hai.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_so_sanh_hai_to_Excel_de_tim_ra_cac_gia_tri_su_khac_biet\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1ch so s\u00e1nh hai t\u1edd Excel \u0111\u1ec3 t\u00ecm ra c\u00e1c gi\u00e1 tr\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u00e2y l\u00e0 c\u00e1ch \u0111\u01a1n gi\u1ea3n nh\u1ea5t \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong Excel cho ph\u00e9p b\u1ea1n x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau. K\u1ebft qu\u1ea3 l\u00e0, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t t\u1ed5ng h\u1ee3p nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t trong m\u1ed9t b\u1ea3ng t\u00ednh m\u1edbi.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 so s\u00e1nh hai b\u1ea3ng t\u00ednh Excel nh\u1eb1m t\u00ecm ra s\u1ef1 kh\u00e1c bi\u1ec7t, ch\u1ec9 c\u1ea7n m\u1edf m\u1ed9t b\u1ea3ng tr\u1ed1ng m\u1edbi, nh\u1eadp c\u00f4ng th\u1ee9c sau v\u00e0o \u00f4 A1, v\u00e0 sau \u0111\u00f3 sao ch\u00e9p n\u00f3:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">=IF(Sheet1!A1&lt;&gt; Sheet2!A1, \u201cSheet1:\u201d&amp;Sheet1!A1&amp;\u201d vs Sheet2:\u201d&amp;Sheet2!A1, \u201c\u201d)<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">K\u1ebft qu\u1ea3 nh\u1eadn \u0111\u01b0\u1ee3c s\u1ebd gi\u1ed1ng nh\u01b0 sau:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7765\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/6-4-1.png\" width=\"623\" height=\"557\" title=\"6-4-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n th\u1ea5y trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh \u1edf tr\u00ean, c\u00f4ng th\u1ee9c so s\u00e1nh 2 t\u1edd, x\u00e1c \u0111\u1ecbnh c\u00e1c \u00f4 v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c v\u00e0 hi\u1ec3n th\u1ecb s\u1ef1 kh\u00e1c nhau trong c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng. Xin l\u01b0u \u00fd r\u1eb1ng trong m\u1ed9t s\u1ed1 b\u00e1o c\u00e1o kh\u00e1c, ng\u00e0y th\u00e1ng (\u00f4 C4) \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y theo s\u1ed1 s\u00ea-ri khi ch\u00fang \u0111\u01b0\u1ee3c l\u01b0u tr\u1eef trong h\u1ec7 th\u1ed1ng Excel, \u0111i\u1ec1u n\u00e0y kh\u00f4ng thu\u1eadn ti\u1ec7n trong vi\u1ec7c ph\u00e2n t\u00edch s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_noi_bat_su_khac_biet_giua_2_to_voi_dinh_dang_co_dieu_kien\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 2 t\u1edd v\u1edbi \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 l\u00e0m n\u1ed5i b\u1eadt c\u00e1c \u00f4 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau trong hai trang v\u1edbi m\u00e0u s\u1eafc b\u1ea1n ch\u1ecdn, h\u00e3y s\u1eed d\u1ee5ng t\u00ednh n\u0103ng \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n c\u1ee7a Excel:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong b\u1ea3ng t\u00ednh, n\u01a1i b\u1ea1n mu\u1ed1n l\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t, ch\u1ecdn t\u1ea5t c\u1ea3 c\u00e1c \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng. \u0110\u1ec3 l\u00e0m \u0111\u01b0\u1ee3c \u0111i\u1ec1u n\u00e0y, b\u1ea1n nh\u1ea5p v\u00e0o \u00f4 b\u00ean tr\u00e1i ph\u00eda tr\u00ean c\u1ee7a d\u1ea3i \u0111\u00e3 s\u1eed d\u1ee5ng, th\u01b0\u1eddng l\u00e0 A1 v\u00e0 nh\u1ea5n Ctrl + Shift + End \u0111\u1ec3 m\u1edf r\u1ed9ng v\u00f9ng l\u1ef1a ch\u1ecdn \u0111\u1ebfn \u00f4 \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng cu\u1ed1i c\u00f9ng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tr\u00ean tab Trang ch\u1ee7, trong nh\u00f3m Styles, ch\u1ecdn Conditional Formatting &gt; New rule, v\u00e0 t\u1ea1o quy t\u1eafc b\u1eb1ng c\u00f4ng th\u1ee9c sau:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> =A1&lt;&gt;Sheet2!A1<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong \u0111\u00f3 Sheet2 l\u00e0 t\u00ean c\u1ee7a trang t\u00ednh kh\u00e1c m\u00e0 b\u1ea1n \u0111ang so s\u00e1nh.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">K\u1ebft qu\u1ea3 l\u00e0 c\u00e1c \u00f4 c\u00f3 c\u00e1c gi\u00e1 tr\u1ecb kh\u00e1c nhau s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng m\u00e0u \u0111\u00e3 ch\u1ecdn:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7766\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/7-3-1.png\" width=\"571\" height=\"613\" title=\"7-3-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n th\u1ea5y, r\u1ea5t d\u1ec5 so s\u00e1nh hai b\u1ea3ng Excel b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng c\u00f3 \u0111i\u1ec1u ki\u1ec7n. Tuy nhi\u00ean, nh\u1eefng ph\u01b0\u01a1ng ph\u00e1p n\u00e0y kh\u00f4ng ph\u00f9 h\u1ee3p v\u1edbi vi\u1ec7c so s\u00e1nh to\u00e0n di\u1ec7n v\u00ec nh\u1eefng h\u1ea1n ch\u1ebf sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Ch\u00fang ch\u1ec9 t\u00ecm th\u1ea5y s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u00e1c gi\u00e1 tr\u1ecb, nh\u01b0ng kh\u00f4ng th\u1ec3 so s\u00e1nh c\u00f4ng th\u1ee9c ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng \u00f4.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Ch\u00fang kh\u00f4ng th\u1ec3 th\u00eam ho\u1eb7c x\u00f3a c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t. Ngay sau khi b\u1ea1n th\u00eam ho\u1eb7c xo\u00e1 m\u1ed9t h\u00e0ng \/ c\u1ed9t trong m\u1ed9t trang t\u00ednh, t\u1ea5t c\u1ea3 c\u00e1c h\u00e0ng \/ c\u1ed9t ti\u1ebfp theo s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u l\u00e0 kh\u00e1c bi\u1ec7t.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Ch\u00fang l\u00e0m vi\u1ec7c tr\u00ean m\u1ed9t b\u1ea3ng t\u00ednh, nh\u01b0ng kh\u00f4ng th\u1ec3 ph\u00e1t hi\u1ec7n s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ea5u tr\u00fac c\u1ea5p b\u1ea3ng t\u00ednh nh\u01b0 b\u1ed5 sung t\u1edd v\u00e0 x\u00f3a.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_va_hop_nhat_cac_ban_sao_cua_mot_bang_tinh_dung_chung\"><\/span><span style=\"font-family: 'Times New Roman', Times\">So s\u00e1nh v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3n sao c\u1ee7a m\u1ed9t b\u1ea3ng t\u00ednh d\u00f9ng chung<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Khi h\u1ee3p nh\u1ea5t c\u00e1c phi\u00ean b\u1ea3n kh\u00e1c nhau c\u1ee7a c\u00f9ng m\u1ed9t t\u1ec7p Excel, t\u00ednh n\u0103ng So s\u00e1nh v\u00e0 H\u1ee3p th\u1ef1c s\u1ef1 r\u1ea5t h\u1eefu \u00edch. N\u00f3 \u0111\u1eb7c bi\u1ec7t h\u1eefu \u00edch khi m\u1ed9t s\u1ed1 ng\u01b0\u1eddi d\u00f9ng c\u1ed9ng t\u00e1c l\u00e0m vi\u1ec7c tr\u00ean c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh Excel v\u00ec n\u00f3 cho ph\u00e9p b\u1ea1n xem c\u00e1c thay \u0111\u1ed5i v\u00e0 nh\u1eadn x\u00e9t c\u1ee7a t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng c\u00f9ng m\u1ed9t l\u00fac. \u0110\u1ec3 t\u1eadn d\u1ee5ng t\u00ednh n\u0103ng n\u00e0y, h\u00e3y \u0111\u1ea3m b\u1ea3o th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 Chia s\u1ebb b\u1ea3ng t\u00ednh Excel c\u1ee7a b\u1ea1n v\u1edbi nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 chia s\u1ebb m\u1ed9t b\u1ea3ng t\u00ednh, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o n\u00fat Share Workbook tr\u00ean tab Review, nh\u00f3m Changes, ch\u1ecdn Allow Changes by More Than One User\u2026 v\u00e0 nh\u1ea5p OK. Cho ph\u00e9p Excel l\u01b0u b\u1ea3ng t\u00ednh n\u1ebfu \u0111\u01b0\u1ee3c nh\u1eafc. B\u1eadt t\u00ednh n\u0103ng Track Changes b\u1ea3ng t\u00ednh s\u1ebd s\u1ebd t\u1ef1 \u0111\u1ed9ng \u0111\u01b0\u1ee3c chia s\u1ebb.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 M\u1ed7i ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n b\u1ea5t k\u1ef3 ch\u1ec9nh s\u1eeda n\u00e0o trong b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c chia s\u1ebb ph\u1ea3i l\u01b0u m\u1ed9t b\u1ea3n sao (t\u1ec7p .xls ho\u1eb7c xlsx) b\u1eb1ng t\u00ean t\u1ec7p duy nh\u1ea5t.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">B\u00e2y gi\u1edd t\u1ea5t c\u1ea3 c\u00e1c chu\u1ea9n b\u1ecb ban \u0111\u1ea7u \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n \u0111\u00fang, b\u1ea1n \u0111\u00e3 s\u1eb5n s\u00e0ng \u0111\u1ec3 k\u1ebft h\u1ee3p c\u00e1c b\u1ea3n sao sang m\u1ed9t b\u1ea3ng t\u00ednh d\u00f9ng chung.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">1. K\u00edch ho\u1ea1t t\u00ednh n\u0103ng Compare and Merge Workbooks trong Excel<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> M\u1eb7c d\u00f9 t\u00ednh n\u0103ng Compare and Merge Workbooks c\u00f3 s\u1eb5n trong t\u1ea5t c\u1ea3 c\u00e1c phi\u00ean b\u1ea3n c\u1ee7a Excel 2016, Excel 2013, Excel 2010 v\u00e0 nh\u1eefng phi\u00ean b\u1ea3n th\u1ea5p h\u01a1n, tuy nhi\u00ean l\u1ec7nh n\u00e0y s\u1ebd kh\u00f4ng \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb \u1edf b\u1ea5t c\u1ee9 ph\u1ea7n n\u00e0o trong Excel theo m\u1eb7c \u0111\u1ecbnh. \u0110\u1ec3 th\u00eam n\u00f3 v\u00e0o thanh c\u00f4ng c\u1ee5 Quick Access, th\u1ef1c hi\u1ec7n theo c\u00e1c b\u01b0\u1edbc sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 M\u1edf tr\u00ecnh \u0111\u01a1n th\u1ea3 xu\u1ed1ng Quick Access v\u00e0 ch\u1ecdn More Commands.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Trong h\u1ed9p tho\u1ea1i Excel Options, ch\u1ecdn All Commands under Choose commands from.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Trong danh s\u00e1ch c\u00e1c l\u1ec7nh, ch\u1ecdn Compare and Merge Workbooks v\u00e0 nh\u1ea5n v\u00e0o n\u00fat Add \u0111\u1ec3 di chuy\u1ec3n n\u00f3 sang ph\u1ea7n b\u00ean tay ph\u1ea3i.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1ea5p OK.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7767\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/8-4.png\" width=\"651\" height=\"425\" title=\"8-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. So s\u00e1nh v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3ng t\u00ednh<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Khi t\u1ea5t c\u1ea3 ng\u01b0\u1eddi d\u00f9ng \u0111\u00e3 ho\u00e0n th\u00e0nh c\u00f4ng vi\u1ec7c v\u1edbi b\u1ea3ng t\u00ednh Excel \u0111\u00e3 chia s\u1ebb c\u1ee7a b\u1ea1n, b\u1ea1n c\u00f3 th\u1ec3 h\u1ee3p nh\u1ea5t t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n sao v\u00e0o m\u1ed9t t\u1ec7p.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 M\u1edf phi\u00ean b\u1ea3n ch\u00ednh c\u1ee7a b\u1ea3ng t\u00ednh \u0111\u01b0\u1ee3c chia s\u1ebb.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1ea5p v\u00e0o l\u1ec7nh Compare and Merge Workbooks tr\u00ean thanh c\u00f4ng c\u1ee5 Quick Access.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7768\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/9-4.png\" width=\"413\" height=\"64\" title=\"9-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Trong h\u1ed9p tho\u1ea1i xu\u1ea5t hi\u1ec7n, ch\u1ecdn m\u1ed9t b\u1ea3n sao c\u1ee7a b\u1ea3ng t\u00ednh chia s\u1ebb m\u00e0 b\u1ea1n mu\u1ed1n h\u1ee3p nh\u1ea5t. \u0110\u1ec3 ch\u1ecdn m\u1ed9t s\u1ed1 b\u1ea3n sao, h\u00e3y gi\u1eef ph\u00edm Shift trong khi nh\u1ea5p v\u00e0o t\u00ean t\u1ec7p, sau \u0111\u00f3 b\u1ea5m OK.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7769\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/10-4.png\" width=\"657\" height=\"449\" title=\"10-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Gi\u1edd th\u00ec nh\u1eefng thay \u0111\u1ed5i t\u1eeb m\u1ed7i b\u1ea3n sao \u0111\u00e3 \u0111\u01b0\u1ee3c h\u1ee3p nh\u1ea5t v\u00e0o m\u1ed9t b\u1ea3ng t\u00ednh duy nh\u1ea5t v\u00e0 b\u1ea1n c\u00f3 th\u1ec3 xem l\u1ea1i t\u1ea5t c\u1ea3 c\u00e1c ch\u1ec9nh s\u1eeda c\u00f9ng m\u1ed9t l\u00fac. \u0110\u1ec3 ch\u1ec9 ra h\u00e0ng v\u00e0 c\u1ed9t c\u00f3 s\u1ef1 kh\u00e1c bi\u1ec7t, Excel s\u1ebd l\u00e0m n\u1ed5i b\u1eadt c\u00e1c ch\u1eef c\u00e1i, c\u1ed9t v\u00e0 s\u1ed1 h\u00e0ng v\u1edbi m\u00e0u \u0111\u1ecf \u0111\u1eadm. \u1ede c\u1ea5p \u0111\u1ed9 \u00f4, c\u00e1c ch\u1ec9nh s\u1eeda t\u1eeb nh\u1eefng ng\u01b0\u1eddi d\u00f9ng kh\u00e1c nhau \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng c\u00e1c m\u00e0u kh\u00e1c nhau, do \u0111\u00f3 b\u1ea1n c\u00f3 th\u1ec3 nh\u00ecn th\u1ea5y ng\u01b0\u1eddi \u0111\u00e3 th\u1ef1c hi\u1ec7n m\u1ed9t thay \u0111\u1ed5i c\u1ee5 th\u1ec3.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7770\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/11-4.png\" width=\"455\" height=\"219\" title=\"11-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ch\u00fa th\u00edch. N\u1ebfu l\u1ec7nh Compare and Merge Workbooks c\u00f3 m\u00e0u x\u00e1m trong Excel c\u1ee7a b\u1ea1n, r\u1ea5t c\u00f3 th\u1ec3 \u0111\u00f3 l\u00e0 v\u00ec b\u1ea1n \u0111ang c\u1ed1 k\u1ebft h\u1ee3p c\u00e1c t\u1ec7p Excel kh\u00e1c nhau. H\u00e3y nh\u1edb r\u1eb1ng, t\u00ednh n\u0103ng Compare and Merge Workbooks cho ph\u00e9p h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3n sao c\u1ee7a c\u00f9ng m\u1ed9t b\u1ea3ng t\u00ednh.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_cong_cu_khac_dung_de_so_sanh_cac_tep_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1c c\u00f4ng c\u1ee5 kh\u00e1c d\u00f9ng \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y, Microsoft Excel cung c\u1ea5p m\u1ed9t s\u1ed1 \u00edt c\u00e1c t\u00ednh n\u0103ng \u0111\u1ec3 so s\u00e1nh d\u1eef li\u1ec7u trong hai ho\u1eb7c nhi\u1ec1u b\u1ea3ng t\u00ednh. Nh\u01b0ng kh\u00f4ng c\u00f3 l\u1ef1a ch\u1ecdn t\u00edch h\u1ee3p n\u00e0o \u0111\u1ee7 \u0111\u1ec3 so s\u00e1nh m\u1ed9t c\u00e1ch to\u00e0n di\u1ec7n c\u00e1c trang Excel, n\u00f3 nguy\u00ean to\u00e0n b\u1ed9 b\u1ea3ng t\u00ednh, ch\u1ec9 ra t\u1ea5t c\u1ea3 s\u1ef1 kh\u00e1c nhau v\u1ec1 gi\u00e1 tr\u1ecb, c\u00f4ng th\u1ee9c ho\u1eb7c \u0111\u1ecbnh d\u1ea1ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ec v\u1eady, n\u1ebfu b\u1ea1n c\u1ea7n c\u00e1c ph\u01b0\u01a1ng ti\u1ec7n ti\u00ean ti\u1ebfn v\u00e0 th\u1ef1c s\u1ef1 hi\u1ec7u qu\u1ea3 \u0111\u1ec3 so s\u00e1nh hai t\u1ec7p Excel, r\u1ea5t c\u00f3 th\u1ec3 b\u1ea1n s\u1ebd ph\u1ea3i s\u1eed d\u1ee5ng m\u1ed9t trong c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a b\u00ean ngo\u00e0i \u0111\u01b0\u1ee3c thi\u1ebft k\u1ebf \u0111\u1eb7c bi\u1ec7t \u0111\u1ec3 so s\u00e1nh, c\u1eadp nh\u1eadt v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c trang t\u00ednh v\u00e0 b\u1ea3ng t\u00ednh Excel. D\u01b0\u1edbi \u0111\u00e2y b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y m\u1ed9t c\u00e1i nh\u00ecn t\u1ed5ng quan nhanh v\u1ec1 m\u1ed9t v\u00e0i c\u00f4ng c\u1ee5 \u0111\u01b0\u1ee3c xem l\u00e0 nh\u1eefng c\u00f4ng c\u1ee5 th\u1ef1c hi\u1ec7n t\u1ed1t nh\u1ea5t trong l\u0129nh v\u1ef1c n\u00e0y.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Synkronizer Excel Compare: c\u00f4ng c\u1ee5 3 trong 1 \u0111\u1ec3 so s\u00e1nh, h\u1ee3p nh\u1ea5t v\u00e0 c\u1eadp nh\u1eadt c\u00e1c t\u1ec7p Excel<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ti\u1ec7n \u00edch Synkronizer Excel Compare c\u00f3 th\u1ec3 nhanh ch\u00f3ng so s\u00e1nh, h\u1ee3p nh\u1ea5t v\u00e0 c\u1eadp nh\u1eadt hai t\u1ec7p Excel gi\u00fap b\u1ea1n h\u1ea1n ch\u1ebf g\u1eb7p ph\u1ea3i s\u1ef1 c\u1ed1 khi t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t theo c\u00e1ch th\u1ee7 c\u00f4ng.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu b\u1ea1n \u0111ang t\u00ecm ki\u1ebfm m\u1ed9t ph\u01b0\u01a1ng ph\u00e1p nhanh ch\u00f3ng v\u00e0 \u0111\u00e1ng tin c\u1eady \u0111\u1ec3 so s\u00e1nh hai b\u1ea3ng t\u00ednh ho\u1eb7c trang t\u00ednh Excel, ch\u1eafc ch\u1eafn b\u1ea1n s\u1ebd t\u00ecm th\u1ea5y nh\u1eefng t\u00ednh n\u0103ng h\u1eefu \u00edch sau c\u1ee7a Synkronizer Excel Compare:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 X\u00e1c \u0111\u1ecbnh s\u1ef1 kh\u00e1c nhau gi\u1eefa hai t\u1edd Excel.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 K\u1ebft h\u1ee3p nhi\u1ec1u t\u1ec7p Excel v\u00e0o m\u1ed9t phi\u00ean b\u1ea3n duy nh\u1ea5t m\u00e0 kh\u00f4ng t\u1ea1o ra b\u1ea3n sao kh\u00f4ng mong mu\u1ed1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u1ea3 hai t\u1edd.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Ch\u1ec9 hi\u1ec3n th\u1ecb nh\u1eefng kh\u00e1c bi\u1ec7t c\u00f3 li\u00ean quan \u0111\u1ebfn c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 H\u1ee3p nh\u1ea5t v\u00e0 c\u1eadp nh\u1eadt t\u1edd.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Tr\u00ecnh b\u00e0y chi ti\u1ebft v\u00e0 d\u1ec5 \u0111\u1ecdc c\u00e1c b\u00e1o c\u00e1o kh\u00e1c bi\u1ec7t.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 c\u00f3 \u0111\u01b0\u1ee3c m\u1ed9t s\u1ed1 \u00fd t\u01b0\u1edfng c\u01a1 b\u1ea3n v\u1ec1 kh\u1ea3 n\u0103ng v\u00e0 hi\u1ec7u su\u1ea5t c\u1ee7a Synkronizer Excel Compare, ch\u00fang ta h\u00e3y th\u1ef1c hi\u1ec7n m\u1ed9t v\u00e0i thao t\u00e1c ki\u1ec3m tra.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_hai_tep_Excel_de_tim_su_khac_biet\"><\/span><span style=\"font-family: 'Times New Roman', Times\">So s\u00e1nh hai t\u1ec7p Excel \u0111\u1ec3 t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u1ea3 s\u1eed b\u1ea1n \u0111ang t\u1ed5 ch\u1ee9c m\u1ed9t s\u1ed1 s\u1ef1 ki\u1ec7n v\u00e0 trong b\u1ea3ng Excel c\u1ee7a b\u1ea1n, b\u1ea1n thu th\u1eadp th\u00f4ng tin v\u1ec1 nh\u1eefng ng\u01b0\u1eddi tham gia nh\u01b0 t\u00ean ng\u01b0\u1eddi tham gia, ng\u00e0y \u0111\u1ebfn, s\u1ed1 ch\u1ed7 ng\u1ed3i v\u00e0 c\u00e1c chi ti\u1ebft kh\u00e1c. Ngo\u00e0i ra, b\u1ea1n c\u00f3 m\u1ed9t v\u00e0i nh\u00e0 qu\u1ea3n l\u00fd ti\u1ebfp x\u00fac tr\u1ef1c ti\u1ebfp v\u1edbi ng\u01b0\u1eddi tham gia v\u00e0 c\u01a1 s\u1edf d\u1eef li\u1ec7u, v\u00e0 k\u1ebft qu\u1ea3 l\u00e0 b\u1ea1n c\u00f3 2 phi\u00ean b\u1ea3n c\u1ee7a c\u00f9ng m\u1ed9t t\u1ec7p Excel.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Gi\u1edd h\u00e3y xem hi\u1ec7u qu\u1ea3 c\u1ee7a Synkronizer trong vi\u1ec7c so s\u00e1nh hai phi\u00ean b\u1ea3n v\u00e0 x\u00e1c \u0111\u1ecbnh s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa ch\u00fang.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 ch\u1ea1y Synkronizer Excel Compare, h\u00e3y chuy\u1ec3n t\u1edbi tab Add-ins v\u00e0 nh\u1ea5p v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng Synchronizer 11.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7771\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/12-4.png\" width=\"296\" height=\"130\" title=\"12-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> C\u1eeda s\u1ed5 Synkronizer s\u1ebd hi\u1ec7n l\u00ean \u1edf ph\u1ea7n b\u00ean tr\u00e1i c\u1ee7a c\u1eeda s\u1ed5 Excel, \u1edf \u0111\u00f3 b\u1ea1n th\u1ef1c hi\u1ec7n 5 b\u01b0\u1edbc sau:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 1. Ch\u1ecdn 2 b\u1ea3ng t\u00ednh c\u1ea7n so s\u00e1nh:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7772\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/13-4.png\" width=\"428\" height=\"308\" title=\"13-4\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 2. Ch\u1ecdn trang t\u00ednh c\u1ea7n so s\u00e1nh.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> N\u1ebfu b\u1ea3ng t\u00ednh \u0111\u00e3 ch\u1ecdn c\u00f3 b\u1ea5t k\u1ef3 t\u1edd n\u00e0o c\u00f3 c\u00f9ng t\u00ean, t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c k\u1ebft h\u1ee3p v\u00e0 t\u1ef1 \u0111\u1ed9ng ch\u1ecdn \u0111\u1ec3 so s\u00e1nh (nh\u01b0 t\u1edd Participants trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh b\u00ean d\u01b0\u1edbi).<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 ch\u1ecdn c\u00e1c b\u1ea3ng t\u00ednh m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh, ho\u1eb7c h\u01b0\u1edbng d\u1eabn c\u00e1c add-in ph\u00f9 h\u1ee3p v\u1edbi c\u00e1c b\u1ea3ng t\u00ednh theo c\u00e1c ti\u00eau ch\u00ed kh\u00e1c, v\u00ed d\u1ee5 theo lo\u1ea1i b\u1ea3ng t\u00ednh \u2013 t\u1ea5t c\u1ea3, \u0111\u01b0\u1ee3c b\u1ea3o v\u1ec7, ho\u1eb7c \u1ea9n.<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7773\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/14-2.png\" width=\"425\" height=\"547\" title=\"14-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Khi b\u1ea1n \u0111\u00e3 ch\u1ecdn c\u00e1c trang t\u00ednh, ti\u1ec7n \u00edch Synkronizer s\u1ebd m\u1edf ch\u00fang c\u1ea1nh nhau, \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo chi\u1ec1u ngang ho\u1eb7c theo chi\u1ec1u d\u1ecdc, nh\u01b0 trong View Side by Side c\u1ee7a Excel.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">3. Ch\u1ecdn m\u1ed9t trong c\u00e1c t\u00f9y ch\u1ecdn so s\u00e1nh sau:<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 So s\u00e1nh d\u1ea1ng c\u00e1c b\u1ea3ng t\u00ednh b\u00ecnh th\u01b0\u1eddng \u2013 t\u00f9y ch\u1ecdn m\u1eb7c \u0111\u1ecbnh ho\u1ea1t \u0111\u1ed9ng trong h\u1ea7u h\u1ebft c\u00e1c tr\u01b0\u1eddng h\u1ee3p.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 So s\u00e1nh v\u1edbi c\u00e1c t\u00f9y ch\u1ecdn li\u00ean k\u1ebft \u2013 n\u1ebfu c\u00e1c trang t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 h\u00e0ng ho\u1eb7c c\u1ed9t m\u1edbi ho\u1eb7c \u0111\u00e3 b\u1ecb x\u00f3a, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh ch\u00fang \u201c1 tr\u00ean 1\u201d.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 So s\u00e1nh d\u1ea1ng c\u01a1 s\u1edf d\u1eef li\u1ec7u \u2013 c\u00f3 th\u1ec3 d\u00f9ng \u0111\u1ec3 so s\u00e1nh c\u00e1c trang t\u00ednh c\u00f3 c\u1ea5u tr\u00fac c\u01a1 s\u1edf d\u1eef li\u1ec7u.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 So s\u00e1nh c\u00e1c ph\u1ea1m vi \u0111\u00e3 ch\u1ecdn \u2013 n\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n so s\u00e1nh to\u00e0n b\u1ed9 c\u00e1c trang t\u00ednh, h\u00e3y x\u00e1c \u0111\u1ecbnh ph\u1ea1m vi c\u1ea7n \u0111\u01b0\u1ee3c so s\u00e1nh.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">4. Ch\u1ecdn lo\u1ea1i n\u1ed9i dung c\u1ea7n so s\u00e1nh (t\u00f9y ch\u1ecdn).<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tr\u00ean tabSelect tab &gt; Compare, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn (c\u00e1c) lo\u1ea1i n\u1ed9i dung li\u00ean quan \u0111\u1ebfn c\u00f4ng vi\u1ec7c hi\u1ec7n t\u1ea1i c\u1ee7a b\u1ea1n:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7774\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/15-1-2.png\" width=\"355\" height=\"144\" title=\"15-1-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u1ede ph\u1ea7n Content, b\u1ea1n c\u00f3 th\u1ec3 ch\u1ecdn c\u00e1c nh\u1eadn x\u00e9t v\u00e0 t\u00ean (ngo\u00e0i gi\u00e1 tr\u1ecb, c\u00f4ng th\u1ee9c v\u00e0 c\u00e1c gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n \u0111\u01b0\u1ee3c so s\u00e1nh theo m\u1eb7c \u0111\u1ecbnh).<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u1ede ph\u1ea7n Formats, b\u1ea1n ch\u1ecdn \u0111\u1ecbnh d\u1ea1ng \u00f4 nh\u01b0 s\u1eafp x\u1ebfp, \u0111i\u1ec1n, ph\u00f4ng ch\u1eef, \u0111\u01b0\u1eddng vi\u1ec1n,\u2026<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 T\u00f9y ch\u1ecdn Filters cho ph\u00e9p b\u1ea1n l\u1ecdc ra s\u1ef1 kh\u00e1c bi\u1ec7t m\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n hi\u1ec3n th\u1ecb. V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 b\u1ecf qua tr\u01b0\u1eddng h\u1ee3p, kho\u1ea3ng c\u00e1ch h\u00e0ng \u0111\u1ea7u ho\u1eb7c d\u1ea5u ch\u1ea5m, t\u1ea5t c\u1ea3 c\u00e1c c\u00f4ng th\u1ee9c ho\u1eb7c c\u00e1c c\u00f4ng th\u1ee9c kh\u00e1c nhau c\u00f3 c\u00f9ng k\u1ebft qu\u1ea3, c\u00e1c h\u00e0ng ho\u1eb7c c\u1ed9t \u1ea9n v\u00e0 h\u01a1n th\u1ebf n\u1eefa.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> 5. Cu\u1ed1i c\u00f9ng, nh\u1ea5p v\u00e0o n\u00fat Start m\u00e0u \u0111\u1ecf l\u1edbn tr\u00ean thanh th\u1ef1c \u0111\u01a1n v\u00e0 ti\u1ebfn h\u00e0nh ki\u1ec3m tra k\u1ebft qu\u1ea3.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> H\u00ecnh dung v\u00e0 ph\u00e2n t\u00edch s\u1ef1 kh\u00e1c bi\u1ec7t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Th\u00f4ng th\u01b0\u1eddng ch\u1ec9 c\u1ea7n cho Synkronizer v\u00e0i gi\u00e2y l\u00e0 c\u00f3 th\u1ec3 so s\u00e1nh 2 t\u1edd v\u00e0 tr\u00ecnh b\u00e0y b\u00e1o c\u00e1o t\u00f3m t\u1eaft ng\u1eafn g\u1ecdn v\u00e0 b\u00e1o c\u00e1o s\u1ef1 kh\u00e1c bi\u1ec7t chi ti\u1ebft tr\u00ean tab Results.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Trong m\u1ed9t b\u00e1o c\u00e1o t\u00f3m t\u1eaft, b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y t\u1ea5t c\u1ea3 nh\u1eefng s\u1ef1 kh\u00e1c nhau trong nh\u00e1y m\u1eaft: thay \u0111\u1ed5i trong c\u1ed9t, h\u00e0ng, \u00f4, nh\u1eadn x\u00e9t, \u0111\u1ecbnh d\u1ea1ng v\u00e0 t\u00ean.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 xem b\u00e1o c\u00e1o chi ti\u1ebft, ch\u1ec9 c\u1ea7n nh\u1ea5p v\u00e0o lo\u1ea1i s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee5 th\u1ec3 tr\u00ean b\u00e1o c\u00e1o t\u00f3m t\u1eaft.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u1ea2nh ch\u1ee5p m\u00e0n h\u00ecnh sau \u0111\u00e2y cho th\u1ea5y b\u00e1o c\u00e1o t\u00f3m t\u1eaft (\u1edf ph\u1ea7n ph\u00eda tr\u00ean c\u1ee7a m\u1ee5c Results), v\u00e0 tr\u00ecnh b\u00e0y s\u1ef1 kh\u00e1c bi\u1ec7t \u00f4 (\u1edf ph\u1ea7n d\u01b0\u1edbi c\u1ee7a khung):<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7775\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/16-2.png\" width=\"375\" height=\"559\" title=\"16-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Ngay khi nh\u1ea5p chu\u1ed9t v\u00e0o m\u1ed9t \u0111i\u1ec3m kh\u00e1c bi\u1ec7t, b\u1ea1n s\u1ebd \u0111\u01b0\u1ee3c \u0111\u01b0a \u0111\u1ebfn c\u00e1c \u00f4 t\u01b0\u01a1ng \u1ee9ng tr\u00ean 2 trang t\u00ednh b\u1ea1n \u0111ang so s\u00e1nh, nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7776\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/17-2-1.png\" width=\"633\" height=\"521\" title=\"17-2-1\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ngo\u00e0i ra, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o m\u1ed9t b\u00e1o c\u00e1o s\u1ef1 kh\u00e1c bi\u1ec7t trong m\u1ed9t b\u1ea3ng t\u00ednh ri\u00eang, ho\u1eb7c ti\u00eau chu\u1ea9n hay si\u00eau li\u00ean k\u1ebft, v\u00e0 chuy\u1ec3n \u0111\u1ebfn m\u1ed9t s\u1ef1 kh\u00e1c bi\u1ec7t c\u1ee5 th\u1ec3 v\u1edbi m\u1ed9t c\u00fa nh\u1ea5p chu\u1ed9t:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7778\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/a.png\" width=\"339\" height=\"235\" title=\"a\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"So_sanh_tat_ca_cac_bang_tinh_trong_hai_bang_tinh_cung_mot_luc\"><\/span><span style=\"font-family: 'Times New Roman', Times\">So s\u00e1nh t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3ng t\u00ednh trong hai b\u1ea3ng t\u00ednh c\u00f9ng m\u1ed9t l\u00fac<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">N\u1ebfu hai t\u1ec7p Excel b\u1ea1n \u0111ang so s\u00e1nh c\u00f3 ch\u1ee9a nhi\u1ec1u trang, t\u1ea5t c\u1ea3 c\u00e1c c\u1eb7p b\u1ea3ng t\u00ednh ph\u00f9 h\u1ee3p s\u1ebd \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y trong b\u00e1o c\u00e1o t\u00f3m t\u1eaft \u0111\u1ec3 b\u1ea1n c\u00f3 th\u1ec3 quan s\u00e1t \u0111\u01b0\u1ee3c:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7779\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/18-2-1.png\" width=\"371\" height=\"269\" title=\"18-2-1\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_noi_bat_su_khac_biet_giua_cac_trang\"><\/span><span style=\"font-family: 'Times New Roman', Times\">L\u00e0m n\u1ed5i b\u1eadt s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa c\u00e1c trang<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Theo m\u1eb7c \u0111\u1ecbnh, tr\u00ecnh so s\u00e1nh ti\u1ec7n \u00edch c\u1ee7a Synkronizer Excel Compare l\u00e0m n\u1ed5i b\u1eadt t\u1ea5t c\u1ea3 c\u00e1c kh\u00e1c bi\u1ec7t \u0111\u01b0\u1ee3c t\u00ecm th\u1ea5y, nh\u01b0 trong \u1ea3nh ch\u1ee5p m\u00e0n h\u00ecnh sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00e0ng \u2013 s\u1ef1 kh\u00e1c bi\u1ec7t trong gi\u00e1 tr\u1ecb \u00f4<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> H\u1ed3ng t\u00edm \u2013 s\u1ef1 kh\u00e1c bi\u1ec7t trong c\u00e1c \u0111\u1ecbnh d\u1ea1ng \u00f4<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Xanh l\u00e1 \u2013 C\u00e1c h\u00e0ng \u0111\u01b0\u1ee3c ch\u00e8n v\u00e0o<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7780\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/19-2.png\" width=\"661\" height=\"420\" title=\"19-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u0110\u1ec3 ch\u1ec9 nh\u1eefng \u0111i\u1ec3m kh\u00e1c bi\u1ec7t c\u00f3 li\u00ean quan, h\u00e3y nh\u1ea5p v\u00e0o n\u00fat Outline tr\u00ean tab Results v\u00e0 ch\u1ecdn c\u00e1c t\u00f9y ch\u1ecdn \u0111\u01b0\u1ee3c y\u00eau c\u1ea7u:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7781\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/20-2.png\" width=\"295\" height=\"250\" title=\"20-2\"><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cap_nhat_va_hop_nhat_cac_trang\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u1eadp nh\u1eadt v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c trang<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ch\u1ee9c n\u0103ng h\u1ee3p nh\u1ea5t ch\u1eafc ch\u1eafn l\u00e0 m\u1ed9t trong nh\u1eefng ch\u1ee9c n\u0103ng h\u1eefu \u00edch nh\u1ea5t c\u1ee7a Synkronizer Excel Compare add-in. N\u00f3 cho ph\u00e9p b\u1ea1n chuy\u1ec3n gi\u00e1 tr\u1ecb t\u1eeb t\u1edd 1 \u0111\u1ebfn t\u1edd 2 v\u00e0 ng\u01b0\u1ee3c l\u1ea1i. B\u1ea1n c\u00f3 th\u1ec3 h\u1ee3p nh\u1ea5t c\u00e1c gi\u00e1 tr\u1ecb c\u1ee7a c\u00e1c \u00f4 ri\u00eang l\u1ebb ho\u1eb7c di chuy\u1ec3n c\u00e1c c\u1ed9t \/ h\u00e0ng kh\u00e1c nhau t\u1eeb ngu\u1ed3n \u0111\u1ebfn \u0111\u00edch, v\u00e0 b\u1ea3n ch\u00ednh c\u1ee7a b\u1ea1n \u0111\u01b0\u1ee3c c\u1eadp nh\u1eadt trong v\u00e0i gi\u00e2y.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u0110\u1ec3 c\u1eadp nh\u1eadt m\u1ed9t ho\u1eb7c nhi\u1ec1u s\u1ef1 kh\u00e1c bi\u1ec7t, h\u00e3y ch\u1ecdn ch\u00fang tr\u00ean b\u1ea3ng c\u1ee7a Synkronizer v\u00e0 nh\u1ea5p v\u00e0o m\u1ed9t trong 4 n\u00fat c\u1eadp nh\u1eadt \u2013 n\u00fat \u0111\u1ea7u ti\u00ean v\u00e0 cu\u1ed1i c\u00f9ng c\u1eadp nh\u1eadt t\u1ea5t c\u1ea3 s\u1ef1 kh\u00e1c bi\u1ec7t, trong khi c\u00e1c n\u00fat th\u1ee9 hai v\u00e0 th\u1ee9 3 ch\u1ec9 c\u1eadp nh\u1eadt s\u1ef1 l\u1ef1a ch\u1ecdn kh\u00e1c bi\u1ec7t (m\u0169i t\u00ean n\u00fat ch\u1ec9 \u0111\u01b0\u1eddng truy\u1ec1n):<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7782\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/21-2.png\" width=\"342\" height=\"256\" title=\"21-2\"><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Tr\u00ean \u0111\u00e2y l\u00e0 nh\u1eefng t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a ti\u1ec7n \u00edch Synkronizer, nh\u01b0ng ch\u1eafc ch\u1eafn ti\u1ec7n \u00edch n\u00e0y c\u00f2n nhi\u1ec1u t\u00ednh n\u0103ng h\u01a1n n\u1eefa r\u1ea5t nhi\u1ec1u. N\u00f3 l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 t\u1ed1t nh\u1ea5t \u0111\u1ec3 so s\u00e1ch s\u1ef1 kh\u00e1c bi\u1ec3n v\u00e0 cung c\u1ea5p nhi\u1ec1u t\u00ednh n\u0103ng ph\u1ee5c v\u1ee5 c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">XlCompare: so s\u00e1nh v\u00e0 h\u1ee3p nh\u1ea5t c\u00e1c b\u1ea3ng t\u00ednh, trang t\u00ednh v\u00e0 c\u00e1c d\u1ef1 \u00e1n VBA<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> S\u1eed d\u1ee5ng ti\u1ec7n \u00edch xlCompare, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai t\u1ec7p Excel, b\u1ea3ng t\u00ednh, t\u00ean v\u00e0 c\u00e1c D\u1ef1 \u00e1n VBA. N\u00f3 gi\u00fap b\u1ea1n c\u00f3 th\u1ec3 th\u00eam, x\u00f3a v\u00e0 thay \u0111\u1ed5i d\u1eef li\u1ec7u, \u0111\u1ed3ng th\u1eddi cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng h\u1ee3p nh\u1ea5t c\u00e1c s\u1ef1 kh\u00e1c bi\u1ec7t. Ngo\u00e0i ra, n\u00f3 cung c\u1ea5p c\u00e1c t\u00f9y ch\u1ecdn sau:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 T\u00ecm b\u1ea3n ghi tr\u00f9ng l\u1eb7p gi\u1eefa hai b\u1ea3ng t\u00ednh v\u00e0 lo\u1ea1i b\u1ecf ch\u00fang.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 C\u1eadp nh\u1eadt t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi hi\u1ec7n c\u00f3 trong m\u1ed9t trang v\u1edbi c\u00e1c gi\u00e1 tr\u1ecb t\u1eeb m\u1ed9t t\u1edd kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Th\u00eam (m\u1edbi) c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t t\u1eeb m\u1ed9t trang t\u00ednh n\u00e0y sang m\u1ed9t trang kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 H\u1ee3p nh\u1ea5t t\u1ea5t c\u1ea3 c\u00e1c b\u1ea3n ghi c\u1eadp nh\u1eadt t\u1eeb m\u1ed9t b\u1ea3ng t\u00ednh n\u00e0y sang m\u1ed9t b\u1ea3ng t\u00ednh kh\u00e1c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 S\u1eafp x\u1ebfp d\u1eef li\u1ec7u tr\u00ean b\u1ea3ng theo c\u1ed9t ch\u00ednh.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 L\u1ecdc c\u00e1c k\u1ebft qu\u1ea3 so s\u00e1nh \u0111\u1ec3 hi\u1ec3n th\u1ecb s\u1ef1 kh\u00e1c bi\u1ec7t ho\u1eb7c d\u1eef li\u1ec7u gi\u1ed1ng h\u1ec7t nhau.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 \u0110\u00e1nh d\u1ea5u c\u00e1c k\u1ebft qu\u1ea3 so s\u00e1nh b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng m\u00e0u s\u1eafc.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Florencesoft DiffEngineX: so s\u00e1nh b\u1ea3ng t\u00ednh Excel \u0111\u1ec3 t\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> DiffEngineX l\u00e0 m\u1ed9t ti\u1ec7n \u00edch kh\u00e1c c\u00f3 th\u1ec3 gi\u00fap b\u1ea1n x\u00e1c \u0111\u1ecbnh s\u1ef1 kh\u00e1c nhau gi\u1eefa c\u00e1c gi\u00e1 tr\u1ecb \u00f4, c\u00f4ng th\u1ee9c, nh\u1eadn x\u00e9t, t\u00ean Excel v\u00e0 m\u00e3 VBA. N\u00f3 c\u00f3 th\u1ec3 so s\u00e1nh hai b\u1ea3ng t\u00ednh Excel ho\u1eb7c c\u00e1c trang t\u00ednh \u0111\u01b0\u1ee3c ch\u1ecdn.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">DiffEngineX ho\u1ea1t \u0111\u1ed9ng v\u1edbi xls, xlsx, xlsm v\u00e0 xlsb, h\u1ed7 tr\u1ee3 Excel 2013, Excel 2010, Excel 2007 v\u00e0 Excel 2003.<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">Change pro for Excel: so s\u00e1nh c\u00e1c trang t\u00ednh Excel tr\u00ean m\u00e1y t\u00ednh \u0111\u1ec3 b\u00e0n v\u00e0 thi\u1ebft b\u1ecb di \u0111\u1ed9ng<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> V\u1edbi t\u00ednh n\u0103ng Change pro for Excel, b\u1ea1n c\u00f3 th\u1ec3 so s\u00e1nh hai trang t\u00ednh trong Excel c\u0169ng nh\u01b0 tr\u00ean c\u00e1c thi\u1ebft b\u1ecb di \u0111\u1ed9ng v\u1edbi s\u1ef1 so s\u00e1nh t\u00f9y ch\u1ecdn d\u1ef1a tr\u00ean m\u00e1y ch\u1ee7. C\u00e1c t\u00ednh n\u0103ng ch\u00ednh c\u1ee7a c\u00f4ng c\u1ee5 n\u00e0y l\u00e0:<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">\u2013 T\u00ecm s\u1ef1 kh\u00e1c bi\u1ec7t gi\u1eefa 2 t\u1edd theo c\u00f4ng th\u1ee9c v\u00e0 gi\u00e1 tr\u1ecb.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 X\u00e1c \u0111\u1ecbnh thay \u0111\u1ed5i b\u1ed1 c\u1ee5c, bao g\u1ed3m c\u00e1c h\u00e0ng v\u00e0 c\u1ed9t \u0111\u01b0\u1ee3c th\u00eam \/ x\u00f3a.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 Nh\u1eadn bi\u1ebft nh\u1eefng d\u1eef li\u1ec7u nh\u01b0 bi\u1ec3u \u0111\u1ed3, \u0111\u1ed3 th\u1ecb v\u00e0 h\u00ecnh \u1ea3nh.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 T\u1ea1o v\u00e0 in c\u00e1c b\u00e1o c\u00e1o kh\u00e1c nhau v\u1ec1 c\u00f4ng th\u1ee9c, gi\u00e1 tr\u1ecb v\u00e0 s\u1ef1 kh\u00e1c bi\u1ec7t b\u1ed1 c\u1ee5c.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 L\u1ecdc, s\u1eafp x\u1ebfp v\u00e0 t\u00ecm ki\u1ebfm b\u00e1o c\u00e1o kh\u00e1c bi\u1ec7t v\u1ec1 nh\u1eefng thay \u0111\u1ed5i quan tr\u1ecdng.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 So s\u00e1nh c\u00e1c t\u1ec7p tin tr\u1ef1c ti\u1ebfp t\u1eeb Outlook ho\u1eb7c c\u00e1c h\u1ec7 th\u1ed1ng qu\u1ea3n l\u00fd t\u00e0i li\u1ec7u.<\/span><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> \u2013 H\u1ed7 tr\u1ee3 cho t\u1ea5t c\u1ea3 c\u00e1c ng\u00f4n ng\u1eef, bao g\u1ed3m nhi\u1ec1u byte.<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cac_dich_vu_truc_tuyen_de_so_sanh_cac_tep_Excel\"><\/span><span style=\"font-family: 'Times New Roman', Times\">C\u00e1c d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1ec7p Excel<\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-family: 'Times New Roman', Times\">Ngo\u00e0i c\u00e1c c\u00f4ng c\u1ee5 v\u00e0 ti\u1ec7n \u00edch c\u00e0i s\u1eb5n v\u00e0o m\u00e1y t\u00ednh, c\u00f3 m\u1ed9t s\u1ed1 d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn cho ph\u00e9p b\u1ea1n nhanh ch\u00f3ng so s\u00e1nh hai b\u1ea3ng t\u00ednh Excel cho nh\u1eefng kh\u00e1c bi\u1ec7t m\u00e0 kh\u00f4ng c\u1ea7n c\u00e0i \u0111\u1eb7t b\u1ea5t k\u1ef3 ph\u1ea7n m\u1ec1m n\u00e0o tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n. C\u00f3 l\u1ebd \u0111\u00f3 kh\u00f4ng ph\u1ea3i l\u00e0 gi\u1ea3i ph\u00e1p t\u1ed1t nh\u1ea5t \u0111\u1ed1i v\u1edbi v\u1ea5n \u0111\u1ec1 an ninh, nh\u01b0ng n\u1ebfu c\u00e1c t\u1ec7p Excel c\u1ee7a b\u1ea1n kh\u00f4ng ch\u1ee9a b\u1ea5t k\u1ef3 th\u00f4ng tin nh\u1ea1y c\u1ea3m n\u00e0o, t\u1ea1i sao kh\u00f4ng s\u1eed d\u1ee5ng m\u1ed9t s\u1ed1 d\u1ecbch v\u1ee5 tr\u1ef1c tuy\u1ebfn mi\u1ec5n ph\u00ed \u0111\u1ec3 c\u00f3 k\u1ebft qu\u1ea3 ngay l\u1eadp t\u1ee9c?<\/span><\/p>\n<p><span style=\"font-family: 'Times New Roman', Times\">V\u00ed d\u1ee5: b\u1ea1n c\u00f3 th\u1ec3 th\u1eed XLComparator ho\u1eb7c CloudyExcel ho\u1eb7c t\u00ecm m\u1ed9t s\u1ed1 d\u1ecbch v\u1ee5 t\u01b0\u01a1ng t\u1ef1 kh\u00e1c tr\u00ean m\u1ea1ng. \u0110\u00e2y l\u00e0 c\u00e1ch d\u1ecbch v\u1ee5 c\u1ee7a MistExcel ho\u1ea1t \u0111\u1ed9ng s\u1ebd nh\u01b0 th\u1ebf n\u00e0y:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7783\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/22-2.png\" width=\"547\" height=\"363\" title=\"22-2\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> B\u1ea1n ch\u1ec9 c\u1ea7n t\u1ea3i l\u00ean hai b\u1ea3ng t\u00ednh Excel m\u00e0 b\u1ea1n mu\u1ed1n so s\u00e1nh v\u00e0 nh\u1ea5p v\u00e0o n\u00fat Find Difference \u1edf d\u01b0\u1edbi c\u00f9ng c\u1ee7a m\u00e0n h\u00ecnh. Ch\u1ec9 trong m\u1ed9t th\u1eddi gian c\u1ef1c ng\u1eafn, s\u1ef1 kh\u00e1c bi\u1ec7t trong hai b\u1ea3ng t\u00ednh s\u1ebd \u0111\u01b0\u1ee3c \u0111\u00e1nh d\u1ea5u b\u1eb1ng c\u00e1c m\u00e0u kh\u00e1c nhau:<\/span><br \/>\n<img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-7784\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/23-1.png\" width=\"607\" height=\"539\" title=\"23-1\"><br \/>\n<span style=\"font-family: 'Times New Roman', Times\"> Tr\u00ean \u0111\u00e2y l\u00e0 b\u00e0i vi\u1ebft H\u1ecdc Excel Online tr\u00ecnh b\u00e0y nh\u1eefng c\u00e1ch c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng \u0111\u1ec3 so s\u00e1nh c\u00e1c t\u1eadp tin Excel nh\u1eb1m t\u00ecm ra nh\u1eefng kh\u00e1c bi\u1ec7t. C\u1ea3m \u01a1n c\u00e1c b\u1ea1n \u0111\u00e3 theo d\u00f5i b\u00e0i vi\u1ebft!<\/span><\/p>\n<p style=\"text-align: left\">Blog Ho\u0323c Excel online \u0111a\u0303 m\u01a1\u0309 r\u00e2\u0301t nhi\u00ea\u0300u ca\u0301c kho\u0301a ho\u0323c \u0111a\u0300o ta\u0323o v\u00ea\u0300\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc-excel-co-ban\">H\u1ecdc Excel c\u01a1 b\u1ea3n \u0111\u1ebfn n\u00e2ng cao<\/a>\u00a0v\u01a1\u0301i ca\u0301c chuy\u00ean gia ha\u0300ng \u0111\u00e2\u0300u ta\u0323i Vi\u00ea\u0323t Nam. Ch\u00fang t\u00f4i se\u0303 mang \u0111\u00ea\u0301n cho ba\u0323n nh\u01b0\u0303ng bu\u00f4\u0309i ho\u0323c b\u00f4\u0309 i\u0301ch, hi\u1ec7u qua\u0309 co\u0301 th\u00ea\u0309 s\u01b0\u0309 du\u0323ng tha\u0300nh tha\u0323o Excel \u0111\u00ea\u0309 a\u0301p du\u0323ng trong c\u00f4ng vi\u00ea\u0323c. Ngoa\u0300i ra, chu\u0301ng t\u00f4i \u0111ang co\u0301 nhi\u00ea\u0300u ch\u01b0\u01a1ng tri\u0300nh khuy\u00ea\u0301n ma\u0323i l\u01a1\u0301n cho ca\u0301c ho\u0323c vi\u00ean \u0111\u0103ng ki\u0301 trong tha\u0301ng na\u0300y, v\u00e2\u0323y co\u0300n tr\u1ea7n tr\u01b0\u0300 gi\u0300 n\u01b0\u0303a ma\u0300 kh\u00f4ng \u0111\u0103ng ki\u0301 ngay th\u00f4i. Th\u00f4ng tin chi ti\u1ebft xem t\u1ea1i:<\/p>\n<p style=\"text-align: justify\"><strong>Xem th\u00eam: <a href=\"http:\/\/blog.ezworkapp.com\/cach-so-sanh-hai-cot-du-lieu-trong-excel-de-xoa-highligh-to-mau-du-lieu-trung-lap.html\">L\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng nhau gi\u1eefa 2 c\u1ed9t trong excel<\/a> ch\u1ec9 v\u00e0i b\u01b0\u1edbc \u0111\u01a1n gi\u1ea3n<\/strong><\/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-586.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":6540,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-6539","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\/6539","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=6539"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/6539\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/6540"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=6539"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=6539"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=6539"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}