/ Ungalwenza kanjani uhlu olwehlayo ku-Excel

I-Microsoft Excel

Uma sikhuluma ngamaspredishithi, kufanele sikhulume nge-Excel, isicelo esangena emakethe ngo-1985, kepha asizange sibe yisethenjwa emakethe kuze kube ngu-1993, lapho sidlula iLotus-1-2-3 enamandla onke. Namuhla i-Excel iyi- kuhlanganiswe ndawonye futhi akunakwehlukaniswa ku-Office 365.

Eminyakeni edlule, i-Excel ithuthuke kuphela, inikezela ngezixazululo eziningi, izixazululo kuzo zombili izinkampani nabantu ngabanye. Omunye wemisebenzi esinikeza yona, kokubili abasebenzisi nezinkampani, kungenzeka dala uhlu lokwehla, umsebenzi owusizo kakhulu esifundisa wona ngokulandelayo.

I-Excel iyatholakala kuwo womabili amaWindows ne-MacOS nange-Web, ngezihumusho ezigcwele. Yize kuliqiniso ukuthi sinenguqulo etholakalayo yamadivayisi eselula, lokhu akuphelelanga kangako njengaleyo esingayithola kuzinguqulo zedeskithophu. Izinyathelo okufanele zilandelwe ukudala uhlu olwehlayo ku-Excel ziyefana ku-Windows, i-MacOS nangezinguqulo zeWebhu.

Noma zingadalwa kuphela ngezinguqulo zedeskithophu ze-Excel, lezi kungaboniswana futhi kuhlangatshezwane nanoma iyiphi inguqulo ye-Excel, kufaka phakathi inguqulo encishisiwe iMicrosoft esinikeza yona ngohlelo lweHhovisi lwamaselula, uhlelo olumahhala ngokuphelele.

Yini uhlu lokudonsela phansi

Uhlu lokudonsela phansi lwe-Excel

Uhlu lokuya phansi, luyasivumela khetha ohlwini lwezinketho inketho eyodwa kuphela, ngaphandle kokunye. Lolu hlobo lohlu lusivumela ukuthi sisebenzise amanani azenzakalelayo ukugwema ukungena kwedatha eyiphutha noma ngamaphutha esipelingi (okusivumela ukuthi senze izihlungi ezithile zokusesha).

Ezinkampanini, lolu hlu lukuvumela ukuthi uhlele futhi uphathe imisebenzi yakho yansuku zonke kanye nokuphathwa ngendlela esebenza kahle kakhulu, kanye nokunikeza ukuthintwa kobungcweti okungaze kulimaze. Inani lohlu lokudonsela phansi esingalwakha alunamkhawulo, ukuze sikwazi ukwakha ibhokisi lohlu lwamaseli ngayinye eshidini.

Imigqa - amathebula we-pivot ku-Excel
I-athikili ehlobene:
Ungayenza kanjani ithebula le-pivot ku-Excel ngaphandle kwezinkinga

Lezi zinhlobo zohlu zilusizo kakhulu lapho kwenziwa ama-invoice (lapho umqondo ngamunye wehlukile kowedlule), ukulandelela ukuvakashelwa, dala yolwazi ukusebenzisa izihlungi ngokwezifiso lokho kusivumela ukuthi silawule amasheya ezinqolobaneni ... Uma usufinyelele le ndatshana, kungenzeka ukuthi ucace ngokusetshenziswa ohlose ukukunika lo msebenzi omuhle we-Excel.

/ Ungazakha kanjani izinhla zokwehla ku-Excel

Uhlu lokudonsela phansi luthola idatha kusuka kumatafula okufanele siwakhe ngaphambili ukuze siwasebenzise njengomthombo. Uma inhloso yeshidi sifuna ukudala uhlu lokudonsela phansi ukuliphrinta, kufanele setha umthombo wedatha kwelinye ishidi elihlukile, ishidi esingalibiza ngokuthi iDatha.

