USU  ››  Zvirongwa zvebhizimusi otomatiki  ››  Chirongwa chekiriniki  ››  Mirayiridzo yechirongwa chekurapa  ›› 

Rongedza tsika

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Apa tadzidza simbisa chati yose kuti uone kukosha kwakakosha.

Avhareji kukosha

Iwe unogona kuisa maitiro. Kuti uite izvi, ngatipinde mumodule "Varwere" pambiru "Zvose zvakashandiswa" kuwana otomatiki kukosha kweavhareji. Kuti uwane pfungwa yakajeka yekuti imarii iyo murwere anoshandisa mukiriniki yako. Kuti tiite izvi, tinoenda kumurairo watinotoziva "Conditional Formatting" .

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

Kana uchine mitemo yekufomatidza kubva kumienzaniso yapfuura, bvisa yese.

Wobva wawedzera mutemo mutsva uchishandisa bhatani re' Nyowani '.

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

Nekuda kweizvozvo, isu tichasimbisa vatengi vakashandisa mari yakanaka munzvimbo yako yekurapa. Mari yacho ichaenzana kana kuti yakakura kudarika avhareji yekiriniki.

Uyezve, kusarudzwa kwemaitiro kunozongochinja nekufamba kwenguva. Mushure mezvose, nezuro chiyero chepakati chakanga chakaenzana nechiyero chimwe chete, uye nhasi chinogona kutosiyana zvachose.

Pane mushumo unokosha unoongorora avhareji yesimba rekutenga .

Nzvimbo Yepamusoro 3 Yakanakisa uye Yepamusoro 3 Yakaipisisa

Unogona kuseta mamiriro ekufomatidza anozoratidza ' Pamusoro gumi ' kana ' Pamusoro 3 ' yevatengi vakanyanya kunaka.

Ticharatidza varwere vakadai mugirinhi font.

Ngatiwedzerei chechipiri chimiro kuratidza iyo ' Pamusoro 3 ' yakaipisisa varwere. Huwandu hwemari yavo yakashandiswa hucharatidzwa mumavara matsvuku.

Ita shuwa kuti ese mafomati mamiriro achaiswa kune iyo ' Total Spent ' munda.

Nekudaro, mune imwecheteyo data seti, isu tinowana chinzvimbo che' Vepamusoro 3 Varwere Vakanyanya ' uye' Vepamusoro 3 Varwere Vakaipisisa '.

Imwe muzana yevatengi vakanyanya kunaka

Kana paine varwere vakawanda, zvinokwanisika kuvaka yako ' Top 3 ' rating, uko ' 3 ' isingazove iyo nhamba yevanhu vachawanikwa mune yakajairika rondedzero, asi muzana yehuwandu hwevatengi base. Ipapo iwe unogona kuburitsa zviri nyore 3 muzana yeakanakisa kana akaipisisa varwere. Kuti uite izvi, ingo tarisa iyo ' % yemhando yakasarudzwa ' cheki bhokisi.

Unique values kana duplicates

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

Ona pazasi mamwe misoro inobatsira:

• Tsvaga zvakapetwa muchikamu
• Shandisa chati yekuona
• Simbisa Zvinhu Zvinokosha
• Kutenga simba rekuongorora
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana