Indlela yokulondoloza nokwabelana ngezincwadi zokusebenza ku-Excel

Ukwabelana ngencwadi yokusebenzela ye-Excel akukhona nje ukuthumela ifayela nge-imeyili: namuhla kunezindlela ezihlukene zokumema abanye abantu, hlela ndawonye ngesikhathi esifanayo futhi ulawule ukuthi umhlanganyeli ngamunye angenzani. Kulo mhlahlandlela, sichaze kabanzi ngendlela yokulondoloza, ukwabelana, nokuphatha izincwadi zokusebenza ku-Excel, kokubili kusetshenziswa izinketho zesimanje kanye nendlela yencwadi yokusebenzela eyabelwe yakudala, kanye nemikhawulo yazo kanye tricks ukuze ungaphunyuki lutho.

Uma usebenza namaqembu noma amakhasimende, uzofuna ukwazi ukuthi uyisebenzise nini i-Excel Yewebhu nokuthi uzoyisebenzisa nini isistimu yebhuku lokusebenza okwabelwana ngalo endala. Kuso sonke lesi sihloko, uzobona ukuthi yiziphi izinhlelo zokusebenza ezivumela ukubhala ngokubambisana, ukuthi ungamema kanjani abantu nge-imeyili ngesixhumanisi, kanjani ukusetha ukufunda kuphela futhi, okubaluleke kakhulu, iziphi izici ezivinjiwe ezincwadini ezivamile ezabiwe ukuze ungatholi noma yiziphi lezimanga.

Izindlela zokwabelana ngencwadi yokusebenzela ye-Excel

Uma wabelana ngewebhu ku-Excel, abamukeli bathola i-imeyili yesimemo enesixhumanisi sefayela; bamane bachofoze ukuze bayivule esipheqululini sabo, lapho izovezwa khona nge-Excel kuwebhu. Ukusuka lapho, bangakhetha phakathi Hlela ibhuku kanye nezinketho zokuthi Hlela kusiphequluli noma Hlela ku-Excel, kuye ngokuthi ukhetha ukusebenza esipheqululini noma kuhlelo lokusebenza lwedeskithophu.

Ukubhala ngokubambisana kwesikhathi sangempela kuvumela abantu abaningi ukuthi bahlele ibhuku lokusebenza elifanayo ngesikhathi esisodwa. Ukuze lokhu kusebenze, bonke ababambiqhaza kufanele babe nenguqulo ehambisanayo yokubhala ngokubambisana: I-Excel ye Android, Excel for iOS, I-Excel Mobile kanye nokubhalisela ku I-Microsoft 365Uma othile engahlangabezani nalezi zimfuneko, usengahlela esipheqululini ngokukhetha okuthi Hlela Kusiphequluli, ukuze wonke umuntu akwazi ukunikela ngaphandle kokuvinjwa.

Ngendlela yakudala (yakudala) yencwadi yokusebenzela eyabelwe, ngemva kokunika amandla inketho yokuvumela abasebenzisi abaningi ukuthi bahlele, uzobona i-Excel imaka ifayela njengelabelwe ngokubonisa umbhalo kubha yesihloko. Nokho, ukuze abanye bakwazi ukuyifinyelela futhi bayihlele, incwadi yokusebenzela kufanele igcinwe endaweni okufinyeleleka kuyo, njenge idrayivu yenethiwekhi eyabiwe wonke umuntu abone.

Imininingwane ewusizo: uma usanda kwabelana ngohlelo lwakudala, i-Excel izocela ukuqinisekiswa ngenkinobho ethi KULUNGILE; uma wenza njalo, isimo okwabelwana ngaso sigcinwa futhi siyasebenza. Gcina indlela efanayo kubo bonke abasebenzisi, njengoba lokhu kubalulekile ukuze incwadi isebenze njengendawo yokusebenza emaphakathi.

Ukubhala ngokubambisana nokubonakala kwezinketho

Uma wena nethimba lakho nisebenza ndawonye, ​​i-Excel ingase ibonise ububanzi obukhethiwe bomuntu ngamunye ngemibala ehlukene. Lokhu kwenzeka uma usebenzisa i-Excel ye-Microsoft 365 ngokubhalisele, i-Excel yewebhu, I-Excel ye-Android noma i-Excel ye-iOS. Ukwengeza, ku-Microsoft 365, i-AutoSave kufanele inikwe amandla ukuze lezo zinketho ezinemibala zivele ngesikhathi sangempela.

Uma ungaziboni ezinye izinketho, linda imizuzwana embalwa; ngezinye izikhathi isibuyekezo sithatha isikhathi ukufika. Uma namanje zingaveli, hlola ukuthi empeleni usebenzisa i-Excel ye-Microsoft 365, i-Excel yewebhu, i-Android, noma i-iOS. Nge-Excel Mobile Okukhethiwe akuboniswa, nakuba izinguquko zabanye abantu ziboniswa cishe ngokushesha. Ngezinguqulo zangaphambili ze-Excel, lokhu kuhlelwa ngasikhathi sinye akutholakali, futhi ngeke ukwazi ukubona ukukhetha kwakho.

Ezimweni ezixubile, kuhle ukuncoma ukuthi bonke abahlanganyeli basebenzise inguqulo ehambisanayo ebhalwe ngokuhlanganyela. Ngale ndlela, ngeke nje ubone okukhethiwe kombala, kodwa uzogwema ukuvinjwa kanye nokungqubuzana okungadingekile lapho ulondoloza.

Yabelana njengokufunda kuphela ku-Excel yewebhu

Kunezikhathi lapho ufuna ukuthi abanye bakwazi ukuvula ibhuku lokusebenza ngaphandle kokuthinta idatha. Ku-Excel kuwebhu, ungasetha ukufinyelela kokufunda kuphela ukuze uqinisekise ukuthi akekho oyihlela ngephutha. Lesi silungiselelo silula futhi sikuvumela ukuthi ulawule izimvume ezivela ngaphakathi kwebhuku lokusebenzela. iphaneli yokwabelana.

1. Ebhukwini lakho, iya kokuthi Ifayela > Yabelana > Yabelana nabanye (noma sebenzisa inkinobho yokwabelana ekhoneni eliphezulu kwesokudla).
2. Ebhokisini elithi Faka igama noma ikheli le-imeyili, faka amakheli e-imeyili abamukeli; uma uke wazisebenzisa ngaphambili, zingavela njengeziphakamiso. Ngemva kokuthayipha ikheli ngalinye, cindezela u-Enter ukuze ulingeze.
3. Ukuze ukhawulele izimvume, hamba kuzilungiselelo zesixhumanisi bese ususa ukumaka inketho yokuhlela; uzobona ukuthi manje ithi noma ubani onesixhumanisi angayibuka. Qinisekisa ngokuthi Faka ukuze ukusethele kumodi yokufunda kuphela.
4. Ekugcineni, khetha okuthi Thumela ukuze uthumele isixhumanisi nge-imeyili. I-Excel yewebhu izokhiqiza i-imeyili enokufinyelela kokufunda kuphela kubamukeli bakho obakhethile.

Ngale ndlela, unganikeza ukufinyelela okusheshayo kubantu abaningi kuyilapho ugcina idatha yakho ivikelekile ezinguqukweni; ilungele imibiko ofuna ukuyibuka kodwa ongayishintshi. ngaphandle kokuphinda amafayela noma ulahlekelwe ukulawula inguqulo eyinhloko.

Indlela yencwadi eyabiwe yakudala: ukwenza kusebenze nokuhamba komsebenzi

Nakuba kuwuhlelo oludala, kusengenzeka ukusebenzisa incwadi yomsebenzi eyabiwe evamile. Ungayinika amandla kuthebhu yokubuyekeza usebenzisa umyalo ohambisanayo futhi uhlole ibhokisi elivumela abasebenzisi abaningi ukuthi balihlele ngesikhathi esisodwa. Ngemva kokwamukela, i-Excel izokwazisa ukuthi ulondoloze ifayela bese ulimaka njenge okwabiwe.

Ngale ndlela, kunconywa ukuthi ulondoloze ibhuku lomsebenzi kufolda yenethiwekhi okwabelwana ngayo, hhayi kuseva yewebhu, ukuze bonke abasebenzisi babe nokufinyelela okungaguquki. Lapho ibhuku lokusebenza okwabelwana ngalo lenziwa, i-Excel iqala ukuqopha umlando woshintsho ngemininingwane efana negama lomsebenzisi wokuhlela, usuku nesikhathi kanye nedatha eqondile eshintshiwe. Leli rekhodi lenza kube lula ukuhlola okwenzekile nokwenza izinqumo.

Umbhali angachaza isikhathi lapho izinguquko zizogcinwa khona emlandweni. Ngokuzenzakalelayo, izinsuku ezingama-30 ziyagcinwa, kodwa zingalungiswa ukuze kugcinwe isikhathi esiningi noma esincane kuye ngezidingo. Lokhu kusiza ukugcina usayizi wefayela ekuqhumeni futhi kugcina ukuqapha kulawuleka esikhathini esimaphakathi. ngaphandle kokuyekethisa ukusebenza.

Esinye isici sesistimu yakudala yikhono lokubuyekeza izinguquko ekulondolozweni: uma ulondoloza incwadi yokusebenza, noma yiziphi izinguquko ezenziwe abanye abasebenzisi kusukela ngesikhathi sokugcina zifakiwe. Uma uthanda, unganika amandla izibuyekezo ezizenzakalelayo ngezikhathi ezimisiwe ukuze ubone inqubekelaphambili ngaphandle kokuncika ekulondolozeni kwakho.

Ukuphatha ukuthi ubani ongenayo nokulandelela izinguquko

Kuthebhu ethi Buyekeza, ungabona uhlu lwabantu abanencwadi yokusebenza evuliwe njengamanje. Isigaba esithi "Abasebenzisi abalandelayo banale ncwadi yokusebenzela evuliwe" sibonisa ukuthi ubani ohlelayo ngaso sonke isikhathi, okusiza ukuthi uhlanganise umsebenzi. Uma othile edinga ukuhamba ukuze asebenzise ushintsho olubucayi, ungalubheka uthi shazi. ngaphandle kokucabangela.

Ukuze uhlole izibuyekezo, zakudala Shintsha ukulawula Leli ithuluzi elimaphakathi. I-Excel irekhoda imininingwane ngaso sonke isikhathi uma ulondoloza. Ungakhetha ukuthi uzibuka kanjani: zigqanyiswe eshidini ngokwalo ukuze zibukezwe, noma eshidini Lomlando elinakho konke okufakiwe okuhleliwe, okuwusizo emibikweni nasezinqumweni ezisemthethweni.

Uma ufuna ukwenza ngcono umbono wakho womlando, izinketho zikuvumela ukuthi uhlunge ngedethi (ngokwesibonelo, kusukela ngedethi ethile), ngombhali othile, noma ngohlu oluthile lwamaseli. Ngale ndlela, ungagxila kuphela kulokho okubalulekile, noma ngabe uqinisekisa ibhulokhi yedatha. noma ukubuyekeza umsebenzi womsebenzisi ngokuqondene.

Khumbula ukuthi ukuze umlando ube khona, ukulandela kokushintsha kufanele kunikwe amandla uma uhlela. Uma kungenjalo, alikho irekhodi lokuhlela okudlule elizotholakala. Sebenzisa lesi silungiselelo ngaphambi kokuqala inkathi yokubambisana okukhulu ukuze kuqinisekiswe ukulandeleka.

Umlando nesikhathi sokugcina

Umlando woshintsho ugcinwa kuphela isikhathi esishiwo. Ngokuzenzakalelayo, yizinsuku ezingama-30. Ungakwazi ukwandisa noma unciphise lesi sikhawu endaweni Yokulandela Ukushintsha, ubonise ukuthi zingaki izinsuku okufanele uzigcine. Kubalulekile ukusetha inombolo efanelekile, ngoba i-Excel isusa unomphela izinguquko kulogi endala kunalowo mkhawulo. ngaphandle kokuba nethuba lokuzibuyisa.

Uma uzoshintsha isikhathi, kwenze lapho iqembu lazi, ikakhulukazi uma likhona ukucwaningwa kwamabhuku noma izimfuneko zangaphakathi ezidinga ukugcinwa komkhondo isikhathi esithile. Inani eliphansi kakhulu lingase lishiye ngaphandle imicimbi oyodinga ukuyibuza kamuva; inani eliphakeme kakhulu lingavimba ifayela, libe nomthelela ekusebenzeni.

Ukuxazulula londoloza izingxabano

Uma abantu ababili behlela iseli elifanayo futhi balondoloza, kungase kuphakame izingxabano. Uma kunjalo, i-Excel ibonisa ibhokisi lengxoxo Lokuxazululwa Kwengxabano komunye wabasebenzisi ukuze anqume ukuthi iyiphi inguqulo okufanele igcinwe. Wonke umuntu ohlelayo unegunya elilinganayo lokukhetha, futhi umuntu wokugcina ozogcinwa ngokuvamile kube nguye othola isaziso ukuze axazulule. ukuqhathanisa izinguquko.

Kulelo windi, ungagcina ukuguqulwa kwakho kwamanje (Yamukela okwami) noma ugcine okomunye umuntu (Yamukela abanye) futhi ubuyekeze ukungqubuzana ngokungqubuzana. Uma uthanda, kunezinketho zomhlaba wonke ze Yamukela konke okwami noma Yamukela zonke ezinye, ziwusizo kakhulu uma udinga ukuvala ngokushesha inqwaba yokungefani.

Uma ufuna ukugwema ukubona ibhokisi lezingxabano futhi uhlale unezinguquko ezigciniwe ezikhona, ungakhubaza lesi sixwayiso ngokuvumela okuthandwayo okuhambisanayo kuzilungiselelo ezithuthukisiwe zebhuku lomsebenzi okwabelwana ngalo. Ukwengeza, izinqumo ezenziwe zibonakala eshidini Lomlando elinamakholomu afana Nohlobo Lwesenzo kanye Nesenzo Sokulahlekelwa, lapho uzobona khona ukuthi yikuphi okufakiwe okugciniwe nokuthi yikuphi okungagcinwanga. kanye nezinkomba zabo.

Imikhawulo yendlela yencwadi eyabiwe

Uhlelo lwezincwadi olwabiwe lwendabuko luyisixazululo sefa ngakho-ke luye lwakwenza lokho imikhawulo eminingi. Uma uyisebenzisa, ezinye izici azitholakali. Ukuze ugweme noma yiziphi izimanga, nalu uhlu oluphelele lwezinto ezingasekelwe nezenzo ezivinjiwe ngenkathi ibhuku lokusebenza labelwa.

Izinto ezingasekelwe ezincwadini zokusebenza ezabiwe zakudala (ayikwazi ukudalwa noma ukushintshwa ngesikhathi isebenza):

• Akwenzeki ukudala noma ukufaka amatafula.
• Amafomethi anemibandela awanakungezwa noma ashintshwe.
• Ukuqinisekiswa kwedatha akukwazi ukwengezwa noma ukushintshwa.
• Imibiko yamashadi ne-PivotChart ayikwazi ukudalwa noma ukushintshwa.
• Awukwazi ukufaka noma ukuguqula izithombe noma ezinye izinto ezishumekiwe.
• Izixhumanisi azikwazi ukufakwa noma ukuhlelwa.
• Izimo azikwazi ukudalwa, ukushintshwa, noma ukubukwa.
• Izinombolo ezincane ezizenzakalelayo azikwazi ukufakwa.
• Amathebula edatha awakwazi ukudalwa.
• Imibiko ye-PivotTable ayikwazi ukudalwa noma ukushintshwa.
• Ukuhlukaniswa kwedatha akukwazi ukudalwa noma ukusetshenziswa.
• Olayini bezinhlansi abakwazi ukudalwa noma ukushintshwa.
• Awukwazi ukwengeza noma ukushintsha amashidi engxoxo. I-Microsoft Excel 4.
• Amazwana anentambo awakwazi ukungezwa.

Izenzo ezingavunyelwe ngenkathi incwadi yabiwa:

• Amabhulokhi amaseli awakwazi ukufakwa noma ukususwa.
• AmaSpredishithi awakwazi ukususwa.
• Awukwazi ukuhlanganisa amaseli noma ukuhlukanisa amaseli ahlanganisiwe.
• Awukwazi ukuhlunga noma ukuhlunga ngefomethi.
• Amathuluzi okudweba awakwazi ukusetshenziswa.
• Amaphasiwedi awakwazi ukunikezwa, ashintshwe, noma asuswe.
• Awukwazi ukuvikela noma ukungavikeli amashidi noma incwadi.
• Idatha ayikwazi ukuhlanganiswa noma ihlelwe.
• Amamakhro awakwazi ukubhalwa, ukurekhodwa, ukushintshwa, ukubukwa, noma ukunikezwa.
• Amafomu afanayo awanakushintshwa noma asuswe.
• Amamephu e-XML angeke angezwe, aqanjwe kabusha, noma asuswe.
• Amaseli awakwazi ukunikezwa izici ze-XML.
• Awukwazi ukusebenzisa iphaneli yomthombo we-XML, ibha yamathuluzi ye-XML, noma i- imiyalo Imenyu yedatha ye-XML.
• Awukwazi ukusebenzisa ifomu ledatha ukwengeza amarekhodi amasha.
• Amazwana anemicu awakwazi ukuhlelwa noma asuswe.

Njengoba ubona, le mikhawulo ithinta izici ezibalulekile ezifana namathebula, amashadi, ukuqinisekiswa, nokuvikela. Ngakho-ke, uma udinga ukusebenza ngalezi zici, kuwumqondo omuhle ukuzilungiselela ngaphambi kokwabelana noma ukucabangela izindlela zesimanje zokubhala ngokubambisana lapho le mikhawulo ingasebenzi. kuye ngesimo.

Yeka ukwabelana ngencwadi

Uma udinga ukubuyela ebhukwini lokusebenza elijwayelekile, ungayekisa ukusebenza okwabiwe. Qaphela ukuthi uma uyeka ukwabelana, umlando woshintsho ohlobene uyasuswa. Uma uthanda ukuligcina, phrinta Iphepha Lomlando noma ulikopishele kwenye incwadi yokusebenzela ngaphambi kokuqhubeka. ukuze ungalahlekelwa ukulandeleka.

Yazisa abahleli ukulondoloza nokuvala ifayela; uma kungenjalo, bazolahlekelwa yinoma yimuphi umsebenzi ongalondoloziwe. Qiniseka ukuthi nguwe kuphela ovela ohlwini lwabasebenzisi nencwadi yokusebenzela evuliwe. Bese, kuthebhu ethi Buyekeza, vula inketho ethi Yabelana Ngebhuku Lokusebenza, ungahloli Vumela abasebenzisi abaningi ukuhlela ngesikhathi esisodwa, futhi wamukele. Uma isilawuli sibonakala simpunga, uzodinga ukungalivikeli ishidi noma incwadi yokusebenzela ukuze wenze ushintsho.

Kokunye ukusetshenziswa, uzobona ukulandelana okuqondile kakhulu: kuthebhu ethi Buyekeza, khetha inkinobho ethi Yabelana Incwadi Yokusebenzela, susa ukumaka ibhokisi elithi Vumela ngesikhathi esisodwa ukuhlela, chofoza KULUNGILE, bese uqinisekisa ngokuthi Yebo lapho i-Excel ibuza. Lokhu kuzobuyisela ibhuku lokusebenza kumodi ekhethekile futhi ilebula yebha yesihloko izonyamalala.

Ukubuka ngokwezifiso kanye nezintandokazi ezivulekile

Uma incwadi yokusebenzela yabelwa kusetshenziswa indlela yakudala, i-Excel igcina ukubuka okwenziwe ngokwezifiso ngomsebenzisi ngamunye. Lokhu kubuka kungabandakanya ukuthi yiliphi ishidi eliboniswayo lapho livulwa, ileveli yokusondeza, izihlungi ezisetshenzisiwe, nezilungiselelo zokuphrinta. Ngokuzenzakalelayo, izihlungi nokuphrinta kuyagcinwa, nakuba ungase futhi ubonise ukuthi ukhetha ukusebenzisa izilungiselelo zangempela. ngokwezidingo zakho.

Le mininingwane ithuthukisa ukuzizwisa kwethimba, njengoba umuntu ngamunye engaba nombono wakhe ngaphandle kokuthikameza abanye. Uma udinga ukusondeza noma ukhethe ishidi elithile njalo uma uvula ifayela, i-Excel izokhumbula. okuthandayo inqobo nje uma isabelwe nalolu hlelo.

Izindawo nokulondoloza okufinyelelekayo

Kungakhathalekile ukuthi iyiphi indlela, kubalulekile ukulondoloza incwadi yokusebenzela endaweni efinyeleleka kubo bonke abahlanganyeli. Ngendlela yakudala, isincomo siyifolda yenethiwekhi okwabelwana ngayo. Ezimeni zesimanje zokubhala ngokubambisana, ukuyivula esipheqululini bese ukhetha Hlela ku-Explorer noma Hlela ku-Excel kunciphisa ukungqubuzana futhi kwenza kube lula kuwo wonke umuntu. ngena ngaphandle kwezinkinga.

Uma ubamema nge-imeyili, abamukeli bazobona umlayezo onesixhumanisi futhi bangawuvula esipheqululini sewebhu ngokubonisa ifayela besebenzisa i-Excel yewebhu. Uma bethanda ideskithophu, bakhetha Hlela Incwadi Yokusebenzela bese behlela ku-Excel; uma behlala esipheqululini, bakhetha Hlela Kusiphequluli. ukuguquguquka ikuvumela ukuthi uguqule ukugeleza kumsebenzisi ngamunye nedivayisi ngaphandle kokudela ukuhlanganyela.

Okokugcina, khumbula ukunika amandla ukulondoloza okuzenzakalelayo ezinguqulweni zokubhaliselwe ukuze ukubhala ngokuhlanganyela kungenazihibe futhi okukhethiwe kubuyekezwe ngombala lapho kufanele khona. Futhi uma nganoma isiphi isikhathi uqaphela ukuthi okukhethiwe akubonakali, qinisekisa ukuthi nonke nisebenza ngenguqulo eyodwa esekelwe futhi ninikeze isistimu imizuzwana embalwa. ngoba ukuvumelanisa kungase kuthathe isikhathi umzuzwana.

Isihluthulelo sokuphatha ukusebenzisana kahle ku-Excel ukukhetha imodi efanele yephrojekthi ngayinye nokuqonda imikhawulo yendlela evamile. Phakathi kwezimemo zesixhumanisi ezinezimvume ezilawulwayo, ukubhala ngokuhlanganyela kuzinguqulo ezihambisanayo, namathuluzi okulandelela ukungqubuzana nokuxazulula, unawo wonke amathuluzi okwabelana okuvikelekile. ngaphandle kokulahlekelwa ukulawula nokuqinisekisa ukuthi incwadi yakho iyindlela oyidinga ngayo.

I-athikili ehlobene:

Ungawabelana kanjani ngamafayela phakathi kwamadivayisi kunethiwekhi yendawo Windows 11

Isaka

Umbhali oshisekayo ngomhlaba wamabhayithi nobuchwepheshe ngokujwayelekile. Ngiyathanda ukwabelana ngolwazi lwami ngokubhala, futhi yilokho engizokwenza kule bhulogi, ngikubonise zonke izinto ezithakazelisayo kakhulu ngamagajethi, isofthiwe, ihadiwe, izitayela zobuchwepheshe, nokuningi. Inhloso yami ukukusiza ukuthi uzulazule emhlabeni wedijithali ngendlela elula nejabulisayo.