Indlela Yokwenza Ishadi Lophayi ku-Excel 2016

Ukwenza ishadi likaphayi ku-Excel 2016 kuyikhono elibalulekile kulabo abafuna ukubona ngeso lengqondo nokuxhumana ngokucacile nangokufingqiwe. idatha yakho. Leli thuluzi elinamandla elivela ku-Microsoft livumela abasebenzisi ukuthi bakhe amashadi ophayi angokwezifiso besebenzisa amasethi edatha akhona kusipredishithi. Kulesi sihloko, sizohlola isinyathelo ngesinyathelo ulenza kanjani ishadi likaphayi ku-Excel 2016, kusukela ekulungiseleleni idatha kuya ekwenzeni ngokwezifiso ishadi lokugcina. Qhubeka ufunde ukuze uthole ukuthi ungawasebenzisa kanjani ngokugcwele amakhono e-Excel futhi wethule idatha yakho ngokucacile nangempumelelo.

1. Isingeniso samashadi ophayi ku-Excel 2016

Amashadi ophayi ayithuluzi elinamandla lokubuka ngeso lengqondo idatha ku-excel 2016. Lawa magrafu ayindilinga asivumela ukuthi simelele ngokucacile nangokufingqiwe ingxenye ye-elementi ngayinye ngokuphathelene nengqikithi. Kulesi sigaba, sizohlola ukuthi ungawakha kanjani futhi wenze ngendlela oyifisayo amashadi ophayi ku-Excel 2016.

Ukuze uqalise, vula i-Excel 2016 bese ukhetha idatha ofuna ukuyigrafu. Qiniseka ukuthi idatha ihlelwe ngamakholomu noma imigqa. Okulandelayo, chofoza ithebhu ethi "Faka" kuribhoni bese ukhetha "Ishadi Lophayi" eqenjini elithi "Amashadi". Lokhu kuzovula ibhokisi lengxoxo elithi “Faka Ishadi”. Lapha ungakhetha uhlobo lweshadi likaphayi elivumelana kangcono nezidingo zakho.

Uma usukhethile uhlobo lweshadi likaphayi, chofoza inkinobho ethi "KULUNGILE" ukuze ufake ishadi kusipredishithi sakho. Ungakwazi ke ukwenza ngendlela oyifisayo ukubukeka kweshadi usebenzisa amathuluzi okufometha e-Excel. Ungashintsha umbala wezingxenye zeshadi, wengeze amalebula edatha, noma ulungise nosayizi nesikali seshadi. Ukwengeza, ungakwazi ukwengeza isihloko kanye nenganekwane ukuze wenze igrafu iqondeke kakhudlwana kubafundi.

2. Isinyathelo ngesinyathelo: Ukudala ishadi likaphayi ku-Excel 2016

Ukwakha ishadi likaphayi ku-Excel 2016, landela lezi zinyathelo ezilandelayo:

Isinyathelo se-1: Vula I-Microsoft Excel 2016 bese ukhetha idatha ofuna ukuyimela eshadini likaphayi. Qiniseka ukuthi idatha ihlelwe yaba amakholomu noma imigqa, ngakho isigaba ngasinye sinevelu yaso ehambisanayo.

Isinyathelo se-2: Chofoza ithebhu "Faka" phakathi ibha yamathuluzi kwe-Excel. Bese, khetha okuthi “Amashadi” bese ukhetha inketho ethi “Pie Chart” kumenyu yokudonsela phansi. Ukukhethwa kwezinhlobo ezahlukene zamagrafu kuzovela, khetha inketho ethi "Pie Chart" ukuze udale.

Isinyathelo se-3: Ishadi likaphayi lizokhiqizwa ngokuzenzakalelayo kusipredishithi sakho se-Excel. Uma ufuna ukulenza ngendlela oyifisayo, chofoza kwesokudla kugrafu bese ukhetha “Izinketho Zeshadi”. Kusukela lapha, ungashintsha isihloko, wengeze amalebula ezigabeni, noma ulungise imibala nezitayela zegrafu ngokuya ngokuncamelayo.

3. Ukusetha idatha yeshadi likaphayi ku-Excel 2016

1. Vula uhlelo lwe-Excel 2016 bese ukhetha ispredishithi ofuna ukwakha kuso ishadi likaphayi.
2. Yiya kuthebhu ethi “Faka” kubha yamathuluzi ye-Excel bese ubheka ingxenye ethi “Amashadi”. Chofoza kusithonjana "Ishadi Lophayi".
3. Ibhokisi lengxoxo lizovuleka lapho ungakhetha khona idatha ofuna ukuyisebenzisela igrafu. Kuthebhu "Ububanzi Bedatha", qiniseka ukuthi amanani eshadi namalebula akhethwe ngendlela efanele. Ungakwenza lokhu ngokuhudula ikhesa phezu kwedatha kuspredishithi.

Ungakwazi ke ukwenza ngokwezifiso ishadi lakho likaphayi ngezinketho ezahlukene. Kuthebhu ethi “Idizayini Yeshadi” kanye “Nezinketho Zeshadi”, ungashintsha isihloko seshadi, wengeze amalebula edatha nenganekwane, futhi ulungise ukubukeka nokufometha kweshadi.

Uma ufuna ukushintsha ukuhleleka kwezigaba zeshadi likaphayi, ungakwenza lokho ngokuchofoza kwesokudla eshadini bese ukhetha okuthi “Shintsha ukuhleleka kwezingxenye zeshadi.” Ungakwazi futhi ukushintsha imibala yezigaba zegrafu ngokuchofoza kwesokudla nokukhetha okuthi “Ifomethi Yedatha.”

Ekugcineni, ungagcina ishadi lakho likaphayi ku-Excel 2016 futhi wabelane ngalo nabanye abasebenzisi. Khumbula ukuthi ungakwazi njalo ukubuyela emuva futhi ulungise noma yiziphi izilungiselelo zegrafu ngokuvumelana nezintandokazi zakho kanye nezidingo zakho.

4. Ukukhetha uhlobo lweshadi likaphayi olufanele ku-Excel 2016

Lapho udala amashadi ophayi ku-Excel 2016, kubalulekile ukukhetha uhlobo olufanele olukuvumela ukuthi wethule idatha ngokucacile nangempumelelo. Kunezinhlobo ezimbalwa zamashadi ophaya atholakala ku-Excel, ngalinye linezici zalo ezithile kanye nokusetshenziswa kwalo. Ukuzinika isikhathi sokukhetha uhlobo olufanele kuzoqinisekisa ukuthi ulwazi lukhulunywa ngokunembile nangokuqondakalayo.

Okunye okucatshangelwayo okubalulekile lapho ukhetha uhlobo lweshadi likaphayi ku-Excel 2016 ukunquma inani ledatha ofuna ukuyibonisa. Uma unamasethi ambalwa edatha, ishadi likaphayi elilula lingase lanele. Ngakolunye uhlangothi, uma unezigaba eziningi zedatha noma ufuna ukugqamisa umehluko ngamaphesenti, ishadi lophayi abaningi noma ishadi likaphayi webha lingase lifaneleke kakhulu. Ukuhlola izinketho ezitholakalayo nokuhlola izidingo zakho zokwethulwa kwedatha kuzokusiza wenze ukukhetha okufanele.

Esinye isici esibalulekile lapho ukhetha ishadi likaphayi elilungile ukucabangela ukufundeka nokucaca kweshadi eliwumphumela. Ukuqinisekisa ukuthi idatha kulula ukuyihumusha, kubalulekile ukugwema amashadi ophayi anezigaba eziningi, futhi ugweme ukugqagqana okweqile kwezigaba. Ukwengeza, ukusebenzisa izinketho zokufometha ze-Excel, njengokwengeza amalebula edatha nezihloko ezichazayo, kuzosiza ukuthuthukisa ukuqonda kweshadi. Ngokuvamile, kunconywa ukugcina ishadi likaphayi lilula ngangokunokwenzeka ukuze ugweme ukudideka futhi uqinisekise ukuthi ulwazi luyadluliswa. ngempumelelo.

5. Ukwenza ngendlela oyifisayo Ukubukeka Kweshadi Lophayi ku-Excel 2016

Inikeza indlela esheshayo nelula yokuthuthukisa iphrezentheshini ebonakalayo yedatha yakho. Ngokuchofoza okumbalwa nje, ungakwazi ukulungisa isakhiwo, imibala, nezinto zeshadi ukuze kufane nezidingo zakho.

Ukwenza ngendlela oyifisayo ukubukeka kweshadi likaphayi ku-Excel 2016, kuqala kufanele ukhethe igrafu ngokuchofoza kuyo. Bese, kuthebhu ethi “Amathuluzi Eshadi”, chofoza okuthi “Dizayina” ukuze ufinyelele izinketho ezahlukene zokwenza ngendlela oyifisayo. Lapha ungakwazi ukushintsha isitayela segrafu, ukhethe isakhiwo esichazwe ngaphambilini noma udale esakho isakhiwo esingokwezifiso.

Ngokungeziwe kusakhiwo, ungakwazi futhi ukwenza ngezifiso imibala yeshadi likaphayi. Kuthebhu ethi "Fometha", chofoza "Imibala Yochungechunge" ukuze ukhethe iphalethi yombala kuchazwe kusengaphambili noma dala inhlanganisela yakho yombala. Ungakwazi futhi ukushintsha umbala wesigaba ngasinye segrafu ngasodwana.

6. Engeza Amalebula Nenganekwane eshadini likaphayi ku-Excel 2016

1. Faka ishadi likaphayi: Okokuqala, ukwengeza amalebula nenganekwane eshadini likaphayi ku-Excel 2016, udinga ukuvula Ifayela le-Excel equkethe igrafu. Uma ifayela selivuliwe, thola isipredishithi esiqukethe ishadi likaphayi bese uchofoza kuso ukuze usikhethe.

2. Engeza amalebula eshadini likaphayi: Uma ishadi likaphayi selikhethiwe, hamba kuthebhu ethi “Design” kubha yamathuluzi ye-Excel. Eqenjini lamathuluzi Amalebula Edatha, chofoza inkinobho ethi Amalebula Edatha bese ukhetha inketho ethi Engeza Amalebula Edatha. Lokhu kuzongeza amalebula ngokuzenzakalela engxenyeni ngayinye yeshadi likaphayi.

3. Engeza inganekwane eshadini likaphayi: Ukwengeza inganekwane eshadini likaphayi, buyela kuthebhu “Isakhiwo” kubha yamathuluzi ye-Excel. Eqenjini lamathuluzi Amalebula, chofoza inkinobho ye-Legend bese ukhetha indawo oyifunayo yenganekwane. Ungakhetha kokukhethwa kukho okunjengokuthi “Kwesokudla”, “Kwesobunxele”, “Phezulu” noma “Phansi”. Uma ukhetha indawo, inganekwane izovela ngokuzenzakalelayo eshadini likaphayi.

7. Ukuhlola izinketho zokufometha kweshadi likaphayi ku-Excel 2016

I-Excel 2016 inikezela ngezinketho eziningi zokufometha ukuze wenze ngokwezifiso amashadi akho ophaya futhi uwanikeze ukubukeka okukhangayo nokochwepheshe. Kulesi sifundo, sizohlola amathuluzi ahlukene atholakalayo futhi sikunikeze amathiphu awusizo ukuze wenze ngokugcwele lezi zinketho zokufometha.

Ukuze uqalise, ungashintsha ifomethi yeshadi likaphayi ku-Excel 2016 kuthebhu ethi “Design” kuribhoni. Lapha uzothola izinketho ezimbalwa ukuze ulungise ukubukeka kweshadi lakho, njengokwengeza izihloko, amalebula edatha, nezinganekwane. Ungakwazi futhi ukushintsha imibala nezitayela zezingcezu zegrafu ukuze ugqamise ulwazi olubalulekile.

Ukwengeza, i-Excel 2016 ikuvumela ukuthi ulungise usayizi nendawo yeshadi likaphayi kusipredishithi sakho. Ungahudula bese uphonsa igrafu ukuze uyibeke endaweni oyifunayo. Ungaphinda ushintshe usayizi wegrafu ngokuyikhetha futhi ulungise izindawo zokulawula emaphethelweni. Lezi zilawuli zikuvumela ukuthi ushintshe usayizi wegrafu ngokulinganayo noma ngokungalingani, kuye ngezidingo zakho.

8. Ukusebenzisa Idatha Yespredishithi Eshadini Lophayi ku-Excel 2016

Ukuze usebenzise idatha yespredishithi eshadini likaphayi ku-Excel 2016, kunezinyathelo ezimbalwa okudingeka uzilandele. Okokuqala, vula isipredishithi ku-Excel futhi uqiniseke ukuthi idatha ihlelwe kahle. Idatha kufanele ibe kumakholomu ahlukene, futhi ikholomu ngayinye kufanele ibe nesihloko esichaza uhlobo lwedatha equkethe. Lokhu kuzokwenza kube lula ukukhomba idatha ofuna ukuyisebenzisa kugrafu.

Okulandelayo, khetha idatha ofuna ukuyisebenzisa eshadini likaphayi. Ungakwenza lokhu ngokucindezela inkinobho yegundane engakwesokunxele bese uhudula ukuze ukhethe amaseli owafunayo. Uma usuyikhethile idatha, hamba kumenyu ethi “Faka” kubha yamathuluzi bese ukhetha “Ishadi” engxenyeni ethi “Amashadi Anconyiwe”. Ibhokisi lengxoxo lizovela lapho kufanele ukhethe khona okuthi "Pie" njengohlobo lweshadi ofuna ukulenza.

Ngemva kokukhetha uhlobo lweshadi lophayi, ishadi lizokhiqizwa ngokuzenzakalelayo kusipredishithi sakho ngedatha ekhethiwe. Nokho, ungase ufune ukwenza ngendlela oyifisayo ukubukeka kwegrafu. Ukuze wenze lokhu, chofoza kwesokudla eshadini bese ukhetha "Izinketho Zeshadi." Lapha ungakwazi ukushintsha isihloko segrafu, imibala yezigaba zikaphayi, ilebula yedatha nezinye izici ukuze uyenze ifundeke kakhudlwana futhi ibukeke. Linga ngezinketho ezitholakalayo uze waneliseke ngomphumela wokugcina.

9. Ukubuyekeza nokulungisa ishadi likaphayi ku-Excel 2016

Uma uneshadi likaphayi ku-Excel 2016 futhi udinga ukwenza isibuyekezo noma ukuguqulwa, uze endaweni efanele. Ngezansi, sizochaza isinyathelo ngesinyathelo indlela yokuxazulula le nkinga futhi sithole imiphumela oyifunayo.

1. Into yokuqala okudingeka uyenze ukukhetha ishadi likaphayi ofuna ukulibuyekeza noma ulilungise. Ungakwenza lokhu ngokuchofoza igrafu ukuze uyigqamise. Khumbula ukuthi ungaphinda ukhethe ishadi kuthebhu ethi “Idizayini Yeshadi” kubha yamathuluzi.

2. Uma ishadi selikhethiwe, uzobona “Amathuluzi Eshadi” avela kubha yamathuluzi. Chofoza ithebhu ethi "Design" bese ukhetha izinketho ofuna ukuzishintsha. Kulesi sigaba, uzothola izinketho ezihlukahlukene zokwenza ngokwezifiso ishadi lakho likaphayi, njengokushintsha imibala, ukwengeza noma ukukhipha amalebula, ukuhlela idatha, phakathi kokunye.

10. Amathiphu namasu okuthuthukisa amashadi akho ophaya ku-Excel 2016

Amashadi ophayi ayithuluzi eliwusizo lokubuka ngeso lengqondo ukusatshalaliswa kwedatha ku-Excel 2016. Nokho, kungenzeka ukuthuthukisa ukubukeka kwawo nokwandisa ukusebenza kwawo ngokulandela okunye amathiphu namasu. Ngezansi kunamathiphu amathathu wokukusiza uzuze amashadi ophaya ahlaba umxhwele:

1. Sebenzisa imibala ehlukene: Ukuze wenze amashadi akho ophaya athandeke kakhulu, kubalulekile ukukhetha imibala egqamayo. Ngale ndlela, kuzoba lula ukuhlukanisa izigaba ezahlukene ezimelelwe kugrafu. Ungenza imibala ngendlela oyifisayo usebenzisa ithuluzi lokufometha ishadi le-Excel noma ukhethe izinhlanganisela ezichazwe ngaphambilini. Khumbula ukuthi kuhle ukugwema ukusebenzisa imibala efana kakhulu, njengoba lokhu kuzokwenza ulwazi lube nzima ukulihumusha.

2. Lungisa usayizi weshadi: Kwesinye isikhathi amashadi ophaya angabonakala ehlanekezelwe noma engafundeki kahle ngenxa yosayizi wawo. Ukuze uxazulule le nkinga, kunconywa ukuthi ulungise usayizi weshadi mathupha. Ungakwenza lokhu ngokukhetha ishadi nokusebenzisa izinketho zokulinganisa ezitholakala kuthebhu ethi "Fometha" yeribhoni. Qiniseka ukuthi ishadi likhulu ngokwanele ukuze libonise ngokucacile amalebula namaphesenti ahlotshaniswa nesigaba ngasinye.

3. Lebula amagrafu akho ngendlela efanele: Ukulebula okuhle kubalulekile ukuze kube lula ukuqonda igrafu kaphayi. Qiniseka ukuthi ufaka amalebula acacile, achazayo esigaba ngasinye. Ngaphezu kwalokho, kuyatuseka ukukhombisa amaphesenti ahlotshaniswa nesigaba ngasinye segrafu. Unganika amandla le nketho ngokukhetha ishadi futhi ufinyelele izinketho zelebula ezitholakala kuthebhu ethi “Dizayina” iribhoni. Lokhu kuzovumela abafundi ukuthi babone kalula ingxenye ngayinye yegrafu futhi baqonde incazelo yayo.

Ukulandela lezi zeluleko namaqhinga, ungathuthukisa amashadi akho ophayi ku-Excel 2016 futhi wenze idatha yakho icace futhi iqondakale kakhudlwana. Khumbula ukuhlola ngedizayini ehlukene nezinketho zokwenza ngendlela oyifisayo ukuze uthole isitayela esizifanela kangcono izidingo zakho. Ungangabazi ukusebenzisa lezi zincomo futhi uthole amashadi ophayi abukekayo!

11. Ukuxazulula izinkinga ezivamile lapho udala ishadi likaphayi ku-Excel 2016

Uma ubulokhu uhlangabezana nobunzima bokwenza ishadi likaphayi ku-Excel 2016, ungakhathazeki, usendaweni efanele! Ngezansi, sizokwethula izixazululo ezinkingeni ezijwayelekile ongabhekana nazo lapho ukhiqiza lolu hlobo lwegrafu ku-Excel:

Usayizi weshadi ongalungile: Uma ishadi lakho likaphayi libukeka lilincane kakhulu noma lingalingani nedatha yakho, ungakwazi ukulungisa kalula usayizi walo. Ukuze wenze lokhu, chofoza kwesokudla kugrafu bese ukhetha "Usayizi Nezakhiwo" kumenyu. Okulandelayo, lungisa usayizi wegrafu ngokuvumelana nezintandokazi zakho. Kuhlale kuhle ukuthi uqinisekise ukuthi igrafu inkulu ngokwanele ukuze idatha ifundeke.

Omaka bedatha abangekho: Uma amalebula edatha engaveli eshadini lakho likaphayi, qiniseka ukuthi ukhethe inketho efanele lapho udala ishadi. Ukuze wenze lokhu, chofoza kwesokudla eshadini bese ukhetha okuthi “Engeza Amalebula Edatha” kumenyu ye-pop-up. Qiniseka ukuthi ukhetha inketho oyifunayo: "Amalebula ngaphakathi kwesegimenti", "Amalebula angaphandle kwesegimenti" noma "Awekho amalebula". Ngale ndlela, ungabonisa noma ufihle amalebula ngokwezidingo zakho.

Imibala engamele: Uma imibala yamasegimenti eshadi lakho likaphayi ingameleli idatha ehambisanayo, ungayenza ngendlela oyifisayo kalula. Okokuqala, khetha igrafu bese uchofoza kwesokudla kweyodwa yamasegimenti. Kusuka kumenyu ye-pop-up, khetha "Gcwalisa Imibala" bese ukhetha umbala ofuna ukuwunikeza kuleyo ngxenye. Phinda le nqubo kuwo wonke amasegimenti, wenze isiqiniseko sokuthi imibala inengqondo futhi ilingana nedatha yakho.

