Uyifaka njani ibhokisi yokukhangela kwi-Excel

  • Iibhokisi zokujonga ziphucula intsebenziswano kunye nokufakwa kwedatha kwi-Excel.
  • Zingasetyenziswa kulawulo lomsebenzi kunye noluhlu lokutshekisha.
  • Bakuvumela ukuba ukhethe iinketho ezininzi kwiimvavanyo kunye neefom.
  • Zinokudityaniswa neeseli kwaye zisetyenziswe kwiifomyula zokuhlalutya idatha eguqukayo.

Yintoni ibhokisi yokukhangela kwi-Excel?

I-spreadsheet ye-Microsoft edumileyo yasungulwa kwimarike ngo-1985, kule minyaka iphantse ibe yi-40 yembali iye yavela kakhulu, idibanisa imisebenzi eyenza umsebenzi wethu ngayo ube lula kwaye ngokukhawuleza. Enye yezinto ezintsha zamva nje ezithe yazisa kukusebenza okusivumelayo faka ibhokisi yokukhangela kwi-excel ngamanyathelo nje ambalwa.

Abona basebenzisi rhoqo besi sixhobo seofisi bebecela iMicrosoft ukuba ibandakanye into efana nale iminyaka kwaye, ekugqibeleni, umnqweno wabo uye waneliswa. Makhe sibone ukuba isebenza njani.

Yintoni ibhokisi yokukhangela kwi-Excel?

Yintoni ibhokisi yokukhangela kwi-Excel?

Luhlobo lolawulo olusebenzisanayo oluvumela thina abasebenzisi ukukhetha okanye ukungakhethi ukhetho. Ukubona kakhulu, iphucula intsebenziswano kunye ne-spreadsheet kwaye iququzelele ukungena kwedatha.

Sinokuyinxulumanisa neeseli ezithile ukubonisa isimo sazo, esisinceda xa sisenza izibalo kunye nohlalutyo olusekelwe kukhetho lwethu. Ukuba sisebenzisa i-Excel njengesixhobo sokuphucula imveliso yethu, singasebenzisa le bhokisi yokukhangela ukuqaqambisa imisebenzi egqityiweyo nikubone kakuhle oko kuseza kwenziwa.

Le bhokisi ayisiyonto intsha ngokwenene kwi-Excel, okwenzekayo kukuba kude kube ngoku yayifumaneka kuphela kwimo yomphuhlisi, ngoko ke ukuyingena kwi-spreadsheet yayingeyonto eyayifumaneka kumntu wonke. Ngethamsanqa, oko akusekho.

Uyifaka njani ibhokisi yokukhangela kwi-Excel ngendlela yakudala

Uyifaka njani ibhokisi yokukhangela kwi-Excel ngendlela yakudala

Ukuba ufuna ukwazi ukuba bekufuneka kwenziwe njani kude kube ngoku, ukwandisa ulwazi lwakho malunga ne-Microsoft spreadsheet, siya kuphendula umbuzo wakho.

Amanyathelo amawathathwe ngala:

Yenza ithebhu "yoMphuhlisi".

Ukuba awunayo kufuneka ulandele indlela:

  • Uvimba.
  • Khetha
  • Lungiselela iribhoni.
  • Khangela ibhokisi “Umphuhlisi” kwaye ucofe ku "Ukwamkela".

Faka ibhokisi yokukhangela

Ukusuka kwi "Developer" ithebhu landela indlela:

  • Faka.
  • Ibhokisi yokujonga.
  • Cofa kwiseli ofuna kuvele kuyo.

Nxulumanisa ibhokisi yokukhangela kwiseli

Cofa ekunene kwibhokisi yokukhangela kwaye ukhethe "Ifomati yokulawula", kwithebhu ye "Ulawulo" Yiya kwindawo ethi "Ikhonkco kwiseli", faka ireferensi yeseli ekuthethwa ngayo uze ucofe "Ukwamkela".

Uyifaka njani ibhokisi yokukhangela kwi-Excel ngenkqubo entsha

Uya kubona ukuba ngoku oku kukhawuleza kwaye kulula, kwaye kuyafumaneka kuye nabani na. Kuya kufuneka ukhethe iseli ofuna ukusebenza kuyo kwaye uvule imenyu ethi "Faka" kwaye emva koko ucofe ku "Checkbox". Ngokwenza nje oku, Sele unayo ibhokisi yakho engenanto kwiseli ebonisiweyo.

Ukuba awuyiboni olu khetho kuguqulelo lwakho lwe-Excel, ungakhathazeki, kuba lusaphuma kubo bobabini abasebenzisi beWindows kunye neMacOS. Kulindeleke ukuba ekupheleni kukaJulayi sonke sibe nako ukonwabela lo msebenzi mtsha. Kwimeko ye Iinguqulelo ze-Excel zewebhu kunye neselfowuni Kusaza kufuneka silinde ixesha elidana.

