UMicrosoft uphucula umsebenzi wokukhuphela kunye nokuncamathisela kwi-Excel

UMicrosoft uphucula umsebenzi wokukhuphela kunye nokuncamathisela kwi-Excel

Umsebenzi wokukhuphela kwaye uncamathisele kwi-Excel Yinto yakudala enokusigcina ixesha elininzi, kwaye iphinde ithintele iimpazamo eziqhelekileyo esinokuthi sizenze xa sibhala idatha isuka kwenye iseli ukuya kwenye. Ukuba ungumsebenzisi walo msebenzi, uya kuvuya ukwazi ukuba uphuculo lufikile.

IMicrosoft igxile kakhulu kuphuhliso lwe-AI, kodwa oko akuthethi ukuba ishiya ecaleni iinkqubo zayo zokusebenza okanye izixhobo zayo zeofisi. Ke ngoko, iyaqhubeka ukusothusa ngophuculo kunye neempawu ezintsha.

Ingaba umsebenzi wokukopa kunye nokuncamathisela kwi-Excel uquka ntoni kwaye ikunceda njani?

Ingaba umsebenzi wokukopa kunye nokuncamathisela kwi-Excel uquka ntoni kwaye ikunceda njani?

Ngaphakathi iindlela ezimfutshane zokucofa esinokuthi sisebenzise Windows, ukusika okanye ukukopa kwaye uncamathisele yenye yezona zidumileyo kwaye yenye yezona ziluncedo.

Kwimeko ethile ye-Excel, sithetha ngenqaku elisivumela ukuba sithathe idatha ukusuka kwindawo enye ukuya kwenye kwi-spreadsheet:

  • Sika. Xa ukhetha ukhetho "lokusikwa", idatha ekhethiweyo iyanyamalala kwindawo yayo yokuqala kwaye ikhutshelwe kwibhodi eqhotyoshwayo yenkqubo yokusebenza.
  • Khuphela. Ikhuphela idatha ekhethiweyo kwibhodi eqhotyoshwayo, kodwa ihleli kwiseli yoqobo.
  • Cola. Ezo datha sizisikileyo okanye sizikhuphele zincamatheliswa ngokuthe ngqo kwibhodi eqhotyoshwayo ukuya kwindawo esiyikhethileyo. Kwaye bayanyamalala kwibhodi eqhotyoshwayo.

Lo msebenzi uyasivumela kunokuba luncedo olukhulu xa sisebenza nge-spreadsheet. Ngenxa yokuba isebenza:

Lungisa kwakhona idatha

Ukuba ufuna ukucwangcisa ngokutsha imiqolo okanye iikholamu zedatha, okanye utshintshe ulandelelwano, yenza ngokulula a "umsiki wentonga" yedatha. Kwimizuzu embalwa uya kube ulungile yonke into, ngaphandle kokuhamba kwinkqubo edinayo yokuchwetheza kwakhona ulwazi ofuna ukutshintsha indawo.

Hambisa idatha phakathi kwespredishithi

Ngomsebenzi wokukhuphela kunye nokuncamathisela kwi-Excel singathatha idatha kwi-spreadsheet ukuya nakweyiphi na enye, ukuba nje ingaphakathi kwincwadi enye.

Nciphisa iimpazamo

Okukhona uphinda uphinda uvelise intwana yolwazi, ngakumbi ukuba ingumzobo, kokukhona kunokwenzeka ukuba wenze impazamo kwaye iziphumo zokugqibela zingahambelani noko ubulindele ukukufumana.

Ukuba endaweni yokwenza ushicilelo ngesandla sisebenzisa i windows imiyalelo ukusika okanye ukukopa kwaye uncamathisele kwi-Excel, uyawunciphisa loo mngcipheko.

Khuphela kwaye uhambise iifomyula

Abantu abaninzi abangabasebenzisi be-Excel abaphambili abayazi, kodwa umsebenzi wokusika okanye ukukopa kunye nokuncamathisela wenza okungakumbi kunokuhambisa idatha ukusuka kwiseli enye ukuya kwenye. Kwakhona Ikuvumela ukuba uhambise iifomula ngaphakathi kwespredishithi. Into eluncedo kakhulu xa ufuna ukuhlengahlengisa iifomyula ezintsonkothileyo okanye kufuneka uzikhuphele ukusuka kwenye iseli ukuya kwenye ukuze uqhubeke usebenza nazo.

Lungisa kwakhona izinto zegraphic

Ukuba ufake iitshathi, imifanekiso, okanye ezinye izinto ezibonwayo kwispreadsheet sakho, unokuzisusa ngokulula ukusuka kwenye indawo ukuya kwenye ngalo msebenzi.

Yeyiphi impucuko uMicrosoft asinika yona ngoku kukopi kunye nokuncamathisela umsebenzi kwi-Excel?

Yeyiphi impucuko uMicrosoft asinika yona ngoku kukopi kunye nokuncamathisela umsebenzi kwi-Excel?

