{"id":1499,"date":"2024-12-02T05:18:03","date_gmt":"2024-12-02T05:18:03","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap\/"},"modified":"2024-12-02T05:18:03","modified_gmt":"2024-12-02T05:18:03","slug":"cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap\/","title":{"rendered":"C\u00e1ch x\u00e1c \u0111\u1ecbnh Ng\u00e0y Th\u00e1ng N\u0103m b\u1eb1ng c\u00e1c h\u00e0m th\u1eddi gian trong Excel c\u00f3 b\u00e0i t\u1eadp"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<blockquote id='\"h\u00e0m-l\u1ea5y-ng\u00e0y'>\n<p>Trong Excel ch\u00fang ta th\u01b0\u1eddng xuy\u00ean ph\u1ea3i l\u00e0m vi\u1ec7c v\u1edbi \u0111\u1ed1i t\u01b0\u1ee3ng th\u1eddi gian l\u00e0 Ng\u00e0y, Th\u00e1ng, N\u0103m. V\u1eady l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u00e1ch \u0111\u01b0\u1ee3c c\u00e1c gi\u00e1 tr\u1ecb ng\u00e0y, th\u00e1ng, n\u0103m t\u1eeb 1 \u00f4 ch\u1ee9a 1 d\u1eef li\u1ec7u c\u00f3 d\u1ea1ng th\u1eddi gian? Hay l\u00e0m th\u1ebf n\u00e0o \u0111\u1ec3 t\u1ea1o ra 1 gi\u00e1 tr\u1ecb ng\u00e0y th\u00e1ng t\u1eeb nh\u1eefng n\u1ed9i dung ri\u00eang l\u1ebb N\u0103m, Th\u00e1ng, Ng\u00e0y? Sau \u0111\u00e2y <a href=\"http:\/\/blog.ezworkapp.com\/\"><strong>H\u1ecdc Excel Online<\/strong><\/a> s\u1ebd h\u01b0\u1edbng d\u1eabn c\u00e1c b\u1ea1n c\u00e1c <strong>h\u00e0m l\u1ea5y ng\u00e0y th\u00e1ng n\u0103m trong excel.<\/strong><\/p>\n<\/blockquote>\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-674d430b11918\" 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\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html#Ham_YEAR_de_lay_gia_tri_Nam_tu_mot_doi_tuong_thoi_gian\" title=\"H\u00e0m YEAR\u00a0\u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb N\u0103m t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian\">H\u00e0m YEAR\u00a0\u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb N\u0103m t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\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\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html#Ham_MONTH_de_lay_gia_tri_Thang_tu_mot_doi_tuong_thoi_gian\" title=\"H\u00e0m\u00a0MONTH \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Th\u00e1ng\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian\">H\u00e0m\u00a0MONTH \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Th\u00e1ng\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian<\/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\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html#Ham_DAY_de_lay_gia_tri_Ngay_tu_mot_doi_tuong_thoi_gian\" title=\"H\u00e0m\u00a0DAY \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Ng\u00e0y\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian\">H\u00e0m\u00a0DAY \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Ng\u00e0y\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian<\/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\/cach-xac-dinh-ngay-thang-nam-bang-cac-ham-thoi-gian-trong-excel-co-bai-tap.html#Ham_DATE_de_tao_ra_1_gia_tri_thoi_gian_tu_viec_ghep_cac_doi_tuong_Nam_Thang_Ngay\" title=\"H\u00e0m DATE \u0111\u1ec3 t\u1ea1o ra 1 gi\u00e1 tr\u1ecb th\u1eddi gian t\u1eeb vi\u1ec7c gh\u00e9p c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng N\u0103m, Th\u00e1ng,\u00a0Ng\u00e0y\">H\u00e0m DATE \u0111\u1ec3 t\u1ea1o ra 1 gi\u00e1 tr\u1ecb th\u1eddi gian t\u1eeb vi\u1ec7c gh\u00e9p c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng N\u0103m, Th\u00e1ng,\u00a0Ng\u00e0y<\/a><\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h3><span class=\"ez-toc-section\" id=\"Ham_YEAR_de_lay_gia_tri_Nam_tu_mot_doi_tuong_thoi_gian\"><\/span>H\u00e0m YEAR\u00a0\u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb N\u0103m t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb S\u1ed1 n\u0103m t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng th\u1eddi gian th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m <strong>YEAR<\/strong> trong Excel.<\/p>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m <strong>YEAR<\/strong><\/p>\n<p style=\"padding-left: 30px\">=YEAR(serial_number)<\/p>\n<p>Trong \u0111\u00f3 serial_number l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb v\u1ec1 th\u1eddi gian, l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, kh\u00f4ng ph\u1ea3i d\u1ea1ng Text<\/p>\n<p style=\"padding-left: 30px\">Xem th\u00eam:\u00a0<a href=\"http:\/\/blog.ezworkapp.com\/cach-phan-biet-loai-du-lieu-trong-excel-voi-nhom-ham-isnumber-isnontext-istext.html\">C\u00e1ch ph\u00e2n bi\u1ec7t d\u1ea1ng d\u1eef li\u1ec7u trong Excel v\u1edbi nh\u00f3m h\u00e0m IsNumber, IsNonText, IsText<\/a><\/p>\n<p>Trong v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y ch\u00fang ta c\u00f9ng xem c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m YEAR v\u00e0 k\u1ebft qu\u1ea3 thu \u0111\u01b0\u1ee3c:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19494\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-year-tach-gia-tri-so-nam.png\" width=\"486\" height=\"135\" title=\"ham-year-tach-gia-tri-so-nam\"><\/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-109.gif\" title=\"ex101_92019-nho-109\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p>Nh\u01b0 v\u1eady ch\u00fang ta th\u1ea5y: D\u00f9 gi\u00e1 tr\u1ecb th\u1eddi gian vi\u1ebft d\u01b0\u1edbi \u0111\u1ecbnh d\u1ea1ng n\u00e0o th\u00ec h\u00e0m YEAR v\u1eabn l\u1ea5y \u0111\u00fang s\u1ed1 N\u0103m trong gi\u00e1 tr\u1ecb th\u1eddi gian \u0111\u00f3.<\/p>\n<p>V\u00ed d\u1ee5: \u0110\u1ec3 x\u00e1c \u0111\u1ecbnh n\u0103m hi\u1ec7n t\u1ea1i l\u00e0 n\u0103m n\u00e0o th\u00ec ch\u00fang ta k\u1ebft h\u1ee3p h\u00e0m YEAR v\u1edbi h\u00e0m TODAY nh\u01b0 sau:<\/p>\n<p style=\"padding-left: 30px\">=YEAR(TODAY())<\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m\u00a0YEAR\u00a0ra m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng Number, kh\u00f4ng ph\u1ea3i d\u1ea1ng th\u1eddi gian.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_MONTH_de_lay_gia_tri_Thang_tu_mot_doi_tuong_thoi_gian\"><\/span>H\u00e0m\u00a0MONTH \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Th\u00e1ng\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 l\u1ea5y \u0111\u01b0\u1ee3c gi\u00e1 tr\u1ecb S\u1ed1\u00a0Th\u00e1ng\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng th\u1eddi gian th\u00ec ch\u00fang ta c\u00f3 th\u1ec3 s\u1eed d\u1ee5ng h\u00e0m\u00a0<strong>MONTH<\/strong>\u00a0trong Excel.<\/p>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m\u00a0<strong>MONTH<\/strong><\/p>\n<p style=\"padding-left: 30px\">=MONTH(serial_number)<\/p>\n<p>Trong \u0111\u00f3 serial_number l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb v\u1ec1 th\u1eddi gian, l\u00e0 d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1, kh\u00f4ng ph\u1ea3i d\u1ea1ng Text<\/p>\n<p>X\u00e9t m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 \u00e1p d\u1ee5ng h\u00e0m t\u00e1ch s\u1ed1 th\u00e1ng t\u1eeb 1 gi\u00e1 tr\u1ecb th\u1eddi gian nh\u01b0 sau:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19496\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-month-tach-gia-tri-so-thang.png\" width=\"519\" height=\"149\" title=\"ham-month-tach-gia-tri-so-thang\"><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m\u00a0MONTH ra m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng Number, kh\u00f4ng ph\u1ea3i d\u1ea1ng th\u1eddi gian.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_DAY_de_lay_gia_tri_Ngay_tu_mot_doi_tuong_thoi_gian\"><\/span>H\u00e0m\u00a0DAY \u0111\u1ec3 l\u1ea5y gi\u00e1 tr\u1ecb\u00a0Ng\u00e0y\u00a0t\u1eeb m\u1ed9t \u0111\u1ed1i t\u01b0\u1ee3ng\u00a0th\u1eddi gian<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>T\u01b0\u01a1ng t\u1ef1 nh\u01b0 h\u00e0m <strong>YEAR<\/strong>, h\u00e0m <strong>MONTH<\/strong> \u1edf tr\u00ean, h\u00e0m <strong>DAY<\/strong> s\u1ebd gi\u00fap ch\u00fang ta x\u00e1c \u0111\u1ecbnh s\u1ed1 Ng\u00e0y t\u1eeb m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian trong Excel.<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m <strong>DAY<\/strong><\/p>\n<p style=\"padding-left: 30px\">=DAY(serial_number)<\/p>\n<p>serial_number l\u00e0 m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian, d\u1eef li\u1ec7u d\u1ea1ng s\u1ed1.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19497\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-day-tach-gia-tri-so-ngay.png\" width=\"492\" height=\"140\" title=\"ham-day-tach-gia-tri-so-ngay\"><\/p>\n<p>K\u1ebft qu\u1ea3 c\u1ee7a h\u00e0m DAY ra m\u1ed9t gi\u00e1 tr\u1ecb c\u00f3 lo\u1ea1i d\u1eef li\u1ec7u l\u00e0 d\u1ea1ng Number, kh\u00f4ng ph\u1ea3i d\u1ea1ng th\u1eddi gian.<\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_DATE_de_tao_ra_1_gia_tri_thoi_gian_tu_viec_ghep_cac_doi_tuong_Nam_Thang_Ngay\"><\/span>H\u00e0m DATE \u0111\u1ec3 t\u1ea1o ra 1 gi\u00e1 tr\u1ecb th\u1eddi gian t\u1eeb vi\u1ec7c gh\u00e9p c\u00e1c \u0111\u1ed1i t\u01b0\u1ee3ng N\u0103m, Th\u00e1ng,\u00a0Ng\u00e0y<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p>\u0110\u1ec3 t\u1ea1o ra m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian th\u00ec ch\u00fang ta ph\u1ea3i d\u00f9ng h\u00e0m DATE. <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-date-trong-excel-cach-tinh-toan-ngay-thang.html\"><strong>H\u00e0m Date<\/strong><\/a> gi\u00fap x\u00e1c \u0111\u1ecbnh ra m\u1ed9t gi\u00e1 tr\u1ecb th\u1eddi gian c\u00f3 \u0111\u1ea7y \u0111\u1ee7 Ng\u00e0y, Th\u00e1ng, N\u0103m v\u00e0 \u0111\u01b0\u1ee3c vi\u1ebft \u0111\u00fang \u0111\u1ecbnh d\u1ea1ng chu\u1ea9n l\u00e0 Th\u1eddi gian.<\/p>\n<p>C\u1ea5u tr\u00fac c\u1ee7a h\u00e0m DATE<\/p>\n<p style=\"padding-left: 30px\">=DATE(year, month, day)<\/p>\n<p>C\u1ea5u tr\u00fac h\u00e0m Date kh\u00e1 \u0111\u1eb7c bi\u1ec7t, \u0111\u00f3 l\u00e0 th\u1ee9 t\u1ef1 c\u1ee7a c\u00e1c th\u00e0nh ph\u1ea7n trong h\u00e0m l\u00e0 N\u0103m &gt; Th\u00e1ng &gt; Ng\u00e0y. Khi vi\u1ebft h\u00e0m c\u1ea7n \u0111\u1eb7c bi\u1ec7t ch\u00fa \u00fd n\u1ed9i dung n\u00e0y.<\/p>\n<p>M\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 vi\u1ec7c \u1ee9ng d\u1ee5ng h\u00e0m Date \u0111\u1ec3 t\u1ea1o ra gi\u00e1 tr\u1ecb bi\u1ec3u di\u1ec5n th\u1eddi gian:<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"aligncenter size-full wp-image-19517\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2024\/12\/ham-date-ghep-ngay.png\" width=\"733\" height=\"155\" title=\"ham-date-ghep-ngay\"><\/p>\n<ul>\n<li>Trong k\u1ebft qu\u1ea3 t\u1ea1i D4 v\u00e0 D5 c\u00f3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-if-va-cach-su-dung-ham-if-trong-excel.html\">h\u00e0m IF<\/a> \u0111\u1ec3 bi\u1ec7n lu\u1eadn gi\u00e1 tr\u1ecb n\u0103m. N\u1ebfu s\u1ed1 n\u0103m nh\u1ecf h\u01a1n ho\u1eb7c b\u1eb1ng 18 (n\u0103m hi\u1ec7n t\u1ea1i l\u00e0 2018) th\u00ec s\u1ebd coi n\u0103m \u0111\u00f3 thu\u1ed9c n\u0103m 2000 tr\u1edf \u0111i. C\u00f2n kh\u00f4ng ph\u1ea3i th\u00ec s\u1ebd t\u00ednh cho nh\u1eefng n\u0103m thu\u1ed9c 1900 t\u1edbi tr\u01b0\u1edbc 2000<\/li>\n<li>K\u1ebft qu\u1ea3 t\u1ea1i D3 c\u00f3 s\u1eed d\u1ee5ng <a href=\"http:\/\/blog.ezworkapp.com\/ham-text-va-cac-ung-dung-tuyet-voi-cua-ham-text-trong-excel.html\">h\u00e0m TEXT<\/a> k\u1ebft h\u1ee3p h\u00e0m DATE \u0111\u1ec3 thay \u0111\u1ed5i c\u00e1ch \u0111\u1ecbnh d\u1ea1ng gi\u00e1 tr\u1ecb ng\u00e0y theo \u00fd mu\u1ed1n.<\/li>\n<\/ul>\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t b\u00e0i t\u1eadp nh\u1ecf cho c\u00e1c b\u1ea1n \u0111\u1ec3 luy\u1ec7n t\u1eadp v\u1ec1 h\u00e0m x\u1eed l\u00fd th\u1eddi gian. C\u00e1c b\u1ea1n t\u1ea3i v\u1ec1 theo \u0111\u1ecba ch\u1ec9:\u00a0<a href=\"http:\/\/bit.ly\/2yFD83j\">http:\/\/bit.ly\/2yFD83j<\/a><\/p>\n<p>\u0110\u1ec3 c\u00f3 th\u1ec3 l\u00e0m t\u1ed1t b\u00e0i t\u1eadp tr\u00ean, c\u00e1c b\u1ea1n c\u1ea7n t\u00ecm hi\u1ec3u th\u00eam m\u1ed9t s\u1ed1 ki\u1ebfn th\u1ee9c v\u1ec1 c\u00e1c h\u00e0m: <a href=\"http:\/\/blog.ezworkapp.com\/ham-hlookup-trong-excel-va-cac-ung-dung-nang-cao-thuong-gap.html\">VLOOKUP<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-choose-trong-excel.html\">CHOOSE<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/ham-sumif-tinh-tong-excel.html\">SUMIFS<\/a>, <a href=\"http:\/\/blog.ezworkapp.com\/cach-dung-ham-weekday-trong-excel.html\">WEEKDAY<\/a><\/p>\n<p>Ngo\u00e0i ra H\u1ecdc Excel Online xin gi\u1edbi thi\u1ec7u v\u1edbi c\u00e1c b\u1ea1n\u00a0<a href=\"http:\/\/bit.ly\/2tqUmwz\"><strong>Kh\u00f3a h\u1ecdc\u00a0Excel t\u1eeb c\u01a1 b\u1ea3n t\u1edbi n\u00e2ng cao d\u00e0nh cho ng\u01b0\u1eddi\u00a0\u0111i l\u00e0m<\/strong><\/a>.\u00a0\u0110\u00e2y l\u00e0 1 kh\u00f3a h\u1ecdc r\u1ea5t\u00a0\u0111\u1ea7y\u00a0\u0111\u1ee7 ki\u1ebfn th\u1ee9c v\u00e0 b\u1ed5 tr\u1ee3 r\u1ea5t tuy\u1ec7t v\u1eddi cho b\u1ea1n trong vi\u1ec7c l\u00e0m quen v\u1edbi Excel, s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng c\u1ee5, c\u00e1c h\u00e0m trong\u00a0Excel\u00a0\u0111\u1ec3\u00a0gi\u00fap b\u1ea1n l\u00e0m vi\u1ec7c tr\u00ean\u00a0Excel\u00a0\u0111\u01b0\u1ee3c t\u1ed1t h\u01a1n, hi\u1ec7u qu\u1ea3 h\u01a1n. 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-109.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":1500,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-1499","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\/1499","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=1499"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/1499\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/1500"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=1499"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=1499"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=1499"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}