Maitiro ekuwedzera huwandu muExcel

Maitiro ekusimudza muExcel: Kubata Masimba Masimba

Excel chishandiso chine simba chinopa huwandu hwakasiyana hwemabasa uye kugona kwekutonga nekuongorora data. Pakati pemabasa aya mabasa emasimba, ayo anobvumira nhamba kuti isimudzwe kune rimwe simba. Kuziva aya maficha kwakakosha kuita mamwe epamusoro maverengero uye ongororo muExcel, ingave inyanzvi kana yemunhu. Muchinyorwa chino, isu tichaongorora zvakadzama maitiro ekusimudza muExcel uye maitiro ekuita zvakanyanya zveaya maficha emagetsi kutora hunyanzvi hwako hwespredishiti kuenda padanho rinotevera.

1. Kunzwisisa mabasa emagetsi muExcel

Tisati tanyura munyika yesimba muExcel, zvakakosha kuti tinzwisise kuti aya mabasa emagetsi ndeapi uye kuti anoshandiswa sei. Muchidimbu, basa resimba rinotibvumira kusimudza nhamba kune rimwe simba. Semuenzaniso, kana tichida kukwidza nhamba 2 kune simba 3, tinoshandisa "SIMBA (2, 3)" basa muExcel, iro richatipa 8 semugumisiro "SIMBA (base, exponent)".

2. Mienzaniso inoshanda yekusimudza nhamba muExcel

Iye zvino zvatava nekunzwisisa kwekutanga kwemabasa emagetsi muExcel, ngatitarisei mimwe mienzaniso inoshanda kuratidza mashandisirwo aanoitwa mumamiriro epasirese. Fungidzira uri kushanda painjiniya purojekiti uye unoda kuverenga nzvimbo yedenderedzwa yakapihwa radius. Kana iwe uine radius yakachengetwa musero, unogona kushandisa simba rekuita kuti rikwire uye uwane nzvimbo. Semuenzaniso, kana radius iri 5, unogona kushandisa fomula =PI() * SIMBA(A2, 2) uko A2 ndiyo sero uko kukosha kweradius kunochengetwa.

3. Mazano nemanomano kutora mukana wakazara wemasimba masimba

Pamusoro pemienzaniso yakakosha, kune akati wandei matipi uye matekinoro anogona kukubatsira iwe kuti uite zvakanyanya emagetsi maficha muExcel. Semuyenzaniso, kana uchida kukwidza nhamba dzakawanda kusimba rimwe chete, unogona kushandisa mareferensi emasero pane kutaipa nhamba yega yega. Nenzira iyi, kana iwe uchida kukwereta nhamba 5 dzakasiyana, unogona kushandisa fomula =SIMBA(A2:A6, 2) pane kunyora =SIMBA(A2, 2), =SIMBA(A3, 2), nezvimwewo. Iyi nzira ichakubatsira iwe kuchengetedza nguva uye kudzivirira zvikanganiso zvinogona kuitika.

Muchidimbu, kugona mabasa esimba muExcel kwakakosha pakuita mamwe maverengero akaomarara uye kuongorora. Kunzwisisa yekutanga syntax uye mienzaniso inoshanda, pamwe nekushandisa matipi anobatsira uye matekinoroji, zvinokutendera iwe kutora hunyanzvi hwako hwespredishiti kuenda kune inotevera nhanho. Neruzivo urwu, iwe unozokwanisa kuita mamwe maverengero akanyatsojeka uye anoshanda, uye kutora mukana weiyo yakazara kugona kweExcel mumabasa ako ezuva nezuva.

1. Nhanganyaya kuExcel mabasa

Excel mashandiro maturusi ane simba anotendera iwe kuti uite kuverenga uye kuongorora data zvinobudirira. Neaya mabasa, zvinokwanisika kuita masvomhu, manhamba uye zvine musoro mashandiro muspredishiti, zvichiita kuti basa rive nyore uye kuchengetedza nguva yevashandisi. <>
Mamwe eanonyanya kushandiswa mabasa muExcel anosanganisira:
- Mabasa eMasvomhu: akadai seSUM, AVERAGE, MAXIMUM uye MINIMUM, ayo anobvumira kuverenga kwekutanga kuti kuitwe muspredishiti.
- Statistical mabasa: akadai DEVEST, VAR uye CONFIDENCE, ayo anobatsira kuongorora uye kupfupisa data zvichienderana nekugovera kwayo.
-Kushanda zvine musoro: senge IF, UYE uye OR, izvo zvinobvumira kuongororwa zvine musoro uye bvunzo kuti dziitwe muspredishiti.

