Yuav Ua Li Cas Thiaj Li Sib Koom Daim Ntawv Qhia (nrog Duab)

Cov txheej txheem:

Yuav Ua Li Cas Thiaj Li Sib Koom Daim Ntawv Qhia (nrog Duab)
Yuav Ua Li Cas Thiaj Li Sib Koom Daim Ntawv Qhia (nrog Duab)

Video: Yuav Ua Li Cas Thiaj Li Sib Koom Daim Ntawv Qhia (nrog Duab)

Video: Yuav Ua Li Cas Thiaj Li Sib Koom Daim Ntawv Qhia (nrog Duab)
Video: Kev txo Hwjchim yog yam uas haum Vajtswv siab 2024, Tej zaum
Anonim

Spreadsheets yog qhov tseem ceeb ntawm chaw ua haujlwm. Lawv tau siv los npaj cov ntaub ntawv thiab ua cov ntawv ceeb toom. Txawm hais tias koj siv Internet-based spreadsheet program lossis tus qauv Microsoft Excel, koj yuav tsum tau faib cov ntawv nthuav qhia rau koj pab neeg lossis cov thawj coj. Hmoov zoo, feem ntau cov phiaj xwm phiaj xwm tau tsim muaj qhov tshwj xeeb los pab koj tsim daim ntawv nthuav qhia rau siv los ntawm ntau tus neeg, tsuav yog koj siv cov server sib koom, lossis koj muaj Internet sib txuas. Kab lus no yuav qhia koj yuav ua li cas thiaj ua daim ntawv sib koom ua ke hauv Google Docs thiab Microsoft Excel.

Cov kauj ruam

Txoj Kev 1 ntawm 2: Microsoft Excel Spreadsheet

Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 1
Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 1

Kauj Ruam 1. Qhib koj daim ntawv nthuav qhia zoo lossis tsim daim ntawv tshiab los ntawm kev mus rau Cov Ntawv Qhia Ntawv hauv kab ntawv sab saum toj kab rov tav thiab xaiv "Tshiab

Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 2
Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 2

Kauj Ruam 2. Hloov pauv koj daim ntawv

Cov no yuav tsum suav nrog macros, kab kos, sib txuas cov cell. cov duab, cov khoom, cov ntawv sib txuas, cov qauv qhia, cov lej sib cais, cov ntaub ntawv cov ntaub ntawv, Pivot Table cov ntawv tshaj tawm, kev tiv thaiv daim ntawv thiab cov qauv raws li txoj cai.

Ua Ib Daim Ntawv Sib Koom Ua Ntej 3
Ua Ib Daim Ntawv Sib Koom Ua Ntej 3

Kauj Ruam 3. Nyem rau ntawm Cov Cuab Yeej Ntawv Qhia lossis hauv lwm qhov version koj tuaj yeem pom Cov Ntsuam Xyuas Tab

Xaiv "Sib Koom Cov Ntawv Qhia/Qhia Ua Haujlwm" los ntawm cov kev xaiv hauv cov ntawv qhia zaub mov nco.

Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 4
Ua Ib Daim Ntawv Sib Koom Ua Ke Kauj Ruam 4

Kauj Ruam 4. Nyem rau Editing tab thaum lub npov sib tham tshwm tuaj

Ua Ib Daim Ntawv Qhia Sib Koom Kauj Ruam 5
Ua Ib Daim Ntawv Qhia Sib Koom Kauj Ruam 5

Kauj Ruam 5. Nrhiav lub npov uas hais tias "Tso cai hloov pauv los ntawm ntau dua ib tus neeg siv tib lub sijhawm

Nyem rau ntawm lub npov kom paub tseeb tias koj xav tau qhov kev hloov ntawd.

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 6
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 6

Kauj Ruam 6. Nyem "OK" kom txuag qhov kev hloov ntawd

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 7
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 7

Kauj Ruam 7. Txuag phau ntawv ua haujlwm hauv nws qhov chaw tam sim no los ntawm txhaj rau Cov Ntawv Qhia Ntawv thiab xaiv "Txuag

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 8
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 8

Kauj Ruam 8. Rov qab mus rau Cov Ntawv Qhia Ntawv thiab xaiv "Txuag Raws Li

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 9
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 9

Kauj Ruam 9. Txuag cov ntaub ntawv hauv daim nplaub tshev sib koom ntawm kev sib koom network

Ua kom txhua tus neeg uas yuav siv daim ntawv tau tso cai siv daim ntawv ntawd. Yog tsis yog, txuag nws qhov chaw uas txhua tus tuaj yeem nkag tau.

Txoj Kev 2 ntawm 2: Google Docs Spreadsheet

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 10
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 10

Kauj Ruam 1. Nkag mus rau hauv koj tus lej Google Cov Ntaub Ntawv

Yog tias koj tsis muaj Google Docs tus account, teeb tsa nws los ntawm txhaj "Sim Google Docs Tam Sim No" khawm ntawm Google kos npe hauv nplooj ntawv

Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 11
Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 11

Kauj Ruam 2. Mus rau koj daim ntawv teev npe lossis nyem rau ntawm lub npov "Tsim Tshiab"

Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 12
Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 12

Kauj Ruam 3. Xaiv "Spreadsheet" los ntawm cov npe xaiv, lossis qhib daim ntawv nthuav qhia uas koj twb tau ua haujlwm lawm

Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 13
Ua Ib Daim Ntawv Qhia Tshwm Tshooj Kauj Ruam 13

Kauj Ruam 4. Nyem rau khawm "Qhia" rau sab xis thiab saum koj daim ntawv teev npe

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 14
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 14

Kauj Ruam 5. Xaiv cov npe ntawm cov neeg uas koj xav koom nrog hauv koj daim ntawv teev npe hauv Google, lossis koj tuaj yeem sau email chaw nyob

Ua Ib Daim Ntawv Tshaj Tawm Sib Koom Kauj Ruam 15
Ua Ib Daim Ntawv Tshaj Tawm Sib Koom Kauj Ruam 15

Kauj Ruam 6. Txiav txim siab yog tias tus neeg tuaj yeem kho lossis tsuas yog saib daim ntawv nthuav qhia

Nyem rau ntawm lub npov nco rau sab xis ntawm tus neeg lub npe.

Ua Ib Daim Ntawv Qhia Tshooj Tshooj 16
Ua Ib Daim Ntawv Qhia Tshooj Tshooj 16

Kauj Ruam 7. Nias lub pob "Qhia & Txuag"

Yees duab - Los ntawm kev siv qhov kev pabcuam no, qee cov ntaub ntawv yuav raug muab qhia rau YouTube

Lub tswv yim

  • Thaum faib cov ntawv nthuav qhia siv Google Docs, koj lwm cov neeg siv yuav tsum muaj, lossis kos npe rau, tus lej Google.
  • Thaum koj khaws koj daim ntawv Excel hauv daim ntawv sib koom, txheeb xyuas ib qho txuas rau lwm phau ntawv ua haujlwm kom ntseeg tau tias lawv tsis tau tawg hauv cov txheej txheem txuag lawv mus rau qhov chaw tshiab.

Pom zoo: