Momwe mungakonzekere gawo la Microsoft Excel ndi mzere

Konzani mizati ndi mizere ya Excel

Limodzi mwa mafunso omwe ogwiritsa ntchito amadzifunsa akamagwira ntchito ndi ma spreadsheet ndi momwe mungakonzekere bwino kwambiri. Osati ma column okha, komanso mizere ndi maselo. Funso limabuka makamaka mukamagwira ntchito ndi zochuluka zedi ndipo muyenera kubwerera mobwerezabwereza m'ndandanda / mzere / selo.

Nthawi zambiri zomwe timafuna kuti zizioneka nthawi zonse ndi mizati ndi mizere yomwe imakhala ndi mitu kapena mitu, ngakhale chinyengo ichi chitha kugwiritsidwanso ntchito ndi mizere ina ndi mizati (sikuyenera kukhala yoyamba).

Popanda kugwiritsa ntchito njira yokonzekera magawo a Excel, kugwira ntchito ndi ma spreadsheet kumatha kukhala pang'onopang'ono, kotopetsa, komanso pang'onopang'ono. Ngakhale kukhumudwitsa nthawi zina. Timakakamizidwa kugwiritsa ntchito mpukutu, kusuntha tsambalo m'mwamba ndi pansi kapena pansi, kuwononga nthawi yambiri. Ndipo nthawi ndi chinthu chomwe palibe amene ayenera kuyipulumutsa.

Chifukwa chake tikufotokozera momwe tingagwiritsire ntchito njira yosavuta imeneyi ndi mphamvu mwanjira imeneyi gwirani ntchito Excel m'njira yabwino kwambiri komanso yothandiza.

Konzani gawo mu Excel

Magwiridwe antchito okonzekera gawo la Excel ali pulogalamuyi kuyambira mtundu wake wa 2007. Chiyambi chake chinali chothandiza kwambiri kwa ogwiritsa ntchito omwe amagwiritsa ntchito ma spreadsheet akulu ndikusamalira zambiri. Ndipo ndi lero. Chinyengo chomwe chimakulitsa zokolola zathu.

Kuti igwire bwino ntchito, awa ndi magawo omwe muyenera kutsatira:

konzani gawo labwino kwambiri

Kudina pa "Onani" kutsegulira njira zitatu kuti muimitse mizati, mizere ndi mapanelo.

Choyamba, timadina pa tabu "Maso" yomwe imawonekera pamwamba pa spreadsheet, pomwe zida zonse zimawonetsedwa. Pamenepo tili ndi njira zitatu:

    • Sungani mzere wapamwamba. Pogwiritsa ntchito njirayi, mzere woyamba wa spreadsheet ndi "wachisanu", womwe umakhalabe wosasunthika komanso wowonekera tikadutsa mozungulira papepala.
    • Sungani gawo loyamba. Zimagwira ngati njira yapita, kusunga gawo loyamba la spreadsheet lokhazikika ndikuwoneka pomwe tikupita mozungulira kupyoza chikalatacho.
    • Amaundana mapanelo. Njirayi ndiyophatikiza ziwiri zapitazo. Zimatithandiza kupanga magawano potengera selo lomwe tidasankha kale. Ndiyomwe tiyenera kusankha ngati tikufuna kuundana kapena kukonza mizere ndi mizati nthawi yomweyo. Komanso zikakhala kuti mzere kapena mzere womwe tikufuna kukhazikitsa sikhala woyamba.

Kutengera ntchito yomwe mukuyenera kuchita, muyenera kusankha chimodzi mwanjira zitatuzi.

Mizere ndi mizati yomwe imakhala yotsimikizika imasiyanitsidwa ndi mzere wokulirapo wa khungu womwe umawazindikiritsa. Ndikofunikira kudziwa kuti kukonza mizati ya Excel (kapena mizere kapena mapanelo) ndichowonera. Mwanjira ina, mizere ndi mizati sizisintha mawonekedwe choyambirira mkati mwa spreadsheet yathu, amangowoneka owoneka kuti atithandizire.

Ntchitoyo ikamalizidwa, titha kubwerera "Tulutsani" mizere ndi mizere yozizira. Pachifukwachi, tidzayenera kulowanso zenera la «Onani» ndikuletsa njira yomwe tidasankha kale.

Gawani zenera mu Excel

Monga tawonera, cholinga chokhazikitsa mizati ya Excel sichina ayi koma kuthandizira kugwira ntchito ndi ma spreadsheet pogwiritsa ntchito chiwonetsero chomveka bwino komanso chosavuta cha chikalatacho. Koma ichi si chinyengo chokha chomwe chingatithandize. Kutengera mtundu wamakalata kapena ntchito, zitha kukhala zofunikira mwayi wogawaniza zenera la Excel.

Kodi ntchitoyi imakhala ndi chiyani? Kwenikweni ndikugawana chinsalu cha spreadsheet kuti pezani malingaliro osiyana a chikalata chimodzimodzi. Mwachitsanzo, pazenera limodzi titha kuwona gawo loyamba ndi zonse zomwe zili, pomwe titha kuwona pazenera lonse pazenera lachiwiri.

kugawanika chophimba kuposa

Chithunzi cha Excel chagawika pawiri

Tiyeni tiwone momwe njirayi ingagwiritsidwe ntchito mu Microsoft Excel:

  1. Chinthu choyamba kuchita ndi kupita, monga momwe munachitira kale, kupita ku tabu "Maso".
  2. Pamenepo muyenera kungosankha "Gawani". Chophimbacho chidzagawika m'magawo anayi.

Mwanjira imeneyi titha kupeza malingaliro anayi osiyana a chikalata chomwecho, kuti tigwire ntchito payekhapayekha. Ndipo popanda kugwiritsa ntchito mpukutu mobwerezabwereza kuti ayende pamwamba pake.

Ndipo ngati zowonetsera zinayi ndizochulukirapo (nthawi zina poyesera kupanga zinthu zosavuta kumatha kuzipangitsa kukhala zovuta kwambiri), pali njira zina Ingogwirani ntchito ndi chinsalu chogawika pawiri. Poterepa tiyenera kuchita izi:

  1. Tiyeni tibwerere ku "Maso", ngakhale nthawi ino tidasankha njira ya "Windo latsopano".
  2. Pakadali pano titha kusankha njira ziwiri: "Mawonekedwe ofanana" kapena ayi "Konzani zonse«. Pazonsezi, chinsalucho chidzawoneka m'magulu awiri, ngakhale ngati tasankha njira yachiwiri titha kusankha pakati pa mitundu ingapo yowonetsera: yopingasa, yowongoka, yosanja kapena yosunthika. Mwachikondi chathu.

Zomwe zili m'nkhaniyi zikutsatira mfundo zathu za malamulo okonzekera. Kuti mufotokoze cholakwika dinani Apa.

Khalani oyamba kuyankha

Siyani ndemanga yanu

Anu email sati lofalitsidwa.

*

*

  1. Wotsogolera pazidziwitso: Blog ya Actualidad
  2. Cholinga cha deta: Control SPAM, kasamalidwe ka ndemanga.
  3. Kukhazikitsa: Kuvomereza kwanu
  4. Kulumikizana kwa zomwe zafotokozedwazo: Zomwezo siziziwululidwa kwa anthu ena kupatula pakukakamizidwa mwalamulo.
  5. Zosunga: Zosungidwa ndi Occentus Networks (EU)
  6. Ufulu: Nthawi iliyonse mutha kuchepetsa, kuchira ndikuchotsa zidziwitso zanu.