Ungawathola Kanjani Amanani Ayimpinda Kukholomu Yethebula le-Excel

Ithebula elinamanani afanayo liyinkinga enkulu kubasebenzisi abaningi be-Microsoft Excel. Ulwazi oluphindayo lungasuswa kusetshenziswa amathuluzi akhelwe ohlelweni, okuletha ithebula ekubukekeni okuyingqayizivele. Indlela yokwenza kahle izoxoxwa kulesi sihloko.

Indlela yoku-1 Ulihlola kanjani ithebula ukuze uthole izimpinda futhi uzisuse usebenzisa ithuluzi Lokufometha Okunemibandela

Ukuze ulwazi olufanayo lungaphindwa kaningana, kufanele lutholakale futhi lukhishwe ohlwini lwetafula, kusale inketho eyodwa kuphela. Ukuze wenze lokhu, udinga ukwenza lezi zinyathelo ezilandelayo:

1. Sebenzisa inkinobho yegundane engakwesokunxele ukuze ukhethe ububanzi bamaseli ofuna ukuwahlola ukuze uthole ulwazi oluyimpinda. Uma kudingekile, ungakhetha lonke ithebula.
2. Phezulu kwesikrini, chofoza ithebhu "Ekhaya". Manje, ngaphansi kwebha yamathuluzi, indawo enemisebenzi yalesi sigaba kufanele iboniswe.
3. Esigatshaneni esithi "Izitayela", chofoza kwesokunxele inkinobho ethi "Ukufometha Okunemibandela" ukuze ubone amathuba alo msebenzi.
4. Kumenyu yokuqukethwe evelayo, thola umugqa othi “Dala umthetho…” bese uchofoza kuwo nge-LMB.

5. Kumenyu elandelayo, engxenyeni ethi "Khetha uhlobo lomthetho", uzodinga ukukhetha umugqa "Sebenzisa ifomula ukuze unqume amaseli afomethiwe."
6. Manje, emugqeni wokufaka ongezansi kwalesi sigatshana, kufanele ufake ngokwakho ifomula usuka kukhibhodi “=COUNTIF($B$2:$B$9; B2)>1”. Izinhlamvu ezikubakaki zikhombisa ububanzi bamaseli okuzokwenziwa phakathi kwawo ukufometha nokusesha izimpinda. Kubakaki, kuyadingeka ukuba unikeze uhla oluthile lwezakhi zetafula bese ulenga izimpawu zamadola kumaseli ukuze ifomula "ingaphumi" ngesikhathi senqubo yokufometha.

7. Uma uthanda, kumenyu ethi “Dala umthetho wokufometha”, umsebenzisi angachofoza inkinobho ethi “Fometha” ukuze acacise umbala ozosetshenziselwa ukugqamisa izimpinda ewindini elilandelayo. Lokhu kulula, ngoba amanani aphindaphindiwe abamba iso ngokushesha.

Nakani! Ungathola izimpinda kusipredishithi se-Excel ngesandla, ngeso, ngokuhlola iseli ngalinye. Nokho, lokhu kuzothatha umsebenzisi isikhathi esiningi, ikakhulukazi uma kuhlolwa ithebula elikhulu.

Indlela yesi-2: Thola futhi ususe amanani ayimpinda usebenzisa inkinobho ethi Susa Izimpinda

I-Microsoft Office Excel inesici esikhethekile esikuvumela ukuthi ukhiphe ngokushesha amaseli ngolwazi oluyimpinda oluvela etafuleni. Le nketho yenziwa yasebenza kanje:

1. Ngokufanayo, gqamisa ithebula noma uhla oluthile lwamaseli ekhasini lokusebenzela le-Excel.
2. Ohlwini lwamathuluzi phezulu kumenyu enkulu yohlelo, chofoza igama elithi “Idatha” kanye ngenkinobho yegundane engakwesokunxele.
3. Esigatshaneni esithi "Ukusebenza ngedatha", chofoza inkinobho ethi "Susa izimpinda".

4. Kumenyu okufanele ivele ngemva kokwenza lokhu kukhohlisa okungenhla, maka ibhokisi eliseduze komugqa othi “Idatha yami” liqukethe izihloko. Esigabeni esithi "Amakholomu", amagama awo wonke amakholomu epuleti azobhalwa, udinga futhi ukuhlola ibhokisi eliseduze kwawo, bese uchofoza okuthi "KULUNGILE" ngezansi kwefasitela.

5. Isaziso mayelana nezimpinda ezitholiwe sizovela esikrinini. Zizosuswa ngokuzenzakalelayo.

Kubalulekile! Ngemva kokukhipha amanani ayimpinda, ipuleti kuzodingeka ilethwe efomini “elifanele” mathupha noma kusetshenziswa inketho yokufometha, ngoba amanye amakholomu nemigqa ingase iphume.

Indlela yesi-3: Ukusebenzisa isihlungi esithuthukisiwe

Le ndlela yokukhipha izimpinda inokuqaliswa okulula. Ukuze uyiqedele, uzodinga:

1. Esigabeni esithi "Idatha", eduze kwenkinobho ethi "Hlunga", chofoza igama elithi "Okuthuthukisiwe". Iwindi Lokuhlunga Okuthuthukile liyavuleka.

2. Beka iswishi yokuguqula eduze komugqa othi “Kopishela imiphumela kwenye indawo” bese uchofoza isithonjana esiseduze nenkambu ethi “Ububanzi bokuqala”.
3. Khetha ngegundane ububanzi bamaseli lapho ofuna ukuthola khona izimpinda. Iwindi lokukhetha lizovala ngokuzenzakalelayo.
4. Okulandelayo, emgqeni othi “Beka umphumela ebangeni”, udinga futhi ukuchofoza i-LMB kusithonjana ekugcineni bese ukhetha noma iyiphi iseli ngaphandle kwetafula. Lokhu kuzoba yisici sokuqala lapho ilebula ehleliwe izofakwa khona.

5. Khetha ibhokisi elithi “Amarekhodi ahlukile kuphela” bese uchofoza okuthi “KULUNGILE”. Njengomphumela, ithebula elihleliwe elingenazimpinda lizovela eduze kwamalungu afanayo okuqala.

Ulwazi Olwengeziwe! Uhlu oludala lwamaseli lungasuswa, kushiye ilebula elungisiwe kuphela.

Indlela yesi-4: Sebenzisa i-PivotTables

Le ndlela iqala ukuhambisana ne-algorithm yesinyathelo ngesinyathelo elandelayo:

1. Engeza ikholomu eyinsiza kuthebula lokuqala futhi inombolo yalo isuka ku-1 iye ku-N. N iyinombolo yomugqa wokugcina ohlwini.

2. Iya engxenyeni ethi "Faka" bese uchofoza inkinobho ethi "Pivot Table".

3. Ewindini elilandelayo, faka inkinobho yokuguqula emgqeni othi “Eshidini elikhona”, kunkambu ethi “Ithebula noma ububanzi,” cacisa uhla oluthile lwamaseli.
4. Emgqeni othi "Ububanzi", cacisa iseli lokuqala lapho uhlu lwethebula elilungisiwe lizongezwa khona bese uchofoza okuthi "KULUNGILE".

5. Efasiteleni elingakwesokunxele sekhasi lokusebenzela, khetha amabhokisi eduze kwamagama amakholomu ethebula.

6. Hlola umphumela.

Isiphetho

Ngakho-ke, kunezindlela ezimbalwa zokususa izimpinda ku-Excel. Ngayinye yezindlela zabo zingabizwa ngokuthi zilula futhi ziphumelelayo. Ukuze uqonde isihloko, kufanele ufunde ngokucophelela ulwazi olungenhla.