{"id":6687,"date":"2025-01-11T22:18:19","date_gmt":"2025-01-11T22:18:19","guid":{"rendered":"https:\/\/howtogeek.blog\/lv\/?p=6687"},"modified":"2025-01-11T22:18:19","modified_gmt":"2025-01-11T22:18:19","slug":"6-exciting-new-features-and-improvements-in-excel-2025","status":"publish","type":"post","link":"https:\/\/howtogeek.blog\/lv\/6-exciting-new-features-and-improvements-in-excel-2025\/","title":{"rendered":"6\u00a0Jaunas aizraujo\u0161as funkcijas un uzlabojumi programm\u0101 Excel\u00a02025"},"content":{"rendered":"

Ar 2024.\u00a0gad\u0101 ieviestajiem aizraujo\u0161ajiem uzlabojumiem, tostarp uzlabotiem pieejam\u012bbas l\u012bdzek\u013ciem un \u0101tr\u0101ku darbgr\u0101matas veiktsp\u0113ju, Microsoft ir gatavs turpin\u0101t revol\u016bciju programm\u0101 Excel 2025.\u00a0gad\u0101. Iedzi\u013cin\u0101simies revolucion\u0101rajos funkcij\u0101s, kuras paredz\u0113ts ieviest \u0161ogad un kas sniegs lietot\u0101jiem iesp\u0113jas un uzlabos vi\u0146u datu p\u0101rvald\u012bbas iesp\u0113jas.<\/p>\n

1 <\/span>Papla\u0161in\u0101ta otr\u0101 pilota integr\u0101cija<\/span><\/h2>\n

Sagatavojieties dzi\u013c\u0101kai Copilot integr\u0101cijai programm\u0101 Excel. T\u0101 k\u0101 \u0161\u012b m\u0101ksl\u012bg\u0101 intelekta sp\u0113kstacija arvien vair\u0101k tiek iek\u013cauta Microsoft\u00a0365 komplekt\u0101, varat sagaid\u012bt, ka tas iev\u0113rojami racionaliz\u0113s j\u016bsu darbpl\u016bsmu.<\/p>\n

Copilot ne tikai pal\u012bdz\u0113s jums veikt sare\u017e\u0123\u012btus Excel uzdevumus, bet tagad pal\u012bdz\u0113s uzlabot j\u016bsu datu manipul\u0101cijas sp\u0113jas, ietaupot j\u016bsu laiku un p\u016bles. Programmat\u016bra var\u0113s ieg\u016bt atbildes no t\u012bmek\u013ca un neman\u0101mi iek\u013caut attiec\u012bgo inform\u0101ciju tie\u0161i j\u016bsu izkl\u0101jlap\u0101s, p\u0101rveidojot to, k\u0101 j\u016bs analiz\u0113jat un interpret\u0113jat datus.<\/p>\n

Turkl\u0101t Copilot b\u016bs uzlabotas uzvednes iesp\u0113jas, kas \u013caus jums viegli izveidot satrieco\u0161as diagrammas un veidnes. \u0160is r\u012bks j\u016bs iesaist\u012bs draudz\u012bg\u0101, sarunvalodas veid\u0101, pal\u012bdzot jums izveidot efekt\u012bvas uzvednes, kas piel\u0101gotas j\u016bsu vajadz\u012bb\u0101m.<\/p>\n

L\u016bk, pati aizraujo\u0161\u0101k\u0101 da\u013ca: dr\u012bzum\u0101 var\u0113sit kop\u012bgot piel\u0101got\u0101s uzvednes ar kol\u0113\u0123iem, izmantojot Microsoft Teams Copilot uzved\u0146u galeriju, veicinot sadarb\u012bbu un zin\u0101\u0161anu apmai\u0146u sav\u0101 organiz\u0101cij\u0101. Turkl\u0101t popul\u0101r\u0101k\u0101s uzvednes sa\u0146ems funkciju \u201cPat\u012bk\u201d, kas \u013caus jums nov\u0113rt\u0113t to lietder\u012bbu j\u016bsu komand\u0101.<\/p>\n

Attiecas uz:<\/strong> Desktop, Web un Mac | Izlai\u0161anas s\u0101kums:<\/strong> 2025.\u00a0gada janv\u0101ris<\/p>\n

2 <\/span>Power Query atsvaidzin\u0101\u0161ana no autentific\u0113tiem datu avotiem<\/span><\/h2>\n

Power Query, kas ir b\u016btisks datu p\u0101rveido\u0161anas l\u012bdzeklis, 2025.\u00a0gad\u0101 pastiprin\u0101s savu sp\u0113li. Iepriek\u0161 aprobe\u017eoj\u0101s ar vaic\u0101jumu atsvaidzin\u0101\u0161anu no darbgr\u0101matas un anon\u012bm\u0101m OData pl\u016bsm\u0101m, bet gaid\u0101mie atjaunin\u0101jumi \u013caus jums atsvaidzin\u0101t Power Query datus ar\u012b no autentific\u0113tiem avotiem.<\/p>\n

\u0160is uzlabojums nodro\u0161in\u0101s lietot\u0101jiem liel\u0101ku elast\u012bbu un kontroli p\u0101r vi\u0146u datu integr\u0101cijas procesiem, \u013caujot veikt sare\u017e\u0123\u012bt\u0101kas darbpl\u016bsmas un re\u0101llaika datu anal\u012bzi.<\/p>\n

Attiecas uz:<\/strong> Web | Izlai\u0161anas s\u0101kums:<\/strong> 2025.\u00a0gada marts<\/p>\n

3 <\/span>Sinhroniz\u0113jiet datus no Microsoft Forms ar Excel Desktop App<\/span><\/h2>\n

Aizraujo\u0161a jauna funkcija Microsoft 365 abonentiem ir iesp\u0113ja izveidot un saist\u012bt veidlapas tie\u0161i Excel darbvirsmas lietotn\u0113, uzlabojot re\u0101llaika atgriezenisko saiti. \u0160\u012b integr\u0101cija \u013cauj vizualiz\u0113t atbildes nekav\u0113joties, kad notiek datu piepl\u016bdums.<\/p>\n

Vienk\u0101r\u0161i atveriet jaunu darbgr\u0101matu, aktiviz\u0113jiet autom\u0101tisko saglab\u0101\u0161anu, p\u0113c tam dodieties uz cilni \u201cIevietot\u201d, lai izveidotu jaunu veidlapu. Veidlapas konfigur\u0113\u0161anas laik\u0101 atbilsto\u0161ie jaut\u0101jumi tiks dinamiski atjaunin\u0101ti j\u016bsu Excel izkl\u0101jlap\u0101.<\/p>\n

\u0160is neman\u0101mais savienojums starp Forms un Excel paver jaud\u012bgas iesp\u0113jas veikt aptaujas, viktor\u012bnas un datu v\u0101k\u0161anas iniciat\u012bvas j\u016bsu organiz\u0101cij\u0101.<\/p>\n

Attiecas uz:<\/strong> Darbvirsma | Izlai\u0161anas s\u0101kums:<\/strong> 2024.\u00a0gada novembris<\/p>\n

4 <\/span>Nesader\u012bgu formulu nov\u0113r\u0161ana<\/span><\/h2>\n

Viena no noz\u012bm\u012bgaj\u0101m probl\u0113m\u0101m, ar ko saskaras uz\u0146\u0113mumi, migr\u0113jot uz Microsoft 365, ir iesp\u0113jam\u0101 nesader\u012bba ar eso\u0161aj\u0101m formul\u0101m un sait\u0113m. Lai mazin\u0101tu \u0161\u012bs probl\u0113mas, Microsoft ievies\u012bs atl\u012bdzin\u0101\u0161anas procesu, kura m\u0113r\u0137is ir nodro\u0161in\u0101t visu datu apr\u0113\u0137inu un formulu funkcionalit\u0101ti p\u0113c migr\u0101cijas. \u0160\u012b funkcija padar\u012bs p\u0101rejas vienm\u0113r\u012bg\u0101kas lietot\u0101jiem, kuri p\u0101riet no cit\u0101m platform\u0101m.<\/p>\n

Attiecas uz:<\/strong> Web | Izlai\u0161anas s\u0101kums:<\/strong> 2025.\u00a0gada janv\u0101ris<\/p>\n

5 <\/span>citi r\u012bki pieredz\u0113ju\u0161iem datu anal\u012bti\u0137iem<\/span><\/h2>\n

Datu anal\u012bzes r\u012bku ainava strauji main\u0101s, un t\u0101das platformas k\u0101 Tableau un valodas, piem\u0113ram, Python, k\u013c\u016bst arvien popul\u0101r\u0101kas re\u0101llaika anal\u012btikai. Korpor\u0101cija Microsoft to apzin\u0101s un ir ap\u0146\u0113musies saglab\u0101t Excel atbilsto\u0161u, nep\u0101rtraukti uzlabojot t\u0101s iesp\u0113jas.<\/p>\n

\u012apa\u0161i iev\u0113r\u012bbas cien\u012bgs ir Python pievieno\u0161ana programm\u0101 Excel, pied\u0101v\u0101jot lietot\u0101jiem iesp\u0113ju palaist Python kodu tie\u0161i programm\u0101 Excel, v\u0113l vair\u0101k integr\u0113jot robustos anal\u012btiskos r\u012bkus. S\u0101kot ar 2025.\u00a0gada janv\u0101ri, Python atbalsts tiks papla\u0161in\u0101ts l\u012bdz Excel t\u012bmek\u013ca versijai, paverot ce\u013cu progres\u012bv\u0101kiem anal\u012btikas procesiem, kas piln\u012bb\u0101 ietverti ekosist\u0113m\u0101.<\/p>\n

6 <\/span>neizb\u0113gamas jaunas funkcijas<\/span><\/h2>\n

T\u0101 k\u0101 Microsoft turpina ieviest jaunin\u0101jumus, sagaidiet, ka tiks ieviestas papildu funkcijas, kas atbilst main\u012bgaj\u0101m lietot\u0101ju vajadz\u012bb\u0101m. \u0145emot v\u0113r\u0101, ka 2024.\u00a0gad\u0101 par\u0101d\u012bj\u0101s 14 jaunas funkcijas, tostarp TEXTBEFORE un WRAPROWS, iesp\u0113jams, ka jaunas un uzlabotas funkcijas debit\u0113s 2025.\u00a0gad\u0101.<\/p>\n

Tas var\u0113tu ar\u012b liecin\u0101t par pak\u0101penisku klasisko funkciju, piem\u0113ram, VLOOKUP un CONCATENATE, p\u0101rtrauk\u0161anu par labu dinamisk\u0101kiem p\u0113cte\u010diem, piem\u0113ram, XLOOKUP un CONCAT, no jauna defin\u0113jot lietot\u0101ju pieeju datu izguvei un manipul\u0101cij\u0101m.<\/p>\n

Ja v\u0113laties laic\u012bgi izp\u0113t\u012bt \u0161os l\u012bdzek\u013cus, apsveriet iesp\u0113ju pievienoties programmai Microsoft 365 Insider<\/a> . P\u0101rbaudiet Microsoft ce\u013cvedi<\/a> , lai uzzin\u0101tu jaun\u0101kos atjaunin\u0101jumus par gaid\u0101majiem l\u012bdzek\u013ciem un uzlabojumiem!<\/p>\n

Papildu ieskati<\/h3>\n

1. Kas ir programm\u0101 Excel Copilot l\u012bdzeklis?<\/strong><\/h4>\n

Copilot ir AI integr\u0101cija, kas izstr\u0101d\u0101ta, lai pal\u012bdz\u0113tu lietot\u0101jiem automatiz\u0113t uzdevumus, uzlabot produktivit\u0101ti un sniegt viedus ieskatus tie\u0161i programm\u0101 Excel. Izmantojot Copilot, lietot\u0101ji var racionaliz\u0113t savu darbpl\u016bsmu un sasniegt lab\u0101kus datu anal\u012bzes rezult\u0101tus.<\/p>\n

2.\u00a0K\u0101 Power Query uzlabo Excel datu apstr\u0101di?<\/strong><\/h4>\n

Power Query \u013cauj lietot\u0101jiem izveidot savienojumu ar, p\u0101rveidot un iel\u0101d\u0113t datus no da\u017e\u0101diem avotiem, nodro\u0161inot efekt\u012bv\u0101ku datu p\u0101rvald\u012bbu. Jaun\u0101 iesp\u0113ja 2025.\u00a0gad\u0101 atsvaidzin\u0101t datus no autentific\u0113tiem avotiem uzlabos re\u0101llaika datu piek\u013cuvi un integr\u0101cijas iesp\u0113jas.<\/p>\n

3. K\u0101das priek\u0161roc\u012bbas sniedz Microsoft Forms sinhroniz\u0101cija ar Excel?<\/strong><\/h4>\n

Sinhroniz\u0101cijas l\u012bdzeklis \u013cauj lietot\u0101jiem izveidot veidlapas programm\u0101 Excel un skat\u012bt atbildes re\u0101llaik\u0101, tikl\u012bdz t\u0101s tiek sa\u0146emtas. \u0160\u012b integr\u0101cija vienk\u0101r\u0161o datu v\u0101k\u0161anas procesu un nodro\u0161ina, ka lietot\u0101ju atsauksmes tiek nekav\u0113joties atspogu\u013cotas Excel vid\u0113, veicinot interakt\u012bv\u0101ku pieredzi.<\/p>\n

Avots un att\u0113li<\/a><\/p>\n","protected":false},"excerpt":{"rendered":"

Ar 2024.\u00a0gad\u0101 ieviestajiem aizraujo\u0161ajiem uzlabojumiem, tostarp uzlabotiem pieejam\u012bbas l\u012bdzek\u013ciem un \u0101tr\u0101ku darbgr\u0101matas veiktsp\u0113ju, Microsoft ir gatavs turpin\u0101t revol\u016bciju programm\u0101 Excel 2025.\u00a0gad\u0101. Iedzi\u013cin\u0101simies revolucion\u0101rajos funkcij\u0101s, kuras paredz\u0113ts ieviest \u0161ogad un kas sniegs lietot\u0101jiem iesp\u0113jas un uzlabos vi\u0146u datu p\u0101rvald\u012bbas iesp\u0113jas. 1 Papla\u0161in\u0101ta otr\u0101 pilota integr\u0101cija Sagatavojieties dzi\u013c\u0101kai Copilot integr\u0101cijai programm\u0101 Excel. T\u0101 k\u0101 \u0161\u012b m\u0101ksl\u012bg\u0101 intelekta […]<\/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":[130,869,286,9],"class_list":["post-6687","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\/lv\/wp-json\/wp\/v2\/posts\/6687","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/comments?post=6687"}],"version-history":[{"count":1,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/6687\/revisions"}],"predecessor-version":[{"id":6688,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/posts\/6687\/revisions\/6688"}],"wp:attachment":[{"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/media?parent=6687"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/categories?post=6687"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/howtogeek.blog\/lv\/wp-json\/wp\/v2\/tags?post=6687"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}