{"id":28272,"date":"2022-04-12T14:56:37","date_gmt":"2022-04-12T07:56:37","guid":{"rendered":"https:\/\/divineshop.vn\/tin-tuc\/?p=28272"},"modified":"2022-04-12T14:56:37","modified_gmt":"2022-04-12T07:56:37","slug":"lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua","status":"publish","type":"post","link":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/","title":{"rendered":"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua"},"content":{"rendered":"<div class=\"content-inner\">\n<p><strong>Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n d\u1eef li\u1ec7u nh\u01b0ng ch\u01b0a bi\u1ebft v\u1eadn d\u00f9ng h\u00e0m OFFSET m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, chuy\u00ean nghi\u1ec7p.\u00a0<\/strong><\/p>\n<p>V\u1eady th\u00ec b\u1ea1n h\u00e3y \u0111\u1ecdc ngay b\u00e0i vi\u1ebft d\u01b0\u1edbi \u0111\u00e2y, Divine Shop s\u1ebd gi\u00fap b\u1ea1n \u201cn\u1eb1m l\u00f2ng\u201d c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OFFSET ti\u1ebft ki\u1ec7m \u0111\u01b0\u1ee3c r\u1ea5t nhi\u1ec1u th\u1eddi gian, c\u00f4ng s\u1ee9c trong vi\u1ec7c t\u00ednh to\u00e1n tr\u00ean Excel<img loading=\"lazy\" class=\"aligncenter size-full wp-image-550448\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f4093d1b.jpeg\" alt=\"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua\" width=\"2000\" height=\"1125\" \/><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_17 counter-hierarchy counter-decimal ez-toc-grey\">\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_la_gi\"><\/span><span id=\"Ham_OFFSET_la_gi\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>H\u00e0m OFFSET l\u00e0 g\u00ec?\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">H\u00e0m OFFSET l\u00e0 m\u1ed9t h\u00e0m \u0111\u01b0\u1ee3c d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n c\u00e1c d\u1eef li\u1ec7u tr\u00ean m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u00e3y d\u1ef1a v\u00e0o v\u00f9ng tham chi\u1ebfu c\u00f3 s\u1eb5n. C\u00fa ph\u00e1p: <\/span><b>=OFFSET(reference, rows, cols, [height], [width])<\/b><\/p>\n<p><span style=\"font-weight: 400\">Trong \u0111\u00f3:\u00a0<\/span><\/p>\n<ul>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Reference<\/strong>: l\u00e0 m\u1ed9t \u00f4 ho\u1eb7c m\u1ed9t d\u00e3y d\u00f9ng \u0111\u1ec3 l\u00e0m v\u00f9ng tham chi\u1ebfu ban \u0111\u1ea7u.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Rows<\/strong>: S\u1ed1 h\u00e0ng m\u00e0 c\u00f4ng th\u1ee9c di chuy\u1ec3n c\u1ee7a v\u00f9ng \u0111\u01b0\u1ee3c tham chi\u1ebfu ban \u0111\u1ea7u. N\u1ebfu nh\u01b0 s\u1ed1 h\u00e0ng l\u00e0 s\u1ed1 d\u01b0\u01a1ng th\u00ec c\u00f4ng th\u1ee9c di chuy\u1ec3n xu\u1ed1ng ph\u00eda d\u01b0\u1edbi v\u00f9ng tham chi\u1ebfu v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Cols<\/strong>: S\u1ed1 c\u1ed9t m\u00e0 c\u00f4ng th\u1ee9c di chuy\u1ec3n trong v\u00f9ng tham chi\u1ebfu ban \u0111\u1ea7u. N\u1ebfu s\u1ed1 c\u1ed9t l\u00e0 s\u1ed1 d\u01b0\u01a1ng th\u00ec d\u1eef li\u1ec7u s\u1ebd di chuy\u1ec3n b\u00ean ph\u1ea3i v\u00f9ng tham chi\u1ebfu v\u00e0 ng\u01b0\u1ee3c l\u1ea1i.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Height<\/strong>: l\u00e0 chi\u1ec1u cao \u2013 \u0111\u01b0\u1ee3c t\u00ednh b\u1eb1ng s\u1ed1 h\u00e0ng b\u1ea1n c\u1ea7n tham chi\u1ebfu v\u1ec1.\u00a0<\/span><\/li>\n<li style=\"font-weight: 400\"><span style=\"font-weight: 400\"><strong>Width<\/strong>: l\u00e0 chi\u1ec1u r\u1ed9ng \u2013 \u0111\u01b0\u1ee3c t\u00ednh l\u00e0 s\u1ed1 c\u1ed9t m\u00e0 b\u1ea1n c\u1ea7n tham chi\u1ebfu v\u1ec1.\u00a0<\/span><\/li>\n<\/ul>\n<p><span style=\"font-weight: 400\"><em>L\u01b0u \u00fd: Height, Width l\u00e0 hai \u0111i\u1ec1u ki\u1ec7n t\u1ef1 ch\u1ecdn, kh\u00f4ng b\u1eaft bu\u1ed9c trong c\u00fa ph\u00e1p h\u00e0m OFFSET v\u00e0 hai \u0111\u1ed1i s\u1ed1 n\u00e0y kh\u00f4ng d\u00f9ng s\u1ed1 \u00e2m.<\/em>\u00a0<\/span><\/p>\n<p><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550450\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f441e33a.jpeg\" alt=\"H\u00e0m OFFSET l\u00e0 g\u00ec?\u00a0\" width=\"2000\" height=\"1125\" \/><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Ham_OFFSET_thuong_duoc_dung_trong_nhung_truong_hop_nao\"><\/span><span id=\"Ham_OFFSET_thuong_duoc_dung_trong_nhung_truong_hop_nao\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>H\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o?\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Ch\u1eafc h\u1eb3n, b\u1ea1n s\u1ebd th\u1eafc m\u1eafc l\u00e0m sao \u0111\u1ec3 v\u1eadn d\u1ee5ng h\u00e0m OFFSET m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u hi\u1ec7u qu\u1ea3 nh\u1ea5t ph\u1ea3i kh\u00f4ng n\u00e0o? Ti\u1ebfp theo, Divine Shop s\u1ebd h\u01b0\u1edbng d\u1eabn b\u1ea1n m\u1ed9t trong s\u1ed1 c\u00e1ch c\u01a1 b\u1ea3n \u0111\u1ec3 v\u1eadn d\u00f9ng h\u00e0m OFFSET. Trong v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi \u0111\u00e2y y\u00eau c\u1ea7u b\u1ea1n h\u00e3y t\u00ecm s\u1ed1 l\u01b0\u1ee3ng c\u00f2n l\u1ea1i c\u1ee7a chi\u1ebfc iPhone 11 Pro Max 512GB d\u1ef1a tr\u00ean d\u1eef li\u1ec7u t\u1ed3n kho ban \u0111\u1ea7u.\u00a0<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400\">B\u1ea1n h\u00e3y nh\u1eadp c\u00f4ng th\u1ee9c nh\u01b0 sau: <\/span><b>=OFFSET(B1;4;1)<\/b><\/p>\n<p><b><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550435\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f4733ae6.jpeg\" alt=\"H\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o?\u00a0 - B\u01b0\u1edbc 1\" width=\"2000\" height=\"1125\" \/><\/b><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400\">Ti\u1ebfp t\u1ee5c nh\u1ea5n <\/span><b>Enter<\/b><span style=\"font-weight: 400\">, \u0111\u1ec3 xem k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400\"> <img loading=\"lazy\" class=\"aligncenter size-full wp-image-550437\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f4a8bd50.jpeg\" alt=\"H\u00e0m OFFSET th\u01b0\u1eddng \u0111\u01b0\u1ee3c d\u00f9ng trong nh\u1eefng tr\u01b0\u1eddng h\u1ee3p n\u00e0o?\u00a0 - B\u01b0\u1edbc 2\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<p><span style=\"font-weight: 400\">Ngo\u00e0i ra, h\u00e0m OFFSET c\u00f2n \u0111\u01b0\u1ee3c v\u1eadn d\u1ee5ng n\u00e2ng cao h\u01a1n v\u1edbi vi\u1ec7c l\u1ed3ng gh\u00e9p c\u00e1c h\u00e0m t\u00ednh to\u00e1n c\u00f3 \u0111i\u1ec1u ki\u1ec7n \u0111\u1ec3 gi\u00fap t\u1ed1i \u01b0u c\u00e1c b\u01b0\u1edbc th\u1ef1c hi\u1ec7n. B\u1ea1n h\u00e3y ti\u1ebfp t\u1ee5c theo d\u00f5i b\u00ean d\u01b0\u1edbi nh\u00e9!<\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Cach_ket_hop_giua_ham_OFFSET_va_SUM_COUNTA\"><\/span><span id=\"Cach_ket_hop_giua_ham_OFFSET_va_SUM_COUNTA\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>C\u00e1ch k\u1ebft h\u1ee3p gi\u1eefa h\u00e0m OFFSET v\u00e0 SUM, COUNTA<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<h3><span class=\"ez-toc-section\" id=\"Ham_OFFSET_ket_hop_voi_SUM\"><\/span><span id=\"Ham_OFFSET_ket_hop_voi_SUM\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi SUM<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">\u1ede v\u00ed d\u1ee5 ti\u1ebfp theo, Divine Shop s\u1ebd k\u1ebft h\u1ee3p c\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng d\u1ef1a tr\u00ean d\u1eef li\u1ec7u tham chi\u1ebfu. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, y\u00eau c\u1ea7u b\u1ea1n h\u00e3y t\u00ecm ra t\u1ed5ng s\u1ed1 l\u01b0\u1ee3ng b\u00e1n \u0111\u01b0\u1ee3c c\u1ee7a s\u1ea3n ph\u1ea9m AirPods Pro trong hai th\u00e1ng.\u00a0<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400\">B\u1ea1n h\u00e3y nh\u1eadp v\u00e0o v\u1edbi c\u00f4ng th\u1ee9c nh\u01b0 sau: <\/span><b>=SUM(OFFSET(B1;5;1;1;2)). <\/b><span style=\"font-weight: 400\">\u1ede \u0111\u00e2y b\u1ea1n s\u1ebd d\u00f9ng h\u00e0m SUM \u0111\u1ec3 t\u00ednh t\u1ed5ng v\u00e0 l\u1ed3ng gh\u00e9p OFFSET \u0111\u1ec3 tham chi\u1ebfu t\u1eeb \u00f4 s\u1ea3n ph\u1ea9m xu\u1ed1ng 5 d\u00f2ng v\u00e0 l\u1ea5y gi\u00e1 tr\u1ecb t\u1eeb c\u1ed9t \u0111\u1ea7u ti\u00ean v\u1edbi ph\u1ea1m vi l\u00e0 1 h\u00e0ng v\u00e0 2 c\u1ed9t.<\/span><\/p>\n<p><span style=\"font-weight: 400\"> <img loading=\"lazy\" class=\"aligncenter size-full wp-image-550439\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f4e2e6f9.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi SUM - B\u01b0\u1edbc 1\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400\">Sau \u0111\u00f3 nh\u1ea5n Enter, b\u1ea1n s\u1ebd xem \u0111\u01b0\u1ee3c k\u1ebft qu\u1ea3.<\/span><\/p>\n<p><span style=\"font-weight: 400\"> <img loading=\"lazy\" class=\"aligncenter size-full wp-image-550440\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f51a32ec.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi SUM - B\u01b0\u1edbc 2\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<h3><span class=\"ez-toc-section\" id=\"Ham_OFFSET_ket_hop_voi_COUNTA\"><\/span><span id=\"Ham_OFFSET_ket_hop_voi_COUNTA\" class=\"ez-toc-section\"><\/span><strong><span style=\"font-size: 14pt\">H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA<\/span><\/strong><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p><span style=\"font-weight: 400\">T\u01b0\u01a1ng t\u01b0, khi ch\u00fang ta th\u1ef1c hi\u1ec7n k\u1ebft h\u1ee3p OFFSET v\u00e0 h\u00e0m COUNTA c\u00f3 ngh\u0129a b\u1ea1n \u0111ang th\u1ef1c hi\u1ec7n t\u1ea1o m\u1ed9t danh s\u00e1ch \u0111\u1ed9ng v\u1edbi h\u00e0m OFFSET. H\u00e3y theo d\u00f5i v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y \u0111\u1ec3 t\u1ea1o danh s\u00e1ch \u0111\u1ed9ng c\u00e1c s\u1ea3n ph\u1ea9m.\u00a0<\/span><\/p>\n<p><b>B\u01b0\u1edbc 1: <\/b><span style=\"font-weight: 400\">B\u1ea1n s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p c\u00f4ng th\u1ee9c nh\u01b0 sau: Ch\u00fang ta s\u1ebd d\u00f9ng h\u00e0m OFFSET b\u1eaft \u0111\u1ea7u tham chi\u1ebfu \u1edf \u00f4 B2 \u2013 kh\u00f4ng thay \u0111\u1ed5i v\u1ec1 h\u00e0ng v\u00e0 c\u1ed9t, ti\u1ebfp t\u1ee5c sau \u0111\u00f3 c\u1ee9 m\u1ed7i tham chi\u1ebfu s\u1ebd xu\u1ed1ng 1 d\u00f2ng v\u00e0 kh\u00f4ng \u0111\u1ed5i v\u1ec1 c\u1ed9t. L\u00fac n\u00e0y vi\u1ec7c s\u1eed d\u1ee5ng k\u1ebft h\u1ee3p COUNTA \u0111\u1ec3 \u0111\u1ebfm nh\u1eefng \u00f4 c\u00f3 ch\u1ee9a n\u1ed9i dung v\u00e0 kh\u00f4ng ph\u1ea3i l\u00e0 \u00f4 tr\u1ed1ng.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400\">C\u00fa ph\u00e1p: <\/span><b>=OFFSET(B2;0;0;COUNTA(B2:B8))<\/b><\/p>\n<p><b><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550441\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f54e3bac.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA - B\u01b0\u1edbc 1\" width=\"2000\" height=\"1125\" \/><\/b><\/p>\n<p><b>B\u01b0\u1edbc 2: <\/b><span style=\"font-weight: 400\">Sau \u0111\u00f3 b\u1ea1n nh\u1ea5n Enter, s\u1ebd \u0111\u01b0\u1ee3c hi\u1ec3n th\u1ecb k\u1ebft qu\u1ea3. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550443\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f5814b55.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA - B\u01b0\u1edbc 2\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<p><b>B\u01b0\u1edbc 3: <\/b><span style=\"font-weight: 400\">Ti\u1ebfp theo, \u0111\u1ec3 th\u1ef1c hi\u1ec7n t\u1ea1o danh s\u00e1ch \u0111\u1ed9ng b\u1ea1n h\u00e3y truy c\u1eadp v\u00e0o <\/span><b>Data &gt; Data Validation.<\/b><\/p>\n<p><b><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550445\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f5b38aa0.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA - B\u01b0\u1edbc 3\" width=\"2000\" height=\"1125\" \/><\/b><\/p>\n<p><b>B\u01b0\u1edbc 4: <\/b><span style=\"font-weight: 400\">T\u1ea1i h\u1ed9p tho\u1ea1i Data Validation, b\u1ea1n h\u00e3y ch\u1ecdn <\/span><b>Settings &gt; Allows: List &gt; Source:<\/b> <b>=OFFSET($B$2;0;0;COUNTA($B$2:$B$8)).<\/b><\/p>\n<p><b><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550446\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f5e5f99e.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA - B\u01b0\u1edbc 4\" width=\"2000\" height=\"1125\" \/><\/b><\/p>\n<p><b>B\u01b0\u1edbc 5: <\/b><span style=\"font-weight: 400\">Cu\u1ed1i c\u00f9ng, sau khi nh\u1ea5n <strong>OK<\/strong>\u00a0b\u1ea1n s\u1ebd xem \u0111\u01b0\u1ee3c danh s\u00e1ch \u0111\u1ed9ng \u0111\u00e3 t\u1ea1o. <\/span><\/p>\n<p><span style=\"font-weight: 400\"><img loading=\"lazy\" class=\"aligncenter size-full wp-image-550447\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f61ebe36.jpeg\" alt=\"H\u00e0m OFFSET k\u1ebft h\u1ee3p v\u1edbi COUNTA - B\u01b0\u1edbc 5\" width=\"2000\" height=\"1125\" \/><\/span><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tam_ket\"><\/span><span id=\"Tam_ket\" class=\"ez-toc-section\"><\/span><span style=\"font-size: 18pt\"><b>T\u1ea1m k\u1ebft\u00a0<\/b><\/span><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400\">Qua b\u00e0i vi\u1ebft tr\u00ean, Divine Shop \u0111\u00e3 h\u01b0\u1edbng d\u1eabn b\u1ea1n c\u00e1ch s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, chi ti\u1ebft v\u00e0 k\u1ebft h\u1ee3p v\u1edbi vi\u1ec7c s\u1eed d\u1ee5ng l\u1ed3ng gh\u00e9p v\u1edbi c\u00e1c h\u00e0m t\u00ednh to\u00e1n s\u1ebd gi\u00fap cho b\u1ea1n t\u1ed1i \u01b0u \u0111\u01b0\u1ee3c th\u1eddi gian x\u1eed l\u00fd d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3 h\u01a1n. Ch\u00fac c\u00e1c b\u1ea1n th\u1ef1c hi\u1ec7n th\u00e0nh c\u00f4ng!<\/span><\/p>\n<\/div>\n<\/div>\n\n\n<hr class=\"wp-block-separator\"\/>\n\n\n\n<figure class=\"wp-block-image size-full\"><a href=\"https:\/\/divineshop.vn\/search?q=netflix\" target=\"_blank\" rel=\"noopener\"><img loading=\"lazy\" width=\"728\" height=\"240\" src=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png\" alt=\"\" class=\"wp-image-284289\" srcset=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix.png 728w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-300x99.png 300w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-150x49.png 150w, https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2025\/11\/Netflix-696x229.png 696w\" sizes=\"(max-width: 728px) 100vw, 728px\" \/><\/a><\/figure>\n\n\n\n<!--nextpage-->\n","protected":false},"excerpt":{"rendered":"<p>Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng Excel \u0111\u1ec3 t\u00ednh to\u00e1n d\u1eef li\u1ec7u nh\u01b0ng ch\u01b0a bi\u1ebft v\u1eadn d\u00f9ng h\u00e0m OFFSET m\u1ed9t c\u00e1ch hi\u1ec7u qu\u1ea3, chuy\u00ean nghi\u1ec7p.\u00a0 V\u1eady [&hellip;]<\/p>\n","protected":false},"author":12,"featured_media":28273,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"inline_featured_image":false},"categories":[148],"tags":[216],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v18.1 (Yoast SEO v18.2) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<meta name=\"description\" content=\"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua\" \/>\n<meta property=\"og:description\" content=\"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng\" \/>\n<meta property=\"og:url\" content=\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/\" \/>\n<meta property=\"og:site_name\" content=\"Divine News\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/divineshop.vn\" \/>\n<meta property=\"article:published_time\" content=\"2022-04-12T07:56:37+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg\" \/>\n\t<meta property=\"og:image:width\" content=\"2000\" \/>\n\t<meta property=\"og:image:height\" content=\"1125\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"CTV\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 ph\u00fat\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\/\/schema.org\",\"@graph\":[{\"@type\":\"Organization\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\",\"name\":\"Divine News\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"sameAs\":[\"https:\/\/www.facebook.com\/divineshop.vn\",\"https:\/\/www.instagram.com\/divineshop.game\/\",\"https:\/\/www.youtube.com\/DivineTVN\"],\"logo\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg\",\"width\":960,\"height\":960,\"caption\":\"Divine News\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#logo\"}},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/\",\"name\":\"Divine News\",\"description\":\"Tin hay m\u1ed7i ng\u00e0y\",\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}\"},\"query-input\":\"required name=search_term_string\"}],\"inLanguage\":\"vi\"},{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg\",\"contentUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg\",\"width\":2000,\"height\":1125},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage\",\"url\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/\",\"name\":\"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua - Divine News\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage\"},\"datePublished\":\"2022-04-12T07:56:37+00:00\",\"dateModified\":\"2022-04-12T07:56:37+00:00\",\"description\":\"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng\",\"breadcrumb\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/\"]}]},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\/\/divineshop.vn\/tin-tuc\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua\"}]},{\"@type\":\"Article\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage\"},\"author\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\"},\"headline\":\"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua\",\"datePublished\":\"2022-04-12T07:56:37+00:00\",\"dateModified\":\"2022-04-12T07:56:37+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage\"},\"wordCount\":1230,\"publisher\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"},\"image\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg\",\"keywords\":[\"excel\"],\"articleSection\":[\"M\u1eb8O HAY\"],\"inLanguage\":\"vi\",\"copyrightYear\":\"2022\",\"copyrightHolder\":{\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#organization\"}},{\"@type\":\"Person\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a\",\"name\":\"CTV\",\"image\":{\"@type\":\"ImageObject\",\"@id\":\"https:\/\/divineshop.vn\/tin-tuc\/#personlogo\",\"inLanguage\":\"vi\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g\",\"caption\":\"CTV\"}}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"description":"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng","robots":{"index":"index","follow":"follow","max-snippet":"max-snippet:-1","max-image-preview":"max-image-preview:large","max-video-preview":"max-video-preview:-1"},"canonical":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/","og_locale":"vi_VN","og_type":"article","og_title":"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua","og_description":"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng","og_url":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/","og_site_name":"Divine News","article_publisher":"https:\/\/www.facebook.com\/divineshop.vn","article_published_time":"2022-04-12T07:56:37+00:00","og_image":[{"width":2000,"height":1125,"url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg","type":"image\/jpeg"}],"twitter_card":"summary_large_image","twitter_misc":{"Written by":"CTV","Est. reading time":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Organization","@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization","name":"Divine News","url":"https:\/\/divineshop.vn\/tin-tuc\/","sameAs":["https:\/\/www.facebook.com\/divineshop.vn","https:\/\/www.instagram.com\/divineshop.game\/","https:\/\/www.youtube.com\/DivineTVN"],"logo":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/Avatar.jpg","width":960,"height":960,"caption":"Divine News"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#logo"}},{"@type":"WebSite","@id":"https:\/\/divineshop.vn\/tin-tuc\/#website","url":"https:\/\/divineshop.vn\/tin-tuc\/","name":"Divine News","description":"Tin hay m\u1ed7i ng\u00e0y","publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/divineshop.vn\/tin-tuc\/?s={search_term_string}"},"query-input":"required name=search_term_string"}],"inLanguage":"vi"},{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage","inLanguage":"vi","url":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg","contentUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg","width":2000,"height":1125},{"@type":"WebPage","@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage","url":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/","name":"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua - Divine News","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#website"},"primaryImageOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage"},"datePublished":"2022-04-12T07:56:37+00:00","dateModified":"2022-04-12T07:56:37+00:00","description":"Excel t\u1eeb l\u00e2u nay lu\u00f4n l\u00e0 m\u1ed9t trong nh\u1eefng c\u00f4ng c\u1ee5 \u201cqu\u1ed1c d\u00e2n\u201d cho vi\u1ec7c t\u00ednh to\u00e1n v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u m\u1ed9t c\u00e1ch t\u1ed1i \u01b0u nh\u1ea5t. V\u00e0i n\u1ebfu nh\u01b0 l\u00e2u nay b\u1ea1n s\u1eed d\u1ee5ng","breadcrumb":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/"]}]},{"@type":"BreadcrumbList","@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/divineshop.vn\/tin-tuc\/"},{"@type":"ListItem","position":2,"name":"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua"}]},{"@type":"Article","@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#article","isPartOf":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage"},"author":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a"},"headline":"\u201cL\u1ee5m ngay\u201d b\u00ed k\u00edp s\u1eed d\u1ee5ng h\u00e0m OFFSET \u0111\u01a1n gi\u1ea3n, hi\u1ec7u qu\u1ea3 m\u00e0 d\u00e2n v\u0103n ph\u00f2ng nh\u1ea5t \u0111\u1ecbnh kh\u00f4ng n\u00ean b\u1ecf qua","datePublished":"2022-04-12T07:56:37+00:00","dateModified":"2022-04-12T07:56:37+00:00","mainEntityOfPage":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#webpage"},"wordCount":1230,"publisher":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"},"image":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua\/#primaryimage"},"thumbnailUrl":"https:\/\/divineshop.vn\/tin-tuc\/wp-content\/uploads\/2022\/03\/lum-ngay-bi-kip-su-dung-ham-offset-don-gian-hieu-qua-ma-dan-van-phong-nhat-dinh-khong-nen-bo-qua_62340f3cc9337.jpeg","keywords":["excel"],"articleSection":["M\u1eb8O HAY"],"inLanguage":"vi","copyrightYear":"2022","copyrightHolder":{"@id":"https:\/\/divineshop.vn\/tin-tuc\/#organization"}},{"@type":"Person","@id":"https:\/\/divineshop.vn\/tin-tuc\/#\/schema\/person\/ab675a5edaf3a6c9f037d16aa192413a","name":"CTV","image":{"@type":"ImageObject","@id":"https:\/\/divineshop.vn\/tin-tuc\/#personlogo","inLanguage":"vi","url":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/99e99dbd029810d7d24fba0cc828c79b?s=96&d=mm&r=g","caption":"CTV"}}]}},"_links":{"self":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28272"}],"collection":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/users\/12"}],"replies":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/comments?post=28272"}],"version-history":[{"count":2,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28272\/revisions"}],"predecessor-version":[{"id":72088,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/posts\/28272\/revisions\/72088"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media\/28273"}],"wp:attachment":[{"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/media?parent=28272"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/categories?post=28272"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/divineshop.vn\/tin-tuc\/wp-json\/wp\/v2\/tags?post=28272"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}