USU  ››  Mapulogalamu opangira mabizinesi  ››  Dongosolo la shopu  ››  Malangizo a pulogalamu ya sitolo  ›› 

Pezani zamtengo wapatali kapena zobwereza

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa tidawona momwe tingamangire mlingo wa zabwino kapena zoipa.

Makhalidwe apadera

Tsopano tiyeni tilowe "Zogulitsa" sankhani zokhazo "ogula" amene agula katundu kwa ife kwa nthawi yoyamba. 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 kuzitsanzo zam'mbuyomu, chotsani onse. Kenako onjezani yatsopano 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 ' Customer '.

Zotsatira zake, tidzawona makasitomala oyambirira. Makasitomala atsopano omwe amagula chinthu kuchokera kwa ife kwa nthawi yoyamba adzaonekera.

Kuwunikira kobwereza

Momwemonso, mutha kupeza zobwereza zonse. Tiyeni tiwunikire mumitundu yosiyana mayina amakasitomala omwe agula katundu kwa ife kangapo. Kuti muchite izi, onjezani mawonekedwe atsopano.

Zosintha zonse ziwiri ziyenera kugwiritsidwa ntchito pagawo lomwelo.

Tsopano pamndandanda wazogulitsa, makasitomala athu okhazikika amawonetsedwa mumtundu wobiriwira wobiriwira.

Dziwani ngati zobwereza zikuloledwa m'magawo akuluakulu.

Onani pansipa mitu ina yothandiza:

• Kodi zobwereza zimaloledwa?
• Mtengo Wamtengo
• Conditional Formating
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera