Mutungamiri wekutanga weMicrosoft Excel
Unoda kudzidza kuti ungashandisa sei Microsoft Excel, spreadsheet inonyanyozivikanwa munyika yose kwemakore? Zvisinei, zvinogona kunge zvichityisidzira kana iwe watanga kutanga software. Nzira Yokushandisa nayo Excel inotenderera yakawanda yakagadzirirwa neyekutanga kutangira mupfungwa. Iyi mirayiridzo inosanganisira mienzaniso-danho-nhanho pamusoro pekushandisa kushandisa Excel kuumba sarashiti yepamusoro; Sarudza tutori kuti utange!
Excel Screen Elements
Iyi Excel Screen Elements tutorial inoratidza zvikamu zvikuru zveExpcel worksheet , inotarisa:
- Cell uye sero rinoshanda
- Wedzera peji icon
- Column letters
- Row nhamba
- Status bar
- Formula bar
- Bhokisi bhokisi
- Ribbon uye tabhoni mabhii
- Faira tab
Basic Excel Spreadsheet
Dzidzo yeCheck Excel Spreadsheet inosanganisira zvinyorwa zvekusika nekugadzirisa shanduro yepamusoro mune shanduro dzekupedzisira dze Excel. Misoro yakavharwa inosanganisira:
- Kuisa data
- Kuumba mazano ari nyore
- Tsanangudzo yezita rakarongwa
- Kushandisa fomu nemaitiro ekuzadza
- Kushandisa nhamba uye sejeri mafomati kune pepaji
- Kuwedzera cell formting
Excel Math
Dzidza kuwedzera, kubvisa, kuwedzera uye kugovana nhamba iyi mu Excel Math tutorial. Dzidzo yacho inosanganisira kuchinja kurongeka kwekushanda mumashandisirwo, kujekesa uye kushandiswa kwemasvomhu eExpcel.
Nyaya imwe neimwe inosanganisira muenzaniso wekutanga-ne-chiitiko pamusoro pekugadzira fomu iyo ichaita imwechete kana yakawanda yezvidzidzo zvese zvemasvomhu muExpcel.
Kuwedzera Up Numeri Nebasa reSUM
Nhanho nhanho mirayiridzo yekuti ungashandisa sei SUM basa reSUM . Sezvo kuwedzera mitsara uye nhamba dzematare ndeimwe yemabasa anowanzoshandiswa muExcel, Microsoft inowedzera nzira iyi yekugadzirisa kuita basa iri nyore. Dzidzo inosanganisira:
- SUM basa syntax uye nharo
- Kupinda basa reSUM
- AutoSUM
- SUM function dialog box
Shamba kana Kopa Data
Muchidzidzo ichi, dzidza kuti ungashandisa sei zvigadziri zvitsva kuti ucheke, kopi uye unyore data mu Excel . Enda kune imwe nzvimbo kune imwe nzvimbo kana kuipindira nenzira dzakawanda. Dzidzo inosanganisira:
- Nzira dzekukopa deta
- The clipboard uye pasting data
- Kushandisa zvitsva zvitsva kuti uite uye unamate
- Kushandisa mamiriro ekutenderera kunyoresa deta
- Kushandisa zvinyorwa zvekushandisa pane Home tab kuti ukope data
- Kufambisa data nekatsinhanisa maki
- Kufambisa dheta nemamiriro ekumenyu uye kushandisa Home tab
Wedzera / Bvisa Columns uye Rows
Unoda kugadzirisa urongwa hwe data yako? Panzvimbo pokungotamisa data, wadii kuwedzera, kana kubvisa zvinyorwa uye mitsetse yekuwedzera kana kuderedza nzvimbo yebasa sezvaidiwa? Dzidza nzira dzakanakisisa dzekuwedzera kana kubvisa zvinyorwa zvisingabviri kana zvakawanda uye mitsetse uchishandisa nzira shoma yebhobhoyo kana mamiriro ekutenderera.
Viga / Bvisa Mikoko nemirairo
Unogona kuvanza mapuranga nemitsetse ine data mune pepadheetiti. Kuita izvi kunogona kuita kuti zvive nyore kutarisa kune dzimwe, nzvimbo dzinokosha dzebasa racho uye zviri nyore kuvadzosa kana iwe uchida kuona data yakavanzwa zvakare.
Kupinda Muzuva
Dzidza kuti ungashandisa sei nzira yekutsinhanisa keyboard kuti uite nokukurumidza musi uye nguva yezvino kune Excel spreadsheet. Kana iwe uchida kuve nekuvandudzwa kwezuva kune zuva razvino nguva dzose apo pepa rekushandura rakavhurwa, shandisa basa reTODAY pane.
Kupinda Dhiyabhorosi muExcel
Usapotsa mazano aya manomwe pamusoro pezvakanaka zvekuisa dhidhi mune rimwe pepaji rinosanganisira:
- Kuronga pepa rekushanda
- Kuisa iyo data
- Kupinda zvinyorwa uye zvinyorwa zvematare
- Kuchengetedza mapepa evhidhiyo
- Kushandisa zvinyorwa zvinyorwa mune mafomu
- Rongedza data yako
Chati Yechikamu
Iyo inozivikanwawo sebar grafu, mifananidzo yemapuranga inoshandiswa kuratidza kuenzanisa pakati pezvinhu zve data. Kirasi imwe neimwe muchati inomiririra zvakasiyana nedhadharo kubva pane pepa. Dzidza kuti ungashandise sei zvinobudirira mune zvidzidzo.
Line Graph
Mifananidzo yematafura kana mutsara wemutsara anoshandiswa kuratidzira mamiriro ekufamba kwenguva. Mutsetse wega wega muchirafu unoratidza kuchinja kwehuwandu hwekukosha kwepodha kubva pane pepa.
Pie Chart
Mapepa emashande anoshandiswa kuratidza zvikamu. Nhepfenyuro imwe chete ye data yakarongedzwa uye imwe neimwe yepiyo inomiririra chinhu chimwe chete chebhuku kubva pamushandi webasa.