{"id":755,"date":"2024-12-02T02:46:35","date_gmt":"2024-12-02T02:46:35","guid":{"rendered":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/microsoft-dang-mang-python-toi-excel-cac-ban-oi\/"},"modified":"2024-12-02T02:46:35","modified_gmt":"2024-12-02T02:46:35","slug":"microsoft-dang-mang-python-toi-excel-cac-ban-oi","status":"publish","type":"post","link":"https:\/\/blog.ezworkapp.com\/index.php\/2024\/12\/02\/microsoft-dang-mang-python-toi-excel-cac-ban-oi\/","title":{"rendered":"Microsoft \u0111ang mang Python t\u1edbi Excel, c\u00e1c b\u1ea1n \u01a1i!"},"content":{"rendered":"
\n

Hai th\u1ebf gi\u1edbi Excel v\u00e0 Python \u0111ang \u201c\u0111\u1ee5ng \u0111\u1ed9\u201d nhau, nh\u01b0ng kh\u00f4ng ph\u1ea3i \u0111\u1ec3 chi\u1ebfn \u0111\u1ea5u m\u00e0 l\u00e0 \u0111\u1ec3 c\u00f9ng nhau n\u00e2ng t\u1ea7m ph\u00e2n t\u00edch d\u1eef li\u1ec7u v\u00e0 tr\u1ef1c quan h\u00f3a, nh\u1edd v\u00e0o s\u1ef1 k\u1ebft h\u1ee3p t\u00e0i t\u00ecnh c\u1ee7a Microsoft.<\/p>\n

Microsoft \u0111ang \u201c\u0111\u01b0a\u201d ng\u00f4n ng\u1eef l\u1eadp tr\u00ecnh Python ph\u1ed5 bi\u1ebfn v\u00e0o Excel. Phi\u00ean b\u1ea3n xem tr\u01b0\u1edbc c\u00f4ng khai c\u1ee7a t\u00ednh n\u0103ng n\u00e0y \u0111\u00e3 c\u00f3 s\u1eb5n t\u1eeb h\u00f4m nay, gi\u00fap ng\u01b0\u1eddi d\u00f9ng Excel c\u00f3 th\u1ec3 \u201cv\u1ecdc\u201d v\u00e0 ph\u00e2n t\u00edch d\u1eef li\u1ec7u t\u1eeb Python.<\/p>\n

\u201cGi\u1edd \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ngh\u1ecbch d\u1eef li\u1ec7u trong Excel b\u1eb1ng c\u00e1c bi\u1ec3u \u0111\u1ed3 v\u00e0 th\u01b0 vi\u1ec7n Python, sau \u0111\u00f3 d\u00f9ng c\u00f4ng th\u1ee9c, bi\u1ec3u \u0111\u1ed3 v\u00e0 PivotTables c\u1ee7a Excel \u0111\u1ec3 tinh ch\u1ec9nh th\u00eam,\u201d \u00f4ng Stefan Kinnestrand, gi\u00e1m \u0111\u1ed1c \u0111i\u1ec1u h\u00e0nh c\u00f4ng vi\u1ec7c hi\u1ec7n \u0111\u1ea1i t\u1ea1i Microsoft, ph\u00f4 b\u00e0y. \u201cGi\u1edd \u0111\u00e2y, b\u1ea1n c\u00f3 th\u1ec3 ph\u00e2n t\u00edch d\u1eef li\u1ec7u cao c\u1ea5p ngay trong m\u00f4i tr\u01b0\u1eddng quen thu\u1ed9c c\u1ee7a Excel b\u1eb1ng c\u00e1ch truy c\u1eadp tr\u1ef1c ti\u1ebfp Python t\u1eeb thanh c\u00f4ng c\u1ee5 Excel.\u201d<\/p>\n

B\u1ea1n kh\u00f4ng c\u1ea7n c\u00e0i th\u00eam ph\u1ea7n m\u1ec1m hay thi\u1ebft l\u1eadp ti\u1ec7n \u00edch m\u1edf r\u1ed9ng n\u00e0o \u0111\u1ec3 truy c\u1eadp ch\u1ee9c n\u0103ng n\u00e0y, v\u00ec t\u00edch h\u1ee3p Python v\u00e0o Excel s\u1ebd l\u00e0 m\u1ed9t ph\u1ea7n c\u1ee7a c\u00e1c k\u1ebft n\u1ed1i t\u00edch h\u1ee3p v\u00e0 Power Query c\u1ee7a Excel. Microsoft c\u00f2n th\u00eam m\u1ed9t ch\u1ee9c n\u0103ng PY m\u1edbi cho ph\u00e9p hi\u1ec3n th\u1ecb d\u1eef li\u1ec7u Python ngay tr\u00ean l\u01b0\u1edbi c\u1ee7a b\u1ea3ng t\u00ednh Excel. Qua m\u1ed9t \u0111\u1ed1i t\u00e1c v\u1edbi Anaconda, m\u1ed9t kho l\u01b0u tr\u1eef Python doanh nghi\u1ec7p, c\u00e1c th\u01b0 vi\u1ec7n Python ph\u1ed5 bi\u1ebfn nh\u01b0 pandas, statsmodels v\u00e0 Matplotlib s\u1ebd c\u00f3 m\u1eb7t trong Excel.<\/p>\n

V\u00ed d\u1ee5 v\u1ec1 Python trong Excel. \u1ea2nh: Microsoft<\/figcaption><\/figure>\n

C\u00e1c ph\u00e9p t\u00ednh Python s\u1ebd \u0111\u01b0\u1ee3c th\u1ef1c hi\u1ec7n tr\u00ean Microsoft Cloud, v\u1edbi k\u1ebft qu\u1ea3 tr\u1ea3 v\u1ec1 m\u1ed9t b\u1ea3ng t\u00ednh Excel. Ng\u01b0\u1eddi d\u00f9ng Excel s\u1ebd c\u00f3 th\u1ec3 t\u1ea1o c\u00f4ng th\u1ee9c, PivotTables v\u00e0 bi\u1ec3u \u0111\u1ed3 d\u1ef1a tr\u00ean d\u1eef li\u1ec7u Python, c\u00f3 kh\u1ea3 n\u0103ng k\u1ebft h\u1ee3p c\u00e1c th\u01b0 vi\u1ec7n bi\u1ec3u \u0111\u1ed3 nh\u01b0 Matplotlib v\u00e0 Seaborn \u0111\u1ec3 t\u1ea1o ra c\u00e1c bi\u1ec3u \u0111\u1ed3 tr\u1ef1c quan nh\u01b0 heatmaps, violin plots v\u00e0 swarm plots. V\u00ec thi\u1ebft l\u1eadp \u0111\u1ec3 ch\u1ea1y tr\u00ean m\u00f4i tr\u01b0\u1eddng \u0111\u00e1m m\u00e2y c\u1ee7a Microsoft, v\u1eady n\u00ean b\u1ea1n s\u1ebd kh\u00f4ng c\u1ea7n ph\u1ea3i thi\u1ebft l\u1eadp g\u00ec hay c\u00e0i \u0111\u1eb7t b\u1ea5t c\u1ee9 th\u1ee9 g\u00ec tr\u00ean m\u00e1y t\u00ednh c\u1ee7a b\u1ea1n, vi\u1ec7c t\u00edch h\u1ee3p Python v\u00e0o trong Excel \u0111\u00e3 \u0111\u01b0\u1ee3c Microsoft lo cho ch\u00fang ta v\u00e0 vi\u1ec7c c\u1ee7a ch\u00fang ta l\u00e0 s\u1eed d\u1ee5ng th\u1eadt s\u00e1ng t\u1ea1o v\u00e0 hi\u1ec7u qu\u1ea3.<\/p>\n

H\u00e0m PY() v\u00e0 t\u1ea5t c\u1ea3 s\u1ef1 k\u1ef3 di\u1ec7u c\u1ee7a Python nay s\u1ebd c\u00f3 m\u1eb7t trong Excel<\/figcaption><\/figure>\n

\u201cT\u00f4i r\u1ea5t ph\u1ea5n kh\u00edch v\u00ec s\u1ef1 k\u1ebft h\u1ee3p ch\u1eb7t ch\u1ebd gi\u1eefa Python v\u00e0 Excel gi\u1edd \u0111\u00e2y \u0111\u00e3 \u0111\u01b0\u1ee3c c\u00f4ng b\u1ed1,\u201d Guido van Rossum, cha \u0111\u1ebb c\u1ee7a Python v\u00e0 hi\u1ec7n l\u00e0 m\u1ed9t k\u1ef9 s\u01b0 n\u1ed5i ti\u1ebfng t\u1ea1i Microsoft, chia s\u1ebb. \u201cT\u00f4i tin r\u1eb1ng c\u1ea3 hai c\u1ed9ng \u0111\u1ed3ng s\u1ebd t\u00ecm ra nh\u1eefng \u1ee9ng d\u1ee5ng m\u1edbi th\u00fa v\u1ecb t\u1eeb s\u1ef1 h\u1ee3p t\u00e1c n\u00e0y, l\u00e0m t\u0103ng c\u01b0\u1eddng kh\u1ea3 n\u0103ng c\u1ee7a m\u1ed7i b\u00ean. Khi t\u00f4i gia nh\u1eadp Microsoft ba n\u0103m tr\u01b0\u1edbc, t\u00f4i ch\u01b0a t\u1eebng ngh\u0129 r\u1eb1ng \u0111i\u1ec1u n\u00e0y s\u1ebd tr\u1edf th\u00e0nh hi\u1ec7n th\u1ef1c.\u201d<\/p>\n

S\u1eed d\u1ee5ng Python c\u00f9ng m\u00e1y h\u1ecdc \u0111\u1ec3 d\u1ef1 \u0111o\u00e1n th\u1eddi ti\u1ebft ngay trong Excel<\/figcaption><\/figure>\n

Python trong Excel \u0111ang \u0111\u01b0\u1ee3c tri\u1ec3n khai h\u00f4m nay d\u01b0\u1edbi d\u1ea1ng phi\u00ean b\u1ea3n xem tr\u01b0\u1edbc c\u00f4ng khai cho nh\u1eefng ng\u01b0\u1eddi d\u00f9ng Microsoft 365 Insiders \u1edf k\u00eanh Beta t\u1eeb phi\u00ean b\u1ea3n 16.0.16818.2000. Ban \u0111\u1ea7u, n\u00f3 s\u1ebd ch\u1ec9 d\u00e0nh cho Windows tr\u01b0\u1edbc khi \u0111\u01b0\u1ee3c m\u1edf r\u1ed9ng cho c\u00e1c n\u1ec1n t\u1ea3ng kh\u00e1c \u201cv\u00e0o m\u1ed9t th\u1eddi \u0111i\u1ec3m sau\u201d. <\/p>\n

B\u1ea1n c\u1ea7n c\u00f3 Microsoft 365 phi\u00ean b\u1ea3n Family ho\u1eb7c Personal tr\u1edf l\u00ean \u0111\u1ec3 tham gia ch\u01b0\u01a1ng tr\u00ecnh n\u00e0y.<\/figcaption><\/figure>\n

Microsoft cho bi\u1ebft Python trong Excel s\u1ebd \u0111\u01b0\u1ee3c bao g\u1ed3m trong g\u00f3i \u0111\u0103ng k\u00fd Microsoft 365 trong th\u1eddi gian xem tr\u01b0\u1edbc, nh\u01b0ng \u201cm\u1ed9t s\u1ed1 ch\u1ee9c n\u0103ng s\u1ebd b\u1ecb h\u1ea1n ch\u1ebf n\u1ebfu kh\u00f4ng c\u00f3 gi\u1ea5y ph\u00e9p tr\u1ea3 ph\u00ed\u201d sau khi phi\u00ean b\u1ea3n xem tr\u01b0\u1edbc k\u1ebft th\u00fac.<\/p>\n

\n
\n
\n
\n<\/a>\n<\/div>\n<\/div>\n
H\u00e0m PY() \u0111\u1ec3 chuy\u1ec3n qua ch\u1ebf \u0111\u1ed9 s\u1eed d\u1ee5ng Python trong Excel.<\/figcaption><\/figure>\n

V\u1eady b\u1ea1n c\u00f2n ch\u1edd \u0111\u1ee3i g\u00ec n\u1eefa m\u00e0 kh\u00f4ng chu\u1ea9n b\u1ecb ngay ki\u1ebfn th\u1ee9c Python \u0111\u1ec3 c\u00f3 th\u1ec3 \u00e1p d\u1ee5ng v\u00e0 chu\u1ea9n b\u1ecb cho nh\u1eefng n\u00e2ng c\u1ea5p th\u00fa v\u1ecb n\u00e0y \u0111\u1ebfn v\u1edbi Excel?<\/p>\n

\n
Tham gia h\u1ecdc Python Excel c\u00f9ng Thanh<\/a><\/div>\n<\/div>\n

Ngu\u1ed3n b\u00e0i vi\u1ebft: Microsoft<\/a><\/p>\n<\/div>\n

\n

Click \u0111\u0103ng k\u00fd h\u1ecdc t\u1ea1i:<\/p>\n

T\u1ea5t c\u1ea3 kho\u00e1 h\u1ecdc\u00a0\ud83d\udcd6<\/span><\/a><\/p>\n

H\u01b0\u1edbng d\u1eabn k\u00edch ho\u1ea1t<\/a><\/p>\n

HKD H\u1ecdc Excel Online
S\u1ed1 \u0110K: 17A80048102<\/p>\n<\/div>\n

\n

\u00a9 document.currentScript.insertAdjacentHTML(‘afterend’, ” + new Intl.DateTimeFormat(document.documentElement.lang, {year: ‘numeric’}).format() + ”); H\u1ecdc Excel Online. All rights reserved.<\/p>\n<\/div>\n","protected":false},"excerpt":{"rendered":"

Tham gia h\u1ecdc Python Excel c\u00f9ng Thanh<\/a><\/p>\n","protected":false},"author":1,"featured_media":756,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[2],"tags":[],"class_list":["post-755","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\/755","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=755"}],"version-history":[{"count":0,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/posts\/755\/revisions"}],"wp:featuredmedia":[{"embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media\/756"}],"wp:attachment":[{"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/media?parent=755"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/categories?post=755"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/blog.ezworkapp.com\/index.php\/wp-json\/wp\/v2\/tags?post=755"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}