MOMWE MUNGASINTHIRE NAMBALA KUTI MULEMBE NDI KUBWERERA KU EXCEL

Imodzi mwa ntchito zomwe anthu akugwiritsa ntchito pulogalamu ya Excel ndizokutembenuka kwa mawerengedwe a malemba ndi zosiyana. Funso limeneli nthawi zambiri limakukakamizani kuti mutenge nthawi yambiri pa chisankho ngati wogwiritsa ntchito sakudziwa bwino zochita zake. Tiyeni tiwone momwe tingathetsere mavuto onse awiri m'njira zosiyanasiyana.

Sinthani chiwerengero kuti muwone mauthenga

Maselo onse a Excel ali ndi maonekedwe omwe amauza pulogalamuyo kuyang'ana mawu. Mwachitsanzo, ngakhale ziwerengero zinalembedwa mwa iwo, koma zolembazo zimakhala zolembedwera, ntchitoyo idzawagwiritsira ntchito momveka bwino ndipo sangathe kuchita chiwerengero cha masamu ndi deta. Kuti Excel azindikire manambala mofanana ndi chiwerengero, ayenera kuti alowe mu chidutswa cha pepala ndi mawonekedwe ambiri kapena angapo.

Poyamba, ganizirani njira zosiyanasiyana zothetsera vuto la kusinthira manambala kukhala mawonekedwe a mauthenga.

Njira 1: Kupanga mawonekedwe pogwiritsa ntchito makondomu

Kawirikawiri, ogwiritsa ntchito amawongolera malemba amtunduwu m'malemba.

Sankhani zinthu zomwe zili mu pepala yomwe mukufuna kusintha deta yanu. Monga mukuonera, mu tab "Kunyumba" pa batch toolbar mu block "Nambala" Masewera apadera amawonetsera chidziwitso kuti zinthu izi ndizofanana, zomwe zikutanthauza kuti chiwerengero cholembedwa mmenemo chikuwonekera pulogalamu ngati nambala.

Dinani botani lamanja la mouse pamasankhidwe ndi pakasankhidwe masankhani kusankha malo "Sungani maselo ...".

Muwindo lokhazikitsa lomwe limatsegula, pitani ku tabu "Nambala"ngati ilo linali lotseguka kwinakwake. Mu bokosi lokhalamo "Maofomu Owerengeka" sankhani malo "Malembo". Kusunga kusintha kumani pa "Chabwino " pansi pazenera.

Monga mukuonera, mutatha kuwonongeka, mauthenga amawonetsedwa m'munda wapadera umene maselo atembenuzidwira kuwonekera.

Koma ngati tiyesera kuwerengera mtengo wa galimoto, idzawonekera mu selo ili pansipa. Izi zikutanthauza kuti kutembenuka sikudakwanira. Ichi ndi chimodzi mwa zida za Excel. Pulogalamuyo salola kuloza kutembenuka kwa deta mwa njira yabwino kwambiri.

Kuti titsirize kutembenuka, tifunika kufufukira pang'onopang'ono pa batani lamanzere kuti muikepo chithunzithunzi pa chigawo chilichonse cha zosiyana ndikusindikiza fungulo Lowani. Kuti muphweka ntchitoyo, m'malo mojambulira kawiri, mungagwiritse ntchito fungulo la ntchito. F2.

Pambuyo pokonza njirayi ndi maselo onse a derali, deta yomwe ili mkati mwake idzawonetsedwa ndi pulogalamuyi ngati malemba, ndipo motero, mtengo wa galimoto udzakhala zero. Kuonjezerapo, monga momwe mukuonera, kona kumtunda kumanzere kwa maselo adzakhala obiriwira. Izi ndizinso zowoneka bwino kuti zinthu zomwe ziwerengero zilipo zimatembenuzidwa kukhala zolemba zosiyana. Ngakhale kuti izi sizinali zoyenera komanso nthawi zina palibe chizindikiro.

Phunziro: Momwe mungasinthire mawonekedwe mu Excel

Njira 2: Zida za tepi

Mukhozanso kutembenuzira chiwerengero kuti muwone mauthenga pogwiritsa ntchito zipangizo pa tepi, makamaka, pogwiritsa ntchito munda kuti muwonetse maonekedwe omwe takambirana pamwambapa.

Sankhani zinthu, deta yomwe mukufuna kutembenuza kuti muwone malemba. Kukhala mu tab "Kunyumba" Dinani pa chithunzicho mwa mawonekedwe a katatu kupita kumanja kwa munda umene maonekedwewo akuwonetsedwa. Ipezeka mu bokosi la zida. "Nambala".

