Lembani Pangani ku Microsoft Excel

Mwinamwake, ambiri ogwiritsa ntchito osadziwa zambiri amayesa kukopera deta ku Excel, koma chifukwa cha zochita zawo, zomwe zinapangidwa zimapangidwa kukhala zosiyana kwambiri kapena zolakwika. Izi ndizo chifukwa chakuti mawonekedwewa anali muzoyambirira zolemba, ndipo ndiyi njirayi yomwe inayikidwa, osati mtengo. Mavuto ngati amenewa akanatha kupezeka ngati ogwiritsira ntchitowa akudziŵa bwino lingaliro lotero "Sakani Mwapadera". Ndicho, mungathe kuchita zina zambiri, kuphatikizapo masamu. Tiyeni tiwone chomwe chida ichi ndi momwe mungagwirire nazo.

Gwiritsani ntchito papepala yapadera

Sakanizani Mwapadera makamaka cholinga choyikapo mawu ena pa pepala la Excel monga momwe likufunira ndi wogwiritsa ntchito. Pogwiritsira ntchito chida ichi, simungatenge deta zonse zomwe zasindikizidwa mu selo, koma zokhazokha (malingaliro, maonekedwe, mawonekedwe, ndi zina zotero). Kuwonjezera apo, pogwiritsa ntchito zipangizo, mukhoza kupanga masamu opangira (kuwonjezerapo, kuchulukitsa, kuchotsa ndi kugawa), komanso kutumizira tebulo, ndiko kuti, kusinthana mizere ndi mizere mkati mwake.

Pofuna kupita ku malo apadera, choyamba, muyenera kuchita zomwe mukujambula.

  1. Sankhani selo kapena maulendo omwe mukufuna kuwatsanzira. Sankhani ndi chithunzithunzi pamene mukukhala pansi pa batani lamanzere. Dinani kusankhidwa ndi batani lamanja la mouse. Menyu ya nkhaniyi imayikidwa, yomwe muyenera kusankha chinthucho "Kopani".

    Ndiponso, mmalo mwa ndondomeko yapamwambayi, mukhoza, pokhala pa tab "Kunyumba", dinani pazithunzi "Kopani"yomwe imayikidwa pa tepi mu gulu "Zokongoletsera".

    Mukhoza kujambula mawu powasankha ndikulemba kuphatikiza mafungulo otentha Ctrl + C.

  2. Kuti mupite mwatsatanetsatane, sankhani malo pa pepala limene tikukonzekera kusonkhanitsa zinthu zomwe tajambula kale. Dinani kusankhidwa ndi batani lamanja la mouse. Muzondomeko zomwe zakhala zikuyambidwa, sankhani malo "Kuika Mwapadera ...". Pambuyo pake, mndandanda wowonjezera umatsegulira momwe mungasankhire mitundu yosiyanasiyana ya zochita, ogawidwa m'magulu atatu:
    • Ikani (Sakanizani, Kutumiza, Mafomu, Mafomu ndi Zopanga Nambala, Zopanda malire, Sungani Zithunzi Zachiyambi Zowonjezera, ndi Kusunga Fomu Yoyamba);
    • Ikani malonda ("Phindu ndi maonekedwe oyambirira", "Makhalidwe" ndi "Makhalidwe ndi maonekedwe a manambala");
    • Zina zosungira zosankha ("Kupanga", "Chithunzi", "Ikani Link" ndi "Linked Picture").

    Monga momwe mukuonera, zipangizo za gulu loyamba zimasindikiza mawu omwe ali mu selo kapena mtundu. Gulu lachiwiri likukonzekera, choyamba, pofuna kukopera zoyenera, osati malemba. Gulu lachitatu limapanga kusintha kwa maonekedwe ndi maonekedwe.

  3. Kuonjezera apo, muzinthu zoonjezera zomwezo pali chinthu china chomwe chiri ndi dzina lomwelo - "Kuika Mwapadera ...".

  4. Mukadutsamo, mawonekedwe osiyana omwe akuwonekera amatsegula ndi zipangizo zomwe zigawidwa m'magulu akulu awiri: Sakanizani ndi "Ntchito". Zotsatira zake, chifukwa cha zida za gulu lomaliza, ndizotheka kuchita masamu, zomwe takambirana pamwambapa. Kuonjezerapo, pawindo ili muli zinthu ziwiri zomwe sizikuphatikizidwa m'magulu osiyana: "Sungani maselo opanda kanthu" ndi "Kutumiza".

  5. Kuyika kwapadela sikungapezeke kokha kupyolera mndandanda wamakono, komanso kupyolera mu zipangizo zomwe zili pa riboni. Kuti muchite izi, pokhala pa tab "Kunyumba", dinani pa chithunzicho mwa mawonekedwe a katatu wotsika pansi, omwe ali pansi pa batani Sakanizani mu gulu "Zokongoletsera". Ndiye mndandanda wa zochitika zotheka kumatsegulidwa, kuphatikizapo kusintha kwawindo losiyana.

Njira 1: Gwiritsani ntchito Makhalidwe

Ngati mukufunikira kusinthitsa miyeso ya maselo, zotsatira zake zimachokera pogwiritsa ntchito machitidwe okhwima, kenaka kuika kwapadera kumapangidwira pazomwezo. Ngati mumagwiritsa ntchito zojambulazo, chiwerengerocho chidzakopedwa, ndipo mtengo umene umapezeka mmenemo sungakhale umene mukuufuna.

  1. Kuti mutengere makhalidwe, sankhani mtundu umene uli ndi zotsatira za kuwerengera. Lembani izo mwa njira iliyonse yomwe tinayankhulira pamwambapa: mndandanda wa masewero, batani pa riboni, kuphatikiza mafungulo otentha.

  2. Sankhani malo pa pepala kumene tikukonzekera kuyika deta. Pitani ku menyu mwa njira imodzi, yomwe takambirana pamwambapa. Mu chipika "Ikani malonda" sankhani malo "Makhalidwe ndi Mapangidwe A Nambala". Chinthuchi ndi choyenera kwambiri pazimenezi.

    Njira yomweyi ingagwiridwe kudzera pawindo lomwe tanena kale. Pankhaniyi, mu chipika Sakanizani Sinthani ku malo "Makhalidwe ndi Mapangidwe A Nambala" ndi kukankhira batani "Chabwino".

  3. Mulimonse momwe mungasankhire, deta idzasamutsira kumtundu wosankhidwa. Idzawonetsedwa ndondomeko yake popanda kusamutsidwa kwa ma formula.

Phunziro: Mmene mungachotsedwe mu Excel

Njira 2: Lembani Zopangira

