Nzira yekushanda sei muExcel 2010

The Excel application inowanikwa mumutemo weMicrosoft Office 2010 uye inoshandisa somushandi wePC ane mahwhefa.

Ini ndichaedza kupindura mubvunzo wekuti ungashanda sei muExcel. Neyi purogiramu, tinotanga kuumba bhuku reku Excel rinoumbwa nemashizha akawanda. Inogona kusikwa nenzira mbiri.

Pane pakombiyuta yePC, penya-panda mumenyu yezvirikuita kuti usarudze: "Ita shanduro yeMicrosoft Excel" kana "uzarure purogiramu uchishandisa nzira shoma uye ugadzire bhuku idzva rebasa."

Excel purogiramu inokubvumira kuongorora data, matafura uye zvinyorwa zvinyorwa, kuita zvakasiyana-siyana zvemasvomhu mumagwaro kuburikidza nekupinda mafomu, ega maitiro emashandi uye mairafu anobvumira kuti uongorore data yematafura.

Hazvisi nyore kuti kutsanangura muchidimbu muchikamu chepfupi kuti tingashanda sei muExcel, chii chiri nzvimbo yekushandiswa kwepurogiramu, iyo nzira dzinoshandiswa. Asi ngatitangei kuronga.

Usati watizarura bhuku rine masevi asina chinhu. Usati watanga kushanda navo, nyatsodzidza zvirongwa zvepurogiramu yacho , zvichienderana neshanduro. Shanduro ya2010 ine chinyorwa chepamusoro pamusoro. Wokutanga wavo "Home". Zvadaro kune matabhi ekuita mabasa emushandisi: Inser, Peji Yemafomu, Mafomu, Data, Ongorora, Ona uye Mawedzera. Iwe unofanirwa kuzvidzidzira nekunyatsoziva nemashandisi aripo ma tabs.

Cherechedza bhodhi yeHofisi. Yakagadzirirwa kuvhara mirairo uye iri muhwindo reprogram, kumusoro kwekuruboshwe.

Ngatitii tinoumba faira yemari, kwaunogona kuona kufamba kwemari, data yekuwana, kuverenga kwepfuma uye kurasikirwa. Pane mukana wekuongorora zvakakwana zvemabasa emari. Nzira yekushanda sei muExcel kuumba gwaro rakadaro?

Kutanga, tinoshandisa dhidhiyo data mumasero, ayo atinosangana tafura. Kuisa dhidhi muchitokisi, unofanirwa kuita kuti iite. Kuti uite izvi, sarudza iyo nekona kona uye ugoisa ruzivo rwaunoda.

Mushure mokuzadza munda wose, tinogadzira tafura nekusarudza nzvimbo yose yekushanda. Mutsva yakarurama , sarudza mutsara "Format Cell". Pano tinosarudza i "Borders" tool uye tishandise.

Mamwe mirairo yekugadziridza tafura inowanikwa mumumenyu iyi. Nzira yekushanda muExcel, iwe uchadzidza bhuku racho. Verengere ivo pachavo. Gamuchira uye unyatsodzidza bhuku rekuzvidzivirira, iro rinotaura nezvemaitiro ekushanda muna Excel 2010. Sarudza bhuku rinotsanangurwa nemabasa, sezvo imwe dzidziso isina tsika isingabatsiri. Kuita mabasa, iwe uchakwanisa kusimbisa ruzivo rwako rwepfungwa uye nokukurumidza kudzidza mitemo yekushanda mu Excel.

Kushanda ne Excel mazano

Mushure mokugadzirisa mahwendefa ekuverengera mumagetsi ega (uye Excel, chaizvoizvo, yakagadzirirwa izvi), unofanirwa kuisa nhamba dzaunoda uye zviratidzo mumutsara wekugadzira uye mukati memusero pachako. Kushanda nemazwi muEexcel ndechimwe chekubatsira kwemaspredishiti. Pano iwe unogona kuita chero zviito: kuwedzera, kubvisa, kuwedzera, kupatsanura, kuwedzera kwemasango akaenzana, kuverenga kwemabasa uye logarithms; Iwe unogona kuwana huwandu hwemashamba uye aritemu inoreva.

Chirevo chacho chinotangira nechiratidzo chakaenzana, chinowanikwa mumutsara wepeyamu, uye ipapo zvinopikisa zvebasa zvakanyorwa mumakabhesi, zvakaparadzaniswa semicolon.

Kana uchida kudzidza zvakadzama mazano emabasa mune purogiramu, unoda kutora zvidzidzo zvakakosha. Uye kutanga, unongoda kudzidza mitemo inokubvumira kudzidza kuti ungashanda sei muExcel.