Izindlela ezi-6 Zokukhipha Ifomula Kuseli Ye-Excel

Ispredishithi i-Excel sinenani elikhulu lemisebenzi ekuvumela ukuthi usebenze ngokuphumelelayo ngenani elikhulu lolwazi kanye nezibalo ezihlukahlukene. Kuvamise ukwenzeka ukuthi umsebenzisi udinga ukususa ifomula okwabalwa ngayo umphumela, futhi ashiye ingqikithi kuseli. Isihloko sizoxoxa ngezindlela ezimbalwa zokususa amafomula kumaseli espredishithi e-Excel.

Isusa amafomula

Isipredishithi asinalo ithuluzi elihlanganisiwe lokususa ifomula. Lesi senzo singenziwa ngezinye izindlela. Ake sihlaziye ngayinye ngokuningiliziwe.

Indlela 1: Kopisha Amanani Usebenzisa Izinketho zokunamathisela

Inketho yokuqala iyona esheshayo futhi elula. Indlela ikuvumela ukuthi ukopishe okuqukethwe komkhakha futhi ukuyise kwenye indawo, ngaphandle kwamafomula kuphela. Imiyalo enemininingwane imi kanje:

1. Senza ukukhetha kweseli noma uhla lwamaseli, esizolikopisha ngokuzayo.

2. Sicindezela i-RMB entweni engafanele yendawo ekhethiwe. Kuvela imenyu yokuqukethwe encane, lapho kufanele ukhethe khona into ethi "Kopisha". Enye inketho yokukopisha ukusebenzisa inhlanganisela yokhiye "Ctrl + C". Inketho yesithathu yokukopisha amanani ukusebenzisa inkinobho ethi "Kopisha" etholakala kubha yamathuluzi yesigaba "Ekhaya".

3. Khetha iseli esifuna ukunamathisela kulo ulwazi olukopishwe ngaphambilini, chofoza kwesokudla kulo. Imenyu yokuqukethwe ejwayelekile iyavula. Sithola ibhulokhi ethi "Namathisela Izinketho" bese uchofoza into ethi "Values", ebukeka njengesithonjana esinesithombe sokulandelana kwezinombolo "123".

4. Ilungile! Ulwazi olukopishiwe ngaphandle kwamafomula ludluliselwe endaweni entsha ekhethiwe.

Indlela yesi-2: Sebenzisa Namathisela Okukhethekile

Kukhona okuthi "Namathisela Okukhethekile" okukusiza ukuthi ukopishe ulwazi futhi ulunamathisele kumaseli kuyilapho ugcina ukufometha kwangempela. Ulwazi olufakiwe ngeke luqukathe amafomula. Imiyalo enemininingwane imi kanje:

1. Sikhetha ububanzi esifuna ukubunamathisela endaweni ethile bese sibukopisha sisebenzisa noma iyiphi indlela ekulungele wena.

2. Sithuthela kuseli lapho sifuna ukuqala ukunamathisela idatha ekopishiwe, chofoza kwesokudla kuyo. Imenyu yokuqukethwe encane ivuliwe. Sithola into ethi "Namathisela Okukhethekile" bese uchofoza isithonjana somcibisholo esitholakala kwesokudla sale elementi. Kumenyu eyengeziwe evelayo, chofoza umbhalo othi "Values ​​nokufometha komthombo".

3. Kwenziwe, umsebenzi uqedwe ngempumelelo!

Indlela yesi-3: Susa Amafomula Kuthebula Lomthombo

Okulandelayo, ake sikhulume ngendlela yokususa amafomula kuthebula lokuqala. Imiyalo enemininingwane imi kanje:

1. Sikopisha ububanzi bamaseli nganoma iyiphi indlela etholakalayo. Isibonelo, sebenzisa inhlanganisela yokhiye "Ctrl + C".

2. Njengendlela okuxoxwe ngayo ngaphambilini, sinamathisela ngenkathi sigcina ukufometha koqobo komunye umkhakha weshidi lokusebenzela. Ngaphandle kokukhipha okukhethiwe, sikopisha idatha futhi.

3. Sithuthela emkhakheni osekhoneni eliphezulu kwesokunxele, cindezela u-RMB. Imenyu yokuqukethwe ejwayelekile iyavela, lapho kufanele ukhethe khona into ethi "Values".

4. Ukugcwaliswa kwamaseli ngaphandle kwamafomula kukopishelwe endaweni yokuqala. Manje usungakwazi ukususa amanye amathebula ebesiwadinga ngenqubo yokukopisha. Khetha izimpinda zethebula nge-LMB bese uchofoza endaweni yokukhetha nge-RMB. Kuvela imenyu yokuqukethwe, lapho kufanele uchofoze into ethi "Susa".

5. Iwindi elincane elithi "Susa amaseli" liboniswe esikrinini. Lapha ungakhetha ozokususa. Sibeka into eduze nombhalo othi "Line" bese uchofoza "Kulungile". Esibonelweni sethu, awekho amaseli anedatha ngakwesokudla sokukhethiwe, ngakho-ke inketho ethi "Amaseli, ashintshelwe kwesokunxele" nayo ifanelekile.

6. Amathebula ayimpinda akhishwa ngokuphelele ekhasini lokusebenza. Senze ukushintshwa kwamafomula ngezinkomba ezithile kuthebula lokuqala.

Indlela yesi-4: Susa amafomula ngaphandle kokukopishela kwenye indawo

Abanye abasebenzisi bespredishithi se-Excel bangase banganeliseki ngendlela yangaphambilini, ngoba ibandakanya inani elikhulu lokukhohlisa lapho ungadideka khona. Kukhona okunye ukuhluka kokususa amafomula etafuleni lokuqala, kodwa kudinga ukunakekelwa ngasohlangothini lomsebenzisi, njengoba zonke izenzo zizokwenziwa kuthebula ngokwalo. Kubalulekile ukwenza konke ngokucophelela ukuze ungasusi ngephutha amanani adingekayo noma "ungaphuli" ukwakheka kwedatha. Imiyalo enemininingwane imi kanje:

1. Ekuqaleni, njengasezindleleni ezedlule, sikhetha indawo lapho kudingeka khona ukususa amafomula nganoma iyiphi indlela ekulungele wena. Okulandelayo, sikopisha amanani ngenye yezindlela ezintathu.

2. Ngaphandle kokukhipha okukhethiwe, chofoza endaweni ye-RMB. Imenyu yokuqukethwe iyavela. Ebhokisini lomyalo elithi "Namathisela Izinketho", khetha into ethi "Values".

3. Ilungile! Njengomphumela wokukhohlisa okwenziwe kuthebula lokuqala, amafomula athathelwa indawo amanani athile okubala.

Indlela yesi-5: Faka isicelo seMacro

Indlela elandelayo ihlanganisa ukusetshenziswa kwama-macros. Ngaphambi kokuthi uqale ukususa amafomula etafuleni bese uwashintsha ngamavelu athile, udinga ukunika amandla “Imodi Yonjiniyela”. Ekuqaleni, le modi ikhutshaziwe kusiprosesa sespredishithi. Imiyalo enemininingwane yokunika amandla "Imodi Yonjiniyela":

1. Chofoza kuthebhu ethi “Ifayela”, etholakala phezulu kusixhumi esibonakalayo sohlelo.

2. Kuvulwe iwindi elisha, lapho ohlwini olungakwesokunxele lwezici udinga ukuya phansi kakhulu bese uchofoza "Amapharamitha".

3. Izilungiselelo ziboniswa ngakwesokudla. Thola ingxenye ethi “Yenza ngokwezifiso iRibhoni” bese uchofoza kuyo. Kunamabhokisi ohlu amabili. Ohlwini olufanele sithola into ethi "Unjiniyela" bese ubeka uphawu eduze kwayo. Ngemva kokuqeda zonke izikhohlisi, chofoza "OK".

4. Ilungile! Imodi yonjiniyela inikwe amandla.

Imiyalo enemininingwane yokusebenzisa i-macro:

1. Sidlulela kuthebhu ethi "Unjiniyela", etholakala phezulu kwesixhumi esibonakalayo sespredishithi. Okulandelayo, thola iqembu lepharamitha ethi "Ikhodi" bese ukhetha into ethi "Visual Basic".

2. Khetha ishidi olifunayo ledokhumenti, bese uchofoza into ethi "Buka Ikhodi". Ungenza umsebenzi ofanayo ngokuchofoza kabili eshidini olifunayo. Ngemuva kwalesi senzo, umhleli omkhulu uyavela esikrinini. Namathisela ikhodi elandelayo endaweni yomhleli:

Amafomula_okususa_okulandelayo()

Selection.Value = Selection.Value

Qeda i-Sub

3. Ngemva kokufaka ikhodi, chofoza esiphambanweni ekhoneni eliphezulu kwesokudla kwesikrini.
4. Sikhetha ububanzi lapho amafomula atholakala khona. Okulandelayo, iya engxenyeni ethi "Unjiniyela", thola ibhulokhi yomyalo "Ikhodi" bese uchofoza into ethi "Macros".

5. Kuvele iwindi elincane elibizwa ngokuthi “Macro”. Khetha i-macro esanda kwakhiwa bese uchofoza u-Run.

6. Ilungile! Wonke amafomula kumaseli athathelwe indawo yimiphumela yokubala.

Indlela yesi-6: susa ifomula kanye nomphumela wokubala

Kwenzeka ukuthi umsebenzisi we-Excel spreadsheet processor akadingi nje kuphela ukusebenzisa ukususwa kwamafomula, kodwa futhi ukususa imiphumela yokubala. Imiyalo enemininingwane imi kanje:

1. Njengakuzo zonke izindlela ezedlule, siqala umsebenzi wethu ngokukhetha ububanzi lapho amafomula atholakala khona. Bese uchofoza kwesokudla endaweni yokukhetha. Imenyu yokuqukethwe ivela esibukweni. Thola into ethi "Sula okuqukethwe" bese uchofoza kukho. Enye inketho yokususa ukucindezela inkinobho ethi "Delete".

2. Njengomphumela wokukhohlisa, yonke idatha kumaseli akhethiwe yasuswa.

Ukususa ifomula ngenkathi kugcinwa imiphumela

Ake sicabangele ngokuningiliziwe ukuthi ungayisusa kanjani ifomula ngenkathi ulondoloza umphumela. Le ndlela ihlanganisa ukusebenzisa impahla ethi Namathisela Amanani. Imiyalo enemininingwane imi kanje:

1. Khetha iseli noma ububanzi lapho ifomula esiyidingayo itholakala khona. Uma kuyifomula yamalungu afanayo, kufanele uqale ukhethe wonke amaseli kububanzi aqukethe ifomula yamalungu afanayo.
2. Chofoza iseli kufomula yamalungu afanayo.
3. Iya engxenyeni ethi “Ekhaya” futhi uthole ibhulokhi yamathuluzi ethi “Ukuhlela”. Lapha sichofoza isici esithi "Thola bese ukhetha", bese sichofoza inkinobho ethi "Hamba".
4. Ewindini elilandelayo, chofoza okuthi "Okwengeziwe", bese uchofoza into ethi "Uhlelo Lwamanje".
5. Sibuyela esigabeni "Ekhaya", thola into ethi "Kopisha" bese uchofoza kuyo.
6. Ngemva kokwenza inqubo yokukopisha, chofoza umcibisholo, otholakala ngaphansi kwenkinobho ethi "Namathisela". Esinyathelweni sokugcina, chofoza okuthi "Faka Amanani".

Isusa ifomula yamalungu afanayo

Ukuze wenze inqubo yokususa ifomula yamalungu afanayo, okokuqala udinga ukuqinisekisa ukuthi wonke amaseli kububanzi aqukethe ifomula oyifunayo akhethiwe. Imiyalo enemininingwane imi kanje:

1. Khetha umkhakha owufunayo kufomula yamalungu afanayo.
2. Sithuthela engxenyeni ethi "Ekhaya". Sithola ibhulokhi yamathuluzi "Ukuhlela" bese uchofoza into ethi "Thola bese ukhetha".
3. Okulandelayo, chofoza okuthi "Hamba", bese ku-elementi "Okwengeziwe".
4. Chofoza ku- "Uhlelo Lwamanje".
5. Ekupheleni kwenqubo, chofoza "Susa".

Isiphetho

Ukufingqa, singasho ukuthi akukho lutho oluyinkimbinkimbi ekususeni amafomula kumaseli esipredishithi. Kunenqwaba yezindlela zokususa, ukuze wonke umuntu azikhethele okungcono kakhulu.