Pamusoro peaya mabasa ekutanga, Excel inopawo akawanda ehunyanzvi mabasa emamwe mabasa, sekutsvaga sikweya midzi yenhamba, kuverenga kufarira kwekomboni, kana kuona kuti zuva rinowira pazuva rebhizinesi. Aya akasarudzika maficha anogona kubatsira zvakanyanya kune akasiyana maindasitiri nehunyanzvi. <>
Kuti ushandise basa muExcel, unongonyora zita rayo muchitokisi uye wopa nharo dzinodiwa mumaparentheses. Semuenzaniso, kana uchida kuwedzera nhamba dzakatevedzana, unogona kunyora "=SUM(A1:A10)" muchitokisi. Paunenge uchinge wadzvanya Enter, Excel inoverenga huwandu hwenhamba dziri muchikamu ichocho uye kuratidza mhedzisiro muchitokisi.

Sezvo iwe uchiwedzera kujairana neExcel maficha, iwe unowana isingaperi mikana yekuwana zvakanyanya kubva muchishandiso chine simba ichi. Kunyangwe iwe uchida kuongorora zvemari, kugadzira mishumo yetsika, kana otomatiki kudzokorora mabasa, Excel inokupa iwe maficha aunoda kuti uzviite nemazvo. nzira inoshanda. Ongorora Excel maficha uye tsvaga zvese zvaunogona kuita mumaspredishiti ako!

2. Mashandisiro emafomula uye mareferensi muExcel zvakanaka

Kuti uwedzere nhamba muExcel, unogona kushandisa fomura yakapusa: =nhamba...nhamba. Semuenzaniso, kana tichida kukwenya nhamba yechishanu, tinonyora chete =5^2. Zvakakosha kuyeuka kuti chiratidzo chekukwirira ndicho circumflex accent (^). Nenzira iyi, isu tinokwanisa kuita masvomhu nekukurumidza uye nemazvo pasina chikonzero chekushandisa mashandiro emaoko.

Mukuwedzera kune squaring, zvinokwanisika kushandisa mamwe mafomula uye mareferensi muExcel zvinobudirira. Mumwe wavo ndiye KUWEDZERA, iyo inotibvumira kuwedzera sarudzo yenhamba otomatiki. Semuenzaniso, kana tiine rondedzero yenhamba uye tichida kuwana huwandu hwadzo, tinongosarudza nhamba dzatinoda kuwedzera nekunyora. =SUM(range). Excel inozoverengera otomatiki huwandu hwenhamba dzakasarudzwa.

Imwe fomula inobatsira ndeye Avhareji, iyo inotibvumira kuwana avhareji yenhamba dzakasarudzwa. Kuti tishandise fomula iyi, tinosarudza nhamba dzatinoda kuenzana nekunyora = Avhareji (nzvimbo). Excel inoverenga avhareji yenhamba dzakasarudzwa uye inotiratidza mhedzisiro otomatiki. Neformula iyi, tinogona kuchengetedza nguva nesimba kana tichiita masvomhu muExcel.

Muchidimbu, Excel inotipa maturusi akawanda ekushandisa mafomula uye mareferensi nemazvo. Kubva pa squaring kusvika pakuwedzera neavhareji yenhamba, tinogona kutora mukana weaya mabasa kurerutsa maverengero edu uye kuwana mhedzisiro chaiyo. Neruzivo rwekutanga rweaya mafomula uye mareferensi, isu tinogona kukwidziridza ruzivo rweExcel uye nekuvandudza goho mumabasa edu ezuva nezuva.

3. Matanho ekugadzirisa nekugadzirisa data muExcel

MuExcel, kurongeka kwedata uye mafomati ndiwo akakosha maficha ekuwana zvakanyanya kunze kweichi chishandiso chine simba. Heano mamwe maitiro anokubatsira iwe kuvandudza hunyanzvi hwako hweExcel uye kukwidziridza yako data management:

1. Shandisa matafura epivot: Matafura epivot inzira huru yekuronga nekupfupikisa huwandu hukuru hwe data nenzira yakajeka, iri nyore kunzwisisa. Iwe unogona kugadzira matafura ane simba kuongorora data mishumo yekutengesa, mishumo yemari, zvinyorwa zvezvinyorwa uye zvimwe zvakawanda. Shandisa Excel's pivot tafura inoratidzira kuboka uye kupfupikisa data, kusefa ruzivo rwakakodzera, uye kugadzira mishumo yehunyanzvi.

2. Shandisa conditional formatting: Conditional fomati chishandiso chine simba chinokutendera kuti uise otomatiki data rinosangana nemamwe mamiriro. Unogona kushandisa mafomati ezvimiso kuti uone makoshero akafanana, kuratidza maseru ane hunhu hwepamusoro-soro kana hwakaderera, kana kumureza data rinoenderana nezvinodiwa. Iyi ficha ichakubatsira iwe nekukurumidza kuona mapatani uye mafambiro mune yako data uye kuita sarudzo zvichienderana neruzivo rwunooneka.

3. Ronga uye sefa data rako: Kugona kuronga nekusefa data muExcel Izvo zvakakosha pakuronga uye kuongorora maseti makuru eruzivo. Iwe unogona kuronga data rako mukukwira kana kudzika kurongeka, zvichibva pane zvakakosha mukoramu imwe kana kupfuura akawanda makoramu. Pamusoro pezvo, iwe unogona kusefa data rako kuratidza chete kukosha zvinosangana nemamwe maitiro. Aya maficha anozotendera iwe kuti uwane nekukurumidza ruzivo rwaunoda uye nekuriongorora zvakanyanya.

Kuita mazano aya kuchakubvumidza kuti ugone kukwidziridza manejimendi e data rako muExcel uye nekuvandudza hunyanzvi hwako mukushandisa chishandiso ichi. Rangarira kuti kugara uchidzidzira uye kuongorora kwese mabasa eExcel kuchakubatsira iwe kuve nyanzvi yekuongorora data nekugadzirisa. Tanga kushandisa aya mazano nhasi uye tora mukana wakazara weExcel kugona!

4. Mazano ekurerutsa mabasa ekudzokorora muExcel uchishandisa macros

Muchikamu chekupedzisira chekufunga nezvacho kana tichisimudza hunyanzvi hwedu muExcel, pane izvo Mazano eKurerutsa Kudzokorora Mabasa Uchishandisa Macros. Macros nhevedzano yemirairo uye zviito zvakarekodhwa mune yakatarwa hurongwa iyo inogona kuridzwa otomatiki. Izvi zvinotitendera kuti tiite otomatiki maitiro uye kuchengetedza nguva yakakosha. Heano mamwe matipi akakosha ekuita zvakanyanya simba remacros muExcel.

Zano rekutanga ndere Ziva uye ongorora kudzokorora mabasa izvo zvatinoita kazhinji muExcel. Inogona kuva chero chinhu kubva pakufometa maseru chaiwo kusvika pakugadzira mishumo yakaoma. Kana mabasa aya aonekwa, tinofanira funga nezvekutevedzana kwemirayiro inodiwa kuti iite. Izvo zvakakosha kuti utarise kune zvese zvakadzama, senge keyboard mapfupi anoshandiswa kana mabhatani embeva anodiwa. Kunzwisisa uku kwakakosha pakugadzira macro inoshanda.

Danho rinotevera ndeiri rekodha macro muExcel. Kuti tiite izvi, tinoenda ku "Developer" tab mune yepamusoro menyu uye sarudza "Rekodha macro". Tevere, isu tinosarudza zita reiyo macro uye topa keyboard pfupi, kana tichida. Nepo isu tichiita zviito zvinodiwa kuti tipedze basa rekudzokorora, iyo macro ichave ichirekodha yega yega nhanho dzedu. Kana basa rapera, tinongomira kurekodha macro. Iye zvino tinogona mhanyisa macro nekungodzvanya nzira yekudimbudzira kiibhodhi kana kushandisa sarudzo inoenderana mu "Developer" tab.

5. Wedzera kubereka muExcel nemapfupi ekhibhodi anobatsira

Kushandisa mapfupi ekhibhodi muExcel ndeye nzira inoshanda de wedzera kubereka uye kugadzirisa mafambiro ebasa. Kuziva uye kugona mamwe mapfupi anobatsira anogona kuita mutsauko wese mukumhanya uye nekurongeka kwemabasa ako ezuva nezuva. Heino rondedzero yemapfupi ekhibhodi anozokubatsira iwe kusimudza yako Excel hunyanzvi.

1. Quick Scroll: Shandisa makiyi emiseve kukurumidza kufamba pakati pemasero, mitsetse kana makoramu pasina kushandisa mbeva.

2. Kukurumidza kusarudza: Iyo Shift + Arrow kiyi musanganiswa inobvumidza iwe kukurumidza kusarudza huwandu kana block yemasero. Kana iwe ukadzvanya kiyi yeCtrl pamwe chete neShift, unogona kusarudza masero asina-contiguous.

3. Kopa woisa: Shandisa makiyi Ctrl + C kukopa uye Ctrl + V kunamira. Iyi kiyi musanganiswa inobatsira zvakanyanya kana uchishanda nehuwandu hukuru hwe data inoda kudhindwa kana kuendeswa kunzvimbo dzakasiyana.

Nezvishandiso izvi zvaunazvo, iwe uchaona maitiro ako ekuita uye kushanda zvakanaka muExcel kuwedzera zvakanyanya. Usatore pasi simba remapfupi ekhibhodi, sezvo anogona kukuchengetedza nguva uye kuderedza zvikanganiso paunenge uchipinda kana kushandura data. Dzidzira uye edza aya mapfupi uye uve nyanzvi yeExcel! Yeuka kuti kudzidzira nguva dzose ndicho chinhu chinokosha pakuziva unyanzvi hwose.

6. Maitiro ekuita ongororo yedata inoshanda uchishandisa pivot matafura muExcel

Pivot matafura muExcel chishandiso chine simba chekuongorora huwandu hukuru hwe data nekukurumidza uye nemazvo. Nekugona kwavo kupfupisa uye kuronga data mumasekonzi, matafura epivot ave sarudzo yakakurumbira yekuitisa inoshanda data data.. Kuti ushandise matafura epivot muExcel, unofanirwa kutanga waona kuti une data rakarongeka mutafura kana huwandu hwemasero. Wobva wasarudza iyo data uye enda ku "Insert" tebhu mukati mudziyo wekushandisa. Dzvanya "Pivot Tafura" uye sarudza paunoda kuti tafura yepivot ioneke.

Kana uchinge wagadzira iyo pivot tafura muExcel, unogona kutanga kuita inoshanda data data. Chinhu chakakosha pamatafura epivot kugona kukurumidza uye nyore kuunganidza uye kusefa data.. Iwe unogona kuwedzera minda patafura yepivot kuti uongorore zvakasiyana-siyana zve data, senge sums, mavhareji, mashoma, uye maximum. Uyezve, unogona kusefa data nyore kuratidza chete ruzivo rwaunofarira. Semuenzaniso, kana iwe uchiongorora data rekutengesa, unogona kusefa nedunhu kana yakatarwa nguva.

Chimwe chinhu chinobatsira chepivot matafura kugona gadzira machati ane simba anoenderana netafura data. Izvi zvinokubvumira kukurumidza uye zvakajeka kuona mafambiro uye mapatani mune data. Iwe unogona kugadzira akasiyana machati, senge makoramu machati, mitsetse machati, kana mabhawa machati, uye gadzirisa iwo kune zvaunoda. Iko kusanganiswa kwematafura epivot uye machati epivot muExcel inobvumidza iwe kuita yakazara uye inoshanda ongororo yedata, inogona kubatsira zvikuru mukuita sarudzo dzebhizinesi kana kupa mishumo.

7. Kugadzirisa Machati uye Kuona Data muExcel

:

Kana zvasvika pa simudza hunyanzvi hwako hweExcel, zvakakosha kuti uzive magadzirirwo egirafu uye maturusi ekuona data ayo inopihwa nesoftware. Aya maficha anogona kushandura yako data inofinha kuita inoyevedza uye inodzidzisa yekuona mharidzo.

A zvinobudirira Kugadzirisa machati ako muExcel kuri kushandisa "Design" tebhu iri patoolbar. Pano, iwe unowana sarudzo dzekuchinja mhando yechati, gadzirisa matemo, shandura mavara, uye wedzera zvimwe zvinhu zvakaita semazita uye mavara. Ku gadzirisa zvinhu izvi, iwe unozokwanisa kuratidza ruzivo rwakakosha uye kuita kuti girafu yako ive nyore kududzira. Pamusoro pezvo, iwe unogona kushandisa zvinhu zvakaita sematafura epivot kana Excel mafomula kuti ugadzire otomatiki machati anoenderana nedata idzva rakaiswa.

