USU  ››  Mapulogalamu opangira mabizinesi  ››  Pulogalamu yachipatala  ››  Malangizo a pulogalamu yachipatala  ›› 

Pezani zobwereza muzambiri

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa tidawona momwe tingamangire mavoti abwino kapena oyipa kwambiri.

Mukufuna kupeza zobwereza muzambiri? Tsopano mutha kuphunzira momwe mungapezere zobwerezedwa kapena zofunikira zapadera mu pulogalamuyi.

Makhalidwe apadera

Tiyeni titsegule module "Maulendo" .

Tsopano ife basi kusankha pulayimale "odwala" amene anabwera kudzaonana ndi dokotala koyamba. Kuti tichite izi, timapita ku lamulo lomwe tikudziwa kale "Conditional Formating" .

Chonde werengani chifukwa chake simungathe kuwerenga malangizowo mofanana ndikugwira ntchito pawindo lomwe likuwonekera.

Ngati mukadali ndi malamulo okonza kuchokera ku zitsanzo zam'mbuyomu, chotsani onse.

Kenako onjezani lamulo latsopano la masanjidwe a data pogwiritsa ntchito batani la ' Chatsopano '.

Kenako, sankhani mtengo wa ' Format unique values only ' pamndandanda. Kenako dinani batani la ' Format ' ndikupanga font kukhala yolimba mtima.

Ikani masitayilo awa pagawo la ' Wodwala '.

Zotsatira zake, tidzawona odwala oyambirira. Izi zidzakhala zolemba za nthawi yosankhidwa, zomwe zikuwonetsedwa pamndandanda kamodzi kokha.

Kuwunikira kobwereza

Momwemonso, mutha kupeza zobwereza zonse. Tiyeni tiwonetsere mumitundu yosiyana mayina a odwala omwe amapezeka pamndandanda wa maulendo angapo. Kuti muchite izi, onjezani mawonekedwe atsopano.

Zosintha zonse ziwiri ziyenera kugwiritsidwa ntchito pagawo lomwelo.

Tsopano pamndandanda wa maulendo, odwala athu okhazikika amawonetsedwa mumtundu wobiriwira wobiriwira.

Dziwani ngati zobwereza zikuloledwa m'magawo akuluakulu.

Onani pansipa mitu ina yothandiza:

• Kodi zobwerezedwa zingalowe?
• Makhalidwe abwino
• Onetsani Mfundo Zofunika Kwambiri
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera