Zamkatimu
Kuchokera pa bukhuli muphunzira ndikutha kuphunzira momwe mungabise mizati mu Excel 2010-2013. Mudzawona momwe magwiridwe antchito a Excel obisala amagwirira ntchito, ndipo muphunziranso momwe mungasankhire ndikugawa magawo pogwiritsa ntchito "Gulu".
Kutha kubisa mizati mu Excel ndikothandiza kwambiri. Pakhoza kukhala zifukwa zambiri zosawonetsa gawo lina la tebulo (tsamba) pazenera:
- Mizati iwiri kapena kuposerapo iyenera kufananizidwa, koma imasiyanitsidwa ndi zigawo zina zingapo. Mwachitsanzo, mukufuna kufananiza mizati A и Y, ndipo chifukwa cha izi ndizosavuta kuziyika pambali. Mwa njira, kuwonjezera pa mutuwu, mukhoza kukhala ndi chidwi ndi nkhaniyi Momwe Mungayikitsire Magawo mu Excel.
- Pali zigawo zingapo zothandizira zomwe zili ndi mawerengedwe apakatikati kapena ma formula omwe amatha kusokoneza ogwiritsa ntchito ena.
- Mukufuna kubisala kuti musamawone kapena kutetezedwa kuti musasinthe zina zofunika kapena zambiri zanu.
Werengani kuti mudziwe momwe Excel imapangira kuti ikhale yachangu komanso yosavuta kubisa mizati yosafunikira. Kuphatikiza apo, m'nkhaniyi muphunzira njira yosangalatsa yobisira zipilala pogwiritsa ntchito "Gulu", zomwe zimakulolani kubisala ndikuwonetsa mizati yobisika mu sitepe imodzi.
Bisani mizati yosankhidwa mu Excel
Kodi mukufuna kubisa mizati imodzi kapena zingapo patebulo? Kodi pali njira yosavuta yochitira izi:
- Tsegulani pepala la Excel ndikusankha mizati yomwe mukufuna kubisa.
Tip: Kuti musankhe mizati yosakhala yoyandikana, ikani chizindikirocho podina batani lakumanzere ndikusunga makiyiwo Ctrl.
- Dinani kumanja pa mizati yosankhidwa kuti mubweretse menyu yankhani ndikusankha Bisani (Bisani) pamndandanda wazinthu zomwe zilipo.
Tip: Kwa omwe amakonda njira zazifupi za kiyibodi. Mutha kubisa mizati yosankhidwa podina Ctrl + 0.
Tip: Mutha kupeza gulu Bisani (Bisani) pa Riboni ya Menyu Kunyumba > Maselo > Makhalidwe > Bisani ndikuwonetsa (Poyamba > Maselo > Mtundu > Bisani & Osabisa).
Voila! Tsopano mutha kusiya mosavuta deta yofunikira kuti muwonere, ndikubisala zosafunikira kuti zisasokoneze ntchito yomwe ilipo.
Gwiritsani ntchito chida cha "Gulu" kubisa kapena kuwonetsa mizati ndikudina kamodzi
Omwe amagwira ntchito kwambiri ndi matebulo nthawi zambiri amagwiritsa ntchito luso lobisala ndikuwonetsa mizati. Palinso chida china chomwe chimagwira ntchito yabwino ndi ntchitoyi - mudzayamikira! Chida ichi ndiGulu“. Zimachitika kuti pa pepala limodzi pali magulu angapo osalumikizana amizere omwe amafunika kubisika kapena kuwonetsedwa nthawi zina - ndikuzichita mobwerezabwereza. Zikatero, kupanga magulu kumapangitsa kuti ntchito ikhale yosavuta.
Mukapanga magulu, chopingasa chopingasa chimawonekera pamwamba pake kuti chiwonetse mizati yomwe yasankhidwa kuti ikhale m'magulu ndipo ikhoza kubisika. Pafupi ndi dash, mudzawona zithunzi zing'onozing'ono zomwe zimakulolani kubisala ndikuwonetsa deta yobisika ndikudina kamodzi kokha. Kuwona zithunzi zotere papepala, mudzamvetsetsa nthawi yomweyo komwe mizati yobisika ili ndi mizati yomwe ingabisike. Momwe zimachitikira:
- Tsegulani pepala la Excel.
- Sankhani maselo oti muwabise.
- Press Shift+Alt+Kumanja Muvi.
- A dialog box adzaoneka Gulu (Gulu). Sankhani Zambiri (Zigawo) ndikudina OKkutsimikizira kusankha.
Tip: Njira ina yopita ku bokosi lomwelo la zokambirana: Deta > gulu > gulu (Deta> Gulu> Gulu).
Tip: Kuti muchotse gulu, sankhani mndandanda womwe uli ndi magawo omwe ali m'magulu ndikudina Shift+Alt+Left Arrow.
- Chida «Gulu»ziwonjezera zilembo zapadera pa pepala la Excel, zomwe ziwonetse ndendende ndimizere yomwe ili mgululi.
- Tsopano, imodzi ndi imodzi, sankhani mizati yomwe mukufuna kubisa, ndikusindikiza kulikonse Shift+Alt+Kumanja Muvi.
Zindikirani: Mutha kupanga magulu oyandikana nawo. Ngati mukufuna kubisa mizati yosakhala yoyandikana, muyenera kupanga magulu osiyana.
- Mukangosindikiza makiyi osakaniza Shift+Alt+Kumanja Muvi, mizati yobisika idzawonetsedwa, ndi chithunzi chapadera chokhala ndi chikwangwani "-»(osachepera).
- Kusinkhasinkha opanda adzabisa mizati, ndi “-'zidzasanduka'+“. Kusindikiza more iwonetsa nthawi yomweyo zigawo zonse zobisika mugululi.
- Pambuyo pamagulu, manambala ang'onoang'ono amawonekera pakona yakumanzere. Zitha kugwiritsidwa ntchito kubisala ndikuwonetsa magulu onse a msinkhu womwewo panthawi imodzi. Mwachitsanzo, mu tebulo ili m'munsimu, kuwonekera pa nambala 1 idzabisa mizati yonse yomwe ikuwoneka pachithunzichi, ndikudina pa nambala 2 adzabisa mizati С и Е. Izi ndizothandiza kwambiri mukapanga magulu otsogola komanso magulu angapo.
Ndizomwezo! Mwaphunzira momwe mungagwiritsire ntchito chida chobisala mizati mu Excel. Kuphatikiza apo, mwaphunzira momwe mungasankhire magulu ndikuchotsa magulu. Tikukhulupirira kuti kudziwa zanzeru izi kukuthandizani kuti ntchito yanu yanthawi zonse mu Excel ikhale yosavuta.
Khalani opambana ndi Excel!