Ispredishithi asilutho ngaphandle kwedokhumenti ehlela idatha ngendlela yemigqa namakholomu. Amaspredishithi asetshenziswa cishe yiyo yonke inhlangano yebhizinisi ukugcina amarekhodi ayo edatha futhi enze imisebenzi kuleyo datha. Ngisho nezikole namakolishi asebenzisa isoftware yesipredishithi ukuze agcine imininingwane yawo egciniwe. Uma kukhulunywa ngesoftware yesipredishithi, I-Microsoft Excel kanye namashidi e-Google ayisofthiwe eseqophelweni eliphezulu esetshenziswa abantu abaningi. Namuhla, abasebenzisi abaningi bakhetha i-Google AmaSpredishithi kune-Microsoft Excel njengoba igcina AmaSpredishithi ku-Cloud Storage yabo, okungukuthi i-Google Drayivu engafinyelelwa kunoma iyiphi indawo. Okudingekayo kuphela ukuthi ikhompuyutha yakho kufanele ixhumeke ku-inthanethi. Enye into enhle nge-Google AmaSpredishithi ukuthi ungayisebenzisa efasiteleni lesiphequluli sakho ku-PC yakho.
Uma kuziwa ekulondolozeni okufakiwe kwedatha, enye yezinkinga ezijwayelekile abasebenzisi abaningi ababhekana nazo iyimpinda noma okufakiwe okuyimpinda. Isibonelo, ake ucabange unemininingwane yabantu eqoqwe ocwaningweni. Uma uwafaka ohlwini usebenzisa isofthiwe yesipredishithi sakho njenge-Google AmaSpredishithi, kungenzeka kube namarekhodi ayimpinda. Okusho ukuthi, umuntu oyedwa kungenzeka ukuthi ugcwalise inhlolovo izikhathi ezingaphezu kwesisodwa, yingakho i-Google AmaSpredishithi izofaka ohlwini okufakiwe kabili. Okufakiwe okuyimpinda okunjalo kuba nzima kakhulu uma kukhulunywa ngamabhizinisi. Ake ucabange uma ukuthengiselana kwemali kufakwa kumarekhodi ngaphezu kokukodwa. Uma ubala izindleko eziphelele ngaleyo datha, kuzoba inkinga. Ukuze ugweme izimo ezinjalo, umuntu kufanele aqinisekise ukuthi awekho amarekhodi ayimpinda kusipredishithi. Ukufeza kanjani lokhu? Nokho, kulo mhlahlandlela, uzoxoxa ngezindlela ezihlukene ezingu-6 zokususa izimpinda ku-Google AmaSpredishithi. Woza, ngaphandle kwesingeniso esengeziwe, ake sibheke esihlokweni.
Okuqukethwe[ fihla ]
- Uzikhipha Kanjani Izimpinda ku-Google AmaSpredishithi?
- Indlela yoku-1: Ukusebenzisa inketho yokususa izimpinda
- Indlela yesi-2: Susa Izimpinda Ngamafomula
- Indlela yesi-3: Khipha Okufakiwe Okuphindeke kabili Ngokufometha Okunemibandela
- Indlela yesi-4: Susa Amarekhodi Ayimpinda ngamathebula e-Pivot
- Indlela 5: Ukusebenzisa Isikripthi Sezinhlelo Zokusebenza
- Indlela yesi-6: Sebenzisa Isengezo ukuze Ususe Izimpinda ku-Google AmaSpredishithi
Uzikhipha Kanjani Izimpinda ku-Google AmaSpredishithi?
Amarekhodi ayimpinda ayinkinga ngempela esimweni sokugcina amarekhodi edatha. Kodwa akudingekile ukuba ukhathazeke njengoba ungakwazi ukususa kalula okufakiwe okuyimpinda kusipredishithi sakho se-Google AmaSpredishithi. Ake sibone ezinye izindlela ongasusa ngazo izimpinda ku-Google AmaSpredishithi.
Indlela yoku-1: Ukusebenzisa inketho yokususa izimpinda
I-Google AmaSpredishithi inenketho eyakhelwe ngaphakathi yokukhipha okufakiwe okuphindaphindayo (okufakiwe okuyimpinda). Ukuze usebenzise leyo nketho, landela umfanekiso ongezansi.
1. Isibonelo, bheka lokhu (bona isithombe-skrini ngezansi). Lapha ungabona ukuthi irekhodi Ajit ifakwe kabili. Leli irekhodi eliyimpinda.
2. Ukususa okufakiwe okuyimpinda, khetha noma gqamisa imigqa namakholomu.
3. Manje chofoza inketho yemenyu enelebula Idatha . Skrolela phansi bese uchofoza ku- Susa izimpinda inketho.
4. Ibhokisi le-pop-up lizovela, libuze ukuthi yimaphi amakholomu okufanele ahlaziywe. Khetha izinketho ngokwezidingo zakho bese uchofoza ku Susa izimpinda inkinobho.
5. Wonke amarekhodi ayimpinda azosuswa, futhi izici eziyingqayizivele ziyosala. I-Google AmaSpredishithi izokwazisa ngale inombolo yamarekhodi ayimpinda asusiwe .
6. Esimeni sethu, okufakwe okuyimpinda okukodwa kuphela okukhishiwe (Ajit). Ungabona ukuthi i-Google AmaSpredishithi ikususile okufakile okuyimpinda (bheka isithombe-skrini esilandelayo).
Indlela yesi-2: Susa Izimpinda Ngamafomula
Ifomula 1: YIMPELA
I-Google AmaSpredishithi inefomula ebizwa ngokuthi UNIQUE egcina amarekhodi ayingqayizivele futhi ezosusa konke okufakiwe okuyimpinda kusipredishithi sakho.
Ngokwesibonelo: =OKUHLUKILE(A2:B7)
1. Lokhu kuzohlola okufakiwe okuyimpinda ku ububanzi obucacisiwe bamaseli (A2:B7) .
ezimbili. Chofoza kunoma iyiphi iseli engenalutho kusipredishithi sakho bese ufaka ifomula engenhla. I-Google AmaSpredishithi izogqamisa ububanzi bamaseli owacacisayo.
3. I-Google AmaSpredishithi izoklelisa amarekhodi ahlukile lapho uthayiphe khona ifomula. Ungakwazi ke esikhundleni sedatha endala ufake amarekhodi ayingqayizivele.
Ifomula 2: COUNTIF
Ungasebenzisa le fomula ukuze ugqamise konke okufakiwe okuyimpinda kusipredishithi sakho.
1. Isibonelo: Cabanga ngesithombe-skrini esilandelayo esiqukethe okukodwa okuyimpinda.
2. Kusithombe-skrini esingenhla, kuseli C2, asifake ifomula ngokuthi, =COUNTIF(A:A2, A2)>1
3. Manje, uma ukhiye u-Enter usucindezelwe, uzokhombisa umphumela njengo AMANGA.
4. Hambisa isikhombi segundane usibeke phezu kwe isikwele esincane engxenyeni engezansi yeseli ekhethiwe. Manje uzobona uphawu lokuhlanganisa esikhundleni sekhesa yegundane lakho. Chofoza futhi ubambe kulelo bhokisi, bese ulihudulela phezulu kuseli lapho ofuna ukuthola khona okufakiwe okuyimpinda. Amashidi e-Google angakwenza kopisha ngokuzenzakalelayo ifomula kumaseli asele .
5. I-Google Sheet izongeza ngokuzenzakalelayo IQINISO phambi kokungena okuyimpinda.
QAPHELA : Kulesi simo, sicacise njengokuthi >1 (okukhulu kuno-1). Ngakho, lesi simo sasiyoba umphumela IQINISO ezindaweni lapho ukungena kutholakala ngaphezu kokukodwa. Kuzo zonke ezinye izindawo, umphumela uba AMANGA.
Indlela yesi-3: Khipha Okufakiwe Okuphindeke kabili Ngokufometha Okunemibandela
Ungakwazi futhi ukusebenzisa ukufometha okunemibandela ukuze ususe amarekhodi ayimpinda ku-Google AmaSpredishithi.
1. Okokuqala, khetha isethi yedatha ongathanda ukwenza kuyo ukufometha okunemibandela. Bese, kusukela ku-Imenyu khetha Ifomethi bese upheqa phansi bese ukhetha Ukufometha okunemibandela.
2. Chofoza u- Fometha amaseli uma... ibhokisi lokudonsela phansi, bese ukhetha okuthi Ifomula Ngokwezifiso inketho.
3. Faka ifomula njenge =COUNTIF(A:A2, A2)>1
Qaphela: Udinga ukushintsha idatha yomugqa nekholomu ngokuya nge-Google Sheet yakho.
4. Le fomula izohlunga amarekhodi kukholamu A.
5. Chofoza u- Kwenziwe inkinobho. Uma ikholomu A iqukethe noma iyiphi amarekhodi ayimpinda , I-Google AmaSpredishithi izogqamisa okufakiwe okuphindiwe (izimpinda).
6. Manje usungakwazi ukususa kalula lawa marekhodi ayimpinda.
Indlela yesi-4: Susa Amarekhodi Ayimpinda ngamathebula e-Pivot
Njengoba amathebula e-pivot esebenziseka ngokushesha futhi evumelana nezimo, ungawasebenzisa ukuze uthole futhi ususe amarekhodi ayimpinda ku-Google Sheet.
Okokuqala, kuzodingeka ugqamise idatha ku-Google Sheet. Okulandelayo, dala ithebula le-pivot bese uphinde ugqamise idatha yakho. Ukuze udale ithebula le-pivot ngedathasethi yakho, zulazulela ku Idatha ngaphansi kwemenyu ye-Google Sheet bese uchofoza ku- Ithebula le-Pivot inketho. Uzocelwa ngebhokisi ubuze ukuthi udale yini ithebula le-pivot eshidini elikhona noma eshidini elisha. Khetha inketho efanelekile bese uqhubeka.
Ithebula lakho le-pivot lizokwakhiwa. Kuphaneli engakwesokudla, khetha i Engeza inkinobho eduze Nemigqa ukuze wengeze imigqa efanele. Eduze kwamanani, khetha okuthi Engeza ikholomu ukuze uhlole impinda yamanani. Ithebula lakho le-pivot lingafaka kuhlu amanani nezibalo zawo (okungukuthi, inani lezikhathi lapho inani lenzeka ngalo eshidini lakho). Ungasebenzisa lokhu ukuze uhlole ukuphindwaphindwa kokufakiwe ku-Google Sheet. Uma isibalo singaphezu kokukodwa, lokho kusho ukuthi okufakiwe kuphindwa kaningi kusipredishithi sakho.
Indlela 5: Ukusebenzisa Isikripthi Sezinhlelo Zokusebenza
Enye indlela enhle yokususa okuyimpinda kudokhumenti yakho ukusebenzisa i-Apps Script. Okunikezwe ngezansi isikripthi sezinhlelo zokusebenza sokususa okufakiwe okuyimpinda kusipredishithi sakho:
|_+_|Indlela yesi-6: Sebenzisa Isengezo ukuze Ususe Izimpinda ku-Google AmaSpredishithi
Ukusebenzisa isengezo ukuze ukhiphe okufakiwe okuyimpinda kusipredishithi sakho kungaba yinzuzo. Izandiso ezinjalo ezimbalwa zisiza. Olunye uhlelo olunjalo lokwengeza i-add on Ama-Ablebits okuthiwa Susa Izimpinda .
1. Vula i-Google AmaSpredishithi, bese usuka Izengezo chofoza imenyu ku- Thola izengezo inketho.
2. Khetha i Yethula icon (eqokonyiswe kusithombe-skrini) ukuze uqalise Indawo yeMakethe ye-G-Suite .
3. Manje sesha i- Engeza udinga futhi uyifake.
4. Dlula encazelweni yesengezo uma uthanda bese kuthi-ke chofoza Faka inketho.
Yamukela izimvume ezidingekayo ukuze ufake isengezo. Kungase kudingeke ukuthi ungene ngemvume ngemininingwane ye-akhawunti yakho ye-Google. Ngemva kokufaka isengezo, ungakwazi ukususa kalula izimpinda ku-Google AmaSpredishithi.
Kunconyiwe:
- Ungasusa kanjani ikhefu lesigaba kuMicrosoft Word
- Izindlela Ezi-5 Zokufaka Uphawu Lwezimpande Eziyisikwele eZwini
- Ungagoqa Kanjani Ngokushesha Umbhalo Ku-Google AmaSpredishithi?
Sithemba ukuthi lolu lwazi lube usizo futhi ukwazile susa kalula okufakiwe okuyimpinda ku-Google AmaSpredishithi. Uma uneziphakamiso noma imibuzo engqondweni yakho, sebenzisa isigaba sokuphawula ukuze ubabuze.
Elon Decker U-Elon ungumbhali wezobuchwepheshe e-Cyber S. Ubelokhu ebhala imihlahlandlela yokuthi kwenziwa kanjani iminyaka eyi-6 manje futhi uhlanganise izihloko eziningi. Uthanda ukumboza izihloko ezihlobene ne-Windows, Android, namaqhinga namathiphu akamuva.