Thola futhi ususe okuphindwe kabili ku-Microsoft Excel

Lapho usebenza ngetafula noma i-database enolwazi oluningi, kungenzeka ukuthi eminye imigqa iphindaphindwe. Lokhu kubuye kwandise ukuhlelwa kwemininingwane. Ngaphezu kwalokho, uma kunezimpinda, ukubalwa okungalungile kwemiphumela kumafomula kungenzeka. Ake sibheke ukuthi singayithola kanjani futhi sikhiphe imigqa ephindwe kabili ku-Microsoft Excel.

Sesha futhi ususe

Kunezindlela eziningi zokuthola nokususa amanani wethebula aphindaphindwa. Kokunye kwalokhu okukhethiwe, ukusesha kanye nokuqedwa kwezimpinda yizona zixhumanisi kwinqubo eyodwa.

Indlela yoku-1: ukususwa okulula kwemigqa ephindiweyo

Indlela elula kakhulu yokususa izimpinda ukusebenzisa inkinobho ekhethekile ku iribhoni eyenzelwe lezi zinhloso.

1. Khetha lonke uhla lwethebula. Iya kuthebhu "Idatha". Chofoza inkinobho Susa izimpinda. Itholakala ethepheni kwibhulokhi yamathuluzi. "Sebenza nedatha".



2. Ukuvula iwindi eliphindaphindayo kuyavula. Uma unetafula elinekhanda (futhi iningi likhona njalo), khona-ke ipharamitha "Imininingwane yami iqukethe izihloko" kumele ukhethwe. Ensimini enkulu yewindi, kukhona uhlu lwamakholomu wokuhlola. Umugqa uzothathwa njengophindaphindwayo kuphela uma idatha yawo wonke amakholomu emakwe ngokuhlangana kwethikhi. Okusho ukuthi, uma ungahloli igama lekholomu, lapho-ke ukhulisa amathuba werekhodi eliqashelwa liphindaphindwa. Ngemuva kokuthi wonke amasethingi adingekayo enziwe, chofoza inkinobho "Kulungile".



3. U-Excel wenza inqubo yokuthola nokuphinda okuphindwe kabili. Ngemuva kokuphothulwa kwayo, kuvela iwindi lemininingwane lapho kubikwa khona ukuthi mangakhi amanani aphindwayo asusiwe nenombolo yokufakwayo eyingqayizivele esele. Ukuvala leli windi, cindezela inkinobho "Kulungile".

Indlela 2: susa izimpinda etafuleni elihlakaniphile

Ama-duplicates angasuswa ebangeni lamaseli ngokwakha itafula smart.

1. Khetha lonke uhla lwethebula.



2. Ukuba kuthebhu "Ikhaya" chofoza inkinobho "Fometha njengetafula"etholakala ethepheni kubhulokhi bamathuluzi Izitayela. Kuluhlu olubonakala, khetha noma yisiphi isitayela osithandayo.



3. Ngemuva kwalokho kuvula iwindi elincane lapho udinga khona ukuthi uqinisekise ibanga elikhethiwe ukwakha "itafula smart". Uma ukhethe konke kahle, khona-ke ungaqinisekisa, uma wenza iphutha, khona-ke kule windi kufanele ukukulungise. Kubalulekile futhi ukunaka Ithebula Lokuqondisa kwakukhona uphawu lokuhlola. Uma kungenjalo, khona-ke kufanele ibekwe. Ngemuva kokuthi wonke amasethingi aqediwe, chofoza inkinobho. "Kulungile". Ithebula le-Smart lidaliwe.



4. Kepha ukudala itafula elihlakaniphile kuyisinyathelo esisodwa kuphela ukuxazulula umsebenzi wethu oyinhloko - ukususa izimpinda. Chofoza kunoma isiphi iseli kuhlu lwethebula. Iqembu elingezekile lamathebhu liyavela. "Ukusebenza ngamatafula". Ukuba kuthebhu "Umqambi" chofoza inkinobho Susa izimpindaetholakala kubambo kubhokisi lamathuluzi "Insizakalo".



5. Ngemuva kwalokho, iwindi lokususa izimpinda livulwa, umsebenzi nalo ochazwe ngokuningiliziwe encazelweni yendlela yokuqala. Zonke izenzo ezengeziwe zenziwa ngokulandelana okufanayo.

Le ndlela iyindawo yonke futhi isebenza kahle kunazo zonke ezichazwe kule ndatshana.

Isifundo: Ungayenza kanjani itafula e-Excel

Indlela 3: faka isicelo sokuhlunga

Le ndlela ayisisusi okuphindwe kabili, ngoba ukuhlunga kufihla kuphela okufakiwe okuphindwe kabili etafuleni.

1. Khetha itafula. Iya kuthebhu "Idatha". Chofoza inkinobho "Hlunga"etholakala kubhulokhi yezilungiselelo Hlunga nesihlungi.



2. Ukuhlunga kuvuliwe, okukhonjiswa yizimpawu ezivele ngesimo sonxantathu ezingenakubalwa kumagama ekholomu. Manje sidinga ukukuhlela. Chofoza inkinobho "Kuthuthukile"eseduze nayo yonke into eqenjini elifanayo lamathuluzi Hlunga nesihlungi.



3. Ukuvula iwindi lokuhlunga okuthuthukile. Hlola ibhokisi eliseduze kwepharamitha "Okufakiwe okuhlukile kuphela". Zonke ezinye izilungiselelo zishiywa ngokuzenzakalelayo. Ngemuva kwalokho chofoza inkinobho "Kulungile".

Ngemuva kwalokho, okufakiwe okuphindwe kabili kuzofihlwa. Kepha ungavula ukubonisa kwawo nganoma yisiphi isikhathi ngokucindezela inkinobho futhi "Hlunga".

Isifundo: Isihlungi esithuthukisiwe ku-Excel

Indlela 4: ukufometha okunemibandela

Ungathola futhi amaseli ayimpinda usebenzisa ukufomatha kwetafula okunemibandela. Kuliqiniso, kuzodingeka zisuswe nelinye ithuluzi.

1. Khetha indawo yetafula. Ukuba kuthebhu "Ikhaya"chofoza inkinobho Ukufomatha okunemibandelaetholakala kubhulokhi yezilungiselelo Izitayela. Kumenyu evelayo, dlula ezintweni "Imithetho Yokukhetha" futhi "Amanani okuphindwayo ...".



2. Iwindows izilungiselelo zokufomatha iyavula. Ipharamitha yokuqala ekuyo ishiywe ingashintshiwe - Impinda. Kepha kupharamitha lokukhetha, ungashiya zombili izilungiselelo ezizenzakalelayo, bese ukhetha noma yimuphi umbala ofanele wena, bese uchofoza inkinobho "Kulungile".

Ngemuva kwalokho kuzokhethwa amangqamuzana anamanani ayimpinda. Uma ufisa, ungasusa lawa maseli ngendlela ejwayelekile.

Ukunaka! Ukusesha okuphindwe kabili kusetshenziswa ukufomatha okunemibandela akwenziwa ngumugqa wonke, kodwa ngeseli ngalinye ikakhulukazi, ngakho-ke akulungele wonke amacala.

Isifundo: Ukufomatha okunemibandela ku-Excel

Indlela yesi-5: ukusetshenziswa kwefomula

Ngaphezu kwalokho, ungathola izimpinda ngokusebenzisa ifomula usebenzisa imisebenzi eminingana ngesikhathi esisodwa. Ngalo, ungasesha izimpinda kukholamu ethile. Indlela ejwayelekile yale formula izobukeka kanjena:

= IF ERROR (INDEX (ikholamu_address; SEARCH (0; COUNTIF (ikholamu_address_address_cost (ngokuphelele); ikholamu_address; ikholamu_address;) + IF (COUNT (ikholamu_address 0) ;; ikholomu_1);)

1. Dala ikholamu ehlukile lapho izoboniswa izimpinda.



2. Sifaka ifomula ngokuya ngethempulethi engenhla kwiseli lokuqala lamahhala lekholamu entsha. Esimweni sethu esithile, ifomula izobukeka kanjena:

   = UMA u-ERROR (INDEX (A8: A15; SEARCH) (0; COUNTIF (E7: $ E $ 7; A8: A15) + UMA (COUNTIF (A8: A15; A8: A15)> 1; 0; 1);; "")



3. Khetha ikholomu yonke yezimpinda, ngaphandle kwenhloko. Beka isikhombisi ekugcineni kwebha yefomula. Cindezela inkinobho kukhibhodi F2. Ngemuva kwalokho sithayipha ukuhlanganiswa kwezinkinobho I-Ctrl + Shift + Faka. Lokhu kungenxa yobuntu bokusebenzisa amafomula kumalungu afanayo.

Ngemuva kwalezi zinyathelo kwikholamu Izimpinda amanani ayimpinda ayaboniswa.

Kepha, le ndlela iseyinkimbinkimbi kakhulu kubasebenzisi abaningi. Ngaphezu kwalokho, kubandakanya kuphela ukusesha okuphindwe kabili, kepha hhayi ukususwa kwabo. Ngakho-ke, kunconywa ukusebenzisa izixazululo ezilula nezisebenza ngokwengeziwe ezichazwe ekuqaleni.

Njengoba ukwazi ukubona, e-Excel kunamathuluzi amaningi aklanyelwe ukuthola nokukhipha. Ngayinye yazo inezimpawu zayo. Isibonelo, ukufometha okunemibandela kufaka phakathi ukufuna izimpinda kuphela kwiseli ngayinye ngazinye. Ngaphezu kwalokho, akuwona wonke amathuluzi awakwazi ukusesha kuphela, kodwa futhi asuse amanani aphindaphindwayo. Inketho yendawo yonke ukudala itafula elihlakaniphile. Lapho usebenzisa le ndlela, ungalungisa ngokuningiliziwe nangokuvumayo ukusesha okuphindwe kabili. Ngaphezu kwalokho, ukususwa kwabo kwenzeka ngaso leso sikhathi.