Computer, Software
Easy nefikelelekayo kumntu Excel - ukuzimanyanisa indlela iiseli Excel
Excel - inkqubo ngokubanzi ekuvumela ukuba imishini imisebenzi yesiqhelo, ukuqokelela nokucwangcisa ulwazi ngendlela tabular Umnyango neefomula kunye nokubalwa koko oluzenzekelayo zokubala. Spreadsheet zisetyenziswa kuphela ngenjongo accounting ingxelo. Bona zithanda phantse kuzo zonke iinkalo zomsebenzi. Oku kubangelwa, ngaphezu kwabo bonke, ukusebenza kunye nokusetyenziswa kwale nkqubo kwakunye ne-Excel ivumela ukuba ukumela zigcinwa kulwazi ngohlobo iitafile nemizobo. Ukuze ngempumelelo Ukudala kakhulu kwaye ulwazi database, umsebenzisi iimfuno wazi njani ukuba udityaniso iiseli Excel. Ujongano imbonakaliso lwedatha kakhulu ndakuzuza ithuba mbono, a ebonakalayo kumboniso lolwazi kunye yayo ntetho, kwakunye uhlalutyo efumanekayo.
Ngenxa yobuninzi kwemisebenzi abasebenzisi inkqubo mfundi ezijongene nemingeni eyahlukileyo. Xa adale complex iitafile kuyimfuneko ukuba iqela le data. Kulo mba, ukusekwa lokuqala etafileni kukho umbuzo: "Indlela ngokwakha uhlangane iiseli?". Yenza kube lula kakhulu. Thina ukuchaza inkqubo ukuhlanganisa iiseli:
2. Emva koko aqondise isalathisi se mouse kwi ariya ekhethiweyo eziseleni. Cinezela iqhosha lemouse ekunene, i menu elilo phezulu. Kuludwe onesiphumo, khetha umba "Iiseli Format."
3 utyhila i window eneenkcukacha ezinezithuba ezininzi. Kufuneka ukuba ukuvula i tab yesibini "ulungelelwaniso". Emva koko, phantsi "Display," khetha umba "Hlanganisa iiseli", klikha u- "OK". Ngoku siyabona ukuba iiseli abahlukunyezwa thina sasimanyene kwenye. Le theyibhile ingezantsi ibonisa indlela zingavela iseli edityanisiweyo:
| igama | inani | |
| bagcobe. | $ | |
Ukwazi ukuba uhlangane indlela iiseli Excel, ungabeka nezinye iparameters - fomati, ubungakanani kunye nohlobo lokubhala befonti, isakhiwo itekisi kunye nezikhuseli, ulwalathiso kwisisele kwisicatshulwa. Unakho ukwenza emideni yabo, oko kukuthi, khetha imigca ubukhulu, imilo kunye nombala elifunekayo. Bookmark "inani" ikuvumela ukuba amisiweyo zinqwenelekayo kwifomathi i data ngokohlobo eliqhelekileyo amanani okanye okubhaliweyo. Imali yeloo lizwe ifomati efanelekileyo izibalo, njengoko ipha isiphumo esibi amanani abomvu yomgca. Format "Umhla" yaye "Ixesha" ziqulathe iinketho eziliqela, sinokukhetha kakhulu elula kuphela.
| № p / p | igama | Le ixabiso. bagcobe. | Yabelana,% | Umahluko (+/-) 2006-2007. | |||||
| 2005 | 2006 | 2007 | 2005 | 2006 | 2007 | amawaka. bagcobe. | % | ||
| 1 | -asethi ezingaphathekiyo | 35 | 23 | 12 | 0,01 | 0,01 | 0.004 | -11 | -47,83 |
| 2 | impahla fixed | 302030 | 268665 | 253577 | 48,94 | 78,78 | 78,99 | -15.088 | -5,62 |
| 3 | ukwakhiwa kuyaqhubeka | 11708 | 11700 | 11710 | 1,90 | 3,43 | 3,65 | 10 | 0,09 |
| 4 | Nenzuzo izimali ebambekayo impahla | ||||||||
| 5 | investment zexesha elide | 14370 | 14388 | 14338 | 2,33 | 4,22 | 4,47 | -50 | -0,35 |
| 6 | Zaqaliswa tax amafa | 289005 | 46274 | 41378 | 46,83 | 13,57 | 12,89 | -4896 | -10,58 |
| 7 | enye | ||||||||
| vneoborot TOTAL. impahla | 617148 | 341050 | 321015 | 100.00 | 100.00 | 100.00 | -20.035 | -5,87 | |
Imfuneko ukuze uhlangane iiseli excel kwenzeka abantu ikakhulu xa ekudaleni chap, xa itafile iqulethe isixa esikhulu data. Ukunenzela lula, a olubonakalayo umelo lwe data, kwakunye ngaphezulu ngokukhawuleza nangokulula yokufumana ulwazi Ungasebenzisa ozikhethelayo ukugcwaliswa umsebenzi. Oku kunokwenziwa ngqo kwi control panel ngokusebenzisa kwiqhosha "Fakela" kwaye khetha ofunekayo umbala kwi-drop-down list. Njengoko ubona, inkqubo ye-Excel Kulula kakhulu kuba likuvumela ukuba wenze ukubukeka wedatha iboniswe ngabanye ngokunxulumene neemfuno ezithile umsebenzisi. Sinethemba lokuba kwixesha elizayo umbuzo, ukuba bahlabele njani ukuhlangana iiseli, ukuba ndikubeke ekupheleni efile.
Similar articles
Trending Now