Njengoba ngishilo ngenhla, eshidini elifanayo singenza uhlu olungenamkhawulo lokudonsela phansi, ngakho-ke uma singafuni ukudala ishidi lomthombo ngamunye wedatha, singasebenzisa ishidi elifanayo, ngaphandle kokukhipha idatha esiyisebenzisile njenge umthombo wohlu esesivele silwenzile. Lapho nje sesicacile ukuthi zisebenza kanjani, sikukhombisa izinyathelo okufanele uzilandele dala uhlu lokudonsela phansi ku-Excel.

Dala umthombo wedatha

Umthombo wedatha ye-Excel

Into yokuqala okufanele siyenze ukudala umthombo wedatha, idatha esetshenziselwa ukudala uhlu lokudonsela phansi. Uma singazange kudala le datha, uhlu olwehliswayo ngeke babe nalutho abalukhombisayo. Ukwakha umthombo wedatha, sivula ishidi elisha ku-Excel, chofoza kabili egameni bese sizoliqamba ngokuthi iDatha.

Ukuze singazibandakanyi nokuthi yimiphi imithombo yedatha yohlu ngalunye lokwehla esifuna ukukwenza, kufanele sibhale njengenani lokuqala igama lohlu, noma ngabe amadolobha, amamodeli, amazwe, izingubo ... Uma sizokwakha uhlu kuphela, akudingekile ukubhala igama esitokisini sokuqala.

Okulandelayo, kufanele sibhale zonke izinketho esizifunayo ayaboniswa ohlwini olwehliswayo, enye engezansi kwenye kukholomu efanayo ukwenza kube lula ukukhetha umthombo wedatha. Lapho nje sesenze umthombo wedatha, singakha uhlu lokudonsela phansi.

Dala uhlu lokudonsela phansi

Uhlu lokudonsela phansi lwe-Excel

  • Okokuqala sikhetha amaseli lapho sifuna ukuthi uhlu olwehliswayo luboniswe.
  • Okulandelayo, chofoza inketho yeDatha (hhayi ishidi) kubhebhe. Ngaphakathi kokukhethwa kukho, chofoza ku Ukuqinisekiswa kwedatha.

Setha uhlu ku-Excel

  • Ngaphakathi kwethebhu Yokucushwa> Indlela yokuqinisekisa> Vumela sikhethe Uhlu.
  • Okulandelayo siya ebhokisini le-Origin bese uchofoza isithonjana ekugcineni kwebhokisi ku khetha ububanzi bamaseli lapho kutholakala khona idatha.

Amaseli lapho kutholakala khona amabanga we-Excel

  • Okulandelayo, chofoza ku-Data sheet bese sikhetha ububanzi bamaseli lapho kutholakala khona idatha, kushiya igama leseli elisivumele ukuthi sikhombe le datha. Lapho sesikhethe ibanga ledatha, sicindezela u-Enter.

Excel

  • Sesivele sidale uhlu lwethu lokuqala lokwehla ekhasini elikhulu le-Excel. Kuwo wonke amaseli esiwakhethile ukukhombisa uhlu lokudonsela phansi, manje sekukhonjisiwe umcibisholo oya phansi osimema ukuthi sicindezele kuwo khetha kuzo zonke izinketho lokho esikusungule ngaphambilini kuDatha sheet.

Lapho sesenze uhlu lokuqala lokudonsela phansi, kufanele yenza inqubo efanayo ukudala lonke uhlu olwehlayo esilifunayo noma esiludingayo.


Yiba ngowokuqala ukuphawula

Shiya umbono wakho

Ikheli lakho le ngeke ishicilelwe. Ezidingekayo ibhalwe nge *

*

*

  1. Ubhekele idatha: I-Actualidad Blog
  2. Inhloso yedatha: Lawula Ugaxekile, ukuphathwa kwamazwana.
  3. Ukusemthethweni: Imvume yakho
  4. Ukuxhumana kwemininingwane: Imininingwane ngeke idluliselwe kubantu besithathu ngaphandle kwesibopho esisemthethweni.
  5. Isitoreji sedatha: Idatabase ebanjwe yi-Occentus Networks (EU)
  6. Amalungelo: Nganoma yisiphi isikhathi ungakhawulela, uthole futhi ususe imininingwane yakho.