Maphunziro a Microsoft Excel a Dummies

Maphunziro a Microsoft Excel a Dummies

Maphunziro a Excel a Dummies zimakupatsani mwayi womvetsetsa ndikuwongolera maluso oyambira ogwirira ntchito ku Excel, kuti mutha kupita molimba mtima kumitu yovuta kwambiri. Maphunzirowa akuphunzitsani momwe mungagwiritsire ntchito mawonekedwe a Excel, kugwiritsa ntchito mafomu ndi ntchito kuti muthetse mavuto osiyanasiyana, kupanga ma graph ndi ma chart, kugwira ntchito ndi ma pivot tables ndi zina zambiri.

Maphunzirowa adapangidwa makamaka kwa ogwiritsa ntchito novice Excel, makamaka "ma dummies athunthu". Chidziwitso chimaperekedwa pang'onopang'ono, kuyambira ndi zofunikira kwambiri. Kuchokera kugawo kupita ku gawo la maphunziro, zinthu zambiri zosangalatsa komanso zosangalatsa zimaperekedwa. Mukamaliza maphunziro onse, mudzagwiritsa ntchito chidziwitso chanu molimba mtima ndikuphunzira momwe mungagwiritsire ntchito zida za Excel zomwe zingathetse 80% ya ntchito zanu zonse. Ndipo chofunika kwambiri:

  • Mudzaiwala nthawi zonse funso: "Momwe mungagwire ntchito ku Excel?"
  • Tsopano palibe amene angayerekeze kukuyitanani "teapot".
  • Palibe chifukwa chogula maphunziro opanda pake kwa oyamba kumene, omwe amasonkhanitsa fumbi pa alumali kwa zaka zambiri. Gulani mabuku ofunikira ndi othandiza okha!
  • Patsamba lathu mupeza maphunziro ambiri osiyanasiyana, maphunziro ndi zolemba zogwirira ntchito mu Microsoft Excel osati kokha. Ndipo zonsezi pamalo amodzi!

Gawo 1: Zoyambira za Excel

  1. Kuyamba kwa Excel
    • Mawonekedwe a Microsoft Excel
    • Riboni mu Microsoft Excel
    • Mawonekedwe a Backstage mu Excel
    • Quick Access Toolbar ndi Book Views
  2. Pangani ndi kutsegula mabuku ogwirira ntchito
    • Pangani ndi kutsegula mabuku a Excel
    • Mode Yogwirizana mu Excel
  3. Kusunga mabuku ndi kugawana
    • Sungani ndi AutoRecover Workbooks mu Excel
    • Kutumiza kunja kwa Excel Workbooks
    • Kugawana Mabuku Ogwiritsa Ntchito a Excel
  4. Maziko a Cell
    • Cell in Excel - mfundo zoyambira
    • Zomwe zili m'ma cell mu Excel
    • Kukopera, kusuntha ndi kuchotsa ma cell mu Excel
    • Kumaliza ma cell mu Excel
    • Pezani ndi Kusintha mu Excel
  5. Sinthani mizati, mizere ndi maselo
    • Sinthani kukula kwa mizere ndi kutalika kwa mizere mu Excel
    • Lowetsani ndi kuchotsa mizere ndi mizati mu Excel
    • Sunthani ndi kubisa mizere ndi mizati mu Excel
    • Manga mawu ndikuphatikiza ma cell mu Excel
  6. Mapangidwe a Maselo
    • Kupanga mafonti mu Excel
    • Kuyanjanitsa mawu mu ma cell a Excel
    • Malire, shading ndi masitaelo a cell mu Excel
    • Kupanga manambala mu Excel
  7. Zoyambira Mapepala a Excel
    • Sinthani dzina, ikani ndikuchotsa pepala mu Excel
    • Koperani, sunthani ndikusintha mtundu wa pepala mu Excel
    • Kugawa mapepala mu Excel
  8. Kapangidwe katsamba
    • Kupanga ma margins ndi mawonekedwe a masamba mu Excel
    • Ikani zoduka masamba, sindikizani mitu ndi ma footer mu Excel
  9. Kusindikiza mabuku
    • Sindikizani gulu mu Microsoft Excel
    • Khazikitsani malo osindikizira mu Excel
    • Kukhazikitsa malire ndi sikelo mukasindikiza mu Excel

Gawo 2: Mafomula ndi Ntchito

  1. Njira Zosavuta
    • Ogwiritsa ntchito masamu ndi ma cell mu ma fomula a Excel
    • Kupanga Mafomu Osavuta mu Microsoft Excel
    • Sinthani mafomula mu Excel
  2. Zolemba zovuta
    • Chiyambi cha mafomula ovuta mu Excel
    • Kupanga mafomu ovuta mu Microsoft Excel
  3. Maulalo achibale ndi mtheradi
    • Maulalo ogwirizana mu Excel
    • Zolemba zenizeni mu Excel
    • Maulalo kumasamba ena mu Excel
  4. Mafomu ndi Ntchito
    • Chidziwitso cha Ntchito mu Excel
    • Kuyika ntchito mu Excel
    • Ntchito Library mu Excel
    • Ntchito Wizard mu Excel

