Imidwebo isiza ukwethula idatha yenombolo ngesakhiwo sokudweba, ukululaza kakhulu ukuqonda okuningi kwemininingwane. Futhi, usebenzisa amashadi, ungabonisa ubuhlobo phakathi kochungechunge oluhlukile lwemininingwane.
I-Microsoft Office suite, iZwi, ikuvumela ukuba udale imidwebo. Sizochaza ukuthi singakwenza kanjani lokhu ngezansi.
Qaphela: Ukutholakala kwesofthiwe ye-Microsoft Excel kwikhompyutha inikeza izici eziphambili zokufaka ishadi ku-Word 2003, 2007, 2010 - 2016. Uma i-Excel ingafakiwe, i-Microsoft Graph isetshenziselwa ukwakha amashadi. Umdwebo kulokhu kuzonikezwa ngemininingwane ehlobene (itafula). Kule tafula, awukwazi ukungena kuphela idatha yakho, kodwa futhi uyifake kusuka kumbhalo wombhalo noma uyifake kwezinye izinhlelo.
Ukwakha ishadi eliyisisekelo
Ungangeza umdwebo eZwini ngezindlela ezimbili: ungene ngemvume kudokhumenti noma ufake umdwebo we-Excel ozohlanganiswa nedatha kwifayili le-Excel. Umehluko phakathi kwalezi imidwebo kulapho idatha equkethwe kuwo igcinwa nokuthi ibuyekezwa kanjani ngemva kokufakwa ku-MS Word.
Qaphela: Amanye amashadi adinga indawo ethile yedatha ku-MS Excel.
Ungabeka kanjani ishadi ngokulifaka emgqokweni?
Umdwebo we-Excel obanjwe eZwini ngeke ushintshe ngisho noma ifayili yomthombo ishintshiwe. Izinto ezihlanganisiwe kudokhumenti ziyingxenye yefayela, yehluleka ukuba yingxenye yomthombo.
Ukucabangela ukuthi yonke idatha igcinwe eDokhumenti yeZwi, kuyasiza kakhulu ukusebenzisa ukungena emacaleni uma kungekho izinguquko ezidingekayo kule data ngokulandela ifayela lomthombo. Futhi, isingeniso kungcono ukusebenzisa uma ungafuni abasebenzisi abazosebenza nodokhumenti esikhathini esizayo ukuze babuyekeze yonke imininingwane ehlobene.
1. Chofoza inkinobho yesinxele segundane kudokhumenti lapho ufuna ukwengeza ishadi.
Chofoza ithebhu "Faka".
3. eqenjini "Imifanekiso" khetha "Ishadi".
4. Ebhokisini lebhokisi ebonakalayo, khetha umdwebo oyifunayo bese uchofoza "Kulungile".
5. Akukhona nje ukuthi ishadi lizovela eshadini, kodwa futhi i-Excel, ezoba efasiteleni lokuhlukanisa. Izobonisa isibonelo sedatha.
6. Faka esikhundleni sesampula idatha evezwe iwindi ye-Excel ngezindinganiso ozidingayo. Ngaphandle kwedatha, ungathatha indawo yezibonelo zamasignatures e-axis (Ikholomu 1) negama legendane (Umugqa 1).
Emva kokufaka idatha edingekayo efasiteleni le-Excel, chofoza uphawu "Ukuguqula idatha ku-Microsoft Excel"Futhi londoloza lo mbhalo: "Ifayela" - Londoloza njenge.
8. Khetha indawo yokugcina idokhumenti bese ufaka igama elifunayo.
9. Chofoza "Gcina". Manje ungavala idokhumenti.
Lena enye yezindlela ezingenzeka ukuthi ungenza ishadi etafuleni eZwini.
Ungeza kanjani ishadi elixhunyiwe le-Excel kudokhumenti?
Le ndlela ikuvumela ukuba udale umdwebo ngokuqondile ku-Excel, kushidi langaphandle lohlelo, bese umane uhlanganise inguqulo ehambisanayo ku-MS Word. Idatha equkethwe kumdwebo oxhunyiwe izobuyekezwa uma izinguquko / izibuyekezo zenziwa eshidi langaphandle lapho ligcinwa khona. Izwi ngokwalo ligcina kuphela indawo yerefayili yomthombo, ibonisa idatha ehambisana nayo ethunyelwe kuyo.
Le ndlela yokwakha imidwebo iwusizo ngokukhethekile uma udinga ukufaka ulwazi kumadokhumenti ongekho onomthwalo wemfanelo. Lokhu kungaba idatha eqoqwe omunye umuntu, ozoyivuselela njengoba kudingeka.
1. Sika umdwebo ovela ku-Excel. Ungakwenza lokhu ngokucindezela "Ctrl + X" noma ngokusebenzisa igundane: khetha ishadi bese uchofoza "Sika" (iqembu "Ibhodi lokunamathisela"ithebhu "Ikhaya").
2. Emadokhumenti eZwi, chofoza lapho ufuna ukufaka ishadi.
3. Faka ishadi usebenzisa izihluthulelo "Ctrl + V" noma khetha umyalo ohambelana nephaneli yokulawula: "Namathisela".
4. Londoloza idokhumenti ngeshadi elifakiwe kulo.
Qaphela: Izinguquko ozenzile kumbhalo wokuqala we-Excel (ishidi langaphandle) uzoboniswa masinyane eDokhumenti yeZwi lapho ufaka ishadi. Ukuze ubuyekeze idatha uma uvule kabusha ifayela ngemuva kokuyivala, kuzodingeka uqinisekise ukubuyekezwa kwedatha (inkinobho "Yebo").
Esikhathini esithile, sibheke ishadi lepayipi eZwini, kodwa ngale ndlela ungenza ishadi lanoma yiluphi uhlobo, kube yilona igrafu enekholomu, njengesibonelo esandulele, i-histogram, ishadi le-bubble, noma enye.
Ukushintsha isakhiwo noma isitayela seshadi
Ungaguqula njalo ukubukeka kweshadi owadalile ku-Word. Akudingekile ukwengeza izakhi ezintsha ngokuzenzekelayo, ukuzishintsha, ukufometha - kukhona njalo ithuba lokusebenzisa isitayela esenziwe ngomumo noma isakhiwo, okukhona okuningi kuloluhlelo lweMicrosoft. Isakhiwo ngasinye noma isitayela singaguqulwa ngaso sonke isikhathi ngesandla futhi shintshwe ngokuvumelana nezidingo ezidingekayo noma ezifunwayo, njengoba nje ungasebenza ngento ngayinye yomdwebo.
Indlela yokusebenzisa isakhiwo esilungile?
1. Chofoza eshadini ofuna ukuguqula bese uya kuthebhu "Umklami"itholakala kuthebhu esemqoka "Ukusebenza ngamashadi".
2. Khetha isakhiwo seshadi ofuna ukuyisebenzisa (iqembu "Izakhiwo zamashadi").
3. Ukuhlelwa kweshadi lakho kuzoshintsha.
Indlela yokusebenzisa isitayela esilungele?
1. Chofoza kumdwebo ofuna ukusebenzisa isitayela esiphelile bese uya kuthebhu "Umklami".
2. Khetha isitayela ofuna ukuyisebenzisa ishadi lakho eqenjini. Izitayela Zezhadi.
3. Izinguquko zizobonakala ngokushesha eshadini lakho.
Ngakho-ke, ungashintsha imidwebo yakho, ebizwa ngokuthi uyahamba, ngokukhetha isakhiwo esifanele nesitayela, kuye ngokuthi yini edingekayo okwamanje. Isibonelo, ungakha izifanekiso eziningana zomsebenzi wakho, bese uguqula kusuka, esikhundleni sokudala okusha (sizobe sitshele ukuthi singagcina kanjani imidwebo njengesifanekiso esingezansi). Isibonelo, unegrafu enekholomu noma ishadi lepayipi, ukhetha isakhiwo esifanele, ungenza kusuka kuso ishadi elinama-percents eZwini.
Indlela yokushintsha ngesandla izakhiwo zeshadi?
1. Chofoza igundane kumdwebo noma isici esihlukile esakhiweni ofuna ukushintsha. Lokhu kungenziwa ngendlela ehlukile:
- Chofoza noma kuphi kumdwebo ukuze usebenze ithuluzi. "Ukusebenza ngamashadi".
- Kuthebhu "Fometha"iqembu "Isiqeshana Samanje" chofoza umcibisholo oseduze "I-Chart Elements", ke ungakhetha into oyifunayo.
2. Kuthebhu "Umklami", eqenjini "Izakhiwo zamashadi" chofoza entweni yokuqala - Engeza i-Chart Element.
3. Emenyu enwetshiwe, khetha ukuthi ufuna ukufaka noma ukushintsha.
Qaphela: Izinketho zokuhlela ezikhethiwe kanye / noma ukuguqulwa nguwe zizosetshenziselwa kuphela isici esikhethiwe leshadi. Uma kwenzeka ukhethe yonke imidwebo, isibonelo, ipharamitha "Idatha yedatha" izosetshenziswa kuwo wonke okuqukethwe. Uma kuphela iphuzu lwedatha elikhethiwe, izinguquko zizosetshenziswa kuphela kulo.
Indlela yokushintsha ngesandla ngesakhiwo sezinto zeshadi?
1. Chofoza kumdwebo noma isici saso sodwa isifiso sakho ofuna ukushintsha.
Chofoza ithebhu "Fometha" isigaba "Ukusebenza ngamashadi" futhi uthathe isinyathelo esidingekayo:
- Ukufometha isici esikhethiwe leshadi, khetha "Ifomethi yesikhwama esikhethiwe" eqenjini "Isiqeshana Samanje". Ngemuva kwalokho, ungabeka izinketho zokufometha ezidingekayo.
- Ukufometha isakhiwo esakhiwe ngeshadi, ukhethe isitayela esifunyiwe eqenjini. "Izitayela Zomzimba". Ngaphezu kokushintsha isitayela, ungaphinda ugcwalise ukuma ngombala, shintsha umbala wenkomba yayo, engeza imiphumela.
- Ukufometha umbhalo, khetha isitayela oyifunayo eqenjini. Izitayela ze-WordArt. Lapha ungenza "Gcwalisa umbhalo", "Umbhalo Ogqamile" noma engeza imiphumela ekhethekile.
Ungasindisa kanjani ishadi njengesifanekiso?
Ngokuvamile kwenzeka ukuthi umdwebo owadalile ungadinga kamuva, ngokufanayo noma okufanayo, lokhu akubalulekile kakhulu. Kulesi simo, kungcono ukugcina ishadi njengesifanekiso - lokhu kuzokwenza kube lula nokusheshisa umsebenzi esikhathini esizayo.
Ukwenza lokhu, mane uchofoze kumdwebo on inkinobho yesokudla yegundane bese ukhetha "Londoloza njengesifanekiso".
Ewindini ebonakalayo, khetha indawo ozoyigcina, setha igama lefayili oyifunayo bese uchofoza "Gcina".
Yilokho nje, manje ukwazi ukwenza iZwi noma yikuphi umdwebo, ungene noma uxhunyiwe, ube nokubukeka okuhlukile, okungukuthi, ungashintsha njalo ulungise ukuvumelanisa nezidingo zakho noma izidingo ezidingekayo. Sifisela wena umsebenzi ophumelelayo nokufunda okuphumelelayo.