Mu mndandanda wotsegulira njira zosankha, sankhani chinthucho "Malembo".

Kuwonjezera apo, monga mwa njira yapitayi, ife timagwiritsira ntchito sequentially mulojekiti m'zinthu zonse zamtunduwu mwa kuwirikiza kawiri pa batani lamanzere kapena kusindikiza fungulo F2ndiyeno dinani Lowani.

Deta yasinthidwa kukhala malemba.

Njira 3: Gwiritsani ntchito ntchitoyi

Njira ina yosinthira deta yamtundu kuti ayese data mu Excel ndiyo kugwiritsa ntchito ntchito yapadera, yomwe imatchedwa - Malembo. Njira iyi ndi yoyenera, choyamba, ngati mukufuna kutumiza manambala monga malemba m'ndandanda yapadera. Kuwonjezera pamenepo, idzapulumutsa nthawi kutembenuka ngati kuchuluka kwa deta kukulira. Pambuyo pa zonse, zindikirani kuti kupyolera mu selo iliyonse mu mazanamazana kapena masauzande a mizere si njira yabwino yopitilira.

Ikani cholozera ku gawo loyambirira la mtundu umene zotsatira za kutembenuka ziwonetsedwe. Dinani pazithunzi "Ikani ntchito"yomwe ili pafupi ndi bar.

Foda ikuyamba Oyang'anira ntchito. M'gululi "Malembo" sankhani chinthu "TEXT". Pambuyo pake dinani pa batani "Chabwino".

