I-Spreadsheet asiyonto ngaphandle koxwebhu olucwangcisa idatha ngohlobo lwemiqolo kunye neekholamu. I-spreadsheets zisetyenziswa phantse yonke intlangano yezoshishino ukugcina iirekhodi zayo zedatha kunye nokwenza imisebenzi kuloo datha. Nkqu nezikolo kunye neekholeji zisebenzisa isoftware yespredishithi ukugcina ugcino lwedatha. Xa kuziwa kwisoftware yespredishithi, Microsoft Excel kunye ne-Google sheets zezona nkqubo ziphezulu zisetyenziswa ngabantu abaninzi. Kule mihla, abasebenzisi abaninzi bakhetha iiSpredishithi zikaGoogle ngaphezulu kweMicrosoft Excel njengoko igcina iSpreadsheets kwiLifu labo lokuGcina, oko kukuthi iGoogle Drive enokufikelelwa kuyo nayiphi na indawo. Ekuphela kwemfuneko kukuba ikhompyuter yakho kufuneka iqhagamshelwe kwi-Intanethi. Enye into entle malunga namaPhepha kaGoogle kukuba ungayisebenzisa kwifestile yebrawuza yakho kwiPC yakho.
Xa kufikwa ekugcineni ukufakwa kwedatha, omnye wemiba eqhelekileyo ejongene nabasebenzisi abaninzi kukuphinda-phinda okanye ungeniso oluphindwe kabini. Umzekelo, khawube nomfanekiso wakho uneenkcukacha zabantu abaqokelelwe kuphando. Xa uzidwelisa usebenzisa isoftwe yespredishithi sakho esinje ngeSpredishithi zikaGoogle, kukho iirekhodi eziphindaphindwayo. Oko kukuthi, umntu omnye unokuba ugcwalise uphando ngaphezu kwesihlandlo esinye, kwaye ngenxa yoko amaPhepha kaGoogle angadwelisa ungeniso kabini. Ungeniso oluphindwayo olunjalo luyingxaki ngakumbi xa kufikwa kumashishini. Khawucinge ukuba i-transaction yemali ifakwe kwiirekhodi ngaphezu kwesinye. Xa ubala iindleko zizonke ngaloo datha, iya kuba ngumba. Ukuphepha iimeko ezinjalo, umntu kufuneka aqinisekise ukuba akukho zirekhodi eziphindwe kabini kwi-spreadsheet. Indlela yokuphumeza oku? Ewe, kwesi sikhokelo, uya kuxoxa ngeendlela ezi-6 ezahlukeneyo zokususa iimpinda kwiishiti zikaGoogle. Yiza, ngaphandle kwentshayelelo eyongezelelekileyo, makhe sijonge isihloko.
Imixholo[ fihla ]
- Uzikhupha njani iikopi kuGoogle amaShidi?
- Indlela yoku-1: Ukusebenzisa iKhetho lokukhupha iiMpinda
- Indlela yesi-2: Susa iimpinda ngeeFomula
- Indlela yesi-3: Susa amaNgeno aPhindwa kabini ngokuFomatha okuneMiqathango
- Indlela yesi-4: Susa iiRekhodi eziPhindwa kabini ngeeTafile zePivot
- Indlela yesi-5: Ukusebenzisa i-Apps Script
- Indlela yesi-6: Sebenzisa i-Add-on ukukhupha iiMpawu eziphindwe kabini kwii-Google Sheets
Uzikhupha njani iikopi kuGoogle amaShidi?
Iirekhodi eziphindwe kabini ziyinkathazo ngokwenene kwimeko yokugcinwa kweerekhodi zedatha. Kodwa akufuneki ube nexhala njengoko unokususa ngokulula amangeniso aphindwe kabini kwi-spreadsheet sakho sikaGoogle. Makhe sibone ezinye iindlela onokususa ngazo ukuphindaphinda kuMashidi kaGoogle.
Indlela yoku-1: Ukusebenzisa iKhetho lokukhupha iiMpinda
I-Google Sheets inenketho eyakhelwe-ngaphakathi yokususa amangeniso aphindaphindayo (amangenelo aphindwe kabini). Ukusebenzisa olo khetho, landela lo mfanekiso ungezantsi.
1. Umzekelo, jonga oku (jonga umfanekiso weskrini ongezantsi). Apha ungabona ukuba irekhodi Ajit ifakwe kabini. Le yingxelo ephindwe kabini.
2. Ukususa ingeniso ephindwe kabini, khetha okanye uqaqambise imiqolo nemiqolo.
3. Ngoku nqakraza kukhetho lwemenyu oluphawulweyo Idatha . Skrolela ezantsi uze ucofe iqhosha Susa iimpinda ukhetho.
4. Kuya kuvela ibhokisi ye-pop-up, ebuza ukuba yeyiphi na imiqolo ekufuneka ihlalutywe. Khetha iinketho ngokweemfuno zakho kwaye emva koko ucofe ku Susa iimpinda iqhosha.
5. Zonke iirekhodi eziphindwe kabini ziya kususwa, kwaye izinto ezizodwa ziya kuhlala. Amashidi kaGoogle azakukwazisa ngale inani leerekhodi eziphindiweyo zaye zapheliswa .
6. Kwimeko yethu, enye kuphela into ephindwe kabini yasuswa (Ajit). Uyabona ukuba iGoogle Sheets ilususile ungeniso oluphindiweyo (jonga umfanekiso wekhusi olandelayo).
Indlela yesi-2: Susa iimpinda ngeeFomula
Ifomula 1: EYODWA
I-Google Sheets inefomula ebizwa ngokuba yi-UNIQUE egcina iirekhodi ezizodwa kwaye iya kuphelisa onke amangenelo aphindwe kabini kwi-spreadsheet sakho.
Umzekelo: =EYODWA(A2:B7)
1. Oku kuya kukhangela amangenelo aphindwe kabini kwi uluhlu oluchaziweyo lweeseli (A2:B7) .
Mbini. Cofa kuyo nayiphi na iseli engenanto kwi-spreadsheet sakho kwaye ngenisa le fomula ingentla. Amashidi kaGoogle angagqamisa uluhlu lweeseli ozikhankanyayo.
3. I-Google Sheets iya kudwelisa iirekhodi ezizodwa apho uchwetheze ifomula. Emva koko ungabuyisela idatha endala kunye neerekhodi ezizodwa.
Ifomula yesi-2: COUNTIF
Ungasebenzisa le fomula ukuqaqambisa onke amangenelo aphindwayo kwispreadsheet sakho.
1. Umzekelo: Qwalasela le mifanekiso yekhusi ilandelayo equlethe ungeniso olunye.
2. Kumfanekiso wekhusi ongentla, kwiseli C2, masingenise ifomula njenge, =COUNTIF(A:A2, A2)>1
3. Ngoku, lakube licofa iqhosha elithi Faka, liya kubonisa isiphumo njenge BUBUXOKI.
4. Hambisa isalathisi semouse kwaye usibeke phezu kwe isikwere esincinci kwindawo esezantsi yeseli ekhethiweyo. Ngoku uzakubona uphawu lokudibanisa endaweni yekhesa yemouse yakho. Nqakraza kwaye ubambe kuloo bhokisi, kwaye emva koko yirhuqe phezulu kwiseli apho ufuna ukufumana amangeniso aphindwayo. Amaphepha eGoogle angenza njalo khuphela ngokuzenzekelayo ifomula kwiiseli eziseleyo .
5. IPhepha likaGoogle liya kongeza ngokuzenzekelayo YINYANISO phambi kongeniso oluphindiweyo.
PHAWULA : Kule meko, sichaze njenge>1 (enkulu kuno-1). Ngoko ke, le meko yayiza kubangela YINYANISO kwiindawo apho ukungena kufunyanwa ngaphezu kwexesha elinye. Kuzo zonke ezinye iindawo, umphumo uba BUBUXOKI.
Indlela yesi-3: Susa amaNgeno aPhindwa kabini ngokuFomatha okuneMiqathango
Unokwenza nokusebenzisa ukufomatha okunemiqathango ukuphelisa iirekhodi eziphindaphindwayo kuMashidi kaGoogle.
1. Okokuqala, khetha isethi yedatha ongathanda ukwenza kuyo ukufomatha okunemiqathango. Emva koko, kwiMenu khetha Ubume kwaye uskrolele ezantsi uze ukhethe Ukufomatha okunemiqathango.
2. Cofa kwi Fomatha iiseli ukuba... ibhokisi eyehlayo, kwaye ukhethe i Ifomula yesiko ukhetho.
3. Faka ifomula njenge =COUNTIF(A:A2, A2)>1
Phawula: Kuya kufuneka utshintshe umqolo kunye nedatha yekholamu ngokwePhepha lakho likaGoogle.
4. Le fomyula iya kuhluza iirekhodi kwikholam A.
5. Cofa kwi Ugqibile iqhosha. Ukuba ikholam A iqulethe nayiphi na iirekhodi eziphindiweyo , I-Google Sheets iza kuqaqambisa amangenelo aphindaphindiweyo (aphindwayo).
6. Ngoku unokucima ngokulula ezi rekhodi ziphindwe kabini.
Indlela yesi-4: Susa iiRekhodi eziPhindwa kabini ngeeTafile zePivot
Njengoko iitafile zepivot zikhawuleza ukusetyenziswa kwaye zibhetyebhetye, ungayisebenzisa ukufumana kunye nokuphelisa iirekhodi eziphindiweyo kwiPhepha likaGoogle.
Okokuqala, kuya kufuneka uqaqambise idatha kwiPhepha likaGoogle. Okulandelayo, yenza itafile yepivot kwaye uphinde uphawule idatha yakho. Ukwenza itafile yepivot ngeseti yedatha yakho, yiya kwi Idatha phantsi kweMenu yePhepha likaGoogle kwaye ucofe ku Itafile yePivot ukhetho. Uya kubuzwa ngebhokisi ebuza ukuba wenze itafile yepivot kwiphepha elikhoyo okanye ishidi elitsha. Khetha ukhetho olufanelekileyo kwaye uqhubeke.
Itafile yakho yepivot iyakwenziwa. Ukusuka kwindawo yolawulo esekunene, khetha i Yongeza iqhosha kufuphi neMiqolo ukudibanisa iirowu ezifanelekileyo. Kufuphi namaxabiso, khetha ukongeza umhlathi ukujonga uphindo lwamaxabiso. Itheyibhile yakho yepivot ingadwelisa amaxabiso namanani awo (o.k.t. inani lamaxesha exabiso lenzeka kwiphepha lakho). Ungasebenzisa oku ukujonga ukuphinda-phindwa kwamangeniso kwiPhepha likaGoogle. Ukuba ubalo lungaphezulu kwesinye, oko kuthetha ukuba ingeniso iphindwa kaninzi kwi-spreadsheet sakho.
Indlela yesi-5: Ukusebenzisa i-Apps Script
Enye indlela entle yokuphelisa impinda kuxwebhu lwakho kukusebenzisa iSkripthi seApps. Kunikwe ngezantsi i-apps-script yokususa amangeniso aphindiweyo kwispreadsheet sakho:
|_+_|Indlela yesi-6: Sebenzisa i-Add-on ukukhupha iiMpawu eziphindwe kabini kwii-Google Sheets
Ukusebenzisa i-add-on ukuphelisa amangeniso aphindwe kabini kwi-spreadsheet yakho kunokuba luncedo. Izandiso ezininzi ezinjalo ziye zaba luncedo. Enye inkqubo yokongezwayo kukongeza nge Ii-Ablebits igama Susa iikopi .
1. Vula iGoogle Sheets, emva koko ukusuka Izongezo imenyu cofa kwi Fumana izongezo ukhetho.
2. Khetha i Qalisa icon (iphawulwe kumfanekiso wekhusi) ukuze uqalise i Indawo yeMarike ye-G-Suite .
3. Ngoku khangela i Faka kwi udinga kwaye uyifake.
4. Yiya kwinkcazo yesongezo ukuba uyafuna kwaye emva koko cofa kwi Faka ukhetho.
Yamkela iimvume eziyimfuneko zokufakela i-add-on. Kusenokufuneka ungene ngenkcazi zeakhawunti yakho kaGoogle. Emva kokuba ufake i-add-on, unokususa ngokulula iimpinda kwi-Google Sheets.
eCetyisiweyo:
- Ulicima njani ikhefu leCandelo kwiMicrosoft Word
- Iindlela ezi-5 zokuFaka iSimboli ye-Square Root kwiLizwi
- Ungasonga njani isicatshulwa ngokukhawuleza kwiishiti zikaGoogle?
Siyathemba ukuba olu lwazi lube luncedo kwaye ukwazile susa ngokulula amangeniso aphindwe kabini kuMashithi kaGoogle. Ukuba unazo naziphi na iingcebiso okanye imibuzo engqondweni yakho, sebenzisa icandelo lamagqabaza ukubabuza.
Elon Decker U-Elon ungumbhali wezobugcisa kwi-Cyber S. Ubhala indlela-izikhokelo malunga neminyaka eyi-6 ngoku kwaye uye wagubungela izihloko ezininzi. Uyakuthanda ukugubungela izihloko ezinxulumene neWindows, Android, kunye namaqhinga amva nje kunye neengcebiso.