Microsoft Excel Tutorial for Dummies

Microsoft Excel Tutorial for Dummies

I-Excel Tutorial yamaDummies izokuvumela ukuthi uqonde kalula futhi uphumelele amakhono ayisisekelo okusebenza ku-Excel, ukuze ukwazi ukuqhubekela phambili ngokuzethemba ezihlokweni eziyinkimbinkimbi. Isifundo sizokufundisa indlela yokusebenzisa isixhumi esibonakalayo se-Excel, ukusebenzisa amafomula nemisebenzi ukuxazulula izinkinga ezihlukahlukene, ukwakha amagrafu namashadi, ukusebenza ngamathebula e-pivot nokunye okuningi.

Isifundo sidalelwe abasebenzisi abaqalayo be-Excel, ngokuqondile "ama-dummies aphelele". Ulwazi lunikezwa ngezigaba, kuqala ngezinto eziyisisekelo. Ukusuka esigabeni kuya kwesinye sesifundo, kunikelwa izinto ezithokozisayo nezithokozisayo. Ngemva kokuqeda sonke isifundo, uzosebenzisa ngokuzethemba ulwazi lwakho ekusebenzeni futhi ufunde ukuthi ungasebenza kanjani ngamathuluzi e-Excel azoxazulula u-80% wayo yonke imisebenzi yakho. Futhi okubaluleke kakhulu:

  • Uzokhohlwa unomphela umbuzo: "Isebenza kanjani ku-Excel?"
  • Manje akekho oyoke alinge ukukubiza “ngetiye”.
  • Asikho isidingo sokuthenga izifundo ezingenamsebenzi zabaqalayo, ezizobe ziqoqa uthuli eshalofini iminyaka. Thenga izincwadi eziwusizo neziwusizo kuphela!
  • Esizeni sethu uzothola izifundo eziningi ezahlukahlukene, izifundo kanye namamanyuwali okusebenza ku-Microsoft Excel hhayi kuphela. Futhi konke lokhu endaweni eyodwa!

Isigaba 1: I-Excel Basics

  1. Isingeniso ku-Excel
    • I-Microsoft Excel interface
    • Iribhoni kuMicrosoft Excel
    • Ukubuka ngemuva kwesiteji ku-Excel
    • Ibha yamathuluzi yokufinyelela ngokushesha kanye nokubukwa kwencwadi
  2. Dala futhi uvule izincwadi zokusebenza
    • Dala futhi uvule izincwadi zokusebenza ze-Excel
    • Imodi yokuvumelana ku-Excel
  3. Igcina izincwadi nokwabelana
    • Londoloza futhi Ubuyisele Ngokuzenzakalelayo Izincwadi Zokusebenza ku-Excel
    • Ithekelisa Izincwadi Zokusebenzela ze-Excel
    • Ukwabelana nge-Excel Workbooks
  4. Izisekelo Zeseli
    • Iseli ku-Excel - imiqondo eyisisekelo
    • Okuqukethwe kweseli ku-Excel
    • Ikopisha, inyakaze futhi isuse amaseli ku-Excel
    • Qedela ngokuzenzakalela amaseli ku-Excel
    • Thola bese Ufaka esikhundleni ku-Excel
  5. Shintsha amakholomu, imigqa namaseli
    • Shintsha ububanzi bekholomu nobude bomugqa ku-Excel
    • Faka futhi ususe imigqa namakholomu ku-Excel
    • Hambisa futhi ufihle imigqa namakholomu ku-Excel
    • Goqa umbhalo bese uhlanganisa amaseli ku-Excel
  6. Ukufometha Kweseli
    • Ukulungiselelwa kwefonti ku-Excel
    • Ukuqondanisa umbhalo kumaseli e-Excel
    • Imingcele, ukufiphaza nezitayela zamaseli ku-Excel
    • Ukufometha izinombolo ku-Excel
  7. Izisekelo Zeshidi le-Excel
    • Qamba kabusha, faka futhi ususe ishidi ku-Excel
    • Kopisha, hambisa futhi ushintshe umbala wephepha lokusebenza ku-Excel
    • Ukuqoqa amashidi ku-Excel
  8. Isakhiwo sekhasi
    • Ukufometha amamajini nokuma kwekhasi ku-Excel
    • Faka ukunqamuka kwekhasi, phrinta izihloko nonyaweni ku-Excel
  9. Ukuphrinta izincwadi
    • Iphaneli yokuphrinta ku-Microsoft Excel
    • Setha indawo yokuphrinta ku-Excel
    • Ukusetha amamajini nesikali lapho uphrinta ku-Excel

Isigaba 2: Amafomula kanye Nemisebenzi

  1. Amafomula Alula
    • Ama-opharetha wezibalo nezinkomba zamaseli kumafomula e-Excel
    • Ukudala Amafomula Alula ku-Microsoft Excel
    • Hlela amafomula ku-Excel
  2. Amafomula ayinkimbinkimbi
    • Isingeniso samafomula ayinkimbinkimbi ku-Excel
    • Ukudala amafomula ayinkimbinkimbi ku-Microsoft Excel
  3. Izixhumanisi ezihlobene neziphelele
    • Izixhumanisi ezihlobene ku-Excel
    • Izinkomba eziphelele ku-Excel
    • Izixhumanisi kwamanye amashidi ku-Excel
  4. Amafomula kanye Nemisebenzi
    • Isingeniso Semisebenzi ku-Excel
    • Ukufaka Umsebenzi ku-Excel
    • Ilabhulali esebenzayo ku-Excel
    • Isilekeleli Somsebenzi ku-Excel

Isigaba 3: Ukusebenza ngedatha

  1. Ukulawula Ukubukeka Kweshidi Lokusebenza
    • Izifunda ezibandayo ku-Microsoft Excel
    • Hlukanisa amashidi futhi ubuke incwadi yokusebenzela ye-Excel kumafasitela ahlukene
  2. Hlunga idatha ku-Excel
    • Ukuhlunga nge-Excel - ulwazi oluyisisekelo
    • Ukuhlunga ngokwezifiso ku-Excel
    • Hlunga amazinga ku-Excel
  3. Ukuhlunga idatha ku-Excel
    • Hlunga ku-Excel - Okuyisisekelo
    • Isihlungi esithuthukisiwe ku-Excel
  4. Ukusebenza namaqembu kanye nokuxoxisana
    • Amaqembu namathothali amancane ku-Excel
  5. Amathebula ku-Excel
    • Dala, shintsha futhi susa amathebula ku-Excel
  6. Amashadi kanye Nomugqa we-Spark
    • Amashadi ku-Excel - Okuyisisekelo
    • Isakhiwo, Isitayela, nezinye Izinketho Zeshadi
    • Ungasebenza kanjani ngemigqa ye-spark ku-Excel

Isigaba 4: Izici ezithuthukile ze-Excel

  1. Ukusebenza ngamanothi kanye nezinguquko zokulandelela
    • Landelela izibuyekezo ku-Excel
    • Buyekeza izibuyekezo ku-Excel
    • Amazwana eseli ku-Excel
  2. Ukuqeda kanye Nokuvikela Izincwadi Zokusebenzela
    • Vala futhi uvikele izincwadi zokusebenza ku-Excel
  3. Ukufomatha okunemibandela
    • Ukufometha Okunemibandela ku-Excel
  4. Amathebula e-Pivot nokuhlaziywa kwedatha
    • Isingeniso sePivotTables ku-Excel
    • I-Pivot Yedatha, Izihlungi, Izisiki, kanye namashadi e-Pivot
    • Kuthiwani uma ukuhlaziywa ku-Excel

Isigaba 5: Amafomula Athuthukile ku-Excel

  1. Sixazulula izinkinga sisebenzisa imisebenzi enengqondo
    • Ungasetha kanjani isimo esilula se-boolean ku-Excel
    • Ukusebenzisa Imisebenzi Ye-Excel Boolean Ukucacisa Izimo Eziyinkimbinkimbi
    • IF umsebenzi ku-Excel ngesibonelo esilula
  2. Ukubala nokufingqa ku-Excel
    • Bala amaseli ku-Excel usebenzisa COUNTIF kanye nemisebenzi engu-COUNTIF
    • Hlanganisa ku-Excel usebenzisa imisebenzi ye-SUM ne-SUMIF
    • Ungabala kanjani inani elihlanganisiwe ku-Excel
    • Bala izilinganiso ezinesisindo usebenzisa i-SUMPRODUCT
  3. Ukusebenza ngezinsuku nezikhathi ku-Excel
    • Usuku nesikhathi ku-Excel - imiqondo eyisisekelo
    • Ukufaka nokufometha amadethi nezikhathi ku-Excel
    • Imisebenzi yokukhipha amapharamitha ahlukahlukene kumadethi nezikhathi ku-Excel
    • Imisebenzi yokudala nokubonisa amadethi nezikhathi ku-Excel
    • Imisebenzi ye-Excel yokubala izinsuku nezikhathi
  4. Sesha idatha
    • Umsebenzi we-VLOOKUP ku-Excel onezibonelo ezilula
    • BUKA umsebenzi ku-Excel ngesibonelo esilula
    • I-INDEX kanye ne-MATCH imisebenzi ku-Excel enezibonelo ezilula
  5. Ngiyathokoza ukwazi
    • Imisebenzi Yezibalo ze-Excel Odinga Ukuyazi
    • Imisebenzi yezibalo ze-Excel odinga ukuyazi
    • Umbhalo we-Excel usebenza ngezibonelo
    • Uhlolojikelele lwamaphutha avela kumafomula e-Excel
  6. Ukusebenza ngamagama ku-Excel
    • Isingeniso samaseli namagama ebanga ku-Excel
    • Indlela yokuqamba iseli noma ububanzi ku-Excel
    • 5 Imithetho Ewusizo Nemihlahlandlela Yokudala Amagama Eseli Nobubanzi ku-Excel
    • Umphathi Wegama ku-Excel - Amathuluzi Nezici
    • Ungawaqamba kanjani ama-constants ku-Excel?
  7. Ukusebenza ngama-arrays ku-Excel
    • Isingeniso samafomula afanayo ku-Excel
    • Amafomula we-Multicell array ku-Excel
    • Amafomula ohlu lweseli eyodwa ku-Excel
    • Izinhlaka zama-constants ku-Excel
    • Ukuhlela amafomula afanayo ku-Excel
    • Ukusebenzisa amafomula afanayo ku-Excel
    • Izindlela zokuhlela amafomula afanayo ku-Excel

Isigaba 6: Uma uthanda

  1. Ukwenza ngokwezifiso isixhumi esibonakalayo
    • Uyenza kanjani ngokwezifiso i-Ribbon ku-Excel 2013
    • Thepha imodi ye-Ribbon ku-Excel 2013
    • Xhumanisa izitayela ku-Microsoft Excel

Ingabe ufuna ukufunda okwengeziwe nge-Excel? Ikakhulukazi kuwe, silungiselele izifundo ezimbili ezilula neziwusizo: izibonelo ze-Excel ezingama-300 nemisebenzi engama-30 ye-Excel ezinsukwini ezingama-30.

shiya impendulo