クイズ講座 表計算マクロ 初級コース
1K+
Okudawunilodiwe
Wonke umuntu
info
Mayelana nale geyimu
Lona umbuzo wezinga labaqalayo kanye nesifundo ku-Excel macros (VBA), isofthiwe yesipredishithi edumile esebenza ku-Windows.
Lesi sifundo sihlanganisa izinguqulo 365, 2024, kanye no-2097 ze-Excel, isofthiwe yesipredishithi edumile esebenza ku-Windows.
(Imininingwane yophawu lokuhweba)
I-Microsoft Excel wuphawu lokuhweba olubhalisiwe noma wuphawu lokuhweba lwe-Microsoft Corporation e-United States kanye/noma kwamanye amazwe.
I-VBA (Visual Basic for Applications) kanye ne-Visual Basic izimpawu zokuthengisa ezibhalisiwe noma izimpawu zokuthengisa ze-Microsoft Corporation e-United States kanye/noma kwamanye amazwe.
■ Ububanzi Bemibuzo Nokuqukethwe Kwesifundo■
Lesi sifundo sihloselwe labo abajwayelene nokusebenza kwespredishithi njengokwenza amafomula namathebula nokulondoloza izincwadi zokusebenza, kodwa abathola ulimi lokubhala (VBA) lunzima futhi lwesabisa ukulufunda.
Lesi sifundo sihloselwe labo abafuna ukufunda ngokugcwele izisekelo zokuhlela.
Esigabeni Sezisekelo, uzofunda ulwazi oluyisisekelo nolwazi oludingekayo ekuhleleni.
Esigabeni Esisebenzayo, uzothola ulwazi olunolwazi lokuhlela ngokwakha izinhlelo zokusebenza ezimbalwa ezilula.
Umgomo omkhulu "ukudala izinhlelo zokusebenza ezilula."
■ Imibuzo Yemibuzo■
Ukuhlola kusekelwe emazingeni amane alandelayo.
Amaphuzu ayi-100: Ukusebenza okuhle kakhulu.
Amaphuzu angama-80 noma ngaphansi: Ukusebenza kahle.
60 amaphuzu noma ngaphansi: Qhubeka uzama.
0 amaphuzu noma ngaphansi: Zama kakhudlwana.
Ukuzuza amaphuzu aphelele angu-100 kuzo zonke izifundo kuzophumela esitifiketini!
Isitifiketi esivezwe kuhlelo lokusebenza kuphela esisemthethweni.
Zama imibuzo yemibuzo ukuze uzuze [isitifiketi] sakho!
■ Uhlolojikelele lwesifundo■
= Izisekelo =
Izifundo ezilandelayo zihlanganisa okubalulekile kokuhlela kwezinga labaqalayo.
1. Isingeniso
Funda amalungiselelo ayisisekelo angaphambi kwesifundo kanye nendlela yokusebenzisa Isihleli Esiyisisekelo Esibonakalayo.
2. Visual Basic
Funda ulimi lokuhlela, Visual Basic.
3. Izinto Zespredishithi (i-Excel).
Funda indlela yokusebenzisa izinto zespredishithi ezilimini zokubhala.
4. Amasu Okuhlela
Funda amakhono abalulekile wokuhlela.
= Isifundo Esisebenzayo =
Funda izinhlelo ezisebenzayo usebenzisa izifundo ezehlukene ezisuselwe ku-Basic Course.
1. Inventory Table Update
Lesi sifundo sethula isifundo esiyisibonelo kusetshenziswa ukuqoshwa okukhulu, kusetshenziswa ithebula le-inventory njengesihloko.
2. Uhlu lokuhlola
Lesi sifundo sethula isifundo esiyisibonelo sisebenzisa izehlakalo, kusetshenziswa uhlu lokuhlola njengesifundo.
3. Iwashi elimiswayo
Lesi sifundo sethula isibonelo esithile sokuhlela kusetshenziswa isitophuwashi njengesihloko.
4. I-SUM Umsebenzi wokulingisa
Lesi sifundo sizama umsebenzi we-SUM, umsebenzi weshidi lokusebenzela.
5. Ibhokisi Lengxoxo/Okokufaka Inani
Lesi sifundo sizama ukufaka inani sisebenzisa ibhokisi lengxoxo.
6. Ukubalwa kwe-Arithmetic/Numeric
Lesi sifundo sizama okuyisisekelo kwesamba nesilinganiso.
7. Okuhlobene Nosuku/Ikhalenda
Lesi sifundo sizama ukudala ikhalenda.
Ngalesi sifundo, uzothola amakhono asebenzayo wokuhlela, kusukela kwezisekelo zezinga labaqalayo.
Lesi sifundo sihlanganisa izinguqulo 365, 2024, kanye no-2097 ze-Excel, isofthiwe yesipredishithi edumile esebenza ku-Windows.
(Imininingwane yophawu lokuhweba)
I-Microsoft Excel wuphawu lokuhweba olubhalisiwe noma wuphawu lokuhweba lwe-Microsoft Corporation e-United States kanye/noma kwamanye amazwe.
I-VBA (Visual Basic for Applications) kanye ne-Visual Basic izimpawu zokuthengisa ezibhalisiwe noma izimpawu zokuthengisa ze-Microsoft Corporation e-United States kanye/noma kwamanye amazwe.
■ Ububanzi Bemibuzo Nokuqukethwe Kwesifundo■
Lesi sifundo sihloselwe labo abajwayelene nokusebenza kwespredishithi njengokwenza amafomula namathebula nokulondoloza izincwadi zokusebenza, kodwa abathola ulimi lokubhala (VBA) lunzima futhi lwesabisa ukulufunda.
Lesi sifundo sihloselwe labo abafuna ukufunda ngokugcwele izisekelo zokuhlela.
Esigabeni Sezisekelo, uzofunda ulwazi oluyisisekelo nolwazi oludingekayo ekuhleleni.
Esigabeni Esisebenzayo, uzothola ulwazi olunolwazi lokuhlela ngokwakha izinhlelo zokusebenza ezimbalwa ezilula.
Umgomo omkhulu "ukudala izinhlelo zokusebenza ezilula."
■ Imibuzo Yemibuzo■
Ukuhlola kusekelwe emazingeni amane alandelayo.
Amaphuzu ayi-100: Ukusebenza okuhle kakhulu.
Amaphuzu angama-80 noma ngaphansi: Ukusebenza kahle.
60 amaphuzu noma ngaphansi: Qhubeka uzama.
0 amaphuzu noma ngaphansi: Zama kakhudlwana.
Ukuzuza amaphuzu aphelele angu-100 kuzo zonke izifundo kuzophumela esitifiketini!
Isitifiketi esivezwe kuhlelo lokusebenza kuphela esisemthethweni.
Zama imibuzo yemibuzo ukuze uzuze [isitifiketi] sakho!
■ Uhlolojikelele lwesifundo■
= Izisekelo =
Izifundo ezilandelayo zihlanganisa okubalulekile kokuhlela kwezinga labaqalayo.
1. Isingeniso
Funda amalungiselelo ayisisekelo angaphambi kwesifundo kanye nendlela yokusebenzisa Isihleli Esiyisisekelo Esibonakalayo.
2. Visual Basic
Funda ulimi lokuhlela, Visual Basic.
3. Izinto Zespredishithi (i-Excel).
Funda indlela yokusebenzisa izinto zespredishithi ezilimini zokubhala.
4. Amasu Okuhlela
Funda amakhono abalulekile wokuhlela.
= Isifundo Esisebenzayo =
Funda izinhlelo ezisebenzayo usebenzisa izifundo ezehlukene ezisuselwe ku-Basic Course.
1. Inventory Table Update
Lesi sifundo sethula isifundo esiyisibonelo kusetshenziswa ukuqoshwa okukhulu, kusetshenziswa ithebula le-inventory njengesihloko.
2. Uhlu lokuhlola
Lesi sifundo sethula isifundo esiyisibonelo sisebenzisa izehlakalo, kusetshenziswa uhlu lokuhlola njengesifundo.
3. Iwashi elimiswayo
Lesi sifundo sethula isibonelo esithile sokuhlela kusetshenziswa isitophuwashi njengesihloko.
4. I-SUM Umsebenzi wokulingisa
Lesi sifundo sizama umsebenzi we-SUM, umsebenzi weshidi lokusebenzela.
5. Ibhokisi Lengxoxo/Okokufaka Inani
Lesi sifundo sizama ukufaka inani sisebenzisa ibhokisi lengxoxo.
6. Ukubalwa kwe-Arithmetic/Numeric
Lesi sifundo sizama okuyisisekelo kwesamba nesilinganiso.
7. Okuhlobene Nosuku/Ikhalenda
Lesi sifundo sizama ukudala ikhalenda.
Ngalesi sifundo, uzothola amakhono asebenzayo wokuhlela, kusukela kwezisekelo zezinga labaqalayo.
Kubuyekezwe ngo-
Ukuphepha kuqala ngokuqonda ukuthi onjiniyela baqoqa futhi babelane kanjani ngedatha yakho. Ubumfihlo bedatha nezinqubo zokuphepha zingahluka kuye ngokusebenzisa kwakho, isifunda, nobudala. Unjiniyela unikeze lolu lwazi futhi angalubuyekeza ngokuhamba kwesikhathi.
Ayikho idatha eyabiwe nezinkampani zangaphandle
Funda kabanzi mayelana nendlela onjiniyela abaveza ngayo ukwabelana
Ayikho idatha eqoqiwe
Funda kabanzi mayelana nokuthi onjiniyela bakuveza kanjani ukuqoqwa
Yini entsha
認定証の取得 (全課目１００点満点制覇!!の場合)
オプションメニューに[動画 (講座アプリ向け)]を追加
オプションメニューにアプリの[最新バージョンの確認]を追加
イメージトレーニングの画面の向きに応じてボタンの位置を変更
講座ページでのピンチ操作によるズームイン・ズームアウト機能に対応
Android 16 対応
オプションメニューに[動画 (講座アプリ向け)]を追加
オプションメニューにアプリの[最新バージョンの確認]を追加
イメージトレーニングの画面の向きに応じてボタンの位置を変更
講座ページでのピンチ操作によるズームイン・ズームアウト機能に対応
Android 16 対応
Ukusekelwa kwe-app
Mayelana nonjiniyela
VBASYS JUKU
juku@vbasys.net
619-455, KAMISENOCHO, AKI-KU
HIROSHIMA, 広島県 739-0302
Japan
+81 70-9096-2966