Excel yog software los ntawm Excel Microsoft, suav nrog hauv Office pob. Nrog rau qhov kev pab cuam no nws muaj peev xwm tsim thiab tsim cov ntawv nthuav qhia, sawv cev ntawm lwm tus. Tus nqi ntawm kev siv koj cov dej num, kev nthuav tawm ntawm cov nuj nqis, kev txheeb xyuas graphical. Ntawm ntau lub luag haujlwm muaj, kev txhim kho cov qauv rau automate suav yog txaus siab heev. Tag nrho rau kev teeb tsa cov ntaub ntawv thiab teeb tsa ntau hom kab kos.

Excel feem ntau siv los npaj, tshwj xeeb:

  • Ib pob nyiaj siv, xws li kev tsim cov phiaj xwm kev lag luam piv txwv;
  • Accounting, nrog rau manipulation ntawm kev xam thiab accounting nqe lus, xws li nyiaj ntsuab flows thiab profits;
  • Tshaj tawm, ntsuas qhov project ua tau zoo thiab tshuaj xyuas qhov sib txawv ntawm cov txiaj ntsig;
  • Invoices thiab kev muag khoom. Rau kev tswj hwm ntawm kev muag khoom thiab cov ntaub ntawv xa nyiaj, nws muaj peev xwm xav txog cov ntaub ntawv hloov mus rau cov kev xav tau tshwj xeeb;
  • Kev npaj, rau kev tsim cov haujlwm tshaj lij thiab cov phiaj xwm, xws li kev tshawb fawb kev lag luam ntawm lwm tus;

Cov haujlwm tseem ceeb ntawm Excel yog dab tsi:

  • Kev tsim cov rooj,
  • Kev tsim cov ntawv ua haujlwm,
  • Formatting ib daim ntawv
  • Cov ntaub ntawv nkag thiab tsis siv neeg suav hauv daim ntawv nthuav qhia,
  • Luam ib daim ntawv.

Yuav ua li cas ua qee qhov haujlwm yooj yim hauv Excel?

  1. Tsim ib lub rooj:

Nyem rau ntawm qhov kev xaiv Tshiab thiab tom qab ntawd xaiv cov qauv uas muaj, uas tuaj yeem yog: daim ntawv nthuav dav dawb, cov qauv qub lossis cov qauv tshiab uas twb muaj lawm.

Txhawm rau tsim ib phau ntawv ua haujlwm, nias qhov kev xaiv Cov Ntaub Ntawv (nyob rau hauv cov ntawv qhia zaub mov saum toj), ua raws li New. Xaiv qhov kev xaiv Blank workbook. Koj yuav pom tias cov ntaub ntawv muaj 3 nplooj ntawv, los ntawm txhaj rau lub pob nas txoj cai, nws tuaj yeem tshem tawm lossis ntxig ntau nplooj ntawv raws li qhov tsim nyog.

  1. Thov ciam teb:

Ua ntej xaiv lub xov tooj ntawm tes, nyem rau ntawm Xaiv Txhua qhov kev xaiv (nyob rau hauv cov ntawv qhia zaub mov saum toj kawg nkaus), tom qab ntawd xaiv los ntawm Lub Tsev tab, xaiv Font thiab nqes mus rau qhov kev xaiv Ciam teb, tam sim no koj tsuas yog xav tau xaiv cov qauv xav tau.

  1. Hloov xim:

Xaiv qhov xav tau ntawm tes thiab cov ntawv nyeem koj xav hloov. Mus rau tsev xaiv, Font sub-khoom, nyem Font Xim thiab ua ntu zus hauv Cov Xim Xim.

  1. Kom align text:

Xaiv cov hlwb nrog cov ntawv nyeem, nyem Home, ces nyem Alignment.

  1. Txhawm rau siv shading:

Xaiv lub xovtooj ntawm tes koj xav hloov, mus rau cov ntawv qhia zaub mov saum toj kawg nkaus thiab nyem Tsev, tom qab ntawd mus rau Font subgroup, thiab nyem Sau Xim. Qhib lub ntsiab xim xaiv thiab xaiv cov xim koj nyiam.

  1. Cov ntaub ntawv nkag:

Txhawm rau nkag mus rau hauv cov ntaub ntawv hauv Excel, tsuas yog xaiv lub xov tooj ntawm tes thiab ntaus cov ntaub ntawv, tom qab ntawd nias ENTER lossis, yog tias koj xav tau, xaiv TAB tus yuam sij txav mus rau lwm lub xovtooj. Txhawm rau ntxig cov ntaub ntawv tshiab hauv lwm kab, nias lub ALT + ENTER ua ke.

  1. Ua kom muaj kev zoo siab:

Tom qab nkag mus rau tag nrho cov ntaub ntawv, formatting lub spreadsheet thiab graphics nyob rau hauv txoj kev xav, cia peb mus rau luam cov ntaub ntawv. Txhawm rau luam ib daim ntawv nthuav dav, xaiv lub xov tooj los tso saib. Nyem rau ntawm cov ntawv qhia zaub mov saum toj kawg nkaus "Cov ntaub ntawv" thiab tom qab ntawd nyem rau Sau. Yog tias koj xav tau, siv cov keyboard shortcut, nws yog CTRL + P.

Nyob rau hauv xaus

Yog tias koj xav paub ntau ntxiv txog kev siv Excel ua haujlwm, tsis txhob yig los qhia koj tus kheej dawb nrog cov yeeb yaj kiab tshaj lij ntawm peb lub xaib.