Maitiro ekuchinja kesi muExcel 2016, 2013 kana 2010

Vazhinji vashandisi veExcel vanosangana nematambudziko nekuda kwekusakwanisa kukurumidza kushandura nyaya yezvinyorwa mumapepa ekushanda. Neimwe chikonzero, Microsoft yakawedzera chinhu ichi kuIzwi uye yakasiya Excel isina iyo. Asi izvi hazvireve kuti iwe unofanirwa kushandura nemaoko zvinyorwa musero rega rega - kune nzira dzipfupi dzakati wandei. Vatatu vavo vachatsanangurwa pasi apa.

Excel yakakosha mabasa

MuExcel, pane mabasa anoratidza mavara mune imwe nyaya - REGULATORY(), PASI() и prop (). Yokutanga inoshandura zvinyorwa zvose kuva mavara makuru, yechipiri - mumavara maduku, yechitatu inoshandura chete mavara ekutanga emashoko muhombe huru, mamwe ose anosiya mumaduku maduku. Vose vanoshanda pamusimboti mumwe chete, saka, vachishandisa imwe semuenzaniso - ngazvive REGULATORY() - unogona kuona mashandisirwo ese ari matatu.

Pinda formula

1. Gadzira koramu itsva padivi peiyo yaunoda kugadzirisa, kana kana yakanakira, ingoshandisa koramu isina chinhu padivi petafura.

2. Isa chiratidzo chakaenzana (=) chinoteverwa nezita rebasa (KUTONGA) mucell cell padhuze nepamusoro-akawanda emaseru ezvinyorwa zvinogoneka.

Mumabhuraketi mushure mezita rebasa, nyora zita repadyo nesero rine mavara (mune skrini iri pazasi, iyi sero C3). Iyo formula ichaita senge =PROPISN(C3).

4. Hit Enter.

Sero B3 ikozvino rine mavara erusero C3 mune makuru.

Kopa fomula kumaseru ari pasi pekoramu

Iye zvino fomula imwechete inogona kuiswa kune mamwe masero ari mukoramu.

5. Sarudza sero rine formula.
6. Fambisa cursor kune diki square (zadza marker), iyo iri pazasi kurudyi kwesero - museve wecursor unofanirwa kushanduka kuita muchinjikwa.

7. Kuchengeta bhatani regonzo rakadzvanywa, dhonza cursor pasi kuti uzadze ese anodiwa maseru - iyo fomula ichakopwa mavari.
8. Regedza bhatani rembeva.

Kana iwe uchida kuzadza maseru ese ekoramu kumucheto kwepasi kwetafura, ingo fambisa pamusoro pechiratidzo chekuzadza uye tinya kaviri.

Bvisa mubatsiri column

Ikozvino kune makoramu maviri ane mavara akafanana mumaseru, asi mune akasiyana kesi. Kuti uchengete imwe chete, kopira data kubva mukoramu yemubatsiri, isa mukoramu yaunoda, uye dzima mubatsiri.

1. Sarudza maseru ane formula uye tinya Ctrl + C.

2. Tinya-kurudyi pane yekutanga yemaseru ane mavara anodiwa muchikamu chinogadziriswa.
3. Pasi pe "paste options" sarudza chiratidzo Zvinokosha mune zvemukati menyu.

4. Kurudyi tinya pane mubatsiri column uye sarudza Bvisa.
5. Mubhokisi rebhokisi rinoonekwa, sarudza Yese Column. 

Zvino zvose zvaitwa.

Tsananguro yacho ingaita seyakaoma. Asi ingotevera matanho akapihwa uye uchaona kuti hapana chakaoma mairi.

Kugadzirisa zvinyorwa uchishandisa Microsoft Word

Kana iwe usingade kuvhiringa nemaformula muExcel, unogona kushandisa murairo kushandura kesi muIzwi. Ngationei kuti zvinoshanda sei.

1. Sarudza maseru aunoda kuchinja.
2. Izvo zvinoshandiswa Ctrl + C kana kuti tinya-kurudyi panzvimbo yakasarudzwa wosarudza mufananidzo mune zvemukati menyu.

3. Vhura gwaro idzva muShoko.
4. dzvanya Ctrl + V kana kuti tinya-kurudyi papepa wosarudza Insert.

Ikozvino kopi yetafura yako iri mugwaro reShoko.

5. Sarudza iwo masero etafura kwaunoda kushandura kesi yezvinyorwa.
6. Dzvanya icon Bhalisa, iyo iri muboka Font mu tab Home.
7. Sarudza imwe yemakesi mashanu sarudzo kubva pane yekudonhedza pasi.

Iwe unogona zvakare kusarudza mavara uye kushandisa Shift + F3 kusvikira chinyorwa chakarurama. Nenzira iyi, unogona kusarudza matatu chete sarudzo dzenyaya - yepamusoro, yakaderera uye Sentence kesi (umo mutsara wega wega unotanga nemavara makuru, mamwe mabhii madiki).

Iye zvino izvo zvinyorwa zviri patafura zviri muchimiro chaunoda, unogona kungozvikopa zvakare muExcel.

Kushandisa VBA macros

YeExcel 2010 uye 2013, pane imwe nzira yekushandura zvinyorwa zvemavara - VBA macros. Maitiro ekuisa VBA kodhi muExcel uye kuita kuti ishande inyaya yechimwe chinyorwa. Pano, chete macros akagadzirira-akagadzirwa anogona kuiswa anozoratidzwa.

Iwe unogona kushandisa iyo inotevera macro kushandura mavara kune yepamusoro kesi:

Sub Uppercase()

    Kune Imwe neimwe Sero Mukusarudza

        Kana isiri Cell.HasFormula Zvino

            Cell.Value = UCase(Cell.Value)

        Endai Kana

    Next Cell

End Sub

Kune yakaderera, iyi kodhi ichaita:

Madiki Madiki()

    Kune Imwe neimwe Sero Mukusarudza

        Kana isiri Cell.HasFormula Zvino

            Cell.Value = LCase(Cell.Value)

        Endai Kana

    Next Cell

End Sub

Macro yekuita kuti izwi rega rega ritange nemavara makuru:

Sub Propercase()

    Kune Imwe neimwe Sero Mukusarudza

        Kana isiri Cell.HasFormula Zvino

            Sero.Kukosha = _

            Application _

            .WorksheetFunction _

            .Zvakakodzera(Cell.Value)

        Endai Kana

    Next Cell

End Sub

Iye zvino iwe unoziva maitiro aungaita nyaya yezvinyorwa muExcel. Sezvauri kuona, izvi hazvisi zvakaoma, uye hapana kana imwe nzira yekuzviita - ndeipi yenzira dziri pamusoro apa iri nani iri kwauri.