Njengoko sibonile, eyona njongo iphambili yalo msebenzi kukugcina ixesha kunye neempazamo ezinokwenzeka, kwaye uhlaziyo olusandula ukufika luya kwelo cala. Kuba into efunwa nguMicrosoft kukuba sikwazi ukusebenza ngendlela ethe kratya, ukuphelisa inani lokucofa okufunekayo ukuze usebenze kwi-Excel yewebhu.

Abasebenzisi sele beqaphela ukusebenza okuphuculweyo kokutsala kunye nokulahla, okwenza kube lula ukukhetha kunye nokuhambisa imiqolo kunye neekholamu. Yiyiphi Iyasisindisa ekubeni sicofe kwiindawo ezahlukeneyo kwaye yenza lula kwaye ikhawulezise inkqubo.

Oku akukuphela kophuculo, abanye sele befikile, kwaye zonke zisetyenziswa ngokuzenzekelayo, ngaphandle kwesidingo sokuba wena njengomsebenzisi ufake nantoni na:

  • Kugqityiwe ngokuzenzekelayo. Isixhasi sikuvumela ukuba wongeze idatha kwiseli kwaye ube nolwazi oluzisongele ngokuzenzekelayo kwiiseli ezinxulumeneyo.
  • Cola. Ngoku, xa ukhuphela idatha, i-icon ye-pop-up ivela kunye neendlela ezahlukeneyo zokuncamathisela ezikhoyo. Oku kuluncedo kakhulu xa sisebenza ngeefomula.
  • Ukulawula idatha. I-Excel kwiwebhu ngoku ikunikeza ukhetho lwe "Iifomula kuphela", "iFomathi kuphela" kunye "nexabiso kunye nefomathi", ukuze njengomsebenzisi ube nolawulo olukhulu kwidatha.

Ngaphandle kophuculo olutsha lomsebenzi wokukhuphela kunye nokuncamathisela kwi-Excel, sinokwenza le nkqubo ngokusebenzisa indlela emfutshane yebhodibhodi. Cofa kuluhlu lweeseli ofuna ukuzikopa kwaye ucinezele Ctrl + C (Umyalelo + C ukuba usebenza kwiMac). Ukuncamathisela, khetha iseli okanye uluhlu lweeseli kwaye ucinezele Ctrl + V (Umyalelo + V ovela kwiMac).

Amaqhinga okufumana ngakumbi kwi-Excel

Amaqhinga okufumana ngakumbi kwi-Excel

Ukuba ufuna ukufumana ngakumbi kwisixhobo sespredishithi sikaMicrosoft, nikela ingqalelo kula maqhinga:

Khetha zonke

Ukuba ufuna ukukhetha yonke imixholo yespreadsheet ukuze usike okanye uyikopishe kwaye uyincamathisele kwenye indawo, cofa kwi icon ebonakala kwikona ephezulu ngasekhohlo yoxwebhu. Ekunene phakathi kuka-“A” kwikholamu kunye nenani loku-1 kumqolo.

Khipha idatha kwiPDF

Ukuba bakuthumela uxwebhu lwePDF kunye netafile ekufuneka usebenze nayo kwi-Excel, akufuneki uyikhuphele ngesandla, zama eli qhinga:

  • Vula i-Excel sheet engenanto.
  • Cofa kwi "Data" tab kwaye emva koko "Fumana ulwazi".
  • Khetha ukhetho "Ukusuka kwifayile."
  • Ukuba ukhetho "Ukusuka kwiPDF" luvela, khetha le ngqo. Ukuba ayiveli, sebenzisa "Ukusuka kwisicatshulwa/CSV".
  • Khetha uxwebhu lwePDF olunetafile onomdla kuyo.
  • Cofa kabini kwigama lefayile kwaye ucofe "kwindawo"Itheyibhile”.
  • Ukuba imboniso ichanekile, cofa kabini "Itheyibhile".
  • Pulsa “Vala ulayishe”

Emva koku kufuneka ngoku ube netafile kwi-spreadsheet sakho.

Ukukhuselwa kwamaphepha kunye neeseli

Ukuba kukho abantu abaninzi abasebenza kuxwebhu olufanayo, unokukhusela ulwazi kutshintsho olungafunwayo.

  • Cofa ekunene kwithebhu yephepha ukukhusela, emazantsi efestile ye-Excel.
  • Khetha "Khusela iphepha".
  • Ibhokisi yencoko yababini iyavela apho unokuseta khona igama lokugqitha.
  • Khetha ukuba zeziphi iintshukumo zohlengahlengiso eziya kuvunyelwa kwiphepha.
  • Cofa apha "Ukwamkela".

Zininzi iindlela zokusebenzisa i-spreadsheets kwaye uzisebenzise ngokukhawuleza nalula. Ngaphandle kwamathandabuzo, utshintsho kumsebenzi wokukhuphela kunye nokuncamathisela kwi-Excel kwenza ukusebenzisa esi sixhobo seofisi kube lula ngakumbi.


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.