Amakhompyutha, Isofthiwe
Easy futhi ezingabizi i-Excel - indlela ukuhlanganisa amaseli e-Excel
Excel - uhlelo okwandile elikuvumela imisebenzi ngokuzenzakalelayo isimiso, gcogca ubuye uhlelembise idatha ngefomu yethebula ukuze ukungena amafomula okwalandela ukucabanga okuzenzakalelayo yamanani. Amaspredishithi isetshenziswe kuphela ngenhloso kwemibiko yezimali nokubika. Basuke kuyanda cishe yonke imikhakha yomsebenzi. Lokhu kungenxa, ngaphezu kwakho konke, ukusebenza kanye lula ukusetshenziswa kohlelo kanye Excel ikuvumela ukuba bamele ulwazi olulondolozwe ifomu amathebula kanye imidvwebo. Ukuze ngempumelelo Ukwakha database enkulu futhi ulwazi, umsebenzisi udinga ukwazi indlela ukuhlanganisa amaseli e-Excel. Ukumelwa sokuqhafaza idatha ekahle kakhulu bezibona, isibonisi okubonakalayo ulwazi kanye isethulo yayo, kanye ukuhlaziywa idatha etholakalayo.
Ngenxa yobuningi lohlelo imisebenzi abasebenzisi imfundamakhwela bebhekana nezinselele ezahlukene. Lapho edala amatafula eziyinkimbinkimbi kubalulekile iqembu idatha. Kule ndaba, ukusungulwa kokuqala etafuleni kukhona umbuzo: "kanjani ukuba abe umpetha ukuhlanganisa amaseli?". Kwenze silula. Sichaza inqubo ukuhlanganisa amaseli:
2. Khona uqondise isikhombisi segundane endaweni ekhethiwe amaseli. Cindezela inkinobho kwesokudla igundane, imenyu-pop-up. Ohlwini kuphumele, ukhethe into "Ifomethi Amaseli."
3 lembula iwindi enemininingwane ngamathebhu eziningana. Sidinga ukuvula ithebhu yesibili "Ukuhambisana". Khona-ke, ngaphansi kwesithi "Khombisa," ukhetha into "Hlanganisa amaseli", chofoza "OK". Manje siyabona ukuthi amaseli isehlane yithi sasimunye kwelinye. Ithebula elingezansi libonisa kanjani iseli kuhlanganiswe zingavela:
| igama | intengo | |
| deda. | $ | |
Ukwazi indlela ukuhlanganisa amaseli e-Excel, ungasetha nemingcele - format, ubungako kanye hlobo lombhalo ifonti, umbhalo isakhiwo kanye padding, kombhalo kuseli. Ungase futhi wenze kwemingcele yabo, okungukuthi, khetha ukujiya, ukuma nombala wazo emigqeni. Bookmark "inombolo" ikuvumela ukusetha format wayefisa idatha efomini izinombolo abavamile noma umbhalo. Lwemali format efanelekayo izibalo, njengoba inike okuholela amagugu ongathandeki ifonti abomvu. Ifomethi "Usuku" futhi "Isikhathi" aqukethe ongakhetha eziningana, singakwazi kuphela akhethe ekahle kunazo.
| № p / p | igama | Inani th. deda. | Abelana,% | Ukuphambuka (+/-) 2006-2007. | |||||
| 2005 | 2006 | 2007 | 2005 | 2006 | 2007 | ayizinkulungwane. ukukuthinta. | % | ||
| 1 | amafa angaphatheki | 35 | 23 | 12 | 0.01 | 0.01 | 0.004 | -11 | -47,83 |
| 2 | amafa engaguquki | 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 | ukutshalwa kwezimali inzuzo e amafa eziphathekayo | ||||||||
| 5 | ukutshalwa kwezimali eside | 14370 | 14388 | 14338 | 2,33 | 4,22 | 4,47 | -50 | -0,35 |
| 6 | Engamancozuncozu intela amafa | 289005 | 46274 | 41378 | 46,83 | 13,57 | 12,89 | -4896 | -10,58 |
| 7 | nezinye | ||||||||
| vneoborot TOTAL. amafa | 617148 | 341050 | 321015 | 100.00 | 100.00 | 100.00 | -20.035 | -5,87 | |
Isidingo ukuhlanganisa amaseli e-excel kwenzeka kubantu ngokuyinhloko uma udala cap, lapho etafuleni iqukethe semali idatha. Ukuze kube lula, kuvumelana kwetinhlavu idatha, kanye ngokushesha futhi kalula ukuthola ulwazi ungasebenzisa ozikhethela ukugcwaliswa umsebenzi. Lokhu kungenziwa ngokuqondile control panel ngokusebenzisa inkinobho "Gcwalisa" bese ukhetha umbala oyifunayo kusukela uhlu olwehlayo. Njengoba ubona, lolu hlelo Excel esivumelana kakhulu ngoba ikuvumela ukuba wenze ukubukeka kwe-idatha eboniswa ngabanye ngokwezenzo izidingo ezithile umsebenzisi. Sithemba ukuthi esikhathini esizayo umbuzo indlela Excel ukuhlanganisa amaseli, ukuba ningabeki isikhubekiso ngawe ekupheleni efile.
Similar articles
Trending Now