USU  ››  Zvirongwa zvebhizimusi otomatiki  ››   ››   ›› 

Value Rating

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa tadzidza simbisa chati yose kuti uone kukosha kwakakosha.

Avhareji yecheki uye pamusoro peavhareji cheki

Zvino ngatipindei mune module "Sales" pambiru "Kubhadhara" kuwana otomatiki kukosha kweavhareji. Panyaya yekutengesa, iyi inonzi ' avhareji cheki '. Uye zvakare zvichave zvinonakidza kwatiri kuona hunhu huri pamusoro peavhareji. Kuti tiite izvi, tinoenda kumurairo watinoziva kare "Conditional Formatting" .

Ndapota verenga kuti nei usingazokwanisi kuverenga mirairo yakafanana uye kushanda pahwindo rinoonekwa.

Kana uchine mitemo yekufometa kubva kumienzaniso yapfuura, bvisa yese. Wobva wawedzera imwe nyowani uchishandisa bhatani re' Nyowani '.

Muhwindo rinoonekwa, sarudza mutemo ' Fomati chete maitiro ari pamusoro kana pasi peavhareji '. Zvadaro, mune yekudonhedza pasi pasi, sarudza ' Huru pane kana kuenzana neavhareji yemhando yakasarudzwa '. Pakudzvanya bhatani re' Format ', shandura saizi yefonti zvishoma uye ita kuti font ishinga.

Nekuda kweizvozvo, isu tichasimbisa maodha akaenzana kana akakwira kupfuura avhareji yebhiri.

Zvakare, iyo mamiriro ekutsvaga aunoisa kana uchivhura module inoita basa rakakura "sales" . Mushure mezvose, nezuro cheki yevhareji yakanga yakaenzana nemari imwe, uye nhasi inogona kutochinja.

Pane mushumo unokosha unoongorora avhareji yebhiri .

Nzvimbo Yepamusoro 3 Yakanakisa uye Yepamusoro 3 Yakaipisisa Orders

Iwe unogona kuseta mamiriro ekufomatidza anozoratidza ' Pamusoro gumi ' kana ' Pamusoro 3 ' yeakanakisa maodha.

Ticharatidza maodha akadaro mugirinhi font.

Ngatiwedzerei chechipiri chimiro kuratidza iyo ' Pamusoro 3 ' yakashata maodha.

Ita shuwa kuti ese mafomati mamiriro achaiswa kune iyo ' Inobhadhara ' ndima.

Nekudaro, mune imwecheteyo dataset, isu tinowana chinzvimbo che ' Pamusoro 3 Best Orders ' uye ' Pamusoro 3 Yakaipisisa Orders '.

Imwe muzana yezvakanakisa maodha

Kana paine maodha akawanda, zvinokwanisika kuvaka chiyero chako ' Top 3 ', uko ' 3 ' isingazove nhamba yecheki dzinofanirwa kuwanikwa murunyoro rwese, asi muzana. Ipapo iwe unogona nyore kudhinda 3 muzana yezvakanakisa kana zvakaipisisa mirairo. Kuti uite izvi, ingo tarisa iyo ' % yeyakasarudzwa renji' cheki bhokisi.

Unique values kana duplicate

Iyo purogiramu ichakuratidza iwe mune chero tafura akasiyana tsika kana zvakapetwa .

Ona pazasi mamwe misoro inobatsira:

• Tsvaga yakasarudzika tsika kana zvakapetwa
• Batanidza Chati muMakoshi Akaratidzwa
• Conditional Formatting
• Avhareji cheki
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana