{"id":11813,"date":"2025-01-15T05:18:21","date_gmt":"2025-01-15T05:18:21","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel\/"},"modified":"2025-01-15T05:18:21","modified_gmt":"2025-01-15T05:18:21","slug":"tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2025\/01\/15\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel\/","title":{"rendered":"T\u00cdNH TO\u00c1N NHI\u1ec0U TRANG T\u00cdNH CH\u1ec8 V\u1edaI M\u1ed8T C\u00d4NG TH\u1ee8C: THAM CHI\u1ebeU 3-D TRONG EXCEL"},"content":{"rendered":"<div class=\"uk-panel uk-margin\" id=\"template-nJy84WMn#1\">\n<p style=\"text-align: justify\">B\u00e0i h\u01b0\u1edbng d\u1eabn ng\u1eafn n\u00e0y gi\u1ea3i th\u00edch \u0111i\u1ec1u c\u1ed1t l\u00f5i c\u1ee7a tham chi\u1ebfu 3-D trong Excel v\u00e0 ch\u1ec9 b\u1ea1n c\u00e1ch t\u00ednh to\u00e1n nhi\u1ec1u trang t\u00ednh ch\u1ec9 v\u1edbi m\u1ed9t c\u00f4ng th\u1ee9c 3-D.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t trong nh\u1eefng t\u00ednh n\u0103ng tham chi\u1ebfu \u00a0tuy\u1ec7t v\u1eddi nh\u1ea5t c\u1ee7a Excel ch\u00ednh l\u00e0 tham chi\u1ebfu 3D, hay c\u00f2n \u0111\u01b0\u1ee3c bi\u1ebft \u0111\u1ebfn nh\u01b0 tham chi\u1ebfu trong kh\u00f4ng gian ba chi\u1ec1u.<\/p>\n<p style=\"text-align: justify\">M\u1ed9t tham chi\u1ebfu 3D trong Excel tham chi\u1ebfu \u0111\u1ebfn c\u00f9ng m\u1ed9t \u00f4 hay d\u1ea3i \u00f4 tr\u00ean nhi\u1ec1u trang t\u00ednh. \u0110\u00e2y l\u00e0 c\u00e1ch r\u1ea5t thu\u1eadn ti\u1ec7n v\u00e0 nhanh ch\u00f3ng nh\u1eb1m t\u00ednh to\u00e1n d\u1eef li\u1ec7u \u1edf nhi\u1ec1u trang t\u00ednh c\u00f3 c\u00f9ng c\u1ea5u tr\u00fac, v\u00e0 n\u00f3 c\u00f3 th\u1ec3 l\u00e0 s\u1ef1 thay th\u1ebf l\u00fd t\u01b0\u1edfng cho t\u00ednh n\u0103ng CONSOLIDATE trong Excel. Nghe c\u00f3 v\u1ebb m\u01a1 h\u1ed3, nh\u01b0ng \u0111\u1eebng lo l\u1eafng, c\u00e1c v\u00ed d\u1ee5 sau \u0111\u00e2y s\u1ebd gi\u00fap m\u1ecdi th\u1ee9 r\u00f5 r\u00e0ng h\u01a1n.<\/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-6787451b13273\" 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-1\"><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#THAM_CHIEU_3D_TRONG_EXCEL_LA_GI\" title=\"THAM CHI\u1ebeU 3D TRONG EXCEL L\u00c0 G\u00cc?\">THAM CHI\u1ebeU 3D TRONG EXCEL L\u00c0 G\u00cc?<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#CACH_TAO_THAM_CHIEU_3-D_TRONG_EXCEL\" title=\"C\u00c1CH T\u1ea0O THAM CHI\u1ebeU 3-D TRONG EXCEL\">C\u00c1CH T\u1ea0O THAM CHI\u1ebeU 3-D TRONG EXCEL<\/a>\n<ul class=\"ez-toc-list-level-2\">\n<li class=\"ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#TAO_THEM_TRANG_TINH_MOI_VAO_CONG_THUC_3D_TRONG_EXCEL\" title=\"T\u1ea0O\u00a0TH\u00caM TRANG T\u00cdNH M\u1edaI V\u00c0O C\u00d4NG TH\u1ee8C 3D TRONG EXCEL\">T\u1ea0O\u00a0TH\u00caM TRANG T\u00cdNH M\u1edaI V\u00c0O C\u00d4NG TH\u1ee8C 3D TRONG EXCEL<\/a><\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-2\"><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#TAO_TEN_CHO_MOT_THAM_CHIEU_3-D_TRONG_EXCEL\" title=\"T\u1ea0O T\u00caN CHO M\u1ed8T THAM CHI\u1ebeU 3-D TRONG EXCEL\">T\u1ea0O T\u00caN CHO M\u1ed8T THAM CHI\u1ebeU 3-D TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/li>\n<li class=\"ez-toc-page-1 ez-toc-heading-level-1\"><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#CAC_HAM_EXCEL_HO_TRO_THAM_CHIEU_3-D\" title=\"C\u00c1C H\u00c0M EXCEL H\u1ed6 TR\u1ee2 THAM CHI\u1ebeU 3-D\">C\u00c1C H\u00c0M EXCEL H\u1ed6 TR\u1ee2 THAM CHI\u1ebeU 3-D<\/a>\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\">\n<ul class=\"ez-toc-list-level-3\">\n<li class=\"ez-toc-heading-level-3\"><a class=\"ez-toc-link ez-toc-heading-6\" href=\"https:\/\/blog.hocexcel.online\/tinh-toan-nhieu-trang-tinh-chi-voi-mot-cong-thuc-tham-chieu-3-d-trong-excel.html#LUU_Y_KHI_CHEN_DI_CHUYEN_VA_XOA_TRANG_TINH_SE_LAM_THAY_DOI_THAM_CHIEU_3-D_TRONG_EXCEL\" title=\"L\u01afU \u00dd: KHI CH\u00c8N, DI CHUY\u1ec2N V\u00c0 X\u00d3A TRANG T\u00cdNH S\u1ebc L\u00c0M THAY \u0110\u1ed4I THAM CHI\u1ebeU 3-D TRONG EXCEL\">L\u01afU \u00dd: KHI CH\u00c8N, DI CHUY\u1ec2N V\u00c0 X\u00d3A TRANG T\u00cdNH S\u1ebc L\u00c0M THAY \u0110\u1ed4I THAM CHI\u1ebeU 3-D TRONG EXCEL<\/a><\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<\/nav>\n<\/div>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"THAM_CHIEU_3D_TRONG_EXCEL_LA_GI\"><\/span>THAM CHI\u1ebeU 3D TRONG EXCEL L\u00c0 G\u00cc?<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, tham chi\u1ebfu 3D trong Excel cho ph\u00e9p b\u1ea1n tham chi\u1ebfu m\u1ed9t hay nhi\u1ec1u \u00f4 \u1edf nhi\u1ec1u trang t\u00ednh. N\u00f3i c\u00e1ch kh\u00e1c, n\u00f3 kh\u00f4ng ch\u1ec9 tham chi\u1ebfu m\u1ed9t d\u1ea3i \u00f4, m\u00e0 c\u00f2n m\u1ed9t d\u1ea3i c\u00e1c t\u00ean c\u1ee7a trang t\u00ednh. \u0110i\u1ec3m m\u1ea5u ch\u1ed1t \u1edf \u0111\u00e2y ch\u00ednh l\u00e0 t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh \u0111\u01b0\u1ee3c tham chi\u1ebfu ph\u1ea3i c\u00f3 c\u00f9ng c\u1ea5u tr\u00fac v\u00e0 c\u00f3 c\u00f9ng lo\u1ea1i d\u1eef li\u1ec7u. H\u00e3y xem x\u00e9t v\u00ed d\u1ee5 d\u01b0\u1edbi \u0111\u00e2y.<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u1ea1n c\u00f3 c\u00e1c b\u1ea3ng b\u00e1o c\u00e1o doanh s\u1ed1 h\u00e0ng th\u00e1ng n\u1eb1m \u1edf 4 trang t\u00ednh kh\u00e1c nhau:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-6433 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/201-300x80-1.png\" width=\"514\" height=\"137\" title=\"201-300x80-1\"><\/p>\n<p style=\"text-align: justify\">\u0110i\u1ec1u b\u1ea1n t\u00ecm ki\u1ebfm \u0111\u00f3 l\u00e0 t\u00ednh t\u1ed5ng t\u1ea5t c\u1ea3 doanh s\u1ed1, c\u1ee5 th\u1ec3 l\u00e0 c\u1ed9ng t\u1ed5ng c\u1ee7a m\u1ed7i th\u00e1ng \u1edf b\u1ed1n trang t\u00ednh. Gi\u1ea3i ph\u00e1p r\u00f5 r\u00e0ng nh\u1ea5t ch\u00ednh l\u00e0 c\u1ed9ng c\u00e1c \u00f4 c\u00f3 ch\u1ee9a t\u1ed5ng doanh s\u1ed1 m\u1ed7i th\u00e1ng nh\u01b0 m\u1ecdi khi:<\/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-327.gif\" title=\"ex101_92019-nho-327\"><br \/>\n<\/a>\n<\/div>\n<\/div>\n<p style=\"text-align: justify\">=Jan!B6+Feb!B6+Mar!B6+Apr!B6<\/p>\n<p style=\"text-align: justify\">Nh\u01b0ng n\u1ebfu b\u1ea1n c\u00f3 12 trang t\u00ednh cho c\u1ea3 n\u0103m lu\u00f4n th\u00ec sao? Hay th\u1eadm ch\u00ed l\u00e0 nhi\u1ec1u trang t\u00ednh h\u01a1n cho v\u00e0i n\u0103m? S\u1ebd c\u00f3 r\u1ea5t nhi\u1ec1u vi\u1ec7c ph\u1ea3i l\u00e0m. Thay v\u00e0o \u0111\u00f3, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng h\u00e0m SUM c\u00f3 tham chi\u1ebfu 3D \u0111\u1ec3 t\u00ednh t\u1ea5t c\u1ea3 trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">=SUM(Jan:Apr!B6)<\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c SUM n\u00e0y th\u1ef1c hi\u1ec7n c\u00f9ng m\u1ed9t ph\u00e9p t\u00ednh nh\u01b0 c\u00f4ng th\u1ee9c d\u00e0i \u1edf ph\u00eda tr\u00ean, c\u1ee5 th\u1ec3 l\u00e0 c\u1ed9ng t\u1ea5t c\u1ea3 c\u00e1c gi\u00e1 tr\u1ecb \u1edf \u00f4 B6 c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh \u2013 c\u00e1c trang t\u00ednh n\u00e0y n\u1eb1m gi\u1eefa hai trang t\u00ednh bi\u00ean m\u00e0 b\u1ea1n \u0111\u1ecbnh r\u00f5, Th\u00e1ng M\u1ed9t v\u00e0 Th\u00e1ng T\u01b0 trong v\u00ed d\u1ee5 n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6434 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/202.png\" width=\"251\" height=\"270\" title=\"202\"><\/p>\n<p style=\"text-align: justify\"><strong>M\u1eb9o:<\/strong>\u00a0N\u1ebfu b\u1ea1n mu\u1ed1n sao ch\u00e9p c\u00f4ng th\u1ee9c 3-D cho m\u1ed9t v\u00e0i \u00f4 v\u00e0 b\u1ea1n kh\u00f4ng mu\u1ed1n c\u00e1c tham chi\u1ebfu \u00f4 b\u1ecb thay \u0111\u1ed5i, th\u00ec b\u1ea1n c\u00f3 th\u1ec3 kh\u00f3a ch\u00fang b\u1eb1ng c\u00e1ch th\u00eam k\u00fd hi\u1ec7u $, c\u1ee5 th\u1ec3 l\u00e0 b\u1eb1ng c\u00e1ch s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 tuy\u1ec7t \u0111\u1ed1i nh\u01b0\u00a0=SUM(Jan:Apr!$B$6).<\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n kh\u00f4ng mu\u1ed1n t\u00ednh t\u1ed5ng c\u1ee7a t\u1eebng th\u00e1ng, kh\u00f4ng sao, b\u1ea1n c\u00f3 th\u1ec3 th\u00eam tr\u1ef1c ti\u1ebfp d\u1ea3i \u00f4 c\u1ea7n t\u00ednh v\u00e0o c\u00f4ng th\u1ee9c 3-D:<\/p>\n<p style=\"text-align: justify\">=SUM(Jan:Apr!B2:B5)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6435 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/203.png\" width=\"251\" height=\"203\" title=\"203\"><\/p>\n<p style=\"text-align: justify\">N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh t\u1ed5ng doanh thu c\u1ee7a m\u1ed7i s\u1ea3n ph\u1ea9m ri\u00eang r\u1ebd, th\u00ec h\u00e3y l\u1eadp m\u1ed9t b\u1ea3ng s\u1ea3n ph\u1ea9m trong \u0111\u00f3 c\u00e1c s\u1ea3n ph\u1ea9m \u0111\u01b0\u1ee3c s\u1eafp x\u1ebfp theo \u0111\u00fang th\u1ee9 t\u1ef1 \u1edf trang t\u00ednh h\u00e0ng th\u00e1ng, r\u1ed3i nh\u1eadp c\u00f4ng th\u1ee9c 3-D n\u00e0y v\u00e0o \u00f4 tr\u00ean c\u00f9ng, trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y l\u00e0 \u00f4 B2:<\/p>\n<p style=\"text-align: justify\">=SUM(Jan:Apr!B2)<\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1edb s\u1eed d\u1ee5ng tham chi\u1ebfu \u00f4 t\u01b0\u01a1ng \u0111\u1ed1i \u2013 tham chi\u1ebfu \u00f4 kh\u00f4ng c\u00f3 $, \u0111\u1ec3 c\u00f4ng th\u1ee9c \u0111\u01b0\u1ee3c \u0111i\u1ec1u ch\u1ec9nh theo t\u1eebng \u00f4 khi \u0111\u01b0\u1ee3c sao ch\u00e9p xu\u1ed1ng c\u00e1c \u00f4 d\u01b0\u1edbi:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-6436 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/204.png\" width=\"217\" height=\"166\" title=\"204\"><\/p>\n<p style=\"text-align: justify\">D\u1ef1a tr\u00ean c\u00e1c c\u00f4ng th\u1ee9c tr\u00ean, h\u00e3y r\u00fat ra c\u00fa ph\u00e1p chung cho tham chi\u1ebfu 3-D v\u00e0 c\u00f4ng th\u1ee9c 3-D trong Excel:<\/p>\n<p style=\"text-align: justify\">Tham chi\u1ebfu 3-D trong Excel<\/p>\n<p style=\"text-align: justify\"><em>First_sheet<\/em>:<em>Last_sheet<\/em>!<em>cell hay<\/em><br \/>\n<em>First_sheet<\/em>:<em>Last_sheet<\/em>!<em>range<\/em><\/p>\n<p style=\"text-align: justify\">C\u00f4ng th\u1ee9c 3-D trong Excel:<\/p>\n<p style=\"text-align: justify\">=<em>Function<\/em>(<em>First_sheet<\/em>:<em>Last_sheet<\/em>!<em>cell)<\/em>\u00a0hay<br \/>\n=<em>Function<\/em>(<em>First_sheet<\/em>:<em>Last_sheet<\/em>!<em>range)<\/em><\/p>\n<p style=\"text-align: justify\">Khi s\u1eed d\u1ee5ng c\u00e1c c\u00f4ng th\u1ee9c 3-D n\u00e0y trong Excel, t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh n\u1eb1m gi\u1eefa trang \u0111\u1ea7u ti\u00ean v\u00e0 trang cu\u1ed1i c\u00f9ng \u0111\u1ec1u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00e9p t\u00ednh.<\/p>\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CACH_TAO_THAM_CHIEU_3-D_TRONG_EXCEL\"><\/span>C\u00c1CH T\u1ea0O THAM CHI\u1ebeU 3-D TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">\u0110\u1ec3 l\u1eadp c\u00f4ng th\u1ee9c c\u00f3 tham chi\u1ebfu 3-D trong c\u00e2u l\u1ec7nh, h\u00e3y l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n nh\u1eadp c\u00f4ng th\u1ee9c 3-D.<\/p>\n<p style=\"text-align: justify\">G\u00f5 d\u1ea5u b\u1eb1ng (=), nh\u1eadp t\u00ean h\u00e0m, r\u1ed3i nh\u1eadp d\u1ea5u ngo\u1eb7c m\u1edf, v\u00ed d\u1ee5 =SUM(<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p v\u00e0o tab c\u1ee7a trang t\u00ednh \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n th\u00eam tham chi\u1ebfu 3-D.<\/p>\n<p style=\"text-align: justify\">Trong khi nh\u1ea5p gi\u1eef ph\u00edm Shift, h\u00e3y nh\u1ea5p tab c\u1ee7a trang t\u00ednh cu\u1ed1i c\u00f9ng \u2013 trang t\u00ednh \u0111\u01b0\u1ee3c th\u00eam v\u00e0o tham chi\u1ebfu 3-D c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Ch\u1ecdn \u00f4 hay d\u1ea3i \u00f4 m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh.<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh c\u00f4ng th\u1ee9c 3D.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6437 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/205.png\" width=\"290\" height=\"167\" title=\"205\"><\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"TAO_THEM_TRANG_TINH_MOI_VAO_CONG_THUC_3D_TRONG_EXCEL\"><\/span>T\u1ea0O\u00a0TH\u00caM TRANG T\u00cdNH M\u1edaI V\u00c0O C\u00d4NG TH\u1ee8C 3D TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">Tham chi\u1ebfu 3D trong Excel c\u00f3 th\u1ec3 m\u1edf r\u1ed9ng. N\u00f3 c\u00f3 ngh\u0129a l\u00e0 b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o tham chi\u1ebfu 3-D \u1edf m\u1ed9t th\u1eddi \u0111i\u1ec3m n\u00e0o \u0111\u00f3, r\u1ed3i ch\u00e8n trang t\u00ednh m\u1edbi v\u00e0o, r\u1ed3i di chuy\u1ec3n trang t\u00ednh \u0111\u1ebfn d\u1ea3i \u00f4 m\u00e0 c\u00f4ng th\u1ee9c 3-D tham chi\u1ebfu:<\/p>\n<p style=\"text-align: justify\">Gi\u1ea3 s\u1eed b\u00e2y gi\u1edd \u0111\u1ea7u n\u0103m v\u00e0 b\u1ea1n ch\u1ec9 c\u00f3 d\u1eef li\u1ec7u c\u1ee7a v\u00e0i th\u00e1ng \u0111\u1ea7u. Tuy nhi\u00ean, trang t\u00ednh m\u1edbi c\u00f3 th\u1ec3 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o m\u1ed7i th\u00e1ng v\u00e0 b\u1ea1n mu\u1ed1n c\u00f3 c\u00e1c trang t\u00ednh n\u00e0y trong c\u00f4ng th\u1ee9c khi c\u00e1c trang t\u00ednh n\u00e0y \u0111\u01b0\u1ee3c t\u1ea1o ra.<\/p>\n<p style=\"text-align: justify\">V\u1ec1 vi\u1ec7c n\u00e0y, h\u00e3y t\u1ea1o m\u1ed9t trang t\u00ednh m\u1edbi, v\u00ed d\u1ee5 Th\u00e1ng M\u01b0\u1eddi Hai, r\u1ed3i bi\u1ebfn n\u00f3 th\u00e0nh trang t\u00ednh cu\u1ed1i c\u00f9ng trong tham chi\u1ebfu 3-D c\u1ee7a b\u1ea1n:<\/p>\n<p style=\"text-align: justify\">=SUM(Jan:Dec!B2:B5)<\/p>\n<p style=\"text-align: justify\">Khi m\u1ed9t trang t\u00ednh \u0111\u01b0\u1ee3c th\u00eam v\u00e0o c\u1eeda s\u1ed5, ch\u1ec9 c\u1ea7n di chuy\u1ec3n n\u00f3 v\u00e0o gi\u1eefa Th\u00e1ng M\u1ed9t v\u00e0 Th\u00e1ng M\u01b0\u1eddi Hai:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6438 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/206-300x169-1.png\" width=\"300\" height=\"169\" title=\"206-300x169-1\"><\/p>\n<p style=\"text-align: justify\">Xong r\u1ed3i! B\u1edfi v\u00ec c\u00f4ng th\u1ee9c SUM c\u1ee7a b\u1ea1n ch\u1ee9a tham chi\u1ebfu 3-D, n\u00f3 s\u1ebd c\u1ed9ng d\u1ea3i \u00f4 \u0111\u01b0\u1ee3c th\u00eam v\u00e0o (B2:B5) trong t\u1ea5t c\u1ea3 trang t\u00ednh n\u1eb1m gi\u1eefa c\u00e1c trang t\u00ednh x\u00e1c \u0111\u1ecbnh (Jan:Dec!). Ch\u1ec9 c\u1ea7n nh\u1edb r\u1eb1ng t\u1ea5t c\u1ea3 trang t\u00ednh \u0111\u01b0\u1ee3c th\u00eam v\u00e0o tham chi\u1ebfu 3-D trong Excel n\u00ean c\u00f3 c\u00e1ch s\u1eafp x\u1ebfp d\u1eef li\u1ec7u gi\u1ed1ng nhau v\u00e0 c\u00f3 c\u00f9ng lo\u1ea1i d\u1eef li\u1ec7u.<\/p>\n<h2 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"TAO_TEN_CHO_MOT_THAM_CHIEU_3-D_TRONG_EXCEL\"><\/span>T\u1ea0O T\u00caN CHO M\u1ed8T THAM CHI\u1ebeU 3-D TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p style=\"text-align: justify\">\u0110\u1ec3 khi\u1ebfn vi\u1ec7c s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c 3D trong Excel c\u1ee7a b\u1ea1n d\u1ec5 d\u00e0ng h\u01a1n, b\u1ea1n c\u00f3 th\u1ec3 t\u1ea1o t\u00ean cho tham chi\u1ebfu 3D c\u1ee7a m\u00ecnh.<\/p>\n<p style=\"text-align: justify\">Tr\u00ean tab Formulas, h\u00e3y \u0111i \u0111\u1ebfn nh\u00f3m Defined Names r\u1ed3i nh\u1ea5p Define Name.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6439 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/207.png\" width=\"249\" height=\"126\" title=\"207\"><\/p>\n<p style=\"text-align: justify\">Trong h\u1ed9p tho\u1ea1i New Name, h\u00e3y g\u00f5 m\u1ed9t c\u00e1i t\u00ean c\u00f3 ngh\u0129a v\u00e0 d\u1ec5 nh\u1edb v\u00e0o h\u1ed9p Name, t\u1ed1i \u0111a l\u00e0 255 k\u00fd t\u1ef1. Trong v\u00ed d\u1ee5 n\u00e0y, h\u00e3y \u0111\u1eb7t t\u00ean \u0111\u01a1n gianr th\u00f4i, v\u00ed d\u1ee5: thamchieu-cuatoi<\/p>\n<p style=\"text-align: justify\">X\u00f3a n\u1ed9i dung c\u1ee7a Refers ra kh\u1ecfi h\u1ed9p, h\u00e3y nh\u1eadp tham chi\u1ebfu 3D v\u00e0o \u0111\u00e2y theo c\u00e1ch sau \u0111\u00e2y:<\/p>\n<p style=\"text-align: justify\">G\u00f5 = (d\u1ea5u b\u1eb1ng).<\/p>\n<p style=\"text-align: justify\">Nh\u1ea5p gi\u1eef Shift, nh\u1ea5p tab c\u1ee7a trang t\u00ednh \u0111\u1ea7u ti\u00ean m\u00e0 b\u1ea1n mu\u1ed1n tham chi\u1ebfu, r\u1ed3i nh\u1ea5p v\u00e0o trang t\u00ednh cu\u1ed1i c\u00f9ng.<\/p>\n<p style=\"text-align: justify\">H\u00e3y ch\u1ecdn \u00f4 hay d\u1ea3i \u00f4 c\u1ea7n tham chi\u1ebfu. B\u1ea1n c\u0169ng c\u00f3 th\u1ec3 tham chi\u1ebfu to\u00e0n b\u1ed9 c\u1ed9t b\u1eb1ng c\u00e1ch nh\u1ea5p k\u00fd t\u1ef1 c\u1ed9t trong trang t\u00ednh.<\/p>\n<p style=\"text-align: justify\">\u1ede v\u00ed d\u1ee5 n\u00e0y, h\u00e3y t\u1ea1o ra m\u1ed9t tham chi\u1ebfu 3D trong Excel cho to\u00e0n b\u1ed9 c\u1ed9t B t\u1eeb trang t\u00ednh Th\u00e1ng M\u1ed9t \u0111\u1ebfn Th\u00e1ng T\u01b0. V\u00ec v\u1eady, b\u1ea1n c\u00f3 k\u1ebft qu\u1ea3 nh\u01b0 th\u1ebf n\u00e0y:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-6440 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/208-300x134-1.png\" width=\"300\" height=\"134\" title=\"208-300x134-1\"><\/p>\n<p style=\"text-align: justify\">H\u00e3y nh\u1ea5p n\u00fat OK \u0111\u1ec3 l\u01b0u tham chi\u1ebfu 3D v\u1eeba m\u1edbi t\u1ea1o r\u1ed3i \u0111\u00f3ng h\u1ed9p tho\u1ea1i. Xong!<\/p>\n<p style=\"text-align: justify\">V\u00e0 b\u00e2y gi\u1edd, \u0111\u1ec3 t\u00ednh t\u1ed5ng c\u00e1c con s\u1ed1 \u1edf c\u1ed9t B \u1edf t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh t\u1eeb Th\u00e1ng M\u1ed9t \u0111\u1ebfn Th\u00e1ng T\u01b0, b\u1ea1n ch\u1ec9 c\u1ea7n s\u1eed d\u1ee5ng c\u00f4ng th\u1ee9c \u0111\u01a1n gi\u1ea3n n\u00e0y:<\/p>\n<p style=\"text-align: justify\">=SUM(my_reference)<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\" wp-image-6441 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/209.png\" width=\"273\" height=\"112\" title=\"209\"><\/p>\n<p style=\"text-align: justify\">\n<h1 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"CAC_HAM_EXCEL_HO_TRO_THAM_CHIEU_3-D\"><\/span>C\u00c1C H\u00c0M EXCEL H\u1ed6 TR\u1ee2 THAM CHI\u1ebeU 3-D<span class=\"ez-toc-section-end\"><\/span><\/h1>\n<p style=\"text-align: justify\">Sau \u0111\u00e2y l\u00e0 danh s\u00e1ch c\u00e1c h\u00e0m\u00a0trong Excel cho ph\u00e9p s\u1eed d\u1ee5ng tham chi\u1ebfu 3-D:<\/p>\n<p style=\"text-align: justify\">SUM \u2013 t\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb s\u1ed1.<\/p>\n<p style=\"text-align: justify\">AVERAGE \u2013 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh c\u1ee7a c\u00e1c con s\u1ed1.<\/p>\n<p style=\"text-align: justify\">AVERAGEA \u2013 t\u00ednh gi\u00e1 tr\u1ecb trung b\u00ecnh, g\u1ed3m c\u00f3 ch\u1eef s\u1ed1, k\u00fd t\u1ef1 v\u00e0 c\u00e1c ph\u00e9p l\u00f4gic.<\/p>\n<p style=\"text-align: justify\">COUNT \u2013 \u0111\u1ebfm c\u00e1c \u00f4 c\u00f3 s\u1ed1.<\/p>\n<p style=\"text-align: justify\">COUNTA \u2013 \u0111\u1ebfm c\u00e1c \u00f4 kh\u00f4ng r\u1ed7ng.<\/p>\n<p style=\"text-align: justify\">MAX \u2013 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">MAXA \u2013 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t, bao g\u1ed3m k\u00fd t\u1ef1 v\u00e0 ph\u00e9p l\u00f4gic.<\/p>\n<p style=\"text-align: justify\">MIN \u2013 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t.<\/p>\n<p style=\"text-align: justify\">MINA \u2013 tr\u1ea3 v\u1ec1 gi\u00e1 tr\u1ecb nh\u1ecf nh\u1ea5t, bao g\u1ed3m k\u00fd t\u1ef1 v\u00e0 ph\u00e9p l\u00f4gic.<\/p>\n<p style=\"text-align: justify\">PRODUCT \u2013 \u00a0nh\u00e2n c\u00e1c s\u1ed1.<\/p>\n<p style=\"text-align: justify\">STDEV, STDEVA, STDEVP, STDEVPA \u2013 t\u00ednh \u0111\u1ed9 l\u1ec7ch d\u1ef1a tr\u00ean m\u1eabu c\u1ee7a chu\u1ed7i c\u00e1c gi\u00e1 tr\u1ecb x\u00e1c \u0111\u1ecbnh.<\/p>\n<p style=\"text-align: justify\">VAR, VARA, VARP, VARPA \u2013 tr\u1ea3 v\u1ec1 ph\u01b0\u01a1ng sai d\u1ef1a tr\u00ean m\u1eabu c\u1ee7a chu\u1ed7i c\u00e1c gi\u00e1 tr\u1ecb.<\/p>\n<h3 style=\"text-align: justify\"><span class=\"ez-toc-section\" id=\"LUU_Y_KHI_CHEN_DI_CHUYEN_VA_XOA_TRANG_TINH_SE_LAM_THAY_DOI_THAM_CHIEU_3-D_TRONG_EXCEL\"><\/span>L\u01afU \u00dd: KHI CH\u00c8N, DI CHUY\u1ec2N V\u00c0 X\u00d3A TRANG T\u00cdNH S\u1ebc L\u00c0M THAY \u0110\u1ed4I THAM CHI\u1ebeU 3-D TRONG EXCEL<span class=\"ez-toc-section-end\"><\/span><\/h3>\n<p style=\"text-align: justify\">B\u1edfi v\u00ec, m\u1ed7i tham chi\u1ebfu 3-D trong Excel \u0111\u01b0\u1ee3c x\u00e1c \u0111\u1ecbnh b\u1eb1ng m\u1ed9t trang t\u00ednh b\u1eaft \u0111\u1ea7u v\u00e0 m\u1ed9t trang t\u00ednh k\u1ebft th\u00fac, n\u00ean h\u00e3y g\u1ecdi ch\u00fang l\u00e0 \u0111i\u1ec3m n\u00fat tham chi\u1ebfu 3-D, vi\u1ec7c thay \u0111\u1ed5i \u0111i\u1ec3m n\u00fat s\u1ebd thay \u0111\u1ed5i tham chi\u1ebfu, v\u00ec v\u1eady s\u1ebd thay \u0111\u1ed5i c\u00f4ng th\u1ee9c 3-D c\u1ee7a b\u1ea1n. V\u00e0 b\u00e2y gi\u1edd, h\u00e3y xem \u0111i\u1ec1u g\u00ec s\u1ebd x\u1ea3y ra khi b\u1ea1n di chuy\u1ec3n hay x\u00f3a \u0111i\u1ec3m n\u00fat tham chi\u1ebfu 3-D, hay ch\u00e8n, x\u00f3a v\u00e0 di chuy\u1ec3n c\u00e1c trang t\u00ednh n\u1eb1m trong \u0111i\u1ec3m n\u00fat.<\/p>\n<p style=\"text-align: justify\">M\u00ecnh s\u1ebd gi\u1ea3i th\u00edch chi ti\u1ebft h\u01a1n\u00a0 qua v\u00ed d\u1ee5 \u0111\u1ec3 m\u1ecdi g\u01b0\u1eddi d\u1ec5 hi\u1ec3u h\u01a1n nh\u00e9.<\/p>\n<p style=\"text-align: justify\">X\u00e9t c\u00f4ng th\u1ee9c 3-D m\u00e0 ch\u00fang ta \u0111\u00e3 t\u1ea1o ra tr\u01b0\u1edbc \u0111\u00f3:<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6442 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/210.png\" width=\"251\" height=\"212\" title=\"210\"><\/p>\n<p style=\"text-align: justify\">Ch\u00e8n, di chuy\u1ec3n hay sao ch\u00e9p trang t\u00ednh b\u00ean trong \u0111i\u1ec3m n\u00fat. N\u1ebfu b\u1ea1n ch\u00e8n, sao ch\u00e9p hay di chuy\u1ec3n c\u00e1c trang t\u00ednh gi\u1eefa \u0111i\u1ec3m n\u00fat tham chi\u1ebfu 3D (trang t\u00ednh Th\u00e1ng M\u1ed9t v\u00e0 Th\u00e1ng T\u01b0 trong v\u00ed d\u1ee5 n\u00e0y), th\u00ec d\u1ea3i \u00f4 tham chi\u1ebfu (t\u1eeb \u00f4 B2 \u0111\u1ebfn \u00f4 B5) \u1edf t\u1ea5t c\u1ea3 c\u00e1c trang t\u00ednh v\u1eeba \u0111\u01b0\u1ee3c th\u00eam v\u00e0o \u0111\u1ec1u \u0111\u01b0\u1ee3c th\u00eam v\u00e0o ph\u00e9p t\u00ednh.<\/p>\n<p style=\"text-align: justify\">X\u00f3a trang t\u00ednh, hay di chuy\u1ec3n trang t\u00ednh ra kh\u1ecfi \u0111i\u1ec3m n\u00fat. Khi b\u1ea1n x\u00f3a b\u1ea5t c\u1ee9 trang t\u00ednh n\u00e0o \u1edf trong \u0111i\u1ec3m n\u00fat, hay di chuy\u1ec3n trang t\u00ednh ra kh\u1ecfi \u0111i\u1ec3m n\u00fat, nh\u1eefng trang t\u00ednh n\u00e0y s\u1ebd \u0111\u01b0\u1ee3c lo\u1ea1i ra kh\u1ecfi c\u00f4ng th\u1ee9c 3-D c\u1ee7a b\u1ea1n.<\/p>\n<p style=\"text-align: justify\">Di chuy\u1ec3n m\u1ed9t \u0111i\u1ec3m n\u00fat. N\u1ebfu b\u1ea1n di chuy\u1ec3n m\u1ed9t \u0111i\u1ec3m n\u00fat b\u1ea5t k\u1ef3 (trang t\u00ednh Th\u00e1ng M\u1ed9t hay Th\u00e1ng T\u01b0, hay c\u1ea3 hai) \u0111\u1ebfn m\u1ed9t v\u1ecb tr\u00ed m\u1edbi trong c\u00f9ng c\u1eeda s\u1ed5, Excel s\u1ebd \u0111i\u1ec1u ch\u1ec9nh c\u00f4ng th\u1ee9c 3-D \u0111\u1ec3 th\u00eam v\u00e0o c\u00e1c trang t\u00ednh m\u1edbi n\u1eb1m gi\u1eefa \u0111i\u1ec3m n\u00fat, v\u00e0 x\u00f3a c\u00e1c trang t\u00ednh n\u1eb1m ngo\u00e0i \u0111i\u1ec3m n\u00fat.<\/p>\n<p style=\"text-align: justify\">Ho\u00e1n \u0111\u1ed5i \u0111i\u1ec3m n\u00fat. Vi\u1ec7c ho\u00e1n \u0111\u1ed5i \u0111i\u1ec3m n\u00fat tham chi\u1ebfu 3-D trong Excel s\u1ebd d\u1eabn \u0111\u1ebfn vi\u1ec7c thay \u0111\u1ed5i m\u1ed9t trong c\u00e1c trang t\u00ednh \u0111i\u1ec3m n\u00fat. V\u00ed d\u1ee5, n\u1ebfu b\u1ea1n di chuy\u1ec3n trang t\u00ednh m\u1edf \u0111\u1ea7u ( Th\u00e1ng M\u1ed9t) ra ph\u00eda sau trang t\u00ednh k\u1ebft th\u00fac (Th\u00e1ng T\u01b0), trang t\u00ednh Th\u00e1ng M\u1ed9t s\u1ebd b\u1ecb x\u00f3a kh\u1ecfi tham chi\u1ebfu 3-D, \u0111i\u1ec1u n\u00e0y s\u1ebd d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3\u00a0Feb:Apr!B2:B5.<\/p>\n<p style=\"text-align: justify\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-6443 aligncenter\" src=\"http:\/\/blog.ezworkapp.com\/wp-content\/uploads\/2025\/01\/211.png\" width=\"251\" height=\"186\" title=\"211\"><\/p>\n<p style=\"text-align: justify\">Vi\u1ec7c di chuy\u1ec3n trang t\u00ednh k\u1ebft th\u00fac (Th\u00e1ng T\u01b0) ra tr\u01b0\u1edbc trang t\u00ednh m\u1edf \u0111\u1ea7u (Th\u00e1ng M\u1ed9t) c\u0169ng c\u00f3 \u1ea3nh h\u01b0\u1edfng t\u01b0\u01a1ng t\u1ef1. Trong tr\u01b0\u1eddng h\u1ee3p n\u00e0y, trang t\u00ednh Th\u00e1ng T\u01b0 s\u1ebd b\u1ecb x\u00f3a kh\u1ecfi tham chi\u1ebfu 3-D, vi\u1ec7c n\u00e0y d\u1eabn \u0111\u1ebfn k\u1ebft qu\u1ea3 \u00a0Jan:Mar!B2:B5.<\/p>\n<p style=\"text-align: justify\">H\u00e3y l\u01b0u \u00fd r\u1eb1ng vi\u1ec7c kh\u00f4i ph\u1ee5c v\u1ecb tr\u00ed ban \u0111\u1ea7u s\u1ebd kh\u00f4ng kh\u00f4i ph\u1ee5c tham chi\u1ebfu 3-D ban \u0111\u1ea7u. Trong v\u00ed d\u1ee5 tr\u00ean, ngay c\u1ea3 khi ch\u00fang ta di chuy\u1ec3n trang t\u00ednh Th\u00e1ng M\u1ed9t v\u1ec1 v\u1ecb tr\u00ed ban \u0111\u1ea7u, th\u00ec tham chi\u1ebfu 3-D v\u1eabn c\u00f3 d\u1ea1ng\u00a0Feb:Apr!B2:B5, v\u00e0 b\u1ea1n ph\u1ea3i ch\u1ec9nh s\u1eeda n\u00f3 m\u1ed9t c\u00e1ch th\u1ee7 c\u00f4ng \u0111\u1ec3 th\u00eam trang t\u00ednh Th\u00e1ng M\u1ed9t v\u00e0o ph\u00e9p t\u00ednh.<\/p>\n<p style=\"text-align: justify\">X\u00f3a \u0111i\u1ec3m n\u00fat. Khi b\u1ea1n x\u00f3a m\u1ed9t trong hai trang t\u00ednh \u0111i\u1ec3m n\u00fat, n\u00f3 s\u1ebd b\u1ecb x\u00f3a kh\u1ecfi tham chi\u1ebfu 3D, v\u00e0 \u0111i\u1ec3m n\u00fat b\u1ecb x\u00f3a thay \u0111\u1ed5i theo h\u01b0\u1edbng n\u00e0y:<\/p>\n<p style=\"text-align: justify\">&gt; N\u1ebfu trang t\u00ednh \u0111\u1ea7u ti\u00ean b\u1ecb x\u00f3a, th\u00ec \u0111i\u1ec3m n\u00fat thay \u0111\u1ed5i th\u00e0nh trang t\u00ednh \u1edf ngay sau trang t\u00ednh b\u1ecb x\u00f3a. Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu trang t\u00ednh Th\u00e1ng M\u1ed9t b\u1ecb x\u00f3a, th\u00ec tham chi\u1ebfu 3D thay \u0111\u1ed5i th\u00e0nh\u00a0Feb:Apr!B2:B5.<\/p>\n<p style=\"text-align: justify\">&gt; N\u1ebfu trang t\u00ednh cu\u1ed1i c\u00f9ng b\u1ecb x\u00f3a, th\u00ec \u0111i\u1ec3m n\u00fat thay \u0111\u1ed5i th\u00e0nh trang t\u00ednh \u1edf ph\u00eda tr\u01b0\u1edbc. Trong v\u00ed d\u1ee5 n\u00e0y, n\u1ebfu trang t\u00ednh Th\u00e1ng T\u01b0 b\u1ecb x\u00f3a, th\u00ec tham chi\u1ebfu 3D thay \u0111\u1ed5i th\u00e0nh\u00a0Jan:Mar!B2:B5.<\/p>\n<p style=\"text-align: justify\">\u0110\u00e2y l\u00e0 c\u00e1ch b\u1ea1n t\u1ea1o ra v\u00e0 s\u1eed d\u1ee5ng tham chi\u1ebfu 3D trong Excel. Nh\u01b0 b\u1ea1n c\u00f3 th\u1ec3 th\u1ea5y, \u0111\u00e2y l\u00e0 c\u00e1ch r\u1ea5t thu\u1eadn ti\u1ec7n v\u00e0 nhanh ch\u00f3ng \u0111\u1ec3 t\u00ednh to\u00e1n c\u00f9ng m\u1ed9t d\u1ea3i \u00f4 n\u1eb1m tr\u00ean nhi\u1ec1u trang t\u00ednh. Khi vi\u1ec7c c\u1eadp nh\u1eadt c\u00e1c c\u00f4ng th\u1ee9c d\u00e0i d\u00f2ng \u0111\u1ec3 tham chi\u1ebfu c\u00e1c trang t\u00ednh kh\u00e1c nhau c\u00f3 th\u1ec3 tr\u1edf n\u00ean nh\u00e0m ch\u00e1n, th\u00ec c\u00f4ng th\u1ee9c 3-D trong Excel ch\u1ec9 y\u00eau c\u1ea7u vi\u1ec7c c\u1eadp nh\u1eadt m\u1ed9t v\u00e0i tham chi\u1ebfu, hay b\u1ea1n ch\u1ec9 c\u1ea7n ch\u00e8n c\u00e1c trang t\u00ednh m\u1edbi \u00a0v\u00e0o gi\u1eefa \u0111i\u1ec3m n\u00fat tham chi\u1ebfu 3D m\u00e0 kh\u00f4ng c\u1ea7n thay \u0111\u1ed5i c\u00f4ng th\u1ee9c.<\/p>\n<p style=\"text-align: justify\">C\u00e1c b\u1ea1n c\u00f3 th\u1ec3 xem nhi\u1ec1u b\u00e0i vi\u1ebft h\u01a1n <a href=\"http:\/\/blog.ezworkapp.com\/\">t\u1ea1i \u0111\u00e2y<\/a> : \u00a0 blog.hocexcel.online<\/p>\n<p style=\"text-align: justify\">C\u1ea3m \u01a1n c\u00e1c b\u1ea1n v\u00ec \u0111\u00e3 \u0111\u1ecdc b\u00e0i vi\u1ebft n\u00e0y h\u00f4m nay. H\u1eb9n g\u1eb7p l\u1ea1i c\u00e1c b\u1ea1n v\u00e0o tu\u1ea7n t\u1edbi!<\/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-327.gif\"><br \/>\n<\/a>\n<\/div>\n","protected":false},"author":1,"featured_media":11814,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-11813","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\/11813","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=11813"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/11813\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/11814"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=11813"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=11813"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=11813"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}