Pane zviitiko apo mafaera eExcel anofanirwa kushandurwa kuita mazwi emazwi, semuenzaniso, kana tsamba yakavakirwa pane gwaro retafura. Nehurombo, ingoshandura gwaro rimwe kuenda kune imwe kuburikidza nemenyu chinhu "chengetedza se ..." hazvishande, sezvo mafaera aya ane chimiro chakasiyana zvachose. Ngatifungei kuti chii chinonzi Excel fomati yekutendeuka nzira dziripo mushoko.
Shandurudza Excel mafaera muShoko
Kune nzira dzinoverengeka kamwechete. Izvi zvichabatsira neyechitatu-bato software, asi pane nguva dzose mukana wekutamiswa kwehuwandu hwekutumira. Funga nezvezvisarudzo zvese kuitira.Nzira 1: Manual Kutevedzera
Imwe yenzira dzakareruka dzekushandura zvirimo zveiyo Excel faira kushoko iri kungotevedzera uye kuisa data.
- Vhura iyo faira muMicrosoft Excel chirongwa uye kugovera zvirimo izvo zvatinoda kuendesa kushoko. Nekunyora-kurudyi mbeva pane izvi zvirimo, fonera mamiriro emenyu uye udzvanise pane "Kopa" chinhu. Neimwe nzira, iwe unogona zvakare kudzvanya pane bhatani pane tepi ine izita rimwe chete kana shandisa iyo CTRL + C KURU KUKOSHESA
- Mushure meizvozvo, kuvhura Microsoft Shoko. Dzvanya pane iyo kuruboshwe bhatani bhatani uye mune menyu inoonekwa kuburikidza neyekuisa parameter Sarudza iyo "Sevha mamiriro ekugadzira" chinhu.
- Kopa data ichave yakaiswa.
Iko kukanganisa kwenzira iyi ndeyekuti haisi nguva dzose shanduko yakaitwa nenzira kwayo, kunyanya nefomula. Uye zvakare, iyo data iri paiyo pepa reExcel haifanire kunge yakajeka kupfuura iro peji peji, kana zvisina kudaro vanongoerekana vasingakwani.
Nzira 2: Zvitatu-Party Zvirongwa
Kune zvakare mutsauko wekushandura mafaera kubva kuBudiki neshoko uchishandisa zvirongwa zvakakosha. Mune ino kesi, vhura zvirongwa izvi zvachose. Imwe yeiyo sarudzo dzakakurumbira dzekushandura magwaro kubva mukuratidzira muShoko iri iyo Abex Excel kushandura kushandurwa kwekushandisa. Iyo inochengetedza zvizere sosi yekugadzira data uye chimiro chematafura kana kutendeuka, kutsigira batch kutendeuka. Iko kungovhiringidza chete kushandisa mushandisi weimba ndeyekuti iyo interface kubva muchirongwa chekutaura Chirungu, pasina mukana wekurima. Nekudaro, mashandiro ayo ayo akapusa uye ane pfungwa, zvekuti kunyange mushandisi ane ruzivo rwakawanda rwechirungu achanzwisisa pasina matambudziko.
Dhawunirodha Abex Excel kushandurwa kwemazwi kubva kunzvimbo yepamutemo
- Isa uye kuvhura Abex Excel kushandurwa kwemazwi. Dzvanya pane iyo "Wedzera mafaera" bhatani.
- Hwindo rinovhura kwaunoda kusarudza iyo Excel faira iyo isu tiri kuenda kushandura. Kana zvichidikanwa, mafaera akati wandei anogona kuwedzerwa nenzira yakadaro.
- Ipapo pazasi pewindo rechirongwa, sarudza imwe yeiyo mana mafomu ayo iyo faira ichashandurwa. Iyi ndiyo doc (Microsoft Word 97-2003), DOCX, DOCM, RTF.
- Mu "Kuburitsa Kugadziriswa" Ground Boka, isa mhedzisiro mune izvo zvigadziko. Kana switch yakaiswa kune iyo "chengetedza chinangwa chefaira (s) chinzvimbo muRource folda", kuchengetedza inogadzirwa mune imwecheteyo dhairekitori kuiswa kunobva kupi.
- Kana iwe uchida imwe nzvimbo yekuchengetedza, wozoisa chinja kune "Gadzirisa" chinzvimbo. Nekusarudzika, kuponeswa kuchaitwa kune iyo yekubuda mudura iri paC drive Kero yeDhairekitori.
- Hwindo rinovhura iyo inotsanangura iyo folda pane yakaoma dhisiki kana inobvisa midhiya. Mushure mekunge dhairekitori rinoratidzwa, tinya pane zvakanaka.
- Kuti utsaure zvimwe zvakaringana shanduko, tinya pane "sarudzo" pane mudziyo wekushandisa. Mukuwanda kwazvo kwezviitiko, pane yakaringana paramita dzatataura pamusoro.
- Kana zvese zvigadziriso zvikaitwa, tinya pane "shandura", yakaiswa pachiteshi chekushandisa kurudyi kwe "sarudzo".
- Maitiro ekutendeuka anoitwa. Mushure mekupedza, iwe unogona kuvhura iyo faira yapera kuburikidza neshoko uye kushanda nazvo yatove muchirongwa ichi.
Nzira 3: Online Services
Kana iwe usingade kutanga software zvakanyatsoitika pakuita kweizvi maitiro, pane sarudzo yekushandisa yakakosha online masevhisi. Nheyo yekushanda kwevose vanoshandurwa zvakafanana vanenge zvakafanana, isu ticharondedzera tichishandisa muenzaniso webasa rinotonhorera.
Enda kune webhusaiti yepamutemo yefolutils
- Uchishandisa link iri pamusoro, vhura peji repaiti iro rinokutendera kuti uite online kushandura excel mafaera. Ichi chikamu chine kugona kwekuvaverengera kune inotevera mafomu: PDF, HTML, Jpeg, TXT, Tiff, pamwe neDoc. Mu "Dhawunirodha faira" block, tinya paBlowse.
- Hwindo rinovhura mukati kuti vasarudze faira muExcel fomati uye tinya pane bhatani rakavhurika.
- Pa "gadziriso sarudzo", taura chimiro kushandura iyo faira. Pane yedu nyaya, ichi chifananidzo cheDoC.
- Mu "Tora Faira" Chikamu, chinosara chekudzvanya pa "Dhawunirodha Convertible Faira".
Gwaro rinozotariswa kune komputa neyakajairwa chishandiso chakaiswa mubrowser yako. Iyo DEC faira inogona kuvhurwa uye yakarongedzwa muMicrosoft izwi.
Sezvauri kuona, pane mikana yakati wandei yekushandura data kubva mukuwedzera mushoko. Yekutanga inoreva kutamiswa kuri nyore kwezvinhu kubva kune imwe chirongwa kuenda kune imwe kopi nzira. Vaviri vamwe vane shanduko yakazara-yekudzora mafaira uchishandisa chirongwa chechitatu chetatu kana basa repamhepo.