5 kuuraya nzira dzekushandisa Microsoft Excel
Excel ipurogiramu yepurogiramu yemagetsi.
Shanduro yepakombiyuta ipurogiramu yemapurogiramu epurogiramu inoshandiswa pakuchengetedza, kuronga nekushandisa deta .
Iko Inoshandiswa Inoshandiswa Kwairi
Purogiramu yemapurogiramu yepurogiramu yaive yakabva pamapapanishiti emapepanhi anoshandiswa pakuverenga. Sezvo zvakadaro, kuve kwekutanga kwemaspredishiti e-computer kwakafanana nepepa. Nyaya yakabatana yakachengetwa mumatafura - iyo inounganidza mabhokisi mashoma emakona kana masero akagadzirirwa mumitsara nemadzamu.
Nhasi mapurogiramu eExcel nemamwe mapurogiramu epadheseti anogona kuchengetedza mapeji akawanda epadheetti mune imwe faira yemakombiyuta.
Ifa yekombiyuta yakachengetedzwa inowanzotaurwa sebhuku rebhuku uye peji rimwe nerimwe mubhuku rebhuku ndiro rimwe pepa pepaji.
Excel Alternatives
Mamwe mapurogiramu epaseseti aripo anowanikwa kushandiswa anosanganisira:
Google Sheets (kana Google Spreadsheets) - purogiramu yakasununguka, yewebhu-spreadsheet program;
Excel Online - yakawanda, yakaiswa pasi, web-based version ye Excel;
Open Office Calc - purogiramu yepaspiritsi yakasununguka, yakakosha.
Spreadsheet Makero uye Maferensi emunzvimbo
Paunotarisa paEccel skrini - kana chimwe chipimo chepaspiritsi - unoona tafura rekwangwani kana girasi yemitsara nemakoroni , sezvinoratidzwa mumufananidzo uri pamusoro.
Mune dzimwe shanduro dze Excel, pepa rega rega rimwe nerimwe rine mitsara inosvika mamiriyoni uye dzinopfuura 16,000 columns, izvo zvinoda kugadzirisa chirongwa kuitira kuchengetedza kuti pane data iri kupi.
Mitsetse yakanamatira inozivikanwa nenhamba (1, 2, 3) uye mapuroni akajeka netsamba dzedigwaro (A, B, C). Nokuda kwemashure anopfuura 26, mapurumu anozivikanwa nemabhii maviri kana akawanda akadai seAA, AB, AC kana AAA, AAB, nezvimwe.
Nhamba yepakati yepakati pakati pendarama nemutsara, sezvakataurwa, ibhokisi duku rekwangwani rinozivikanwa senhare.
Sero ndiyo inonyanya kukoshesa kuchengetedza dhesi rekushandura, uye nokuti peji rimwe nerimwe rine mamiriyoni eaya masero, rimwe nerimwe rinozivikanwa nesero rinotarisa.
Sero rinoreva kusanganiswa kwemutsamba yemutsara uye nhamba yemutsara yakadai seA3, B6, uye AA345. Mune izvi masero mapepa, tsamba yemutsara inogara ichinyorwa.
Data Dhiyabhorosi, Formula, uye Mabasa
Mhando yedata iyo sero inogona kubata inosanganisira:
- Numeri;
- Text;
- Nguva uye nguva;
- Boolean zvinokosha ;
- Formulas .
Mafomu anoshandiswa kuverenga - kazhinji kuisa data iri mune mamwe masero. Aya masero, zvisinei, angave akawanikwa pamashizha akasiyana kana mumabhuku akasiyana-siyana.
Kugadzira chirevo chinotanga nekupinda chiratidzo chakaenzana muchitokisi chaunoda mhinduro yacho. Mafomu anogonawo kusanganisira masero ekutaura kune nzvimbo yedhesi uye imwe kana kupfuura mamwe maspredishiti emabasa .
Basa muExcel nemamwe mapepanethi e-elektroniki akavakwa-mavara ayo akagadzirirwa kuita nyore kuita zviverengero zvakasiyana-siyana - kubva pane zvakaitwa zvakadai sekupinda zuva kana nguva kune dzakaoma zvakadai sekutsvaga ruzivo rwakanangana huri mumatafura makuru e data .
Excel uye Financial Data
Mapapanethi anowanzoshandiswa kuchengetedza dhepfumi yemari. Zvinyorwa uye mabasa anoshandiswa pamhando iyi yedata zvinosanganisira:
- Kuita maitiro ekutanga emasvomhu akadai sekuenzanisa mapuranga kana mitsara yenhamba .
- Kuwana maitiro akadai senzuzo kana kurasikirwa.
- Kuverenga zvirongwa zvekubhadhara zvezvikwereti kana zvekubhadhara mari.
- Kuwana mavhareji, mashoma, zviduku uye mamwe maitiro ekuverengera mune imwe nzvimbo yakawanda yedata.
- Kutakura Chii-Kana kuongorora pane data - apo zvigadziriswa zvinoshandiswa imwe panguva imwechete kuona kuti kuchinja kunokanganisa sei nedzimwe dheta - zvakadai sekubhadhara uye mari.
Zvimwe Zvimwe Zvishandiso
Zvimwe zviitiko zvinowanzoshandiswa izvo Excel inogona kushandiswa kuisanganisira:
- Girafu kana kuti data charing kuti ibatsire vashandisi pakutsvaga maitiro ekufambisa.
- Kugadzirisa deta kuita kuti data inokosha iwane nyore kuwana uye kunzwisisa.
- Kunyora deta uye maratidziro ekushandisa mumishumo.
- Kuronga uye kuchenesa deta kuti uwane ruzivo rwakananga.
- Kubatanidza dhesiro remashandisi emashandisirwo nemashati ekushandiswa mune dzimwe hurongwa dzakadai seMicrosoft PowerPoint neShoko.
- Kuendesa dhiyabhorosi kubva kumapurogiramu ezvinyorwa zvekuongorora
Mapaparishiti aiva yekutanga 'killer apps ' emakombiyuta ega pamusana pekukwanisa kwavo kuunganidza uye kuve nemanzwisisiro emashoko. Zvirongwa zvepapurogiramu epakutanga zvakadai saVisiCalc uye Lotus 1-2-3 dzainyanya kukonzera kukura mukuzivikanwa kwemakombiyuta seApple II uye IBM PC sebhizimusi.