{"id":1106,"date":"2017-02-20T17:49:39","date_gmt":"2017-02-20T10:49:39","guid":{"rendered":"https:\/\/engisv.info\/?p=1106"},"modified":"2017-02-20T17:49:39","modified_gmt":"2017-02-20T10:49:39","slug":"microsoft-excel-phan-1-cac-khai-niem-co-ban","status":"publish","type":"post","link":"https:\/\/www.engisv.info\/?p=1106","title":{"rendered":"Microsoft Excel &#8211; C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n"},"content":{"rendered":"<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng v\u0103n ph\u00f2ng quan tr\u1ecdng c\u1ee7a b\u1ed9 Microsoft Office, l\u00e0 \u1ee9ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c b\u1ea3ng t\u00ednh, th\u00f4ng k\u00ea, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, l\u1eadp k\u1ebf ho\u1ea1ch&#8230; Trong lo\u1ea1t b\u00e0i n\u00e0y, t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n \u0111\u1ec3 nh\u1eefng b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u ho\u1eb7c nh\u1eefng b\u1ea1n l\u00e2u ng\u00e0y kh\u00f4ng s\u1ee7 d\u1ee5ng c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i ki\u1ebfn th\u1ee9c, hy v\u1ecdng v\u1edbi lo\u1ea1t b\u00e0i n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi m\u1edbi ti\u1ebfp x\u00fac kh\u00f4ng c\u00f2n th\u1ea5y Excel l\u00e0 c\u00e1i g\u00ec \u0111\u00f3 qu\u00e1 ph\u1ee9c t\u1ea1p.<\/p>\n<p><strong>C\u01a1 b\u1ea3n v\u1ec1\u00a0giao di\u1ec7n l\u00e0m vi\u1ec7c:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-1109 size-large aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/01-1024x539.png\" width=\"640\" height=\"337\" \/><\/p>\n<ul>\n<li>(1) Nh\u01b0 c\u00e1c ph\u1ea7n m\u1ec1m kh\u00e1c c\u1ee7a MS Office, th\u00ec \u0111\u00e2y l\u00e0 ph\u1ea7n ch\u1ee9a c\u00e1c tr\u00ecnh \u0111\u01a1n l\u1ec7nh \u0111\u01b0\u1ee3c nh\u00f3m th\u00e0nh c\u00e1c nh\u00f3m ch\u1ee9c n\u0103ng (c\u1ee5 th\u1ec3 t\u1eebng ph\u1ea7n n\u1ebfu g\u1eb7p t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u c\u1ee5 th\u1ec3 h\u01a1n trong c\u00e1c b\u00e0i vi\u1ebft).<\/li>\n<li>(2) Khi c\u1ea7n s\u1eed d\u1ee5ng c\u00e1c h\u00e0m, ch\u00fang ta c\u00f3 th\u1ec3 click v\u00e0o bi\u1ec3u t\u01b0\u1ee3ng<strong> fx<\/strong> n\u00e0y \u0111\u1ec3 c\u00f3 th\u1ec3 xem g\u1ee3i \u00fd c\u1ee7a t\u1ea5t c\u1ea3 c\u00e1c h\u00e0m trong Excel, trong g\u1ee3i \u00fd c\u00f3 c\u1ea3 v\u00ed d\u1ee5 v\u00e0 c\u00e1c h\u01b0\u1edbng d\u1ea9n d\u00f9ng h\u00e0m.<\/li>\n<li>(3) C\u00e1c c\u1ed9t trong khu v\u1ef1c l\u00e0m vi\u1ec7c, c\u00e1c c\u1ed9t \u0111\u01b0\u1ee3c \u0111\u01b0\u1ee3c \u0111\u00e1nh th\u1ee9 t\u1ef1 b\u1eb1ng k\u00fd t\u1ef1 b\u1eaft \u0111\u1ea7u t\u1eeb A,B,C&#8230;. tr\u00ean m\u1ed9t sheet c\u00f3 c\u00f3 th\u1ec3 c\u00f3 \u0111\u1ebfn 16,384 c\u1ed9t t\u00f9y phi\u00ean b\u1ea3n.<\/li>\n<li>(4) C\u00e1c d\u00f2ng trong khu v\u1ef1c l\u00e0m vi\u1ec7c \u0111\u01b0\u1ee3c \u0111\u00e1nh theo s\u1ed1 th\u1ee9 t\u1ef1 t\u1eeb 1,2,3,&#8230; tr\u00ean m\u1ed9t sheet c\u00f3 th\u1ec3 c\u00f3 \u0111\u1ebfn 1,048,576 t\u00f9y phi\u00ean b\u1ea3n.<\/li>\n<li>(5) Sheet\u00a0l\u00e0 m\u1ed9t trang l\u00e0m vi\u1ec7c, m\u1eb7c \u0111\u1ecbnh tr\u00ean MS Office 2013, 2016 s\u1ebd c\u00f3 m\u1ed9t sheet khi t\u1ea1o m\u1edbi file, c\u00e1c phi\u00ean b\u1ea3n tr\u01b0\u1edbc \u0111\u00f3 th\u00ec c\u00f3 3 sheet. S\u1ed1 sheet t\u1ed1i \u0111a ph\u1ee5 thu\u1ed9c v\u00e0o b\u1ed9 nh\u1edb c\u1ee7a m\u00e1y t\u00ednh.<\/li>\n<li>(6) Hi\u1ec3n th\u1ecb c\u00e1c n\u1ed9i dung ch\u1ee9a trong \u00f4 nh\u01b0 c\u00e1c h\u00e0m, c\u00f4ng th\u1ee9c, ph\u00e9p to\u00e1n, d\u1eef li\u1ec7u&#8230;<\/li>\n<\/ul>\n<p><strong>C\u00e1c ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a excel:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1110 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/02-300x261.png\" alt=\"\" width=\"300\" height=\"261\" \/><\/p>\n<p>Trong excel c\u00f3 c\u00e1c d\u1eef li\u1ec7u ki\u1ec3m s\u1ed1, chu\u1ed7i k\u00fd t\u1ef1, ng\u00e0y th\u00e1ng&#8230; xong c\u00f3 hai ki\u1ec3u c\u01a1 b\u1ea3n m\u00e0 ch\u00fang l\u00e0 s\u1ed1 v\u00e0 chu\u1ed7i.<\/p>\n<ul>\n<li><strong>Ki\u1ec3u s\u1ed1<\/strong> l\u00e0 c\u00e1c s\u1ed1 \u0111\u01b0\u1ee3c h\u00ecnh th\u00e0nh c\u00e1c s\u1ed3 t\u1eeb 0 \u0111\u1ebfn 9, ki\u1ec3u s\u1ed1 trong excel v\u1ec1 m\u1eb7c \u0111\u1ecbnh s\u1ebd n\u1eb1m b\u00ean tr\u00e1i c\u1ee7a \u00f4 d\u1eef li\u1ec7u. Ki\u1ec3u s\u1ed1 d\u00f9ng \u0111\u1ec3 t\u00ednh to\u00e1n.<\/li>\n<li><strong>Ki\u1ec3u chu\u1ed7i<\/strong>\u00a0l\u00e0 ki\u1ec3u n\u00e0y th\u01b0\u1eddng d\u00f9ng \u0111\u1ec3 ghi nh\u1eadn th\u00f4ng tin. Ki\u1ec3u chu\u1ed7i \u00a0khi nh\u1eadp d\u1eef li\u1ec7u \u00a0v\u00e0o\u00a0m\u1eb7c \u0111\u1ecbnh s\u1ebd n\u1eb1m ph\u00eda b\u00ean ph\u1ea3i c\u1ee7a \u00f4 d\u1eef li\u1ec7u. C\u00f3 c\u00e1c c\u00e1ch hinh th\u00e0nh chu\u1ed7i nh\u01b0 sau:\n<ul>\n<li>Chu\u1ed7i k\u00fd t\u1ef1 h\u00ecnh th\u00e0nh t\u1eeb c\u00e1c k\u00fd t\u1ef1 t\u1eeb A \u0111\u1ebfn Z \u00a0 ho\u1eb7c a \u0111\u1ebfn z, c\u00e1c k\u00fd t\u1ef1 \u0111\u1eb7t bi\u1ec7t nh\u01b0 #,@,&#8230;<\/li>\n<li>Trong m\u1ed9t d\u00e3y s\u1ed1 c\u00f3 ch\u01b0a \u00edt nh\u1ea5t m\u1ed9t k\u00fd t\u1ef1 th\u00ec ki\u1ec3u d\u1eef li\u1ec7u c\u1ee7a ch\u00fang c\u0169ng l\u00e0 ki\u1ec3u chu\u1ed7i.<\/li>\n<li>\u0110\u1ec3 nh\u1eadp d\u1eef li\u1ec7u s\u1ed1 th\u00e0nh ki\u1ec3u chu\u1ed5i k\u00fd t\u1ef1, khi nh\u1eadp li\u1ec7u, ta b\u1eaft \u0111\u1ea7u b\u1eb1ng nh\u1ea5u nh\u00e1y \u0111\u01a1n (&#8216;) ph\u00eda tr\u01b0\u1edbc chu\u1ed7i s\u1ed1, c\u00e1ch n\u00e0y d\u00f9ng \u0111\u1ec3 nh\u1eadp li\u1ec7u c\u00e1c d\u1eef li\u1ec7u nh\u01b0 s\u1ed1 \u0111i\u1ec7n tho\u1ea1i, m\u00e3 s\u1ed1 th\u01b0\u1eddng b\u1eaft \u0111\u1ea7u t\u1eeb s\u1ed1 0 v\u00ed d\u1ee5: 0983333333 s\u1ebd nh\u1eadp v\u00e0o \u00f4 d\u1eef li\u1ec7u &#8216;0983333333<\/li>\n<\/ul>\n<\/li>\n<\/ul>\n<p>M\u1ed9t h\u00e0m, m\u1ed9t c\u00f4ng th\u1ee9c t\u00ednh bao g\u1ed3m c\u00e1c ph\u00e9p to\u00e1n v\u00e0 c\u00e1c h\u00e0m trong Excel \u0111\u01b0\u1ee3c h\u00ecnh th\u00e0nh b\u1eaft \u0111\u1ea7u b\u1eb1ng d\u1ea5u b\u1eb1ng (=).<\/p>\n<p>\u0110\u1ec3 h\u00ecnh th\u00e0nh c\u00f4ng th\u1ee9c trong excel, ta c\u00f3 th\u1ec3 d\u00f9ng c\u00e1c ph\u00e9p to\u00e1n c\u1ed9ng (+), tr\u1eeb (-), nh\u00e2n (*), chia (\/), l\u1ee7y th\u1eeba (^) c\u00e1c h\u00e0m lu\u1eadn l\u00fd, h\u00e0m so s\u00e1nh&#8230; Ch\u00fang ta s\u1ebd l\u00e0m chi ti\u1ebft ph\u1ea7n n\u00e0y trong c\u00e1c b\u00e0i vi\u1ebft sau.<\/p>\n<p>Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, v\u00f9ng l\u00e0m vi\u1ec7c c\u1ee7a excel ch\u1ee9a c\u00e1c \u00f4 (cell), c\u00e1c \u00f4 n\u00e0y \u0111\u01b0\u1ee3c h\u00ecnh th\u00e0nh t\u1eeb c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t giao v\u1edbi nhau, nh\u01b0 trong h\u00ecnh ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y \u00f4 giao gi\u1eefa c\u1ed9t C v\u00e0 d\u00f2ng 2 th\u00ec c\u00f3 t\u00ean l\u00e0 C2, \u0111\u00e2y ch\u00ednh l\u00e0 t\u1ecda \u0111\u1ed9 hay n\u00f3i c\u00e1ch kh\u00e1c l\u00e0 \u0111\u1ecba ch\u1ec9 \u00f4.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1111 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/03-300x220.png\" alt=\"\" width=\"300\" height=\"220\" \/><\/p>\n<p>T\u01b0\u01a1ng t\u1ef1 ta s\u1ebd c\u00f3 \u0111\u1ecba ch\u1ec9 m\u1ed9t v\u00f9ng d\u1eef li\u1ec7u, nh\u01b0 b\u00ean d\u01b0\u1edbi l\u00e0 v\u00f9ng d\u1eef li\u1ec7u t\u00ednh t\u1eeb \u00f4 B2 \u0111\u1ebfn \u00f4 C5.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1112 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/04-300x226.png\" alt=\"\" width=\"300\" height=\"226\" \/><\/p>\n<p>Ngo\u00e0i ra ch\u00fang ta c\u00f3 th\u1ec3 li\u00ean k\u1ebft d\u1eef li\u1ec7u t\u1eeb sheet n\u00e0y qua sheet kh\u00e1c trong excel v\u00e0 n\u00f3 s\u1ebd \u0111\u01b0\u1ee3c g\u00e1n th\u00eam trong ph\u1ea7n \u0111\u1ecba ch\u1ec9 l\u00e0 \u00f4 d\u1eef li\u1ec7u \u0111\u00f3 thu\u1ed9c sheet n\u00e0o.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1115 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/06-300x247.png\" alt=\"\" width=\"300\" height=\"247\" \/><\/p>\n<p><strong>\u0110\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 tuy\u1ec7t \u0111\u1ed1i:<\/strong><\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1121 aligncenter zoooom\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/07-300x259.png\" alt=\"\" width=\"300\" height=\"259\" \/><\/p>\n<p>Nh\u01b0 \u0111\u00e3 n\u00f3i \u1edf tr\u00ean, b\u1ea3ng t\u00ednh excel \u0111\u01b0\u1ee3c h\u00ecnh th\u00e0nh t\u1eeb c\u00e1c \u00f4 l\u00e0 giao gi\u1eefa c\u00e1c d\u00f2ng v\u00e0 c\u1ed9t v\u1ecb tr\u00ed \u0111\u00f3 \u0111\u01b0\u1ee3c g\u1ecdi l\u00e0 m\u1ed9t \u0111\u1ecba ch\u1ec9. V\u1eady nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i v\u00e0 \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i?<\/p>\n<ul>\n<li><strong>\u0110\u1ecba ch\u1ec9 t\u01b0\u01a1ng \u0111\u1ed1i<\/strong> l\u00e0 \u0111\u1ecba ch\u1ec9 khi th\u1ef1c hi\u1ec7n ph\u00e9p to\u00e1n ho\u1eb7c h\u00e0m, l\u00fac th\u1ef1 hi\u1ec7n vi\u1ec7c copy c\u00e1c \u0111\u1ecba ch\u1ec9 n\u00e0y s\u1ebd thay \u0111\u1ed5i theo theo chi\u1ec1u d\u1ecdc ho\u1eb7c ngang t\u01b0\u01a1ng \u1ee9ng v\u1edbi v\u1ecb tr\u00ed con tr\u1ecf.<\/li>\n<li><strong>\u0110\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i<\/strong>\u00a0(hay \u0111\u1ecba ch\u1ec9 c\u1ed1 \u0111\u1ecbnh) l\u00e0 \u0111\u1ecba ch\u1ec9 kh\u00f4ng thay \u0111\u1ed5i khi khi th\u1ef1c hi\u1ec7n vi\u1ec7c copy h\u00e0m ho\u1eb7c ph\u00e9p to\u00e1n theo chi\u1ec1u d\u1ecdc ho\u1eb7c ngang. \u0110\u1ec3 thi\u1ebft l\u1eadp \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i ta nh\u1ea5n ph\u00edm F4 ngay v\u1ecb tr\u00ed \u0111\u1ecba ch\u1ec9 mu\u1ed1n chuy\u1ec3n th\u00e0nh \u0111\u1ecb ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i, ho\u1eb7c b\u1ea1n c\u00f3 th\u1ec3 t\u1ef1 th\u00eam d\u1ea5u $.<\/li>\n<\/ul>\n<p>V\u00ed d\u1ee5 trong h\u00ecnh tr\u00ean cho ta th\u1ea5y \u1edf c\u1ed9t E l\u00e0 ph\u00e9p c\u1ed9ng c\u1ee7a c\u00e1c \u00f4 c\u1ed9t C v\u1edbi m\u1ed9t gi\u00e1 tr\u1ecb trong \u00f4 B2, ch\u00fang ta c\u00f3 th\u1ec3 th\u1ea5y c\u00e1c \u0111\u1ecba ch\u1ec9 c\u1ee7a c\u1ed9t C thay \u0111\u1ed5i t\u1eeb tr\u00ean xu\u1ed1ng v\u00e0 \u0111\u01b0a d\u1eef li\u1ec7u t\u01b0\u01a1ng \u1ee9ng c\u1ee7a c\u00e1c \u00f4 v\u00e0o ph\u00e9p to\u00e1n, trong khi gi\u00e1 tr\u1ecb c\u1ed9t B ch\u1ec9 c\u1ed1 \u0111\u1ecbnh \u1edf c\u1ed9t B2.<\/p>\n<p><img loading=\"lazy\" decoding=\"async\" class=\"size-medium wp-image-1129 aligncenter\" src=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/08-300x280.png\" alt=\"\" width=\"300\" height=\"280\" \/><\/p>\n<p>Ch\u00fang ta c\u00f3 th\u1ec3 ch\u1ecdn m\u1ed9t v\u00f9ng \u0111\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i.<\/p>\n<p>\u0110\u1ecba ch\u1ec9 tuy\u1ec7t \u0111\u1ed1i c\u00f3 th\u1ec3 r\u00e0ng bu\u1ed9c c\u1ea3 d\u00f2ng v\u00e0 c\u1ed9t nh\u01b0 $B$2 ho\u1eb7c ch\u1ec9 r\u00e0ng bu\u1ed9c c\u1ed9t $B2 hay ch\u1ec9 r\u00e0ng bu\u1ed9c d\u00f2ng B$2.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng v\u0103n ph\u00f2ng quan tr\u1ecdng c\u1ee7a b\u1ed9 Microsoft Office, l\u00e0 \u1ee9ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c b\u1ea3ng t\u00ednh, th\u00f4ng k\u00ea, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, l\u1eadp k\u1ebf ho\u1ea1ch&#8230; Trong lo\u1ea1t b\u00e0i n\u00e0y, t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n \u0111\u1ec3 nh\u1eefng b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u ho\u1eb7c nh\u1eefng b\u1ea1n l\u00e2u ng\u00e0y kh\u00f4ng s\u1ee7 d\u1ee5ng c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i ki\u1ebfn th\u1ee9c, hy v\u1ecdng v\u1edbi lo\u1ea1t b\u00e0i n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi m\u1edbi ti\u1ebfp x\u00fac kh\u00f4ng c\u00f2n th\u1ea5y Excel l\u00e0 c\u00e1i g\u00ec \u0111\u00f3 qu\u00e1 ph\u1ee9c t\u1ea1p.&hellip;<\/p>\n","protected":false},"author":2,"featured_media":1108,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_exactmetrics_skip_tracking":false,"footnotes":""},"categories":[14,15],"tags":[37],"class_list":["post-1106","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-thu-thuat","category-van-phong","tag-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO plugin v28.7 - https:\/\/yoast.com\/product\/yoast-seo-wordpress\/ -->\n<title>Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV<\/title>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/www.engisv.info\/?p=1106\" \/>\n<meta property=\"og:locale\" content=\"en_US\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV\" \/>\n<meta property=\"og:description\" content=\"Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng v\u0103n ph\u00f2ng quan tr\u1ecdng c\u1ee7a b\u1ed9 Microsoft Office, l\u00e0 \u1ee9ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c b\u1ea3ng t\u00ednh, th\u00f4ng k\u00ea, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, l\u1eadp k\u1ebf ho\u1ea1ch&#8230; Trong lo\u1ea1t b\u00e0i n\u00e0y, t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n \u0111\u1ec3 nh\u1eefng b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u ho\u1eb7c nh\u1eefng b\u1ea1n l\u00e2u ng\u00e0y kh\u00f4ng s\u1ee7 d\u1ee5ng c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i ki\u1ebfn th\u1ee9c, hy v\u1ecdng v\u1edbi lo\u1ea1t b\u00e0i n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi m\u1edbi ti\u1ebfp x\u00fac kh\u00f4ng c\u00f2n th\u1ea5y Excel l\u00e0 c\u00e1i g\u00ec \u0111\u00f3 qu\u00e1 ph\u1ee9c t\u1ea1p.&hellip;\" \/>\n<meta property=\"og:url\" content=\"https:\/\/www.engisv.info\/?p=1106\" \/>\n<meta property=\"og:site_name\" content=\"EngISV\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/engisv\" \/>\n<meta property=\"article:published_time\" content=\"2017-02-20T10:49:39+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png\" \/>\n\t<meta property=\"og:image:width\" content=\"300\" \/>\n\t<meta property=\"og:image:height\" content=\"300\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/png\" \/>\n<meta name=\"author\" content=\"hoanghiepktv\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:label1\" content=\"Written by\" \/>\n\t<meta name=\"twitter:data1\" content=\"hoanghiepktv\" \/>\n\t<meta name=\"twitter:label2\" content=\"Est. reading time\" \/>\n\t<meta name=\"twitter:data2\" content=\"7 minutes\" \/>\n<script type=\"application\/ld+json\" class=\"yoast-schema-graph\">{\"@context\":\"https:\\\/\\\/schema.org\",\"@graph\":[{\"@type\":\"Article\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#article\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106\"},\"author\":{\"name\":\"hoanghiepktv\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\"},\"headline\":\"Microsoft Excel &#8211; C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n\",\"datePublished\":\"2017-02-20T10:49:39+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106\"},\"wordCount\":1372,\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"keywords\":[\"Excel\"],\"articleSection\":[\"Th\u1ee7 thu\u1eadt\",\"V\u0103n ph\u00f2ng\"],\"inLanguage\":\"en-US\"},{\"@type\":\"WebPage\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106\",\"name\":\"Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV\",\"isPartOf\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#primaryimage\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#primaryimage\"},\"thumbnailUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"datePublished\":\"2017-02-20T10:49:39+00:00\",\"breadcrumb\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#breadcrumb\"},\"inLanguage\":\"en-US\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\\\/\\\/www.engisv.info\\\/?p=1106\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#primaryimage\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2017\\\/02\\\/excel-cover-1.png\",\"width\":300,\"height\":300},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/?p=1106#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"Home\",\"item\":\"https:\\\/\\\/www.engisv.info\\\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"Microsoft Excel &#8211; C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#website\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"name\":\"EngISV\",\"description\":\"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!\",\"publisher\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\\\/\\\/www.engisv.info\\\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"en-US\"},{\"@type\":\"Organization\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#organization\",\"name\":\"EngISV\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\",\"url\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"contentUrl\":\"https:\\\/\\\/www.engisv.info\\\/wp-content\\\/uploads\\\/2018\\\/06\\\/logo2-3-1-1.png\",\"width\":200,\"height\":76,\"caption\":\"EngISV\"},\"image\":{\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/logo\\\/image\\\/\"},\"sameAs\":[\"https:\\\/\\\/www.facebook.com\\\/engisv\"]},{\"@type\":\"Person\",\"@id\":\"https:\\\/\\\/www.engisv.info\\\/#\\\/schema\\\/person\\\/dcbab2ddc35f4c71f45c7e13f36367bf\",\"name\":\"hoanghiepktv\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"en-US\",\"@id\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"url\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"contentUrl\":\"https:\\\/\\\/secure.gravatar.com\\\/avatar\\\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g\",\"caption\":\"hoanghiepktv\"},\"url\":\"https:\\\/\\\/www.engisv.info\\\/?author=2\"}]}<\/script>\n<!-- \/ Yoast SEO plugin. -->","yoast_head_json":{"title":"Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV","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:\/\/www.engisv.info\/?p=1106","og_locale":"en_US","og_type":"article","og_title":"Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV","og_description":"Excel l\u00e0 m\u1ed9t trong nh\u1eefng \u1ee9ng d\u1ee5ng v\u0103n ph\u00f2ng quan tr\u1ecdng c\u1ee7a b\u1ed9 Microsoft Office, l\u00e0 \u1ee9ng d\u1ee5ng d\u00f9ng \u0111\u1ec3 thi\u1ebft l\u1eadp c\u00e1c b\u1ea3ng t\u00ednh, th\u00f4ng k\u00ea, ph\u00e2n t\u00edch d\u1eef li\u1ec7u, l\u1eadp k\u1ebf ho\u1ea1ch&#8230; Trong lo\u1ea1t b\u00e0i n\u00e0y, t\u00f4i s\u1ebd gi\u1edbi thi\u1ec7u nh\u1eefng \u0111i\u1ec1u c\u01a1 b\u1ea3n \u0111\u1ec3 nh\u1eefng b\u1ea1n m\u1edbi b\u1eaft \u0111\u1ea7u ho\u1eb7c nh\u1eefng b\u1ea1n l\u00e2u ng\u00e0y kh\u00f4ng s\u1ee7 d\u1ee5ng c\u00f3 th\u1ec3 c\u1eadp nh\u1eadt l\u1ea1i ki\u1ebfn th\u1ee9c, hy v\u1ecdng v\u1edbi lo\u1ea1t b\u00e0i n\u00e0y s\u1ebd gi\u00fap ng\u01b0\u1eddi m\u1edbi ti\u1ebfp x\u00fac kh\u00f4ng c\u00f2n th\u1ea5y Excel l\u00e0 c\u00e1i g\u00ec \u0111\u00f3 qu\u00e1 ph\u1ee9c t\u1ea1p.&hellip;","og_url":"https:\/\/www.engisv.info\/?p=1106","og_site_name":"EngISV","article_publisher":"https:\/\/www.facebook.com\/engisv","article_published_time":"2017-02-20T10:49:39+00:00","og_image":[{"width":300,"height":300,"url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","type":"image\/png"}],"author":"hoanghiepktv","twitter_card":"summary_large_image","twitter_misc":{"Written by":"hoanghiepktv","Est. reading time":"7 minutes"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/www.engisv.info\/?p=1106#article","isPartOf":{"@id":"https:\/\/www.engisv.info\/?p=1106"},"author":{"name":"hoanghiepktv","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf"},"headline":"Microsoft Excel &#8211; C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n","datePublished":"2017-02-20T10:49:39+00:00","mainEntityOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1106"},"wordCount":1372,"publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1106#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","keywords":["Excel"],"articleSection":["Th\u1ee7 thu\u1eadt","V\u0103n ph\u00f2ng"],"inLanguage":"en-US"},{"@type":"WebPage","@id":"https:\/\/www.engisv.info\/?p=1106","url":"https:\/\/www.engisv.info\/?p=1106","name":"Microsoft Excel - C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n - EngISV","isPartOf":{"@id":"https:\/\/www.engisv.info\/#website"},"primaryImageOfPage":{"@id":"https:\/\/www.engisv.info\/?p=1106#primaryimage"},"image":{"@id":"https:\/\/www.engisv.info\/?p=1106#primaryimage"},"thumbnailUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","datePublished":"2017-02-20T10:49:39+00:00","breadcrumb":{"@id":"https:\/\/www.engisv.info\/?p=1106#breadcrumb"},"inLanguage":"en-US","potentialAction":[{"@type":"ReadAction","target":["https:\/\/www.engisv.info\/?p=1106"]}]},{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/?p=1106#primaryimage","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2017\/02\/excel-cover-1.png","width":300,"height":300},{"@type":"BreadcrumbList","@id":"https:\/\/www.engisv.info\/?p=1106#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"Home","item":"https:\/\/www.engisv.info\/"},{"@type":"ListItem","position":2,"name":"Microsoft Excel &#8211; C\u00e1c kh\u00e1i ni\u1ec7m c\u01a1 b\u1ea3n"}]},{"@type":"WebSite","@id":"https:\/\/www.engisv.info\/#website","url":"https:\/\/www.engisv.info\/","name":"EngISV","description":"H\u00e3y b\u1eaft \u0111\u1ea7u t\u1eeb nh\u1eefng vi\u1ec7c nh\u1ecf!","publisher":{"@id":"https:\/\/www.engisv.info\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/www.engisv.info\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"en-US"},{"@type":"Organization","@id":"https:\/\/www.engisv.info\/#organization","name":"EngISV","url":"https:\/\/www.engisv.info\/","logo":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/","url":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","contentUrl":"https:\/\/www.engisv.info\/wp-content\/uploads\/2018\/06\/logo2-3-1-1.png","width":200,"height":76,"caption":"EngISV"},"image":{"@id":"https:\/\/www.engisv.info\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/engisv"]},{"@type":"Person","@id":"https:\/\/www.engisv.info\/#\/schema\/person\/dcbab2ddc35f4c71f45c7e13f36367bf","name":"hoanghiepktv","image":{"@type":"ImageObject","inLanguage":"en-US","@id":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","url":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/645a174195a58b43e64a66af9255c62adc3c73faba32dda89a76c2778e9b3172?s=96&d=mm&r=g","caption":"hoanghiepktv"},"url":"https:\/\/www.engisv.info\/?author=2"}]}},"_links":{"self":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1106","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=1106"}],"version-history":[{"count":0,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/posts\/1106\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=\/wp\/v2\/media\/1108"}],"wp:attachment":[{"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=1106"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=1106"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.engisv.info\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=1106"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}