Iingcebiso ezi-5 eziphezulu zeMicrosoft Excel kunye namaqhinga kwiOfisi 365
Nokuba usebenza kwi-accounting, ugcwalise ii-invoyisi, okanye uqhubekisa nje amanani athile, iMicrosoft Excel yinkqubo eluncedo kakhulu kumashishini nakubathengi ngokufanayo. Nangona kunjalo, ngokungafaniyo nezinye iinkqubo ze-Ofisi 365, i-Excel igxile kakhulu kwidatha, enokuthi yoyike kwabanye. Ungakhathazeki, kuba ngoku sikunika ujongo kwiingcebiso zethu ze-Excel esizithandayo kunye namaqhinga kwi-Ofisi 365. Ezi ngcebiso kunye namaqhinga akayi kukugcina ixesha kuphela kodwa anokwenza lula izinto kwaye akuncede ube yingcali ye-Excel.
Sebenzisa iindlela ezimfutshane
Ngokufana nezinye iinkqubo zeOfisi 365, kukho inani leendlela ezimfutshane ezinokuthi zisetyenziswe kwi-Excel.
Xa ujongana namanani kunye neespredishithi ezinokufikelela phantse kwiikholamu ezingapheliyo kunye nemigca, ezi ndlela zimfutshane zinokuphela zikongela ixesha kunye nentloko.
Siqokelele ezinye zezinto esizithandayo .
- CTRL + Faka: ukuphinda okubhaliweyo. Cofa kulo lonke iqela leeseli kwaye emva koko uchwetheze into ofuna ukuyiphinda kwiseli yokugqibela, emva koko ucinezele Ctrl + Faka. Into oyibhalileyo iya kwiseli nganye..
- I-ALT + F1: Sebenzisa le ndlela imfutshane ukwenza iitshathi kwiphepha elifanayo njengedatha yakho. Ngokufanayo, ukucinezela F11 Ukwenza itshati kwiphepha elahlukileyo
- Shift+F3 Sebenzisa le ndlela imfutshane ukufaka umsebenzi
- Alt + H + D + C: Sebenzisa le ndlela imfutshane ukucima ikholamu
- U-Alt + H + B: Sebenzisa le ndlela imfutshane ukongeza umda kwiseli
- Ctrl + Shift + $: Sebenzisa le ndlela imfutshane ukusebenzisa ifomathi yemali
- Ctrl + Shift + %: Sebenzisa le ndlela imfutshane ukufaka ifomathi yepesenti
- Ctrl + Shift + &: Sebenzisa le ndlela imfutshane ukufaka imida yolwandlalo
- I-F5: Sebenzisa le ndlela imfutshane ukuya kwiseli. Vele uchwetheze F5 kwaye ufomethe iseli okanye igama leseli
Zama imisebenzi ye-IFS Boolean yokuphelisa isidingo sefomula eyakhiwe
IFS ngumsebenzi wasekhaya owaziwa ngokuba “Ukuba, le, ke, kwaye leya.”. Oku kusetyenziswa ngabahlalutyi kwihlabathi liphela, kwaye inokuvavanya iimeko ezininzi kwi-Excel ukuze ungadingi ukusebenzisa iifomyula ezifakwe kwindlwane.
Uphawu lunokusetyenziswa ngokungena =IFS kwibha yefomula, ngokulandela imigaqo. Emva koko i-IFS ihlola ukujonga ukuba iimeko zifezekisiwe kwaye izakubuyisela ixabiso elihambelana nemeko ye-TRUE. Isampulu ye-IFS iboniswe ngezantsi.
Kulo mfanekiso ulandelayo, sisebenzisa ifomula ukwenza amanqaku kwi-spreadsheet.
Sebenzisa ibha yomgangatho ukujonga inqanaba ledatha
Akukho mntu uthanda ukwenza ukubala ngokukhawuleza, kodwa i-Excel iyakwazi ukukhawulezisa idatha yakho. Ukuba unephepha lamanani, okanye amanani, ibar yesimo inokuqhubekeka ngokulula amanani akho ngaphandle kokuchwetheza ifomula. Oku kubandakanya isikali, isikali, imin, ubuninzi, isixa. Kufuneka nje uqaqambise idatha ukuze uqalise. Kwiimeko ezinqabileyo, unokufuna ukuyivula kuqala. Ukuba kunjalo, cofa ekunene kwibar yewonga, kwaye ucofe ukwenza iinketho zezibalo ofuna ukuzibona.
Zama iibar zedatha ukuze ubone idatha yakho ngokubonakalayo
Idatha enkulu iluncedo, kodwa akukho nto ibonakalayo ngaphezu kwe-infographics. Ngophawu lweeBar zeDatha kwi-Excel, unokongeza iibar kwiitafile zakho ezikhoyo ngaphandle kokongeza igrafu. Ungakwenza oku ngokukhetha idatha kunye neeseli ofuna ukuzigrafu, kwaye emva koko uye Iphepha lasekhaya Ikhaya, kwaye ukhethe UkuFomatha ngokuNemiqathango , khetha Iibha zeDatha. Emva koko unokukhetha ukusuka kwigradiyenti yokuzalisa okanye ukuzaliswa kombala.
Cela uncedo kuExcel
Ukuba uzifumana ulahlekile kwi-Excel, inkqubo ngokwayo inokunceda. Cofa ngokulula kwibhokisi ephezulu apho ithi khangela Kwaye uya kukwazi ukukhangela umsebenzi ojonge ukuwenza kwi-Excel.
Ibhokisi yokukhangela iya kuthi emva koko ikunike ukhetho. Kungenjalo, ungasoloko ubhala “ Nceda" Kule bar yokukhangela ukufowuna kwaye ufumane uluhlu lwezihloko ezidumileyo kunye nemisebenzi ye-Excel. Ezinye zezihloko eziqhelekileyo ezidweliswe apha yindlela imigca, imisebenzi, iiseli, iifomyula, ukufomatha, iitafile, njl.
Ngaba uya kukwazi ukufumana elona nqanaba liphezulu kwi-Excel?
Kuninzi onokukwenza ngeMicrosoft Excel, kwaye kunzima ukuyigubungela kwiposti enye. Iingcebiso zethu kunye namaqhinga achukumisa kuphela iziseko, kodwa kuninzi okuninzi okufumanayo. Sixelele kumazwana angezantsi amacebiso akho kunye namaqhinga e-Excel kunye ne-Ofisi 365.
Uzilungisa njani iikhowudi zempazamo zikaMicrosoft Excel
