Iwe unoda kudzidza zvakawanda nezveExcel mabasa? Zvakadini nekudzidza maitiro ekuashandisa mubasa rako? Microsoft Excel ine mabasa akawanda zvekuti kunyange vashandisi vane ruzivo havazogara vachikwanisa kunyatso fambisa izvi zvakasiyana. Zvakanaka 30 Excel inoshanda mumazuva makumi matatu ichava kukurudzira kwakasimba kwekuzvivandudza iwe uye ichakudzidzisa maitiro ekugadzira zvinhu zvinoshamisa muExcel mabhuku.
Kana iwe uri novice Excel mushandisi uye wakauya kune ino saiti kuti udzidze zvese kubva kune izvo zvakakosha, ini ndinokurudzira kuti utange watarisa kune yedu Excel Tutorial yeVatangi. Mariri iwe uchawana yakawanda yemhando yepamusoro uye inobatsira ruzivo.
Kosi iyi chii?
Zvidzidzo zvese makumi matatu ishanduro yemarathon yezvinyorwa neCanada Excel guru guru - Debrie Dalgleish. Mazuva ese kubva muna Ndira 2, 2011 kusvika Ndira 31, 2011, pakanga paine chinyorwa paContextures blog yaitsanangura chimwe chezvinhu izvi. Mabasa ese akaiswa muzvikamu: zvinyorwa, ruzivo, uye kutsvaga uye zvinongedzo. The Feature List chikamu chinopa zvinongedzo kushandurudzo dzezvinyorwa zvese izvi.
Chinyorwa chimwe nechimwe chine zvinotevera:
- Tsananguro inodonongodza kuti chimiro chega chega chinoshanda sei.
- Zvidzidzo zvese makumi matatu zvinoperekedzwa nescreenshots izvo zvinokutendera kuti utaure zvakajeka ruzivo rwakakosha (iyo mifananidzo yakatorwa muExcel 30).
- Mienzaniso inoshanda yekushandisa Excel mafomula ari ega uye nemamwe mabasa.
- Misungo inogona kumuka kana uchishanda nemabasa.
- Pamwe nemamwe akawanda akaenzana anobatsira ruzivo.
Chii chandichawana?
Nerubatsiro rwemarathon iyi, iwe uchakwanisa kuwedzera ruzivo rwako rwemabasa eMicrosoft Excel uye kuita kuti mabhuku ako ebasa ashande. Dzidza kuti ndezvipi zvimiro zvinoshanda zvakanyanya mune mamwe mamiriro, uye zvipi zvekudzivisa zvachose.
Gwaro iri rinokubatsira kuti ushandise zvakajairika mabasa zvinobudirira. Kunyangwe iwo maExcel mabasa aunoshanda nawo zuva rega rega anogona kunge aine zvakavanzika maficha nemakomba ausingazive nezvazvo. Iwe unogona kushandisa zvakachengeteka yese mienzaniso inoratidzwa mubasa rako pachako.
Chinyorwa chezvinhu:
Zuva 01 - ZVAKAITIKA - inogona kutarisa mitsara miviri yemutambo chaiwo, uye, zvakare, nyaya inonzwa.
Zuva 02 - ZVINHU - Inodzosa nhamba yenzvimbo dziri mune chinongedzo.
Zuva 03 - TRIM - Inobvisa nzvimbo dzese kubva kune tambo yemavara, kunze kwenzvimbo imwe chete pakati pemashoko.
Zuva 04 - INFO - Inoratidza ruzivo nezve yazvino nharaunda yekushanda.
Zuva 05 - SARUDZA - Inodzosa kukosha kubva pane rondedzero, ichisarudza zvinoenderana nenhamba index.
Zuva 06 - AKAKADZIDZWA - Inotenderedza nhamba kune imwe nhamba yenzvimbo dzedesimali uye inodzosa mhedzisiro yemavara fomati ine kana isina zviuru zvinoparadzanisa.
Zuva 07 - CODE - Inodzosa nhamba yenhamba yemavara ekutanga tambo yemavara.
Zuva 08 - CHAR - Inodzosa imwe hunhu ine kodhi inofanana nenhamba yakapinda, zvichibva patafura yemukombuta yako.
Zuva 09 - VLOOKUP - Inotarisa kumusoro kukosha muchikamu chekutanga chetafura uye inodzorera imwe kukosha kubva mumutsara mumwe chete patafura.
Zuva regumi - HLOOKUP - Inotarisa kukosha mumutsara wekutanga wetafura uye inodzosa imwe kukosha kubva mukoramu imwechete patafura.
Zuva regumi nerimwe - CELL (CELL) - inoratidza ruzivo nezve mafomati, zvirimo uye nzvimbo yesero pane yakapihwa link.
Zuva regumi nembiri - COLUMNS - Inodzosa nhamba yemakoramu muhurongwa kana referensi.
Zuva regumi nematatu - TRANSPOSE - Inodzosa hupamhi hwemaseru serenji yakatwasuka kana zvakasiyana.
Zuva 14 - T (T) - Inodzosa mavara kana kukosha musero kuri mavara, kana tambo isina chinhu kana isiri mavara.
Zuva 15 - REPEAT (REPT) - inodzokorora tambo yemavara nhamba yakatarwa yenguva.
Zuva 16 - LOOKUP - Inodzosa kukosha kubva mumutsara mumwe, koramu imwe, kana rondedzero.
Zuva regumi nenomwe - ERROR.TYPE - Inozivisa mhando yekukanganisa nenhamba kana kudzorera #N/A kana pasina kukanganisa kwawanikwa.
Zuva regumi nesere - TSVAGA - Inotsvaga tambo yemavara mukati meimwe tambo yemavara, uye kana yawanikwa, inoshuma nzvimbo yayo.
Zuva regumi nepfumbamwe - MATCH - Inodzosa chinzvimbo cheukoshi muhurongwa, kana #N/A kukanganisa kana isina kuwanikwa.
Zuva rechi20 - ADDRESS - Inodzosa sero referensi semavara zvichienderana nemutsara uye nhamba yekoramu.
Zuva rechi21 - TYPE - Inodzosa nhamba inotsanangura rudzi rwe data.
Zuva 22 - N (N) - Inodzosa kukosha kwakashandurwa kuita nhamba.
Zuva rechi23 - TSVAGA - Inowana tambo yemavara mukati meimwe tambo yemavara, inonzwira tsitsi.
Zuva 24 - INDEX - Inodzosera kukosha kana chirevo kune kukosha.
Zuva rechi25 - REPLACE - Inotsiva mavara mukati memavara zvichienderana nenhamba yakatsanangurwa yemavara uye nzvimbo yekutanga.
Zuva rechi26 - OFFSET - Inodzosa chinongedzo chinobvisa kubva pane yakapihwa link neimwe nhamba yemitsara nemakoramu.
Zuva rechi27 - SUBSTITUTE - Inotsiva zvinyorwa zvekare nemavara matsva mukati memutsara wemavara.
Zuva 28 - HYPERLINK - inogadzira chinongedzo chinovhura gwaro rakachengetwa pakombuta, network server, network yemuno kana Internet.
Zuva rechi29 - KUCHENA - Inobvisa mamwe mavara asina kudhinda kubva muzvinyorwa.
Zuva remakumi matatu - INDIRECT - Inodzosa chinongedzo chakapihwa nerunyoro tambo.