12. Thumela ishadi likaphayi ku-Excel 2016 kwamanye amafomethi

Ukukhipha ishadi likaphayi ku-Excel 2016 kwamanye amafomethi kungaba usizo ekwabelaneni ngolwazi olubonakalayo ngendlela elula kakhulu. Ngenhlanhla, i-Excel inikeza izinketho ezimbalwa zokuthekelisa amashadi ophaya. kumafomethi ahlukene. Ngezansi kukhona izinyathelo zokwenza lo msebenzi.

1. Okokuqala, vula ifayela le-Excel eliqukethe ishadi likaphayi ofuna ukulithekelisa. Qiniseka ukuthi igrafu ikhethiwe ngokuchofoza kuyo.

2. Uma ishadi selikhethiwe, chofoza ithebhu ethi “Ifayela” phezulu kwesokunxele kwesikrini se-Excel. Bese, khetha inketho ethi “Londoloza Njenge” kumenyu yokudonsela phansi.

3. Iwindi lengxoxo lizovuleka lapho ungakhetha khona indawo negama lefayela eliphumayo. Esigabeni esithi "Londoloza njengohlobo", khetha ifomethi yefayela ofuna ukukhiphela kuyo ishadi likaphayi. Izinketho ezijwayelekile zifaka i-PNG, i-JPEG, ne-PDF. Khetha ifomethi oyifunayo bese uchofoza inkinobho ethi "Gcina".

Ngalezi zinyathelo ezilula, ishadi lakho likaphayi le-Excel 2016 lizothunyelwa kwenye ifomethi ngokushesha! Manje usungabelana kalula ngegrafu yakho nabanye abasebenzisi noma uyisebenzise kumaphrezentheshini nakumadokhumenti.

13. Ukuqhathaniswa kwamashadi ophayi nezinye izinhlobo zamashadi ku-Excel 2016

Amashadi ophayi ayithuluzi eliwusizo lokumelela idatha ngokubonakalayo ku-Excel 2016. Nokho, kubalulekile ukuqhathanisa lawa mashadi nezinye izinhlobo zamashadi ukuze unqume ukuthi iyiphi inketho engcono kakhulu yesethi yakho yedatha. Ngezansi kukhona ukuqhathanisa okubalulekile phakathi kwamashadi ophayi nezinye izinhlobo zamashadi atholakala ku-Excel 2016.

1. Ukuqhathanisa namashadi ebha: Amashadi ophayi alungile uma unezigaba ezimele ingxenye yawo wonke. Nokho, uma ufuna ukuqhathanisa amanani ahlukene phakathi kwezigaba noma ubonise izinguquko ngokuhamba kwesikhathi, amashadi amabha angase asebenze kakhulu. Amashadi ebha avumela ukuqhathanisa kalula phakathi kwamanani, kuyilapho amashadi ophaya angaba nzima kakhulu ukuwahumusha ngokobukhulu.

2. Ukuqhathanisa namagrafu omugqa: Uma ubheke ukubonisa ithrendi noma izinguquko eziqhubekayo kudatha ngokuhamba kwesikhathi, amagrafu omugqa ayinketho engcono. Lawa magrafu akuvumela ukuthi ubone ngeso lengqondo ubudlelwano phakathi kokuhluka okubili futhi angasebenza kangcono ekuboniseni ukuguquguquka noma amaphethini ngokuhamba kwesikhathi. Ngakolunye uhlangothi, amashadi ophaya afaneleka kakhulu ukumela idatha emile ngesikhathi esithile.

3. Ukuqhathanisa ne-scatter plots: Iziqephu ze-scatter ziwusizo ekuboniseni ubudlelwano phakathi kweziguquguquko ezimbili noma ngaphezulu eziqhubekayo. Lawa magrafu akuvumela ukuthi ubone amaphethini noma ukuhlobana phakathi kwamanani. Ngokuphambene, amashadi ophaya awafanele ukumela ubudlelwano phakathi kokuhluka, njengoba abonisa kuphela ingxenye yesigaba ngasinye ngokuhlobene naso sonke.

