{"id":11274,"date":"2025-01-15T02:25:16","date_gmt":"2025-01-15T02:25:16","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day\/"},"modified":"2025-01-15T02:25:16","modified_gmt":"2025-01-15T02:25:16","slug":"5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day\/","title":{"rendered":"5 Pivot Table m\u00e0 ch\u1eafc h\u1eb3n b\u1ea1n ch\u01b0a t\u1eebng g\u1eb7p tr\u01b0\u1edbc \u0111\u00e2y"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p>M\u1ed9t \u0111i\u1ec1u m\u00e0 b\u1ea1n n\u00ean l\u01b0u \u00fd v\u1ec1 nh\u1eefng pivot table l\u00e0 h\u1ea7u h\u1ebft c\u00e1c v\u00ed d\u1ee5 m\u00e0 b\u1ea1n t\u1eebng g\u1eb7p \u0111\u1ec1u d\u1ef1a tr\u00ean d\u1eef li\u1ec7u doanh s\u1ed1 b\u00e1n h\u00e0ng. Theo c\u00e1ch n\u00e0o \u0111\u00f3, \u0111i\u1ec1u n\u00e0y kh\u00e1 h\u1ee3p l\u00ed: \u1edf \u0111\u00e2u c\u00f3 bu\u00f4n b\u00e1n, \u1edf \u0111\u00f3 c\u00f3 ti\u1ec1n, v\u00e0 c\u00e1c c\u00f4ng ty th\u00ec lu\u00f4n lu\u00f4n c\u00f3 d\u1eef li\u1ec7u d\u1eef li\u1ec7u doanh thu d\u01b0\u1edbi d\u1ea1ng n\u00e0y ho\u1eb7c d\u1ea1ng kh\u00e1c. Tuy nhi\u00ean, pivot table c\u00f3 th\u1ec3 x\u1eed l\u00ed nhi\u1ec1u h\u01a1n l\u00e0 ch\u1ec9 m\u1ed7i doanh s\u1ed1. B\u1ea5t k\u00ec khi n\u00e0o b\u1ea1n c\u1ea7n ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi d\u1eef li\u1ec7u, b\u1ea1n h\u00e3y ngh\u0129 v\u1ec1 pivot table<\/p>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 5 v\u00ed d\u1ee5 th\u00fa v\u1ecb ch\u1eafc h\u1eb3n b\u1ea1n ch\u01b0a t\u1eebng g\u1eb7p tr\u01b0\u1edbc \u0111\u00e2y, v\u00e0 ch\u00fang s\u1ebd gi\u00fap b\u1ea1n th\u1ea5y \u0111\u01b0\u1ee3c pivot table h\u1eefu d\u1ee5ng v\u00e0 linh ho\u1ea1t th\u1ebf n\u00e0o.<\/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-67871c8b61859\" class=\"ez-toc-cssicon-toggle-label\"><span class=\"\"><span class=\"eztoc-hide\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><\/span><\/span><\/label><\/p>\n<nav>\n<ul class=\"ez-toc-list ez-toc-list-level-1 \">\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Theo_doi_thoi_gian\" title=\"Theo d\u00f5i th\u1eddi gian\">Theo d\u00f5i th\u1eddi gian<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Hoat_dong_nguoi_dung_trong_mot_cong_web\" title=\"Ho\u1ea1t \u0111\u1ed9ng ng\u01b0\u1eddi d\u00f9ng\u00a0trong\u00a0m\u1ed9t c\u1ed5ng web\">Ho\u1ea1t \u0111\u1ed9ng ng\u01b0\u1eddi d\u00f9ng\u00a0trong\u00a0m\u1ed9t c\u1ed5ng web<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Danh_sach_lop_hoc\" title=\"Danh s\u00e1ch l\u1edbp h\u1ecdc\">Danh s\u00e1ch l\u1edbp h\u1ecdc<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Do_luong_dung_cu\" title=\"\u0110o l\u01b0\u1eddng d\u1ee5ng c\u1ee5\">\u0110o l\u01b0\u1eddng d\u1ee5ng c\u1ee5<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Dang_ki_Email\" title=\"\u0110\u0103ng k\u00ed Email\">\u0110\u0103ng k\u00ed Email<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/5-pivot-table-ma-chac-han-ban-chua-tung-gap-truoc-day.html#Tom_luoc\" title=\"T\u00f3m l\u01b0\u1ee3c\">T\u00f3m l\u01b0\u1ee3c<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Theo_doi_thoi_gian\"><\/span>Theo d\u00f5i th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00e3y t\u01b0\u1edfng t\u01b0\u1ee3ng b\u1ea1n c\u1ea7n ph\u1ea3i \u0111\u0103ng nh\u1eadp th\u1eddi gian cho\u00a0nh\u1eefng kh\u00e1ch h\u00e0ng v\u00e0 d\u1ef1 \u00e1n kh\u00e1c nhau, v\u00e0 \u0111\u1ecbnh k\u00ec b\u00e1o c\u00e1o th\u1eddi gian\u00a0c\u1ee7a d\u1ef1 \u00e1n v\u00e0 kh\u00e1ch h\u00e0ng. T\u1ea5t nhi\u00ean s\u1ebd c\u00f3 r\u1ea5t nhi\u1ec1u \u1ee9ng d\u1ee5ng d\u00e0nh ri\u00eang cho\u00a0vi\u1ec7c theo d\u00f5i th\u1eddi gian, tuy nhi\u00ean, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng t\u1ea1o ra m\u1ed9t h\u1ec7 th\u1ed1ng linh ho\u1ea1t c\u1ee7a ri\u00eang b\u1ea1n b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng Pivot Table.<\/p>\n<p>\u1ede m\u1ee9c t\u1ed1i thi\u1ec3u, \u0111i\u1ec1u m\u00e0 b\u1ea1n c\u1ea7n ghi l\u1ea1i l\u00e0 ng\u00e0y th\u00e1ng (date), th\u1eddi gian b\u1ea1n s\u1eed d\u1ee5ng (time), t\u00ean kh\u00e1ch h\u00e0ng (client), v\u00e0 d\u1ef1 \u00e1n (project). V\u1eady n\u00ean, sau khi b\u1ea1n nh\u1eadp d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch nh\u1ea5t qu\u00e1n, k\u1ebft qu\u1ea3 d\u1eef li\u1ec7u ngu\u1ed3n s\u1ebd gi\u1ed1ng nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9037 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/1-7-300x149-1.png\" width=\"300\" height=\"149\" title=\"1-7-300x149-1\"><\/p>\n<p>L\u01b0u \u00fd r\u1eb1ng s\u1ebd kh\u00f4ng c\u00f3 d\u00f2ng tr\u1ed1ng \u2013 b\u1ea1n ch\u1ec9 c\u1ea7n nh\u1eadp ti\u1ebfp d\u1eef li\u1ec7u.<\/p>\n<p>B\u00e2y gi\u1edd l\u00e0 c\u00e1c t\u00f3m t\u1eaft. \u0110\u1ea7u ti\u00ean, b\u1ea1n c\u00f3 th\u1ec3 s\u1ebd mu\u1ed1n c\u00f3 m\u1ed9t c\u00e1i nh\u00ecn t\u1ed5ng qu\u00e1t v\u1ec1 th\u1eddi gian c\u1ee7a b\u1ea1n theo tu\u1ea7n. Trong b\u1ea3ng ta s\u1eed d\u1ee5ng s\u1ed1 tu\u1ea7n \u0111\u01b0\u1ee3c cung c\u1ea5p b\u1edfi \u00a0<a href=\"https:\/\/exceljet.net\/excel-functions\/excel-weeknum-function\">WEEKNUM function<\/a>\u00a0c\u1ee7a Excel (xem c\u1ed9t C c\u1ee7a d\u1eef li\u1ec7u ngu\u1ed3n):<\/p>\n<div class=\"code-block code-block-1\" style=\"margin: 8px 0;clear: both\">\n<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-280.gif\" title=\"ex101_92019-nho-280\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9036 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/2-5-300x149-1.png\" width=\"300\" height=\"149\" title=\"2-5-300x149-1\"><\/p>\n<p>B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 s\u1ebd mu\u1ed1n s\u1eafp x\u1ebfp pivot table \u0111\u1ec3 bi\u1ec3u di\u1ec5n nhi\u1ec1u l\u1edbp th\u1eddi gian bi\u1ec3u truy\u1ec1n th\u1ed1ng, v\u1edbi c\u00e1c ng\u00e0y trong tu\u1ea7n n\u1eb1m \u1edf ph\u00eda tr\u00ean c\u00f9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9035 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/3-5-300x149-1.png\" width=\"300\" height=\"149\" title=\"3-5-300x149-1\"><\/p>\n<p>M\u1ed7i l\u1ea7n b\u1ea1n l\u1ecdc m\u1ed9t s\u1ed1 tu\u1ea7n kh\u00e1c nhau, pivot table c\u1ee7a b\u1ea1n s\u1ebd t\u1ea1o ra m\u1ed9t th\u1eddi gian bi\u1ec3u m\u1edbi \u0111\u1ec3 bi\u1ec3u di\u1ec5n c\u00e1c ng\u00e0y trong tu\u1ea7n.<\/p>\n<p>L\u01b0u \u00fd r\u1eb1ng b\u1eb1ng vi\u1ec7c th\u00eam v\u00e0o m\u1ed9t c\u1ed9t cho T\u00ean (Name) v\u00e0o d\u1eef li\u1ec7u, b\u1ea1n c\u00f3 th\u1ec3 theo d\u00f5i v\u00e0 b\u00e1o c\u00e1o th\u1eddi gian cho nhi\u1ec1u ng\u01b0\u1eddi. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 th\u00eam m\u1ed9t c\u1ed9t t\u1ef7 l\u1ec7 v\u00e0o d\u1eef li\u1ec7u v\u00e0 s\u1eed d\u1ee5ng pivot table \u0111\u1ec3 t\u00f3m l\u01b0\u1ee3c gi\u00e1 c\u1ea3 ho\u1eb7c t\u1ec9 l\u1ec7 thanh to\u00e1n c\u1ee7a th\u1eddi gian \u0111\u0103ng nh\u1eadp.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Hoat_dong_nguoi_dung_trong_mot_cong_web\"><\/span>Ho\u1ea1t \u0111\u1ed9ng ng\u01b0\u1eddi d\u00f9ng\u00a0trong\u00a0m\u1ed9t c\u1ed5ng web<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>H\u00ecnh dung r\u1eb1ng b\u1ea1n \u0111\u01b0\u1ee3c giao\u00a0m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u t\u1eeb website c\u1ee7a m\u1ed9t c\u00f4ng ty l\u1edbn. Trang web l\u00e0 m\u1ed9t c\u1ed5ng cung c\u1ea5p th\u00f4ng tin s\u1ea3n ph\u1ea9m cho\u00a0\u0111\u1ed1i t\u00e1c. C\u00e1c \u0111\u1ed1i t\u00e1c \u0111\u0103ng k\u00ed tr\u00ean m\u1ed9t n\u1ec1n t\u1ea3ng xuy\u00ean su\u1ed1t n\u0103m, v\u00e0 c\u1ed5ng n\u00e0y s\u1ebd ho\u1ea1t \u0111\u1ed9ng trong m\u1ed9t th\u1eddi gian d\u00e0i. B\u1ea1n h\u00e3y m\u1edf d\u1eef li\u1ec7u v\u00e0 quan s\u00e1t,\u00a0d\u1eef li\u1ec7u s\u1ebd gi\u1ed1ng nh\u01b0 b\u1ea3ng d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9034 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/4-4-300x149-1.png\" width=\"300\" height=\"149\" title=\"4-4-300x149-1\"><\/p>\n<p>S\u1ebfp c\u1ee7a b\u1ea1n mu\u1ed1n bi\u1ebft m\u1ed9t v\u00e0i th\u00f4ng tin c\u01a1 b\u1ea3n: c\u00f3 bao nhi\u00eau ng\u01b0\u1eddi d\u00f9ng hi\u1ec7n t\u1ea1i \u0111ang ho\u1ea1t \u0111\u1ed9ng? C\u00f3 bao nhi\u00eau ng\u01b0\u1eddi d\u00f9ng \u0111\u01b0\u1ee3c t\u1ea1o ra m\u1ed7i th\u00e1ng? \u0110\u1ed1i t\u00e1c n\u00e0o c\u00f3 nhi\u1ec1u t\u00e0i kho\u1ea3n ng\u01b0\u1eddi d\u00f9ng nh\u1ea5t?\u2026<\/p>\n<p>Nh\u1eefng d\u1ea1ng d\u1eef li\u1ec7u n\u00e0y r\u1ea5t ph\u00f9 h\u1ee3p cho pivot table. Pivot table s\u1ebd gi\u00fap b\u1ea1n gi\u1ea3i quy\u1ebft c\u00e1c d\u1ea1ng d\u1eef li\u1ec7u n\u00e0y m\u1ed9t c\u00e1ch nhanh ch\u00f3ng. \u0110\u1ea7u ti\u00ean, ng\u01b0\u1eddi d\u00f9ng \u0111ang ho\u1ea1t \u0111\u1ed9ng v\u00e0 kh\u00f4ng ho\u1ea1t \u0111\u1ed9ng. D\u1ea1ng t\u00f3m t\u1eaft n\u00e0y l\u00e0 m\u1ed9t m\u1ea9u trong c\u1ea3 chi\u1ebfc b\u00e1nh, th\u1eadm ch\u00ed v\u1edbi m\u1ed9t l\u01b0\u1ee3ng c\u1ef1c l\u1edbn d\u1eef li\u1ec7u:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9033 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/5-4-300x149-1.png\" width=\"300\" height=\"149\" title=\"5-4-300x149-1\"><\/p>\n<p>Ti\u1ebfp theo, t\u1ed1p 10 \u0111\u1ed1i t\u00e1c h\u00e0ng \u0111\u1ea7u theo s\u1ed1 l\u01b0\u1ee3ng ng\u01b0\u1eddi d\u00f9ng ho\u1ea1t \u0111\u1ed9ng. \u00a0R\u1ea5t d\u1ec5 d\u00e0ng ho\u00e0n th\u00e0nh ch\u1ec9 v\u1edbi pivot table gi\u00e1 tr\u1ecb l\u1ecdc c\u00f3 s\u1eb5n \u201cTop 10\u201d.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9032 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/6-4-300x161-1.png\" width=\"300\" height=\"161\" title=\"6-4-300x161-1\"><\/p>\n<p>V\u00e0 cu\u1ed1i c\u00f9ng, b\u1eb1ng vi\u1ec7c g\u1ed9p nh\u00f3m c\u00e1c ng\u00e0y t\u1ea1o ra ng\u01b0\u1eddi d\u00f9ng theo th\u00e1ng v\u00e0 n\u0103m, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng bi\u1ec3u di\u1ec5n to\u00e0n b\u1ed9 l\u1ecbch s\u1eed t\u1ea1o ra ng\u01b0\u1eddi d\u00f9ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9031 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/7-3-300x149-1.png\" width=\"300\" height=\"149\" title=\"7-3-300x149-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Danh_sach_lop_hoc\"><\/span>Danh s\u00e1ch l\u1edbp h\u1ecdc<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Trong v\u00ed d\u1ee5 n\u00e0y, b\u1ea1n s\u1ebd gi\u00fap \u0111i\u1ec1u ph\u1ed1i vi\u1ec7c \u0111\u0103ng k\u00ed cho m\u1ed9t l\u1edbp h\u1ecdc v\u00e0o c\u00e1c ng\u00e0y th\u1ee9 hai, th\u1ee9 t\u01b0 v\u00e0 th\u1ee9 6. M\u1ed7i ng\u00e0y trong su\u1ed1t kho\u1ea3ng th\u1eddi gian \u0111\u0103ng k\u00ed, b\u1ea1n s\u1ebd c\u00f3 m\u1ed9t b\u1ed9 d\u1eef li\u1ec7u nh\u01b0 d\u01b0\u1edbi \u0111\u00e2y:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9030 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/8-2-300x126-1.png\" width=\"300\" height=\"126\" title=\"8-2-300x126-1\"><\/p>\n<p>C\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n l\u00e0 g\u1eedi m\u1ed9t b\u00e1o c\u00e1o \u0111\u01a1n gi\u1ea3n t\u1edbi ng\u01b0\u1eddi h\u01b0\u1edbng d\u1eabn v\u00e0o \u0111\u1ea7u m\u1ed7i ng\u00e0y \u0111\u0103ng k\u00ed. Kh\u00f4ng c\u00f3 nhi\u1ec1u d\u1eef li\u1ec7u \u1edf \u0111\u00e2y, nh\u01b0ng n\u1ebfu b\u1ea1n t\u1ea1o ra m\u1ed9t b\u00e1o c\u00e1o b\u1eb1ng tay, b\u1ea1n s\u1ebd c\u1ea7n k\u1ebft h\u1ee3p c\u1ea3 vi\u1ec7c l\u1ecdc, s\u1eafp x\u1ebfp, sao ch\u00e9p v\u00e0 d\u00e1n, v\u00e0 b\u1ea1n s\u1ebd c\u1ea7n ph\u1ea3i l\u1eb7p \u0111i l\u1eb7p l\u1ea1i qu\u00e1 tr\u00ecnh \u0111\u00f3 m\u1ed7i ng\u00e0y.<\/p>\n<p>M\u1ed9t l\u1ea7n n\u1eefa, \u0111\u00e2y l\u1ea1i l\u00e0 m\u1ed9t c\u00f4ng vi\u1ec7c \u0111\u01a1n gi\u1ea3n \u0111\u1ed1i v\u1edbi pivot table. Ch\u1ec9 c\u1ea7n d\u1ef1ng m\u1ed9t pivot table \u0111\u01a1n gi\u1ea3n \u0111\u1ec3 t\u00f3m l\u01b0\u1ee3c ng\u00e0y h\u1ecdc c\u1ee7a l\u1edbp:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9029 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/9-2-300x197-1.png\" width=\"300\" height=\"197\" title=\"9-2-300x197-1\"><\/p>\n<p>B\u1eb1ng vi\u1ec7c th\u00eam v\u00e0o b\u1ea3ng t\u00ean h\u1ecdc sinh, b\u1ea1n c\u00f3 th\u1ec3 nhanh ch\u00f3ng t\u1ea1o ra m\u1ed9t danh s\u00e1ch l\u1edbp \u0111\u1ea7y \u0111\u1ee7.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9028 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/10-2-239x300-1.png\" width=\"239\" height=\"300\" title=\"10-2-239x300-1\"><\/p>\n<p>V\u1edbi vi\u1ec7c di chuy\u1ec3n v\u00f9ng L\u1edbp h\u1ecdc (Class) v\u00e0o v\u00f9ng c\u00e1c nh\u00e3n theo c\u1ed9t, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o ra m\u1ed9t b\u00e1o c\u00e1o m\u00e0 trong \u0111\u00f3 t\u00ean c\u1ee7a h\u1ecdc sinh \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo th\u1ee9 t\u1ef1 b\u1ea3ng ch\u1eef c\u00e1i.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9027 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/11-1-239x300-1.png\" width=\"239\" height=\"300\" title=\"11-1-239x300-1\"><\/p>\n<p>B\u00e2y gi\u1edd b\u1ea1n \u0111\u00e3 c\u00f3 m\u1ed9t b\u00e1o c\u00e1o \u0111\u01b0\u1ee3c b\u1ed1 tr\u00ed nh\u01b0 b\u1ea1n mong mu\u1ed1n, v\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 b\u1ea1n c\u1eadp nh\u1eadp n\u00f3 m\u1ed7i ng\u00e0y? R\u1ea5t \u0111\u01a1n gi\u1ea3n, h\u00e3y d\u00e1n v\u00e0o d\u1eef li\u1ec7u m\u1edbi nh\u1ea5t, ghi \u0111\u00e8 l\u00ean nh\u1eefng d\u1eef li\u1ec7u \u0111\u00e3 c\u00f3, v\u00e0 l\u00e0m m\u1edbi pivot table.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Do_luong_dung_cu\"><\/span>\u0110o l\u01b0\u1eddng d\u1ee5ng c\u1ee5<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>C\u1ee9 m\u1ed7i hai ph\u00fat, b\u1ea1n c\u00f3 \u0111\u01b0\u1ee3c d\u1eef li\u1ec7u \u0111o l\u01b0\u01a1ng t\u1eeb m\u1ed9t h\u1ec7 th\u1ed1ng ghi ch\u00e9p nhi\u1ec7t \u0111\u1ed9, \u0111\u1ed9 \u1ea9m t\u01b0\u01a1ng \u0111\u1ed1i, v\u00e0 nh\u1eefng \u0111i\u1ec3m s\u01b0\u01a1ng m\u00f9 trong nh\u00e0 k\u00ednh:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9026 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/12-2-300x211-1.png\" width=\"300\" height=\"211\" title=\"12-2-300x211-1\"><\/p>\n<p>\u0110i\u1ec1u b\u1ea1n c\u1ea7n l\u00e0 nhanh ch\u00f3ng bi\u1ec3u di\u1ec5n m\u1ee9c \u0111\u1ecdc trung b\u00ecnh qua m\u1ed7i gi\u1edd. V\u00e0 b\u1ea1n c\u00f3 th\u1ec3 d\u1ef1ng l\u00ean m\u1ed9t c\u00f4ng th\u1ee9c c\u1ee7a ri\u00eang m\u00ecnh \u0111\u1ec3 l\u00e0m \u0111i\u1ec1u n\u00e0y, nh\u01b0ng vi\u1ec7c n\u00e0y kh\u00e1 l\u00e0 m\u1ea5t th\u1eddi gian. B\u1eb1ng vi\u1ec7c \u0111\u01b0a d\u1eef li\u1ec7u v\u00e0o pivot table, b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u00eam\u00a0ph\u00e9p\u00a0\u0111o l\u01b0\u1eddng v\u00e0o nh\u01b0 m\u1ed9t gi\u00e1 tr\u1ecb, v\u00e0 thay \u0111\u1ed5i bi\u1ec3u hi\u1ec7n \u0111\u1ec3 di\u1ec5n t\u1ea3 m\u1ee9c trung b\u00ecnh thay v\u00ec c\u1ea3 t\u1ed5ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9025 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/13-1-300x211-1.png\" width=\"300\" height=\"211\" title=\"13-1-300x211-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Dang_ki_Email\"><\/span>\u0110\u0103ng k\u00ed Email<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>B\u1ea1n \u0111ang l\u00e0m vi\u1ec7c v\u1edbi kh\u00e1ch h\u00e0ng, ng\u01b0\u1eddi m\u00e0 \u0111ang theo d\u00f5i vi\u1ec7c \u0111\u0103ng k\u00ed email tr\u00ean website c\u1ee7a h\u1ecd. Kh\u00e1ch h\u00e0ng \u0111ang l\u1eadp m\u1ed9t d\u1ef1 \u00e1n ti\u1ebfp th\u1ecb m\u1edbi v\u00e0 mu\u1ed1n bi\u1ebft ng\u00e0y n\u00e0o trong tu\u1ea7n c\u00f3 l\u01b0\u1ee3ng \u0111\u0103ng k\u00ed l\u1edbn nh\u1ea5t, d\u1ef1a tr\u00ean d\u1eef li\u1ec7u h\u1ecd c\u00f3 \u0111\u01b0\u1ee3c ch\u00f3 \u0111\u1ebfn nay. Ng\u00e0y trong tu\u1ea7n c\u00f3 ch\u00fat r\u1eafc r\u1ed1i, b\u1edfi v\u00ec n\u00f3 kh\u00f4ng xu\u1ea5t hi\u1ec7n \u1edf b\u1ea5t c\u1ee9 n\u01a1i n\u00e0o tr\u00ean d\u1eef li\u1ec7u, nh\u01b0ng b\u1ea1n c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng th\u00eam n\u00f3 v\u00e0o d\u1eef li\u1ec7u b\u1eb1ng vi\u1ec7c s\u1eed d\u1ee5ng\u00a0<a href=\"https:\/\/exceljet.net\/excel-functions\/excel-weekday-function\">WEEKDAY function<\/a>. V\u00e0 d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n s\u1ebd c\u00f3 d\u1ea1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9024 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/14-1-300x178-1.png\" width=\"300\" height=\"178\" title=\"14-1-300x178-1\"><\/p>\n<p>V\u00e0 b\u1ea3n t\u00f3m l\u01b0\u1ee3c ban \u0111\u1ea7u s\u1ebd c\u00f3 d\u1ea1ng:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9023 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/15-1-300x272-1.png\" width=\"300\" height=\"272\" title=\"15-1-300x272-1\"><\/p>\n<p>Nh\u00ecn v\u00e0o d\u1eef li\u1ec7u, b\u1ea1n s\u1ebd nh\u1eadn ra r\u1eb1ng bi\u1ec3u di\u1ec5n t\u1ed5ng l\u01b0\u1ee3ng \u0111\u0103ng k\u00ed thoe ph\u1ea7n tr\u0103m s\u1ebd hi\u1ec7u qu\u1ea3 h\u01a1n l\u00e0 bi\u1ec3u di\u1ec5n theo nh\u1eefng con s\u1ed1 tuy\u1ec7t \u0111\u1ed1i. B\u1eb1ng vi\u1ec7c thi\u1ebft l\u1eadp s\u1ed1 l\u01b0\u1ee3ng email \u0111\u1ec3 bi\u1ec3u di\u1ec5n ph\u1ea7n tr\u0103m c\u1ee7a m\u1ed9t h\u00e0ng, pivot table s\u1ebd th\u1ec3 hi\u1ec7n theo ng\u00e0y trong tu\u1ea7n. H\u01a1n th\u1ebf n\u1eefa, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam \u0111\u1ecbnh d\u1ea1ng \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 l\u00e0m n\u1ed5i b\u1eadt t\u1ec9 su\u1ea5t cao h\u01a1n ho\u1eb7c th\u1ea5p h\u01a1n. Xanh l\u00e1 c\u00e2y cho t\u1ec9 su\u1ea5t cao h\u01a1n v\u00e0 xanh n\u01b0\u1edbc bi\u1ec3n cho t\u1ec9 su\u1ea5t th\u1ea5p h\u01a1n.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"alignnone size-medium wp-image-9022 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/16-1-300x272-1.png\" width=\"300\" height=\"272\" title=\"16-1-300x272-1\"><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Tom_luoc\"><\/span>T\u00f3m l\u01b0\u1ee3c<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>Mong r\u1eb1ng b\u00e0i vi\u1ebft ng\u1eafn n\u00e0y s\u1ebd gi\u00fap b\u1ea1n thay \u0111\u1ed5i suy ngh\u0129 v\u1ec1\u00a0nh\u1eefng pivot table m\u00e0 b\u1ea1n \u0111\u00e3 t\u1eebng ngh\u0129 r\u1eb1ng ch\u00fang g\u00e2y ra nhi\u1ec1u kh\u00f3 kh\u0103n, hy v\u1ecdng b\u00e0i vi\u1ebft s\u1ebd truy\u1ec1n cho b\u1ea1n c\u1ea3m h\u1ee9ng \u0111\u1ec3 th\u1eed nh\u1eefng pivot table m\u1edbi l\u00ean d\u1eef li\u1ec7u c\u1ee7a b\u1ea1n. B\u1ea1n kh\u00f4ng c\u1ea7n ph\u1ea3i c\u00f3 b\u1ed9 d\u1eef li\u1ec7u kh\u1ed5ng l\u1ed3 m\u1edbi c\u00f3 th\u1ec3 th\u1ea5y \u0111\u01b0\u1ee3c l\u1ee3i \u00edch c\u1ee7a vi\u1ec7c s\u1eed d\u1ee5ng pivot table. Pivot table s\u1ebd gi\u00fap ti\u1ebft ki\u1ec7m cho b\u1ea1n th\u1eddi gian v\u00e0 n\u0103ng l\u01b0\u1ee3ng, b\u1ea5t k\u1ec3 khi n\u00e0o b\u1ea1n c\u1ea7n t\u1ea1o m\u1ed9t b\u00e1o c\u00e1o, \u0111\u1eb7c bi\u1ec7t nh\u1eefng b\u00e1o c\u00e1o m\u00e0 b\u1ea1 c\u1ea7n ph\u1ea3i c\u1eadp nh\u1eadp li\u00ean t\u1ee5c trong t\u01b0\u01a1ng lai.<\/p>\n<p>Ngu\u1ed3n: Exceljet<\/p>\n<\/div>\n<div class=\"uk-panel uk-margin uk-width-xlarge\">\n<p>Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/khoa-hoc\" target=\"_blank\" rel=\"noopener\">T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0<span>\ud83d\udcd6<\/span><\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/huong-dan-kich-hoat-khoa-hoc-tai-hoc-excel-online.html\" target=\"_blank\" rel=\"noopener\">H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n<p>HKD H\u1ecdc Excel Online<br \/>S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n<div class=\"uk-panel uk-text-small uk-margin uk-margin-remove-bottom uk-text-center\">\n<p>\u00a9  document.currentScript.insertAdjacentHTML(&#8216;afterend&#8217;, &#8221; + new Intl.DateTimeFormat(document.documentElement.lang, {year: &#8216;numeric&#8217;}).format() + &#8221;);  H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"<div class=\"ad-inserterpro\">\n<a href=\"https:\/\/hocexcel.online\/course\/preview\/ex101-excel-tu-co-ban-den-chuyen-gia-danh-cho-nguoi-di-lam\"><br \/>\n<img decoding=\"async\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/ex101_92019-nho-280.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11275,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11274","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\/11274","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=11274"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11274\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11275"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11274"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11274"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11274"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}