Excel Macro Tutorial

Phunziro ili likugwiritsira ntchito zolemba zazikulu kuti apange macro osavuta ku Excel . Zojambula zazikulu zimagwira ntchito polemba zolemba zonse ndi kuwongolera kwa mbewa. Zambiri zomwe zinapangidwa mu phunziroli zidzagwiritsa ntchito njira zambiri zojambula pamutu pazomwe mukulemba .

Mu Excel 2007 ndi 2010, malamulo onse okhudzana ndi macro ali pa Tsambulitsi Yopanga Chinsalu ya Riboni . Kawirikawiri, tabu iyi iyenera kuwonjezeredwa ku riboni kuti ipeze malamulo akuluakulu. Mitu yomwe ili ndi phunziroli ndi:

• Kuwonjezera Pakanema Khonde
• Kuyambira pa Excel macro recorder
• Zosankha zojambula zamtundu wa Excel
• Kujambula macro
• Kuthamanga kwambiri
• Zolakwika za Macro / Kusintha macro

01 ya 06

Kuwonjezera Pakanema Khonde

1. Dinani pa Fayilo tabu ya riboni kuti mutsegule fayilo menyu.
2. Dinani pa Zosankha mu menyu kuti mutsegule Zokambirana za Excel Options .
3. Dinani pazomwe Mungasankhe pazenera pawindo lamanzere kuti muwone njira zomwe zilipo muwindo lamanja la bokosi.
4. Pansi pa Tsamba la Ma Tabs la zosankhazo, mawindo amayang'ana njira Yotsatsa .
5. Dinani OK.
6. Tsambali lachondeli liyenera kuwonetsedwa tsopano mu Excel 2010.

Kuwonjezera Masakonzedwe Makanema mu Excel 2007

1. Mu Excel 2007, dinani pa bokosi la Office kuti mutseke menyu yotsitsa.
2. Dinani pa batani a Excel Options omwe ali pansi pa menyu kuti mutsegula Excel Options dialog box.
3. Dinani pa Njira Yotchuka pamwamba pawindo lamanzere la bokosi lakulumikiza.
4. Dinani pa Tsatanetsatane Wowonetsera Wokonzera mu khonde lomwe liri kudzanja lamanja la bokosi lakulumikiza.
5. Dinani OK.
6. Tsambulitsi yotsitsila iyenera tsopano kuwonetsedwa m'kaboni.

02 a 06

Kuwonjezera Pulogalamu Yophunzira Title / Excel Macro Recorder

Tisanayambe kujambula zolemba zathu, tifunika kuwonjezera mutu womwe timakhala nawo.

Popeza mutu wa tsamba lililonse umakhala wapadera ku tsambalo, sitikufuna kuti titchulepo mutuwu. Potero tidzowonjezera ku worksheet, musanayambe zojambula zazikulu.

1. Dinani pa selo A1 mu tsamba la ntchito.
2. Lembani mutu: Zolemba Zamalonda Zogulitsa ku June 2008 .
3. Dinani ku key lolowamo pa khibhodi.

Zolemba Zojambula Zojambula

Njira yosavuta yopanga macro mu Excel ndiyo kugwiritsa ntchito zojambula zazikulu. Kuchita izi:

1. Dinani pa Otsogolera tabu.
2. Dinani pa Record Macro mu riboni kuti mutsegule bokosi la Record Macro .

03 a 06

Macro Recorder Options

Pali njira 4 zomwe mungakwaniritse mu bokosi ili:

1. Dzina la macro - perekani dzina lanu lofotokozera. Dzina liyenera kuyamba ndi kalata ndi malo osaloledwa. Makalata, manambala ndi chikhalidwe chotsimikizirika amaloledwa.
2. Mfungulo wafupikitsa - (mungakonde) lembani kalata, nambala, kapena maonekedwe ena mu malo omwe alipo. Izi zidzakulolani kuti muthe kuyendetsa masewerawa polemba chilembo cha CTRL ndikusindikiza kalata yosankhidwa pa makiyi.
3. Sungani macro mkati
   • Zosankha:
   • Bukuli
     • Zambirizi zimapezeka pokhapokha mu fayilo iyi.
   • Buku latsopano
     • Njirayi ikutsegula fayilo yatsopano ya Excel. Zachilendozi zimapezeka kokha pa fayilo yatsopanoyi.
   • Buku labwinopo la anthu.
     • Njirayi imapanga mafayilo obisika a Personal.xls omwe amasungira ma macros anu ndikuwapangitsani inu maofesi onse a Excel.
