Excel ndi pulogalamu yochokera ku Excel Microsoft, yophatikizidwa mu phukusi la Office. Ndi pulogalamuyi ndizotheka kupanga ndi kupanga ma spreadsheets, oyimira pakati pa ena. Ndalama zoyendetsera mapulojekiti anu, kufalikira kwa ndalama, kusanthula kwazithunzi. Pakati pa ntchito zambiri zomwe zilipo, kupangidwa kwa mafomula kuti mawerengedwe azingochitika zokha kumayamikiridwa kwambiri. Zonse zokonzekera deta ndikukonzekera mitundu yosiyanasiyana ya ma chart.

Excel imagwiritsidwa ntchito pokonzekera, makamaka:

  • Bajeti, monga kupanga dongosolo la malonda mwachitsanzo;
  • Kuwerengera ndalama, ndikusintha njira zowerengera ndi ma accounting, monga kutuluka kwandalama ndi phindu;
  • Kupereka lipoti, kuyeza momwe polojekiti ikuyendera komanso kusanthula kusiyana kwa zotsatira;
  • Ma invoice ndi malonda. Poyang'anira malonda ndi ma invoice data, ndizotheka kulingalira mafomu osinthidwa ndi zosowa zenizeni;
  • Kukonzekera, kupanga ntchito zamaluso ndi mapulani, monga kafukufuku wamalonda pakati pa ena;

Kodi ntchito zoyambira za Excel ndi ziti:

  • Kupanga ma tebulo,
  • Kupanga mabuku ogwira ntchito,
  • Kupanga spreadsheet
  • Kulowetsa kwa data ndi kuwerengera zokha mu spreadsheet,
  • Kusindikiza pepala lothandizira.

Momwe mungapangire ntchito zina zoyambira mu Excel?

  1. Kupanga tebulo:

Dinani pa Njira Yatsopano ndiyeno sankhani ma templates omwe alipo, omwe angakhale: spreadsheet yopanda kanthu, ma templates osasintha kapena zatsopano zomwe zilipo kale.

Kuti mupange bukhu lantchito, dinani Fayilo kusankha (yomwe ili pamwamba), ndikutsatiridwa ndi Chatsopano. Sankhani Chopanda kanthu buku ntchito njira. Mudzawona kuti chikalatacho chili ndi mapepala a 3, podutsa ndi batani lamanja la mbewa, ndizotheka kuchotsa kapena kuyika mapepala ambiri momwe mungafunire.

  1. Ikani malire:

Choyamba sankhani selo, dinani pa Sankhani Zonse njira (yomwe ili pamwamba pa menyu), kenako sankhani kuchokera ku tabu Yanyumba, njira ya Font ndikusunthira pansi ku Borders njira, tsopano mukungofunika kusankha kalembedwe komwe mukufuna.

  1. Kusintha mtundu:

Sankhani cell yomwe mukufuna ndi mawu omwe mukufuna kusintha. Pitani ku Njira Yanyumba, Kachinthu kakang'ono ka Font, dinani Mtundu wa Font ndikutsatizana mu Mitundu Yamutu.

  1. Kuyanjanitsa mawu:

Sankhani maselo okhala ndi mawuwo, dinani Pakhomo, kenako dinani Kuyanjanitsa.

  1. Kugwiritsa ntchito shading:

Sankhani selo limene mukufuna kusintha, pitani pamwamba pa menyu ndikudina Kunyumba, kenako pagulu la Font, ndikudina Lembani Mtundu. Tsegulani njira ya Theme Colours ndikusankha mtundu womwe mumakonda.

  1. Zolemba za data:

Kuti mulowetse deta mu Excel spreadsheet, ingosankhani selo ndikulemba zambiri, kenako dinani ENTER kapena, ngati mukufuna, sankhani kiyi ya TAB kuti mupite ku selo lotsatira. Kuti muyike deta yatsopano pamzere wina, dinani kuphatikiza ALT+ENTER.

  1. Kuti muwoneke:

Pambuyo polowetsa zidziwitso zonse, kupanga mawonekedwe a spreadsheet ndi zithunzi m'njira yomwe mukufuna, tiyeni tipitirize kusindikiza chikalatacho. Kuti musindikize spreadsheet, sankhani foni yoti muwonetse. Dinani pamwamba menyu "Fayilo" ndiyeno dinani Sindikizani. Ngati mukufuna, gwiritsani ntchito njira yachidule ya kiyibodi, ndi CTRL+P.

Pomaliza

Ngati mukufuna kudziwa zambiri za kugwiritsa ntchito pulogalamu ya Excel work, musazengereze kudziphunzitsa kwaulere mavidiyo akatswiri patsamba lathu.