Momwe mungasinthire mizere ndi mizati mu Microsoft Excel

Mukamapanga mtundu uliwonse wa graph (kutengera zosintha), zowerengera zowerengera, zowunikira, kusaka pakati pamasamba osiyanasiyana, kufunafuna zowerengera ... kapena tebulo lomwe timafotokozera zomwe tikufuna kupanga, Microsoft Excel ndiye yankho labwino kwambiri pamsika lero. Ndipo pakadali pano, zipitilizabe kukhala zaka zambiri.

Ngakhale ndizowona kuti pamsika titha kupeza njira zosiyanasiyana zaulere kwathunthu, monga Libre Office kapena Apple Numeri, kuchuluka kwa magwiridwe antchito sikuli pafupi ndi omwe Excel amatipatsa. Kupanga matebulo mu Excel kuwasandutsa graph ndi njira yosavuta kwambiri. Bwanji ngati sitikonda zotsatira za graph? Njira yabwino kwambiri pankhaniyi ndikusinthana mizere ya mizati.

Ngakhale zitha kuwoneka zopusa, ngati titasintha zidziwitso za mizere ya mzati, graph yomwe ikutsatirayo ikhoza kukhala yosavuta kumva, osati kwa ife tokha, komanso kwa iwo omwe akuyenera kuwerenga chikalatacho. Zinthu zimatha kukhala zovuta, pomwe mizere ndi mizati ndiyokwera kwambiri, chifukwa zingatitengere nthawi yochuluka, pokhapokha titagwiritsa ntchito zomwe Excel amatipatsa kuti tizichita zokha.

  • Choyamba, tiyenera sankhani tebulo lomwe tikufuna kutembenuza mizere ndi mizati. Kuti tichite izi, tifunika kungodina mbewa pa selo yoyamba pomwe pamakhala maudindo azomwe tili ndi mzere ndi mzere womwe tikufuna kusinthana ndikusunthira patebulo lomaliza.
  • Chotsatira, timayang'ana pamwamba ndikusankha mbewa ndikudina kumanja kuti kutengera okhutira ndi zomatula.
  • Kenako, timapita kuchipinda komwe tikufuna kupanga tebulo latsopano lomwe mizere ndi mizati yasinthidwa ndipo timayika mbewa pomwe tikufuna kuti tebulo liyambire. Pakadali pano, tiyenera kupita pamwamba pa mndandanda wa Excel ndikudina pa katatu kotembenuzidwa kowonetsedwa pa batani la Matani. Njirayi imatipatsa zosankha zapadera zomwe pulogalamuyi ikutipatsa.
  • Kuti titha kunama zomwe zili, koma kusintha mizere ndi mizati, tiyenera kudina Sintha.

Ngati munayamba mwadzifunsapo chomwe kusankha kwa Transpose kunali, muli ndi yankho kale. Monga momwe tingathere pachithunzichi chomwe chikutsogolera nkhaniyi, ntchitoyi ndi yomwe ikuyang'anira kusunthika kwa mizati ndi mizere kuti izikhala sinthani magawidwe athu omwe tapanga.


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. Amafuna minda amalembedwa ndi *

*

*

  1. Wotsogolera pazosankhazi: Miguel Ángel Gatón
  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.