Momwe mungasinthire kuyika mu Excel: 3 Njira Zosavuta

Pofuna kusintha malembawo, ogwiritsa ntchito omwe amagwira ntchito asakatuli, olemba ndi mapurosure nthawi zambiri amakumana. Komabe, pogwira ntchito patebulo labwino, zosowa ngati izi zithanso kuchitika, chifukwa pulogalamuyi sikuti ndi manambala okha, komanso lembalo. Tiyeni tiwone momwe mungasinthire kuyika.

Phunziro: Kukhazikitsa mu Microsoft Mawu

Gwirani ntchito ndi zolemba

Kulemba mawu - gawo ili la ma digito yamagetsi omwe amasinthidwa kukhala omveka kwa ogwiritsa ntchito. Pali mitundu yambiri ya malo, iliyonse yomwe ili ndi malamulo akeake ndi chilankhulo. Luso la pulogalamuyo kuzindikira chilankhulo chake ndikumasulira zomveka kwa anthu wamba (makalata, zilembo zina) zimasankha ngati pulogalamuyi kapena ayi. Mwa zina mwa zolemba zodziwika bwino ziyenera kugawidwa motere:

• Windows-551;
• Koi-8;
• ASCII;
• ANSI;
• UK-2;
• UTF-8 (Unicode).

Dzina lomaliza ndilofala kwambiri pakati pa anthu padziko lapansi, chifukwa limawonedwa ngati mtundu wa muyezo wa chilichonse.

Nthawi zambiri, pulogalamuyo imadziwirapo malo osungirako ndipo nthawi zina wogwiritsa ntchito ayenera kutanthauza mawonekedwe ake. Pokhapokha zitha kugwira ntchito molondola ndi zizindikilo zazolemba.

Excel ili ndi chiwerengero chachikulu chokhudza zovuta ndi pulogalamu ya Excel pomwe mumayesa kutsegula mafayilo a CSV kapena mafayilo apamatumbo. Nthawi zambiri, m'malo mwa zilembo wamba mukamatsegula mafayilo awa kudzera mu Excel, titha kuona anthu osamveka, omwe amatchedwa "crakozyry". Muzochitika izi, wogwiritsa ntchito ayenera kupanga zolakwa zina kuti pulogalamuyo iyambe kukonza. Pali njira zingapo zothetsera vutoli.

Njira 1: Sinthani malo ogwiritsira ntchito nopate ++

Tsoka ilo, chida chodzala ndi mbiri yonse chomwe chingakuloreni kuti musinthe mu malembedwe amtundu uliwonse kuchokera ku Excel. Chifukwa chake, ndikofunikira kugwiritsa ntchito njira zingapo zothetsera izi kapena kukonzanso thandizo lachitatu. Njira imodzi yodalirika kwambiri ndikugwiritsa ntchito mkonzi wa Asana.

1. Thamangani ntchito ya nopapd ++. Dinani pa fayilo "fayilo". Kuchokera pamndandanda woyamba, sankhani "chotseguka". Monga njira ina, mutha kuyimba vtrl + o kiyibodi yanu pa kiyibodi.



2. Zenera lotseguka limayamba. Pitani ku chikwangwani komwe chikalatacho chilipo, chomwe chimawonetsedwa molakwika. Tikuunikira ndikudina batani "lotseguka" pansi pazenera.



3. Fayilo imatseguka pazenera la Notepad ++. Pansi pa zenera kumanja kwa chingwe cha mawonekedwe adawonetsa kuti zalembedwa. Popeza Excels imawonetsa molakwika, ikufunika kusintha. Timalemba ctrl + kuphatikiza kwakukulu pa kiyibodi kuti muwonetsetse mawu onsewo. Dinani pa "Sexding" ya "Mndandanda". Pa mndandanda womwe umatseguka, sankhani "kusintha kwa UTF-8". Uku ndikuphatikizira kwa Unicode komanso ndi ntchito zake zapamwamba molondola momwe mungathere.



4. Pambuyo pake, kupulumutsa zosintha mu fayilo ndikuwombera batani pa chipangizo cha Floppy disk. Tsekani Notepad ++ podina batani ngati mtanda woyera m'Garadi yofiyira pakona yakumanja ya zenera.



5. Tsegulani fayiloyo ndi njira yokhazikika kudzera pa wochititsa kapena kugwiritsa ntchito njira ina iliyonse mu pulogalamu ya Excel. Monga mukuwonera, zilembo zonse tsopano zikuwonetsedwa molondola.

Ngakhale kuti njirayi imakhazikitsidwa pakugwiritsa ntchito pulogalamu ya gulu lachitatu, ndi njira imodzi yosavuta yosinthira zomwe zili mu mafayilo a mafayilo.

Njira 2: Kugwiritsa ntchito kwa Wizard

Kuphatikiza apo, mutha kutembenuka ndikugwiritsa ntchito zida zomangamanga, ndiye kuti ma ngwazi. Zokwanira mokwanira, kugwiritsa ntchito chida ichi kumakhala kovuta kwambiri kuposa kugwiritsa ntchito pulogalamu ya gulu lachitatu lomwe tafotokozazi.

1. Yangani pulogalamu yapamwamba. Ndikofunikira kukhazikitsa ntchitoyo yokhayo, osatsegula chikalatacho. Ndiye kuti, muyenera kuwoneka pepala lopanda kanthu. Pitani ku "deta" tabu. Dinani batani pa tepi ya "kuchokera pa tepi ya" kuchokera pa tepi ", yomwe idayikidwa mu" chida cha "chida chakunja.



