Kusintha chida ndi mfundo mu Microsoft Excel

Zikudziwika kuti m'chinenero cha Chirasha cha Excel chida chikugwiritsidwa ntchito monga cholekanitsa chazitali, pomwe mu Chingerezi mfundo yogwiritsiridwa ntchito ikugwiritsidwa ntchito. Izi zikuchitika chifukwa cha kukhalapo kwa miyezo yosiyanasiyana m'dera lino. Kuwonjezera apo, m'mayiko olankhula Chingerezi, ndizozoloŵera kugwiritsa ntchito comma ngati wolekanitsa, komanso m'dziko lathu - nthawi. Pachifukwachi, izi zimayambitsa vuto pamene munthu akutsegula fayilo yomwe imapangidwa pulogalamu ndi malo osiyana. Zimachokera ku mfundo yakuti Excel sichiganiziranso njira, popeza sizikumvetsetsa zizindikiro. Pankhaniyi, mukuyenera kusintha pulogalamuyo pamakonzedwe, kapena mutengere malemba omwe ali m'kabuku. Tiyeni tipeze momwe tingasinthire komma mpaka pulogalamuyi.

Njira yotsatila

Musanayambe kusintha, muyenera kuyamba kudzizindikira nokha zomwe mumapereka. Ndi chinthu chimodzi ngati mutachita njirayi chifukwa chakuti mukuwonekeratu kuti mukulekanitsa ndipo simukukonzekera kugwiritsa ntchito manambalawa muwerengero. Ndi chinthu chinanso ngati mukufuna kusintha chizindikiro chowerengera, ngati m'tsogolomu chikalatacho chidzagwiritsidwa ntchito mu Chingelezi cha Excel.

Njira 1: Pezani ndi Kusintha Chida

Njira yosavuta yopanga chisinthiko chamatsinje ndi kugwiritsa ntchito chida. "Pezani ndi kusintha". Koma, nthawi yomweyo dziŵike kuti njira iyi si yoyenera kuwerengera, chifukwa zomwe zili mu maselo zidzatembenuzidwa ku malemba.

1. Sankhani malo pamasamba, kumene muyenera kusintha makasitomala kuti mukhale ndi mfundo. Pangani chodindira. Muzondomeko zowonjezera, sankhani chinthucho "Sungani maselo ...". Ogwiritsa ntchito omwe amasankha kugwiritsa ntchito njira zina pogwiritsira ntchito "mafungulo otentha", atasankha, akhoza kulemba kuphatikiza Ctrl + 1.



2. Zowonetsera zojambulazo zimayambika. Pitani ku tabu "Nambala". Mu gulu la magawo "Maofomu Owerengeka" kusunthira kusankha kusankha "Malembo". Kuti muteteze kusintha kumeneku, dinani pa batani. "Chabwino". Mawonekedwe a deta mudongosolo losankhidwa adzasinthidwa.



3. Apanso, sankhani zolingazo. Izi ndizomwe zili zofunika kwambiri, chifukwa popanda chisankho choyambirira, kusinthidwa kudzachitika ponseponse pa pepala, ndipo izi sizofunika nthawi zonse. Pambuyo pasankhidwa, sungani ku tabu "Kunyumba". Dinani pa batani "Pezani ndi kuonetsa"yomwe ili mu chida chogwiritsa ntchito Kusintha pa tepi. Ndiye pulogalamu yaing'ono imatsegulidwa yomwe muyenera kusankha "Bwezerani ...".



4. Pambuyo pake, chidachi chimayamba. "Pezani ndi kusintha" mu tab "Bwezerani". Kumunda "Pezani" ikani chizindikiro ","ndi kumunda "Bwezerani ndi" - ".". Dinani pa batani "Bwezerani Zonse".



5. Zowonjezera zowonjezera zimatsegula momwe lipoti la kusintha kwatsimikiziridwa likufotokozedwa. Dinani pa batani. "Chabwino".