Koma palinso zosiyana pamene kuli kofunika kufotokoza mawonekedwe.

  1. Pankhaniyi, timachita zokopera m'njira iliyonse yomwe ilipo.
  2. Pambuyo pake, sankhani malo pa pepala pamene mukufuna kuyika tebulo kapena deta ina. Gwiritsani ntchito mndandanda wa masewerawa ndikusankha chinthucho "Maonekedwe". Pachifukwa ichi, zokhazokha ndi zowonjezera zidzalowetsedwa (m'maselo omwe mulibe njira), koma kupanga ndi kusintha kwa mawonekedwe a nambala kudzatayika. Choncho, mwachitsanzo, ngati mtundu wa tsikulo uli pa gwero la chitsime, ndiye mutatha kulijambula mudzawonetsedwa molakwika. Selo lofananirana liyenera kupangidwanso.

    Pawindo, zotsatirazi zikufanana ndi kusunthitsa kasinthasintha ku malo "Maonekedwe".

Koma n'zotheka kutumiza mazenera ndi kusunga mtundu wa nambala kapena ngakhale kusungidwa koyambirira koyambirira.

  1. Poyambirira, mu menyu, sankhani malo Mafomu ndi Zopanga Nambala.

    Ngati opaleshoniyi ikuchitidwa kudzera pawindo, ndiye kuti mukuyenera kusintha kusinthana Mafomu ndi Zopanga Nambala ndiye pankani batani "Chabwino".

  2. Pachifukwa chachiwiri, pamene mukufunikira kusunga malemba komanso mafomu a nambala, komanso mawonekedwe onse, sankhani chinthucho mndandanda "Sungani Mafomu Oyamba".

    Ngati wogwiritsa ntchitoyo asankha kugwira ntchitoyi podutsa pawindo, ndiye kuti mukuyenera kusintha kusinthana kwake "Ndi mutu wapachiyambi" ndi kukankhira batani "Chabwino".

Njira 3: kutumiza mawonekedwe

Ngati wogwiritsa ntchito sayenera kutumiza deta, ndipo akungofuna kutengera tebuloyo kuti adziwe zambirizo, ndiye kuti mungagwiritse ntchito chinthu china chapadera.

  1. Lembani tebulo loyambira.

  2. Pa pepala, sankhani dera limene tikufuna kuyika chigawo cha tebulo. Lembani menyu yachidule. Muli mu gawoli "Njira Zina Zowonjezera" sankhani chinthu "Kupanga".

    Ngati ndondomekoyi ikuchitidwa kudzera pawindo, ndiye kuti pachochitika ichi, yesani kusinthasintha "Zopanga" ndipo dinani pa batani "Chabwino".

  3. Monga mukuonera, zitatha izi pali kusuntha kwa chigawo cha gwero la magwero ndi mawonekedwe osungidwa, koma mwamtheradi sizodzazidwa ndi deta.

Njira 4: Lembani tebuloyi pokhala ndi kukula kwazitsulo

Si chinsinsi kuti ngati timapanga tebulo losavuta, sikuti maselo onse a tebulo latsopano adzatha kukhala ndi chidziwitso chonse m'kamwa. Kuti mukonze vutoli pamene mukujambula, mungagwiritsenso ntchito mwapadera.

  1. Choyamba, mwa njira iliyonse yapamwambayi, lembani tebulo la gwero.
  2. Titatha kulumikiza menyu omwe tidziwa kale, timasankha mtengo "Sungani m'lifupi la zikhomo zoyambirira".

    Mchitidwe wofananowu ukhoza kuchitidwa kupyolera muwindo wapadera wowonjezera. Kuti muchite izi, konzekerani kusintha kwa malo "M'lifupi". Pambuyo pake, monga nthawi zonse, dinani pakani. "Chabwino".

  3. Tebulo yayikidwa ndi chiyambi chapakati chalitali.

Njira 5: Ikani Chithunzi

Chifukwa cha kuika kwapadera, mungathe kukopera deta iliyonse yomwe ili pa pepala, kuphatikizapo tebulo, ngati chithunzi.

  1. Lembani chinthucho pogwiritsa ntchito zida zamakono.

  2. Sankhani malo pa pepala pomwe zojambula ziyenera kuikidwa. Imani menyu. Sankhani chinthu mmenemo "Kujambula" kapena "Zojambula zofanana". Pachiyambi choyamba, chithunzi chojambulidwa sichidzaphatikizidwa ndi gome la gwero. Pachiwiri chachiwiri, ngati zoyenera kusintha patebulo, zojambulazo zidzasinthidwa.

Muwindo wapadera wowonjezera, opaleshoni yoteroyo siingakhoze kuchitidwa.

Njira 6: Kulemba Mfundo

Kupyolera muyilo yapadera, mungathe kukopera mwamsanga makalata.

  1. Sankhani maselo omwe ali ndi zolemba. Timapanga zojambulazo pogwiritsa ntchito makasitomala ozungulira, pogwiritsa ntchito batani pamzere kapena pogwiritsa ntchito makiyi Ctrl + C.

  2. Sankhani maselo omwe makalata ayenera kuikidwa. Pitani kuwindo lapadera loyikapo.

  3. Pawindo lomwe limatsegulira, yongolani kusintha kwa malo "Mfundo". Timakanikiza batani "Chabwino".

  4. Pambuyo pake, zolembazo zidzakopedwa ku maselo osankhidwa, ndipo zina zonsezi sizidzasintha.

Njira 7: tumizani tebulo

Pogwiritsira ntchito ndondomeko yapaderayi, mutha kuwongolera matebulo, matrices, ndi zinthu zina zomwe mukufuna kusinthasintha mizere ndi mizere.

  1. Sankhani tebulo limene mukufuna kufotokozera, ndi kulikopera pogwiritsa ntchito njira zomwe tidziwa kale.

  2. Sankhani pa pepala loyandikana ndi momwe mukufuna kukhazikitsa ndondomeko ya tebulo. Gwiritsani ntchito mndandanda wa masewerawa ndikusankha chinthucho. "Kutumiza".

    Opaleshoniyi iyeneranso kuchitidwa pogwiritsa ntchito zenera. Pankhaniyi, muyenera kuyika bokosi "Kutumiza" ndi kukankhira batani "Chabwino".

  3. Ndipotu, ndipo panthawi ina, zotsatira zake zidzakhala tebulo losasinthika, ndiko kuti, tebulo limene mazati ndi mizere yayendetsedwa.

Phunziro: Momwe mungapangire tebulo mu Excel

Njira 8: Gwiritsani ntchito Arithmetic

Pogwiritsira ntchito chida chimene tafotokozedwa ku Excel, mungathe kuchita masewera olimbitsa thupi:

  • Kuwonjezera;
  • Kuwonjezeka;
  • Kuchotsa;
  • Gawani

Tiyeni tiwone momwe chida ichi chikugwiritsidwira ntchito pa chitsanzo cha kuchulukitsa.

  1. Choyamba, timalowa mu selo lopanda kanthu nambala yomwe timakonzekera kuchulukitsa deta yambiri ndi choyikapo chapadera. Chotsatira, timachijambula. Izi zikhoza kuchitika pakukakamiza kuphatikizira Ctrl + C, poyitanitsa mndandanda wamakono kapena kugwiritsa ntchito zida zogwiritsira ntchito tepi.

  2. Sankhani zolemba pa pepala, zomwe tiyenera kuzichulukitsa. Dinani kusankhidwa ndi batani lamanja la mouse. Muzitsegulo zotseguka, dinani kawiri pazinthu. "Kuika Mwapadera ...".

  3. Zenera zatsekedwa. Mu gulu la magawo "Ntchito" ikani kasinthasintha kuti muyime "Pitirizani". Kenako, dinani pakani "Chabwino".

  4. Monga momwe mukuonera, mutatha izi zonse ziwerengero za mtundu wosankhidwa zinachulukitsidwa ndi chiwerengero chokopedwa. Kwa ife, nambala iyi 10.

Mfundo yomweyi ingagwiritsidwe ntchito kugawanitsa, kuwonjezera ndi kuchotsa. Pokhapokha, padzakhala koyenera kuti musinthe mawindo pawindo Apatukani, "Dulani" kapena "Chotsani". Apo ayi, zochita zonse zimakhala zofanana ndi zomwe tafotokoza pamwambapa.

Monga mukuonera, choyika chapadera ndi chida chothandiza kwa wogwiritsa ntchito. Pachifukwachi, simungathe kujambula zonse zopezera deta mu selo kapena zosiyana, koma mwa kuzigawa mu zigawo zosiyana (malingaliro, maonekedwe, maonekedwe, ndi zina zotero). Komanso, n'zotheka kuphatikiza zigawo izi. Kuphatikiza apo, machitidwe a masamu akhoza kuchitidwa pogwiritsira ntchito chida chomwecho. Zoonadi, kupeza maluso ogwira ntchito ndi lusoli kumathandiza kwambiri anthu ogwiritsa ntchito njira yophunzirira Excel lonse.

Posts Popular

https://termotools.com ny.termotools.com © Excel 2024