{"id":13031,"date":"2022-10-03T02:26:35","date_gmt":"2022-10-02T19:26:35","guid":{"rendered":"https:\/\/teky.edu.vn\/blog\/?p=13031"},"modified":"2022-11-03T11:35:18","modified_gmt":"2022-11-03T04:35:18","slug":"tinh-phan-tram-trong-excel","status":"publish","type":"post","link":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/","title":{"rendered":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t"},"content":{"rendered":"\n\n<div class=\"kk-star-ratings kksr-auto kksr-align-left kksr-valign-top\"\n    data-payload='{&quot;align&quot;:&quot;left&quot;,&quot;id&quot;:&quot;13031&quot;,&quot;slug&quot;:&quot;default&quot;,&quot;valign&quot;:&quot;top&quot;,&quot;ignore&quot;:&quot;&quot;,&quot;reference&quot;:&quot;auto&quot;,&quot;class&quot;:&quot;&quot;,&quot;count&quot;:&quot;3&quot;,&quot;legendonly&quot;:&quot;&quot;,&quot;readonly&quot;:&quot;&quot;,&quot;score&quot;:&quot;5&quot;,&quot;starsonly&quot;:&quot;&quot;,&quot;best&quot;:&quot;5&quot;,&quot;gap&quot;:&quot;5&quot;,&quot;greet&quot;:&quot;Rate this post&quot;,&quot;legend&quot;:&quot;5\\\/5 - (3 b\u00ecnh ch\u1ecdn)&quot;,&quot;size&quot;:&quot;24&quot;,&quot;title&quot;:&quot;T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t&quot;,&quot;width&quot;:&quot;142.5&quot;,&quot;_legend&quot;:&quot;{score}\\\/{best} - ({count} {votes})&quot;,&quot;font_factor&quot;:&quot;1.25&quot;}'>\n            \n<div class=\"kksr-stars\">\n    \n<div class=\"kksr-stars-inactive\">\n            <div class=\"kksr-star\" data-star=\"1\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"2\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"3\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"4\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" data-star=\"5\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n    \n<div class=\"kksr-stars-active\" style=\"width: 142.5px;\">\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n            <div class=\"kksr-star\" style=\"padding-right: 5px\">\n            \n\n<div class=\"kksr-icon\" style=\"width: 24px; height: 24px;\"><\/div>\n        <\/div>\n    <\/div>\n<\/div>\n                \n\n<div class=\"kksr-legend\" style=\"font-size: 19.2px;\">\n            5\/5 - (3 b\u00ecnh ch\u1ecdn)    <\/div>\n    <\/div>\n<p><i><span style=\"font-weight: 400;\">Trong c\u00e1c file d\u1eef li\u1ec7u excel, b\u1ea1n r\u1ea5t d\u1ec5 g\u1eb7p ph\u1ea3i c\u00e1c s\u1ed1 li\u1ec7u l\u00e0 ph\u1ea7n tr\u0103m. Ch\u00fang chi\u1ebfm m\u1ed9t ph\u1ea7n l\u1edbn v\u00e0 \u0111\u00f2i h\u1ecfi c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y g\u1ecdn, d\u1ec5 hi\u1ec3u. V\u1eady <\/span><\/i><b><i>t\u00ednh ph\u1ea7n tr\u0103m trong excel <\/i><\/b><i><span style=\"font-weight: 400;\">nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? B\u1ea1n c\u1ea7n \u00e1p d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0o trong qu\u00e1 tr\u00ecnh th\u1ef1c hi\u1ec7n? Vi\u1ec7c n\u1eafm r\u00f5 nh\u1eefng th\u00f4ng tin n\u00e0y s\u1ebd gi\u00fap cho b\u1ea1n s\u1eed d\u1ee5ng excel th\u00e0nh th\u1ea1o h\u01a1n. Tham kh\u1ea3o ngay c\u00f9ng Teky nh\u00e9!<\/span><\/i><\/p>\n<div id=\"ez-toc-container\" class=\"ez-toc-v2_0_76 counter-hierarchy ez-toc-counter ez-toc-grey ez-toc-container-direction\">\n<div class=\"ez-toc-title-container\">\n<p class=\"ez-toc-title\" style=\"cursor:inherit\">N\u1ed9i dung <\/p>\n<span class=\"ez-toc-title-toggle\"><a href=\"#\" class=\"ez-toc-pull-right ez-toc-btn ez-toc-btn-xs ez-toc-btn-default ez-toc-toggle\" aria-label=\"Toggle Table of Content\"><span class=\"ez-toc-js-icon-con\"><span class=\"\"><span class=\"eztoc-hide\" style=\"display:none;\">Toggle<\/span><span class=\"ez-toc-icon-toggle-span\"><svg style=\"fill: #999;color:#999\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" class=\"list-377408\" width=\"20px\" height=\"20px\" viewBox=\"0 0 24 24\" fill=\"none\"><path d=\"M6 6H4v2h2V6zm14 0H8v2h12V6zM4 11h2v2H4v-2zm16 0H8v2h12v-2zM4 16h2v2H4v-2zm16 0H8v2h12v-2z\" fill=\"currentColor\"><\/path><\/svg><svg style=\"fill: #999;color:#999\" class=\"arrow-unsorted-368013\" xmlns=\"http:\/\/www.w3.org\/2000\/svg\" width=\"10px\" height=\"10px\" viewBox=\"0 0 24 24\" version=\"1.2\" baseProfile=\"tiny\"><path d=\"M18.2 9.3l-6.2-6.3-6.2 6.3c-.2.2-.3.4-.3.7s.1.5.3.7c.2.2.4.3.7.3h11c.3 0 .5-.1.7-.3.2-.2.3-.5.3-.7s-.1-.5-.3-.7zM5.8 14.7l6.2 6.3 6.2-6.3c.2-.2.3-.5.3-.7s-.1-.5-.3-.7c-.2-.2-.4-.3-.7-.3h-11c-.3 0-.5.1-.7.3-.2.2-.3.5-.3.7s.1.5.3.7z\"\/><\/svg><\/span><\/span><\/span><\/a><\/span><\/div>\n<nav><ul class='ez-toc-list ez-toc-list-level-1 ' ><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-1\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#Tinh_phan_tram_trong_excel_nen_luu_y_nhung_gi\" >T\u00ednh ph\u1ea7n tr\u0103m trong excel n\u00ean l\u01b0u \u00fd nh\u1eefng g\u00ec?<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-2\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#Cach_tinh_phan_tram_trong_file_excel_co_the_ban_doc_chua_biet\" >C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong file excel c\u00f3 th\u1ec3 b\u1ea1n \u0111\u1ecdc ch\u01b0a bi\u1ebft<\/a><ul class='ez-toc-list-level-3' ><li class='ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-3\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#Cach_tinh_ty_le_phan_tram_trong_excel_co_ban\" >C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel c\u01a1 b\u1ea3n\u00a0<\/a><\/li><li class='ez-toc-page-1 ez-toc-heading-level-3'><a class=\"ez-toc-link ez-toc-heading-4\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#Cach_tinh_ty_le_phan_tram_thay_doi_trong_excel\" >C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong excel\u00a0<\/a><\/li><\/ul><\/li><li class='ez-toc-page-1 ez-toc-heading-level-2'><a class=\"ez-toc-link ez-toc-heading-5\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#Tong_ket_chung_ve_tinh_phan_tram_doi_voi_file_excel\" >T\u1ed5ng k\u1ebft chung v\u1ec1 t\u00ednh ph\u1ea7n tr\u0103m \u0111\u1ed1i v\u1edbi file excel<\/a><\/li><\/ul><\/nav><\/div>\n<h2><span class=\"ez-toc-section\" id=\"Tinh_phan_tram_trong_excel_nen_luu_y_nhung_gi\"><\/span><b>T\u00ednh ph\u1ea7n tr\u0103m trong excel n\u00ean l\u01b0u \u00fd nh\u1eefng g\u00ec?<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><b>T\u00ednh ph\u1ea7n tr\u0103m trong excel<\/b><span style=\"font-weight: 400;\"> l\u00e0 m\u1ed9t trong nh\u1eefng k\u1ef9 n\u0103ng b\u1ea1n c\u1ea7n th\u00e0nh th\u1ea1o. B\u1edfi v\u00ec h\u1ea7u nh\u01b0 b\u1ea5t c\u1ee9 m\u1ed9t b\u1ea3ng d\u1eef li\u1ec7u excel n\u00e0o khi th\u1ef1c hi\u1ec7n \u0111\u1ec1u c\u00f3 xu\u1ea5t hi\u1ec7n c\u00e1c s\u1ed1 li\u1ec7u ph\u1ea7n tr\u0103m. \u0110\u00f3 c\u00f3 th\u1ec3 l\u00e0: Ph\u1ea7n tr\u0103m s\u1ea3n l\u01b0\u1ee3ng, ph\u1ea7n tr\u0103m ti\u00eau hao, ph\u1ea7n tr\u0103m doanh thu,&#8230;\u0110\u00f2i h\u1ecfi s\u1ed1 li\u1ec7u ch\u00ednh x\u00e1c tuy\u1ec7t \u0111\u1ed1i, h\u1ea1n ch\u1ebf sai s\u00f3t. \u0110\u1eb7c bi\u1ec7t l\u00e0 tr\u00ecnh b\u00e0y m\u1ed9t c\u00e1ch khoa h\u1ecdc v\u00e0 chuy\u00ean nghi\u1ec7p nh\u1ea5t c\u00f3 th\u1ec3.<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Khi t\u00ednh to\u00e1n v\u1ec1 ph\u1ea7n tr\u0103m trong file excel, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n theo \u0111\u00fang c\u00f4ng th\u1ee9c. \u0110\u1eb7c bi\u1ec7t, th\u01b0\u1eddng th\u00ec s\u1ed1 li\u1ec7u ph\u1ea7n tr\u0103m t\u00ednh ra hay \u1edf d\u1ea1ng s\u1ed1 th\u1eadp ph\u00e2n nh\u01b0 0,15634\u2026. Ch\u00ednh v\u00ec th\u1ebf n\u00ean b\u1ea1n v\u1eeba ph\u1ea3i \u0111\u1ea3m b\u1ea3o r\u00fat g\u1ecdn sau con s\u1ed1 kh\u00f4ng kho\u1ea3ng 2 \u0111\u1ebfn 4 ch\u1eef s\u1ed1. \u0110\u1ed3ng th\u1eddi \u0111\u00f3 l\u00e0 c\u1ea7n chuy\u1ec3n v\u1ec1 d\u1ea1ng xx %. C\u00f3 nh\u01b0 v\u1eady th\u00ec m\u1edbi \u0111\u1ea3m b\u1ea3o \u0111\u01b0\u1ee3c s\u1ed1 li\u1ec7u chuy\u00ean nghi\u1ec7p, t\u1ec9 m\u1ec9 v\u00e0 d\u1ec5 hi\u1ec3u cho ng\u01b0\u1eddi xem.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Mu\u1ed1n th\u1ebf, ng\u01b0\u1eddi th\u1ef1c hi\u1ec7n t\u00ednh to\u00e1n, c\u1eadp nh\u1eadt s\u1ed1 li\u1ec7u tr\u00ean excel c\u1ea7n n\u1eafm r\u00f5 c\u00e1ch <\/span>t\u00ednh trong file excel. <span style=\"font-weight: 400;\">Nh\u1eb1m x\u1eed l\u00fd hi\u1ec7u qu\u1ea3 s\u1ed1 li\u1ec7u, tr\u00ecnh b\u00e0y d\u1ec5 hi\u1ec3u \u0111\u1eb9p m\u1eaft. Ng\u01b0\u1eddi xem nh\u00ecn v\u00e0o c\u0169ng c\u00f3 thi\u1ec7n c\u1ea3m v\u00e0 d\u1ec5 d\u00e0ng \u0111\u00e1nh gi\u00e1, so s\u00e1nh h\u01a1n. V\u1eady c\u1ee5 th\u1ec3 t\u00ednh % \u0111\u1ed1i v\u1edbi s\u1ed1 li\u1ec7u trong file excel nh\u01b0 th\u1ebf n\u00e0o? C\u00f9ng xem th\u00eam chi ti\u1ebft \u1edf ph\u1ea7n ti\u1ebfp theo v\u1edbi Teky!<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/cach-xoa-so-trang-trong-excel\/\">C\u00e1ch x\u00f3a s\u1ed1 trang trong excel sao cho \u0111\u01a1n gi\u1ea3n nh\u1ea5t<\/a><\/p>\n<figure id=\"attachment_13032\" aria-describedby=\"caption-attachment-13032\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13032\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\" alt=\"tinh-phan-tram-trong-excel-1\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13032\" class=\"wp-caption-text\">T\u00ednh ph\u1ea7n tr\u0103m gi\u00fap cho vi\u1ec7c th\u1ef1c hi\u1ec7n file excel d\u1ec5 d\u00e0ng h\u01a1n<\/figcaption><\/figure>\n<h2><span class=\"ez-toc-section\" id=\"Cach_tinh_phan_tram_trong_file_excel_co_the_ban_doc_chua_biet\"><\/span><b>C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong file excel c\u00f3 th\u1ec3 b\u1ea1n \u0111\u1ecdc ch\u01b0a bi\u1ebft<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">V\u1ec1 c\u01a1 b\u1ea3n, c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m th\u00ec h\u1ea7u nh\u01b0 ai c\u0169ng bi\u1ebft. C\u1ee5 th\u1ec3 l\u00e0: A\/B *100%. Song khi \u00e1p d\u1ee5ng n\u00f3 trong excel th\u00ec b\u1ea1n c\u1ea7n c\u00f3 m\u1ed9t s\u1ed1 c\u00f4ng \u0111o\u1ea1n nh\u1eb1m gi\u00fap \u0111\u00e1p \u00e1n \u0111\u01b0a ra ch\u00ednh x\u00e1c, r\u00f5 r\u00e0ng h\u01a1n.\u00a0<\/span><\/p>\n<p><iframe loading=\"lazy\" title=\"Excel cho ng\u01b0\u1eddi \u0111i l\u00e0m | #01 C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m trong Excel\" width=\"500\" height=\"281\" src=\"https:\/\/www.youtube.com\/embed\/K-u3xQzc44I?feature=oembed\" frameborder=\"0\" allow=\"accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share\" referrerpolicy=\"strict-origin-when-cross-origin\" allowfullscreen><\/iframe><\/p>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_ty_le_phan_tram_trong_excel_co_ban\"><\/span><b><i>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel c\u01a1 b\u1ea3n\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">\u0110\u1ed1i v\u1edbi c\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m trong excel, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 b\u01b0\u1edbc c\u1ee5 th\u1ec3. V\u1edbi v\u00ed d\u1ee5 b\u00ean d\u01b0\u1edbi, b\u1ea1n c\u1ea7n t\u00ecm % l\u01b0\u1ee3ng h\u00e0ng b\u00e1n \u0111\u01b0\u1ee3c so v\u1edbi t\u1ed5ng s\u1ed1 h\u00e0ng h\u00f3a. L\u00fac n\u00e0y c\u00f4ng th\u1ee9c s\u1ebd l\u00e0 C3\/B3, r\u1ea5t \u0111\u01a1n gi\u1ea3n \u0111\u00fang kh\u00f4ng n\u00e0o?\u00a0<\/span><\/p>\n<figure id=\"attachment_13033\" aria-describedby=\"caption-attachment-13033\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13033\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-2.jpg\" alt=\"tinh-phan-tram-trong-excel-2\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-2.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-2-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-2-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13033\" class=\"wp-caption-text\">T\u00ednh ph\u1ea7n tr\u0103m l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e3 b\u00e1n \u0111\u01b0\u1ee3c<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Sau khi t\u00ednh xong gi\u00e1 tr\u1ecb c\u1ee7a \u00f4 D1, b\u1ea1n s\u1ebd ti\u1ebfn h\u00e0nh di chu\u1ed9t \u0111\u1ebfn v\u1ecb tr\u00ed g\u00f3c ph\u1ea3i cu\u1ed1i c\u1ee7a \u00f4. Sau \u0111\u00f3 k\u00e9o chu\u1ed9t \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n tr\u00ean cho nh\u1eefng \u00f4 b\u00ean d\u01b0\u1edbi. C\u1ee5 th\u1ec3 \u1edf \u0111\u00e2y ch\u00ednh l\u00e0 \u00f4 D4 cho \u0111\u1ebfn \u00f4 D8. V\u00e0 nh\u01b0 b\u1ea1n \u0111\u00e3 th\u1ea5y th\u00ec \u0111\u00e1p \u00e1n \u1edf \u0111\u00e2y kh\u00e1 d\u00e0i d\u00f2ng v\u00e0 ch\u01b0a \u0111\u01b0\u1ee3c \u0111\u01b0a v\u1ec1 d\u1ea1ng xx %.\u00a0<\/span><\/p>\n<figure id=\"attachment_13035\" aria-describedby=\"caption-attachment-13035\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13035\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-3.jpg\" alt=\"tinh-phan-tram-trong-excel-3\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-3.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-3-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-3-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13035\" class=\"wp-caption-text\">T\u00ednh % l\u01b0\u1ee3ng h\u00e0ng \u0111\u00e3 b\u00e1n \u0111\u01b0\u1ee3c v\u1edbi c\u00f4ng th\u1ee9c t\u00ednh ph\u1ea7n tr\u0103m<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ti\u1ebfp theo, b\u1ea1n s\u1ebd b\u00f4i \u0111en h\u1ebft kho\u1ea3ng t\u1eeb D3 \u0111\u1ebfn D8. Sau \u0111\u00f3 click chu\u1ed9t ph\u1ea3i \u0111\u1ec3 xu\u1ea5t hi\u1ec7n giao di\u1ec7n h\u1ed9p tho\u1ea1i nh\u01b0 h\u00ecnh \u1ea3nh b\u00ean d\u01b0\u1edbi. B\u1ea1n s\u1ebd ch\u1ecdn Format Cells \u0111\u1ec3 ti\u1ebfp t\u1ee5c c\u00e1c c\u00f4ng \u0111o\u1ea1n sau.\u00a0<\/span><\/p>\n<figure id=\"attachment_13039\" aria-describedby=\"caption-attachment-13039\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13039\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-5-1.jpg\" alt=\"tinh-phan-tram-trong-excel-5\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-5-1.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-5-1-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-5-1-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13039\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng format cells \u0111\u1ec3 \u0111\u1ecbnh h\u00ecnh l\u1ea1i s\u1ed1 li\u1ec7u trong kho\u1ea3ng c\u1ea7n x\u00e9t<\/figcaption><\/figure>\n<figure id=\"attachment_13040\" aria-describedby=\"caption-attachment-13040\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"wp-image-13040 size-full\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-4.jpg\" alt=\"\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-4.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-4-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-4-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13040\" class=\"wp-caption-text\">Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean th\u00ec b\u1ea1n s\u1ebd c\u00f3 h\u00ecnh \u1ea3nh gi\u1ed1ng nh\u01b0 h\u00ecnh b\u00ean d\u01b0\u1edbi<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">V\u1edbi giao di\u1ec7n h\u1ed9p tho\u1ea1i nh\u01b0 h\u00ecnh d\u01b0\u1edbi, b\u1ea1n s\u1ebd click ch\u1ecdn Percentage. Sau \u0111\u00f3 \u0111i\u1ec1u ch\u1ec9nh decimal places v\u1ec1 d\u1ea1ng b\u1ea1n mu\u1ed1n. \u1ede \u0111\u00e2y con s\u1ed1 2 c\u00f3 ngh\u0129a l\u00e0 l\u1ea5y 2 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y. Cu\u1ed1i c\u00f9ng, b\u1ea1n s\u1ebd click ch\u1ecdn OK \u0111\u1ec3 ho\u00e0n th\u00e0nh m\u1ecdi th\u1ee9.<\/span><\/p>\n<figure id=\"attachment_13041\" aria-describedby=\"caption-attachment-13041\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13041\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-6.jpg\" alt=\"tinh-phan-tram-trong-excel-6\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-6.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-6-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-6-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13041\" class=\"wp-caption-text\">S\u1eed d\u1ee5ng percentage gi\u00fap h\u00ecnh d\u1ea1ng s\u1ed1 li\u1ec7u ph\u1ea7n tr\u0103m chu\u1ea9n x\u00e1c h\u01a1n<\/figcaption><\/figure>\n<figure id=\"attachment_13042\" aria-describedby=\"caption-attachment-13042\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13042\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7.jpg\" alt=\"tinh-phan-tram-trong-excel-7\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13042\" class=\"wp-caption-text\">Sau khi th\u1ef1c hi\u1ec7n c\u00e1c b\u01b0\u1edbc tr\u00ean th\u00ec b\u1ea1n s\u1ebd c\u00f3 h\u00ecnh \u1ea3nh gi\u1ed1ng nh\u01b0 h\u00ecnh<\/figcaption><\/figure>\n<ul>\n<li>\n<h3><span class=\"ez-toc-section\" id=\"Cach_tinh_ty_le_phan_tram_thay_doi_trong_excel\"><\/span><b><i>C\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong excel\u00a0<\/i><\/b><span class=\"ez-toc-section-end\"><\/span><\/h3>\n<\/li>\n<\/ul>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 qu\u00e1 tr\u00ecnh t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m hi\u1ec7n nay d\u00e0nh cho b\u1ea1n. M\u1ecdi th\u1ee9 \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n kh\u00e1 nhanh ch\u00f3ng v\u00e0 d\u1ec5 d\u00e0ng. Ch\u1ec9 t\u1ed1n \u00edt ph\u00fat l\u00e0 b\u1ea1n \u0111\u00e3 c\u00f3 th\u1ec3 t\u00ednh to\u00e1n v\u00e0 ghi ch\u00fa xong s\u1ed1 ph\u1ea7n tr\u0103m c\u1ee5 th\u1ec3 v\u1edbi d\u1ea1ng 2 ch\u1eef s\u1ed1 sau d\u1ea5u ph\u1ea9y. \u0110i k\u00e8m \u0111\u00f3 l\u00e0 kh\u00f4ng c\u00f2n d\u00e0i d\u00f2ng n\u1eefa. Th\u1eadt l\u00e0 ti\u1ec7n l\u1ee3i, \u0111\u00fang kh\u00f4ng n\u00e0o?\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">\u0110\u1ec3 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong excel, b\u1ea1n c\u1ea7n th\u1ef1c hi\u1ec7n m\u1ed9t s\u1ed1 b\u01b0\u1edbc nh\u1ea5t \u0111\u1ecbnh. V\u00ed d\u1ee5 nh\u01b0 m\u1ed9t b\u1ea3ng c\u00f4ng ty c\u00f3 doanh thu cho th\u00e1ng 1, th\u00e1ng 2 nh\u01b0 h\u00ecnh d\u01b0\u1edbi cho c\u00e1c s\u1ea3n ph\u1ea9m. Vi\u1ec7c c\u1ee7a b\u1ea1n l\u00e0 t\u00ednh s\u1ef1 thay \u0111\u1ed5i ph\u1ea7n tr\u0103m gi\u1eefa 2 th\u00e1ng li\u00ean t\u1ee5c. C\u1ee5 th\u1ec3, b\u1ea1n c\u00f3 th\u1ec3 d\u00f9ng c\u00f4ng th\u1ee9c (C3-B3)\/B3.\u00a0\u00a0<\/span><\/p>\n<figure id=\"attachment_13043\" aria-describedby=\"caption-attachment-13043\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13043\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-1.jpg\" alt=\"tinh-phan-tram-trong-excel-7\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-1.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-1-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-7-1-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13043\" class=\"wp-caption-text\">T\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i trong excel<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Cu\u1ed1i c\u00f9ng, b\u1ea1n k\u00e9o chu\u1ed9t \u0111\u1ec3 \u00e1p d\u1ee5ng c\u00f4ng th\u1ee9c tr\u00ean cho c\u00e1c \u00f4 t\u00ednh b\u00ean d\u01b0\u1edbi. Nh\u01b0 v\u1eady, ta s\u1ebd c\u00f3 h\u00ecnh d\u01b0\u1edbi \u0111\u00e2y l\u00e0 \u0111\u00e1p \u00e1n % doanh thu thay \u0111\u1ed5i c\u1ee7a c\u00e1c s\u1ea3n ph\u1ea9m qua th\u00e1ng 1 v\u00e0 2.\u00a0<\/span><\/p>\n<figure id=\"attachment_13044\" aria-describedby=\"caption-attachment-13044\" style=\"width: 1000px\" class=\"wp-caption alignnone\"><img loading=\"lazy\" decoding=\"async\" class=\"size-full wp-image-13044\" src=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-8.jpg\" alt=\"tinh-phan-tram-trong-excel-8\" width=\"1000\" height=\"550\" srcset=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-8.jpg 1000w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-8-400x220.jpg 400w, https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-8-768x422.jpg 768w\" sizes=\"auto, (max-width: 1000px) 100vw, 1000px\" \/><figcaption id=\"caption-attachment-13044\" class=\"wp-caption-text\">\u0110\u00e1p \u00e1n doanh thu thay \u0111\u1ed5i cho c\u00e1c lo\u1ea1i s\u1ea3n ph\u1ea9m kh\u00e1c nhau<\/figcaption><\/figure>\n<p><span style=\"font-weight: 400;\">Ngo\u00e0i c\u00e1ch t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m thay \u0111\u1ed5i tr\u00ean th\u00ec b\u1ea1n c\u00f2n c\u00f3 th\u1ec3 h\u1ecdc h\u1ecfi th\u00eam c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m chi\u1ebft kh\u1ea5u trong excel. Hay l\u00e0 c\u00e1ch t\u00ednh trung b\u00ecnh ph\u1ea7n tr\u0103m trong excel. V\u1ec1 c\u01a1 b\u1ea3n c\u00f4ng th\u1ee9c t\u00ednh to\u00e1n c\u0169ng kh\u00e1 t\u01b0\u01a1ng t\u1ef1, \u0111\u01a1n gi\u1ea3n cho b\u1ea1n t\u1ef1 t\u00ednh t\u1ef7 l\u1ec7 ph\u1ea7n tr\u0103m.\u00a0<\/span><\/p>\n<p><span style=\"font-weight: 400;\">Tham kh\u1ea3o th\u00eam: <\/span><a href=\"https:\/\/teky.edu.vn\/blog\/danh-so-trang-trong-excel\/\">\u0110\u00e1nh s\u1ed1 trang trong excel v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n nhanh ch\u00f3ng d\u1ec5 hi\u1ec3u<\/a><\/p>\n<h2><span class=\"ez-toc-section\" id=\"Tong_ket_chung_ve_tinh_phan_tram_doi_voi_file_excel\"><\/span><b>T\u1ed5ng k\u1ebft chung v\u1ec1 t\u00ednh ph\u1ea7n tr\u0103m \u0111\u1ed1i v\u1edbi file excel<\/b><span class=\"ez-toc-section-end\"><\/span><\/h2>\n<p><span style=\"font-weight: 400;\">Tr\u00ean \u0111\u00e2y ch\u00ednh l\u00e0 nh\u1eefng th\u00f4ng tin v\u1ec1 <\/span><b>t\u00ednh ph\u1ea7n tr\u0103m trong excel <\/b><span style=\"font-weight: 400;\">v\u00e0 c\u00e1ch th\u1ef1c hi\u1ec7n hi\u1ec7u qu\u1ea3. Vi\u1ec7c \u0111\u1ea3m b\u1ea3o th\u1ef1c hi\u1ec7n t\u00ednh ph\u1ea7n tr\u0103m m\u1ed9t c\u00e1ch chu\u1ea9n m\u1ef1c s\u1ebd gi\u00fap cho \u0111\u00e1p \u00e1n tr\u00f4ng \u0111\u1eb9p m\u1eaft, t\u1eed t\u1ebf v\u00e0 chuy\u00ean nghi\u1ec7p h\u01a1n. Mong r\u1eb1ng nh\u1eefng th\u00f4ng tin n\u00e0y th\u1ef1c s\u1ef1 mang l\u1ea1i cho b\u1ea1n nh\u1eefng \u0111i\u1ec1u b\u1ed5 \u00edch. C\u1ea3m \u01a1n b\u1ea1n v\u00ec \u0111\u00e3 \u0111\u00f3n \u0111\u1ecdc nh\u1eefng th\u00f4ng tin tr\u00ean c\u1ee7a Teky.<\/span><\/p>\n<p><strong>Xem th\u00eam :\u00a0<\/strong><\/p>\n<ul>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/cach-tinh-phan-tram\/\" target=\"_blank\" rel=\"noopener\">C\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m c\u1ef1c k\u00ec d\u1ec5 v\u00e0 nhanh ch\u00f3ng<\/a><\/li>\n<li><a class=\"LinkSuggestion__Link-sc-1gewdgc-4 evyocv\" href=\"https:\/\/teky.edu.vn\/blog\/game-va-ty-le-that-nghiep\/\" target=\"_blank\" rel=\"noopener\">S\u1ef1 Li\u00ean Quan Gi\u1eefa Ch\u01a1i Game V\u00e0 T\u1ef7 L\u1ec7 Th\u1ea5t Nghi\u1ec7p<\/a><\/li>\n<\/ul>\n","protected":false},"excerpt":{"rendered":"<p>Trong c\u00e1c file d\u1eef li\u1ec7u excel, b\u1ea1n r\u1ea5t d\u1ec5 g\u1eb7p ph\u1ea3i c\u00e1c s\u1ed1 li\u1ec7u l\u00e0 ph\u1ea7n tr\u0103m. Ch\u00fang chi\u1ebfm m\u1ed9t ph\u1ea7n l\u1edbn v\u00e0 \u0111\u00f2i h\u1ecfi c\u1ea7n ph\u1ea3i \u0111\u01b0\u1ee3c tr\u00ecnh b\u00e0y g\u1ecdn, d\u1ec5 hi\u1ec3u. V\u1eady t\u00ednh ph\u1ea7n tr\u0103m trong excel nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? B\u1ea1n c\u1ea7n \u00e1p d\u1ee5ng nh\u1eefng c\u00f4ng th\u1ee9c n\u00e0o trong qu\u00e1 tr\u00ecnh &hellip;<\/p>\n","protected":false},"author":3,"featured_media":13032,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[173],"tags":[],"class_list":["post-13031","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-excel"],"yoast_head":"<!-- This site is optimized with the Yoast SEO Premium plugin v20.9 (Yoast SEO v26.0) - https:\/\/yoast.com\/wordpress\/plugins\/seo\/ -->\n<title>T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t<\/title>\n<meta name=\"description\" content=\"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky\" \/>\n<meta name=\"robots\" content=\"index, follow, max-snippet:-1, max-image-preview:large, max-video-preview:-1\" \/>\n<link rel=\"canonical\" href=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\" \/>\n<meta property=\"og:locale\" content=\"vi_VN\" \/>\n<meta property=\"og:type\" content=\"article\" \/>\n<meta property=\"og:title\" content=\"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t\" \/>\n<meta property=\"og:description\" content=\"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky\" \/>\n<meta property=\"og:url\" content=\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\" \/>\n<meta property=\"og:site_name\" content=\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\" \/>\n<meta property=\"article:publisher\" content=\"https:\/\/www.facebook.com\/TekyAcademy\" \/>\n<meta property=\"article:published_time\" content=\"2022-10-02T19:26:35+00:00\" \/>\n<meta property=\"article:modified_time\" content=\"2022-11-03T04:35:18+00:00\" \/>\n<meta property=\"og:image\" content=\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\" \/>\n\t<meta property=\"og:image:width\" content=\"1000\" \/>\n\t<meta property=\"og:image:height\" content=\"550\" \/>\n\t<meta property=\"og:image:type\" content=\"image\/jpeg\" \/>\n<meta name=\"author\" content=\"Huy \u0110\u00e0m\" \/>\n<meta name=\"twitter:card\" content=\"summary_large_image\" \/>\n<meta name=\"twitter:creator\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:site\" content=\"@SteamTeky\" \/>\n<meta name=\"twitter:label1\" content=\"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi\" \/>\n\t<meta name=\"twitter:data1\" content=\"Huy \u0110\u00e0m\" \/>\n\t<meta name=\"twitter:label2\" content=\"\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc\" \/>\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\":\"Article\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#article\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\"},\"author\":{\"name\":\"Huy \u0110\u00e0m\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\"},\"headline\":\"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t\",\"datePublished\":\"2022-10-02T19:26:35+00:00\",\"dateModified\":\"2022-11-03T04:35:18+00:00\",\"mainEntityOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\"},\"wordCount\":1761,\"commentCount\":0,\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\",\"articleSection\":[\"T\u1ef1 h\u1ecdc Excel\"],\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"CommentAction\",\"name\":\"Comment\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#respond\"]}]},{\"@type\":\"WebPage\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\",\"name\":\"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t\",\"isPartOf\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\"},\"primaryImageOfPage\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage\"},\"thumbnailUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\",\"datePublished\":\"2022-10-02T19:26:35+00:00\",\"dateModified\":\"2022-11-03T04:35:18+00:00\",\"description\":\"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky\",\"breadcrumb\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#breadcrumb\"},\"inLanguage\":\"vi\",\"potentialAction\":[{\"@type\":\"ReadAction\",\"target\":[\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/\"]}]},{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg\",\"width\":1000,\"height\":550,\"caption\":\"T\u00ednh ph\u1ea7n tr\u0103m trong file excel \u0111\u01b0\u1ee3c quan t\u00e2m r\u1ed9ng r\u00e3i\"},{\"@type\":\"BreadcrumbList\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#breadcrumb\",\"itemListElement\":[{\"@type\":\"ListItem\",\"position\":1,\"name\":\"T\u1ef1 h\u1ecdc Excel\",\"item\":\"https:\/\/teky.edu.vn\/blog\/excel\/\"},{\"@type\":\"ListItem\",\"position\":2,\"name\":\"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t\"}]},{\"@type\":\"WebSite\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#website\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"description\":\"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh\",\"publisher\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\"},\"potentialAction\":[{\"@type\":\"SearchAction\",\"target\":{\"@type\":\"EntryPoint\",\"urlTemplate\":\"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}\"},\"query-input\":{\"@type\":\"PropertyValueSpecification\",\"valueRequired\":true,\"valueName\":\"search_term_string\"}}],\"inLanguage\":\"vi\"},{\"@type\":\"Organization\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#organization\",\"name\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\",\"url\":\"https:\/\/teky.edu.vn\/blog\/\",\"logo\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\",\"url\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"contentUrl\":\"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png\",\"width\":495,\"height\":234,\"caption\":\"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7\"},\"image\":{\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/\"},\"sameAs\":[\"https:\/\/www.facebook.com\/TekyAcademy\",\"https:\/\/x.com\/SteamTeky\"]},{\"@type\":\"Person\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c\",\"name\":\"Huy \u0110\u00e0m\",\"image\":{\"@type\":\"ImageObject\",\"inLanguage\":\"vi\",\"@id\":\"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/\",\"url\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"contentUrl\":\"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g\",\"caption\":\"Huy \u0110\u00e0m\"},\"url\":\"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/\"}]}<\/script>\n<!-- \/ Yoast SEO Premium plugin. -->","yoast_head_json":{"title":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t","description":"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky","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:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/","og_locale":"vi_VN","og_type":"article","og_title":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t","og_description":"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky","og_url":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/","og_site_name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","article_publisher":"https:\/\/www.facebook.com\/TekyAcademy","article_published_time":"2022-10-02T19:26:35+00:00","article_modified_time":"2022-11-03T04:35:18+00:00","og_image":[{"width":1000,"height":550,"url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg","type":"image\/jpeg"}],"author":"Huy \u0110\u00e0m","twitter_card":"summary_large_image","twitter_creator":"@SteamTeky","twitter_site":"@SteamTeky","twitter_misc":{"\u0110\u01b0\u1ee3c vi\u1ebft b\u1edfi":"Huy \u0110\u00e0m","\u01af\u1edbc t\u00ednh th\u1eddi gian \u0111\u1ecdc":"7 ph\u00fat"},"schema":{"@context":"https:\/\/schema.org","@graph":[{"@type":"Article","@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#article","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/"},"author":{"name":"Huy \u0110\u00e0m","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c"},"headline":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t","datePublished":"2022-10-02T19:26:35+00:00","dateModified":"2022-11-03T04:35:18+00:00","mainEntityOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/"},"wordCount":1761,"commentCount":0,"publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg","articleSection":["T\u1ef1 h\u1ecdc Excel"],"inLanguage":"vi","potentialAction":[{"@type":"CommentAction","name":"Comment","target":["https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#respond"]}]},{"@type":"WebPage","@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/","url":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/","name":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t","isPartOf":{"@id":"https:\/\/teky.edu.vn\/blog\/#website"},"primaryImageOfPage":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage"},"thumbnailUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg","datePublished":"2022-10-02T19:26:35+00:00","dateModified":"2022-11-03T04:35:18+00:00","description":"T\u00ednh ph\u1ea7n tr\u0103m trong excel \u0111\u01b0\u1ee3c s\u1eed d\u1ee5ng ph\u1ed5 bi\u1ebfn hi\u1ec7n nay. V\u1eady c\u00e1ch t\u00ednh ph\u1ea7n tr\u0103m nh\u01b0 th\u1ebf n\u00e0o l\u00e0 \u0111\u00fang? H\u00e3y tham kh\u1ea3o th\u00eam v\u1edbi Teky","breadcrumb":{"@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#breadcrumb"},"inLanguage":"vi","potentialAction":[{"@type":"ReadAction","target":["https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/"]}]},{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#primaryimage","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2022\/04\/tinh-phan-tram-trong-excel-1.jpg","width":1000,"height":550,"caption":"T\u00ednh ph\u1ea7n tr\u0103m trong file excel \u0111\u01b0\u1ee3c quan t\u00e2m r\u1ed9ng r\u00e3i"},{"@type":"BreadcrumbList","@id":"https:\/\/teky.edu.vn\/blog\/tinh-phan-tram-trong-excel\/#breadcrumb","itemListElement":[{"@type":"ListItem","position":1,"name":"T\u1ef1 h\u1ecdc Excel","item":"https:\/\/teky.edu.vn\/blog\/excel\/"},{"@type":"ListItem","position":2,"name":"T\u00ednh ph\u1ea7n tr\u0103m trong excel v\u00e0 c\u00e1ch d\u1ec5 hi\u1ec3u hi\u1ec7u qu\u1ea3 nh\u1ea5t"}]},{"@type":"WebSite","@id":"https:\/\/teky.edu.vn\/blog\/#website","url":"https:\/\/teky.edu.vn\/blog\/","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","description":"Tr\u1ebb em c\u1ea7n h\u1ecdc l\u1eadp tr\u00ecnh","publisher":{"@id":"https:\/\/teky.edu.vn\/blog\/#organization"},"potentialAction":[{"@type":"SearchAction","target":{"@type":"EntryPoint","urlTemplate":"https:\/\/teky.edu.vn\/blog\/?s={search_term_string}"},"query-input":{"@type":"PropertyValueSpecification","valueRequired":true,"valueName":"search_term_string"}}],"inLanguage":"vi"},{"@type":"Organization","@id":"https:\/\/teky.edu.vn\/blog\/#organization","name":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7","url":"https:\/\/teky.edu.vn\/blog\/","logo":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/","url":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","contentUrl":"https:\/\/teky.edu.vn\/blog\/wp-content\/uploads\/2021\/02\/logo-teky.png","width":495,"height":234,"caption":"TEKY - H\u1ecdc vi\u1ec7n s\u00e1ng t\u1ea1o c\u00f4ng ngh\u1ec7"},"image":{"@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/logo\/image\/"},"sameAs":["https:\/\/www.facebook.com\/TekyAcademy","https:\/\/x.com\/SteamTeky"]},{"@type":"Person","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/0ef776d2d661e910c4126b0c2cd7349c","name":"Huy \u0110\u00e0m","image":{"@type":"ImageObject","inLanguage":"vi","@id":"https:\/\/teky.edu.vn\/blog\/#\/schema\/person\/image\/","url":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","contentUrl":"https:\/\/secure.gravatar.com\/avatar\/f37cfd1404bcaff6806abad0bc6693df65654cabda35ec1fc2eb8008d37d5dad?s=96&d=mm&r=g","caption":"Huy \u0110\u00e0m"},"url":"https:\/\/teky.edu.vn\/blog\/author\/dunglv\/"}]}},"_links":{"self":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13031","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/users\/3"}],"replies":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/comments?post=13031"}],"version-history":[{"count":0,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/posts\/13031\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media\/13032"}],"wp:attachment":[{"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/media?parent=13031"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/categories?post=13031"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/teky.edu.vn\/blog\/wp-json\/wp\/v2\/tags?post=13031"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}