{"id":6865,"date":"2025-01-11T22:17:23","date_gmt":"2025-01-11T22:17:23","guid":{"rendered":"https:\/\/howtogeek.blog\/cs\/?p=6865"},"modified":"2025-01-11T22:17:23","modified_gmt":"2025-01-11T22:17:23","slug":"6-exciting-new-features-and-improvements-in-excel-2025","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/cs\/6-exciting-new-features-and-improvements-in-excel-2025\/","title":{"rendered":"6 Vzru\u0161uj\u00edc\u00ed nov\u00e9 funkce a vylep\u0161en\u00ed v Excelu 2025"},"content":{"rendered":"

D\u00edky vzru\u0161uj\u00edc\u00edm vylep\u0161en\u00edm p\u0159edstaven\u00fdm v roce 2024, v\u010detn\u011b vylep\u0161en\u00fdch funkc\u00ed usnadn\u011bn\u00ed a rychlej\u0161\u00edho v\u00fdkonu se\u0161itu, je Microsoft p\u0159ipraven k dal\u0161\u00ed revoluci Excelu v roce 2025. Poj\u010fme se pono\u0159it do pr\u016fkopnick\u00fdch funkc\u00ed, kter\u00e9 maj\u00ed b\u00fdt zavedeny v leto\u0161n\u00edm roce, kter\u00e9 poskytnou u\u017eivatel\u016fm v\u011bt\u0161\u00ed mo\u017enosti a pos\u00edl\u00ed jejich mo\u017enosti spr\u00e1vy dat.<\/p>\n

1 <\/span>Roz\u0161\u00ed\u0159en\u00e1 integrace druh\u00e9ho pilota<\/span><\/h2>\n

P\u0159ipravte se na hlub\u0161\u00ed integraci Copilota do Excelu. Vzhledem k tomu, \u017ee se tato s\u00edla um\u011bl\u00e9 inteligence st\u00e1le v\u00edce za\u010dle\u0148uje do sady Microsoft 365, m\u016f\u017eete o\u010dek\u00e1vat, \u017ee dramaticky zefektivn\u00ed v\u00e1\u0161 pracovn\u00ed postup.<\/p>\n

Copilot v\u00e1m nejen pom\u016f\u017ee p\u0159i prov\u00e1d\u011bn\u00ed slo\u017eit\u00fdch \u00faloh aplikace Excel, ale nyn\u00ed v\u00e1m pom\u016f\u017ee zlep\u0161it va\u0161e schopnosti manipulace s daty a u\u0161et\u0159\u00ed v\u00e1m \u010das a n\u00e1mahu. Software bude schopen z\u00edsk\u00e1vat odpov\u011bdi z webu a bezprobl\u00e9mov\u011b za\u010dlenit relevantn\u00ed informace p\u0159\u00edmo do va\u0161ich tabulek, \u010d\u00edm\u017e zm\u011bn\u00ed zp\u016fsob, jak\u00fdm analyzujete a interpretujete data.<\/p>\n

Krom\u011b toho bude Copilot obsahovat vylep\u0161en\u00e9 funkce v\u00fdzvy, kter\u00e9 v\u00e1m umo\u017en\u00ed snadno vytv\u00e1\u0159et \u00fa\u017easn\u00e9 grafy a \u0161ablony. Tento n\u00e1stroj v\u00e1s zapoj\u00ed p\u0159\u00e1telsk\u00fdm, konverza\u010dn\u00edm zp\u016fsobem a povede v\u00e1s k vytv\u00e1\u0159en\u00ed \u00fa\u010dinn\u00fdch v\u00fdzev p\u0159izp\u016fsoben\u00fdch va\u0161im pot\u0159eb\u00e1m.<\/p>\n

Zde je ta nejv\u00edce vzru\u0161uj\u00edc\u00ed \u010d\u00e1st: Brzy budete moci sd\u00edlet sv\u00e9 vlastn\u00ed v\u00fdzvy se sv\u00fdmi kolegy prost\u0159ednictv\u00edm Copilot Prompt Gallery v Microsoft Teams, \u010d\u00edm\u017e podpo\u0159\u00edte spolupr\u00e1ci a sd\u00edlen\u00ed znalost\u00ed ve va\u0161\u00ed organizaci. Obl\u00edben\u011bj\u0161\u00ed v\u00fdzvy nav\u00edc obdr\u017e\u00ed funkci \u201eTo se mi l\u00edb\u00ed\u201c, co\u017e v\u00e1m umo\u017en\u00ed posoudit jejich u\u017eite\u010dnost v cel\u00e9m t\u00fdmu.<\/p>\n

Plat\u00ed pro:<\/strong> Desktop, Web a Mac | Za\u010d\u00e1tek vyd\u00e1v\u00e1n\u00ed:<\/strong> leden 2025<\/p>\n

2 <\/span>Obnoven\u00ed Power Query z ov\u011b\u0159en\u00fdch zdroj\u016f dat<\/span><\/h2>\n

Power Query, z\u00e1kladn\u00ed funkce transformace dat, vylep\u0161uje svou hru v roce 2025. Nadch\u00e1zej\u00edc\u00ed aktualizace, kter\u00e9 byly d\u0159\u00edve omezeny na obnovovac\u00ed dotazy ze se\u0161itu a anonymn\u00ed zdroje OData, v\u00e1m umo\u017en\u00ed obnovovat data Power Query tak\u00e9 z ov\u011b\u0159en\u00fdch zdroj\u016f.<\/p>\n

Toto vylep\u0161en\u00ed poskytne u\u017eivatel\u016fm v\u011bt\u0161\u00ed flexibilitu a kontrolu nad jejich procesy integrace dat, umo\u017en\u00ed slo\u017eit\u011bj\u0161\u00ed pracovn\u00ed postupy a anal\u00fdzu dat v re\u00e1ln\u00e9m \u010dase.<\/p>\n

Plat\u00ed pro:<\/strong> Web | Za\u010d\u00e1tek vyd\u00e1v\u00e1n\u00ed:<\/strong> b\u0159ezen 2025<\/p>\n

3 <\/span>Synchronizujte data z Microsoft Forms do aplikace Excel Desktop<\/span><\/h2>\n

Vzru\u0161uj\u00edc\u00ed novou funkc\u00ed pro p\u0159edplatitele Microsoft 365 je mo\u017enost vytv\u00e1\u0159et a propojovat formul\u00e1\u0159e p\u0159\u00edmo v aplikaci Excel pro stoln\u00ed po\u010d\u00edta\u010de, co\u017e zlep\u0161uje zp\u011btnou vazbu v re\u00e1ln\u00e9m \u010dase. Tato integrace v\u00e1m umo\u017e\u0148uje vizualizovat reakce okam\u017eit\u011b, jakmile dojde k p\u0159\u00edlivu dat.<\/p>\n

Jednodu\u0161e otev\u0159ete nov\u00fd se\u0161it, aktivujte automatick\u00e9 ukl\u00e1d\u00e1n\u00ed a pot\u00e9 p\u0159ejd\u011bte na kartu \u201eVlo\u017eit\u201c a vytvo\u0159te nov\u00fd formul\u00e1\u0159. P\u0159i konfiguraci formul\u00e1\u0159e se odpov\u00eddaj\u00edc\u00ed ot\u00e1zky dynamicky aktualizuj\u00ed ve va\u0161\u00ed excelov\u00e9 tabulce.<\/p>\n

Toto bezprobl\u00e9mov\u00e9 propojen\u00ed mezi Forms a Excelem otev\u00edr\u00e1 v\u00fdkonn\u00e9 mo\u017enosti pro pr\u016fzkumy, kv\u00edzy a iniciativy shroma\u017e\u010fov\u00e1n\u00ed dat ve va\u0161\u00ed organizaci.<\/p>\n

Plat\u00ed pro:<\/strong> Desktop | Za\u010d\u00e1tek vyd\u00e1v\u00e1n\u00ed:<\/strong> listopad 2024<\/p>\n

4 <\/span>N\u00e1prava nekompatibiln\u00edch vzorc\u016f<\/span><\/h2>\n

Jednou z v\u00fdznamn\u00fdch v\u00fdzev, kter\u00fdm podniky \u010del\u00ed p\u0159i migraci na Microsoft 365, je mo\u017enost nekompatibility se st\u00e1vaj\u00edc\u00edmi vzorci a odkazy. Ke zm\u00edrn\u011bn\u00ed t\u011bchto probl\u00e9m\u016f zavede spole\u010dnost Microsoft proces n\u00e1pravy zam\u011b\u0159en\u00fd na zaji\u0161t\u011bn\u00ed funk\u010dnosti v\u0161ech datov\u00fdch v\u00fdpo\u010dt\u016f a vzorc\u016f po migraci. Tato funkce usnadn\u00ed p\u0159echody pro u\u017eivatele p\u0159ech\u00e1zej\u00edc\u00ed z jin\u00fdch platforem.<\/p>\n

Plat\u00ed pro:<\/strong> Web | Za\u010d\u00e1tek vyd\u00e1v\u00e1n\u00ed:<\/strong> leden 2025<\/p>\n

5 <\/span>Dal\u0161\u00ed n\u00e1stroje pro pokro\u010dil\u00e9 datov\u00e9 analytiky<\/span><\/h2>\n

Prost\u0159ed\u00ed n\u00e1stroj\u016f pro anal\u00fdzu dat se rychle m\u011bn\u00ed, p\u0159i\u010dem\u017e platformy jako Tableau a jazyky jako Python z\u00edsk\u00e1vaj\u00ed tah pro anal\u00fdzu v re\u00e1ln\u00e9m \u010dase. Spole\u010dnost Microsoft si to uv\u011bdomuje a je odhodl\u00e1na udr\u017eovat Excel relevantn\u00ed neust\u00e1l\u00fdm vylep\u0161ov\u00e1n\u00edm jeho schopnost\u00ed.<\/p>\n

Zvl\u00e1\u0161t\u011b pozoruhodn\u00e9 je p\u0159id\u00e1n\u00ed Pythonu do Excelu, kter\u00e9 u\u017eivatel\u016fm nab\u00edz\u00ed mo\u017enost spou\u0161t\u011bt k\u00f3d Pythonu p\u0159\u00edmo v Excelu a d\u00e1le integruje robustn\u00ed analytick\u00e9 n\u00e1stroje. Po\u010d\u00ednaje lednem 2025 se podpora Pythonu roz\u0161\u00ed\u0159\u00ed na webovou verzi Excelu, \u010d\u00edm\u017e se p\u0159iprav\u00ed cesta pro pokro\u010dilej\u0161\u00ed analytick\u00e9 procesy zcela v r\u00e1mci ekosyst\u00e9mu.<\/p>\n

6 <\/span>nevyhnuteln\u00fdch nov\u00fdch funkc\u00ed<\/span><\/h2>\n

Vzhledem k tomu, \u017ee Microsoft pokra\u010duje v inovac\u00edch, o\u010dek\u00e1vejte zaveden\u00ed dal\u0161\u00edch funkc\u00ed, kter\u00e9 uspokoj\u00ed vyv\u00edjej\u00edc\u00ed se pot\u0159eby u\u017eivatel\u016f. Vzhledem k tomu, \u017ee v roce 2024 se objevilo 14 nov\u00fdch funkc\u00ed, v\u010detn\u011b TEXTBEFORE a WRAPROWS, je pravd\u011bpodobn\u00e9, \u017ee nov\u00e9 a vylep\u0161en\u00e9 funkce budou m\u00edt sv\u016fj debut v roce 2025.<\/p>\n

To by tak\u00e9 mohlo signalizovat postupn\u00e9 vy\u0159azov\u00e1n\u00ed klasick\u00fdch funkc\u00ed, jako je VLOOKUP a CONCATENATE, ve prosp\u011bch dynami\u010dt\u011bj\u0161\u00edch n\u00e1stupc\u016f, jako jsou XLOOKUP a CONCAT, co\u017e nov\u011b definuje, jak u\u017eivatel\u00e9 p\u0159istupuj\u00ed k z\u00edsk\u00e1v\u00e1n\u00ed dat a manipulaci s nimi.<\/p>\n

Pokud chcete tyto funkce prozkoumat brzy, zva\u017ete p\u0159ipojen\u00ed k programu Microsoft 365 Insider Program<\/a> . Pod\u00edvejte se na Microsoft Roadmap<\/a> pro pr\u016fb\u011b\u017en\u00e9 aktualizace o nadch\u00e1zej\u00edc\u00edch funkc\u00edch a vylep\u0161en\u00edch!<\/p>\n

Dal\u0161\u00ed statistiky<\/h3>\n

1. Co je funkce Copilot v Excelu?<\/strong><\/h4>\n

Copilot je integrace um\u011bl\u00e9 inteligence navr\u017een\u00e1 tak, aby u\u017eivatel\u016fm pom\u00e1hala p\u0159i automatizaci \u00faloh, zvy\u0161ov\u00e1n\u00ed produktivity a poskytov\u00e1n\u00ed inteligentn\u00edch p\u0159ehled\u016f p\u0159\u00edmo v Excelu. S Copilot mohou u\u017eivatel\u00e9 o\u010dek\u00e1vat, \u017ee zefektivn\u00ed sv\u00e9 pracovn\u00ed postupy a dos\u00e1hnou lep\u0161\u00edch v\u00fdsledk\u016f anal\u00fdzy dat.<\/p>\n

2. Jak Power Query zlep\u0161uje pr\u00e1ci s daty v Excelu?<\/strong><\/h4>\n

Power Query umo\u017e\u0148uje u\u017eivatel\u016fm p\u0159ipojovat se, transformovat a na\u010d\u00edtat data z r\u016fzn\u00fdch zdroj\u016f, co\u017e umo\u017e\u0148uje efektivn\u011bj\u0161\u00ed spr\u00e1vu dat. Nov\u00e1 mo\u017enost obnovovat data z ov\u011b\u0159en\u00fdch zdroj\u016f v roce 2025 zlep\u0161\u00ed p\u0159\u00edstup k dat\u016fm v re\u00e1ln\u00e9m \u010dase a mo\u017enosti integrace.<\/p>\n

3. Jak\u00e9 v\u00fdhody poskytuje synchronizace Microsoft Forms s Excelem?<\/strong><\/h4>\n

Funkce synchronizace umo\u017e\u0148uje u\u017eivatel\u016fm vytv\u00e1\u0159et formul\u00e1\u0159e v aplikaci Excel a zobrazovat odpov\u011bdi v re\u00e1ln\u00e9m \u010dase, jakmile p\u0159ijdou. Tato integrace zjednodu\u0161uje proces shroma\u017e\u010fov\u00e1n\u00ed dat a zaji\u0161\u0165uje, \u017ee se zp\u011btn\u00e1 vazba od u\u017eivatel\u016f okam\u017eit\u011b odraz\u00ed v prost\u0159ed\u00ed Excelu, co\u017e podporuje interaktivn\u011bj\u0161\u00ed prost\u0159ed\u00ed.<\/p>\n

Zdroj a obr\u00e1zky<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

D\u00edky vzru\u0161uj\u00edc\u00edm vylep\u0161en\u00edm p\u0159edstaven\u00fdm v roce 2024, v\u010detn\u011b vylep\u0161en\u00fdch funkc\u00ed usnadn\u011bn\u00ed a rychlej\u0161\u00edho v\u00fdkonu se\u0161itu, je Microsoft p\u0159ipraven k dal\u0161\u00ed revoluci Excelu v roce 2025. Poj\u010fme se pono\u0159it do pr\u016fkopnick\u00fdch funkc\u00ed, kter\u00e9 maj\u00ed b\u00fdt zavedeny v leto\u0161n\u00edm roce, kter\u00e9 poskytnou u\u017eivatel\u016fm v\u011bt\u0161\u00ed mo\u017enosti a pos\u00edl\u00ed jejich mo\u017enosti spr\u00e1vy dat. 1 Roz\u0161\u00ed\u0159en\u00e1 integrace druh\u00e9ho pilota P\u0159ipravte […]<\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[1],"tags":[126,879,283,5],"class_list":["post-6865","post","type-post","status-publish","format-standard","hentry","category-how-to","tag-microsoft","tag-microsoft-365","tag-microsoft-excel","tag-windows"],"acf":[],"_links":{"self":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6865","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/comments?post=6865"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6865\/revisions"}],"predecessor-version":[{"id":6866,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/posts\/6865\/revisions\/6866"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/media?parent=6865"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/categories?post=6865"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/cs\/wp-json\/wp\/v2\/tags?post=6865"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}