Epamusoro mashanu eMicrosoft Excel Mazano uye Tricks muHofisi 5
Kunyangwe iwe uchishanda muakaunzi, zadza ma invoice, kana kungo gadzirisa dzimwe nhamba, Microsoft Excel chirongwa chinobatsira kwazvo kumabhizinesi nevatengi zvakafanana. Nekudaro, kusiyana nemamwe mapurogiramu eHofisi 365, Excel inotarisa zvakanyanya pane data, izvo zvinogona kutyisa kune vamwe. Usanetseka, nekuti ikozvino tinokupa iwe kutarisa kune mamwe edu atinoda eExcel matipi uye matipi eHofisi 365. Aya matipi uye matipi haangokuchengetere nguva chete asi anogona zvakare kurerutsa zvinhu uye kubatsira kukuita iwe Excel nyanzvi.
Shandisa mamwe mapfupi
Zvakawanda sezvimwe zvirongwa zveHofisi 365, kune akati wandei mapfupi ekhibhodi anogona kushandiswa muExcel.
Paunenge uchibata nenhamba nemaspredishiti anogona kutenderedza makoramu nemitsara isingaperi, mapfupi aya anogona kupedzisira akuchengetedza imwe nguva uye musoro.
Takaunganidza zvimwe zvezvatinoda .
- CTRL+Enter: kudzokorora chinyorwa. Dzvanya paboka rese remasero wobva wanyora zvauri kuda kudzokorora muchitokisi chekupedzisira, wobva wadzvanya Ctrl + Enter. Zvawanyora zvinoenda kune yega yega cell..
- Alt + F1: Shandisa iyi nzira yekudimbudzira kugadzira machati papepa rimwechete nedata rako. Saizvozvowo, kudzvanya F11 Kugadzira chati pane pepa rakasiyana
- Shift + F3 Shandisa iyi nzira yekudimbudzira kuisa chinhu
- Alt + H + D + C: Shandisai nzira yekudimbudzira iyi kudzima column
- Alt + H + B: Shandisai nzira yekudimbudzira iyi kuwedzera bhodha musero
- Ctrl + Shift + $: Shandisa iyi nzira yekudimbudzira kuisa chimiro chemari
- Ctrl + Shift + %: Shandisai nzira yekudimbudzira iyi kuisa mafomati epesenti
- Ctrl + Shift + &: Shandisai nzira yekudimbudzira iyi kuisa miganho yerondedzero
- F5: Shandisa nzira yekudimbudzira iyi kuenda kune sero. Ingonyora F5 uye fomati sero kana sero zita
Edza IFS Boolean mabasa kuti ubvise kudiwa kwemafomati akaiswa
IFS ibasa remunharaunda rinozivikanwa se "Kana, izvi, zvino, uye izvo.". Izvi zvinoshandiswa nevanoongorora pasi rese, uye zvinogona kuongorora akawanda mamiriro muExcel kuitira kuti haufanirwe kushandisa nested mafomula.
Iyo ficha inogona kushandiswa nekupinda =IFS mubhawa yeformula, uchitevera zvirevo. Ipapo IFS inotarisa kuti ione kana mamiriro akazadzikiswa uye inodzosera kukosha kunofanana neiyo TRUE mamiriro. Muenzaniso weIFS unoratidzwa pazasi.
Mumufananidzo unotevera, tinoshandisa fomula kugadzira zvibodzwa muspredishiti.
Shandisa bhara remamiriro kuti uone mamiriro e data
Hapana anofarira kuita nekukurumidza kuverenga, asi Excel inokwanisa kukurumidza kugadzirisa iyo data kwauri. Kana iwe uine pepa renhamba, kana manhamba, iyo mamiriro bar anogona nyore kugadzirisa nhamba dzako pasina kutaipa fomula. Izvi zvinosanganisira scalar, scalar, min, max, sum. Iwe unongoda kuratidza iyo data kuti utange. Muzviitiko zvisingawanzoitiki, ungangoda kuigonesa kutanga. Kana zvirizvo, tinya-kurudyi pabhara yemamiriro, uye tinya kugonesa sarudzo dzematanho aunoda kuona.
Edza mabhawa edata kuti uone data rako nemaziso
Dhata huru inobatsira, asi hapana chinoonekwa kupfuura infographics. Iine maBara eData muExcel, unogona kuwedzera mabara kumatafura ako aripo pasina kuwedzera girafu. Iwe unogona kuita izvi nekusarudza iyo data uye maseru aunoda girafu, wozoenda Homepage Home, uye sarudza Conditional Formatting , Sarudza Data Bars. Iwe unogona ipapo kusarudza kubva kune gradient kuzadza kana kuzadza kwemavara.
Kumbira Excel rubatsiro
Kana iwe ukaona warasika muExcel, iyo purogiramu pachayo inogona kubatsira. Ingodzvanya pabhokisi riri kumusoro kwarinoti tsvaga Uye iwe unozogona kutsvaga basa rauri kutsvaga kuti riitwe muExcel.
Bhokisi rekutsvaga rinozokupa iwe nesarudzo. Neimwe nzira, unogona kugara uchinyora " Help” Mune ino yekutsvaga bhaa kuti ufonere uye uwane runyorwa rweakakurumbira Excel misoro uye mabasa. Mimwe yemisoro yakajairika yakanyorwa pano ndeyekuti mitsara, mabasa, maseru, mafomula, mafomati, matafura, nezvimwe.
Iwe uchakwanisa kuwana nhanho yepamusoro muExcel?
Pane zvakawanda zvaunogona kuita neMicrosoft Excel, uye zvakaoma kuzvivhara mune imwechete post. Mazano edu uye matipi anongobata pane izvo zvekutanga, asi pane zvimwe zvakawanda zvekuwana. Tiudze mune zvakataurwa pazasi matipi ako uye matipi eExcel uye Hofisi 365.
Maitiro ekugadzirisa Microsoft Excel kukanganisa makodhi