Gawo 3: Kugwira ntchito ndi data

  1. Kuwongolera Mawonekedwe a Tsamba la Ntchito
    • Madera ozizira mu Microsoft Excel
    • Gawani mapepala ndikuwona buku lantchito la Excel m'mawindo osiyanasiyana
  2. Sinthani data mu Excel
    • Kusankha mu Excel - chidziwitso chofunikira
    • Kusintha kwachikhalidwe mu Excel
    • Sinthani magawo mu Excel
  3. Kusefa data mu Excel
    • Zosefera mu Excel - Zoyambira
    • Zosefera zapamwamba mu Excel
  4. Kugwira ntchito ndi magulu ndikukambirana
    • Magulu ndi Ma Subtotals mu Excel
  5. Matebulo mu Excel
    • Pangani, sinthani ndi kufufuta matebulo mu Excel
  6. Ma chart ndi Sparklines
    • Ma chart mu Excel - Basics
    • Masanjidwe, Mtundu, ndi Zosankha Zina za Tchati
    • Momwe mungagwiritsire ntchito ndi sparklines mu Excel

Gawo 4: Zapamwamba za Excel

  1. Kugwira ntchito ndi Zolemba ndi Kusintha Kotsatira
    • Tsatani zosintha mu Excel
    • Onaninso zosintha mu Excel
    • Ndemanga zama cell mu Excel
  2. Kumaliza ndi Kuteteza Mabuku a Ntchito
    • Tsekani ndi kuteteza mabuku ogwirira ntchito mu Excel
  3. Njira Zakukonzerani
    • Mapangidwe Okhazikika mu Excel
  4. Pivot tables ndi kusanthula deta
    • Chidziwitso cha PivotTables mu Excel
    • Data Pivot, Zosefera, Slicers, ndi PivotCharts
    • Bwanji ngati kusanthula mu Excel

Gawo 5: Mafomula apamwamba mu Excel

  1. Timathetsa mavuto pogwiritsa ntchito ntchito zomveka
    • Momwe mungakhazikitsire chikhalidwe chosavuta cha boolean mu Excel
    • Kugwiritsa ntchito Excel Boolean Ntchito Kufotokozera Zinthu Zovuta
    • IF ntchito mu Excel ndi chitsanzo chosavuta
  2. Kuwerengera ndi kuwerengera mwachidule mu Excel
    • Werengani ma cell mu Excel pogwiritsa ntchito COUNTIF ndi COUNTIF ntchito
    • Gwirizanitsani mu Excel pogwiritsa ntchito ntchito za SUM ndi SUMIF
    • Momwe mungawerengere kuchuluka kokwanira mu Excel
    • Werengetsani zolemera zake pogwiritsa ntchito SUMPRODUCT
  3. Kugwira ntchito ndi masiku ndi nthawi mu Excel
    • Tsiku ndi nthawi mu Excel - mfundo zoyambira
    • Kulowetsa ndi kupanga masiku ndi nthawi mu Excel
    • Ntchito zochotsa magawo osiyanasiyana kuchokera pamasiku ndi nthawi mu Excel
    • Ntchito zopanga ndikuwonetsa masiku ndi nthawi mu Excel
    • Excel imagwira ntchito powerengera masiku ndi nthawi
  4. Sakani zambiri
    • Ntchito ya VLOOKUP mu Excel yokhala ndi zitsanzo zosavuta
    • ONANI ntchito mu Excel ndi chitsanzo chosavuta
    • INDEX ndi MATCH ntchito mu Excel yokhala ndi zitsanzo zosavuta
  5. Zabwino kudziwa
    • Excel Statistical Ntchito Zomwe Muyenera Kudziwa
    • Ntchito zamasamu za Excel zomwe muyenera kudziwa
    • Zolemba za Excel zimagwira ntchito mu zitsanzo
    • Mwachidule za zolakwika zomwe zimachitika mu Excel formulas
  6. Kugwira ntchito ndi mayina mu Excel
    • Chiyambi cha ma cell ndi mayina osiyanasiyana mu Excel
    • Momwe mungatchulire cell kapena mtundu mu Excel
    • 5 Malamulo Othandiza Ndi Malangizo Opangira Ma Cell and Range Names mu Excel
    • Woyang'anira Dzina mu Excel - Zida ndi Zinthu
    • Momwe mungatchulire zosintha mu Excel?
  7. Kugwira ntchito ndi ma arrays mu Excel
    • Chiyambi cha mafomula osiyanasiyana mu Excel
    • Mafomu a Multicell mu Excel
    • Mafomu amtundu wa cell mu Excel
    • Mndandanda wa zosinthika mu Excel
    • Kusintha mitundu yosiyanasiyana mu Excel
    • Kugwiritsa ntchito mitundu yosiyanasiyana mu Excel
    • Njira zosinthira masanjidwe amitundu mu Excel

Gawo 6: Zosankha

  1. Kusintha kwa mawonekedwe
    • Momwe mungasinthire Riboni mu Excel 2013
    • Dinani mawonekedwe a Riboni mu Excel 2013
    • Lumikizani masitayilo mu Microsoft Excel

Mukufuna kudziwa zambiri za Excel? Makamaka kwa inu, takonzekera maphunziro awiri osavuta komanso othandiza: 300 Excel zitsanzo ndi 30 Excel ntchito m'masiku 30.

Siyani Mumakonda