Zamkatimu
Chifukwa chake, mwapanga buku lantchito mu Excel lodzaza ndi data. Yakonzedwa bwino, mfundo zake ndi zaposachedwa, masanjidwe ake ndi ndendende momwe amafunira. Munaganiza zosindikiza pepala la tebulo ili… ndipo zonse zidalakwika.
Maspredishiti a Excel samawoneka bwino nthawi zonse pamapepala chifukwa sanapangidwe kuti agwirizane ndi tsamba losindikizidwa. Amapangidwa kuti akhale aatali komanso otambalala momwe amafunikira. Izi ndi zabwino kusintha ndi kuonera pa zenera, koma ndi kovuta kusindikiza zikalata chifukwa deta si nthawi zonse bwino bwino pa pepala muyezo pepala.
Zovuta zonsezi sizikutanthauza kuti ndizosatheka kupanga Excel spreadsheet kuwoneka bwino pamapepala. Kwenikweni, sizovuta konse. Njira zisanu zotsatirazi zosindikizira mu Excel zidzakuthandizani kuthetsa vutoli. Onse ayenera kugwira ntchito mofanana mu Excel 5, 2007, ndi 2010.
1. Onani tsambalo musanasindikize
Ndi chida Sindikizani Zowonera (Zowoneratu) Mutha kuwona momwe tebulo lidzawonekera patsamba losindikizidwa. Pankhani yopulumutsa nthawi ndi pepala, Sindikizani Zowonera (Zowoneratu) ndiye chida chanu chachikulu chosindikizira. Mutha kusinthanso zina, monga kukokera malire osindikizira kuti akhale okulirapo kapena ocheperako. Gwiritsani ntchito chida ichi mutasintha zosindikiza zanu ndi masanjidwe anu kuti muwonetsetse kuti spreadsheet ikuwoneka momwe mukufunira.
2. Sankhani zomwe ziyenera kusindikizidwa
Ngati mukusowa gawo laling'ono la deta, musasindikize buku lonse la ntchito - sindikizani deta yosankhidwa. Mutha kusindikiza pepala lokha lomwe mukuliwona posankha pazokonda zosindikiza Sindikizani Mapepala Ogwira Ntchito (Sinthani mapepala omwe akugwira ntchito), kapena sankhani Sindikizani Buku Lonse la Ntchito (Sindikizani Bukhu Lonse) kuti musindikize fayilo yonse. Kuphatikiza apo, mutha kusindikiza gawo laling'ono la data yanu powonetsa malo omwe mukufuna ndikusankha Kusankha Kosindikiza (Sankhani zosindikiza) muzokonda zosindikiza.
3. Kwezani malo omwe alipo
Mumachepetsedwa ndi kukula kwa pepala lomwe mumasindikiza, koma pali njira zopezera zambiri m'dera lake. Yesani kusintha momwe tsamba limayendera. Mayendedwe okhazikika ndi abwino kwa data pomwe pali mizere yambiri kuposa mizere. Ngati tebulo lanu ndi lalikulu kuposa lalitali, sinthani tsambalo kuti likhale malo (malo). Mukufunabe malo ochulukirapo? Mukhoza kusintha m'lifupi mwake malire kuzungulira m'mphepete mwa tsamba. Zing'onozing'ono zimakhala, malo ochulukirapo amatsalira kwa deta. Pamapeto pake, ngati tebulo lanu silili lalikulu kwambiri, yesani kusewera ndi chida Mwambo Makulitsidwe Zosankha (Sikero) kuti igwirizane ndi mizere yonse kapena mizati yonse, kapena kuyika tebulo lonse papepala limodzi losindikizidwa.
4. Gwiritsani ntchito kusindikiza kwa mutu
Ngati tebulo liri ndi masamba opitilira tsamba limodzi, ndiye kuti zimakhala zovuta kumvetsetsa zomwe deta ikunena, chifukwa Excel imangosindikiza mitu yamizere patsamba loyamba mwachisawawa. Gulu Zindikirani Zolemba (Zolemba Zosindikiza) zimakulolani kusindikiza mitu ya mizere kapena mizere patsamba lililonse, kupangitsa kuti deta ikhale yosavuta kuwerenga.
5. Gwiritsani ntchito zodulira masamba
Ngati tebulo lili ndi pepala lopitilira pepala limodzi, timalimbikitsa kugwiritsa ntchito zodulira masamba kuti mudziwe ndendende zomwe zidzagwera papepala lililonse. Mukayika tsamba lopuma, zonse zomwe zili pansipa zimasiyanitsidwa ndi zonse zomwe zili pamwamba pa mpumulo ndikupita ku tsamba lotsatira. Izi ndizothandiza, chifukwa Mutha kugawanitsa deta momwe mukufunira.
Pogwiritsa ntchito zanzeru izi, mutha kupanga ma spreadsheets anu kukhala osavuta kuwerenga. Mupeza zambiri za njira zomwe zafotokozedwa pamwambapa m'maphunziro athu:
- Sindikizani gulu mu Microsoft Excel
- Khazikitsani malo osindikizira mu Excel
- Kukhazikitsa malire ndi sikelo mukasindikiza mu Excel