Okuqukethwe
Kulesi sihloko esinezingxenye ezimbili, uTerry ukhuluma ngenjongo yezitayela ku-Microsoft Excel. Engxenyeni yokuqala, uzofunda ukufometha amaseli ngobuhlakani, futhi engxenyeni yesibili, uzofunda izinketho zokufometha ezithuthuke kakhulu.
Izitayela kuMicrosoft Excel ngokungangabazeki ngesinye sezici ezinganakwa kakhulu, ezingasetshenziswa kancane, futhi ezibukelwa phansi ze-Excel.
Naphezu kokwanda kwesikhala ku-Ribbon ye-Microsoft Excel 2007 enikezelwe kulesi sici, abasebenzisi abaningi (ngibandakanyile nami) benza iphutha lokulungisa mathupha ukufometha kwamaseli ekhasini lokusebenzela, esikhundleni sokuchitha imizuzu embalwa yesikhathi sabo esiyigugu belungisa izitayela zangokwezifiso ezizokwenza ingasetshenziswa ngokuchofoza igundane okumbalwa nje.
Uyawazi lo mlayezo wephutha:Amafomethi eseli ahlukene kakhulu.“? Uma kunjalo, uzokuthola kuwusizo ukusebenzisa izitayela ku-Microsoft Excel.
Izitayela ze-Excel ezisetshenziswe ngobuhlakani zizokongela isikhathi ngokuhamba kwesikhathi! Ingasaphathwa eyokukhululeka okubalulekile ekufometheni kwamaseli, ukubukeka okufanayo kwamathebula kanye nokubonakala kwawo kalula. Futhi nokho, ngisho naphakathi kwabasebenzisi be-Excel abanolwazi kakhulu, leli thuluzi alikathandwa.
Lesi sihloko asihloselwe ukuphendula umbuzo wokuthi kungani singazisebenzisi izitayela ku-Microsoft Excel. Empeleni, kanye nezingxoxo mayelana nokuqinisa izincwadi zokusebenza ze-Microsoft Excel ngokuhlanganisa izitayela namathuluzi okuqinisekisa idatha.
Kulesi sihloko, sizobheka ukusebenza ngezitayela, lapho ngizokunikeza khona imiyalelo yesinyathelo ngesinyathelo sendlela yokusebenzisa leli thuluzi, bese, engxenyeni yesibili yesifundo, sizofunda amasu nezilungiselelo ezihlukahlukene. . Ngizokukhombisa ukuthi ungaphatha kanjani izitayela, wabelane ngemibono yokusebenzisa izitayela ze-Microsoft Excel emsebenzini wakho wansuku zonke, futhi uzothola amathiphu awusizo abhalwe ngokugqamile ezihlokweni zami.
Okokugcina, kufanele kushiwo ukuthi, njengoba kunjalo ngamathuluzi amaningi e-Microsoft, izitayela zikhona kuzo zonke izinhlelo zokusebenza ze-Microsoft Office suite. Lapha sizogxila ezitayeleni ku-Microsoft Excel, kodwa izisekelo namasu achaziwe azosebenza kunoma yiluphi uhlelo lwe-Microsoft Office.
Ngakho yiziphi izitayela kuMicrosoft Excel?
Izitayela kuMicrosoft Excel iyithuluzi elifinyelelwe ngaphansi kwethebhu Ikhaya (Ekhaya). Ikuvumela ukuthi usebenzise izinketho zokufometha ezilungiselelwe kusengaphambili kuseli noma iqembu lamaseli ngokuchofoza okumbalwa nje.
Kukhona iqoqo lezitayela ezisethiwe kakade futhi zilungele ukusetshenziswa. Ungakwazi ukufinyelela kuzo ngokumane uchofoze isithonjana. izitayela (Izitayela) njengoba kukhonjisiwe esithombeni esingenhla.
Uzokwethulwa ngezinketho eziningi (bheka isithombe esingezansi). Eqinisweni, usizo lwazo luyangabazeka. Kodwa ungakhathazeki, kungenzeka ukuthi uguqule izitayela ezisethiwe ukuze zivumelane nezidingo zakho, noma, okuthakazelisa nakakhulu, dala esakho isitayela sohlobo olulodwa! Sizogxila kulokhu ngokuningiliziwe engxenyeni yesibili ye-athikili.
Ukusebenzisa izitayela ku-Excel kukunikeza ukuzethemba kokuthi ukufometha kungaphansi kolawulo lwakho ngokuphelele. Ukusebenzisa izitayela kongela isikhathi osichitha ekufometheni ngokwenza amaseli ethebula futhi kukunikeza ukujula okwengeziwe kolwazi, ikakhulukazi uma usebenzisana (sizokhuluma kabanzi mayelana nolwazi lomsebenzisi ngokuhamba kwesikhathi).
Yini okudingeka uyazi ukusebenzisa izitayela ku-Microsoft Excel?
Uzojabula ukuzwa ukuthi azikho izimfuneko eziphelele zokusebenzisa izitayela ku-Microsoft Excel.
Yebo, kuyasiza ukujwayelana nengxoxo yokufometha nezinto zesitayela ngasinye, ikakhulukazi uma uhlela ukwenza esakho isitayela, kodwa lokhu akuyona imfuneko. Eqinisweni, leli thuluzi kulula kakhulu ukusebenza nalo, ngisho nakulabo asebeqale i-Excel okokuqala!
Izinketho ezitholakalayo zokufometha zesitayela zihlanganisa izici zamaseli ayisithupha, ahambisana namathebhu ayisithupha ebhokisini lengxoxo. Fometha Amaseli (ifomethi yeseli).
Singasebenzisa noma iyiphi inombolo yezakhi zokufometha ezitholakalayo kusibaluli ngasinye, into ebaluleke kakhulu ukungena ngaphakathi kwemikhawulo echazwe yi-Microsoft Excel, okungamafomethi amaseli ahlukene angaba ngu-4000 encwadini yokusebenzela eyodwa (ukugwema umlayezo wephutha we-Excel oshiwo ngenhla).
Inothi Lomhumushi: Ku-Excel 2003 nangaphambili (isandiso.xls), inani eliphezulu lamafomethi angalondolozwa kufayela yizinhlanganisela eziyingqayizivele ezingu-4000. Ku-Excel 2007 nakamuva (extension .xlsx), le nombolo ikhuphuke yaba amafomethi angu-64000.
Kubalulekile ukukhumbula ukuthi, njenge-macro, noma yisiphi isitayela esisha sokufometha se-Microsoft siqondene nencwadi. Lokhu kusho ukuthi zilondolozwe encwadini ethile yokusebenzela futhi zizotholakala kuphela kuleyo ncwadi yokusebenzela uze ungenise isitayela kwenye incwadi yokusebenzela. Sizobona ukuthi lokhu kwenziwa kanjani engxenyeni yesibili yesihloko.
Indlela yokusebenzisa isitayela esethiwe?
Ukuze usebenzise isitayela esilungiselelwe ngaphambili kumaseli e-Excel:
- Khetha amaseli okufanele kusetshenziswe isitayela kuwo.
- Vula ku-Microsoft Excel Ribbon: Ikhaya (Ekhaya) > izitayela (Isitayela) > Izitayela zamaseli (izitayela zamaseli)
Iseluleko esiwusizo! Sicela uqaphele ukuthi lapho ukhetha izitayela, ukuhlola kuqala okusebenzisanayo kuyasebenza - lokhu kusho ukuthi uma uhamba phezu kwezinketho zesitayela ezihlukahlukene, amaseli akhethiwe ayashintsha. Umbono omuhle, Microsoft!
- Khetha noma yisiphi isitayela samaseli ngokuchofoza kuso ngegundane.
Yilokho kuphela! Wonke amaseli akhethiwe azofomethwa ngokwesitayela esikhethiwe!
Iseluleko esiwusizo! Uma ususichazile isitayela samaseli, ukushintsha noma yiziphi izici zokufometha ngesikhathi esifanayo kuzoba umsebenzi wekota womzuzu kuwe, kuncishiswe ekushintsheni amapharamitha esitayela, esikhundleni sokuthi amahora achithwa kuphindaphindwa futhi kushintshwa amafomethi mathupha. etafuleni!
Kunoma ngubani onentshisekelo yokufunda okwengeziwe ngezinketho zesitayela ezithuthukisiwe ku-Microsoft Excel, hlola ingxenye yesibili ye-athikili yami.