Mukati
Vazhinji vashandisi veExcel vanojairana nedambudziko rekuti zvakanyanya kunetsa kuisa huwandu hwakawanda hweruzivo mumaseru, hapana kwekusiya chinyorwa chako mune ramangwana. Muchokwadi, kuita izvi pasina kutyora kutaridzika kwetafura kuri nyore. Ndizvo zvinoitirwa manotsi.
Kushanda neManotsi
Manotsi ndiwo mamwe maregisheni emaseru akasarudzwa. Kazhinji kazhinji iwo ari echinyorwa uye ane chaiwo tsinhiro nemumwe wevanyori vetafura. Mukuwedzera kune zvinyorwa, unogona kuwedzera mufananidzo kumunda unooneka. Nekudaro, kuti ubatanidze yaunoda chirevo kana mufananidzo kune sero, iwe unofanirwa kudzidza kugadzira akareruka mameseji mamaki, kuona uye kuagadzirisa.. Mushure maizvozvi, iwe unogona kuenderera kune advanced settings.
Zvisikwa
Maitiro ekugadzira manotsi ari nyore uye ane akati wandei matanho:
- Sarudza sero kubva patafura negonzo. Kurudyi tinya pairi.
- Kubva pane menyu yemukati inooneka, sarudza iyo "Isert Note" basa.
- Mushure meizvozvo, munda wakasununguka uchabuda padivi pesero rakasarudzwa. Mutsara wepamusoro uchagarwa neiyo default username.
Iwe unogona kuisa chero ruzivo rwemavara munharaunda yemahara. Kuti uvanze mhinduro, unofanirwa kudzvanya-kurudyi pane sero, sarudza basa re "Viga Comment". Mushure meizvozvo, ichave iripo yekuverenga pane chinongedzo chinoratidzwa nekona dzvuku.
ongorora
Iwe unogona kuona zvirevo zvemasero akasiyana nekutenderera pamusoro peumwe neumwe wavo negonzo cursor. Mushure meizvozvo, zvinyorwa zvine chinyorwa chinobuda otomatiki. Kuita kuti chikamu chekutaura chinyangarike, unofanirwa kufambisa chitubu kuenda kune imwe nzvimbo.
Mazano enyanzvi! Kana tafura yakakura, uye ine zvinyorwa zvakawanda zvakasungirirwa kumasero akasiyana, unogona kushandura pakati pavo kuburikidza ne "Ongorora" tab. Nokuda kweizvi, mabhatani "Previous" uye "Next" akagadzirirwa.
Kugadzirisa
Kazhinji pane mamiriro ezvinhu kana zvichidikanwa kuti uchinje zviri mukati mehwindo kune mamwe makomendi. Iwe unogona kuita izvi nekutevera matanho mashoma:
- Tanga wadzvanya pachisero chine mavara akavanzika nebhatani rekurudyi.
- Muchinyorwa chinooneka, sarudza "Edit Note" basa.
- Hwindo rinofanirwa kuvhurika kuburikidza naro iwe raunogona kugadzirisa iwo mameseji, wedzera mapikicha kwairi, kuwedzera kana kuderedza ndima yekutaura.
Unogona kupedzisa kuseta nekudzvanya chero patafura kunze kwemunda kuti uwane mamwe mavara.
Imwe sarudzo yekugadzirisa masero ndeye kuburikidza neOngororo tebhu. Pano iwe unofanirwa kutsvaga seti yezvishandiso zvezvinyorwa uye tinya pakanzi "Edit".
Kuwedzera mufananidzo
Chimwe chezvinhu zvinonakidza zvezvinyorwa muExcel ndeyekuwedzerwa kwemifananidzo inozobuda kana iwe uchitenderera pamusoro pemaseru akasarudzwa. Kuti uwedzere mufananidzo, unofanirwa kuita akati wandei zviito:
- Pakutanga, iwe unofanirwa kuwedzera imwe siginecha mune yakasarudzwa sero.
- Enda kune iyo yekunyora editing process, tungamira mbeva cursor kune imwe yemasero miganhu. Izvo zvakakosha kuti uzvitungamirire kune iyo iyo icon ine miseve mina ichaonekwa, iyo inosiyana munzira dzakasiyana.
- Iwe unofanirwa kudzvanya-kurudyi pane iyi icon, sarudza iyo "Note Format" basa kubva kumenyu inooneka.
- Iwindo rekugadzirisa ruzivo rinofanira kuoneka pamberi pemushandisi. Iwe unofanirwa kuwana iyo "Mavara uye Mitsetse" tebhu uye chinja kwairi.
- Dzvanya pane yakadonhedza pasi inonzi "Muvara", pazasi chaipo pechinyorwa chinooneka, sarudza "Zadza Nzira" basa.
- Iwindo idzva rinofanira kuoneka raunoda kuenda kune "Drawing" tab. Mukati metabhu iyi, tinya bhatani rine zita rimwechete.
- Iwindo re "Insert Images" richaonekwa, umo iwe unoda kusarudza imwe yezvitatu zvingasarudzwa: kurodha mufananidzo kubva kuOneDrive, tsvaga mufananidzo uchishandisa Bing, isa mufananidzo kubva pakombuta. Nzira iri nyore ndeyekuisa kubva pakombuta uko gwaro riripo.
- Kana mufananidzo wasarudzwa, unongochinja kuhwindo rakapfuura umo mufananidzo wakasarudzwa ucharatidzwa. Pano iwe unofanirwa kutarisa bhokisi riri padivi pebasa "Chengetedza zviyero zvemufananidzo."
- Mushure mekudzvanya bhatani rekuti "Zvakanaka", hwindo rekutanga refomati yenoti richavhurwa. Panguva ino, iwe unofanirwa kusunga chinyorwa nemufananidzo kune yekutanga yakasarudzwa sero. Kuti uite izvi, unofanirwa kuenda kune "Kudzivirira" tab, uncheck bhokisi riri pedyo ne "Chinhu Chakachengetedzwa".
- Tevere, iwe unofanirwa kuenda kune "Properties" tab, tarisa bhokisi riri padivi pechinhu chekufambisa uye kushandura zvinhu pamwe nemaseru. Dzvanya bhatani rekuti "OK".
Kuti uwedzere mufananidzo, zvinodikanwa kutambanudza iyo general note ndima munzira dzakasiyana.
Kudzima katsamba
Kubvisa siginicha yakawedzerwa kuri nyore pane kuisa imwe nyowani kana kuigadzirisa. Kuti uite izvi, tinya-kurudyi pane cell ine imwe tsananguro. Kubva pane pop-up menyu, shandisa iyo "Delete note" kuraira.
Nzira yechipiri yekubvisa imwe label kune yakasarudzwa sero iri kuburikidza ne "Ongorora" basa. Usati wasarudza iyi sarudzo, unofanirwa kumaka sero negonzo. Chekupedzisira, tinya pakanzi Delete yekuwedzera ruzivo bhatani.
Nzira yekusaina sei chinyorwa muExcel
Kana mune rimwe gwaro rakagovaniswa reExcel ese ekuwedzera edhisheni pamusoro pemaseru akanyorwa nevashandisi vakasiyana pasina siginecha yemunhu, zvichave zvakaoma kwazvo kuwana munyori wezvimwe zvinyorwa. Chinyorwa chechinyorwa chinokubvumira kuronga data. Kuti uisiye pamusoro peimwe gadziriso kune sero, unofanirwa kuita akati wandei zviito:
- Sarudza chimwe chezvinhu zvikuru menyu "Faira".
- Enda ku "Zvirongwa".
- Enda kune "General" tab.
- Munda wakasununguka uchaonekwa pazasi peji, umo iwe unofanirwa kuisa zita remushandisi akasiya mhinduro pachitokisi.
Nzira yekuwana sei chinyorwa muExcel
Kana gwaro racho rakakura kwazvo, pangava nemamiriro ezvinhu apo unofanira kukurumidza kuwana mhinduro chaiyo. Ita kuti zvibvire. Mirayiridzo yekuwana tsananguro inodiwa kana label:
- Enda kune "Kumba" tab.
- Enda kune "Tsvaga uye sarudza" chikamu.
- Dzvanya bhatani re "Settings".
- Tsvaga sarudzo yekusarudza "Search scope".
- Seta kukosha kuti Note.
- Dzvanya bhatani rekuti "Tsvaga Zvese".
Mushure meizvozvo, runyoro rune maseru zvinoenderana neyakaiswa parameter ichaonekwa pamberi pemushandisi.
Kuratidza nekuvanza chinyorwa
Kana uchida, iwe unogona kuviga zvachose zvinyorwa kuitira kuti zvirege kuonekwa paunenge uchiverenga gwaro guru, kana kudzima basa rekuviga kana rakamboitwa. Kuti uite izvi, unofanirwa kutevera matanho mashoma ari nyore:
- Enda kune zvakajairwa zvigadziriso pa "Faira" tab, uye "Sarudzo", enda kune "Advanced" chikamu.
- Tsvaga chikamu che "Screen".
- Tarisa bhokisi riri pedyo ne "Noti uye zviratidzo" basa.
- Dzvanya bhatani rekuti "OK". Mushure mezvo, zvinyorwa zvakavanzika zvichagara zvichiratidzwa. Kuti uvavanze zvachose, unofanirwa kutarisa bhokisi riri pedyo ne "Hapana manotsi, hapana zviratidzo" basa.
Mazano enyanzvi! Excel ine sarudzo yekuratidza chete mhinduro dzemunhu. Kugonesa chimiro ichi, unofanira kudzvanya-kurudyi pasero uine imwe tsananguro, tinya bhatani rekuti “Show Notes”. Saka ivo vanozoratidzwa zvachose chete pamaseru akasarudzwa. Kuburikidza nemenu yemamiriro ezvinhu akafanana, unogona kuvanza zvachose tsananguro pfupi munzvimbo dzinodiwa.
Kukopa chinyorwa kune mamwe maseru
Kana chinyorwa chakatogadzirwa, unogona kuchikopa kune imwe sero kuitira kuti usazonyora zvinyorwa zvakare. Kuti uite izvi, tevera murairo uri nyore:
- Tinya-kurudyi kuti usarudze sero riri mugwaro rine tsananguro pfupi kana kugadzirisa.
- Kubva pane pop-up menyu, sarudza iyo "Copy" basa.
- Tsvaga sero raunoda kusungirira kanoti akopwa, sarudza nekudzvanya bhatani rekuruboshwe.
- Enda kune "Kumba" tab, uye sarudza "Clipboard", tinya pa "Namira" bhatani.
- Rondedzero yemirairo ichaonekwa pamberi pemushandisi. Pfungwa yekufarira ndeye "Paste Special". Mushure mekudzvanya pairi, hwindo rakasiyana rezvigadziriso richabuda, kwaunoda kutarisa bhokisi riri padivi pezvinyorwa. Inosara kuchengetedza shanduko nekudzvanya pakanzi "OK".
Madhinda sei pepa renoti
Kana iwe ukasagadzirisa zvimwe, nekukasira, Excel zvinyorwa zvinodhindwa pasina manotsi. Kuti uwedzere ivo kuprintout, unofanirwa kugadzirisa chirongwa:
- Enda kuchikamu che "Peji Layout".
- Enda kune "Peji Setup" tab, wobva wadzvanya "Printa Misoro".
- Hwindo rine zvinhu zvega zvekudhinda richavhurwa. Kupikisana neshoko rekuti "Zvinyorwa", unogona kuzviwedzera kune yakadhindwa kana kusiya chiitiko ichi chakanzurwa.
Mazano enyanzvi! Paunenge uchiwedzera manotsi ekudhinda, pane nzira mbiri dzekuaratidza pagwaro rakadhindwa. Kana ukasarudza "Pakupera kwepepa" - ivo vachaonekwa pazasi peji. Iwe unogona kusarudza sarudzo "Sezvo pane pepa" - zvinyorwa zvichadhindwa sezvazvinoonekwa mumagetsi echinyorwa.
Kuchinja zita rekushandisa paunenge uchigadzira manotsi
Paunenge uchishanda muExcel nekugovana kwakabatidzwa, paunogadzira manotsi, haapihwe zita remushandisi anoasiya. Kuti uchinje kuzita rako remadunhurirwa, unofanirwa kutevera matanho mashoma:
- Mukona yepamusoro kuruboshwe, tinya pa "Faira" tab.
- Enda kune "Settings", "General" chikamu.
- Sarudza "Username" kubva pane menyu inooneka.
- Munda wakasununguka uchazarura pamberi pemushandisi, umo zvakakosha kunyora pasi zita raunoda.
Mienzaniso yekushandisa manotsi muExcel
Kuti unzwisise kuti anobatsira sei mamwe maseru maseru muExcel spreadsheet, zvinokurudzirwa kufunga mishoma mienzaniso inoshanda kubva pane zvakaitika kune vamwe vashandisi:
- Kana vashandi veimwe kambani vane chigadziko chebasa chakafanana chakanyorwa muExcel gwaro, vashandi vanoshanda pane imwechete peji mumashifiti vanogona kusiya mhinduro sevanochinja, kupa mirairo, kuchinjana mamwe ruzivo.
- Kuiswa kwemifananidzo - kana tafura ine data pamusoro pevamwe vanhu, mifananidzo yezvimwe zvinhu, kana ine chokuita nekuchengetedza kwavo, kutengesa.
- Tsananguro kune mafomula anozorerutsa mamwe maverengero, macalculation.
Kana iwe ukasiya makomendi nenzira kwayo - kuitira kuti aoneke panguva chaiyo uye asakanganise basa revamwe vashandisi, unogona kuwedzera zvakanyanya kugadzirwa kwebasa rine chekuita nematafura muExcel.
Vhidhiyo tutorials pane manotsi muExcel
Mirayiridzo iri pamusoro ichakubatsira kuti unzwisise zvakakosha zvekugadzira, kugadzirisa, kutarisa, kugadzirisa kwepamusoro kwemashoko kumasero muExcel spreadsheet. Nekudaro, kana ukasangana nechero matambudziko, kuomerwa nezvimwe zviito zvine chekuita nezvinyorwa, zvinokurudzirwa kuona mavhidhiyo ekudzidzisa. Iwo ane nhanho-ne-nhanho mirairo yekuita akasiyana-siyana maseru makomendi.
mhedziso
Kugadzira, kugadzirisa uye kuona zvirevo pamaseru akasiyana muExcel hazvina kuoma sezvazvingaite sekutanga kuona. Zvichava zvinobatsira kuva neunyanzvi hwakadaro kwete chete kune vanhu vanoshanda mumasangano makuru, chengetedza chimwe chinhu vachishandisa matafura, asiwo kune vashandisi vasina kuroorwa vanoshanda muExcel ivo pachavo. Hatifaniri kukanganwa kuti mundima yekunyora iwe unogona kuwedzera kwete zvinyorwa chete, asiwo mifananidzo, iyo inowedzera zvakanyanya kubatsira kwavo mubasa.