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

Onetsani mtundu wakumbuyo

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira kale momwe tingagwiritsire ntchito kusanjidwa koyenera ndi zithunzi.

Gradient pogwiritsa ntchito mitundu iwiri

Ndipo tsopano tiyeni mu module "Odwala" sankhani anthu osungunulira kwambiri pogwiritsa ntchito gradient. Pulogalamuyi itithandiza kuwunikira zinthu zina ndi mtundu wakumbuyo. Kuti tichite izi, timagwiritsa ntchito lamulo lodziwika kale "Conditional Formating" .

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

Pazenera lomwe likuwoneka, chikhalidwe cham'mbuyo cha masanjidwe a data chikhoza kuwonjezedwa. Ngati ndi choncho, dinani batani la ' Sintha '. Ndipo ngati palibe zikhalidwe, ndiye dinani ' Chatsopano ' batani.

Kenako, pamndandanda wazotsatira zapadera, choyamba sankhani mtengo ' Mangani ma cell onse kutengera zomwe ali nawo kudzera mumitundu iwiri yamitundu '. Kenako sankhani mitundu ya mtengo wocheperako komanso waukulu kwambiri.

Mtundu ukhoza kusankhidwa onse pamndandanda ndikugwiritsa ntchito sikelo yosankha mitundu.

Izi ndi momwe chosankha mitundu chimawonekera.

Pambuyo pake, mudzabwerera ku zenera lapitalo, momwe muyenera kuonetsetsa kuti zotsatira zapadera zidzagwiritsidwa ntchito mwachindunji kumunda wa ' Total spend '.

Izi ndi zomwe zotsatira zake zidzawoneka. Ndalama zambiri zomwe wodwala wawononga kuchipatala chanu, maziko a cell amakhala obiriwira. Mosiyana ndi kugwiritsa ntchito seti ya zithunzi zokhala ndi zosankha zotere, pali mithunzi yambiri yamitengo yapakatikati.

Gradient pogwiritsa ntchito mitundu itatu

Koma mutha kupanga gradient pogwiritsa ntchito mitundu itatu. Pazotsatira zamtundu uwu, sankhani ' Sankhani ma cell onse kutengera milingo yawo pamitundu itatu yamitundu '.

Momwemonso, sankhani mitundu ndikusintha mawonekedwe apadera ngati kuli kofunikira.

Pankhaniyi, zotsatira zidzawoneka kale chonchi. Mutha kuwona kuti phale lamitundu yapakati ndilolemera kwambiri.

Sinthani Mafonti

Mutha kusintha osati mtundu wakumbuyo, komanso fonti .

Onani pansipa mitu ina yothandiza:

• Kuwona chidziwitso ndi zithunzi
• Onetsani Mfundo Zofunika Kwambiri
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera