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

Kuona ruzivo nemifananidzo

Aya maficha anowanikwa chete muStandard uye Professional chirongwa masisitimu.

Mifananidzo yakaiswa

Kuona ruzivo nemifananidzo kunopa mhedzisiro inoshamisa. Chero seti yedata pakarepo inova yekuona. Ese marekodhi anobva apatsanurwa nekukasira kuita ' zvakanaka ', ' zvakarerekera ' uye ' zvakaipa '. Ngationei kuti zvinoshanda sei. Kuti aite izvi, mune module "Varwere" simbisa vanhu vakanyanya kukosha vachishandisa seti yemifananidzo inooneka. Vanonyanya kukosha vatengi vachava avo "mari yakashandiswa" nzvimbo yako yekurapa ine zvakawanda kupfuura vamwe. Nokuda kweizvi tinoshandisa murairo "Conditional Formatting" .

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

Iwindo rekuwedzera zvakakosha tafura zvinyorwa zvichaonekwa. Kuti uwedzere mamiriro matsva ekugadzirisa data kwairi, tinya bhatani re' Nyowani '.

Kuti utange, sarudza ' Fomati ese maseru zvichienderana nehunhu hwavo uchishandisa seti yemifananidzo '. Uye ipapo pazasi pehwindo kubva pane yekudonha-pasi rondedzero, sarudza seti yemifananidzo yaunonyanya kufarira.

Yekutanga yekupinda inowedzerwa kune runyorwa rwemafomati mamiriro. Mariri, iwe uchada kusarudza munda watichashandisa iyo yakakosha maitiro. Sarudza iyo ' Total Spent ' munda.

Ona kuti rondedzero yevarwere yachinja sei. Ikozvino kune denderedzwa dzvuku padivi pevatengi vakashandisa mari shoma munzvimbo yako yekurapa. Varwere veavhareji kukosha vanocherechedzwa nedenderedzwa reorenji. Uye iyo yakanyanya kunyungudika uye inodiwa vashanyi vanoiswa chiratidzo chegirinhi denderedzwa.

Mushure meizvozvo, vashandi vako vanonyatsoona kuti ndeupi mutengi anonyungudika.

Uye iwe zvakare uchave nemukana wekuenzanisa huwandu hwemari yakashandiswa neyakapihwa ' VIP ' mamiriro. Vatengi avo vanozviisa sevanonyanya kukosha zvakakosha kwauri here? Uye zvinopesana, iwe unogona kuona pakati pevazhinji vanhuwo zvavo avo vanopedza mari yakawanda newe.

Shandura mafomati anemiganho

Iwe unogona kuedza nekusarudza seti dzakasiyana dzemifananidzo. kuti uchinje "conditional formatting" , isa mutemo wezita rimwe chete zvakare. Dzvanya bhatani rekuti ' Shandura '.

Zvino sarudza imwe seti yemifananidzo. Semuenzaniso, iyo mifananidzo iyo ichasiyana kwete muvara, asi muchiyero chekuzadza.

Pamusoro peiyo yekudonhedza-pasi rondedzero yekusarudza mapikicha, kune zvakare akakosha maitiro marongero aunogona kuedza kuchinja.

Unowana mhedzisiro iyi.

Isa mufananidzo wako kune kukosha

Pachine mukana isa mufananidzo wako kune imwe kukosha kuti ujekeswe zvakanyanya.

kumashure gradient

Tsvaga kuti ungasimbisa sei zvakakosha zvakakosha kwete nemufananidzo, asi ne gradient background .

Ona pazasi mamwe misoro inobatsira:

• Ruzivo rwekuona
• Simbisa ruvara rwekumashure
• Simbisa Zvinhu Zvinokosha
• Kusvika pakutanga

• Dhawunirodha chirongwa nekudzidziswa kunopindirana