USU  ››  Mapulogalamu opangira mabizinesi  ››   ››   ›› 

Ikani Tchati mu Makhalidwe Owonetsedwa

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira sinthani font kuti muzipanga zokhazikika.

Ikani Tchati

Ndipo tsopano tiyeni mu module "Zogulitsa" za column "Kulipira" m’malo mosintha mtundu wa selo, tiyeni tiyese kuyika tchati chonsecho. Kuti tichite izi, timapita ku lamulo lomwe tikudziwa kale "Conditional Formating" .

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

Onetsani lamulo la ' Colour scale ' ndikudina batani la ' Sintha '.

Sankhani mawonekedwe apadera otchedwa ' Fotokozani ma cell onse kutengera zomwe amafunikira kudzera pagulu la data '.

Mukamagwiritsa ntchito izi, tchati chonse chidzawonekera pagawo losankhidwa, lomwe lidzasonyeze kufunikira kwa dongosolo lililonse. Kutalikira kwa tchati, m'pamenenso dongosololi ndi lofunika kwambiri.

Mitundu yosiyanasiyana ya tchati

Ndizotheka kusintha mawonekedwe a tchati.

Sikuti mungangosintha mtundu wa tchati, komanso mutha kupatsanso mtundu wosiyana pazolinga zoyipa.

Kwa ife, kubweza kwazinthu kudzawonetsedwa mumtundu wina.

Mtengo Wamtengo

Werengani za mtengo .

Onani pansipa mitu ina yothandiza:

• Mtengo Wamtengo
• Conditional Formating
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera