Nigute washyiraho ububiko bwimodoka muri excel

Anonim

Microsoft Excel

Ntabwo bishimishije cyane mugihe bitewe no guhagarika imbaraga, mudasobwa imanikwa cyangwa izindi zatsinzwe, amakuru watsinzenye mumeza, ariko ntamwanya watsinze kumeza, ariko ntamwanya wo gukiza, yatakaye. Byongeye kandi, burigihe burigihe kugirango habeho ibisubizo byimirimo yawe - ibi bivuze kurangara mumasomo yingenzi no gutakaza igihe cyinyongera. Kubwamahirwe, gahunda ya Excel ifite igikoresho cyoroshye nko kubika imodoka. Reka dukemure uburyo bwo kuyikoresha.

Gukorana na AutoSave Igenamiterere

Kugirango wirinde cyane gutakaza amakuru muri Excel, birasabwa gushiraho igenamiterere rya Autodry rya Autoshry rishobora kwerekeza neza kubyo ukeneye nubushobozi bwa sisitemu.

Isomo: Ijambo rya Microsoft

Jya kuri Igenamiterere

Reka tumenye uburyo bwo kwinjira mumagena autos.

  1. Fungura tab "dosiye". Ibikurikira, twimukira muri "parameter".
  2. Jya kuri Igenamiterere rya Microsoft Excel

  3. Idirishya rya Portl Excel rifungura. Kanda kurinditse kuruhande rwibumoso rwa "kuzigama". Hano niho igenamiterere ryose ukeneye ryashyizwe ahagaragara.

Jya Kubika igice cya Microsoft Excel

Guhindura igenamiterere ryigihe gito

Mburabuzi, ububiko bwimodoka bushoboka kandi bukorwa buri minota 10. Ntabwo abantu bose bahaza igihe. Nyuma ya byose, muminota 10 urashobora gutsinda amakuru menshi cyane kandi utifuzwa cyane kubatakaza hamwe nimbaraga nigihe cyakoreshejwe mukuzuza ameza. Kubwibyo, abakoresha benshi bahitamo gushyiraho uburyo bwo kubungabunga iminota 5, ndetse numunota 1.

Ni iminota 1 - igihe gito gishobora gushyirwaho. Muri icyo gihe, ntidukwiye kwibagirwa ko gahunda ya sisitemu ikoreshwa muburyo bwo kuzigama, kandi kuri mudasobwa zidakomeye, kwishyiriraho birashobora kuganisha ku gufatanya cyane mugihe cyihuta. Kubwibyo, abakoresha bafite ibikoresho bishaje bigwa mubindi bikabije - muri rusange bazimya ububiko bwimodoka. Nibyo, ntabwo ari byiza gukora, ariko, nyamara, tuzavugana nyuma, uburyo bwo guhagarika iyi mirimo. Kuri mudasobwa nyinshi zigezweho, nubwo washyizeho igihe cyumunota 1 - ntibizirikana bigira ingaruka kumikorere ya sisitemu.

Rero, guhindura ijambo muri "Autosave buri" murimabara yahuye numubare wifuzwa. Igomba kuba integer kandi murwego kuva 1 kugeza 120.

Imbaraga zo kubika imodoka muri Microsoft excel

Hindura izindi ntambwe

Byongeye kandi, mu gice cya Igenamiterere, urashobora guhindura undi mubare wibipimo, nubwo bitabagira inama nta kintu na kimwe cyo kubakoraho. Mbere ya byose, urashobora kumenya muburyo bwa dosiye buzakizwa. Ibi bikorwa muguhitamo izina ryamashya muburyo bukwiye muri "kubika dosiye mubikurikira". Mburabuzi, iyi ni igitabo cya Excel (Xlsx), ariko birashoboka guhindura uku kwagura ibi bikurikira:

  • Igitabo Excel 1993 - 2003 (XLSX);
  • Igitabo Cyiza cya Excel gifite inkunga ya macros;
  • Icyitegererezo;
  • Urupapuro (HTML);
  • Inyandiko yoroshye (txt);
  • CSV n'abandi benshi.

Imiterere yo kubungabunga muri Microsoft Excel

Muri "kataloge ya catalog", hashyizweho inzira aho moteri yizeko ya dosiye yabitswe. Niba ubishaka, iyi nzira irashobora guhinduka intoki.

Inzira igana kuri Catologue Kuri Auto-Kwishyiriraho muri Microsoft Excel

Ikibuga cya "Aho dosiye isanzwe" yerekana inzira igana ububiko aho gahunda isaba kubika dosiye zumwimerere. Nububiko bufungura mugihe ukanze kuri buto "Kubika".

Aho dosiye zamadosiye muburyo bwa Microsoft Excel

Hagarika imikorere

Nkuko bimaze kuvugwa haruguru, kopi yo gukiza byikora yibinyoma byingenzi birashobora guhagarikwa. Kugirango ukore ibi, birahagije gukuraho amatiku kuva kuri "autosave buri" kanda kuri buto ya "ok".

Hagarika ububiko bwimodoka muri Microsoft Excel

Ukwayo, urashobora guhagarika kuzigama mumodoka yanyuma ihagarara mugihe ufunze utazigamye. Kugirango ukore ibi, ukureho amatiku mubintu bihuye.

Guhagarika kopi yanyuma ya Microsoft Excel

Nkuko dushobora kubibona, muri rusange, igenamiterere ryimodoka muri gahunda ya Excel riroroshye, kandi ibikorwa byumvikana byimazeyo. Umukoresha ubwayo arashobora, kwizirikana ibyo akeneye nubushobozi bwibikoresho bya mudasobwa, shyira inshuro ya dosiye yikora yo kuzigama.

Soma byinshi