Spreadsheet ha se letho haese tokomane e hlophisang data ka mokhoa oa mela le likholomo. Li-spreadsheets li sebelisoa ke hoo e ka bang mokhatlo o mong le o mong oa khoebo ho boloka lirekoto tsa ona tsa data le ho etsa ts'ebetso ho data eo. Esita le likolo le likoleche li sebelisa software ea spreadsheet ho boloka boitsebiso ba tsona. Ha ho tluoa ho software ea spreadsheet, Microsoft Excel le Google sheets ke software ea boemo bo holimo eo batho ba bangata ba e sebelisang. Matsatsing ana, basebelisi ba bangata ba khetha Google Sheets ho feta Microsoft Excel kaha e boloka Li-Spreadsheets ho Cloud Storage ea bona, ke hore, Google Drive e ka fihlellehang sebakeng sefe kapa sefe. Ntho feela e hlokahalang ke hore komporo ea hau e hokahane le Marang-rang. Ntho e 'ngoe e ntle ka Google Sheets ke hore u ka e sebelisa ho tsoa fensetereng ea sebatli ho PC ea hau.
Ha ho tluoa tabeng ea ho boloka litlaleho tsa data, e 'ngoe ea mathata a tloaelehileng ao basebelisi ba bangata ba tobaneng le eona ke tse kopitsoang kapa tse qotsitsoeng. Ka mohlala, ak'u nahane u na le lintlha tsa batho tse bokeletsoeng phuputsong. Ha u li thathamisa u sebelisa software ea hau ea spreadsheet e kang Google Sheets, ho na le monyetla oa hore ho be le litlaleho tse kopitsoang. Ka mantsoe a mang, motho a le mong a ka be a tlatsitse phuputso ho feta hang, ka hona Google Sheets e ka thathamisa se kentsoeng habeli. Litlhahiso tse joalo tse kopitsoang li thata haholoanyane ha ho tluoa likhoebong. Ak'u inahanele haeba transaction ea chelete e kenngoa litlalehong ho feta hang. Ha u bala litšenyehelo tsohle ka data eo, e ka ba bothata. Ho qoba maemo a joalo, motho o lokela ho etsa bonnete ba hore ha ho na litlaleho tse kopitsoang ho spreadsheet. Joang ho finyella see? Che, tataisong ena, u tla tšohla mekhoa e 6 e fapaneng ea ho tlosa likopi ho Google Sheets. Tloho, ntle le kenyelletso e eketsehileng, a re hlahlobeng sehlooho.
Litaba[ pata ]
- Mokhoa oa ho tlosa likopi ho Google Sheets?
- Mokhoa oa 1: Ho Sebelisa Khetho ea Tlosa Likopi
- Mokhoa oa 2: Tlosa Likopi ka liforomo
- Mokhoa oa 3: Tlosa Menahano e Ikemetseng ka ho Femata ka Maemo
- Mokhoa oa 4: Tlosa Litlaleho tse Kopanetsoeng ka Litafole tsa Pivot
- Mokhoa oa 5: Ho sebelisa Apps Script
- Mokhoa oa 6: Sebelisa Add-on ho Tlosa Likopi ho Google Sheets
Mokhoa oa ho tlosa likopi ho Google Sheets?
Litlaleho tse kopitsoang li hlile li thata tabeng ea ho boloka lirekoto tsa data. Empa ha oa lokela ho tšoenyeha kaha o ka tlosa habonolo likopi tse kopitsoang ho tsoa ho Google Sheets spreadsheet. A re boneng litsela tse ling tseo ka tsona u ka tlosang likopi ho Google Sheets.
Mokhoa oa 1: Ho Sebelisa Khetho ea Tlosa Likopi
Google Sheets e na le khetho e hahelletsoeng kahare ea ho tlosa litlatsetso tse pheta-phetoang (likhechana tse habeli). Ho sebelisa khetho eo, latela setšoantšo se ka tlase.
1. Ka mohlala, sheba sena (sheba skrini se ka tlase). Mona u ka bona hore rekoto eo Ajit e kenoa habeli. Ena ke tlaleho e kopitsoang.
2. Ho tlosa phetisetso ena, kgetha kapa totobatsa mela le dikholomo.
3. Joale tobetsa khetho ea menu e ngotsoeng Lintlha . Tsamaisetsa tlase ebe o tobetsa konopo ea Tlosa tse kopitsoang kgetho.
4. Ho tla hlaha lebokose la pop-up, le botsang hore na ho hlahlojoe likholomo life. Khetha likhetho ho latela litlhoko tsa hau ebe o tobetsa konopo ea Tlosa tse kopitsoang konopo.
5. Lirekoto tsohle tse kopitsoang li ne li tla hlakoloa, 'me likarolo tse ikhethang li ne li tla sala. Google Sheets e tla u tsebisa hore palo ea likopi tsa lirekoto tse felisitsoeng .
6. Tabeng ea rona, ho ile ha ntšoa sengoloa se le seng feela (Ajit). U ka bona hore Google Sheets e tlositse ho kenya habeli (sheba skrineng se latelang).
Mokhoa oa 2: Tlosa Likopi ka liforomo
Foromo ea 1: E Ikhethang
Google Sheets e na le foromo e bitsoang UNIQUE e bolokang lirekoto tse ikhethang 'me e ka tlosa litlatsetso tsohle tse hlahang ho spreadsheet ea hau.
Ka mohlala: =E KHETHEHILENG(A2:B7)
1. Sena se ne se tla hlahloba hore na ho na le lipehelo tse kopitsoang ho mefuta e fapaneng ea lisele (A2:B7) .
tse pedi. Tobetsa seleng efe kapa efe e se nang letho ho spreadsheet ea hau ebe o kenya foromo e ka holimo. Google Sheets e ne e tla totobatsa mefuta e mengata ea lisele tseo u li boletseng.
3. Google Sheets e tla thathamisa lirekoto tse ikhethang moo u ngotseng foromo. Joale o ka nkela data ea khale sebaka ka lirekoto tse ikhethang.
Foromo ea 2: COUNTIF
U ka sebelisa foromo ena ho hlakisa lingoloa tsohle tse kopitsoang ho spreadsheet ea hau.
1. Mohlala: Nahana ka skrini se latelang se nang le sekhechana se le seng.
2. skrineng se kaholimo, seleng ea C2, ha re kenye foromo joalo ka, =COUNTIF(A:A2, A2)>1
3. Joale, hang ha konopo ea Enter e hatelloa, e tla bontša sephetho e le LESHANO.
4. Tsamaisa pointer ea mouse 'me u e behe holim'a sekwere se senyane karolong e ka tlase ea sele e khethiloeng. Joale o tla bona lets'oao le kopaneng ho fapana le sekhechana sa mouse. Tobetsa 'me u hatelle lebokoseng leo, ebe u le hulela holimo ho sele moo u batlang ho fumana likopi tse peli. Google maqephe a ne a tla kopitsa foromo ka bo eona liseleng tse setseng .
5. Google Sheet e tla eketsa ka bo eona 'NETE ka pela ho kenoa habeli.
HLOKOMELA : Boemong bona, re hlalositse e le > 1 (e kholo ho feta 1). Kahoo, boemo bona bo ne bo tla fella 'NETE dibakeng tseo ho kenoang ho fumanwang hofeta hang. Libakeng tse ling kaofela, phello ke LESHANO.
Mokhoa oa 3: Tlosa Menahano e Ikemetseng ka ho Femata ka Maemo
U ka sebelisa mokhoa oa ho fomata ka maemo ho tlosa lirekoto tse kopitsoang ho Google Sheets.
1. Ntlha ea pele, khetha sete ea data eo u ka ratang ho etsa mokhoa oa ho fomata ka maemo. Ka nako eo, ho tswa ho Menu khetha Sebopeho ebe o tsamaisetsa tlase ebe o khetha Ho fometa ka maemo.
2. Tobetsa ho Hlophisa lisele haeba... Lebokose la ho theoha, ebe u khetha Foromo e Tloaelehileng kgetho.
3. Kenya foromo joalo ka =COUNTIF(A:A2, A2)>1
Hlokomela: U hloka ho fetola data ea mola le kholomo ho latela Google Sheet ea hau.
4. Foromo ena e ka sefa lirekoto ho tsoa kholomong ea A.
5. Tobetsa ho E felile konopo. Haeba kholomo A e na le efe kapa efe likopi tsa litlaleho , Google Sheets e tla totobatsa tse kentsoeng khafetsa (likopi).
6. Hona joale o ka hlakola litlaleho tsena tse kopitsoang habonolo.
Mokhoa oa 4: Tlosa Litlaleho tse Kopanetsoeng ka Litafole tsa Pivot
Kaha litafole tsa pivot li potlakile ho sebelisoa ebile li tenyetseha habonolo, u ka li sebelisa ho fumana le ho tlosa lirekoto tse kopitsoang ho tsoa ho Google Sheet.
Pele, o tla tlameha ho totobatsa lintlha ho Google Sheet. Ka mor'a moo, theha tafole ea pivot 'me u hlakise lintlha tsa hau hape. Ho theha tafole ea pivot ka datha ea hau, ea ho Lintlha tlas'a menu ea Google Sheet ebe o tobetsa ho Tafole ea pivot kgetho. U tla botsoa ka lebokose le botsang hore na u thehe tafole ea pivot leqepheng le teng kapa leqephe le lecha. Khetha khetho e nepahetseng 'me u tsoele pele.
Tafole ea hau ea pivot e tla etsoa. Ho tswa ho phanele e ka ho le letona, khetha Eketsa konopo haufi le Mela ho kenya mela e fapaneng. Haufi le litekanyetso, khetha ho Eketsa kholomo ho hlahloba hore na ho na le phetiso ea boleng. Tafole ea hau ea pivot e tla thathamisa boleng le lipalo tsa bona (ke hore, makhetlo ao boleng bo hlahang leqepheng la hau). U ka sebelisa sena ho lekola phetisetso ea likenyelletso ho Google Sheet. Haeba palo e feta e le 'ngoe, ho bolela hore tlaleho e phetoa hangata ho spreadsheet ea hau.
Mokhoa oa 5: Ho sebelisa Apps Script
Mokhoa o mong o motle oa ho tlosa kopi ea tokomane ea hau ke ka ho sebelisa Apps Script. Ka tlase mona ho fanoe ka sengoloa sa li-apps ho tlosa litlatsetso tse qotsitsoeng ho spreadsheet ea hau:
|_+_|Mokhoa oa 6: Sebelisa Add-on ho Tlosa Likopi ho Google Sheets
Ho sebelisa tlatsetso ho tlosa likopi tse kopitsoang ho spreadsheet ea hau ho ka ba molemo. Likatoloso tse ngata tse joalo li bonahala li thusa. E 'ngoe ea li-add-on tse joalo ke ho eketsa ka Ablebits bitsetsoe Tlosa Likopi .
1. Bula Google Sheets, ebe ho tloha Tlatsetso tobetsa ea menu ho Fumana litlatsetso kgetho.
2. Khetha ea Qala icon (e totobalitsoeng skrineng) ho qala Sebaka sa Maraka sa G-Suite .
3. Joale batla Keketso o hloka le kenya eona.
4. Tsamaea ka tlhaloso ea tlatsetso haeba u lakatsa ebe joale tobetsa ea kenya kgetho.
Amohela litumello tse hlokahalang ho kenya add-on. U kanna ua tlameha ho kena ka mangolo a akhaonto ea hau ea Google. Ka mor'a hore u kenye tlatsetso, u ka tlosa tse kopitsoang habonolo ho Google Sheets.
E khothalelitsoe:
- Mokhoa oa ho hlakola Sekhao sa Karolo ho Microsoft Word
- Litsela tse 5 tsa ho Kenya Letšoao la Square Root ka Lentsoeng
- Mokhoa oa ho phuthela mongolo ka potlako ho Google Sheets?
Re tšepa hore boitsebiso bona bo bile molemo, 'me u khonne tlosa habonolo likopi tse peli ho tsoa ho Google Sheets. Haeba u na le litlhahiso kapa lipotso kelellong ea hau, sebelisa karolo ea maikutlo ho ba botsa.
Elon Decker Elon ke sengoli sa thekenoloji ho Cyber S. O se a ntse a ngola litataiso tsa mokhoa oa ho etsa lilemo tse ka bang 6 joale mme o akaretsa lihlooho tse ngata. O rata ho bua ka lihlooho tse amanang le Windows, Android, le maqheka le malebela a morao-rao.