Fayilo yotsutsana ndi otsogolera imatsegula Malembo. Ntchitoyi ili ndi mawu omasulira awa:
= TEXT (mtengo;
Fenje lotseguka ili ndi minda iwiri yomwe ikugwirizana ndi zifukwa zoperekedwa: "Phindu" ndi "Format".
Kumunda "Phindu" Muyenera kufotokoza nambala kuti isinthidwe kapena kutanthauzira selo yomwe ili. Kwa ife, izi zidzakhala chiyanjano ku gawo loyambirira lazinthu zamakono zomwe zikugwiritsidwa ntchito.
Kumunda "Format" Muyenera kufotokoza zomwe mungachite kuti muwonetse zotsatira. Mwachitsanzo, ngati talowa "0", malemba omwe amachokerawo adzawonetsedwa opanda malo a decimal, ngakhale atakhala mu code source. Ngati tipanga "0,0", zotsatira zidzawonetsedwa ndi malo amodzi, ngati "0,00"ndiye ndi awiri, ndi zina zotero.
Pambuyo pazigawo zonse zofunikira zalowa, dinani pa batani. "Chabwino".

Monga mukuonera, kufunika kwa gawo loyambirira la mndandanda wachindunji likuwonetsedwa mu selo yomwe tinasankha mu ndime yoyamba ya bukhuli. Kuti mutengere makhalidwe ena, muyenera kufotokozera fomuyi pambali pa pepala. Ikani cholozera kumbali ya kumanzere kwa mfundo zomwe ziri ndi ndondomekoyi. Mtolowo umatembenuzidwa kukhala chizindikiro chodzaza chomwe chikuwoneka ngati mtanda wawung'ono. Sambani batani lamanzere la mchenga ndi kukokera m'maselo opanda kanthu omwe akufanana ndi momwe deta imayambira.

Tsopano mndandanda wonsewu uli ndi deta yofunikira. Koma sizo zonse. Ndipotu, zinthu zonse zatsopanozi zili ndi mayina. Sankhani dera ili ndikudina pazithunzi. "Kopani"yomwe ili pa tabu "Kunyumba" pa batch toolbar "Zokongoletsera".

Komanso, ngati tikufuna kusunga mawiri onse (oyambirira ndi osinthidwa), sitichotsa chisankho kuchokera ku dera lomwe lili ndi mayina. Dinani pa ilo ndi batani lamanja la mouse. Mndandandanda wa zochitika zomwe zafotokozedwa. Sankhani malo mmenemo "Sakani Mwapadera". Zina mwazomwe mungachite pa mndandanda umene umatsegulidwa, sankhani "Makhalidwe ndi Mapangidwe A Nambala".
Ngati wogwiritsa ntchito akufuna kusintha deta ya mawonekedwe oyambirira, ndiye m'malo mwachitidwe choyankhidwa, muyenera kuchisankha ndikuchiyika mofanana ndi momwe ziliri pamwambapa.

Mulimonsemo, malemba adzalowetsedwa muzinthu zosankhidwa. Ngati simunasankhe malo omwe amachokera, ndiye kuti maselo okhala ndi mayendedwe akhoza kuchotsedwa. Kuti muchite izi, sankhani, dinani pomwepo ndikusankha malo "Chotsani Chokhutira".

Pazitsulo izi zikhoza kuonedwa kuti zakwaniritsidwa.

Phunziro: Wowonjezera Wogwira Ntchito

Kutembenuza malemba ku nambala

Tsopano tiyeni tiwone njira zomwe mungagwiritsire ntchito ntchito yotsutsana, momwe mungatembenuzire malemba ku nambala mu Excel.

Njira 1: Sinthani kugwiritsa ntchito chizindikiro cholakwika

Njira yosavuta komanso yofulumira ndiyo kutembenuza malembawo pogwiritsa ntchito chithunzi chapadera chomwe chimanena zolakwika. Chizindikiro ichi chili ndi mawonekedwe a chizindikiro cholembedwa mu chithunzi chopangidwa ndi diamondi. Zikuwoneka mukasankha maselo omwe ali ndi zobiriwira kumtunda wakumzere kumanzere, zomwe takambirana kale. Chizindikirocho sichikusonyeza kuti deta mu selo ndizolakwika. Koma manambala omwe ali mu selo omwe ali ndi maonekedwe akuwonekera amachititsa anthu kukayikira pulogalamu kuti deta ikhoza kulowamo molakwika. Choncho, ngati atero, amawalemba kuti wogwiritsa ntchitoyo amvetse. Koma, mwatsoka, Excel samapereka zizindikiro zotere nthawi zonse, ngakhale chiwerengero chiri mu mawonekedwe a mauthenga, kotero njira yomwe ili pansipa si yoyenera pa milandu yonse.

Sankhani selo yomwe ili ndi chizindikiro chobiriwira cha vuto lotheka. Dinani pa chithunzi chomwe chikuwonekera.

Mndandanda wa zochitika zimatsegulidwa. Sankhani mtengo mmenemo "Sinthani kuti mukhale nambala.

Mu chinthu chosankhidwa, deta idzasinthidwa kukhala mawonekedwe.

Ngati palibe njira imodzi yokha yosinthira, koma yokhazikitsidwa, ndiye kuti ndondomeko yotembenuka ikhoza kuthamanga.

Sankhani zonse zomwe malembawo akulemba. Monga mukuonera, pictogram inawonekera imodzi kudera lonse, osati pa selo lirilonse. Dinani pa izo.

Mndandanda umene tidziwa kale umatsegula. Monga nthawi yomaliza, sankhani malo "Sinthani ku nambala".

Dongosolo lonse lapansi lidzasinthidwa kuwonongosoledwe.

Njira 2: Kutembenuza pogwiritsa ntchito mawindo okonza

Kuwonjezera pa kusinthira deta kuchokera ku numeric numeric to text, mu Excel pali kuthekera kwa kubwereranso kudzera pawindo lopangidwira.

Sankhani mtundu umene uli ndi manambala mu malembawo. Dinani botani lamanja la mouse. Mu menyu yachidule, sankhani malo "Sungani maselo ...".

Imayendetsa mawindo apangidwe. Monga mmbuyomu, pitani ku tabu "Nambala". Mu gulu "Maofomu Owerengeka" Tiyenera kusankha miyezo yomwe idzasinthira malemba kukhala nambala. Izi zikuphatikizapo zinthu "General" ndi "Numeric". Mulimonse momwe mungasankhe, pulogalamuyo idzawona nambalayi inalowa mu selo ngati nambala. Sankhani ndikusankha pa batani. Ngati musankha mtengo "Numeric"ndiye kumbali yeniyeni ya zenera kudzathekanso kusintha chiwerengero cha nambala: ikani chiwerengero cha malo apamwamba pambuyo pa mfundo ya decimal, ikani okonza pakati pa ziwerengerozo. Mukatha kukonza, dinani pa batani. "Chabwino".

Tsopano, monga momwe zingasinthire chiwerengero, tifunika kudumpha kupyolera mu maselo onse, ndikuyika mtolowo m'kati mwawo ndikukakamiza Lowani.

Pambuyo pochita zinthu izi, mfundo zonse zasankhidwa zimasinthidwa ku fomu yoyenera.

Njira 3: Kutembenuza pogwiritsira ntchito zipangizo za tepi

Mukhoza kusintha deta yanu ku data yanu pogwiritsa ntchito malo apadera pa chida.

Sankhani mtundu umene uyenera kusinthidwa. Pitani ku tabu "Kunyumba" pa tepi. Dinani kumunda ndi kusankha mtundu mu gulu "Nambala". Sankhani chinthu "Numeric" kapena "General".

Kenaka ife timadutsa mumaselo onse a dera losinthidwa pogwiritsa ntchito mafungulo F2 ndi Lowani.

Makhalidwe osiyana adzatembenuzidwa kuchoka ku malemba kupita ku nambala.

Njira 4: kugwiritsa ntchito njirayi

Mungagwiritsenso ntchito machitidwe apadera kuti mutembenuzire malemba amtengo wapatali kuzinthu zamtengo wapatali. Lingalirani momwe mungachitire izi mchitidwe.

Mu selo yopanda kanthu, yomwe ili pafupi ndi gawo loyambirira la zofunikira zomwe ziyenera kusinthidwa, ikani chizindikiro "chofanana" (=) ndi kupitirira kawiri (-). Kenaka, tchulani adiresi ya gawo loyamba la zosinthika. Motero, kuchulukitsa kawiri ndi mtengo kumachitika. "-1". Monga mukudziwira, kuwonjezeka kwa "kuchepetsa" ndi "kuchepetsa" kumapereka "kuphatikiza". Izi zikutanthauza kuti, mu selo lolunjika, timapeza mtengo womwewo poyamba, koma mwa mawonekedwe. Ndondomekoyi imatchedwa kuti binary negation.

Timakanikiza pa fungulo Lowanipambuyo pake timapeza mtengo wotembenuzidwa wotsirizidwa. Pofuna kugwiritsa ntchito fomu iyi kwa maselo ena onse, timagwiritsa ntchito chikhomo chodzaza, chimene tinkachigwiritsa ntchito kale Malembo.

Tsopano tili ndi mitundu yodzaza ndi machitidwe ndi mayendedwe. Sankhani ndipo dinani pa batani. "Kopani" mu tab "Kunyumba" kapena mugwiritse ntchito njirayo Ctrl + C.

Sankhani malo omwe amachokera ndikusindikiza ndi batani lakumanja. Mu mndandanda wazomwe mwalembazo mupite ku mfundozo "Sakani Mwapadera" ndi "Makhalidwe ndi Mapangidwe A Nambala".

Deta yonse imayikidwa mu mawonekedwe omwe timafunikira. Tsopano mungathe kuchotsa njira yopititsira patsogolo njira yomwe imakhala yovuta kwambiri. Kuti muchite izi, sankhani dera lino, dinani ndondomeko yowonjezera mndandanda ndikusankha malo mmenemo. "Chotsani Chokhutira".

Mwa njira, kuti mutembenuzire zikhulupiliro mwa njira iyi, sikufunika kugwiritsa ntchito kuchulukitsa kawiri kokha ndi "-1". Mukhoza kugwiritsira ntchito masamu ena omwe samatsogolere kusintha (kuwonjezera kapena kuchotsa zero, kumangidwe kwa digiri yoyamba, ndi zina zotero)

Phunziro: Momwe mungapangire autocomplete mu Excel

Njira 5: Kugwiritsira ntchito padera.

Njira yotsatirayi ikufanana kwambiri ndi yoyambayo ndi kusiyana kokha kokha kuti sikufunikira kupanga gawo lina kuti ligwiritse ntchito.

Lowani chiwerengero mu selo iliyonse yopanda kanthu pa pepala "1". Kenaka sankhani ndipo dinani pachithunzi chodziwika bwino. "Kopani" pa tepi.

Sankhani malo pa pepala yomwe mukufuna kutembenuza. Dinani pa ilo ndi batani lamanja la mouse. Mu menyu yomwe imatsegulidwa, dinani kawiri pa chinthucho "Sakani Mwapadera".

Muwindo lapadera loyikira, yikani chosinthira "Ntchito" mu malo "Pitirizani". Pambuyo pa izi, dinani pa batani "Chabwino".

Pambuyo pachithunzi ichi, zikhalidwe zonse za dera losankhidwa zidzasinthidwa kukhala nambala. Tsopano, ngati mukufuna, mukhoza kuchotsa nambalayi "1"zomwe tagwiritsira ntchito kutembenuka.

Njira 6: Gwiritsani ntchito Chida Chamalemba

Njira ina yosinthira malemba mu mawonekedwe ndi kugwiritsa ntchito chida. "Ma Columns Text". Ndizomveka kuigwiritsa ntchito mmalo mwa kadontho kakang'ono kamene kamagwiritsidwa ntchito monga cholekanitsa chakumapeto, ndipo apostrophe imagwiritsidwa ntchito ngati kulekanitsa kwa chiwerengero m'malo mwa malo. Zosinthazi zikupezeka mu Excel ya chinenero cha Chingerezi monga nambala, koma muchinenero cha Chirasha cha pulogalamuyi zikhulupiliro zonse zomwe zili ndi zilembo zapamwambazi zikuwoneka ngati zolemba. Inde, mungathe kusokoneza deta pamanja, koma ngati pali zambiri, zimatenga nthawi yochuluka, makamaka popeza pali kuthekera kwa njira yothetsera vutoli mofulumira.

Sankhani chidutswa cha pepala, zomwe mukufuna kusintha. Pitani ku tabu "Deta". Pa zida zamatepi mu block "Kugwira ntchito ndi deta" dinani pazithunzi "Malemba ndi zipilala".

Iyamba Wopanga Mauthenga. Muwindo loyambirira, zindikirani kuti kusinthana kwa deta kwadasankhidwa "Zopanda malire". Mwachikhazikitso, ziyenera kukhala pa malo awa, koma sikungakhale zodabwitsa kuyang'ana mkhalidwe. Kenaka dinani pa batani. "Kenako".

Muwindo lachiwiri timachokanso chirichonse chosasintha ndipo dinani batani. "Kenako."

Koma mutatsegula zenera lachitatu Osegula Mauthenga muyenera kusindikiza batani "Zambiri".

Zowonjezera zowonjezera zolemba zolowera zikutsegula. Kumunda "Wolekanitsa gawo lonse ndi laling'ono" ikani mfundo, ndi kumunda "Wopatula" - apostrophe. Ndiye dinani chimodzi pa batani. "Chabwino".

Bwerera kuwindo lachitatu Osegula Mauthenga ndipo dinani pa batani "Wachita".

Monga momwe mukuonera, atatha kuchita izi, nambalayi inkaganiza kuti inali yozoloŵera kwa vesi lachirasha, zomwe zikutanthauza kuti nthawi yomweyo zinatembenuzidwa kuchoka ku deta yanu ku data.

Njira 7: Kugwiritsa Macros

Ngati nthawi zambiri mumasintha mbali zazikulu za deta kuchokera ku malemba kupita kuzinthu zowerengeka, ndizomveka kuti cholinga ichi chilembereni zazikulu zomwe zingagwiritsidwe ntchito ngati kuli kofunikira. Koma kuti muchite izi, choyamba, muyenera kuyika macros ndi gulu lokonzekera mu Excel, ngati izi zisanachitike.

Pitani ku tabu "Wotsambitsa". Dinani pa chithunzi pa tepi "Visual Basic"zomwe zimagwidwa mu gulu "Code".

Imathamanga mlangizi wamkulu wa macro. Timayendetsa kapena kukopera mawu awa mmenemo:
Sub Text_in () Selection.NumberFormat = "General" Kusankha.Value = Kusankhidwa.Value Malizani pang'ono
Pambuyo pake, tcherani mkonzi podutsa makina omaliza omwe ali pafupi kumapeto kwawindo.

Sankhani chidutswa pa pepala chomwe chiyenera kutembenuzidwa. Dinani pazithunzi Macrosyomwe ili pa tabu "Wotsambitsa" mu gulu "Code".

Mawindo a macros olembedwa muwongolera pulogalamuyi akuyamba. Pezani zambiri ndi dzina "Malembo"sankhani ndipo dinani pa batani Thamangani.

Monga momwe mukuonera, nthawi yomweyo amasintha mawu olembedwera mu chiwerengero cha chiwerengero.

Phunziro: Momwe mungapangire macro ku Excel

Monga mukuonera, pali njira zingapo zoti mutembenuzire ziwerengero ku Excel, zomwe zalembedwa mu mawerengedwe a manambala, m'mawonekedwe a malemba ndi mosiyana. Kusankha njira inayake kumadalira zinthu zambiri. Choyamba, ichi ndi ntchito. Pambuyo pa zonse, mwachitsanzo, kuti mutembenuze mwatsatanetsatane mawu a malemba ndi olengeza kunja ku chiwerengero chokha chingathe kugwiritsa ntchito chida "Ma Columns Text". Chinthu chachiwiri chomwe chimakhudza kusankha kosankha ndikuthamanga kwafupipafupi. Mwachitsanzo, ngati nthawi zambiri mumagwiritsa ntchito kusintha koteroko, n'zomveka kulemba macro. Ndipo chinthu chachitatu ndizokhazikika mwa munthu aliyense.