Mukamagwira ntchito ku Microsoft Excel mu matebulo obwereza, ndizosavuta kugwiritsa ntchito mndandanda wapansi. Nawo, mutha kungosankha magawo omwe angafune pa menyu yopangidwa. Tiyeni tiwone momwe mungapangire mndandanda wotsalira m'njira zosiyanasiyana.
Kupanga mndandanda wowonjezera
Zosavuta kwambiri, ndipo nthawi yomweyo njira yogwira ntchito kwambiri yopanga mndandanda ndi njira yokhazikika pamndandanda wosiyana.
Choyamba, timapanga tebulo lopanda kanthu komwe tigwiritsa ntchito menyu yotsika, komanso kupanga mndandanda wapadera wa data womwe mtsogolomo uzimitsa menyu. Zambiri izi zitha kuyikidwa mbali zonse ziwiri za chikalatacho ndi zina, ngati simukufuna tebulo kuti liziwoneka limodzi.
Timagawa deta yomwe tikukonzekera kulembetsa ku mndandanda wotsika. Timadina batani lamanja la mbewa, ndikusankha "dzina" ... "muzosankha.
Mawonekedwe opanga dzina amatsegulidwa. Mu "Dzinalo", sangalalani ndi dzina lililonse lomwe tidzapeze. Koma, dzinali liyenera kuyamba ndi kalatayo. Mutha kulowanso cholembera, koma sichofunikira. Dinani pa batani la "OK".
Pitani ku tabu "deta" ya Microsoft Excel. Timatsindika malo omwe tidzagwiritsa ntchito mndandanda wa Drop-Dome. Dinani pa batani la "Data Diseni" lomwe lili pa tepi.
NJIRA yotsimikizira imatsegulira zomwe zikuwonetsa. Mu "magawo" tabu, mu mtundu wa data, sankhani mndandanda walemba. Pamunda "Source" Ikani chikwangwani chofanana, ndipo nthawi yomweyo timalemba dzina la mndandandawo, zomwe zidamupatsa mphamvu pamwambapa. Dinani pa batani la "OK".
Mndandanda wapansi wakonzeka. Tsopano, mukadina batani, khungu lililonse la kuchuluka kwake lidzawonekera mndandanda wa magawo, omwe mungasankhe chilichonse kuti muwonjezerene.
Kupanga mndandanda wotsalira wogwiritsa ntchito zida zapamwamba
Njira yachiwiri imaphatikizapo kupanga mndandanda wotsalira pogwiritsa ntchito zida zaluso, zomwe zimagwiritsa ntchito yogwira ntchito. Mwachisawawa, palibe ntchito zaluso, motero tifunika kuziphatikiza. Kuti muchite izi, pitani ku "fayilo" pulogalamu ya Excel, kenako dinani pa "magawo" mawu.
Pazenera lomwe limatseguka, pitani ku "ritibon Sectuption" ndikukhazikitsa cheke moyang'anizana ndi "wopanga". Dinani pa batani la "OK".
Pambuyo pake, tabu imapezeka pa tepi ndi dzina "wopanga", komwe timasuntha. Akuda ku Microsoft Excel, yomwe iyenera kukhala menyu yotsalira. Kenako, dinani pa tepi pa chithunzi cha "ikani", ndipo zina mwa zinthu zomwe zapezeka mu Gulu la Acticmex, sankhani "gawo ndi mndandanda".
Dinani pamalo pomwe foni yomwe ili ndi mndandanda iyenera kukhala. Monga mukuwonera, fomu yawonekera.
Kenako timasamukira ku "Conserthortor Mode". Dinani pa "katundu wa batani la" batani.
Kholo lowongolera limatseguka. Mu graph "zolemba" zamakono, timapereka mitundu ya ma cell patebulo m'matumba, omwe apangitse mfundo za mndandanda wa mndandanda wotsika.
Kenako, dinani pa cell, ndipo muzosankha, timadutsamo "Combobox" ndi "Sinthani".
Mndandanda wotsika mu Microsoft Excel yakonzeka.
Kupanga maselo ena ndi mndandanda wotsika, ungokhala pansi pa cell yomalizidwa, kanikizani batani la mbewa, ndikutambasula.
Mndandanda Wofananira
Komanso, mu pulogalamu ya Excel yomwe mungapangire pamndandanda wotsika. Awa ndi mndandanda wotere mukasankha mtengo umodzi kuchokera pamndandanda, mu gawo linanso limafunsidwa kuti asankhe magawo ofanana. Mwachitsanzo, posankha mndandanda wazogulitsa za mbatata, zimafunsidwa kuti zisankhe ngati kilogalamu ndi magalamu muyeso muyeso, ndipo mafuta a masamba akasankhidwa - lita ndi milililirers.
Choyamba, timakonzekera tebulo pomwe mndandanda wotsalira udzapezeka, ndipo tidzapanga mindandanda ndi dzina la malonda ndi miyeso yoyeza.
Timapereka chilichonse mwa mndandanda uliwonse womwe adatchulidwa kale, monga tachita kale ndi mndandanda wamba.
Mu khungu loyamba, timapanga mndandanda womwewo momwe zidachitidwira kale, kudzera kutsimikizira kwa data.
Mu cell yachiwiri, ikhazikitsanso zenera lotsika la data, koma mu mzere "gwero" timalowa ntchito "= kugwa" ndi adilesi ya selo yoyamba. Mwachitsanzo, = Dvsl ($ B3).
Monga mukuwonera, mndandandawo udapangidwa.
Tsopano, kuti maselo am'munsi azikhala ndi zinthu zomwezo, monga kale, sankhani maselo apamwamba, ndipo kiyi ya mbewa "pansi.
Chilichonse, tebulo linalengedwa.
Tidaganiza momwe tingapangire mndandanda wotsika. Pulogalamuyi imatha kupanga mndandanda wosavuta wotsika ndikudalira. Nthawi yomweyo, mutha kugwiritsa ntchito njira zosiyanasiyana zolengedwa. Kusankha kumatengera cholinga chapadera, zolinga zake, ntchito yofunsira, ndi zina zambiri.