Yintoni kunye nendlela yokusebenzisa ukufomatha okunemiqathango kwi-Excel?

ukugqwesa ukufomatha okunemiqathango

Ukufomatha okunemiqathango kwi-Excel lukhetho olunokusinceda soyise ulwazi oluphakanyiswa yi-spreadsheet ngendlela enobuhlobo kakhulu.. Amaxwebhu e-Excel ahlala egcwele izibalo kunye namanani aya kubonwa okanye ahlalutywe nguwe okanye abanye, ngoko kuya kuba kuhle ukuba nenye indlela esivumela ukuba sikhawulezise le nkqubo. Isixhobo seMicrosoft siphawulwe ngokubandakanya imisebenzi emininzi evumela nantoni na ukuba yenziwe ngokukhawuleza ukuya kwi-automation. Ke ngoko, namhlanje siza kukubonisa yonke into ekufuneka uyazi ukuze uqale ukusebenzisa ifomathi enemiqathango emsebenzini wakho.

Ngale ndlela, uya kuba nakho ukonyusa ukuba luncedo kwetafile yakho ye-Excel kwaye ugcine ixesha elininzi kwimisebenzi yokuqaqambisa ulwazi kunye nohlalutyo.

Yintoni ukufomatha okunemiqathango kwi-Excel?

I-Excel yinkqubo egcwele izixhobo ezingagubungeli kuphela indawo yokubala, kodwa nokuba yintoni ebhekiselele kwifomathi kunye nendlela idatha kunye nolwazi olubekwe ngayo kwiphepha.. Le yokugqibela ibalulekile, kujongwe ukuba iincwadi zokusebenza ze-Excel aziqhelekanga ukugcinwa ukuze zizityele, kodwa zithunyelwa ngokubanzi kwabanye abantu ukuze zihlolwe kwaye zihlalutywe. Ngelixa usenza oku kokugqibela, kuqhelekile ukuba amanani athile agxininiswe ngokuxhomekeke kwizinto ezijongwayo, nangona kunjalo oku kukwavula ucango lwempazamo yomntu. Sinokuphoswa lula sisisele esibalulekileyo okanye siphawule leyo ingahlangabezaniyo nale nto siyifunayo.

Ukuphelisa le ngxaki, ifomathi enemiqathango ibonakala kwi-Excel, leyo, njengoko igama layo libonisa, ivumela ukuba sifomethe iseli okanye uluhlu lweeseli, ngokuzalisekisa imeko ethile.. Umzekelo, ukuba eyona njongo incinci yokuthengisa ishishini lakho yi-500 €, phawula iiseli ezinamanani angafikeleli kweli nani ngombala obomvu. Ngale ndlela, iphepha le-Excel liza kuthetha ngokwalo ngale khowudi yokufomatha oyibekele iindawo eziphambili.

Usetyenziso onokuthi ulunike kulo msebenzi luninzi kwaye njengoko besitshilo ngaphambili, luya kunika into eluncedo kakhulu kwispredishithi.. Ukuqhubela phambili nomzekelo wokuthengisa, ukuba udibanisa utshintshiselwano ngalunye losuku kwaye usebenzise ifomathi enemiqathango kwiseli ebonisa inani elipheleleyo, liya kutshintsha umbala nje xa ufikelela kumgomo omncinci. Oku kusebenza njengesalathisi esibonakalayo esinomtsalane kuxwebhu olulula lwe-Excel.

Izinto zofomatho olunemiqathango

Indawo yefomathi enemiqathango kwi-Excel ibanzi kakhulu kwaye kufanelekile ukuyazi ukuba uthathe ithuba lokhetho olubandakanyayo kwaye olusinika ithuba lokunika ubomi kwi-spreadsheet yethu. Nangona kunjalo, sinokuthi ukusetyenziswa kwayo kulula ngokwenene kwaye kwanele ukwazi izinto zayo ezintathu eziphambili ukuba uqhelane nayo ngokupheleleyo. Ezi zezi: imiqathango, imithetho kunye neefomathi.

Iimeko

Imeko ayikho enye into ngaphandle kwento esiyisebenzisayo njengesalathiso sokuchaza ukuba kukho into eza kwenzeka okanye hayi.. Umzekelo, ukuba kunetha, ndiya kuthatha iambrela, oku kuthetha ukuba ukuthatha iambrela kunombandela wokuba kunetha. Kwenzeka okufanayo kwi-Excel kunye nefomathi enemiqathango, imeko isekelwe ekubeni iseli inenombolo ethile, isicatshulwa okanye umhla kwaye ukuba kunjalo, kuya kusetyenziswa umgaqo.

Imigaqo

Imithetho yileyo imisela okuya kwenzeka ukuba imeko echazwe ngaphambili ihlangatyeziwe.. Ukuqhubela phambili nomzekelo wesambulela, umgaqo kule meko kukuthabatha kunye nawe, ukuba kunetha. Ngaloo ndlela, ukuba sithatha kwi-Excel, umgaqo uya kubonisa ifomathi eya kusetyenziswa kumgaqo xa imeko idibene.

Ifomathi

