✔️ Njira 5 Zapamwamba Zopangira Ma Table Data mu Microsoft Excel
- Ndemanga za News
Mukapanga ma spreadsheets mu Microsoft Excel, mutha kusanthula deta, kutsatira zosintha ndi anzanu, kugawa mawu ndi data, ndi zina zambiri. Chofunika kwambiri, Excel imakupatsani mwayi wokonza deta yanu m'matebulo kuti mukonzekere ma data anu ndikuwawonetsa mwadongosolo pama chart kapena zida zina zowonera.
Matebulo a data odzaza manambala amatha kukhala otopetsa, ndipo mutha kuwongolera mosangalatsa pogwiritsa ntchito ntchito zomangidwa ndi Excel. Nkhaniyi ikuwonetsani maupangiri abwino kwambiri opangira ma tebulo mu Microsoft Excel. Tikugwiritsa ntchito Mac ndipo njira zomwezo zimagwiranso ntchito kwa ogwiritsa ntchito Windows.
1. Mizere yonyezimira
Tiyerekeze kuti mumapanga tebulo lomwe lili ndi deta monga malonda a mwezi uliwonse kapena kutsika kwa thupi tsiku ndi tsiku. Sparklines ndi gawo la Microsoft Excel lomwe limakupatsani mwayi wopanga kuwala mu cell. Izi zidzakuthandizani kuwona bwino deta. Tsatirani izi.
Khwerero 1: Tsegulani Microsoft Excel pa kompyuta yanu.
Khwerero 2: Tsegulani fayilo ya spreadsheet yomwe mukufuna kusintha.
Khwerero 3: Sankhani minda yomwe mfundo za deta mukufuna kusonyeza.
Khwerero 4: Dinani pa Insert mu bar ya menyu yapamwamba.
Gawo 5: Yang'anani njira ya Sparklines pamwamba kumanja.
Khwerero 6: Dinani pazosankha ndikusankha kalembedwe kanu.
Zenera la Sparklines limatsegula ndikukulimbikitsani kuti musankhe selo kuti muyike Sparklines.
Gawo 7: Pambuyo posankha selo, dinani OK batani.
Excel idzapanga sparkline mu selo yosankhidwa. Mutha kubwereza masitepe ndikupanga Sparklines paselo lililonse lomwe mukufuna.
Mutha kusinthanso mtundu wa Sparklines podina zomwe zili patsamba lakumanja kumanja.
2. Gome la anthu
Ngati mukupanga malipoti okhala ndi ma data monga kutsitsa mapulogalamu, kulumikizana ndi anthu, olembetsa amakalata, ndi zina zambiri, People Graph ikhala yothandiza kuyimira deta yanu. Zipangitsa kuti spreadsheet yanu ikhale yamoyo komanso njira zotsatirira anthu. Tsatirani izi.
Khwerero 1: Tsegulani Microsoft Excel ndikusankha fayilo yanu ya spreadsheet.
Khwerero 2: Dinani pa Insert mu bar ya menyu yapamwamba.
Khwerero 3: Dinani chizindikiro chobiriwira pafupi ndi "Mapulagi Anga" kuti muwonjezere tchati cha anthu.
Tchati chokhazikika cha anthu chidzawonekera papepala lanu pamwamba pa bolodi lanu.
Khwerero 4: Dinani ndi kukokera kuti musunthe graph ya anthu kutali ndi tebulo.
Gawo 5: Sankhani chithunzi cha graph ya anthu ndikudina chizindikiro cha data kumanja kumanja.
Khwerero 6: Sinthani mutu wa graph ya anthu anu kuti agwirizane ndi tebulo lanu.
Gawo 7: Dinani pa Sankhani deta yanu.
Khwerero 8: Sankhani malo a data kuchokera patchati yanu omwe mukufuna kuwonjezera pa tchati cha anthu.
Khwerero 9: Dinani Pangani.
Mudzawona tchati chatsopano cha anthu patsamba lanu chomwe chikuyimira ma metric a tebulo lanu.
Kuti musinthe mtundu wa chithunzi, mutu, ndi mawonekedwe, ingodinani chizindikiro cha Zikhazikiko pakona yakumanja kwa graph ya anthu.
3. wodulira
Nthawi zina posanthula deta patebulo, mawonekedwe a metrics amatha kukhala olemetsa. Pali mwayi woti mudzasokonezedwa kapena kutayika mukamawerenga manambala omwe amaikidwa m'magulu osiyanasiyana. Mutha kupewa zovuta zonse pogwiritsa ntchito chida cha Slicer. Iyi ndi njira yabwino yosefera deta yanu m'matebulo ang'onoang'ono omwe angadye. Ndimomwemo.
Khwerero 1: Tsegulani spreadsheet mu Microsoft Excel.
Khwerero 2: Press Command + A (Mac) kapena Control + A (Windows) kuti musankhe tebulo lanu.
Khwerero 3: Dinani Insert mu kapamwamba menyu pomwe mukusunga tebulo losankhidwa.
Khwerero 4: Sankhani Slicer kuchokera pamwamba kumanja kwa menyu.
Gawo 5: Pazenera la Slicer, sankhani magulu a data yanu kuti muyikemo magawo.
Khwerero 6: Dinani Chabwino kuti mutsimikizire zomwe mwasankha.
Magawo amagulu osankhidwa aziwoneka mu spreadsheet yanu.
Tsopano mutha kusankha zosefera za data patebulo lanu kuti muwone ma metric padera.
Kuti musasankhe zosefera zanu, ingodinani chizindikiro cha Chotsani Zosefera kumanja kumanja.
4. Sinthani chithunzicho
Paint ya Format imakupatsani mwayi kuti mawonekedwe a tebulo lanu azikhala osasinthasintha pomwe mukuwonjezera matebulo osiyanasiyana pa spreadsheet yomweyo. Ngati mukufuna kugwiritsa ntchito izi m'mafayilo anu a spreadsheet, tsatirani izi.
Khwerero 1: Tsegulani fayilo yanu ya spreadsheet mu Microsoft Excel.
Khwerero 2: Sankhani maselo a tebulo omwe mukufuna kukopera masanjidwe ake.
Khwerero 3: Dinani chizindikiro cha Burashi pakona yakumanzere pansi pa tabu Yanyumba.
Khwerero 4: Sunthani cholozera wanu pa tebulo yaiwisi ndi kusankha maselo onse.
Mudzawona kuti matebulo awiriwa tsopano ali ndi mawonekedwe ofanana.
5. Phatikizani deta
Ngati fayilo yanu ya spreadsheet ili ndi ma sheet angapo, mutha kusonkhanitsa deta yonse yamasamba mu tabu imodzi ndi ntchitoyi. Chinthu chabwino kwambiri ndichakuti simuyenera kuyika fomula iliyonse! Mutha kugwiritsa ntchito kuchuluka, avareji, kuwerengera ndi zina zambiri pamasamba oyambira ndipo tabu yophatikizidwa idzasinthidwa zokha. Tsatirani izi.
Khwerero 1: Tsegulani fayilo yanu ya spreadsheet yomwe ili ndi mapepala oposa limodzi.
Khwerero 2: Dinani chizindikiro chowonjezera pansi kuti mupange tsamba latsopano ndikulitcha chilichonse chomwe mukufuna.
Khwerero 3: Patsamba latsopano, sankhani selo lomwe mukufuna kuyikamo deta yophatikizidwa.
Khwerero 4: Dinani pa Data tabu pamwamba menyu.
Gawo 5: Pa tabu ya Data, sankhani chizindikiro cha Consolidate kumanja.
Khwerero 6: Pa Consolidate tabu, dinani chizindikiro cha Reference kuti muwonjezere deta yochokera.
Gawo 7: Tsamba la Consolidate litagwa, tsegulani tsamba loyamba ndikusankha zonse zomwe zili.
Khwerero 8: Dinani chizindikiro cholozeranso kuti mubweze zenera.
Khwerero 9: Dinani chizindikiro cha More.
Mudzawona zolozera zapatsamba lanu loyamba zikuwonjezedwa mubokosi la "Maumboni Onse".
Gawo 10: Dinani chizindikiro cha Reference kachiwiri ndikubwereza masitepe oti muwonjezere deta kuchokera papepala lolozera ku zenera la Consolidate.
Gawo 11: Mukasankha tsiku lanu, onetsetsani kuti njira "Pangani maulalo kugwero la data" yafufuzidwa. Chitaninso chimodzimodzi pazosankha za 'Mzere Wapamwamba' ndi 'Mzere Wakumanzere'.
Gawo 12: Mukatsegula zosankha zonse, dinani Chabwino.
Mudzawona tebulo latsopano mu tabu latsamba lomwe lili ndi data yonse yophatikizidwa kuchokera pamapepala am'mbuyomu.
Sinthani matebulo mu Microsoft Excel
Kupanga matebulo ndichinthu chachikulu kwambiri cha Microsoft Excel. Zomwe zatchulidwa m'nkhaniyi zikuthandizani kuti mukhale ndi luso komanso luso lowonetsera deta. Onetsetsani kuti mukugwiritsa ntchito mtundu waposachedwa wa Microsoft Excel pakompyuta yanu.
SOURCE: Ndemanga za News
Osayiwala kugawana nawo nkhani yathu pamasamba ochezera kuti atilimbikitse. 🤓