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

Gwiritsani ntchito ma chart kuti muwonekere

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira sinthani font kuti musinthe zokhazikika. Ndipo zasintha kale maziko a cell kuti awonetse makasitomala omwe amalipira kwambiri.

Ikani Tchati

Tsopano tiyeni tiyese kugwiritsa ntchito tchati kuti tiwone bwino zomwe zili patebulo zomwe ndizosiyana. Kuti muchite izi, dinani pa module "Odwala" za column "Ndalama zonse zomwe zagwiritsidwa ntchito" 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 ' Fomati ma cell onse kutengera zomwe amafunikira kudzera pagulu la data '.

Mukamagwiritsa ntchito izi, tchati chathunthu chidzawonekera pagawo losankhidwa, lomwe likuwonetsa kuchuluka kwa ndalama zomwe kasitomala aliyense wasiya ku chipatala chanu kuposa odwala ena.

Kutalikira kwa tchati, m'pamenenso wofuna chithandizo amakhala wofunikira kwambiri ku chipatala.

Mitundu yosiyanasiyana ya tchati

Ndizotheka kusintha mawonekedwe a tchati.

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

Kwa ife, odwala omwe chipatalacho adabwezera ndalama zambiri kuposa zomwe adatenga ngati malipiro a ntchito adzawonetsedwa mumtundu wina. Mwachitsanzo, izi zikhoza kuchitika pamene ndalama zolipiridwa zowonongeka zimakhala zazikulu kuposa mtengo wa utumiki womwewo.

Mtengo Wamtengo

Werengani za Makhalidwe abwino .

Onani pansipa mitu ina yothandiza:

• Makhalidwe abwino
• Onetsani Mfundo Zofunika Kwambiri
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera