Spreadsheet si kanthu koma chikalata chomwe chimakonza deta m'mizere ndi mizere. Maspredishiti amagwiritsidwa ntchito ndi pafupifupi bungwe lililonse labizinesi kusunga zolemba zake ndikuchita ntchito pa datayo. Ngakhale masukulu ndi makoleji amagwiritsa ntchito mapulogalamu a spreadsheet kusunga nkhokwe zawo. Zikafika pa pulogalamu ya spreadsheet, Microsoft Excel ndi Google sheets ndi mapulogalamu apamwamba omwe anthu ambiri amagwiritsa ntchito. Masiku ano, ogwiritsa ntchito ambiri amasankha Mapepala a Google kuposa Microsoft Excel momwe amasungira Ma Spreadsheets pa Cloud Storage, mwachitsanzo, Google Drive yomwe imatha kupezeka kulikonse. Chofunikira chokha ndichakuti kompyuta yanu iyenera kulumikizidwa ndi intaneti. Chinthu china chabwino pa Mapepala a Google ndikuti mutha kuchigwiritsa ntchito pawindo lasakatuli lanu pa PC yanu.
Zikafika pakusunga zolembedwa, imodzi mwazovuta zomwe ogwiritsa ntchito ambiri amakumana nazo ndi zobwereza kapena zobwereza. Mwachitsanzo, tayerekezani kuti muli ndi tsatanetsatane wa anthu omwe asonkhanitsidwa kuchokera mu kafukufuku. Mukawalemba pogwiritsa ntchito mapulogalamu anu a spreadsheet monga Google Sheets, pali kuthekera kobwerezabwereza. Ndiye kuti, munthu m'modzi atha kudzaza kafukufukuyu kangapo, chifukwa chake Mapepala a Google amalemba zolembazo kawiri. Zolemba zobwerezabwereza zotere zimakhala zovuta kwambiri zikafika pamabizinesi. Tangoganizani ngati ndalama zogulira ndalama zalowetsedwa m'mabuku kangapo. Mukawerengera ndalama zonse zomwe zawonongedwa ndi datayo, zimakhala zovuta. Pofuna kupewa izi, munthu ayenera kuwonetsetsa kuti palibe zolemba zobwereza mu spreadsheet. Kodi kukwaniritsa izi? Chabwino, mu bukhuli, mukambirana njira 6 zosiyanasiyana zochotsera zobwereza mu Google Mapepala. Onkao mambo, twakonsha kulanguluka’mba twakonsha kulangulukapo pa uno mutwe.
Zamkatimu[ kubisa ]
- Momwe Mungachotsere Zobwerezedwa mu Google Mapepala?
- Njira 1: Kugwiritsa Ntchito Chotsani Zobwerezedwa Njira
- Njira 2: Chotsani Zobwerezedwa ndi Mafomula
- Njira 3: Chotsani Zobwereza Zobwereza Zokhala ndi Mapangidwe Okhazikika
- Njira 4: Chotsani Zobwereza Zobwereza ndi Pivot Table
- Njira 5: Kugwiritsa Ntchito Script
- Njira 6: Gwiritsani Ntchito Zowonjezera Kuti Muchotse Zobwerezedwa mu Google Mapepala
Momwe Mungachotsere Zobwerezedwa mu Google Mapepala?
Zolemba zobwereza zimakhala zovuta kwambiri pakusunga ma data. Koma musadere nkhawa chifukwa mutha kuchotsa zolemba zobwereza mosavuta patsamba lanu la Google Sheets. Tiyeni tiwone njira zina zomwe mungachotsere zobwerezedwa mu Google Mapepala.
Njira 1: Kugwiritsa Ntchito Chotsani Zobwerezedwa Njira
Mapepala a Google ali ndi njira yowonjezeramo kuti achotse zolemba zomwe zimabwerezedwa (zobwerezabwereza). Kuti mugwiritse ntchito njira imeneyi, tsatirani chitsanzo chili m’munsichi.
1. Mwachitsanzo, yang'anani izi (onani chithunzi pansipa). Apa mutha kuwona mbiriyo Ajit imalowetsedwa kawiri. Ichi ndi mbiri yobwereza.
2. Kuchotsa chobwereza, sankhani kapena onetsani mizere ndi mizati.
3. Tsopano dinani pa menyu njira zolembedwa Zambiri . Mpukutu pansi ndiye alemba pa Chotsani zobwerezedwa mwina.
4. Bokosi lodziwikiratu lidzabwera, ndikufunsa kuti ndi magawo ati oti muwunike. Sankhani options malinga ndi zosowa zanu ndiyeno alemba pa Chotsani zobwerezedwa batani.
5. Zolemba zobwereza zonse zidzachotsedwa, ndipo zinthu zapadera zikanatsala. Google Mapepala adzakufunsani za kuchuluka kwa zolemba zobwereza zomwe zidathetsedwa .
6. Kwa ife, cholembera chimodzi chokha chinachotsedwa (Ajit). Mutha kuwona kuti Mapepala a Google achotsa zobwereza (onani chithunzi chotsatira).
Njira 2: Chotsani Zobwerezedwa ndi Mafomula
Fomula 1: UNIQUE
Mapepala a Google ali ndi njira yotchedwa UNIQUE yomwe imakhalabe ndi mbiri yapadera ndipo ingachotse zolemba zonse zomwe zili mu spreadsheet yanu.
Mwachitsanzo: =WACHIWIRI (A2:B7)
1. Izi zingayang'ane zolemba zobwereza mu ma cell osiyanasiyana (A2:B7) .
awiri. Dinani pa selo iliyonse yopanda kanthu pa spreadsheet yanu ndipo lowetsani ndondomeko yomwe ili pamwambayi. Mapepala a Google angasonyeze mitundu yosiyanasiyana ya maselo omwe mumatchula.
3. Mapepala a Google alemba mndandanda wa zolemba zapadera zomwe mudalemba fomula. Mutha kusintha deta yakale ndi zolemba zapadera.
Fomula 2: COUNTIF
Mutha kugwiritsa ntchito fomulayi kuti muwonetsere zolemba zonse zomwe zili mu spreadsheet yanu.
1. Mwachitsanzo: Ganizirani chithunzi chotsatira chomwe chili ndi chobwereza chimodzi.
2. Pa chithunzi pamwambapa, pa selo C2, tiyeni tiyike fomula monga, =COUNTIF(A:A2, A2)>1
3. Tsopano, pamene Enter chinsinsi mbamuikha, izo kusonyeza zotsatira monga ZABODZA.
4. Sunthani cholozera cha mbewa ndikuchiyika pamwamba pa lalikulu lalikulu m'munsi mwa gawo losankhidwa. Tsopano muwona chizindikiro chowonjezera m'malo mwa cholozera cha mbewa yanu. Dinani ndi kugwira pa bokosilo, ndiyeno likokereni ku selo komwe mukufuna kupeza zobwereza. Mapepala a Google angatero kukopera basi chilinganizo ku maselo otsala .
5. Google Sheet idzawonjezera zokha ZOONA kutsogolo kwa kubwereza kolowera.
ZINDIKIRANI : Mu chikhalidwe ichi, tatchula monga > 1 (yaikulu kuposa 1). Choncho, chikhalidwe ichi chikanatha ZOONA m'malo omwe kulowa kumapezeka kangapo. M'malo ena onse, zotsatira zake zimakhala ZABODZA.
Njira 3: Chotsani Zobwereza Zobwereza Zokhala ndi Mapangidwe Okhazikika
Mutha kugwiritsanso ntchito masanjidwe okhazikika kuti muchotse zolemba zomwe zili mu Google Mapepala.
1. Choyamba, sankhani seti ya data yomwe mukufuna kupanga masanjidwe okhazikika. Ndiye, kuchokera Menyu kusankha Mtundu ndi mpukutu pansi ndiye kusankha Zoyenera kupanga.
2. Dinani pa Sinthani ma cell ngati… dontho-pansi, ndi kusankha Custom Formula mwina.
3. Lowetsani chilinganizo ngati =COUNTIF(A:A2, A2)>1
Zindikirani: Muyenera kusintha mizere ndi mzere malinga ndi Google Sheet yanu.
4. Fomula iyi ingasefe zolemba kuchokera pagawo A.
5. Dinani pa Zatheka batani. Ngati gawo A lili ndi chilichonse zolemba zobwereza , Google Sheets iwonetsa zomwe zalembedwa mobwerezabwereza (zobwereza).
6. Tsopano inu mosavuta kuchotsa mbiri chibwereza izi.
Njira 4: Chotsani Zobwereza Zobwereza ndi Pivot Table
Popeza matebulo a pivot ndi osavuta kugwiritsa ntchito komanso osinthika, mutha kuzigwiritsa ntchito kuti mupeze ndikuchotsa zolemba zobwereza pa Google Sheet.
Choyamba, muyenera kuwunikira zomwe zili mu Google Sheet. Kenako, pangani pivot table ndikuwunikiranso deta yanu. Kuti mupange pivot table yokhala ndi dataset yanu, pitani ku Zambiri pansi pa menyu ya Google Sheet ndikudina pa Pivot tebulo mwina. Mudzafunsidwa ndi bokosi lofunsa ngati mungapange tebulo la pivot papepala lomwe lilipo kapena tsamba latsopano. Sankhani njira yoyenera ndikupitiriza.
Pivot table yanu ipangidwa. Kuchokera pagawo lakumanja, sankhani Onjezani batani pafupi ndi Mizere kuti muwonjezere mizere yoyenera. Pafupi ndi ma values, sankhani Onjezani ndime kuti muwone kubwereza kwa ma values. Gome lanu la pivot lingatchule milingo ndi ziwerengero zawo (ie, kuchuluka kwa nthawi zomwe mtengo umapezeka patsamba lanu). Mutha kugwiritsa ntchito izi kuti muwone kubwereza kwa zolemba mu Google Sheet. Ngati chiŵerengerocho chikuposa chimodzi, ndiye kuti kulowetsako kubwerezedwa kangapo mu spreadsheet yanu.
Njira 5: Kugwiritsa Ntchito Script
Njira inanso yabwino yochotsera zobwerezedwa muzolemba zanu ndikugwiritsa ntchito Apps Script. Pansipa pali zolemba za mapulogalamu kuti muchotse zobwerezedwa mu spreadsheet yanu:
|_+_|Njira 6: Gwiritsani Ntchito Zowonjezera Kuti Muchotse Zobwerezedwa mu Google Mapepala
Kugwiritsa ntchito chowonjezera kuti muchotse zolemba zomwe zili patsamba lanu kungakhale kopindulitsa. Zowonjezera zambiri zoterezi zimakhala zothandiza. Imodzi mwa pulogalamu yowonjezera yotereyi ndi yowonjezera Zotheka dzina Chotsani Zobwerezedwa .
1. Tsegulani Mapepala a Google, kenako kuchokera Zowonjezera menyu dinani pa Pezani zowonjezera mwina.
2. Sankhani Launch icon (yosonyezedwa pa skrini) kuti mutsegule Msika wa G-Suite .
3. Tsopano fufuzani Phatikiza muyenera ndi kukhazikitsa.
4. Pita mu kufotokozera za zowonjezera ngati mukufuna ndiyeno alemba pa Instalar mwina.
Landirani zilolezo zofunikira kuti muyike zowonjezera. Muyenera kulowa ndi mbiri yanu ya akaunti ya Google. Mukayika zowonjezera, mutha kuchotsa zobwerezedwa mosavuta kuchokera ku Google Sheets.
Alangizidwa:
- Momwe Mungachotsere Gawo Lopuma mu Microsoft Word
- Njira 5 Zoyika Chizindikiro cha Square Root mu Mawu
- Momwe Mungakulitsire Mwamsanga Mawu mu Mapepala a Google?
Tikukhulupirira kuti chidziwitsochi chinali chothandiza ndipo munakwanitsa Chotsani mosavuta zomwe zabwerezedwa mu Google Mapepala. Ngati muli ndi malingaliro kapena mafunso m'maganizo mwanu, gwiritsani ntchito gawo la ndemanga kuti muwafunse.
Elon DeckerElon ndi mlembi waukadaulo ku Cyber S. Wakhala akulemba zowongolera kwa zaka pafupifupi 6 tsopano ndipo wafotokoza mitu yambiri. Amakonda kuphimba mitu yokhudzana ndi Windows, Android, ndi zidule ndi malangizo aposachedwa.