Yuav Ua Li Cas Google Spreadsheet: 12 Kauj Ruam (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Google Spreadsheet: 12 Kauj Ruam (nrog Duab)
Yuav Ua Li Cas Google Spreadsheet: 12 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Google Spreadsheet: 12 Kauj Ruam (nrog Duab)

Video: Yuav Ua Li Cas Google Spreadsheet: 12 Kauj Ruam (nrog Duab)
Video: Tsis Muaj Peev Xwm Yuav Ua Li Cas 2024, Plaub Hlis Ntuj
Anonim

Yog tias koj tau siv los tsim koj daim ntawv nthuav qhia siv chav ua haujlwm lossis software zoo li Excel, koj yuav tsis muaj teeb meem hauv kev tsim Google Spreadsheet. Google Spreadsheet ua haujlwm zoo ib yam li Excel, thiab koj tuaj yeem ua tau feem ntau ntawm cov ntawv tseem ceeb ua haujlwm nrog nws. Koj tuaj yeem siv Google Spreadsheet ncaj qha los ntawm koj lub web browser lossis los ntawm nws lub mobile app.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Ua Spreadsheet nrog Google Sheets

Ua Google Spreadsheet Kauj Ruam 1
Ua Google Spreadsheet Kauj Ruam 1

Kauj Ruam 1. Kos npe rau hauv Google Ntawv

Mus ntsib docs.google.com/spreadsheets thiab kos npe nrog koj tus lej Google lossis Gmail. Koj tus lej Gmail muab kev nkag tau dawb rau Google Ntawv.

Ua Google Spreadsheet Kauj Ruam 2
Ua Google Spreadsheet Kauj Ruam 2

Kauj Ruam 2. Saib koj cov ntawv uas twb muaj lawm

Thaum nkag mus, koj yuav raug coj mus rau lub npe loj. Yog tias koj twb muaj daim ntawv teev npe tam sim no, koj tuaj yeem pom thiab nkag mus tau los ntawm no.

Ua Google Spreadsheet Kauj Ruam 3
Ua Google Spreadsheet Kauj Ruam 3

Kauj Ruam 3. Tsim daim ntawv tshiab

Nyem rau lub voj liab loj nrog rau kos npe ntxiv rau ntawm kaum sab xis. Lub qhov rai tshiab lossis tab yuav raug qhib nrog lub vev xaib-daim ntawv nthuav tawm.

Ua Google Spreadsheet Kauj Ruam 4
Ua Google Spreadsheet Kauj Ruam 4

Kauj Ruam 4. Npe lub spreadsheet

"Daim ntawv tsis muaj npe" tshwm nyob rau sab laug sab saud. Nov yog lub npe tam sim no ntawm daim ntawv teev npe. Nyem rau nws, thiab lub qhov rai me me yuav tshwm sim. Ntaus lub npe ntawm daim ntawv nthuav tawm ntawm no, thiab nyem lub pob "OK". Koj yuav pom lub npe hloov tam sim.

Ua Google Spreadsheet Kauj Ruam 5
Ua Google Spreadsheet Kauj Ruam 5

Kauj Ruam 5. Ua haujlwm ntawm daim ntawv nthuav qhia

Koj tuaj yeem ua haujlwm hauv Google Ntawv zoo ib yam li koj yuav ua haujlwm li cas hauv Microsoft Excel. Muaj cov ntawv qhia zaub mov header thiab cov cuab yeej nrog cov haujlwm zoo ib yam li Microsoft Excel.

Tsis tas yuav tsum khaws nrog Google Cov Ntawv vim txhua yam uas koj ua tau txais kev cawmdim ntawm qhov ua ntu zus

Ua Google Spreadsheet Kauj Ruam 6
Ua Google Spreadsheet Kauj Ruam 6

Kauj Ruam 6. Tawm ntawm daim ntawv nthuav qhia thaum koj ua tiav

Yog tias koj ua tiav nrog koj daim ntawv tam sim no, koj tuaj yeem yooj yim kaw lub qhov rai lossis tab. Txhua yam tau txais kev cawmdim. Koj tuaj yeem nkag mus rau koj cov ntaub ntawv los ntawm Google Sheets lossis Google Drive.

Txoj Kev 2 ntawm 2: Ua Google Spreadsheet los ntawm Google Sheets Mobile App

Ua Google Spreadsheet Kauj Ruam 7
Ua Google Spreadsheet Kauj Ruam 7

Kauj Ruam 1. Tua Google Cov Ntawv

Lub cim app muaj lub cim ntawm cov ntawv lossis daim ntawv nthuav tawm ntawm nws. Yog tias koj tsis muaj Google Sheets, koj tuaj yeem rub tawm nws dawb los ntawm koj lub cuab yeej lub khw app. Koj tseem tuaj yeem nkag mus rau koj cov ntawv nthuav qhia los ntawm Google Drive app.

Ua Google Spreadsheet Kauj Ruam 8
Ua Google Spreadsheet Kauj Ruam 8

Kauj ruam 2. Kos npe nrog koj tus lej Google

Yog tias qhov no yog thawj zaug koj tau siv lub app, koj yuav tsum txuas nws nrog koj tus lej Google ua ntej txhawm rau koj nkag mus rau koj Google Ntawv. Coj mus rhaub khawm "Pib" thiab xaiv koj li Google account los siv. Tej zaum koj yuav tsum tau nkag mus rau koj li Gmail email chaw nyob thiab tus password.

Ua Google Spreadsheet Kauj Ruam 9
Ua Google Spreadsheet Kauj Ruam 9

Kauj Ruam 3. Saib koj cov ntawv

Thaum nkag mus, koj yuav raug coj mus rau lub npe loj. Yog tias koj twb muaj daim ntawv teev npe tam sim no, koj tuaj yeem pom thiab nkag mus tau los ntawm no.

Ua Google Spreadsheet Kauj Ruam 10
Ua Google Spreadsheet Kauj Ruam 10

Kauj Ruam 4. Tsim ib daim ntawv tshiab

Coj mus rhaub lub voj voog liab loj nrog kos npe ntxiv rau ntawm kaum sab xis. Koj yuav tsum tau sau koj daim ntawv teev npe tshiab tam sim ntawd. Ib lub qhov rai me me yuav tshwm qhov twg koj tuaj yeem ntaus nws hauv. Ua li ntawd, tom qab ntawd coj mus rhaub khawm "Tsim". Ib qho screen uas tsis muaj daim ntawv nthuav qhia yuav tshwm nyob rau hauv puv npo.

Ua Google Spreadsheet Kauj Ruam 11
Ua Google Spreadsheet Kauj Ruam 11

Kauj Ruam 5. Ua haujlwm ntawm daim ntawv nthuav qhia

Koj tuaj yeem ua haujlwm hauv Google Ntawv zoo ib yam li koj yuav ua haujlwm li cas hauv Microsoft Excel. Muaj lub cuab yeej ntawm lub taub hau nrog ua haujlwm zoo ib yam li Microsoft Excel.

Ua Google Spreadsheet Kauj Ruam 12
Ua Google Spreadsheet Kauj Ruam 12

Kauj Ruam 6. Tawm daim ntawv

Yog tias koj tau ua tiav nrog koj daim ntawv tam sim no, coj mus rhaub rau ntawm lub kaum sab laug saum toj ntawm kab ntawv header, tom qab ntawd coj mus rhaub rau sab laug. Koj yuav raug coj rov qab los rau hauv phau ntawv teev npe tseem ceeb. Koj qhov kev hloov pauv yuav raug cawm tau.

Pom zoo: