Ukudityaniswa kwedatha kwi-Excel

Xa usebenza nedatha efanayo ebekwe kwiitafile ezahlukeneyo, amashiti, okanye neencwadi, ukulungiselela ukuqonda kungcono ukuqokelela ulwazi kunye. Kwi-Microsoft Excel, ungajamelana nalo msebenzi usebenzisa isixhobo esikhethekileyo esibizwa ngokuba "yingqungquthela". Inika amandla okuqokelela idatha yedatha enye. Masifumanise ukuba senziwe njani.

Iimeko zokumiliselwa kwenkqubo yokudibanisa

Ngokwemvelo, ayizizo zonke iitafile ezinokudityaniswa zibe nye, kodwa kuphela ezo zihambelana neemeko ezithile:

• Iikholamu kuzo zonke iitafile kufuneka zibe negama elifanayo (kuphela kukwahlulahlula iikholamu kwiindawo);
• Kungabikho zikhongelo okanye imiqolo enexabiso elingenanto;
• Iitemplate kwiitafile kufuneka zifane.

Ukwenza itafile edityanisiweyo

Cinga ngendlela yokwenza itafile ehlanganisiweyo kumzekelo weetafile ezintathu ezine template enye kunye nedatha yedatha. Ngamnye wabo ubekwe kwiphepha elahlukileyo, nangona kwi-algorithm enye unokwenza itafile ehlanganisiweyo kwidatha efumaneka kwiincwadi ezahlukeneyo (iifayile).

1. Vula iphepha elahlukileyo letafile edityanisiweyo.



2. Kwiphepha elivuliweyo, siphawula iseli esiya kuba sisisele esisekhohlo setafile entsha.
3. Ukuba kwindawo "yedatha" ngokunqakraza kwi "Disolidoidiation", ekho kwitheyiphu kwi "Ukusebenza ngedatha" yesixhobo.



4. Iwindows yokudibanisa idatha ivuliwe.

   

   Kwintsimi "yokusebenza", kufuneka useke ukuba yeyiphi inyathelo kunye neeseli kuya kwenziwa xa imigca kunye nemigca ihambelana nomdlalo. Ezi zinokuba zezona zinto zilandelayo:

   • isixa;
   • inombolo;
   • umyinge;
   • ubuninzi;
   • ubuncinci;
   • sebenza;
   • inani lamanani;
   • ukufuduswa;
   • ukuphambuka okungazinzi;
   • ukusasazeka okususiweyo;
   • Ukusasazeka ngokungakholelwa.

   Kwiimeko ezininzi, "isixa" umsebenzi sisetyenzisiwe.



5. Kwicandelo lekhonkco elinamakhonkco, chaza uluhlu lweeseli zenye yeetafile eziphambili eziphantsi kokudityaniswa. Ukuba olu luhlu luye kwifayile enye, kodwa kwelinye iphepha, emva koko cinezela iqhosha elikwilungelo lokufumana idatha.



6. Yiya kwiphepha apho itafile ifumaneka khona, ibalaselisa uluhlu olufunwayo. Emva kokungena kwidatha, sicofa kwakhona kwiqhosha elisekunene lentsimi apho idilesi yongezwa khona.



7. Ukubuyela kwi-Instations yokuDibanisa ukuDibanisa ukongeza iiseli esele zikhethwe luluhlu lweebhendi, cofa kwiqhosha longeziweyo.

   

   Njengoko ubona, emva kwale, uluhlu longezwa kuluhlu.

   

   Ngokufanayo, yongeza zonke ezinye iindawo eziza kuthatha inxaxheba kwinkqubo yokudityaniswa kwedatha.

   

   Ukuba uluhlu olufunayo luthunyelwa kwenye incwadi (ifayile), ke ngoko sacinezela "ukujonga kwakhona, khetha ifayile kwi-hard disk okanye indlela echazwe apha ngasentla iphakamisa uluhlu lweeseli ngaphakathi Le fayile. Ngokwemvelo, kufuneka ifayile kufuneka ivulwe.



8. Ngokufanayo, ezinye iisetingi zetafile ezihlanganisiweyo zenziwe.

   Ukwenzela ukongeza ngokuzenzekelayo igama leekholamu kwi-header, sibeka uphawu kufutshane "utyikityo lomgca ophezulu". Ukwenza isishwankathelo sedatha, sibeke uphawu malunga neparamitha "yasekhohlo". Ukuba uyafuna, xa uhlaziya idatha kwiitafile eziphambili, lonke ulwazi kwitheyibhile ehlanganisiweyo ihlaziywa, kufuneka ufake uphawu lokutshekisha kufutshane ne-parameter yedatha elungileyo ". Kodwa, kule meko, kubalulekile ukuba uqaphele ukuba ukuba ufuna ukongeza imigca emitsha kwitafile yomthombo, kuya kufuneka ususe ibhokisi yokukhangela kule nto kwaye uphinde uphinde uphinde ubumbene ngesandla.

   Xa zonke iisetingi zenziwe, cofa kwiqhosha "Kulungile".



9. Ingxelo edityanisiweyo ilungile. Njengoko ubona, idatha ihleliwe. Ukujonga ulwazi ngaphakathi kwiqela ngalinye, cofa kwindima yenxalenye ngasekhohlo kwetafile.

   

   Ngoku iziqulatho zeqela ziyafumaneka ukuze zibukele. Ngokufanayo, ungabonisa elinye iqela.

Njengoko ubona, ukudityaniswa kwedatha kwi-Excel sisixhobo esilula kakhulu sisixhobo esifanelekileyo, enkosi ekungayiqokeleli ngayo ulwazi olungafaniyo kuphela kwiitafile ezahlukileyo nakwimakhishithi eyahlukileyo, kodwa iphinde iposwe kwezinye iifayile (iincwadi). Ilula kwaye ikhawuleza.