Pezani DirectX mu Windows 10

Ogwiritsa ntchito ambiri a Excel akuyang'anizana ndi funso la kusintha nthawi ndi makasitomala. Izi kawirikawiri zimakhala chifukwa chakuti m'mayiko olankhula Chingerezi ndizozoloŵera kusiyanitsa magawo khumi kuchokera ku nambala ndi dontho, ndipo tili ndi chida. Choipitsitsa kwambiri, nambalayi ndi dontho silikudziwika mu zilankhulo za Chirasha za Excel monga mawerengedwe a manambala. Choncho, njirayi yotsatiridwa ndi yofunika kwambiri. Tiyeni tione momwe tingasinthire mfundo za makasitomala ku Microsoft Excel m'njira zosiyanasiyana.

Njira zosinthira mfundoyi

Pali njira zingapo zotsimikiziranso zosinthira mfundo ku pulogalamu ya Excel. Zina mwazo zathetsedweratu mothandizidwa ndi momwe ntchitoyi imagwirira ntchito, ndipo kugwiritsa ntchito ena kumafuna kugwiritsa ntchito mapulogalamu a chipani chachitatu.

Njira 1: Pezani ndi Kusintha Chida

Njira yosavuta yokonzera madontho ndi makasitomala ndiyo kugwiritsa ntchito mwayi woperekedwa ndi chida. "Pezani ndi kusintha". Koma, ndipo pamodzi ndi iye muyenera kukhala mosamala. Ndipotu, ngati kugwiritsidwa ntchito molakwika, mfundo zonse pa pepala zidzasinthidwa, ngakhale m'malo omwe akufunikiradi, mwachitsanzo, m'masiku. Choncho, njirayi iyenera kugwiritsidwa ntchito mosamala.

  1. Kukhala mu tab "Kunyumba"mu gulu la zida Kusintha pa tepicho dinani batani "Pezani ndi kuonetsa". Mu menyu imene ikuwonekera, dinani pa chinthucho "Bwezerani".

  2. Window ikutsegula "Pezani ndi kusintha". Kumunda "Pezani" onjezani chizindikiro chadothi (.). Kumunda "Bwezerani" - chizindikiro cha comma (,). Dinani pa batani "Zosankha".

  3. Tsegulani kufufuza kwina ndikusintha machitidwe. Mosiyana ndi gawo "Bwezerani ndi ..." dinani pa batani "Format".

  4. Mawindo amatsegulira momwe tingathe kukhazikitsa kamangidwe ka selo kuti lisinthe, zirizonse zomwe zingakhalepo kale. Kwa ife, chinthu chachikulu ndikuyika mawonekedwe a deta. Mu tab "Nambala" pakati pa mapangidwe a mawonekedwe apamwamba kusankha chinthu "Numeric". Timakanikiza batani "Chabwino".

  5. Titabwerera kuwindo "Pezani ndi kusintha", sankhani maselo ambirimbiri pa pepala, kumene mukufunika kuti mutenge malo omwe mwasintha ndi chida. Izi ndizofunika kwambiri, chifukwa ngati simusankha mtundu, ndiye kuti m'malo mwake mudzawongolera malo omwe simukufunikira nthawi zonse. Kenako, dinani pa batani "Bwezerani Zonse".

Monga mukuonera, malowa adapambana.

PHUNZIRO: ZINTHU ZOTHANDIZA ZOKHUDZA IFEYO

Njira 2: Gwiritsani ntchito SUB ntchito

Njira ina yosinthira mfundoyi ndi ndondomeko ndiyo kugwiritsa ntchito ntchito FIT. Komabe, pogwiritsira ntchito ntchitoyi, malowa sapezeka mumaselo amwambo, koma amawonetsedwa muzomwe zilipo.

  1. Sankhani selo yomwe idzakhala yoyamba m'ndandanda yosonyeza deta yosinthidwa. Dinani pa batani "Ikani ntchito"yomwe ili kumanzere kwa malo a chingwe cha ntchito.

  2. Kuyamba Ntchito za Master. Mndandanda womwe umapezeka pawindo lotseguka, tikuyang'ana ntchito TIZANI. Sankhani ndipo dinani pa batani. "Chabwino".

  3. Ntchito yotsutsana zenera ikusegulidwa. Kumunda "Malembo" Muyenera kulowetsa makonzedwe a selo yoyamba ya ndime yomwe muli nambala yomwe ili ndi madontho. Izi zingatheke mosavuta posankha selo ili pa pepala ndi mbewa. Kumunda "Star_text" lembani mfundo (.). Kumunda "Zatsopano_zolemba" ikani comma (,). Munda "Nambala Yoyenera" palibe chifukwa chodzaza. Ntchito yokha idzakhala ndi chitsanzo chotsatira: "= SUB (selo yadilesi;". ";", ",") "". Timakanikiza batani "Chabwino".

  4. Monga momwe mukuonera, mu selo yatsopano, nambalayo ili ndi chiwerengero m'malo mwa mfundo. Tsopano tifunika kuchita zofanana ndi maselo ena onse omwe ali m'ndandanda. Inde, simukusowa kulowa ntchito kwa nambala iliyonse; pali njira yowonjezera yowonjezera kutembenuka. Timakhala pansi pamunsi pansi pa selo yomwe ili ndi deta yosinthidwa. Chizindikiro chodzaza chikuwonekera. Pogwiritsa ntchito batani lamanzere, yesani pansi mpaka kumunsi kwa dera lomwe liri ndi deta yoti mutembenuzidwe.

  5. Tsopano tifunika kugawa maselo nambala yowerengeka. Sankhani mbali yonse ya deta yosinthidwa. Pa tabu laboni "Kunyumba" Ndikuyang'ana chida cha zipangizo "Nambala". Mndandanda wotsika pansi, timasintha mtunduwu kuti ukhale wowerengeka.

Izi zimatsiriza kutembenuka kwa deta.

Njira 3: Gwiritsani ntchito Macro

Mukhozanso kutenganso nthawiyi ndi comma mu Excel pogwiritsa ntchito macro.

  1. Choyamba, muyenera kuyika macros ndi tabu "Wotsambitsa"ngati iwo sali nawo.

  2. Pitani ku tabu "Wotsambitsa".

  3. Timakanikiza batani "Visual Basic".

  4. Ikani code yotsatirayi muwindo lokonzera:

    Ma Macro_substitution_complete ()
    Kusankha.Kumasulira Chiyani: = ".", Kumalo: = ","
    Malizani pang'ono

    Tsekani mkonzi.

  5. Sankhani malo a maselo pa pepala omwe mukufuna kusintha. Mu tab "Wotsambitsa" pressani batani Macros.

  6. Pawindo lomwe limatsegula, mndandanda wa macros. Sankhani kuchokera mndandanda "Macro m'malo mwazigawo". Timakanikiza batani Thamangani.

Pambuyo pake, mfundo zimasinthidwa kukhala makasitomala osiyanasiyana.

Chenjerani! Gwiritsani ntchito njirayi mosamala kwambiri. Zotsatira za izi zazikulu sizitha kusinthika, choncho sankhani maselo okha omwe mukufuna kuwagwiritsa ntchito.

Phunziro: momwe mungapangire macro mu Microsoft Excel

Njira 4: Gwiritsani ntchito Zopewera

Njira yotsatira imaphatikizapo kukopera deta muyezo woyenera mkonzi wa Windows Notepad, ndikusintha pulogalamuyi.

  1. Sankhani ku Excel m'dera la maselo omwe mukufuna kuti mutenge malowo ndi chida. Dinani botani lamanja la mouse. Mu menyu yachidule, sankhani chinthucho "Kopani".

  2. Tsegulani Zoperekera Zina. Dinani ndi batani lamanja la mouse, ndipo mundandanda womwe ukuwonekera dinani pa chinthucho Sakanizani.

  3. Dinani pa chinthu cha menyu Sintha. Mundandanda womwe ukuwonekera, sankhani chinthucho "Bwezerani". Mwinanso, mungathe kungoyimira kuphatikiza kwachinsinsi pa kambokosi Ctrl + H.

  4. Kufufuza ndi kutsegula mawindo kumatsegula. Kumunda "Kodi" ikani mapeto. Kumunda "Kodi" - mafilimu. Timakanikiza batani "Bwezerani Zonse".

  5. Sankhani deta yosinthidwa mu Notepad. Dinani botani lamanja la mouse, ndipo mundandanda musankhe chinthucho "Kopani". Kapena koperani njira yachidule yachinsinsi Ctrl + C.

  6. Timabwerera ku Excel. Sankhani magulu osiyanasiyana omwe maselo ayenera kusinthidwa. Timakanikiza pa iyo ndi batani lolondola. Mu menyu omwe akupezeka m'gawoli "Njira Zowonjezera" dinani pa batani "Sungani malemba okha". Kapena, yesani kuyanjana kwachinsinsi Ctrl + V.

  7. Kwa maselo osiyanasiyana, sankhani chiwerengero cha nambala mofanana ndi kale.

Njira 5: Sinthani Mawonekedwe a Excel

Monga imodzi mwa njira zosinthira mfundo ku makasitomala, mungagwiritse ntchito zoikidwiratu za Excel.

  1. Pitani ku tabu "Foni".

  2. Sankhani gawo "Zosankha".

  3. Pitani ku mfundo "Zapamwamba".

  4. Mu gawo la zosintha "Zosankha zosintha" sankhani chinthucho "Gwiritsani ntchito oyendetsa mapulogalamu". M'munda wokonzedwa "Wolekanitsa gawo lonse ndi laling'ono" ikani mapeto. Timakanikiza batani "Chabwino".

  5. Koma, deta yokha siidzasintha. Ife timawalemba iwo mu Notepad, ndiyeno amawaphatikize iwo kumalo omwewo mwa njira yachizolowezi.

  6. Pambuyo pa opaleshoniyo, ndikulimbikitsidwa kubwezeretsa zosintha zosasintha za Excel.

Njira 6: Sintha machitidwe a dongosolo

Njira iyi ndi yofanana ndi yoyamba. Nthawi iyi yokha, sitikusintha zochitika za Excel. Ndipo mawonekedwe a Windows mawonekedwe.

  1. Kupyolera mu menyu "Yambani" timalowa "Pulogalamu Yoyang'anira".

  2. Mu Pulogalamu Yoyang'anira, pitani ku gawoli "Clock, chinenero ndi dera".

  3. Pitani ku gawo "Malamulo ndi Zigawo Zakale".

  4. Muzenera lotseguka pa tabu "Zopanga" pressani batani "Zida Zapamwamba".

  5. Kumunda "Wolekanitsa gawo lonse ndi laling'ono" timasintha comma kwa mfundo. Timakanikiza batani "Chabwino".

  6. Lembani deta kudzera mu Notepad ku Excel.

  7. Tibwezeretsa mawonekedwe a Windows apitawo.

Mfundo yomalizira ndi yofunika kwambiri. Ngati simukuchita, simungathe kuchita masewera olimbitsa thupi omwe ali ndi deta yosinthidwa. Komanso, mapulogalamu ena omwe amaikidwa pa kompyuta akhoza kugwira ntchito molakwika.

Monga momwe mukuonera, pali njira zingapo zothandizira kuima kwathunthu ndi makina a Microsoft Excel. Inde, ambiri ogwiritsa ntchito amakonda kugwiritsa ntchito chida chophweka komanso chophweka kwambiri pa njirayi. "Pezani ndi kusintha". Koma, mwatsoka, nthawi zina ndiwothandizira sikutheka kutembenuza deta molondola. Ndi pamene njira zina zingathe kupulumutsira.

Posts Popular

https://termotools.com ny.termotools.com © Mawindo 2024