4. Kufotokozera - (zosankha) lowetsani kufotokozera zamkati.

Phunziroli

1. Ikani zosankha mu bokosi la Mauthenga a Record Macro kuti mufanane ndi omwe ali pa chithunzi pamwambapa.
2. Osati dinani OK - komabe - onani pansipa.
   • Kusindikiza botani labwino mu bokosi la Mauthenga a Macro akuyamba kujambula macro omwe mwangodziwa kumene.
   • Monga tanenera kale, zojambula zazikulu zimagwira ntchito polemba zolemba zonse ndi kuwongolera kwa mbewa.
   • Kupanga zojambulazo_mabuku ophatikizira zimaphatikizapo kusindikiza pazithunzi zamtundu zingapo pakhomo la kunyumba la riboni ndi mbewa pamene zolemba zazikulu zikuyenda.
3. Pitani ku sitepe yotsatira musanayambe zojambula zazikulu.

04 ya 06

Kujambula Zochitika za Macro

1. Dinani botani loyenera ku Record Macro dialog box kuti muyambe zojambula zazikulu.
2. Dinani pa tabu la Home la riboni.
3. Onetsetsani maselo A1 kuti F1 mu tsamba la ntchito.
4. Dinani pa chithunzi cha Mgwirizano ndi Pakati kuti mukhale mutu pakati pa maselo A1 ndi F1.
5. Dinani pajambula Yodzaza Mitundu (imawoneka ngati utoto ukhoza) kutsegula mndandanda wazitsika.
6. Sankhani Buluu, Kalankhulidwe 1 kuchokera pa mndandanda kuti mutembenuzire mtundu wa maselo osankhidwa kuti ukhale wabuluu.
7. Dinani pa chithunzi Chajambula Chokongola (ndilo kalata yaikulu "A") kutsegula mndandanda wamatsitsi.
8. Sankhani White kuchokera pa mndandanda kuti mutembenuzire malemba kumaselo osankhidwa kuti ayambe kuyera.
9. Dinani pa Chithunzi Chachizindikiro (pamwamba pa chithunzi chojambula chithunzi) kuti mutsegule mndandanda wazitsitsimezidwe.
10. Sankhani 16 kuchokera pa mndandanda kuti musinthe kukula kwa malemba mumaselo osankhidwa kufika pazomwe 16.
11. Dinani pa tsamba lokonzekera lavoni.
12. Dinani batani la Stop Recording pa kaboni kuti muyimitse kujambula kwakukulu.
13. Panthawiyi, mutu wanu wa tsamba uyenera kufanana ndi mutu womwe uli pamwambapa.

05 ya 06

Kuthamanga kwa Macro

Kuti muyambe macro omwe mwalemba:

1. Dinani patsamba la Tsamba2 pansi pa spreadsheet .
2. Dinani pa selo A1 mu tsamba la ntchito.
3. Lembani mutu: Zolemba Zamalonda Zamagolosi a July 2008 .
4. Dinani ku key lolowamo pa khibhodi.
5. Dinani pa tsamba lokonzekera lavoni.
6. Dinani batani la Macros pa Riboni kuti mubweretse bokosi la Mabulo la Macro .
7. Dinani pamasewero_masamba mawindo m'mawindo la dzina la Macro .
8. Dinani pa batani.
9. Masitepe a lalikulu ayenera kuthamanga mosavuta ndipo agwiritsenso ntchito zofanana zomwe zimagwiritsidwa ntchito pamutu pa pepala 1.
10. Pano, mutu wa pa tsamba 2 uyenera kufanana ndi mutu pa tsamba 1.

06 ya 06

Zolakwika za Macro / Kusintha Macro

Zolakwa za Macro

Ngati zazikulu zanu sizinachite monga momwe ziyembekezeredwa, njira yosavuta, komanso yabwino ndiyo kutsatira ndondomeko ya phunzirolo ndikulemba kachilomboko.

Kusintha / Khwerero ku Macro

An Excel macro yalembedwa m'chinenero cha ma Visual Basic for Applications (VBA).

Kusinthanitsa pa Kusintha kapena Gawo Muzitsulo mu bokosi la ma Macro kumayambitsa mkonzi wa VBA (onani chithunzi pamwambapa).

Pogwiritsa ntchito mkonzi wa VBA ndikuphimba chinenero cha VBA, sichikupezeka pa phunziro ili.