Pulogalamuyi imapanga kusintha kwa makasitomala ku mfundo zomwe zasankhidwa. Ntchitoyi ingaganizidwe kuti yothetsedwa. Koma ziyenera kukumbukiridwa kuti deta m'malo mwake idzakhala ndi malemba, choncho, sangagwiritsidwe ntchito paziwerengerozo.

Phunziro: Chotsani Mkhalidwe Wosintha

Njira 2: Gwiritsani ntchito ntchitoyi

Njira yachiwiri ikuphatikiza kugwiritsa ntchito wogwiritsa ntchito TIZANI. Choyamba, pogwiritsira ntchito ntchitoyi, tidzasintha detayi pambali yosiyana, ndikuyiyikanso kumalo ake oyambirira.

1. Sankhani selo lopanda kanthu kutsutsana ndi selo yoyamba ya deta, momwe makasitomala ayenera kusandulika kukhala zigawo. Dinani pazithunzi "Ikani ntchito"anaikidwa kumanzere kwa bar.



2. Zitatha izi, ntchito ya wizara idzayambitsidwa. Sakani m'gulu "Yesani" kapena "Mndandanda wathunthu wa alfabeti" dzina "MUZIKHALA". Sankhani ndipo dinani pa batani. "Chabwino".



3. Ntchito yotsutsana yenera ikutsegula. Icho chiri ndi zitatu zoyenera kutsutsana. "Malembo", "Zakale" ndi "New Text". Kumunda "Malembo" Muyenera kufotokoza adiresi ya selo imene deta iyenera kupezeka. Kuti muchite izi, yikani mthunzi mumunda uno, ndiyeno dinani pa pepalalo mu selo yoyamba ya zosiyana siyana. Posakhalitsa izi, adiresi idzawonekera pazenera zotsutsana. Kumunda "Zakale" ikani khalidwe lotsatira - ",". Kumunda "New Text" ikani mfundo - ".". Deta itatha, dinani pakani "Chabwino".



4. Monga mukuonera, kusintha kwa selo yoyamba kunapambana. Ntchito yofanana ingathe kuchitidwa kwa maselo ena onse a maulendo omwe mukufuna. Chabwino, ngati mtundu uwu ndi wawung'ono. Koma nanga bwanji ngati ili ndi maselo ambiri? Pambuyo pake, kusinthika mwanjira iyi, pakadali pano, kudzatenga nthawi yambiri. Koma, ndondomeko ikhoza kuthamanga kwambiri poyesa njirayi TIZANI kugwiritsa ntchito chikhomo chodzaza.

   Ikani chithunzithunzi pansi pambali pambali ya selo yomwe ili ndi ntchitoyo. Chizindikiro chodzaza chikuwonekera mu mawonekedwe a mtanda wawung'ono. Gwirani batani lamanzere la mchenga ndikujambula mtandawu mofanana ndi dera lomwe mukufuna kusintha makasitomalawo mu mfundo.



5. Monga momwe mukuonera, zonse zomwe zili mmalo mwachindunji zinasinthidwa ku deta ndi madontho m'malo mwa makasitomala. Tsopano mukuyenera kutsanzira zotsatirazo ndi kusungira mu gwero. Sankhani maselo omwe ali ndi njira. Kukhala mu tab "Kunyumba", dinani pa batani pa riboni "Kopani"yomwe ili mu gulu la zida "Zokongoletsera". Mungathe kukhale kosavuta, kutanthauza mutatha kusankha mtundu kuti mufanizire mgwirizano wa makiyi pa makiyi Ctrl + 1.



6. Sankhani mtundu woyambirira. Dinani kusankhidwa ndi batani lamanja la mouse. Menyu yamakono ikuwonekera. Muli, dinani pa chinthucho "Makhalidwe"yomwe ili mu gulu "Njira Zowonjezera". Chinthuchi chikuwonetsedwa ndi manambala. "123".