Imwe nzira yekuita simudza hunyanzvi hwako hweExcel ndeyekuona data kuburikidza nematafura anopindirana uye magirafu. Panzvimbo pekungoratidza manhamba muspredishiti, unogona kudzishandura kuita mabhawa machati, mitsetse yemachati, mapai machati, kana chero imwe mhando yechati inoenderana nezvido zvako. Izvi zvichaita kuti zvive nyore kuona mafambiro, kuenzanisa, uye mapatani mune yako data. Pamusoro pezvo, iwe unogona kushandisa maficha senge "Sparkline" chishandiso kugadzira magirafu madiki mukati mesero, zvichikubvumidza kuti utarise kiyi data zvakabatanidzwa uye zvinobudirira.

Yeuka kuti Izvo hazvizongokubatsira iwe kupa ruzivo nenzira inoyevedza, asi zvakare kuratidza akakosha mapatani uye maitiro mune yako data. Shandisa zvakasiyana-siyana zvekugadzirisa sarudzo izvo Excel inopa kugadzira zviratidziro zvinoonekwa zvinowedzera data rako uye kubvumira kunzwisisa kuri nani kweruzivo. Ongorora maturusi uye sarudzo dziripo, uye tora yako Excel hunyanzvi kune imwe nhanho!

8. Kugadziriswa kwemaitiro akaoma uye maverengero muExcel

MuExcel, zvakajairika kusangana nemafomu akaomarara uye maverengero anoda optimization kuti uwane nekukurumidza uye kwakaringana mhinduro. Sezvineiwo, kune akasiyana matekiniki atinogona kushandisa kuvandudza mashandiro emaspredishiti edu. Imwe yacho isarudzo yekukwevera nhamba muExcel. Kuti tiite izvi, tinogona kushandisa iyo SIMBA basa kana kutora mukana wekuwanza opareta. Semuenzaniso, kana tichida kukwenya nhamba 5, tinogona kushandisa fomula = SIMBA(5,2) kana kungonyora 5*5 musero.

Mukuwedzera kune squaring, zvinokwanisika kuita mamwe maverengero akaoma muExcel zvakanyanya. Imwe nzira inobatsira ndeyekushandiswa kwematafura ekunongedza. Aya matafura anotibvumira kuronga data uye mafomula nenzira yakarongeka, zvichiita kuti zvive nyore kuverenga nekunzwisisa. Pamusoro pezvo, nekushandisa mareferensi matafura, tinogona kutora mukana weExcel's otomatiki mafomula. Semuenzaniso, kana tichida kuita nhevedzano yekuverenga kweakasiyana ekuisa kukosha, tinogona kuisa kukosha mune imwe koramu yetafura uye toshandisa fomula imwe mune imwe koramu kuita masvomhu otomatiki kune yega yega kukosha.

Pakupedzisira, Kushandisa conditional function inogona kutibatsira kukwenenzvera mafomula akaoma uye maverengero muExcel. Aya mabasa anotibvumira kumisa mamiriro ezvinhu ane musoro uye kuita zviito zvakasiyana zvichienderana nemhedzisiro yekuongorora. Semuenzaniso, tinogona kushandisa iyo IF basa kuita calculation zvichienderana nekuti imwe mamiriro akasangana here kana kwete. Izvi zvinotibvumira kuderedza nhamba yemafomu asina kufanira uye maverengero, kuvandudza kushanda kwemashizha edu. Pamusoro pezvo, nekushandisa zvimiro zvemaitiro, isu tinokwanisa otomatiki kuita sarudzo mune edu mafomula, tichiita kuti awedzere kuchinjika uye achichinjika kune akasiyana mamiriro.

9. Mazano ekugadzirisa zvikanganiso zvakajairika muExcel

Munyika yekuverenga uye maspredishiti, Excel chishandiso chakakosha. Nekudaro, senge chero imwe chirongwa, inogona zvakare kupa zvikanganiso zvinogona kuita kuti zviome kushanda nemazvo. Heano mamwe matipi ekugadzirisa zvinowanzoitika zvikanganiso muExcel.

1. Kukanganisa kwemafomula: Imwe yezvikanganiso zvinowanzoitika muExcel kuita chikanganiso kana uchinyora fomula. Kuti udzivise dambudziko iri, zvakakosha kunyatsoongorora syntax yeformula usati waimhanyisa. Iwe unogona kushandisa iyo fomula yekusimbisa sarudzo yekutarisa kuenderana kweformula uye kuona kuti vese vashandisi uye mareferensi anopereterwa nemazvo.

