Ntchito mu Excel ikukulolani kuchita zosiyana, m'malo momveka bwino, zochita zamakono ndi zochepa zochepa. Chida choterocho ngati "Mbuye Wa Ntchito". Tiyeni tiwone momwe zimagwirira ntchito ndi zomwe mungachite ndi izo.
Ntchito Yowonjezera ntchito
Mlaliki Wachipangizo Ndi chida ngati mawindo aang'ono omwe zonse zomwe zikugwira ntchito ku Excel zimapangidwa ndi gulu, zomwe zimawapangitsa kuti zikhale zosavuta. Komanso, zimapereka mphamvu yokhala ndi mfundo zowonongeka pogwiritsa ntchito mawonekedwe owonetsera.
Kusintha kwa Mbuye Wa Ntchito
Mlaliki Wachipangizo Mukhoza kuthamanga m'njira zingapo mwakamodzi. Koma musanayambe kugwiritsira ntchito chida ichi, muyenera kusankha selo imene mayendedwewa adzakhazikitsidwe ndipo, chifukwa chake, zotsatira zidzawonetsedwa.
Njira yosavuta yolowamo ndikutsegula pa batani. "Ikani ntchito"ili kumbali yakumanzere ya bar. Njirayi ndi yabwino chifukwa mungagwiritse ntchito, pokhala pa tebulo lililonse la pulogalamuyi.
Kuwonjezera apo, chida chimene tikusowa chingayambidwe poyambira pa tabu "Maonekedwe". Kenaka muyenera kudinkhani pa batani lakumanzere pamtambo "Ikani ntchito". Icho chiri mu zida za zipangizo. "Laibulale ya Ntchito". Njira iyi ndi yoipa kuposa yoyamba, chifukwa ngati mulibe tab "Maonekedwe", ndiye kuti muyenera kuchita zina zowonjezera.
Mukhozanso kutsegula pa batani ina iliyonse. "Laibulale ya Ntchito". Panthawi imodzimodziyo, mndandanda udzawonekera pa menyu yotsika pansi, pansi pomwepo pali chinthu "Ikani ntchito ...". Pano iwe uyenera kuwombera pa izo. Koma, njira iyi ndi yovuta kwambiri kuposa yoyamba.
Njira yophweka yopita muwonekedwe. Masters ndigwirizanitsa makiyi otentha Shift + F3. Njirayi imapereka kusintha msanga popanda "manja". Chovuta chachikulu cha ichi ndi chakuti sikuti aliyense wogwiritsa ntchito amatha kusunga mutu wake wonse. Kotero kwa Oyamba kumene pakuzindikira Excel, njira iyi si yoyenera.
Zigawo zamagulu mu Wizard
Mulimonse momwe mungagwiritsire ntchito njira zomwe mwasankhazi, mulimonsemo, mutatha izi zenera zowonekera Masters. Kumtunda kwazenera ndi malo osaka. Pano mukhoza kulowa dzina la ntchitoyo ndi kudinkhani "Pezani", kuti mupeze mwamsanga chinthu chomwe mukufuna ndikuchipeza.
Gawo lapakati lazenera likupereka mndandanda wazinthu zomwe zikuimira Mbuye. Kuti muwone mndandanda uwu, dinani pa chithunzicho ngati mawonekedwe a katatu osinthidwa kupita kumanja. Izi zikutsegula mndandanda wonse wa magulu omwe alipo. Pendekera pansi ndi bala lopukuta.
Ntchito zonse zigawidwa m'magulu 12 otsatirawa:
- Malemba;
- Ndalama;
- Tsiku ndi nthawi;
- Zolemba ndi zolemba;
- Chiwerengero;
- Kusanthula;
- Gwiritsani ntchito database;
- Kuyang'ana katundu ndi chikhalidwe;
- Zomveka;
- Ntchito;
- Masamu;
- Mtanthauziridwa;
- Kugwirizana.
M'gululi "Kutanthauzira Mtumiki" pali ntchito zomwe zimagwiritsidwa ntchito ndi wogwiritsa ntchito kapena zochotsedwa kuchokera kuzinthu zakunja. M'gululi "Kugwirizana" Zomwe zimachokera ku Excel yakale zilipo, zomwe zatsopano zimakhalako kale. Anasonkhanitsidwa mu gulu ili kuthandizira kuyanjana kwa ntchito ndi zolemba zomwe zagwiritsidwa ntchito zakale zogwiritsira ntchito.
Kuonjezera apo, pali mndandanda wazinthu ziwiri mndandanda uwu: "Mndandanda wathunthu wa alfabeti" ndi "Posachedwapa Anagwiritsidwa Ntchito". Mu gulu "Mndandanda wathunthu wa alfabeti" pali mndandanda wathunthu wa ntchito zonse, mosasamala kanthu. Mu gulu "Posachedwapa Anagwiritsidwa Ntchito" ndi mndandanda wa zinthu khumi zomwe zaposachedwa kumene wogwiritsa ntchito. Mndandandawu umasinthidwa nthawi zonse: zinthu zogwiritsidwa ntchito kale zimachotsedwa, ndipo zatsopano zowonjezedwa.
Kusankhidwa kwa ntchito
Kuti mupite kuwindo lazitsutso, choyamba muyenera kusankha gulu lomwe mukufuna. Kumunda "Sankhani ntchito" Dziwani kuti dzina lofunika kuti lichite ntchito yapadera. Pansi pazenera pali chithunzi cha ndemanga kwa chinthu chomwe wasankha. Pambuyo pa ntchito inayake yasankhidwa, muyenera kodina pa batani. "Chabwino".
Ntchito zotsutsana
Pambuyo pake, ntchito yowonekera zowatsegula. Chinthu chachikulu pawindo ili ndi minda yotsutsana. Ntchito zosiyana zimakhala ndi zifukwa zosiyana, koma mfundo yogwirira nawo ntchito imakhala yofanana. Pakhoza kukhala angapo, ndipo mwinamwake mmodzi. Mikangano ingakhale nambala, mafotokozedwe a selo, kapena ngakhale mavesi onse.
- Ngati tigwira ntchito ndi chiwerengero, ndiye tangowalowetsa kuchokera ku kiyibodi kupita kumunda, mofanana ndi momwe timayendetsera manambala m'maselo a pepala.
Ngati zolembazo zimagwiritsidwa ntchito ngati mkangano, zikhozanso kutchulidwa mwadongosolo, koma ndizovuta kwambiri kuchita zinazake.
Ikani cholozera mmunda wotsutsana. Osatseka zenera Masters, onetsetsani pa pepala selo kapena maselo osiyanasiyana omwe muyenera kuwatsata. Pambuyo pake mubokosi la bokosi Masters Zogwirizanitsa za selo kapena mtundu zimalowetsedwa. Ngati ntchitoyi ili ndi zifukwa zingapo, ndiye momwe mungalowetse deta mu gawo lotsatira.
- Pambuyo pa deta zonse zofunika, dinani pa batani "Chabwino", potero ndikuyambitsa ndondomeko yoyenera ntchito.
Kugwira ntchito
Mutatha kugunda batani "Chabwino" Mbuye imatseka ndipo ntchitoyo yokha imayendetsa. Zotsatira za kuphedwa zingakhale zosiyana kwambiri. Zimatengera ntchito zomwe zaikidwa patsogolo pa fomu. Mwachitsanzo, ntchitoyi SUM, yomwe idasankhidwa ngati chitsanzo, ikufotokozera mwachidule zifukwa zonse zomwe zatchulidwa ndikuwonetsa zotsatira mu selo losiyana. Zina mwazomwe mungachite kuchokera mndandanda Masters zotsatira zake zidzakhala zosiyana kwambiri.
Phunziro: Zogwiritsira ntchito za Excel
Monga tikuonera Mlaliki Wachipangizo ndi chida chothandizira kwambiri chomwe chimachepetsa kugwira ntchito ndi malemba mu Excel. Ndicho, mungathe kufufuza zinthu zomwe mumazifuna, komanso kulowetsa zifukwa pogwiritsa ntchito mawonekedwe owonetsera. Kwa osuta makina Mbuye makamaka zofunika.
