{"id":1431,"date":"2023-09-18T01:05:49","date_gmt":"2023-09-17T18:05:49","guid":{"rendered":"https:\/\/trannghiait.com\/?p=1431"},"modified":"2023-09-18T01:05:50","modified_gmt":"2023-09-17T18:05:50","slug":"loi-ich-ke-duong-cheo-trong-excel","status":"publish","type":"post","link":"https:\/\/trannghiait.com\/index.php\/2023\/09\/18\/loi-ich-ke-duong-cheo-trong-excel\/","title":{"rendered":"L\u1ee3i \u00edch k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel"},"content":{"rendered":"\n<p>K\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u. Khi s\u1eed d\u1ee5ng k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o, b\u1ea1n c\u00f3 th\u1ec3 t\u00ednh t\u1ed5ng, trung b\u00ecnh, min, max v\u00e0 c\u00e1c h\u00e0m kh\u00e1c cho m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u ch\u1ec9 v\u1edbi m\u1ed9t v\u00e0i c\u00fa nh\u1ea5p chu\u1ed9t.<\/p>\n\n\n\n<p>\u0110\u1ec3 s\u1eed d\u1ee5ng k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel, b\u1ea1n c\u00f3 th\u1ec3 l\u00e0m theo c\u00e1c b\u01b0\u1edbc sau:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n. V\u00ed d\u1ee5: A1:D10.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;AutoSum&#8221; tr\u00ean thanh c\u00f4ng c\u1ee5. N\u1ebfu b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n m\u1ed9t h\u00e0m kh\u00e1c, h\u00e3y ch\u1ecdn n\u00fat &#8220;More Functions&#8221; v\u00e0 ch\u1ecdn h\u00e0m m\u00e0 b\u1ea1n mu\u1ed1n s\u1eed d\u1ee5ng.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n. Excel s\u1ebd t\u1ef1 \u0111\u1ed9ng ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u \u0111\u1ec3 t\u00ednh to\u00e1n.<\/li>\n\n\n\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh t\u00ednh to\u00e1n. Gi\u00e1 tr\u1ecb t\u00ednh to\u00e1n s\u1ebd hi\u1ec3n th\u1ecb trong \u00f4 \u0111\u00f3.<\/li>\n<\/ol>\n\n\n\n<p>D\u01b0\u1edbi \u0111\u00e2y l\u00e0 m\u1ed9t s\u1ed1 v\u00ed d\u1ee5 v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel:<\/p>\n\n\n\n<ol class=\"wp-block-list\">\n<li>T\u00ednh t\u1ed5ng c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;AutoSum&#8221; tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a ph\u1ea1m vi d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>T\u00ednh trung b\u00ecnh c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;AutoSum&#8221; tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;Average&#8221;.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a ph\u1ea1m vi d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n\n\n\n<ol class=\"wp-block-list\">\n<li>T\u00ecm gi\u00e1 tr\u1ecb l\u1edbn nh\u1ea5t ho\u1eb7c nh\u1ecf nh\u1ea5t trong m\u1ed9t ph\u1ea1m vi d\u1eef li\u1ec7u:<\/li>\n<\/ol>\n\n\n\n<ul class=\"wp-block-list\">\n<li>Ch\u1ecdn ph\u1ea1m vi d\u1eef li\u1ec7u m\u00e0 b\u1ea1n mu\u1ed1n t\u00ednh to\u00e1n.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;AutoSum&#8221; tr\u00ean thanh c\u00f4ng c\u1ee5.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o n\u00fat &#8220;Max&#8221; ho\u1eb7c &#8220;Min&#8221;.<\/li>\n\n\n\n<li>Nh\u1ea5p chu\u1ed9t v\u00e0o \u00f4 n\u1eb1m b\u00ean ph\u1ea3i c\u1ee7a ph\u1ea1m vi d\u1eef li\u1ec7u.<\/li>\n\n\n\n<li>Nh\u1ea5n ph\u00edm Enter \u0111\u1ec3 ho\u00e0n th\u00e0nh t\u00ednh to\u00e1n.<\/li>\n<\/ul>\n\n\n\n<p>K\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n ti\u1ebft ki\u1ec7m th\u1eddi gian v\u00e0 n\u00e2ng cao hi\u1ec7u su\u1ea5t l\u00e0m vi\u1ec7c c\u1ee7a m\u00ecnh. Hy v\u1ecdng r\u1eb1ng c\u00e1c v\u00ed d\u1ee5 tr\u00ean s\u1ebd gi\u00fap b\u1ea1n hi\u1ec3u r\u00f5 h\u01a1n v\u1ec1 c\u00e1ch s\u1eed d\u1ee5ng k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel.<\/p>\n","protected":false},"excerpt":{"rendered":"<div class=\"mh-excerpt\"><p>K\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel l\u00e0 m\u1ed9t c\u00f4ng c\u1ee5 h\u1eefu \u00edch gi\u00fap b\u1ea1n nhanh ch\u00f3ng t\u00ednh to\u00e1n c\u00e1c gi\u00e1 tr\u1ecb trong m\u1ed9t ph\u1ea1m vi d\u1eef <a class=\"mh-excerpt-more\" href=\"https:\/\/trannghiait.com\/index.php\/2023\/09\/18\/loi-ich-ke-duong-cheo-trong-excel\/\" title=\"L\u1ee3i \u00edch k\u1ebb \u0111\u01b0\u1eddng ch\u00e9o trong Excel\">[&#8230;]<\/a><\/p>\n<\/div>","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[10],"tags":[],"class_list":["post-1431","post","type-post","status-publish","format-standard","hentry","category-kien-thuc-excel"],"_links":{"self":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1431","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/comments?post=1431"}],"version-history":[{"count":1,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1431\/revisions"}],"predecessor-version":[{"id":1432,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/posts\/1431\/revisions\/1432"}],"wp:attachment":[{"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/media?parent=1431"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/categories?post=1431"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/trannghiait.com\/index.php\/wp-json\/wp\/v2\/tags?post=1431"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}