Mukati
Kazhinji, mushandisi weExcel anotarisana nekudiwa kwekuzadza maseru nedata rakarongwa mune imwe nzira inonzwisisika. Kana, semuenzaniso, kuita fungidziro yekuti kukosha kwechimwe chiratidzo kuchave nei nenguva yakatarwa, kana maitiro aripo achienderera mberi. Zvino iwe haufanire kuziva akawanda emafomula ezvese izvi. Kudzvanya kwembeva kwakakwana, uye dambudziko rinogadziriswa. Zvose zvinokonzerwa ne autocomplete.
Chimiro ichi chinoshamisa mukunaka kwayo. Semuyenzaniso, inokutendera iwe kukurumidza kunyora mwedzi wekarenda kana kuti uiite kuitira kuti chete 15 uye zuva rekupedzisira remwedzi wega wega rinoratidzwa (somuenzaniso, mune accounting mishumo).
Ungatora sei mukana weichi chinhu chikuru?
Mukona yezasi yekurudyi kune sikweya, nekuidhonza, unogona kuenderera mberi nenhevedzano yehutsika umo mune imwe pateni. Semuenzaniso, kana zuva rekutanga riri Muvhuro, zvino nekuita iri nyore oparesheni, unogona kuisa maitiro mumitsetse inotevera: Chipiri, Chitatu, China, Chishanu, zvichingodaro.
Kana paine seti yehunhu musero senge 1,2,4, zvino nekusarudza ese uye nekukwevera bhokisi pasi, unogona kuenderera nenhamba dzakatevedzana kusvika pa8, 16, 32, zvichingodaro. Izvi zvinokubvumira kuti uderedze zvakanyanya mari yenguva.
Nenzira imwecheteyo, rondedzero yemazita emwedzi inogadzirwa.
Uye izvi ndizvo zvinoita kushandisa autocomplete kufambira mberi kwemasvomhu zvinoita. Mumuenzaniso wedu, isu tinoshandisa maseru maviri ane kukosha kwe1,3, zvichiteerana, uyezve autocomplete inoenderera mberi nhamba dzakateerana.
Uyezve, kugamuchirwa kuchashanda kunyange kana nhamba iri mukati mezvinyorwa. Semuenzaniso, kana iwe ukanyora "1 quarter" uye uchikwevera bhokisi pasi, unowana zvinotevera.
Chaizvoizvo, izvi ndizvo zvese zvakakosha zvaunofanira kuziva. Asi kana iwe uchida kugona hunyanzvi hwekushanda neExcel zvakanyanya hunyanzvi, unogona kujairana nemamwe machipisi uye matipi.
Kushandisa Autocomplete Data List
Ehe, kugadzira rondedzero yemwedzi kana mazuva evhiki hazvisi zvese zvinogona kuitwa neExcel. Ngatitii tine runyorwa rwemaguta uko kambani yedu yakamisa nzvimbo dzebasa. Kutanga iwe unofanirwa kunyora pasi runyorwa rwakazara mu "Shandura rondedzero" chinhu, icho chinogona kuwanikwa kuburikidza nemenu kutevedzana Faira - Sarudzo - Yepamberi - Yese - Rongedza zvinyorwa.
Tevere, hwindo richaonekwa riine runyorwa rwezvinyorwa zvakavakwa muExcel otomatiki.
Hakuna vazhinji vavo pano. Asi kusanzwisisa uku kunogona kugadziriswa nyore nyore. Kuti uite izvi, pane hwindo rekurudyi mune iyo chaiyo kutevedzana kwehunhu uXNUMXbuXNUMXbis yakanyorwa. Kurekodha kunogona kuitwa nenzira mbiri, zvese nemakoma uye mukoramu. Kana paine data rakawanda, rinogona kutengwa kunze kwenyika. Nenzira iyi unogona kuchengetedza nguva yakawanda.
Chii chinodiwa nokuda kweizvi? Kutanga iwe unofanirwa kugadzira runyorwa rwemaguta pane imwe nzvimbo mugwaro, uye wobva wangoita chinongedzo pairi mumunda uri pazasi.
Rondedzero yacho yagadzirwa uye inogona kushandiswa kuzadza mamwe ese maseru.
Pamusoro pezvinyorwa mufomati yemavara, Excel inoita kuti zvikwanise kugadzira manhamba akatevedzana, pamwe nerondedzero yemazuva akarongwa zvinoenderana neimwe pateni. Pakutanga kwechinyorwa ichi, imwe yenzira dzekuishandisa yakapihwa, asi iyi idanho rekare. Iwe unogona kushandisa chishandiso ichi zvakanyanya kuchinjika, senge ace chaiyo.
Kutanga, isu tinosarudza inodiwa kutevedzana kukosha (imwe kana kupfuura) pamwe nechikamu cheiyo renji iyo ichashandiswa kune iyo rondedzero. Tevere, tinowana bhatani re "Zadza" pane yepamusoro panhizha uye mune menyu inooneka, tinya bhatani re "Kufambira mberi".
Zvadaro, hwindo rine marongero rinoonekwa.
Muchikamu chayo chekuruboshwe kune mabhatani eredhiyo ayo iwe unogona kuseta nzvimbo yekutevera kutevedzana: nemitsara kana makoramu. Muchiitiko chekutanga, rondedzero ichadzika, uye yechipiri, ichaenda kurudyi.
Pakarepo kurudyi rwekurongeka kwenzvimbo pane pani paunogona kusarudza rudzi rwekutevedzana kwenhamba. Pane zvakawanda zvingasarudzwa zvekusarudza kubva:
- Arithmetic. Kukosha musero rimwe nerimwe rinotevera imwe nhamba yakakura kupfuura yapfuura. Kukosha kwayo kunotarirwa nezviri mundima ye "Step".
- Geometric. Hukoshi hwega hwega hunozotevera hwakapetwa kakati wandei pane hwapfuura. Zvakawanda sei zvinoenderana nedanho ripi rakaratidzwa nemushandisi.
- Mazuva. Nesarudzo iyi, mushandisi anogona kugadzira nhevedzano yemazuva. Kana ukasarudza rudzi urwu, mamwe marongero eyuniti yechiyero anovhurwa. Ivo vanoverengerwa pakudhirowa kutevedzana: zuva, zuva rekushanda, mwedzi, gore. Saka, kana ukasarudza chinhu che "zuva rekushanda", ipapo vhiki dzevhiki hazvizoverengerwi mune urongwa.
- Autocomplete. Iyi sarudzo yakafanana nekukwevera pasi pakona yekurudyi. Nemashoko akareruka, Excel inosarudza yega kuti inoda kuenderera mberi nenhamba dzakatevedzana kana kuti zviri nani kugadzira runyorwa rurefu. Kana iwe ukatsanangura kukosha 2 uye 4 pamberi, zvino inotevera ichava nenhamba 6, 8, zvichingodaro. Kana izvi zvisati zvaitika iwe ukazadza mamwe masero, ipapo "linear regression" basa richashandiswa (iyi isarudzo inofadza zvikuru iyo inokubvumira kuvaka chirevo maererano nemaitiro aripo).
Pazasi pebhokisi renhaurirano iri, sezvauri kutoona, pane zvingasarudzwa zviviri: saizi yenhanho, yakurukurwa pamusoro, uye kukosha kwemuganho.
Mushure mekunge mapedza mabasa ese, unofanirwa kudzvanya bhatani re "OK". Nenzira imwecheteyo, rondedzero yemazuva ekushanda kweimwe nguva inogadzirwa (semuenzaniso, kusvika 31.12.2020/XNUMX/XNUMX). Uye mushandisi haafanire kuita nhamba huru yemafambiro asina kufanira!
Ndizvozvo, kuseta kwapera. Zvino ngatitarisei dzimwe nzira dzehunyanzvi dzekuzadzisa otomatiki.
Uchishandisa mbeva
Iyi ndiyo nzira iri nyore yekupedzisa otomatiki, ichikubvumidza kuti uite zvine hunyanzvi kunyangwe mashandiro akaomarara. Pane nzira mbiri dzekuti ingashandiswa sei: kushandisa bhatani rekuruboshwe kana rekurudyi. Semuenzaniso, basa nderekuita runyoro rwenhamba dzakarongwa mukukwira kurongeka, uko kukosha kwega kwega kunowedzera neimwe. Kazhinji, nokuda kweizvi, chikwata chinopinda muchitokisi chekutanga, uye deuce mune yechipiri, mushure mezvo vanokwevera bhokisi mukona yezasi yekona. Asi zvinokwanisika kuzadzisa chinangwa ichi neimwe nzira - nekungozadza musero rekutanga. Zvadaro unoda kuikwevera pasi kubva pakona yepasi yekurudyi. Mushure meizvozvo, bhatani riri muchimiro chechikwere richaonekwa. Iwe unofanirwa kuidzvanya uye sarudza iyo "Zadza" chinhu.
Iwe unogona zvakare kushandisa iyo "Zadza chete mafomati" basa, raunogona kuwedzera chete masero mafomati.
Asi pane inokurumidza nzira: kubata Ctrl bhatani uchikweva sero mukuwirirana.
Ichokwadi, inokodzera chete autocomplete kutevedzana kwenhamba. Kana iwe ukaedza kudhonza hunyengeri uhu nedata rerumwe rudzi, ipapo kukosha uXNUMXbuXNUMX kunongoteedzerwa mumaseru anotevera.
Pane nzira yekumhanyisa kufona kwemenu yemukati. Kuti uite izvi, dhonza bhokisi nekubata bhatani rekurudyi.
Ipapo seti yemirairo ichaonekwa. Saka, unogona kufonera bhokisi rebhokisi rine mamwe magadzirirwo ega ega nekudzvanya pane "Kufambira mberi" menyu chinhu. Asi pane chimwe chete chinogumira. Iyo yakanyanya kutevedzana kureba mune iyi kesi ichaganhurwa kune yekupedzisira sero.
Kuti auto-kupedzwa kuitwe kusvika kune inodiwa kukosha (yakatarwa nhamba kana zuva), iwe unofanirwa kudzvanya bhatani rekurudyi rembeva, wakambotungamira chitubu kubhokisi, uye dhonza chiratidzo pasi. Chiratidzo chinobva chadzoka. Uye danho rekupedzisira kusunungura mbeva. Nekuda kweizvozvo, menyu yemukati ine autocomplete marongero ichaonekwa. Sarudza kufambira mberi. Pano, sero rimwe chete rinosarudzwa, saka unofanirwa kutsanangura ese autofill paramita muzvirongwa: kutungamira, nhanho, kukosha kwekugumira, uye tinya bhatani OK.
Iyo inonyanya kunakidza Excel basa ndeye mutsara uye exponential approximation. Izvo zvinoita kuti zvikwanise kuvaka fungidziro yekuti maitiro achachinja sei, zvichibva pane iripo pateni. Sezvo mutemo, kuita fungidziro, unofanirwa kushandisa akakosha eExcel mabasa kana kuita maverengero akaomarara, umo hunhu hweiyo yakazvimirira inotsiviwa. Zviri nyore kwazvo kuratidza muenzaniso uyu mukuita.
Semuenzaniso, kune dynamics yechiratidzo, kukosha kwacho kunowedzera nenhamba imwechete nguva imwe neimwe.
Zviri nyore kunzwisisa kuti kukosha kunofanotaurwa sei nemutsara maitiro (apo imwe neimwe inotevera chiratidzo ichiwedzera kana kuderera nehumwe kukosha). Standard Excel mabasa akakodzera izvi, asi zviri nani kudhirowa girafu rinoratidza mutsara wemaitiro, iyo equation yebasa, uye kukosha kunotarisirwa kujekesa kukuru.
Kuti uzive kuti chiratidzo chakafanotaurwa chichave chii munhamba, paunenge uchiverenga, unofanirwa kutora regression equation sehwaro (kana kushandisa zvakananga mafomula akavakwa muExcel). Nekuda kweizvozvo, pachave neakawanda zviito izvo zvisiri izvo munhu wese anogona kunzwisisa kubva pachiremwaremwa.
Asi mutsara kudzoreredza kunotendera iwe kuti usiye zvachose mafomula akaoma uye kuronga. Ingoshandisa autocomplete. Mushandisi anotora huwandu hwe data pahwaro hwekuti kufanotaura kunoitwa. Iyi seti yemasero inosarudzwa, ipapo bhatani rekurudyi rinodzvanywa, iro raunoda kukwevera huwandu nenhamba inodiwa yemasero (zvichienderana nechinhambwe chepfungwa mune ramangwana iro kukosha kwakafanotaurwa kuverengerwa). Menyu yezvinyorwa ichaonekwa, kwaunoda kusarudza "Linear Approximation" chinhu. Ndizvozvo, kufanotaura kunowanikwa kusingade hunyanzvi hwemasvomhu, kuronga kana kutora mafomula.
Kana zviratidzo zvichiwedzera panguva imwe neimwe yenguva neimwe muzana, saka tiri kutaura nezve exponential kukura. Semuenzaniso, kufanotaura kushanduka kwedenda kana kufanotaura kufarira padhipoziti yebhangi kunoenderana nemaitiro akadaro.
Iko hakuna imwe nzira inoshanda yekufanotaura kukura kweexponential kupfuura iyo yatatsanangura.
Kushandisa mbeva kuzadza otomatiki misi
Kazhinji zvakakosha kuwedzera rondedzero iripo yemazuva. Kuti uite izvi, rimwe zuva rinotorwa uye rinodhonzwa nekona yezasi yekurudyi nebhatani rekuruboshwe. A square icon inooneka, kwaunogona kusarudza nzira yekuzadza.
Semuenzaniso, kana accountant akashandisa spreadsheet, sarudzo ye "weekdays" ichaenderana naye. Zvakare, chinhu ichi chinozodiwa nedzimwe nyanzvi dzinofanirwa kuita zvirongwa zvezuva nezuva, semuenzaniso, HR.
Uye heino imwe sarudzo, maitiro ekuita otomatiki kuzadza kwemazuva negonzo. Semuenzaniso, kambani inofanirwa kubhadhara mihoro pa15 uye zuva rekupedzisira remwedzi. Zvadaro, unofanira kuisa misi miviri, kutambanudza pasi uye sarudza nzira yekuzadza "nemwedzi". Izvi zvinogona kuitwa nekudzvanya bhatani rekuruboshwe mbeva pane sikweya iri pakona yekurudyi, kana nekushandisa bhatani rekurudyi, richiteverwa nekufona otomatiki kumenyu yezvirimo.
Zvakakosha! Yegumi neshanu inoramba iripo, zvisinei nemwedzi, uye yekupedzisira inongoitika otomatiki.
Nebhatani rekurudyi rembeva unogona kugadzirisa mafambiro. Semuenzaniso, ita rondedzero yemazuva ekushanda gore rino, ayo achange achiri kusvika Zvita 31. Kana iwe ukashandisa otomatiki nebhatani rekurudyi mbeva kana kuburikidza nemenu, iyo inogona kuwanikwa kuburikidza nesikweya, saka pane sarudzo "Instant zadza". Kwenguva yekutanga, vagadziri vakapa chinhu ichi muExcel 2013. Izvo zvinodiwa kuti masero azadzwe maererano neimwe nzira. Izvi zvichakubatsira kuchengetedza nguva yakawanda.
mhedziso
Chaizvoizvo, ndizvo chete. Autocomplete chinhu chinobatsira kwazvo chinokubatsira kuti uite otomatiki mafambiro ebasa uye kuita fungidziro zvichienderana nemapateni. Hapana mamwe mafomula kana masvomhu anodiwa. Zvakakwana kudzvanya mabhatani akati wandei, uye mibairo ichaonekwa sekunge nemashiripiti.