7. Pambuyo pazimenezi, zikhulupiliro zidzalowetsedwa muyeso yoyenera. Pankhani iyi, makasitomala adzasinthidwa kukhala mfundo. Kuchotsa dera lomwe silingatithandizenso, wodzazidwa ndi mayesero, sankhani ndikulumikiza batani lamanja la mouse. Mu menyu imene ikuwonekera, sankhani chinthucho "Chotsani Chokhutira".

Kutembenuka kwa deta pa kusintha kwa makasitomala kumalo kumapeto, ndipo zinthu zonse zosafunikira zimachotsedwa.

Phunziro: Wowonjezera Wogwira Ntchito

Njira 3: Gwiritsani ntchito Macro

Njira yotsatira yosinthira makasitomala ku mfundo ikugwirizana ndi kugwiritsa ntchito macros. Koma, chinthucho ndi chakuti mwachinsinsi, macros ku Excel ali olumala.

Choyamba, muyenera kuzipatsa macros, komanso kuyambitsa tabu "Wotsambitsa", ngati akadakalibe pulogalamu yanu. Pambuyo pake muyenera kuchita zotsatirazi:

1. Pitani ku tabu "Wotsambitsa" ndipo dinani pa batani "Visual Basic"yomwe ili mu chida chogwiritsa ntchito "Code" pa tepi.



2. Mkonzi wamkulu amatsegula. Timayika ndondomeko zotsatirazi mmenemo:

   Ma Macro_transformation_completion_point_point ()
Kusankha.Kumasulira Chiyani: = ",", Replacement: = "."
Malizani pang'ono

   Malizitsani ntchito ya mkonziyo pogwiritsa ntchito njira yowonjezera podindira pa botani loyandikira kumtunda wakumanja.



3. Kenako, sankhani mtundu umene ungasinthe. Dinani pa batani Macroszomwe ziri zonse mu gulu lomwelo la zida "Code".



4. Zenera likuyamba ndi mndandanda wa macros omwe alipo m'bukuli. Sankhani zomwe zangotengedwa kupyolera mu mkonzi. Mukasankha mzere ndi dzina lake, dinani pa batani Thamangani.

Kutembenuka kukupitirira. Makasitomala adzasandulika kukhala mfundo.

Phunziro: Momwe mungapangire macro ku Excel

Njira 4: Kukhazikitsa kwa Excel

Njira yotsatira ndi imodzi yokha yomwe ili pamwambapa, yomwe, pamene makasinthasintha akusintha mu mfundo, mawuwo adzawonetsedwa pulogalamuyi ngati nambala, osati monga malemba. Kuti tichite izi, tidzasintha njira yodzipatula muzowonjezera ndi chiwerengero cha nthawi.

1. Kukhala mu tab "Foni", dinani pa dzina lachinsinsi "Zosankha".



2. Muwindo la magawo timasunthira ku ndimeyi "Zapamwamba". Timayang'ana makonzedwe a malo "Zosankha zosintha". Chotsani bokosilo pafupi ndi mtengo. "Gwiritsani ntchito oyendetsa mapulogalamu". Ndiye mu ndime "Wolekanitsa gawo lonse ndi laling'ono" m'malo "," on ".". Kuti mulowetse zigawozo, dinani pa batani. "Chabwino".

Pambuyo pa masitepewa, makasitomala omwe amagwiritsidwa ntchito ngati olekanitsa a tizigawo tingasinthidwe. Koma, chofunika kwambiri, mawu omwe amagwiritsidwa ntchito adzakhalabe manambala, ndipo sangatembenuzidwe.

Pali njira zingapo zosinthira makasitomala ku mfundo za Excel. Zambiri mwa zosankhazi zimaphatikizapo kusintha mtundu wa deta kuchokera ku manambala mpaka malemba. Izi zimapangitsa kuti pulogalamuyo isagwiritse ntchito mawuwa muziwerengero. Koma palinso njira yosinthira makasitomala, ndikusunga maonekedwe oyambirira. Kuti muchite izi, muyenera kusintha makonzedwe a pulogalamuyo.