2. Zenera lolowera mafayilo limatsegulidwa. Imathandizira kutsegulidwa kwa mafomu otsatirawa:
   • NDILEMBERENI;
   • CSV;
   • Prn.

   Pitani ku chikwangwani cha malo omwe mungatumize ndi kudina ndikudina batani la "Log Long".



3. Zenera la Wizard limatseguka. Monga tikuwonera, mu munda wachiwonetsero, zilembozo zikuwonetsedwa molakwika. Mu "Fomu ya Fayilo", timawululira mndandanda wotsika ndikusintha malo "Unicode (Utf-8)" Mmenemo.

   

   Ngati deta ikuwonetsedwa, ndizolakwika molakwika, ndiye yesani kuyesa kugwiritsa ntchito malo ena mpaka mawu omwe ali mu gawo lowonetsera ndiowerengera. Zotsatira zake zikadzakukhutiritsa, dinani batani "lotsatira".



4. Zenera lotsatira la Wizard limatsegula. Apa mutha kusintha chizindikiro, koma tikulimbikitsidwa kusiya zosintha (chizindikiro cha tabu). Dinani pa batani "lotsatira".



5. Zenera lomaliza limatha kusintha mawonekedwe a data:
   • General;
   • Zolemba;
   • Tsiku;
   • Kudumpha.

   Apa zosintha ziyenera kukhazikitsidwa, kupatsidwa chikhalidwe cha zomwe zidakonzedwa. Pambuyo pake, timakanikiza batani "kumaliza".



6. Pawindo lotsatira, tchulani magwiridwe antchito a kumanzere kwa mzere pa pepala pomwe deta iyikidwa. Izi zitha kuchitika poyendetsa ndege pamanja mu gawo loyenerera kapena kungowonetsa khungu lomwe lingafune papepala. Pambuyo pazogwirizanazo zimawonjezeredwa, m'munda wa zenera, dinani batani la "OK".



7. Pambuyo pake, lembalo lidzawonekera pa pepalalo lomwe tikufuna. Imangoyimitsa kapena kubwezeretsa kapangidwe ka tebulo, ngati inali data yazamanthu, chifukwa imawonongedwa mukamayambiranso.

Njira 3: Kusunga fayilo mu gawo linalake

Palinso zinthu zosinthana pomwe fayilo siyenera kutsegulidwa ndi chiwonetsero cholondola cha data, ndikusunga mu malo oyikidwa. Kupambana, mutha kugwira ntchito imeneyi.

1. Pitani ku "fayilo" tabu. Dinani pa "Sungani monga".



2. Zenera lopulumutsa chikalata limatseguka. Kugwiritsa ntchito mawonekedwe a wochititsa, timatanthauzira chikwatu chomwe fayilo idzasungidwa. Kenako yambitsani mtundu wa fayilo ngati tikufuna kupulumutsa bukuli mu mawonekedwe osiyana ndi mtundu wa vollul Excel (xlsx). Kenako ndimadina pa gawo la "ntchito" ndi mndandanda womwe umatsegulira, sankhani "zolemba za intaneti".



3. Pazenera lomwe limatsegula tabu ya "polemba". Mu "kusunga chikalata ngati" munda, tsegulani mndandanda wotsika ndikukhazikitsa mtundu wa malo omwe takambirana pamndandanda, zomwe tikuwona kuti ndizofunikira. Pambuyo pake, dinani batani la "OK".
4. Kubwerera ku "Chikalata Sungani" Windows Ndipo apa tadina batani la "Sungani".

Chikalatacho chidzasungidwa pa disk hards kapena disturic poyambira momwe mwatchulira. Koma muyenera kuganizira kuti tsopano zolembedwa nthawi zonse zimasungidwa mu Excel adzapulumutsidwa pokonzekera izi. Kuti musinthe izi, muyenera kupita ku "Chikalata" cha "Zilembo" ndikusintha makonda.

Pali njira ina yosinthira makonda a zolemba zosungidwa.

1. Kukhala mu "fayilo" tabu, dinani pa "magawo".



2. Khomo lazowonjezera lambiri limatseguka. Sankhani subparaph "kuwonjezera" pamndandanda womwe uli kumanzere kwa zenera. Gawo lalikulu lazenera likuyenda mpaka ku "General" makonda. Apa dinani batani la "Webusayiti ya Webusayiti".



3. "Zolemba za chikalata" zolembedwa "zimatsegulidwa, komwe tikuchita zomwezo zomwe adalankhula kale.

Tsopano chikalata chilichonse chosungidwa mu Excel chikhala nacho ndendende zomwe mwayikapo.

Monga mukuwonera, Excel alibe chida chomwe chingakulolezeni mwachangu komanso mosavuta kuchokera kwa wina. Master of the mbuyeyo ali ndi magwiridwe antchito ndipo ali ndi mwayi wambiri womwe sufunika kutengera motere. Kugwiritsa ntchito, muyenera kudutsa masitepe ochepa, komwe pamachitidwe awa sikukhudza, ndikuthandizira zolinga zina. Ngakhale kutembenuka kudzera mkonzi wachitatu-wachitatu wa Idepad ++ pankhaniyi kumawoneka kosavuta. Kusunga mafayilo mu nthawi yomwe ikuperekedwa mu njira yowonjezera yowonjezera ndikuti nthawi iliyonse mukafuna kusintha izi, muyenera kusintha makonda a pulogalamuyi.