Ukuhlanganiswa kwedatha ku-Excel

Lapho usebenza nedatha efanayo ebekwe kumatafula ahlukene, amashidi, noma ngisho nezincwadi, ukuze kube lula ukubonwa kungcono ukuqoqa imininingwane ndawonye. KuMicrosoft Excel, ungabhekana nalo msebenzi usebenzisa ithuluzi elikhethekile elibizwa nge- "Considation". Inika amandla okuqoqa idatha etafuleni elilodwa. Ake sibheke ukuthi kwenziwa kanjani.

Izimo zokuqaliswa kwenqubo yokuhlanganisa

Ngokwemvelo, akuwona wonke amatafula angahlanganiswa abe munye, kepha yilabo kuphela abahambelana nemibandela ethile:

• Amakholomu kuwo wonke amatafula kufanele abe negama elifanayo (ukuvumela kuphela amakholomu ezindaweni);
• Akufanele kube khona amakholomu noma imigqa enamanani angenalutho;
• Izibonisi ezisematafuleni kumele zifane.

Ukudala itafula elihlanganisiwe

Cabanga ukuthi ungawakha kanjani itafula elihlanganisiwe esibonelweni samatafula amathathu ane-template efanayo nesakhiwo sedatha. Ngayinye yazo itholakala eshidini elihlukile, yize ku-algorithm efanayo ungakha itafula elihlanganisiwe kusuka kwimininingwane etholakala ezincwadini ezahlukene (amafayela).

1. Vula ishidi elihlukile etafuleni elihlanganisiwe.



2. Ephepheni elivulekile, siphawula iseli elizoba yiseli elingaphezulu kwesobunxele letafula elisha.
3. Ukuba sethebhu "yedatha" ngokuchofoza inkinobho ethi "Consolidation", okutholakala etheyipini ku- "Ukusebenza nedatha" yamathuluzi.



4. Kuvulwa iwindi lokusetha idatha.

   

   Ensimini ethi "Umsebenzi", udinga ukusungula ukuthi yisiphi isenzo namaseli azokwenziwa lapho imigqa namakholomu ahambelana nomdlalo. Lokhu kungaba yizenzo ezilandelayo:

   • isamba;
   • inombolo;
   • isilinganiso;
   • Isilinganiso;
   • ubuncane;
   • sebenza;
   • inani lezinombolo;
   • ukuthutha;
   • ukuphambuka okungazinzi;
   • Ukuhlakazwa okubalekile;
   • Ukuhlakazwa okungavikeleki.

   Ezimweni eziningi, umsebenzi we- "mali" uyasetshenziswa.



5. Ensimini yesixhumanisi, chaza uhla lwamaseli kwelinye lamatafula aphambili angaphansi kokuhlanganiswa. Uma leli banga likufayela elifanayo, kodwa kwelinye ishidi, bese ucindezela inkinobho etholakala ngakwesokudla kwenkambu yokungena idatha.



6. Iya ephepheni lapho itafula litholakala khona, qokomisana uhla olufunayo. Ngemuva kokufaka idatha, sichofoza futhi kwinkinobho etholakala ngakwesokudla kwenkambu lapho kungezwa khona ikheli lamaseli.



7. Ukubuyela ewindini lezilungiselelo zokuhlanganisa ukuze ungeze amaseli asevele akhethiwe ohlwini lwamabhande, chofoza inkinobho ethi Faka.

   

   Njengoba ubona, ngemuva kwalokhu, ibanga lingezwa ohlwini.

   

   Ngokufanayo, engeza wonke amanye amabanga azobamba iqhaza kwinqubo yokuhlanganiswa kwedatha.

   

   Uma uhla olufunayo luthunyelwa kwenye incwadi (ifayela), khona-ke thina ngokushesha sicindezela inkinobho ethi "Overview ...", khetha ifayela kwi-hard disk noma bese kuthi indlela ebekiwe engenhla iqokomisa ububanzi be-cell in Leli fayela. Ngokwemvelo, kufanele kuvulwe ifayela.



8. Ngokufanayo, ezinye izilungiselelo zethebula ezihlanganisiwe zingenziwa.

   Ukuze ungeze ngokuzenzakalela igama lamakholomu kunhlokweni, sibeka umkhaza eduze "kwesiginesha yomugqa ophezulu". Ukuze wenze ukubizwa kwedatha, sibeka umkhaza ngepharamitha "yesobunxele". Uma ufuna, lapho uvuselela idatha kumatafula aphambili, lonke ulwazi etafuleni elihlanganisiwe lubuye luvuselelwa, khona-ke kufanele ufake umaki wokuhlola eduze kwe- "Dala ukuxhumana nge-Facial New" Parameter. Kepha, kulokhu, kuyadingeka ukubheka ukuthi uma ufuna ukwengeza imigqa emisha etafuleni lomthombo, kuzofanele ususe ibhokisi lokuhlola kule nto bese ulisebenzisa amanani ngesandla.

   Lapho zonke izilungiselelo zenziwe, chofoza inkinobho ethi "Kulungile".



9. Umbiko ohlanganisiwe usulungile. Njengoba ubona, idatha ihlelwe kahle. Ukuhlola ulwazi ngaphakathi kweqembu ngalinye, chofoza iqhaza kwenye indlela ngakwesobunxele setafula.

   

   Manje okuqukethwe yileli qembu kuyatholakala ukubukwa. Ngokufanayo, ungambula noma yiliphi elinye iqembu.

Njengoba ubona, ukuhlanganiswa kwedatha ku-Excel kuyithuluzi elisebenziseka kalula, ngenxa yokuthi ungaqoqana ngalo ulwazi olutholakala kumathebula ahlukene nakumashidi ahlukene, kepha ngisho nokuthunyelwa kwamanye amafayela (izincwadi). Kulula futhi kuyashesha.