Amashadi asiza ukwethula idatha yamanani ngefomethi yokuqhafaza, enza lula ukuqonda ukuqonda kwamanani amakhulu emininingwane. Futhi, usebenzisa amashadi, ungakhombisa ubudlelwane phakathi kochungechunge oluhlukile lwedatha.
Ingxenye yehhovisi le-Microsoft, iZwi, likuvumela nokuthi wakhe imidwebo. Sizosho ukuthi ungakwenza kanjani lokhu ngezansi.
Qaphela: Ukuba khona kwekhompyuter yakho komkhiqizo wesoftware ye-Microsoft Excel kunikeza amathuba athuthukile wokwenza imidwebo kwi-Word 2003, 2007, 2010 - 2016. Uma i-Excel ingafakiwe, i-Microsoft Graph isetshenziselwa ukudala imidwebo. Ishadi elikulesi simo lizokwethulwa nedatha ehlobene (ithebula). Awukwazi ukufaka idatha yakho kuleli thebula, kodwa futhi uyingenise kusuka kudokhumenti yombhalo noma unamathisele kwezinye izinhlelo.
Ukwakha ishadi lesisekelo
Ungangeza ishadi kuLizwi ngezindlela ezimbili - lishumeke kudokhumenti noma ufake ishadi le-Excel elizohlotshaniswa nedatha eshidi le-Excel. Umehluko phakathi kwale midwebo yilapho igcina khona imininingwane eyiqukethe nokuthi ivuselelwa kanjani ngemuva kokufakwa kwi-MS iZwi.
Qaphela: Amanye amashadi adinga ilungiselelo elithile ledatha ekhasini lokusebenzela le-MS Excel.
Ungayifaka kanjani ishadi ngokuyishumeka kudokhumenti?
Umdwebo we-Excel oshumeke eZwini ngeke uguquke noma ngabe uguqula ifayela lomthombo. Izinto ezifakwe kudokhumenti ziba yingxenye yefayela, ziyeka ukuba yingxenye yomthombo.
Ngokubheka ukuthi yonke imininingwane igcinwe kudokhumenti yeZwi, kubaluleke kakhulu ukusebenzisa ukushumeka ezimeni lapho ungadingi ukushintsha idatha efanayo, ucabangela ifayela lomthombo. Futhi, ukusebenzisa kungcono ukusebenzisa uma ungafuni abasebenzisi abazosebenza nedokhumenti ngokuzayo ukubuyekeza yonke imininingwane ehlobene.
1. Qhafaza kwesobunxele kudokhumenti lapho ufuna ukwengeza khona ishadi.
2. Iya kuthebhu "Faka".
3. Eqenjini "Imifanekiso" khetha "Ishadi".
4. Ebhokisini lengxoxo elivelayo, khetha ishadi oyifunayo bese uqhafaza KULUNGILE.
5. Akuzovela ishadi kuphela eshidini, kodwa ne-Excel, ezoba efasiteleni elihlukanisiwe. Kuzobonisa nedatha yesampula.
6. Faka okunye esikhundleni sedatha enikezwe efasiteleni elihlukanisiwe le-Excel Excel amanani owadingayo. Ngokungeziwe kudatha, kungenzeka ukubuyisela izibonelo zamasiginesha axis (Kholamu 1) negama lean le (Umugqa 1).
7. Ngemuva kokufaka imininingwane edingekayo ewindini le-Excel, chofoza uphawu "Ukushintsha idatha ku-Microsoft Excel»Bese ugcine idokhumenti: Ifayela - Gcina Njengo.
8. Khetha indawo yokugcina idokhumenti bese ufaka igama olifunayo.
9. Chofoza "Gcina". Manje idokhumenti selingavalwa.
Lokhu kungenye yezindlela okungenzeka ngazo ukuthi udwebe ishadi etafuleni eLizwini.
Ungangeza kanjani ishadi elixhunyiwe ku-Excel kudokhumenti?
Le ndlela ikuvumela ukuthi udale ishadi ngqo ku-Excel, ekhasini elingaphandle lohlelo, bese umane ufake inguqulo yayo ehlobene kwi-MS Word. Imininingwane equkethwe kushadi elixhunyiwe izovuselelwa lapho kwenziwa izinguquko / izibuyekezo kushidi lwangaphandle lapho zigcinwa khona. IZwi ngokwalo ligcina kuphela indawo yefayela lomthombo, libonisa idatha ehambisana nalo eyethulwe kuyo.
Le ndlela yokwakha amashadi ibaluleke kakhulu lapho udinga ukufaka imininingwane kudokhumenti ongazibophezeli yona. Lokhu kungaba idatha eqoqwe omunye umuntu ozoyibuyekeza njengoba kunesidingo.
1. Sika ishadi ku-Excel. Ungakwenza lokhu ngokucindezela izinkinobho. "Ctrl + X" noma ngegundane: khetha ishadi bese uqhafaza "Sika" (iqembu "Ibhodi yokunamathisela"ithebhu "Ikhaya").
2. Embhalweni weZwi, chofoza lapho ufuna ukufaka khona ishadi.
3. Faka ishadi usebenzisa izinkinobho "Ctrl + V" noma khetha umyalo ofanele kuphaneli yokulawula: Namathisela.
4. Gcina umbhalo ngeshadi elifakwe kulo.
Qaphela: Izinguquko ozenzayo kudokhumenti yasekuqaleni ye-Excel (iphepha langaphandle) lizovela ngokushesha kumbhalo we-Word lapho ufake khona ishadi. Ukuvuselela imininingwane lapho uvula ifayili futhi ngemuva kokuyivala, kuzodingeka ukuthi uqinisekise ukuvuselelwa kwedatha (inkinobho Yebo).
Esibonelweni esithile, sihlole ishadi likaphayi eLizwini, kepha ngale ndlela ungenza ishadi lanoma uluphi uhlobo, kungaba yitshe elinamakholamu, njengasesibonelweni esedlule, i-histogram, ishadi lokubhaca, noma elinye.
Shintsha ukwakheka noma isitayela seladi
Ungahlala ushintsha ukuvela kweshadi olidale eZwini. Akudingeki ngokuphelele ukufaka izinto ezintsha, ukuzishintsha, uzifomefise - kuhlala kunethuba lokusebenzisa isitayela noma ukwakheka okulungiselelwe, okunezinhlelo eziningi ze-Microsoft. Ukwakheka ngakunye noma isitayela kungahlala kushintshwe ngesandla futhi kulungiswe ngokuya ngezidingo ezidingekayo noma ezifiselekayo, njengoba nje ungasebenza ngento ngayinye yomdwebo.
Ungasisebenzisa kanjani isakhiwo esiqediwe?
1. Chofoza eshadini ofuna ukusishintsha bese uye kuthebhu "Umqambi"etholakala kuthebhu enkulu "Sebenza ngamashadi".
2. Khetha ukwakheka kweshadi ofuna ukulisebenzisa (iqembu Izakhiwo Zeshadi).
3. Ukuhlelwa kweshadi lakho kuzoshintsha.
Ungasisebenzisa kanjani isitayela esenziwe ngomumo?
1. Chofoza eshadini ofuna ukufaka kulo isitayela esiphelile bese uye kuthebhu "Umqambi".
2. Khetha isitayela ofuna ukusisebenzisa eshadini lakho eqenjini. Izitayela Zeshadi.
3. Izinguquko zizothinta ishadi lakho ngokushesha.
Ngakho-ke, ungashintsha imidwebo yakho, ebizwa ngokuthi ekuhambeni, ukhetha ukwakheka kwesitayela esifanele nesitayela, ngokuya ngalokho okudingekayo okwamanje. Isibonelo, ungakha izifanekiso eziningi ezahlukahlukene zomsebenzi, bese ushintsha usuka, esikhundleni sokudala ezintsha (Sizokhuluma ngokuthi ungonga kanjani amashadi njengesifanekiso esingezansi). Isibonelo, unegrafu enamakholamu noma ishadi likaphayi, ukhetha ukwakheka okufanele, ungenza ishadi elinamaphesenti eZwini kusuka kulo.
Ungaziguqula kanjani izandla zamashadi?
1. Chofoza umdwebo noma into ngayinye ofuna ukuyishintsha. Lokhu kungenziwa ngenye indlela:
- Chofoza noma kukuphi eshadini ukuze usebenzise ithuluzi. "Sebenza ngamashadi".
- Kuthebhu "Ifomathi"iqembu "Isiqephu samanje" chofoza umcibisholo oseduze "Izinto zeshadi", ngemuva kwalokho ungakhetha into oyifunayo.
2. Kuthebhu "Umqambi", eqenjini Izakhiwo Zeshadi chofoza entweni yokuqala - Ngeza i-Chart Element.
3. Kumenyu ye-pop-up, khetha lokho ofuna ukukufaka noma ukukushintsha.
Qaphela: Izinketho zokubeka ozikhethayo kanye / noma ozoshintsha zizosebenza kuphela entweni eshadiwe. Uma kwenzeka ukhethe umdwebo wonke, ngokwesibonelo, ipharamitha "Amalebula wedatha" izosetshenziswa kukho konke okuqukethwe. Uma kukhethwe iphuzu ledatha kuphela, izinguquko zizosetshenziswa kulo kuphela.
Ungayishintsha kanjani ngesandla indlela yokuhlelwa kweshadi?
1. Qhafaza eshadini noma kuzinto zalo ofuna ukuzishintsha.
2. Iya kuthebhu "Ifomathi" isigaba "Sebenza ngamashadi" futhi wenze isenzo esidingekayo:
- Ukufometha into eshadiwe ekhethiwe, khetha "Ifomethi yesigaxa esikhethiwe" eqenjini "Isiqephu samanje". Ngemuva kwalokho, ungabeka izinketho zokufomatha ezidingekayo.
- Ukufometha ukwakheka, okuyingxenye yeshadi, khetha isitayela osifunayo eqenjini "Izitayela Zomdwebo". Ngaphezu kokushintsha isitayela, ungagcwalisa futhi umbala ngombala, ushintshe umbala wokuphuma kwawo, ungeze imiphumela.
- Ukufometha umbhalo, khetha isitayela osifunayo eqenjini. Izitayela ze-WordArt. Lapha ungakwazi ukukhipha "Gcwalisa umbhalo", "Uhlaka lombhalo" noma engeza imiphumela ekhethekile.
Ungayigcina kanjani ishadi njengesifanekiso?
Kwenzeka kaningi ukuthi ishadi elakhiwe nguwe lingadingeka esikhathini esizayo, ngokufana noma i-analogue efanayo, lokhu akubalulekile kangako. Kulokhu, kungcono ukonga ishadi njengethempulethi - lokhu kuzokwenza lula futhi kusheshiswe umsebenzi ngokuzayo.
Ukuze wenze lokhu, mane uchofoze eshadini enkombeni yegundane bese ukhetha Gcina Njengesifanekiso.
Ewindini elivelayo, khetha indawo ongayigcina, ucacisa igama lefayela olifunayo bese uchofoza "Gcina".
Yilokho kuphela, manje usuyazi ukuthi ungakha kanjani umdwebo eZwini oshumekiwe noma oxhunyiwe, ukubukeka okuhlukile, okuthi, ngasendleleni, kungashintshwa njalo kulungiswe ukuze kulingane nezidingo zakho noma izidingo ezidingekayo. Sifisela wena umsebenzi okhiqizayo kanye nokuqeqeshwa okusebenzayo.