Ukuba into onayo yinguqulelo ye-Excel ngaphandle kwe-Microsoft 365, njengaleyo yayiyinxalenye yeephakheji ze-Ofisi ye-Microsoft endala, ngoko awuyi kulufumana olu hlaziyo, kwaye kuya kufuneka faka ibhokisi yokukhangela kwi-excel ngenkqubo ebesikuchazele ngaphambili.

Ukusetyenziswa kwebhokisi yokukhangela kwi-Excel

Ukusetyenziswa kwebhokisi yokukhangela kwi-Excel

Inyaniso kukuba le bhokisi inokuba luncedo kakhulu kumanqanaba ahlukeneyo, makhe sibone ukuba ungenza ntoni ngayo:

Ulawulo lomsebenzi kunye noluhlu lokutshekisha

Unokwenza uluhlu apho iseli nganye imele umsebenzi kwaye ubeke ibhokisi kuzo eya kukunceda ulandele inkqubela yoko usalindileyo.

Ukusebenzisana kwiifom

Ukuba usebenzisa i-spreadsheet ukwenza uphando okanye iifomu (nangona sele usazi ukuba iMicrosoft inesixhobo esithile soku: Iifomu zeMicrosoft), iibhokisi zokukhangela zivumela Abasebenzisi bakhetha iinketho ezininzi ngokukhawuleza nangokulula.

Imiqathango kunye neefomula

Iibhokisi zokujonga ezidityaniswe kwiiseli nazo zingasetyenziswa kwiifomula zokutshintsha iziphumo ezisekelwe kukhetho lomsebenzisi. Umzekelo, singenza a Ifomula ishwankathela amaxabiso kuphela xa ibhokisi yokukhangela ikhangelwe.

Uhlalutyo lwedatha

Esi sixhobo sinokukunceda ukucoca idatha okanye usebenze okanye uvale isethi yedatha ethile, ikuvumela ukuba wenze umsebenzi onzima kunye nohlalutyo olupheleleyo.

Ukuzenzekela ngeemakhro

Ezi bhokisi zingasetyenziswa ngokubambisana ne-VBA macros (ISiseko esiBonakalayo sosetyenziso), ukuze imisebenzi ethile yenziwe ngokuzenzekelayo kuxhomekeke ekubeni iibhokisi zikhangelwe okanye hayi.

Izicelo ezisebenzayo

Sikushiyela iimbono onokuzisebenzisa ngazo iibhokisi zokukhangela kwi-spreadsheets:

  • Ulawulo lweeprojekthi. Ungasebenzisa iibhokisi ukubona ukuba imisebenzi iqhubela phambili kangakanani, kwaye udale itshathi yeGantt esebenzayo.
  • Uvavanyo kunye neefom. Ungazisebenzisa ukwenza iintlobo ezahlukeneyo zophando kwaye emva koko uhlalutye ngokukhawuleza iziphumo ngokusekelwe kwiimpendulo ezikhethiweyo.
  • Ukulandelela uluhlu. Ukuba uneshishini elincinci, le yindlela eluncedo nelula yokulawula izinto eziyinxalenye yesitokhwe. Ungayisebenzisa kwakhona ukulandelela idatha yokuthengisa.
  • Uluhlu lokuthenga olusebenzayo. Zininzi iindlela zokwenza Ukufumana okuninzi kubhaliso lweMicrosoft 365 kubomi bakho bemihla ngemihlaUmzekelo, ukusebenzisa iibhokisi zokutshekisha kwi-Excel ukwenza uluhlu lokuthenga olusebenzisanayo, okanye uluhlu lwezinto ekufuneka uzithathe kuhambo lwakho olulandelayo.
  • Inkqubela kuphononongo. Unokusebenzisa iibhokisi ukucwangcisa izifundo okanye imisebenzi elindileyo ukuyenza kwaye ulandelele inkqubela yakho ngexesha lokwenyani, eliya kukuvumela ukuba uphucule imveliso yakho.

Ukwazi indlela yokufaka ibhokisi yokukhangela kwi-Excel kuya kuba luncedo kakhulu kuba, njengoko ubonile, kuvela ukuba sisixhobo esiluncedo kakhulu xa usebenza ngedatha kwaye xa usebenzisa i-spreadsheet kwiinjongo ezininzi zasekhaya okanye zomntu.


Shiya uluvo lwakho

Idilesi yakho ye email aziyi kupapashwa. ezidingekayo ziphawulwe *

*

*

  1. Uxanduva lwedatha: UMiguel Ángel Gatón
  2. Injongo yedatha: Ulawulo lwe-SPAM, ulawulo lwezimvo.
  3. Umthetho: Imvume yakho
  4. Unxibelelwano lwedatha: Idatha ayizukuhanjiswa kubantu besithathu ngaphandle koxanduva lomthetho.
  5. Ukugcinwa kweenkcukacha
  6. Amalungelo: Ngalo naliphi na ixesha unganciphisa, uphinde uphinde ucime ulwazi lwakho.