Sinthani manambala kukhala mameseji ndi mosemphanitsa mu Microsoft Excel

Chimodzi mwazinthu zodziwika zomwe ogwiritsira ntchito pulogalamu ya Excel ndi kutembenuza kwa manambala kukhala mtundu wamawu ndi mosemphanitsa. Funsoli nthawi zambiri limakupatsani nthawi yayitali panjira yothetsera vutoli ngati wogwiritsa ntchito sakudziwa bwino za zochita. Tiyeni tiwone momwe mungathetse mavuto onse m'njira zosiyanasiyana.

Kutembenuza nambala yamakalata

Maselo onse mu Excel ali ndi mtundu winawake, womwe umakhazikitsa pulogalamuyi momwe angaonere mawu amodzi. Mwachitsanzo, ngakhale manambala atalembedwa m'mawuwo, koma mawonekedwe ake amalembedwa, pulogalamuyo amawayang'ana ngati mawu osavuta ndipo sangathe kuwerengetsa masamu ndi deta yotere. Kuti Excel iwone manambala chimodzimodzi ndi manambala, iyenera kuyikidwa mu pepala lokhala ndi mawonekedwe wamba kapena manambala.

Kuti muyambe, lingalirani zosankha zingapo zothana ndi vuto la kusintha manambala kukhala mawu.

Njira 1: kukonzanso kudzera pazosankha

Nthawi zambiri, ogwiritsa ntchito amapanga mitundu ya zilembo kuti azigwiritsa ntchito polemba nkhani.

1. Sankhani zinthu zomwe zili mu pepalalo momwe mukufuna kuti muthe kusintha mawu kuti akhale mawu. Monga mukuwonera, tabu "Pofikira" pa chida chomwe chili mu block "Chiwerengero" mu gawo lapadera likuwonetsa zidziwitso kuti zinthuzi zimakhala ndi mtundu wofanana, zomwe zikutanthauza kuti manambala omwe adalowetsedwa amadziwika ndi pulogalamuyo ngati nambala.



2. Dinani kumanja pazomwe mukusankhazo ndikusankha mawonekedwe mumenyu omwe akutsegulira "Mtundu wamtundu ...".



3. Pazenera lopakika lomwe limatseguka, pitani tabu "Chiwerengero"ngati idatsegulidwa kwina. Mu makatani "Mawerengero Amanambala" sankhani "Zolemba". Kuti musunge zosintha dinani batani "Zabwino " pansi pazenera.



4. Monga mukuwonera, izi zitatha kuwonetsedwa mundawo yapadera kuwonetsa zambiri zomwe maselo adasinthidwa kukhala mawonekedwe amawu.



5. Koma ngati tiyesa kuwerengera kuchuluka kwa auto, ndiye kuti ziwonetsedwa mu foni pansipa. Izi zikutanthauza kuti kutembenuka sikunakhale kwathunthu. Ichi ndi chimodzi mwamawonekedwe a Excel. Pulogalamuyi siyilola kuti amalize kutembenuza kwa njira mwanjira yabwino kwambiri.



6. Kuti amalize kutembenuka, tiyenera kumadina kawiri dinani batani lakumanzere kuti muike chidziwitso paliponse la mitunduyo pawokha ndikudina batani Lowani. M'malo mongodina kawiri, mutha kugwiritsa ntchito kiyi kuti ntchitoyo ikhale yosavuta. F2.



7. Mukatha kuchita njirayi ndi maselo onse amchigawocho, zomwe zimatsimikizidwa mu pulogalamuyi zizindikiridwa ndi pulogalamuyo, chifukwa chake, chiwonetsero chazomwecho chidzakhala chofanana ndi zero. Kuphatikiza apo, monga mukuwonera, ngodya yakumanzere kwa maselo idzakhala yobiriwira. Ichi ndichizindikiro chosadziwika kuti zinthu zomwe manambala amapezeka zimasinthidwa kukhala mtundu wazowonetsera. Ngakhale chizindikiro ichi sichofunikira nthawi zonse, ndipo nthawi zina, chizindikirocho chimasowa.

Phunziro: Momwe mungasinthire mawonekedwe mu Excel

Njira 2: zida za tepi

Mutha kusinthanso manambala kukhala lingaliro logwiritsa ntchito zida zomwe zikujambulidwa pa tepi, makamaka, pogwiritsa ntchito mundawo kuti muwonetse mawonekedwe omwe takambirana pamwambapa.

1. Sankhani zomwe mwasankha zomwe mukufuna kuti musinthe ndikuwona. Kukhala mu tabu "Pofikira" timadina pachizindikiro mu mawonekedwe amakona atatu kumanja kumunda momwe mawonekedwewo akuwonetsera. Ili mu chipangizo. "Chiwerengero".



2. Pamndandanda wamitundu yomwe imatsegulidwa, sankhani "Zolemba".



3. Chotsatira, monga momwe munachitira kale, ikani chikhazikitso pachinthu chilichonse mwa kudina kawiri batani la mbewa kapena ndikanikiza F2kenako dinani batani Lowani.

Zomwe zimasinthidwa zimasinthidwa kukhala zolemba.

Njira 3: gwiritsani ntchito ntchito

Njira ina yosinthira kuchuluka kwa manambala kuti ayese deta ku Excel ndikugwiritsa ntchito ntchito yapadera, yomwe imatchedwa - MUTU. Njira iyi ndi yoyenera, choyambirira, ngati mukufuna kusamutsa manambala ngati malembedwe pagawo lina. Kuphatikiza apo, ipulumutsa nthawi pakusintha ngati kuchuluka kwa deta kuli kwakukulu. Zachidziwikire, kuvomereza kuti kulumpha khungu lirilonse mumizere ya mizere mazana kapena masauzande si njira yabwino yopumira.

1. Timayika cholozera mu gawo loyamba la magawo momwe zotsatira zosinthira ziwonetsedwere. Dinani pachizindikiro "Ikani ntchito"yomwe imayikidwa pafupi ndi mzere wa fomula.



2. Tsamba limayamba Ogwira Ntchito. Gulu "Zolemba" sankhani MUTU. Pambuyo pake, dinani batani "Zabwino".



3. Window Yogwiritsa Ntchito Itsegulidwa MUTU. Ntchitoyi ili ndi syntax yotsatirayi:

   = TEXT (mtengo; mtundu)

   Windo lomwe limatsegulira lili ndi magawo awiri omwe amagwirizana ndi izi: "Mtengo" ndi "Fomu".

   M'munda "Mtengo" muyenera kutchula nambala yosinthidwa kapena ulalo wa khungu lomwe yalipezekamo. M'malo mwathu, izi zikugwirizana ndi gawo loyamba la chiwerengero chomwe chikukonzedwa.

   M'munda "Fomu" muyenera kutchula njira kuti muwonetse zotsatira. Mwachitsanzo, ngati timayambitsa "0", ndiye kuti zolemba zomwe zatulutsidwa ziziwonetsedwa popanda ziwonetsero, ngakhale zitakhala kuti zidachokera. Ngati tiika "0,0", zotsatira zake zidzawonetsedwa ndi malo amodzi, ngati "0,00"ndiye ndi awiri, etc.

   Pambuyo magawo onse ofunikira atayikidwa, dinani batani "Zabwino".



4. Monga mukuwonera, phindu la gawo loyamba la mtundu wopatsidwa likuwonetsedwa mu khungu lomwe tidawunikira m'ndime yoyamba ya buku lino. Pofuna kusamutsa mfundo zina, muyenera kukopera chilinganizo pazinthu zapafupi ndi pepalalo. Ikani cholozera mu ngodya ya kumunsi kwa chinthu chomwe chili ndi formula. Chopata chimasinthidwa kukhala cholembera chodzaza chomwe chimawoneka ngati mtanda wawung'ono. Gwirani batani lamanzere lakumanzere ndikukokera kudzera m'maselo opanda kanthu ofanana ndi mtundu womwe ukupezeka deta.



5. Tsopano mzere wonse umadzazidwa ndi chofunikira chofunikira. Koma si zokhazo. M'malo mwake, zinthu zonse zamitundu yatsopano zimakhala ndi njira. Sankhani malowa ndikudina chizindikiro. Copyyomwe ili pa tabu "Pofikira" pa bandi zida Clipboard.



6. Kupitilira apo, ngati tikufuna kusunga magawo onse (gwero ndi kusinthidwa), sitichotsa kusankhidwa m'derali komwe kuli njira. Timadulira pomwepo ndi batani la mbewa. Mndandanda wazomwe zikuchitika akuyamba. Sankhani malo mmenemu "Lowetsani mwapadera". Mwa zosankha zomwe zili pamndandanda zomwe zimatseguka, sankhani "Zotsatira zamawonekedwe ndi manambala".

   

   Ngati wogwiritsa ntchito akufuna kusintha dilesi momwe idasanjidwa, ndiye kuti m'malo motengera zomwe mwachita, muyenera kuyisankha ndikuyiyika monga momwe tafotokozera pamwambapa.



7. Mulimonsemo, malembawo adzaikidwa mumtundu wosankhidwa. Ngati mwasankha kuyika gwero la magawo, ndiye kuti maselo omwe ali ndi mafomulowa amatha kutha. Kuti muchite izi, sankhani, dinani kumanja ndikusankha mawonekedwe Chotsani Zolemba.

Pamenepa, njira yotembenuzira imatha kuonedwa kuti ndi yathunthu.

Phunziro: Ntchito Wizard ku Excel

Sinthani mawu kuti akhale nambala

Tsopano tiwone momwe mungagwiritsire ntchito yolakwika, yomwe mungasinthe mawu kuti akhale manambala mu Excel.

Njira 1: Sinthani Kugwiritsa Ntchito Chizindikiro

Njira yosavuta komanso yachangu kwambiri ndikusinthira mtundu wamawu pogwiritsa ntchito chithunzi chapadera chomwe chimanena zolakwika. Chithunzichi chikuwoneka ngati chizindikiro chodzikongoletsera cholembedwa mu chithunzi cha rhombus. Zikuwoneka pamene maselo omwe adalembedwa pakona yakumanzere mu wobiriwira amawatsimikizira, omwe tidakambirana kale. Chizindikirochi sichikuwonetsa kuti zambiri zomwe zili muchipangacho ndizolakwika. Koma manambala omwe amapezeka mu foni yokhala ndi mawonekedwe amawoneka kuti amachititsa pulogalamuyo kukayikira kuti mwina zitha kuikidwa molakwika. Chifukwa chake, ngati angatero, amawayika mayina kuti wogwiritsa ntchito awoneke. Koma, mwatsoka, Excel samangopereka zolemba zotere ngakhale manambala atalembedwa, choncho njira yofotokozedwayo siyoyenera milandu yonse.

1. Sankhani khungu lomwe lili ndi chisonyezo chobiriwira cholakwika. Dinani pa chithunzi chomwe chikuwoneka.



2. Mndandanda wa zochita umatseguka. Sankhani mtengo "Sinthani nambala ".



3. Mu chinthu chomwe mwasankha, data imasinthidwa pomwepo kukhala nambala ya manambala.

Ngati palibe imodzi, koma yambiri, yamalemba ofanana omwe atembenuzidwe, ndiye kuti njira iyi yotembenuka imathamanga.

1. Sankhani mtundu wonsewo momwe zomwe zalembedwera zalembedwera. Monga mukuwonera, chithunzicho chinawonekera amalo onse, osati gulu lililonse payokha. Timadulira.



2. Mndandanda womwe watidziwitsa kale umayamba. Monga nthawi yotsiriza, sankhani malo Sinthani Nambala.

Zambiri zosanjidwa zidzasinthidwa ndikuwona.

Njira 2: Sinthani pogwiritsa ntchito mawonekedwe

Ponena za kusintha data kuchokera pakuwona kwamasamba ndikulemba, ku Excel ndikotheka kutembenuza kutembenuka kudzera pazenera.

1. Sankhani mitundu yomwe ili ndi manambala muzolemba. Dinani kumanja. Pazosankha, muyenera kusankha malo "Mtundu wamtundu ...".



2. Tsamba losintha likuyamba. Monga nthawi yapita, pitani ku tabu "Chiwerengero". Mu gululi "Mawerengero Amanambala" tifunika kusankha mfundo zomwe zingasinthe mawuwo kukhala nambala. Izi zikuphatikizapo zinthu "General" ndi "Numeric". Aliyense mwa iwo omwe mungasankhe, pulogalamuyo imayang'ana manambala omwe adalowa mu cell ngati manambala. Pangani kusankha ndikudina batani. Ngati mwasankha "Numeric", ndiye mu gawo loyenera la zenera kuthekera kusintha mawonekedwe owerengera: khazikitsani kuchuluka kwa malo omaliza pambuyo pamawu omaliza, ikani olekanitsidwa pakati pa manambala. Pambuyo khwekhwe litatha, dinani batani "Zabwino".



3. Tsopano, monga momwe angasinthire manambala kukhala mameseji, tifunika kudina maselo onse poika chidziwitso mu lirilonse la iwo ndikudina kiyi pambuyo pake Lowani.

Pambuyo pochita izi, malingaliro onse amtundu wosankhidwa amasinthidwa ku mawonekedwe omwe tikufuna.

Njira 3: Sinthani Pogwiritsa Ntchito Zida za Matepi

Mutha kusintha zidziwitso kukhala nambala pogwiritsa ntchito gawo lapadera pa riboni ya chida.

1. Sankhani mtundu womwe ungasinthe. Pitani ku tabu "Pofikira" pa tepi. Timadulira pamunda ndikusankha mawonekedwe mu gulu "Chiwerengero". Sankhani chinthu "Numeric" kapena "General".



2. Kenako, dinani khungu la malo osinthidwa pogwiritsa ntchito makiyi koposa kamodzi monga momwe tafotokozera F2 ndi Lowani.

Ma values ​​pamudindo azisinthidwa kuchokera palemba kupita nambala.

Njira 4: kugwiritsa ntchito kachitidwe

Muthanso kugwiritsa ntchito njira zapadera zotembenuzira manambala kukhala manambala. Ganizirani momwe mungachitire izi pochita.

1. Mu khungu lopanda kanthu lomwe likufanana ndi gawo loyambirira la masinthidwewo, ikani chizindikiro chofanana (=) ndikusiyirani chizindikiro chachiwiri (-). Kenako, tchulani adilesi ya chinthu choyambirira chosinthika. Chifukwa chake, kuchulukitsa kawiri ndi phindu "-1". Monga mukudziwa, kuchulukitsa minus kumathandizanso. Ndiye kuti, mu cell yomwe tikutsata timapeza mtengo womwewo womwe poyamba, koma uli kale manambala. Njirayi imatchedwa kawiri binary negation.



2. Dinani pa kiyi Lowani, pambuyo pake timapeza mtengo wosinthika wosinthidwa. Pofuna kugwiritsa ntchito fomuloli m'maselo ena onse m'magawo, timagwiritsa ntchito chikhomo chomwe takhala tikugwiritsa ntchito MUTU.



3. Tsopano tili ndi mndandanda womwe umadzazidwa ndi malingaliro ndi mitundu. Sankhani ndikudina batani. Copy pa tabu "Pofikira" kapena gwiritsani ntchito njira yachidule Ctrl + C.



4. Sankhani malo osungirako ndikudina ndi batani la mbewa yoyenera. Pazomwe zili mndondomeko yoyendetsedwa, pitani pazinthuzo "Lowetsani mwapadera" ndi "Zotsatira zamawonekedwe ndi manambala".



5. Zambiri zimayikidwa mu mawonekedwe omwe timafunikira. Tsopano mutha kuchotsa mayendedwe omwe amapezeka momwe mungagwiritsire ntchito njira zosakanizira zamabizinesi. Kuti muchite izi, sankhani malowa, dinani kumanja pazosankha ndikuzisankhako. Chotsani Zolemba.

Mwa njira, sikofunikira kugwiritsa ntchito kokha kuchulukitsa kawiri "-1". Mutha kuyesa kugwiritsa ntchito masamu ena onse omwe sikupangitsa kuti mfundo zisinthe (kuwonjezera kapena kuchotsa ziro, kuphatikiza kukweza mphamvu yoyamba, ndi zina zambiri.)

Phunziro: Momwe mungachite mosamalitsa mu Excel

Njira 5: gwiritsani ntchito malowedwe apadera

Njira yotsatira ndi yofanana kwambiri ndi yapita ndi mfundo ya momwe mungagwiritsire ntchito, kusiyanitsa kokhako ndikuti simukufunika kupangira mzere wina kuti mugwiritse ntchito.

1. Pazipinda zilizonse zopanda kanthu patsamba, lowetsani manambala "1". Kenako sankhani ndikudina chizindikiro chomwe mukuzidziwa Copy pa tepi.



2. Sankhani malo omwe alembedwa kuti asinthidwe. Timadulira pomwepo ndi batani la mbewa. Pazosankha zomwe zimatsegulira, dinani kawiri pazinthuzo "Lowetsani mwapadera".



3. Pazenera lofunikira, ikani chotsekeracho "Ntchito" m'malo Kuchulukitsa. Kutsatira izi, dinani batani "Zabwino".



4. Pambuyo pa izi, malingaliro onse amalo osankhidwa adzasinthidwa kukhala manambala. Tsopano, ngati mukufuna, mutha kufufuta "1"zomwe tidazigwiritsa ntchito potembenuza.

Njira 6: gwiritsani ntchito chida cha Text Columns