Kafushane, amashadi ophaya alungele ukumela izingxenye zawo wonke, kodwa kubalulekile ukucabangela ezinye izinhlobo zamashadi kuye ngezinjongo nezici zedatha. Ibha, umugqa, namashadi e-scatter angasebenza kangcono ezimweni ezithile, okuvumela ukubonwa okungcono nokuqonda idatha.

14. Iziphetho nezincomo zokugcina zokudala amashadi ophayi ku-Excel 2016

Sengiphetha, ukwenza amashadi ophayi ku-Excel 2016 yi-a indlela ephumelelayo ukubonisa idatha yezinombolo ngendlela ecacile nefingqiwe. Kuso sonke lesi sifundo, sinikeze umhlahlandlela wesinyathelo ngesinyathelo wokuthi ungawakha kanjani amashadi ophaya usebenzisa leli thuluzi elivela ku-Microsoft.

Sincoma ukuthi ulandele lawa macebiso lapho udala amashadi ophaya ku-Excel 2016:

• Hlela idatha yakho ngaphambi kokuthi uqale: Qiniseka ukuthi unayo yonke idatha edingekayo yegrafu futhi uyihlele kuspredishithi se-Excel.
• Sebenzisa amalebula acacile nanembile: Qiniseka ukuthi amalebula esigaba segrafu ayachaza futhi kulula ukuba abafundi bawaqonde.
• Ungalayishi kakhulu igrafu ngolwazi oluningi kakhulu: Gcina igrafu ilula futhi ugweme ukungeza izigaba eziningi ezingenza idatha kube nzima ukuyitolika.
• Lungisa ukufometha kweshadi nesakhiwo: Sebenzisa ukufometha kwe-Excel nezinketho zesakhiwo ukuze wenze ishadi lakho libe ngokwezifiso zakho nezidingo zakho.
• Buyekeza futhi Uhlele: Ngaphambi kokuphothula umfanekiso, buyekeza futhi uhlele zonke izici ukuze uqinisekise ukuthi zilungile futhi zijabulisa ngobuhle.

Kafushane, ukwenza amashadi ophaya ku-Excel 2016 kungaba inqubo elula nephumelelayo uma izinyathelo ezinikezwe kulesi sifundo zilandelwa ngendlela efanele. Ngokulandela lezi zincomo nokuzilolonga ngezibonelo, uzokwazi ukwenza amashadi ophayi angochwepheshe futhi aqondakalayo ukuze wethule idatha yakho ngendlela ebukekayo ekhangayo.

Ngamafuphi, i-Excel 2016 ihlinzeka ngethuluzi elinamandla nelisebenziseka kalula lokudala amashadi ophaya. Ngezinketho ezihlukene nezici ezitholakalayo, abasebenzisi bangakwazi ukwenza ngokwezifiso futhi babone idatha ngempumelelo. Ukusuka ekukhetheni nasekuhleleni idatha kuya ekuhleleni ukwakheka nokwengeza izici ezibukwayo, i-Excel 2016 inikeza ulwazi olunembile nolusebenzayo ekudaleni amashadi ophayi. Ngolwazi olunikezwe kulesi sihloko, abasebenzisi bazokwazi ukusebenzisa lolu lwazi ekuhlaziyeni nasekubikeni kwedatha yabo. Kungakhathaliseki ukuthi amaphrojekthi ochwepheshe noma ezemfundo, ikhono lokudala nokwenza ngendlela oyifisayo amashadi ophaya ku-Excel 2016 liqinisekile ukuthi liyithuluzi elibalulekile lanoma ubani osebenza ngedatha futhi ofuna ukuyikhuluma ngokubona. Njengoba abasebenzisi beqhubeka nokuhlola izinketho nezici ezihlukahlukene ezinikezwa yi-Excel 2016, bazokwazi ukunweba amakhono abo okuphatha idatha nolwazi. Ngohlu olubanzi lwamathuluzi okumela ulwazi ngokubukeka, i-Excel 2016 ingumfelandawonye ophelele walabo abafuna isisombululo esisebenzayo nesinamandla sokwenza amashadi ophaya.