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

Mtengo Wamtengo

Izi zimapezeka kokha pamakonzedwe a Standard ndi Professional program.

Apa taphunzira phatikizani tchati chonse kuti muwone zofunikira kwambiri.

cheke chapakati komanso cheke chambiri

Tsopano tiyeni tilowe mu module "Zogulitsa" pa kolamu "Kulipira" kupeza basi mtengo wapakati. Pankhani yogulitsa, izi zimatchedwa ' cheke chapakati '. Komanso zidzakhala zosangalatsa kwa ife kudziwa zomwe zili pamwamba pa avareji. 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 amapangidwe kuchokera ku zitsanzo zam'mbuyomu, chotsani onse. Kenako onjezani yatsopano pogwiritsa ntchito batani la ' Chatsopano '.

Pazenera lomwe likuwoneka, sankhani lamulo lakuti ' Sinthani zikhalidwe zomwe zili pamwamba kapena pansi pa avareji '. Kenako, mumndandanda wotsikira m'munsimu, sankhani ' Greater than or equal to the average of the osankhidwa range '. Mukakanikiza batani la ' Format ', sinthani kukula kwa font pang'ono ndikupanga font kukhala yolimba mtima.

Zotsatira zake, tiwunikira maoda omwe ali ofanana kapena apamwamba kuposa bilu wamba.

Komanso, kusaka komwe mumayika mukatsegula gawoli kudzatenga gawo lalikulu "malonda" . Kupatula apo, dzulo cheke chapakati chinali chofanana ndi ndalama imodzi, ndipo lero zitha kusintha kale.

Pali lipoti lapadera lomwe limasanthula pafupifupi bilu .

Kuyika Pamwamba 3 Opambana Kwambiri komanso Otsogola 3 Oyipitsitsa Kwambiri

Mutha kukhazikitsa mawonekedwe omwe angawonetse ' Top 10 ' kapena ' Top 3 ' pamadongosolo abwino kwambiri.

Tidzawonetsa madongosolo otere mumtundu wobiriwira.

Tiyeni tiwonjezere chikhalidwe chachiwiri kuti tiwonetsere ' Top 3 ' zoyipa kwambiri.

Onetsetsani kuti zolemba zonse ziwiri zidzagwiritsidwa ntchito pagawo la ' Payable '.

Chifukwa chake, mu seti yofananira, tipeza masanjidwe a ' Top 3 Best Orders ' ndi ' Top 3 Worst Orders '.

Gawo lina lazinthu zabwino kwambiri

Pakakhala madongosolo ambiri, ndizotheka kupanga chiwongola dzanja chanu cha ' Top 3 ', pomwe ' 3 ' sichikhala chiwerengero cha macheke omwe akuyenera kupezeka pamndandanda, koma kuchuluka kwake. Ndiye mukhoza kusindikiza mosavuta 3 peresenti ya zabwino kapena zoipa oda. Kuti muchite izi, ingoyang'anani bokosi la ' % la mndandanda womwe wasankhidwa '.

Zapadera kapena zobwereza

Pulogalamuyi imangokuwonetsani patebulo lililonse zamtengo wapatali kapena zobwereza .

Onani pansipa mitu ina yothandiza:

• Pezani zamtengo wapatali kapena zobwereza
• Ikani Tchati mu Makhalidwe Owonetsedwa
• Conditional Formating
• cheke chapakati
• Pachiyambi

• Tsitsani pulogalamuyo ndi maphunziro ochezera