Google Sheets yog daim ntawv thov huab cua muaj zog uas koj tuaj yeem siv dawb yog tias koj muaj Google account. Nws muab rau koj feem ntau tag nrho cov haujlwm uas koj xav pom hauv lwm daim ntawv thov kev them nyiaj xws li Microsoft Excel lossis WPS Office. Hauv phau ntawv qhia no koj yuav kawm paub txog kev siv Google Sheets.
Yuav ua li cas qhib Google Sheets
Txhawm rau pib nrog Google Sheets, koj yuav tsum tau tso npe rau Google account dawb, thiab nkag mus rau Google Drive, qhov chaw koj tuaj yeem tsim thiab teeb tsa koj cov ntawv nthuav qhia.
Google Drive yog qhov chaw koj tsim, khaws, thiab teeb tsa tag nrho Google Sheets spreadsheets uas koj ua haujlwm nrog.
-
Mus saib Google Account nplooj ntawv sau npe thiab ua haujlwm los ntawm tus wizard los tsim koj tus lej Google dawb.
Image -
Thaum koj muaj koj tus lej ID thiab tus lej zais, txuas rau Google Drive thiab kos npe siv koj tus lej Google tshiab.
Image -
Txhawm rau npaj ntau daim ntawv nthuav dav rau hauv ib lub nplaub tshev, xaiv New nyob rau sab laug ntawm Google Drive qhov rai, tom qab ntawd xaiv Folder. Kev siv cov folders yog ib txoj hauv kev zoo los npaj tag nrho koj cov nplooj ntawv Google nplooj ntawv hauv Google Drive.
Yog tias koj ntxiv ib daim ntawv nthuav dav tshiab hauv koj tus lej Google Drive lub ntsiab, nws yuav muab tso rau sab nraud ntawm tag nrho cov folders. Thaum koj sau ntau cov ntaub ntawv nyob ntawd, cov ntawv nthuav qhia yuav nyuaj nrhiav. Nws yog ib lub tswv yim zoo los npaj cov ntawv nthuav dav hauv cov folders hauv koj tus account Google Drive.
Image
Yuav ua li cas los tsim daim Spreadsheet hauv Google Sheets
Koj tuaj yeem tsim daim ntawv nthuav dav tshiab hauv Google Sheets hauv ob txoj hauv kev: Los yog tsim ib daim ntawv nthuav dav, lossis pib nrog tus qauv kom txuag sijhawm. Txawm koj siv txoj kev twg los tsim ib daim ntawv tshiab, nws yuav qhib lub qhov rais tshiab uas koj tuaj yeem pib ua haujlwm hauv daim ntawv.
Tsim ib daim ntawv qhia dub
Thawj txoj hauv kev los tsim ib daim ntawv nthuav qhia dawb paug hauv Google Sheets yog xaiv New nyob rau hauv lub ces kaum sab laug ntawm Google Drive qhov rais, thiab tom qab ntawd xaiv Blank spreadsheet.
Xwb, nyem nyem rau qhov twg hauv ib daim nplaub tshev, tom qab ntawd xaiv Google Sheets > Plank spreadsheet.
Using a Spreadsheet Template
Txhawm rau txuag qee lub sijhawm, koj tuaj yeem pib nrog daim ntawv nthuav dav. Txhawm rau ua qhov no xaiv New > Google Sheets > Los ntawm tus qauv txhawm rau qhib Template Gallery qhov twg koj tuaj yeem ua tau xaiv cov ntawv sau ua ntej ua ntej pib.
Pre-formatted templates suav nrog:
- Calendars
- To-do lists
- pob nyiaj
- Travel and wedding planner
- Daim Ntawv Sijhawm
- nqe lus nyiaj txiag
Koj tuaj yeem tsim koj tus kheej Google Sheets templates.
Yuav ua li cas hloov Google Sheets Cov Ntaub Ntawv
Kho cov ntaub ntawv hauv Google Sheets spreadsheet yog ib qho yooj yim heev. Txawm li cas los xij, muaj ob peb lub tswv yim tseem ceeb uas yuav tsum nco ntsoov. Cov lus qhia no suav nrog kev hloov kho cov ntaub ntawv ntawm tes thiab yuav ua li cas ntxiv lossis tshem tawm kab thiab kab, ntxiv cov ntawv tshiab, thiab ntxiv cov kab kos.
-
Kho cov Cells: Xaiv ib lub xov tooj thiab pib ntaus ntawv nkag mus rau cov ntaub ntawv. Txhawm rau hloov cov ntaub ntawv uas twb muaj lawm hauv lub xov tooj, nyem ob npaug rau lub thawv thiab tso tus cursor qhov twg koj xav hloov kho.
Image -
Tsiv Cells: Txhawm rau txav ntau lub hlwb, xaiv thawj lub xov tooj thiab luag mus rau hauv qab ntawm ntau yam koj xav luam. Nias Ctrl+C txhawm rau luam cov hlwb tseem ceeb. Koj yuav pom cov kab xiav dotted tshwm nyob ib ncig ntawm cov cell. Xaiv lwm lub xovtooj uas koj xav tso qhov ntau thiab nias Ctrl+V los muab tso rau lawv.
Nyob rau Mac, nias Command hloov Control.
Image -
Insert Rows or Columns: Txhawm rau ntxiv lossis rho tawm ib kab lossis kab, nyem rau ntawm tus lej lossis tsab ntawv ntawm kab lossis kab koj xav ntxiv lossis tshem tawm, thiab tom qab ntawd xaiv ib qho ntawm cov kev xaiv hauv qab no:
- Delete kab los yog Delete kem: Tshem cov kab lossis kab thiab hloov cov hlwb ntxiv los yog sab laug kom sau qhov sib txawv.
- Insert 1 above or Insert 1 below: Ntxig ib kab tshiab saum toj los sis hauv qab koj kab xaiv.
- Insert 2 left or Insert 1 right: Ntxig ib kem tshiab rau sab laug lossis sab xis ntawm koj kab ntawv xaiv.
Yog tias koj xaiv ntau lub hlwb lossis txhua kab, cov kev xaiv los ntxig lossis tshem tawm kab lossis kab hloov pauv los rho tawm lossis ntxig cov kab lossis kab uas koj tau qhia.
Image -
Ntxiv daim ntawv tshiab: Koj tuaj yeem ntxiv ib daim ntawv tshiab rau koj cov ntaub ntawv Google Sheets spreadsheet los ntawm xaiv tus + icon nyob rau sab laug ces kaum ntawm lub qhov rais. Qhov no yuav ntxiv ib daim ntawv tshiab rau hauv qab.
Koj tuaj yeem hloov npe koj daim ntawv tshiab los ntawm xaiv tus xub nqes rau sab xis ntawm daim ntawv tab npe thiab xaiv Rename.
Image -
Ntxiv cov kab kos thiab cov duab: Koj tuaj yeem ntxiv cov kab kos lossis cov duab kos rau koj cov ntawv nthuav tawm los ntawm kev qhia txog ntau yam ntawm cov hlwb uas koj xav tau rau daim duab, ces xaiv Insert Chart hauv ribbon. Google Sheets yuav pib xaiv hom kab ntawv uas ua rau muaj kev nkag siab zoo rau cov ntaub ntawv koj xaiv, tab sis koj tuaj yeem xaivpeb dots nyob rau sab xis sab xis ntawm daim duab los hloov qhov no thiab kho qhov chart.
Image
Siv Formulas hauv Google Sheets
Hauv Google Sheets, koj tuaj yeem nkag mus rau lub tsev qiv ntawv ntawm cov ntawv sau ua haujlwm uas tsuas yog qhov dav npaum li txhua yam koj yuav pom hauv Microsoft Excel.
Siv Google Sheets ua haujlwm, koj tuaj yeem nruab nrab tag nrho cov kab lossis kab ntawm cov hlwb, nrhiav qhov max lossis min qhov tseem ceeb, lossis tseem tuaj yeem xa cov ntaub ntawv los ntawm nplooj ntawv web.
-
Txhawm rau ntxig cov qauv hauv Google Sheets spreadsheet, ntaus =(tus kos npe sib npaug). Thaum koj pib ntaus lub npe ntawm lub luag haujlwm, koj yuav pom cov npe poob qis ntawm txhua txoj haujlwm muaj uas pib nrog cov ntawv no.
Koj yuav pom lub ntsiab lus ntawm qhov ua haujlwm thawj zaug. Txhawm rau pom lub ntsiab lus ntawm lwm tus, hla nws lub npe nrog tus nas taw tes.
Image -
Thaum koj ntaus thawj thawj kab lus qhib rau lub luag haujlwm, koj yuav pom cov npe ntawm qhov tsis ua haujlwm thiab lawv cov lus piav qhia.
Image -
Thaum koj ntaus lub kaw lus kaw rau lub luag haujlwm, nias Enter, tom qab ntawd koj yuav pom cov txiaj ntsig rau qhov ua haujlwm ntawd tshwm sim hauv cell.
Image
Yuav Ua Li Cas Qhia Ib Daim Ntawv Qhia
Thaum koj tau tsim koj thawj daim ntawv nthuav dav, koj tuaj yeem xav qhia rau lwm tus. Nov yog ob peb txoj hauv kev los qhia Google Sheets spreadsheet.
-
Yog koj twb muaj daim ntawv nthuav qhia qhib, xaiv File > Share.
Lwm txoj hauv kev koj tuaj yeem faib cov ntawv nthuav qhia hauv Google Sheets yog nyem nyem rau ntawm cov ntawv nthuav qhia hauv Google Drive, thiab tom qab ntawd xaiv Share.
Image -
The Google Sheets Qhia rau lwm tus qhov rai yuav qhib. Yog tias koj tsis xav kom muaj npe tshwj xeeb email chaw nyob los qhia cov ntawv nthuav qhia nrog, xaiv Copy link Qhov kev xaiv no tso cai rau koj muab qhov txuas rau daim ntawv nthuav dav ntawm email, xa ntawv sai, lossis nyob qhov twg Lwm yam.
Yog tias koj tawm ntawm qhov chaw pib rau kev sib koom, tus neeg twg uas muaj qhov txuas mus rau daim ntawv nthuav dav yuav tuaj yeem pom nws. Yog hais tias cov ntaub ntawv yog rhiab heev los yog koj xav khaws cia nws tus kheej, nws yog qhov zoo dua qhov hloov qhov teeb tsa no thiab qhia cov ntawv nthuav qhia rau cov neeg tshwj xeeb.
Image -
Txhawm rau teeb tsa daim ntawv tshaj tawm ua ntiag tug thiab faib rau cov neeg tshwj xeeb, xaiv tus dropdown xub ib sab ntawm tuaj yeem saib, tom qab ntawd xaiv OFF - tsuas yog cov neeg tshwj xeeb tuaj yeem nkag tau.
Image -
Tom ntej no, hauv ntu Neeg, ntaus email chaw nyob ntawm cov neeg koj xav qhia daim ntawv nthuav qhia nrog. Xaiv tus dropdown xub ntawm ib sab ntawm tus cwj mem thiab xaiv yam uas cov neeg siv sib koom ua tau nrog daim ntawv nthuav qhia.
- Can kho: Tus neeg txais tuaj yeem saib, hloov pauv, thiab tawm lus rau hauv daim ntawv nthuav qhia.
- Can saib: Tus neeg tuaj yeem nyeem daim ntawv nthuav dav tab sis tsis hloov pauv lossis hais lus.
- Can comment: Tus neeg koom tes tuaj yeem nyeem thiab tawm lus.
Image -
Click Xa txhawm rau txuag cov chaw tso cai thiab xa cov lus caw.
Image - Thaum koj muab daim ntawv nthuav qhia, Google Sheets yuav xa email rau tag nrho cov neeg koj tau muab daim ntawv nrog thiab suav nrog qhov txuas uas lawv tuaj yeem nkag mus tau.
FAQ
Kuv puas tuaj yeem siv Google Sheets ua cov ntaub ntawv rau lub vev xaib?
Yog. Google Sheets tuaj yeem siv los khaws thiab tswj cov ntaub ntawv rau cov vev xaib me me thiab cov apps. Qee lub koom haum siv nws ua lwm txoj hauv kev database software xws li MySQL.
Kuv puas tuaj yeem siv Google Sheets ua CRM?
Yog. Txawm hais tias Google tsis muaj tus qauv kev tswj hwm tus neeg siv khoom sib raug zoo (CRM), koj tuaj yeem nrhiav CRM templates dawb online uas koj tuaj yeem siv hauv Google Sheets.
Kuv siv VLOOKUP hauv Google Sheets li cas?
Xav siv VLOOKUP hauv Google Sheets, siv cov syntax VLOOKUP("search term", cell range, return value, sorted state). Piv txwv li:=VLOOKUP("Laptop", A3:B9, 3, cuav)
Kuv yuav siv COUNTIF hauv Google Sheets li cas?
Yuav siv COUNTIF hauv Google Sheets, nkag mus =COUNTIF(ntau, qauv), hloov range thiab criterion nrog cov ntaub ntawv xav tau. Tus neeg teb xov tooj sib piv xws li >, <=, lossis siv tau rau hauv ib qho lus.
