Susa amaseli angenalutho ku-Microsoft Excel

Uma wenza imisebenzi ku-Excel, kungadingeka ukususa amaseli angenalutho. Ngokuvamile kuyinto engadingekile futhi yandisa kuphela inani lemininingwane yedatha, kunokuba idideke umsebenzisi. Sichaza izindlela zokususa ngokushesha izinto ezingenalutho.

Ukususwa kwe-algorithms

Okokuqala, udinga ukuyiqonda, futhi kungenzeka ngempela ukususa amaseli angenalutho kuhlelo oluthile noma kuthebula? Le nqubo iholela ekubambeni kwedatha, futhi lokhu akuyona njalo evumelekile. Eqinisweni, izakhi zingasuswa kuphela ezimweni ezimbili:

• Uma umugqa (ikholomu) ungenalutho ngokuphelele (kumatafula);
• Uma amangqamuzana olayini nekholomu ayengavumelani omunye nomunye (ku-arrays).

Uma kunamaseli ambalwa angenalutho, angasuswa kalula ngokusebenzisa indlela evamile yokususa ibhukwana. Kodwa, uma kunenqwaba yezinto ezinjalo ezingazalwanga, ngakho-ke kulesi simo, le nqubo kufanele ibe yenzeke.

Indlela 1: Khetha Amaseli Amagatsha

Indlela elula yokukhipha izakhi ezingenalutho ukusebenzisa ithuluzi lokukhetha iqembu leseli.

1. Khetha ibanga kushidi, lapho sizokwenza khona ukuhlola nokususa izinto ezingenalutho. Sicindezela ukhiye womsebenzi kwikhibhodi F5.



2. Ugijima iwindi elincane elibizwa ngokuthi "Ukuguqulwa". Sicindezela inkinobho kuwo "Qinisekisa ...".



3. Iwindi elilandelayo livula - "Ukukhetha amaqembu amangqamuzana". Setha inkinobho endaweni "Amaseli angenalutho". Yenza ngokuchofoza inkinobho. "Kulungile".



4. Njengoba ubona, zonke izinto ezingenalutho ebangeni elicacisiwe zikhethiwe. Chofoza kunoma yimuphi wabo onenkinobho yegundane efanele. Kumenyu yomongo oqalisiwe, chofoza entweni "Susa ...".



5. Iwindi elincane livuleka lapho okudingeka ukhethe ukuthi yini okufanele isuswe. Shiya izilungiselelo ezizenzakalelayo - "Amaseli, ane-shift up". Sicindezela inkinobho "Kulungile".

Ngemva kwalokhu kusebenza, zonke izakhi ezingenalutho ngaphakathi kwebanga elicacisiwe zizosuswa.

Indlela 2: Ukufometha okunemibandela nokuhlunga

Ungaphinda ususe amaseli angenalutho ngokusebenzisa ukufometha okunemibandela bese uhlunga idatha. Le ndlela yinkimbinkimbi kunokwedlule, kodwa, noma kunjalo, abanye abasebenzisi bayayithanda. Ngaphezu kwalokho, udinga ukwenza ngokushesha ukubhuka ukuthi le ndlela ifanele kuphela uma amanani akhona kukholomu eyodwa futhi engenayo ifomula.

1. Khetha ibanga esizolihlola. Ukuba ngaphakathi kuthebhu "Ikhaya"chofoza kusithonjana "Ukufometha okunemibandela"okuyinto, futhi, itholakala ebhokisini lamathuluzi "Izitayela". Yiya entweni ohlwini oluvula. "Imithetho yokukhethwa kweseli". Kuhlu lwezenzo ezivela, khetha isikhundla. "Okuningi ...".



2. Ifasitela yokufometha okunemibandela ivula. Faka inombolo engxenyeni engakwesokunxele "0". Endaweni efanele, khetha noma yimuphi umbala, kodwa ungashiya izilungiselelo ezizenzakalelayo. Chofoza inkinobho "Kulungile".



3. Njengoba ubona, wonke amaseli ebangeni elichazwe, lapho amanani atholakala khona, akhethiwe kumbala okhethiwe, kuyilapho izinto ezingenalutho zihlala zimhlophe. Siphinde sikhethe uhla lwethu. Kuthebhu efanayo "Ikhaya" chofoza inkinobho "Hlunga futhi uhlunge"etholakala eqenjini Ukuhlela. Emenyu evula, chofoza inkinobho "Hlunga".



4. Ngemva kwalezi zenzo, njengoba sibona, isithonjana esibonisa isihlungi sivele esithombeni esiphambili salokho. Chofoza kuso. Kulolu hlu oluvulwe, iya entweni "Hlela ngombala". Okulandelayo eqenjini "Hlela ngombala weseli" khetha umbala okhethiwe njengomphumela wokufometha okunemibandela.

   

   Ungenza futhi okuhlukile ngokuhlukile. Chofoza kusikrini sokuhlunga. Emenyu ebonakalayo, susa uphawu lokuhlola kusuka endaweni "Ungenalutho". Emva kwalokho chofoza inkinobho "Kulungile".



5. Kuzo zonke izinketho eziboniswe esigabeni esedlule, izakhi ezingenalutho zizofihlwa. Khetha ububanzi bamaseli asele. Ithebhu "Ikhaya" ebhokisini lesethingi "Ibhodi lokunamathisela" chofoza inkinobho "Kopisha".



6. Bese ukhetha noma iyiphi indawo engenalutho efana noma ephepheni elihlukile. Yenza ngokuchofoza ngakwesokudla. Kuhlu olubonakalayo lwezenzo kwimingcele yokufaka, khetha into "Amanani".



7. Njengoba ubona, kwakukhona ukufakwa kwedatha ngaphandle kokufometha ukufometha. Manje ungakwazi ukususa ibanga eliyinhloko, futhi endaweni yalo faka leyo esiyithole ngesikhathi senhla ngenhla, futhi ungaqhubeka usebenza nedatha endaweni entsha. Konke kuxhomeke emisebenzini ethize kanye nezinto ezibaluleke kakhulu zomsebenzisi.

Isifundo: Ukufometha okunemibandela ku-Excel

Isifundo: Hlunga bese uhlunga idatha ku-Excel

Indlela 3: Sebenzisa ifomula eyinkimbinkimbi

Ngaphezu kwalokho, ungakwazi ukususa amaseli angenalutho kusuka ohlwini ngokusebenzisa ifomula eyinkimbinkimbi enemisebenzi eminingi.

1. Okokuqala, kuzodingeka sinikeze igama ebangeni eliguqulwayo. Khetha indawo, chofoza ngokuqondile kwegundane. Emenyu esebenziwe, khetha into "Yika igama ...".



2. Iwindi lokuqamba igama livula. Ensimini "Igama" Sinikeza igama elihle. Isimo esiyinhloko ukuthi akufanele kube nezikhala kuwo. Isibonelo, sinikeze igama ebangeni. "Ungenalutho". Azikho izinguquko ezengeziwe kule festile ezidingekayo. Sicindezela inkinobho "Kulungile".



3. Khetha noma kuphi eshadini ncamashi ububanzi obufanayo besayizi wamaseli angenalutho. Ngokufanayo, sichofoza inkinobho yesokudla yegundane futhi, ngokubizela imenyu yesimongcondvo, hamba into "Yika igama ...".



4. Ewindini evulekayo, njengasesikhathini esidlule, sibanika noma yiliphi igama kule ndawo. Sanquma ukumnika igama. "Ngaphandle_ngenalutho".



5. Chofoza kabili inkinobho yegundane lesokunxele ukuze ukhethe iseli lokuqala lohlelo olunemibandela. "Ngaphandle_ngenalutho" (ungabiza ngendlela ehlukile). Sifaka kuwo ifomula yalolu hlobo olulandelayo:

   = I-IF (STRING () - STRING (Ayinalutho) +1)> AMAKHOSI (Angibuki) - FUNDA IMITHETHO (Ayifuni); (C_full))); LINE () - LINE (Ngaphandle_blank) +1); COLUMN (C_blank); 4)))

   Njengoba lokhu kuyindlela yokwakha, ukubonisa isibalo esikrinini, udinga ukucindezela inhlanganisela yekhiye Ctrl + Shift + Fakaesikhundleni sokucindezela inkinobho kuphela Ngena.



6. Kodwa, njengoba sibona, iseli elilodwa kuphela lagcwala. Ukuze ugcwalise okunye, udinga ukukopisha ifomula kulo lonke uhla. Lokhu kungenziwa nge-marker yokugcwalisa. Setha isikhombisi ekhoneni elingaphansi lesokudla leseli elinesisebenzi esiyinkimbinkimbi. I-cursor kufanele iguqulwe esiphambanweni. Bamba inkinobho yegundane engakwesokunxele bese uyihudula phansi kuze kube sekugcineni kobubanzi. "Ngaphandle_ngenalutho".



7. Njengoba ubona, ngemuva kwalesi senzo sinebanga lapho amangqamuzana agcwalisiwe atholakala khona. Kodwa ngeke sikwazi ukwenza izenzo ezehlukene nale datha, ngoba zixhunywe ngefomula yamalungu. Khetha lonke uhla "Ngaphandle_ngenalutho". Sicindezela inkinobho "Kopisha"okufakwa kuthebhu "Ikhaya" ebhodini lamathuluzi "Ibhodi lokunamathisela".



8. Ngemuva kwalokho, khetha i-original data array. Chofoza inkinobho yesokudla yegundane. Kulolu hlu oluvula eqenjini "Izinketho zokufaka" chofoza kusithonjana "Amanani".



9. Ngemva kwalezi zenzo, idatha izofakwa endaweni yokuqala yendawo kuyo yonke ibanga ngaphandle kwamangqamuzana angenalutho. Uma ufisa, uhlu oluqukethe ifomula lungasuswa manje.

Isifundo: Indlela yokwabela igama leseli ku-Excel

Kunezindlela eziningana zokususa izinto ezingenalutho ku-Microsoft Excel. Okuhlukile nokwabiwa kwamaqembu amangqamuzana kuyindlela elula futhi esheshayo. Kodwa izimo zihlukile. Ngakho-ke, njengezindlela ezengeziwe, ungasebenzisa izinketho ngokuhlunga nokusebenzisa ifomula eyinkimbinkimbi.