Mukati
Excel Tutorial yeDummies ichakubvumidza kuti unzwisise zviri nyore uye kugona hunyanzvi hunyanzvi hwekushanda muExcel, kuitira kuti iwe ugone kuenderera mberi uine chivimbo kune dzimwe nyaya dzakaoma. Dzidzo inokudzidzisa mashandisiro eExcel interface, shandisa mafomula uye mabasa kugadzirisa akasiyana matambudziko, kuvaka magirafu nemachati, kushanda nematafura epivot uye zvimwe zvakawanda.
Dzidzo yacho yakagadzirwa yakanangana nevashandisi veExcel vashandisi, kunyanya kune "dummies yakazara". Mashoko anopiwa mumatanho, kutanga nezvinonyanya kukosha. Kubva pachikamu kuenda kune chikamu chedzidziso, zvakawanda uye zvinonakidza uye zvinonakidza zvinhu zvinopihwa. Mushure mekupedza kosi yese, iwe unozoshandisa ruzivo rwako nechivimbo mukudzidzira uye dzidza maitiro ekushanda neExcel zvishandiso zvinogadzirisa makumi masere muzana emabasa ako ese. Uye zvinonyanya kukosha:
- Iwe unozokanganwa zvachose mubvunzo: "Maitiro ekushanda muExcel?"
- Ikozvino hapana anozomboshinga kukudaidza kuti "teapot".
- Hapana chikonzero chekutenga zvisingabatsiri zvidzidzo zvevanotanga, izvo zvinozounganidza guruva pasherufu kwemakore. Tenga mabhuku anokosha uye anobatsira chete!
- Pasaiti yedu iwe unowana akawanda akawanda akasiyana makosi, zvidzidzo uye zvinyorwa zvekushanda muMicrosoft Excel uye kwete chete. Uye izvi zvese munzvimbo imwechete!
Chikamu 1: Excel Basics
- Nhanganyaya kuExcel
- Microsoft Excel interface
- Ribhoni muMicrosoft Excel
- Backstage maonero muExcel
- Quick Access Toolbar uye Maonero eBhuku
- Gadzira uye vhura mabhuku ebasa
- Gadzira uye vhura Excel workbooks
- Kuenderana Modhi muExcel
- Kuchengeta mabhuku uye kugovera
- Sevha uye AutoRecover Workbooks muExcel
- Kuendesa kunze Excel Workbooks
- Kugovera Excel Workbooks
- Sero Basics
- Sero muExcel - pfungwa dzekutanga
- Sero zvemukati muExcel
- Kukopa, kufambisa uye kudzima maseru muExcel
- Autocomplete masero muExcel
- Tsvaga uye Dzorera muExcel
- Shandura makoramu, mitsetse uye maseru
- Shandura upamhi hwembiru uye urefu hwemutsara muExcel
- Isa uye bvisa mitsara nemakoramu muExcel
- Fambisa uye uvanze mitsara nemakoramu muExcel
- Putira zvinyorwa uye batanidza maseru muExcel
- Sero Formatting
- Kugadzika kwefonti muExcel
- Kubatanidza zvinyorwa muExcel masero
- Border, shading uye maseru masitayipi muExcel
- Kugadzira nhamba muExcel
- Excel Sheet Basics
- Rename, isa uye bvisa pepa muExcel
- Kopa, fambisa uye shandura ruvara rwepepa rekushanda muExcel
- Kubatanidza mapepa muExcel
- Kurongeka kwemapeji
- Kugadzira margin uye kutaridzika kwepeji muExcel
- Isa mapeji akatsemuka, pirinda misoro uye mazasi muExcel
- Kudhinda mabhuku
- Dhinda mapaneru muMicrosoft Excel
- Seta nzvimbo yekudhinda muExcel
- Kuisa mariji uye chiyero paunenge uchidhinda muExcel
Chikamu 2: Formula uye Mabasa
- Manyorerwo Akareruka
- Math opareta uye maseru mareferenzi muExcel mafomula
- Kugadzira Nyore Mafomula muMicrosoft Excel
- Rongedza mafomula muExcel
- Complex formulas
- Nhanganyaya kune yakaoma mafomula muExcel
- Kugadzira mafomula akaoma muMicrosoft Excel
- Relative uye absolute links
- Relative links muExcel
- Absolute mareferensi muExcel
- Zvinongedzo kune mamwe mapepa muExcel
- Formulas uye Mabasa
- Nhanganyaya kune Mabasa muExcel
- Kuisa Basa muExcel
- Basa Raibhurari muExcel
- Basa Wizard muExcel
Chikamu 3: Kushanda nedata
- Kudzora Kuonekwa Kwepepa Rekushanda
- Nzvimbo dzinotonhora muMicrosoft Excel
- Kupatsanura mapepa uye tarisa Excel bhuku rebasa mumahwindo akasiyana
- Ronga data muExcel
- Kusefa data muExcel
- Kushanda nemapoka nekukurukura
- Mapoka uye Subtotals muExcel
- Matafura muExcel
- Gadzira, shandura uye bvisa matafura muExcel
- Machati uye Sparklines
- Machati muExcel - Basics
- Magadzirirwo, Chimiro, uye Dzimwe Chati Sarudzo
- Maitiro ekushanda nema sparklines muExcel
Chikamu 4: Yepamberi maficha eExcel
- Kushanda neManotsi uye Tracking Shanduko
- Tevera kudzokorora muExcel
- Ongorora kudzokorora muExcel
- Cell comments muExcel
- Kuzadza uye Kudzivirira Mabhuku Ebasa
- Vhara uye chengetedza mabhuku ebasa muExcel
- Mamiriro Ekuumbwa
- Conditional Formating muExcel
- Pivot matafura uye kuongororwa kwedata
- Nhanganyaya yePivotTables muExcel
- Data Pivot, Mafirita, Slicers, uye PivotCharts
- Ko kana kuongororwa muExcel
Chikamu 5: Mafomura epamberi muExcel
- Isu tinogadzirisa matambudziko tichishandisa zvine musoro mabasa
- Maitiro ekuseta ari nyore boolean mamiriro muExcel
- Kushandisa Excel Boolean Mabasa Kudoma Mamiriro Akaoma
- IF basa muExcel nemuenzaniso wakapfava
- Kuverenga uye kupfupisa muExcel
- Verenga maseru muExcel uchishandisa COUNTIF uye COUNTIF mabasa
- Sum muExcel uchishandisa iyo SUM uye SUMIF mabasa
- Maitiro ekuverenga iyo cumulative yakazara muExcel
- Verenga uremu hwemaavhareji uchishandisa SUMPRODUCT
- Kushanda nemazuva uye nguva muExcel
- Zuva uye nguva muExcel - basic concepts
- Kupinda nekugadzirisa misi uye nguva muExcel
- Mabasa ekubvisa akasiyana paramita kubva pamazuva uye nguva muExcel
- Mabasa ekugadzira uye kuratidza misi nenguva muExcel
- Excel mabasa ekuverenga misi uye nguva
- Tsvaga data
- VLOOKUP basa muExcel ine mienzaniso yakapusa
- ONA basa muExcel nemuenzaniso wakapfava
- INDEX uye MATCH mabasa muExcel nemienzaniso yakapusa
- Zvakanaka kuziva
- Excel Statistical Mabasa Iwe Unoda Kuziva
- Excel math mabasa aunoda kuziva
- Excel mavara anoshanda mumienzaniso
- Kutarisisa kwezvikanganiso zvinoitika muExcel mafomula
- Kushanda nemazita muExcel
- Nhanganyaya kune masero uye mazita emhando muExcel
- Maitiro ekutumidza sero kana renji muExcel
- 5 Mitemo Inobatsira uye Mazano ekugadzira Sero uye Range Mazita muExcel
- Zita Maneja muExcel - Zvishandiso uye Zvimiro
- Nzira yekutumidza sei macons muExcel?
- Kushanda nearrays muExcel
- Nhanganyaya kune array mafomula muExcel
- Multicell array formula muExcel
- Single cell array formula muExcel
- Zvirongwa zvezvimiro muExcel
- Kugadzirisa mafomula muExcel
- Kushandisa array formulas muExcel
- Maitiro ekugadzirisa array mafomula muExcel
Chikamu 6: Sarudzo
- Interface customization
- Maitiro ekugadzirisa iyo Ribhoni muExcel 2013
- Tinya maitiro eRibhoni muExcel 2013
- Batanidza masitaera muMicrosoft Excel
Unoda kudzidza zvakawanda nezveExcel? Kunyanya iwe, isu takagadzirira maviri akareruka uye anobatsira tutorials: mazana matatu eExcel mienzaniso uye makumi matatu eExcel mabasa mumazuva makumi matatu.