Ngaphakathi kweofisi yeMicrosoft suite, iifomati zimele yonke into enxulumene nobuhle kunye necandelo lokubonwayo kuxwebhu esisebenza kulo. Oku kuvela kwifonti, ukuya kubungakanani bayo, umbala kunye nombala ongasemva, ngoko ukufomatha okunemiqathango akukho nto ngaphandle kwesixhobo esikuvumela ukuba usebenzise konke oku, ngokusekelwe kwimiqathango kunye nemigaqo esiyichazile ngaphambili.

Ulusebenzisa njani ulungiselelo olunemiqathango kwi-Excel?

Amanyathelo okusebenzisa ufomato olunemiqathango olusisiseko

Ukuba sele unombono wokusebenzisa ukufomatha okunemiqathango kwiphepha lakho le-Excel, kuya kufuneka wazi ukuba ukwenza oko kulula kakhulu. Ukuqalisa, kufuneka kuqala sikhethe iseli okanye uluhlu lweeseli esifuna ukuzifomatha ngokwemeko ethile. Emva koko cofa ku «Ifomathi enemiqathango"kwaye uye ku"IMithetho yeSeli", eya kubonisa lonke uluhlu lweenketho onokuzisebenzisa. Ezi zisusela ekuchongeni amaxabiso amakhulu, amancinane okanye alinganayo, ukuya kwimibhalo nakwimihla.

ufomato olunemiqathango olusisiseko

Ngokucofa, umzekelo, kwi «Ndala kuno", ifestile encinci ye-popup enemihlaba emibini iya kuboniswa. Kweyokuqala, kuya kufuneka ufake ireferensi yereferensi kwaye okwesibini uya kuba nakho ukukhetha phakathi kweefomati ezininzi ezichazwe kwangaphambili okanye ukongeza isiko.

Isalathiso kunye noMthetho

Ekugqibeleni, cofa ku «ukwamukela» kwaye yiloo nto ke, ngoku amanani amakhulu kunelo ubulibonisile ngaphambili liza kuphawulwa ngefomathi ekhethiweyo.

UkuFomatha okuneMiqathango kunye nee-Icons

Kuyafaneleka ukuba uqaphele ukuba ukufomatha okunemiqathango akusebenzi nje kuphela ngokutshintsha umbala wokuzalisa weeseli kunye nabalinganiswa, kunokwenzeka kwakhona ukubonisa ii-icon endaweni yemibala yakudala. Oku kunomdla kakhulu kuba kwandisa amandla onxibelelwano kunye nohlalutyo lwe-Excel sheet, ikwenza kube lula ukuqaphela okwenzekayo ngento nganye.

Ukusebenzisa olu hlobo lokufomatha okunemiqathango, siza kuqala ngokukhetha iseli okanye ifomathi yeseli ofuna ukuyifomatha. Emva koko cofa ku «Ifomathi enemiqathango«, yiya kwicandelo lemithetho kwaye ukhethe oko ufuna ukuseta imeko ukuba ihlangatyezwe.

UkuFomatha okuneMiqathango kunye nee-Icons

Emva koko cofa kwakhona kwi "Ifomathi enemiqathango"kodwa, ngeli xesha yiya ku"i icon iseti» kwaye emva koko ukhethe lowo uyifunayo.

UkuFomatha okuneMiqathango kunye nee-Icons

Ngoko nangoko, uya kubona ukuba zivela njani kwicala lasekhohlo leseli nganye ngombala ozichazayo.

UkuFomatha okuneMiqathango ngeBar yeDatha

Ngendlela efanayo esisebenzisa ngayo ii-icon okanye imibala yeeseli, sinokusebenza kunye neebar zedatha. Oku kuluncedo ngakumbi ukuba sivelisa amanani afanele athelekiswe nabanye. Imivalo yedatha iya kusivumela ukuba sibe nendlela ebonakalayo ecacileyo kakhulu kule thelekiso, okwenza ulwazi lufikeleleke ngakumbi.

Ukuba ufuna ukusebenza ngeebha zedatha kwi-Excel yokufomatha ngokwemiqathango, kufuneka ulandele la manyathelo ebesixoxe ngawo ngasentla. Oko kukuthi, khetha iseli okanye uluhlu lweeseli, cofa ku «Ifomathi enemiqathango» kwaye ukhethe umthetho ofuna ukuwusebenzisa kwiMithetho yemenyu. Emva koko, phinda inkqubo ngokuya ku “Ifomathi enemiqathango"kwaye ke ngenisa"imivalo yedatha»ukukhetha uhlobo lwebar ofuna ukuyongeza. Xa uyicofa, ziya kuba sele zongezwe kwi-spreadsheet sakho.

Njengoko sibona, ukufomatha okunemiqathango kuyamangalisa ngokwenene okuya kuphucula i-spreadsheet yakho, ukusebenzisa kwakho i-Excel, kunye nomsebenzi wokugqamisa idatha kunye nokwenza uhlalutyo. Lukhetho olulula ngokwenene ukulisebenzisa, ngoko kufanelekile ukuzama kuyo nayiphi na incwadi yakho ye-Excel.


Yiba ngowokuqala ukuphawula

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.