{"id":1428,"date":"2024-12-02T05:05:58","date_gmt":"2024-12-02T05:05:58","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/16-thu-thuat-google-sheet-ban-can-phai-biet-de-khong-lac-hau\/"},"modified":"2024-12-02T05:05:58","modified_gmt":"2024-12-02T05:05:58","slug":"16-thu-thuat-google-sheet-ban-can-phai-biet-de-khong-lac-hau","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/16-thu-thuat-google-sheet-ban-can-phai-biet-de-khong-lac-hau\/","title":{"rendered":"16 th\u1ee7 thu\u1eadt Google Sheet b\u1ea1n c\u1ea7n ph\u1ea3i bi\u1ebft \u0111\u1ec3 kh\u00f4ng l\u1ea1c h\u1eadu"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nO_m37Xw#1\">\n<p>Google Sheet l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 mi\u1ec5n ph\u00ed g\u1ea7n gi\u1ed1ng nh\u01b0 Excel. Tuy Google Sheet c\u00f3 nh\u1eefng \u0111i\u1ec3m ch\u01b0a b\u1eb1ng Excel nh\u01b0ng c\u00f3 nh\u1eefng \u0111i\u1ec3m kh\u00e1c Google Sheet l\u1ea1i h\u01a1n h\u1eb3n Excel \u0111\u1ec3 x\u1eed l\u00fd m\u1ed9t s\u1ed1 c\u00f4ng vi\u1ec7c c\u1ee5 th\u1ec3.<\/p>\n<p>B\u00e0i vi\u1ebft n\u00e0y s\u1ebd gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n 16 th\u1ee7 thu\u1eadt c\u1ee7a Google Sheet, v\u1edbi<strong> c\u00e1c h\u00e0m trong google sheet<\/strong> c\u00e1c b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 thay \u0111\u1ed5i suy ngh\u0129 c\u1ee7a m\u00ecnh v\u1ec1 Google Sheet v\u00e0 th\u1eadm ch\u00ed chuy\u1ec3n sang s\u1eed d\u1ee5ng c\u00f4ng c\u1ee5 n\u00e0y.<\/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-674d4035bb731\" 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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Cac_phim_tat_trong_Google_Sheet\" title=\"C\u00e1c ph\u00edm t\u1eaft trong Google Sheet:\">C\u00e1c ph\u00edm t\u1eaft trong Google Sheet:<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Chen_anh_vao_o_bang_tinh_voi_URL\" title=\"Ch\u00e8n \u1ea3nh v\u00e0o \u00f4 b\u1ea3ng t\u00ednh v\u1edbi URL\">Ch\u00e8n \u1ea3nh v\u00e0o \u00f4 b\u1ea3ng t\u00ednh v\u1edbi URL<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Su_dung_cau_lenh_SQL_de_loc_tong_hop_va_phan_tich_du_lieu_ngay_trong_bang_tinh_Google\" title=\"S\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL \u0111\u1ec3 l\u1ecdc, t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ngay trong b\u1ea3ng t\u00ednh Google:\">S\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL \u0111\u1ec3 l\u1ecdc, t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ngay trong b\u1ea3ng t\u00ednh Google:<\/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-4\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-google-sheets-co-ban-nang-cao.html#Lay_ra_phan_ngay_thang_nam_trong_1_thoi_diem\" title=\"L\u1ea5y ra ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m trong 1 th\u1eddi \u0111i\u1ec3m:\">L\u1ea5y ra ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m trong 1 th\u1eddi \u0111i\u1ec3m:<\/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-5\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-google-sheets-co-ban-nang-cao.html#Tao_QR_code_ngay_trong_Google_Sheet\" title=\"T\u1ea1o QR code ngay trong Google Sheet:\">T\u1ea1o QR code ngay trong Google Sheet:<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Tra_cuu_du_lieu_theo_dieu_kien_o_nhieu_cot\" title=\"Tra c\u1ee9u d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n \u1edf nhi\u1ec1u c\u1ed9t\">Tra c\u1ee9u d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n \u1edf nhi\u1ec1u c\u1ed9t<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Su_dung_ham_loc_du_lieu_FILTER\" title=\"S\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u FILTER()\">S\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u FILTER()<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Lay_gia_tri_duy_nhat_trong_cot_bang_ham_UNIQUE\" title=\"L\u1ea5y gi\u00e1 tr\u1ecb duy nh\u1ea5t trong c\u1ed9t b\u1eb1ng h\u00e0m UNIQUE\">L\u1ea5y gi\u00e1 tr\u1ecb duy nh\u1ea5t trong c\u1ed9t b\u1eb1ng h\u00e0m UNIQUE<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Scrape_Web_voi_Google_Sheets\" title=\"Scrape Web v\u1edbi Google Sheets\">Scrape Web v\u1edbi Google Sheets<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Nhan_dang_ngon_ngu_voi_Google_Sheets\" title=\"Nh\u1eadn d\u1ea1ng ng\u00f4n ng\u1eef v\u1edbi Google Sheets\">Nh\u1eadn d\u1ea1ng ng\u00f4n ng\u1eef v\u1edbi Google Sheets<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Dich_ngon_ngu_truc_tiep_trong_Google_Sheets\" title=\"D\u1ecbch ng\u00f4n ng\u1eef tr\u1ef1c ti\u1ebfp trong Google Sheets\">D\u1ecbch ng\u00f4n ng\u1eef tr\u1ef1c ti\u1ebfp trong Google Sheets<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Kiem_tra_Emails_va_URLs_dung_chuan\" title=\"Ki\u1ec3m tra Emails v\u00e0 URLs \u0111\u00fang chu\u1ea9n\">Ki\u1ec3m tra Emails v\u00e0 URLs \u0111\u00fang chu\u1ea9n<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Du_doan_gia_tri_trong_tuong_lai_voi_ham_Growth\" title=\"D\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb trong t\u01b0\u01a1ng lai v\u1edbi h\u00e0m Growth()\">D\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb trong t\u01b0\u01a1ng lai v\u1edbi h\u00e0m Growth()<\/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\/thu-thuat-google-sheets-co-ban-nang-cao.html#Lam_cong_thuc_doc_de_hon_bang_cach_xuong_dong\" title=\"L\u00e0m c\u00f4ng th\u1ee9c \u0111\u1ecdc d\u1ec5 h\u01a1n b\u1eb1ng c\u00e1ch xu\u1ed1ng d\u00f2ng\">L\u00e0m c\u00f4ng th\u1ee9c \u0111\u1ecdc d\u1ec5 h\u01a1n b\u1eb1ng c\u00e1ch xu\u1ed1ng d\u00f2ng<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-15\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-google-sheets-co-ban-nang-cao.html#Them_nhung_ky_tu_dac_biet_vao_Google_Sheets\" title=\"Th\u00eam nh\u1eefng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o Google Sheets\">Th\u00eam nh\u1eefng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o Google Sheets<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-16\" href=\"https:\/\/blog.hocexcel.online\/thu-thuat-google-sheets-co-ban-nang-cao.html#Lay_gia_tri_ngau_nhien_tu_1_danh_sach\" title=\"L\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean t\u1eeb 1 danh s\u00e1ch\">L\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean t\u1eeb 1 danh s\u00e1ch<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h2><span class=\"ez-toc-section\" id=\"Cac_phim_tat_trong_Google_Sheet\"><\/span>C\u00e1c ph\u00edm t\u1eaft trong Google Sheet:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 \u0111\u00e3 bi\u1ebft \u0111\u01b0\u1ee3c 1 s\u1ed1 ph\u00edm t\u1eaft trong Excel, Google Sheet c\u0169ng h\u1ed7 tr\u1ee3 r\u1ea5t nhi\u1ec1u ph\u00edm t\u1eaft \u0111\u00f3. H\u01a1n n\u1eefa, Google Sheet c\u00f2n cho b\u1ea1n 1 danh s\u00e1ch c\u00e1c ph\u00edm t\u1eaft ngay trong ph\u1ea7n m\u1ec1m n\u00e0y. C\u00e1c b\u1ea1n ch\u1ec9 c\u1ea7n b\u1ea5m v\u00e0o Menu Help r\u1ed3i ch\u1ecdn Keyboard Shortcuts \u0111\u1ec3 g\u1ecdi ra b\u1ea3ng t\u1ed5ng k\u1ebft n\u00e0y<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/keyboard-shortcut-google-sheets.gif\"><br \/>\n<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/keyboard-shortcut-google-sheets.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6088\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/keyboard-shortcut-google-sheets.gif\" alt=\"keyboard-shortcut-google-sheets\" width=\"1140\" height=\"1154\" title=\"keyboard-shortcut-google-sheets\"><\/a><\/p>\n<blockquote>\n<p>Xem th\u00eam:\u00a0<span data-sheets-value='{\"1\":2,\"2\":\"h\u1ecdc excel v\u0103n ph\u00f2ng\"}' data-sheets-userformat='{\"2\":2561,\"3\":[null,0],\"12\":0,\"14\":[null,2,16711680]}'><a href=\"http:\/\/blog.ezworkapp.com\">h\u1ecdc excel v\u0103n ph\u00f2ng<\/a> uy ti\u0301n, ch\u00e2\u0301t l\u01b0\u01a1ng.<\/span><\/p>\n<\/blockquote>\n<h2><span class=\"ez-toc-section\" id=\"Chen_anh_vao_o_bang_tinh_voi_URL\"><\/span>Ch\u00e8n \u1ea3nh v\u00e0o \u00f4 b\u1ea3ng t\u00ednh v\u1edbi URL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google sheet cung c\u1ea5p cho ch\u00fang ta 1 c\u00f4ng c\u1ee5 c\u1ef1c t\u1ed1t \u0111\u1ec3 c\u00f3 th\u1ec3 ch\u00e8n \u1ea3nh v\u00e0o trong \u00f4 b\u1ea3ng t\u00ednh, \u0111\u00f3 ch\u00ednh l\u00e0 <strong>h\u00e0m Image.\u00a0<\/strong>C\u00e1ch s\u1eed d\u1ee5ng nh\u01b0 sau:<\/p>\n<ul>\n<li>=image(\u201c\u0111\u01b0\u1eddng d\u1eabn URL t\u1edbi \u1ea3nh\u201d,1) \u2013 \u1ea3nh t\u1ef1 thay \u0111\u1ed5i k\u00edch th\u01b0\u1edbc \u0111\u1ec3 v\u1eeba v\u1edbi \u00f4<\/li>\n<li>=image(\u201c\u0111\u01b0\u1eddng d\u1eabn URL t\u1edbi \u1ea3nh\u201d,2) \u2013 \u1ea3nh t\u1ef1 gi\u00e3n ra \u0111\u1ec3 hi\u1ec3n th\u1ecb \u0111\u1ea7y \u00f4<\/li>\n<li>=image(\u201c\u0111\u01b0\u1eddng d\u1eabn URL t\u1edbi \u1ea3nh\u201d,3) \u2013 \u1ea3nh gi\u1eef nguy\u00ean k\u00edch th\u01b0\u1edbc nguy\u00ean b\u1ea3n<\/li>\n<li>=image(\u201c\u0111\u01b0\u1eddng d\u1eabn URL t\u1edbi \u1ea3nh\u201d,4) \u2013 \u1ea3nh v\u1edbi k\u00edch th\u01b0\u1edbc t\u1ef1 ch\u1ecdn<\/li>\n<\/ul>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/add-image-to-cell-google-sheets.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6089\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/add-image-to-cell-google-sheets.png\" alt=\"chen-anh-vao-bang-tinh\" width=\"843\" height=\"500\" title=\"add-image-to-cell-google-sheets\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_cau_lenh_SQL_de_loc_tong_hop_va_phan_tich_du_lieu_ngay_trong_bang_tinh_Google\"><\/span>S\u1eed d\u1ee5ng c\u00e2u l\u1ec7nh SQL \u0111\u1ec3 l\u1ecdc, t\u1ed5ng h\u1ee3p v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u ngay trong b\u1ea3ng t\u00ednh Google:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u1edbi h\u00e0m Query, Google Sheet \u0111\u01b0\u1ee3c trang b\u1ecb th\u00eam s\u1ee9c m\u1ea1nh c\u1ee7a ng\u00f4n ng\u1eef SQL, gi\u00fap ch\u00fang ta c\u00f3 th\u1ec3 vi\u1ebft ng\u00f4n ng\u1eef t\u01b0\u01a1ng t\u1ef1 nh\u01b0 SQL ngay trong Google Sheet v\u1edbi s\u1ef1 tr\u1ee3 gi\u00fap c\u1ee7a h\u00e0m Query m\u1ea1nh m\u1ebd. C\u00e1c b\u1ea1n tham kh\u1ea3o b\u00e0i vi\u1ebft chi ti\u1ebft t\u1ea1i \u0111\u01b0\u1eddng link sau \u0111\u00e2y:<\/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-104.gif\" title=\"ex101_92019-nho-104\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/ham-query-trong-google-sheet.html\" target=\"_blank\" rel=\"noopener\">H\u00e0m Query trong Google Sheet<\/a><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Lay_ra_phan_ngay_thang_nam_trong_1_thoi_diem\"><\/span>L\u1ea5y ra ph\u1ea7n ng\u00e0y th\u00e1ng n\u0103m trong 1 th\u1eddi \u0111i\u1ec3m:<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>V\u1edbi h\u00e0m INT(), ch\u00fang ta c\u00f3 th\u1ec3 d\u1ec5 d\u00e0ng l\u1ea5y ra gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng n\u0103m trong 1 th\u1eddi \u0111i\u1ec3m \u1edf tr\u00ean b\u1ea3ng t\u00ednh Google Sheet<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/tach-du-lieu-ngay-thang-nam.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6090\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tach-du-lieu-ngay-thang-nam.png\" alt=\"tach-du-lieu-ngay-thang-nam\" width=\"464\" height=\"205\" title=\"tach-du-lieu-ngay-thang-nam\"><\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/ham-sumifs-tinh-tong-theo-tuan-thang-nam.html\">H\u00e0m SUMIFS \u2013 t\u00ednh t\u1ed5ng theo tu\u1ea7n, th\u00e1ng, n\u0103m<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tao_QR_code_ngay_trong_Google_Sheet\"><\/span>T\u1ea1o QR code ngay trong Google Sheet:<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>QR code l\u00e0 m\u00e3 v\u1ea1ch 2 chi\u1ec1u d\u00f9ng \u0111\u1ec3 m\u00e3 ho\u00e1 1 th\u00f4ng tin n\u00e0o \u0111\u00f3, c\u00f3 th\u1ec3 l\u00e0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, \u0111\u1ecba ch\u1ec9 email ho\u1eb7c URL ho\u1eb7c 1 s\u1ed1 th\u00f4ng tin kh\u00e1c. Ch\u00fang ta c\u00f3 th\u1ec3 th\u1ef1c hi\u1ec7n vi\u1ec7c m\u00e3 ho\u00e1 n\u00e0y 1 c\u00e1ch r\u1ea5t \u0111\u01a1n gi\u1ea3n s\u1eed d\u1ee5ng h\u00e0m Image. C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng b\u1ea5t k\u00ec ph\u1ea7n m\u1ec1m qu\u00e9t m\u00e3 QR n\u00e0o v\u00e0 th\u1eed 2 m\u00e3 QR sau \u0111\u00e2y s\u1ebd nh\u1eadn \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3 l\u00e0 \u0111\u01b0\u1eddng link c\u1ee7a H\u1ecdc Excel Online. C\u00f2n \u0111\u01b0\u1eddng link c\u00f4ng th\u1ee9c trong \u1ea3nh minh ho\u1ea1 l\u00e0:<\/p>\n<pre><span class=\" default-formula-text-color\" dir=\"auto\">=<\/span><span class=\" default-formula-text-color\" dir=\"auto\">image<\/span><span class=\" default-formula-text-color\" dir=\"auto\">(<\/span><span class=\" string \" dir=\"auto\">\"https:\/\/chart.googleapis.com\/chart?cht=qr&amp;chs=150x150&amp;chl=\"<\/span><span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span> <span dir=\"auto\">A2<\/span> <span class=\" default-formula-text-color\" dir=\"auto\">&amp;<\/span><span class=\" string \" dir=\"auto\">\"&amp;choe=UTF-8\"<\/span><span class=\" default-formula-text-color\" dir=\"auto\">,<\/span><span class=\"number\" dir=\"auto\">1<\/span><span class=\" default-formula-text-color\" dir=\"auto\">)<\/span><\/pre>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/tao-qr-code-trong-google-sheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-6091\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/tao-qr-code-trong-google-sheet-1024x578-1.png\" alt=\"tao-qr-code-trong-google-sheet\" width=\"1024\" height=\"578\" title=\"tao-qr-code-trong-google-sheet-1024x578-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tra_cuu_du_lieu_theo_dieu_kien_o_nhieu_cot\"><\/span>Tra c\u1ee9u d\u1eef li\u1ec7u theo \u0111i\u1ec1u ki\u1ec7n \u1edf nhi\u1ec1u c\u1ed9t<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1c b\u1ea1n c\u00f3 l\u1ebd \u0111\u00e3 qu\u00e1 quen thu\u1ed9c v\u1edbi c\u00e1c h\u00e0m tra c\u1ee9u d\u1ef1a tr\u00ean 1 \u0111i\u1ec1u ki\u1ec7n l\u00e0 VLOOKUP, HLOOKUP v\u00e0 Index k\u1ebft h\u1ee3p v\u1edbi Match. \u0110\u1ec3 m\u1edf r\u1ed9ng kh\u1ea3 n\u0103ng c\u1ee7a c\u00e1c h\u00e0m tra c\u1ee9u n\u00e0y, ch\u00fang ta s\u1ebd s\u1eed d\u1ee5ng h\u00e0m m\u1ea3ng \u2013 ARRAYFORMULA trong v\u00ed d\u1ee5 nh\u01b0 sau<\/p>\n<p><strong>=ARRAYFORMULA(index($E$4:$E$8,match($G4&amp;$H4&amp;$I$3,$B$4:$B$8&amp;$C$4:$C$8&amp;$D$4:$D8,0)))<\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/vlookup-nhieu-cot.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-large wp-image-6093\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/vlookup-nhieu-cot-1024x499-1.png\" alt=\"vlookup-nhieu-cot\" width=\"1024\" height=\"499\" title=\"vlookup-nhieu-cot-1024x499-1\"><\/a><\/p>\n<p>Sau \u0111\u00e2y l\u00e0 di\u1ec5n gi\u1ea3i cho c\u00f4ng th\u1ee9c n\u00e0y<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/huong-dan-vlookup-nhieu-cot.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6094\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/huong-dan-vlookup-nhieu-cot.png\" alt=\"huong-dan-vlookup-nhieu-cot\" width=\"921\" height=\"334\" title=\"huong-dan-vlookup-nhieu-cot\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Su_dung_ham_loc_du_lieu_FILTER\"><\/span>S\u1eed d\u1ee5ng h\u00e0m l\u1ecdc d\u1eef li\u1ec7u FILTER()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>N\u1ebfu trong Excel, c\u00e1c b\u1ea1n ch\u1ec9 c\u00f3 th\u1ec3 l\u1ecdc d\u1eef li\u1ec7u s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5 c\u00f3 s\u1eb5n v\u00e0 s\u1eed d\u1ee5ng advanced filter th\u00ec trong Google Sheet cho ph\u00e9p b\u1ea1n l\u00e0m \u0111i\u1ec1u n\u00e0y v\u1edbi h\u00e0m FILTER() trong v\u00ed d\u1ee5 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/ham-filter-trong-google-sheet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6095\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-filter-trong-google-sheet.png\" alt=\"ham-filter-trong-google-sheet\" width=\"888\" height=\"393\" title=\"ham-filter-trong-google-sheet\"><\/a><\/p>\n<p>Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/su-dung-advanced-filter-de-loc-du-lieu-trung-trong-excel.html\">S\u1eed d\u1ee5ng Advanced Filter \u0111\u1ec3 l\u1ecdc d\u1eef li\u1ec7u tr\u00f9ng trong Excel<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lay_gia_tri_duy_nhat_trong_cot_bang_ham_UNIQUE\"><\/span>L\u1ea5y gi\u00e1 tr\u1ecb duy nh\u1ea5t trong c\u1ed9t b\u1eb1ng h\u00e0m UNIQUE<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00e1ch d\u00f9ng h\u00e0m UNIQUE r\u1ea5t \u0111\u01a1n gi\u1ea3n, cho h\u00e0m UNIQUE 1 c\u1ed9t, h\u00e0m n\u00e0y s\u1ebd tr\u1ea3 v\u1ec1 cho c\u00e1c b\u1ea1n c\u00e1c gi\u00e1 tr\u1ecb kh\u00f4ng b\u1ecb tr\u00f9ng l\u1eb7p. \u1ede \u0111i\u1ec3m n\u00e0y, h\u00e0m UNIQUE t\u01b0\u01a1ng \u0111\u01b0\u01a1ng v\u1edbi ch\u1ee9c n\u0103ng Remove Duplicates c\u1ee7a Excel.<a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-ham-unique.gif\"><br \/>\n<\/a><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-ham-unique.gif\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6096\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-ham-unique.gif\" alt=\"google-sheets-ham-unique\" width=\"1034\" height=\"772\" title=\"google-sheets-ham-unique\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Scrape_Web_voi_Google_Sheets\"><\/span>Scrape Web v\u1edbi Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Vi\u1ec7c l\u1ea5y th\u00f4ng tin v\u00e0 d\u1eef li\u1ec7u t\u1eeb 1 trang Web v\u1ec1 Google Sheets hi\u1ec7n t\u1ea1i d\u1ec5 d\u00e0ng h\u01a1n bao gi\u1edd h\u1ebft v\u1edbi s\u1ef1 gi\u00fap \u0111\u1ee1 c\u1ee7a nh\u00f3m h\u00e0m ImportHTML v\u00e0 <a href=\"http:\/\/blog.ezworkapp.com\/ham-importxml-google-sheet-lay-gia-aliexpress.html\">h\u00e0m ImportXML<\/a><\/p>\n<p>C\u00f4ng th\u1ee9c v\u00ed d\u1ee5 c\u1ee7a h\u00e0m ImportHTML:<\/p>\n<p><strong>=IMPORTHTML(\u201chttps:\/\/en.wikipedia.org\/wiki\/List_of_highest-grossing_films\u201d,\u201dtable\u201d,1)<\/strong><\/p>\n<p>K\u1ebft qu\u1ea3 nh\u01b0 sau:<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-importhtml.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6097\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-importhtml.png\" alt=\"google-sheets-importhtml\" width=\"727\" height=\"697\" title=\"google-sheets-importhtml\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Nhan_dang_ngon_ngu_voi_Google_Sheets\"><\/span>Nh\u1eadn d\u1ea1ng ng\u00f4n ng\u1eef v\u1edbi Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>V\u00ec \u0111\u01b0\u1ee3c t\u00edch h\u1ee3p ch\u1eb7t ch\u1ebd v\u1edbi c\u00e1c d\u1ecbch v\u1ee5 c\u1ee7a Google, n\u00ean Google Sheets c\u0169ng \u0111\u01b0\u1ee3c h\u01b0\u1edfng l\u1ee3i t\u1eeb vi\u1ec7c n\u00e0y, c\u1ee5 th\u1ec3 trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 Google Sheets s\u1ebd c\u00f3 kh\u1ea3 n\u0103ng nh\u1eadn d\u1ea1ng ng\u00f4n ng\u1eef<\/p>\n<p>M\u1ed9t danh s\u00e1ch \u0111\u1ea7y \u0111\u1ee7 theo chu\u1ea9n ISO c\u1ee7a c\u00e1c ng\u00f4n ng\u1eef, c\u00e1c b\u1ea1n xem <a href=\"https:\/\/en.wikipedia.org\/wiki\/List_of_ISO_639-1_codes\" target=\"_blank\" rel=\"noopener\">link n\u00e0y<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-nhan-dang-ngon-ngu.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6098\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-nhan-dang-ngon-ngu.png\" alt=\"google-sheets-nhan-dang-ngon-ngu\" width=\"459\" height=\"353\" title=\"google-sheets-nhan-dang-ngon-ngu\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Dich_ngon_ngu_truc_tiep_trong_Google_Sheets\"><\/span>D\u1ecbch ng\u00f4n ng\u1eef tr\u1ef1c ti\u1ebfp trong Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Kh\u00f4ng nh\u1eefng Google Sheets c\u00f3 th\u1ec3 nh\u1eadn d\u1ea1ng \u0111\u01b0\u1ee3c ng\u00f4n ng\u1eef m\u00e0 c\u00f2n d\u1ecbch \u0111\u01b0\u1ee3c lu\u00f4n cho c\u00e1c b\u1ea1n<\/p>\n<p>H\u00e0m\u00a0GOOGLETRANSLATE() s\u1ebd nh\u1eadn 3 tham s\u1ed1: Tham s\u1ed1 \u0111\u1ea7u ti\u00ean l\u00e0 \u0111o\u1ea1n v\u0103n b\u1ea1n mu\u1ed1n d\u1ecbch, tham s\u1ed1 th\u1ee9 2 l\u00e0 ng\u00f4n ng\u1eef c\u1ee7a \u0111o\u1ea1n v\u0103n b\u1ea1n mu\u1ed1n d\u1ecbch (c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 k\u1ebft h\u1ee3p v\u1edbi h\u00e0m nh\u1eadn d\u1ea1ng ng\u00f4n ng\u1eef ph\u00eda tr\u00ean cho tham s\u1ed1 n\u00e0y), tham s\u1ed1 th\u1ee9 3 l\u00e0 ng\u00f4n ng\u1eef b\u1ea1n mu\u1ed1n Google d\u1ecbch cho b\u1ea1n<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-translate-dich-ngon-ngu.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6099\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-translate-dich-ngon-ngu.png\" alt=\"google-sheets-translate-dich-ngon-ngu\" width=\"462\" height=\"263\" title=\"google-sheets-translate-dich-ngon-ngu\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Kiem_tra_Emails_va_URLs_dung_chuan\"><\/span>Ki\u1ec3m tra Emails v\u00e0 URLs \u0111\u00fang chu\u1ea9n<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Google Sheets c\u00f3 h\u00e0m \u0111\u1ec3 h\u1ed7 tr\u1ee3 b\u1ea1n ki\u1ec3m tra Emails v\u00e0 URLs n\u00e0o h\u1ee3p l\u1ec7<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-email-kiem-tra-tinh-hop-le-email.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6100\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-email-kiem-tra-tinh-hop-le-email.png\" alt=\"google-sheets-email-kiem-tra-tinh-hop-le-email\" width=\"363\" height=\"207\" title=\"google-sheets-email-kiem-tra-tinh-hop-le-email\"><\/a><\/p>\n<p>\u0110\u1ec3 ki\u1ec3m tra t\u00ednh h\u1ee3p l\u1ec7 c\u1ee7a URL, ta c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m isurl() nh\u01b0 sau<\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-kiem-tra-url-hop-le.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter wp-image-6101 size-medium\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-kiem-tra-url-hop-le-300x132-1.png\" alt=\"google-sheets-kiem-tra-url-hop-le\" width=\"300\" height=\"132\" title=\"google-sheets-kiem-tra-url-hop-le-300x132-1\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Du_doan_gia_tri_trong_tuong_lai_voi_ham_Growth\"><\/span>D\u1ef1 \u0111o\u00e1n gi\u00e1 tr\u1ecb trong t\u01b0\u01a1ng lai v\u1edbi h\u00e0m Growth()<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>H\u00e0m n\u00e0y t\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m n\u1ed9i suy tuy\u1ebfn t\u00ednh <a href=\"http:\/\/blog.ezworkapp.com\/cac-ham-excel-moi-trong-phien-ban-excel-2016-va-vi-du.html\" target=\"_blank\" rel=\"noopener\">FORECAST.LINEAR m\u1edbi c\u00f3 m\u1eb7t trong Excel 2016<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-ham-noi-suy.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6102\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-ham-noi-suy.png\" alt=\"google-sheets-ham-noi-suy\" width=\"325\" height=\"334\" title=\"google-sheets-ham-noi-suy\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lam_cong_thuc_doc_de_hon_bang_cach_xuong_dong\"><\/span>L\u00e0m c\u00f4ng th\u1ee9c \u0111\u1ecdc d\u1ec5 h\u01a1n b\u1eb1ng c\u00e1ch xu\u1ed1ng d\u00f2ng<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>C\u00f4ng th\u1ee9c qu\u00e1 d\u00e0i s\u1ebd l\u00e0m b\u1ea1n r\u1ea5t kh\u00f3 theo d\u00f5i v\u00e0 d\u1ec5 g\u00e2y nh\u1ea7m l\u1eabn. \u0110\u1ec3 xu\u1ed1ng d\u00f2ng trong \u00f4 c\u00f4ng th\u1ee9c, c\u00e1c b\u1ea1n h\u00e3y s\u1eed d\u1ee5ng t\u1ed5 h\u1ee3p ph\u00edm ALT + ENTER \u0111\u1ec3 cho c\u00f4ng th\u1ee9c d\u1ec5 nh\u00ecn v\u00e0 d\u1ec5 vi\u1ebft h\u01a1n<\/p>\n<h2><span class=\"ez-toc-section\" id=\"Them_nhung_ky_tu_dac_biet_vao_Google_Sheets\"><\/span>Th\u00eam nh\u1eefng k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o Google Sheets<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>Th\u00eam k\u00fd t\u1ef1 \u0111\u1eb7c bi\u1ec7t v\u00e0o Google Sheets v\u1edbi h\u00e0m CHAR(). 1 danh s\u00e1ch c\u00e1c k\u00fd t\u1ef1 c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 th\u1eed th\u00eam v\u00e0o \u1edf <a href=\"http:\/\/graphemica.com\/unicode\/characters\/page\/2\" target=\"_blank\" rel=\"noopener\">link n\u00e0y<\/a><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-ky-tu-dac-biet.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6103\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-ky-tu-dac-biet.png\" alt=\"google-sheets-ky-tu-dac-biet\" width=\"312\" height=\"243\" title=\"google-sheets-ky-tu-dac-biet\"><\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Lay_gia_tri_ngau_nhien_tu_1_danh_sach\"><\/span>L\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean t\u1eeb 1 danh s\u00e1ch<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p>\u0110\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb ng\u1eabu nhi\u00ean t\u1eeb 1 danh s\u00e1ch, ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c sau \u0111\u00e2y. Th\u1eadt th\u00fa v\u1ecb l\u00e0 ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng ch\u00ednh x\u00e1c c\u00f4ng th\u1ee9c n\u00e0y trong Excel lu\u00f4n m\u00e0 kh\u00f4ng ph\u1ea3i ch\u1ec9nh s\u1eeda g\u00ec<\/p>\n<p><strong><span class=\"s1\">=CHOOSE(RANDBETWEEN(1,5),\u201dLondon\u201d,\u201dBerlin\u201d,\u201dRome\u201d,\u201dMadrid\u201d,\u201dLisbon\u201d)<\/span><\/strong><\/p>\n<p><a href=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2017\/05\/google-sheets-choose-randbetween.png\"><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-6104\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/google-sheets-choose-randbetween.png\" alt=\"google-sheets-choose-randbetween\" width=\"607\" height=\"251\" title=\"google-sheets-choose-randbetween\"><\/a><\/p>\n<p>M\u00ecnh hi v\u1ecdng nh\u1eefng th\u1ee7 thu\u1eadt n\u00e0y s\u1ebd n\u00e2ng cao n\u0103ng su\u1ea5t l\u00e0m vi\u1ec7c v\u00e0 l\u00e0m cho c\u00f4ng vi\u1ec7c c\u1ee7a b\u1ea1n tr\u1edf n\u00ean d\u1ec5 d\u00e0ng h\u01a1n. H\u00e3y chia s\u1ebb b\u00e0i vi\u1ebft n\u00e0y v\u1edbi b\u1ea1n b\u00e8 v\u00e0 \u0111\u1ed3ng nghi\u1ec7p v\u00e0 n\u00f3i v\u1edbi m\u00ecnh b\u1ea1n ngh\u0129 g\u00ec v\u1ec1 nh\u1eefng th\u1ee7 thu\u1eadt n\u00e0y \u1edf trong ph\u1ea7n comment \u1edf d\u01b0\u1edbi nh\u00e9.<\/p>\n<p>Ngo\u00e0i ra \u0111\u1ec3 n\u00e2ng cao h\u01a1n ki\u1ebfn th\u1ee9c v\u1ec1 Excel, \u1ee9ng d\u1ee5ng Excel trong c\u00f4ng vi\u1ec7c th\u00ec c\u00e1c b\u1ea1n c\u00f3 th\u1ec3 tham gia kh\u00f3a h\u1ecdc <a href=\"http:\/\/bit.ly\/2v9oqgP\">EX101 \u2013 Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi chuy\u00ean gia d\u00e0nh cho ng\u01b0\u1eddi \u0111i l\u00e0m<\/a> c\u1ee7a H\u1ecdc Excel Online. Kh\u00f3a h\u1ecdc n\u00e0y s\u1ebd gi\u00fap c\u00e1c b\u1ea1n n\u1eafm v\u1eefng \u0111\u01b0\u1ee3c c\u00e1c h\u00e0m, c\u00e1c c\u00f4ng c\u1ee5 c\u1ee7a Excel, c\u00e1ch v\u1ebd bi\u1ec3u \u0111\u1ed3, l\u1eadp b\u00e1o c\u00e1o b\u1eb1ng Pivot table\u2026 Hi\u1ec7n nay h\u1ec7 th\u1ed1ng \u0111ang c\u00f3 \u01b0u \u0111\u00e3i r\u1ea5t l\u1edbn khi b\u1ea1n \u0111\u0103ng k\u00fd kh\u00f3a h\u1ecdc n\u00e0y. Chi ti\u1ebft xem t\u1ea1i:<\/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-104.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1429,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1428","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\/1428","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=1428"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1428\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1429"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1428"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1428"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1428"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}