2. Kusaenderana kwechimiro: Kazhinji, kukanganisa muExcel kunoitika nekuda kwemafomati asingaenderane pakati pemasero. Semuenzaniso, kana uri kuyedza kuita masvomhu pakati pesero remavara nenhamba sero, ungangoona kukanganisa. Kuti udzivise izvi, zvakakosha kuve nechokwadi kuti maseru anobatanidzwa akaumbwa zvakanaka asati aita chero maoparesheni.

3. Zvinyorwa zvisiri izvo: Imwe mhosho yakajairika muExcel kushandisa mareferensi asiri iwo. Izvi zvinoitika paunonongedzera sero kana huwandu hwemasero asipo kana asina kupereterwa zvisizvo. Kugadzirisa dambudziko iri, zvakakosha kuti uongorore mafomula uye uve nechokwadi chekuti mareferensi ese akanyorwa nemazvo uye anonongedzera kumaseru anodiwa. Pamusoro pezvo, unogona kushandisa "Tsvaga" basa kukurumidza kutsvaga nekugadzirisa chero mareferensi asiri iwo.

Yeuka, Excel chishandiso chine simba chinogona kufambisa zvakanyanya kuverenga kwako data uye kuongorora mabasa. Zvisinei, zvakakosha kuziva zvikanganiso zvakajairika uye kuziva nzira yekuzvigadzirisa. Nemazano aya, iwe unozogona kukwidziridza hunyanzvi hwako hweExcel uye kuwana zvakanyanya kubva mabasa ayo.

10. Kuvandudzwa mukubika uye kugadzira mishumo muExcel

.

MuExcel, kushuma uye kugadzira mishumo mabasa akakosha kune chero munhu anoshanda nedata uye anoda kuongorora nekuona ruzivo. zvinobudirira. Neraki, Microsoft yakaunza mamwe magadzirirwo achangoburwa kuExcel ayo anovandudza zvakanyanya aya maficha.

Imwe ye kuvandudzwa kwakanyanya muExcel ndiko kugona kuita gadzira matafura epivot zviri nyore. Ikozvino, nekungodzvanya kushoma, unogona kukurumidza kushandura huwandu hwe data kuita ine simba pivot tafura iyo inokutendera iwe kuchinjika kusefa, kupfupikisa, uye kuongorora iyo data. Pamusoro pezvo, sarudzo nyowani dzakawedzerwa kugadzirisa marongero uye fomati yematafura epivot, zvichikubvumidza kuti ugadzire mishumo inoyevedza uye yehunyanzvi.

Zvimwe chinhu chikuru mukubika nekugadzira mishumo muExcel ndiko kugona gadzira mifananidzo munguva chaiyo. Iye zvino unogona kuona ruzivo rwako mumachati anodyidzana anogadziridza otomatiki sezvo data riri pasi rinochinja. Izvi zvinonyanya kubatsira pakutarisa uye kuratidza chaiyo-nguva data, senge kutengesa kuita kana kutevedza chirongwa. Pamusoro pezvo, sarudzo nyowani dzakawedzerwa kugadzirisa machati, senge mavara, masitayipi, uye mavara, zvichikubvumidza iwe kugadzira anotonyanya kukanganisa ekuona.

Pamusoro pekuvandudzwa kwepivot matafura uye machati, Excel yakawedzera nyowani artificial intelligence mabasa kuitira kuburitsa mishumo. Ikozvino, unogona kushandisa iyo "Mazano" chimiro kuti uwane otomatiki mazano ekuti ungaratidza sei uye nekuona data rako zvinobudirira. Aya manzwisisiro anogadzirwa neExcel's AI injini yakavakirwa pamapateni uye maitiro mune yako data. Izvi zvinokubatsira kuchengetedza nguva paunenge uchigadzira mishumo uye unova nechokwadi chekuti mharidzo yako ine simba uye yakajeka kune vateereri vako.

Muchidimbu, Zvinoshamisa chaizvo. Nekugona kugadzira zviri nyore kugadzira matafura epivot, machati enguva-chaiyo, uye ane hungwaru hwekugadzira zvinhu, Excel yave chishandiso chine simba zvakanyanya chekuongorora nekupa data. Aya magadzirirwo haangochengetedze nguva chete, asi zvakare anobvumidza iwe kugadzira inoyevedza uye nyanzvi mishumo. Kana iwe uchida kukwidziridza hunyanzvi hwako hweExcel, usazeze kutora mukana weaya maficha matsva uye tora mishumo yako kune inotevera nhanho.