Njira ina yomwe mungasinthe malembedwe kukhala manambala ndikugwiritsa ntchito chida Zolemba Zakale. Ndizomveka kuzigwiritsa ntchito dontho ikamagwiritsidwa ntchito ngati chosokoneza, ndipo chinyengo chimagwiritsidwa ntchito ngati cholekanitsa manambala m'malo mwa malo. Kusankha uku kumadziwika mu English Excel ngati manambala, koma mu mtundu wa Chirussia pulogalamuyi, zonse zomwe zimakhala ndi zilembo pamwambapa zimadziwika ngati zolemba. Zachidziwikire, mutha kupha ma data pamanja, koma ngati alipo ambiri, zimatenga nthawi yochulukirapo, makamaka popeza kuti pali njira yothetsera vutoli mwachangu.

1. Sankhani chidutswa cha pepalalo chomwe mukufuna kusintha. Pitani ku tabu "Zambiri". Pa chida cha block "Gwirani ntchito ndi deta" dinani pachizindikiro Zolemba Zakale.



2. Iyamba Wizard walemba. Pawindo loyamba, onetsetsani kuti kusintha kwa mtundu wa data kuli pomwepo Olekanitsidwa. Mwachisawawa, ziyenera kukhala pamalopo, koma kuyang'ana momwe zilili sizikhala zolakwika. Kenako dinani batani "Kenako".



3. Pa zenera lachiwiri, timasiyanso chilichonse chosasinthika ndikudina batani "Kenako."



4. Koma atatsegula zenera lachitatu Ambuye alemba muyenera kukanikiza batani "Zambiri".



5. Zenera lowonjezera la kulowetsamo zolemba limatsegulidwa. M'munda "Osiyanitsa kwathunthu ndi magawo awiri" khazikitsani mfundo, komanso m'munda "Osiyanasiyana a magulu" - mneneri. Kenako dinani batani limodzi "Zabwino".



6. Tikubwerera pazenera lachitatu Ambuye alemba ndipo dinani batani Zachitika.



7. Monga mukuwonera, atatha kuchita izi, manambalawo adatengera mtundu womwe udalipo m'chinenedwe cha Chirasha, zomwe zikutanthauza kuti adatembenuzidwa nthawi imodzi kuchokera pazomwe zidasinthidwa kukhala ziwerengero.

Njira 7: gwiritsani ntchito macros

Ngati nthawi zambiri mumasinthira madera akulu kuchokera pamitundu kupita pa nambala, ndiye zomveka kulemba zazikulu mwanjira imeneyi, zomwe zidzagwiritsidwe ntchito ngati pakufunika.Koma kuti mukwaniritse izi, choyambirira, muyenera kuphatikiza ma macro ndi gulu la otukula mu mtundu wanu wa Excel, ngati izi sizinachitike.

1. Pitani ku tabu "Wopanga". Dinani pazithunzi cha riboni "Zowoneka Zachikulu"lomwe limayikidwa mgulu "Code".



2. Kuwongolera kwakukulu kwa macro kumayamba. Timayendetsa kapena kukopera mawu otsatirawa:

   
Lembalemba_to_Number ()
Selection.NumberFormat = "Zambiri"
Kusankha.Value = Selection.Value
Mapeto sub

   Pambuyo pake, tsekani mkonzi posintha batani loyandikira pakona yakumanja ya zenera.



3. Sankhani chidutswa patsamba lomwe mukufuna kuti musinthe. Dinani pachizindikiro Macrosyomwe ili pa tabu "Wopanga" pagululi "Code".



4. Windo la macros lojambulidwa patsamba lanu la pulogalamuyo limatsegulidwa. Tapeza zazikulu ndi dzina Malembo_, sankhani ndikudina batani Thamanga.



5. Monga mukuwonera, mawonekedwe a mawu amasinthidwa kukhala mtundu wamitundu.

Phunziro: Momwe mungapangire zazikulu mu Excel

Monga mukuwonera, pali njira zingapo zosinthira manambala kukhala Excel, omwe amalembedwa mu mtundu wa manambala, mawonekedwe amawu ndi mbali ina. Kusankhidwa kwa njira inayake kumadalira zinthu zambiri. Choyamba, iyi ndi ntchito. Zachidziwikire, mwachitsanzo, mutha kusintha mawu ndi makina akunja kukhala akunambala pokhapokha mutagwiritsa ntchito chida Zolemba Zakale. Chinthu chachiwiri chomwe chimakhudza kusankha kwa chisankho ndi kuchuluka komanso kuchuluka kwa zisinthidwe. Mwachitsanzo, ngati nthawi zambiri mumagwiritsa ntchito masinthidwe otere, ndizomveka kujambula zazikulu. Ndipo chinthu chachitatu ndichoti aliyense azigwiritsa ntchito.