Kugwira ntchito mu Microsoft Excel, choyambirira ndicho kuphunzira momwe mungayikere mizere ndi mizati patebulo. Popanda maluso awa, ndizosatheka kugwira ntchito ndi data ya tabular. Tiyeni tiwone momwe mungapangire chipilala mu Excel.
Phunziro: Momwe mungapangire mzere patsamba la Microsoft Mawu
Ikani wolemba
Ku Excel, pali njira zingapo zoika chidutswa mu pepala. Ambiri aiwo ndiosavuta, koma wogwiritsa ntchito novice mwina sangamvetse zonse. Kuphatikiza apo, pali mwayi wosankha mizere kumanja kwa tebulo.
Njira 1: ikani kudzera pagulu logwirizana
Njira imodzi yosavuta yoikira ndikugwiritsa ntchito gulu la Excel yopingasa yolinganiza.
- Timadina pagawo lolinganiza lolumikizana ndi mayina a mizati m'gululi kumanzere komwe mukufuna kuyika mzati. Pankhaniyi, mzerewu umafotokozedwa bwino. Dinani kumanja. Pazosankha zomwe zimapezeka, sankhani Ikani.
- Pambuyo pake, mzere watsopano umawonjezeredwa kumanzere kwa malo osankhidwa.
Njira 2: onjezerani maselo kudzera pa menyu
Mutha kugwira ntchito iyi m'njira yosiyananso, monga mwa mndandanda wa foni.
- Timadula foni iliyonse yomwe ili mgawo kumanja kwa chipilala chomwe chikukonzekera kuti tiwonjezere. Timadulira izi ndi batani loyenera la mbewa. Pazosankha zomwe zikuwoneka, sankhani "Patani ...".
- Pakadali pano kuwonjezera kumeneku sikuchitika zokha. Iwindo laling'ono limatseguka pomwe muyenera kufotokozera zomwe wosuta adzalemba:
- Kholamu
- Chingwe;
- Cell ndi kosunthira pansi;
- Selo yokhala ndikusunthira kumanja.
Timasintha kusintha Kholamu ndipo dinani batani "Zabwino".
- Pambuyo pa izi, gawo lazowonjezera.
Njira 3: Chingwe cha Ribbon
Zithunzi zitha kuikidwa ndikugwiritsa ntchito batani lapadera pa riboni.
- Sankhani khungu kumanzere komwe mukufuna kuwonjezera mzati. Kukhala mu tabu "Pofikira", dinani chizindikirocho ngati mawonekedwe a unverted matatu yomwe ili pafupi ndi batani Ikani mu bokosi la zida "Maselo" pa tepi. Pazosankha zomwe zimatsegulira, sankhani Lowetsani Zambiri pa Mapepala.
- Pambuyo pake, mzati udawonjezeredwa kumanzere kwa chinthu chosankhidwa.
Njira 4: ikani ma cookie
Muthanso kuwonjezera mzere watsopano wogwiritsa ntchito ma cookkeys. Kuphatikiza apo, pali njira ziwiri zowonjezera
- Chimodzi mwazofanana ndi njira yoyamba kukhazikitsira. Muyenera kuwonekera pa gawo pazolumikizira zolumikizana zomwe zili kumanja kwa malo omwe mukufunidwa ndikulemba ndikusakanikirana kofunikira Ctrl ++.
- Kuti mugwiritse ntchito njira yachiwiri, muyenera dinani khungu lililonse pazolowera kumanja kwa malo oyikirako. Kenako lembani pa kiyibodi Ctrl ++. Zitatha izi, zenera laling'ono liwoneka ndi kusankha mtundu wamtundu womwe wafotokozedwa njira yachiwiri yochitira opareshoni. Zochita zina ndizofanana: sankhani chinthucho Kholamu ndipo dinani batani "Zabwino".
Phunziro: Ogula otentha
Njira 5: Ikani Zambiri Zambiri
Ngati mukufuna kukhazikitsa ngodya zingapo nthawi imodzi, ndiye kuti ku Excel palibe chifukwa chogwira ntchito iliyonse, chifukwa njirayi imatha kuphatikizidwa.
- Choyamba muyenera kusankha maselo ambiri pamzere wopingasa kapena magawo pagawo logwirizana momwe mungafunikire kuwonjezera pazipilara.
- Kenako yikani chimodzi mwazochita kudzera pazosankha kapena pogwiritsa ntchito makiyi otentha omwe afotokozedwera njira zam'mbuyomu. Chiwerengero chofananira cha mizati chidzawonjezedwa kumanzere kwa malo osankhidwa.
Njira 6: onjezani mzere kumapeto kwa tebulo
Njira zonsezi pamwambazi ndi zoyenera kuwonjezera pazipilala poyambira komanso pakati pa tebulo. Mutha kuzigwiritsanso ntchito kukhazikitsa mzati kumapeto kwa tebulo, koma muyenera kuchita izi mwanjira yoyenera. Koma pali njira zowonjezerera mzati kumapeto kwa tebulo kuti zitha kuzindikira nthawi yomweyo pulogalamuyo ngati gawo lawo. Kuti muchite izi, muyenera kupanga tebulo lotchedwa "anzeru".
- Timasankha mndandanda wamtundu womwe tikufuna kuti tisinthe ndi "bwino".
- Kukhala mu tabu "Pofikira"dinani batani "Fomati ngati tebulo"ili mu chipangizo Masitaelo pa tepi. Pamndandanda wotsitsa, sankhani chimodzi mwamndandanda wazithunzithunzi kapangidwe kazithunzithunzi mwakufuna kwathu.
- Pambuyo pake, zenera limatseguka momwe magwirizanidwe amalo osankhidwa amawonetsedwa. Ngati mwasankha china chake molakwika, apa ndiye kuti mutha kusintha. Chinthu chachikulu chomwe chikufunika kuchitidwa pa gawoli ndikuwunika ngati cheke cheki pafupi ndi paramu Mutu wa Mitu. Ngati tebulo lanu limakhala ndi mutu (ndipo nthawi zambiri ndi), koma palibe chikhomo cha zinthuzi, ndiye muyenera kuyiyika. Ngati zoikamo zonse zakonzedwa molondola, dinani batani "Zabwino".
- Pambuyo pa izi, mitundu yosankhidwa idapangidwa ngati tebulo.
- Tsopano, kuti muphatikize mzati watsopano patebulopo, ndikokwanira kudzaza khungu lililonse kumanja kwake ndi deta. Mzere womwe khungu ili limakhalapo udzakhala tebulo.
Monga mukuwonera, pali njira zingapo zowonjezera mzati zatsopano papepala lothandizira la Excel, zonse pakati pa tebulo komanso m'magawo owonjezera. Kupanga zowonjezerazo kukhala kosavuta komanso kosavuta momwe mungathere, ndibwino kuti mupange tebulo lotchedwa anzeru. Potere, pakuwonjezera danga kumanja kumanja kwa tebulo, limaphatikizidwa momwemo mu mawonekedwe amtundu watsopano.
