Okuqukethwe
Ukwakhiwa kwenkinga
Njengedatha yokufaka, sinefayela le-Excel, lapho elinye lamashidi liqukethe amathebula amaningana anedatha yokuthengisa yefomu elilandelayo:
Qaphela ukuthi:
- Amathebula anosayizi abahlukene kanye namasethi ahlukene emikhiqizo nezifunda emigqeni namakholomu ngaphandle kokuhlunga.
- Imigqa engenalutho ingafakwa phakathi kwamatafula.
- Inombolo yamathebula ingaba yinoma yimaphi.
Imicabango emibili ebalulekile. Kucatshangwa ukuthi:
- Ngaphezulu kwetafula ngalinye kukholamu yokuqala, kunegama lomphathi elibonisa ukuthengisa kwakhe (Ivanov, Petrov, Sidorov, njll.)
- Amagama wezimpahla nezifunda kuwo wonke amathebula abhalwe ngendlela efanayo - ngokunemba kwecala.
Umgomo omkhulu uwukuqoqa idatha kusuka kuwo wonke amathebula kuyithebula elilodwa eliyisicaba elejwayelekile, elilungele ukuhlaziya okulandelayo nokwakha isifinyezo, okungukuthi kuleli:
Isinyathelo 1. Xhuma kufayela
Masidale ifayela elisha le-Excel elingenalutho bese silikhetha kuthebhu Idatha Umyalo Thola Idatha - Kusuka Efayeleni - Encwadini (Idatha - Kusuka kufayela - Kusuka encwadini yokusebenzela). Cacisa indawo yefayela eliwumthombo ngedatha yokuthengisa bese efasiteleni le-navigator khetha ishidi esilidingayo bese uchofoza inkinobho. Guqula Idatha (Guqula Idatha):
Njengomphumela, yonke idatha esuka kuyo kufanele ilayishwe kusihleli Sombuzo Wamandla:
Isinyathelo sesi-2. Hlanza udoti
Susa izinyathelo ezikhiqizwe ngokuzenzakalelayo uhlobo olushintshiwe (Uhlobo Olushintshiwe) и Izihloko eziphakanyisiwe (Izihloko Ezinyusiwe) futhi ulahle imigqa engenalutho nemigqa enamathothali usebenzisa isihlungi null и TOTAL ngekholomu yokuqala. Ngenxa yalokho, sithola isithombe esilandelayo:
Isinyathelo sesi-3. Ukwengeza abaphathi
Ukuze uqonde kamuva ukuthi ukuthengiswa kukabani, kuyadingeka ukwengeza ikholomu etafuleni lethu, lapho emgqeni ngamunye kuzoba nesibongo esihambisanayo. Kwalokhu:
1. Ake sengeze ikholomu eyinsiza enezinombolo zomugqa sisebenzisa umyalo Engeza Ikholomu - Ikholomu Yenkomba - Kusuka ku-0 (Engeza ikholomu - Ikholomu yenkomba - Kusukela ku-0).
2. Engeza ikholomu ngefomula ngomyalo Ukwengeza Ikholomu – Ikholomu Ngokwezifiso (Engeza ikholomu — Ikholomu yangokwezifiso) bese wethula ukwakhiwa okulandelayo lapho:
Indlela enengqondo yale fomula ilula - uma inani leseli elilandelayo kukholamu yokuqala lithi “Umkhiqizo”, lokhu kusho ukuthi sifike ekuqaleni kwetafula elisha, ngakho sibonisa inani leseli elidlule igama lomphathi. Uma kungenjalo, asibonisi lutho, okungukuthi i-null.
Ukuze uthole iseli lomzali elinesibongo, siqale sibheke ithebula elisuka esinyathelweni sangaphambilini #"Inkomba yengeziwe", bese ucacisa igama lekholomu esiyidingayo [Ikholomu1] kubakaki abayisikwele kanye nenombolo yeseli kuleyo kholomu kubakaki abagoqekile. Inombolo yeseli izoba eyodwa ngaphansi kweyamanje, esiyithatha kukholomu IndexNgokulandelana.
3. Kusele ukugcwalisa amaseli angenalutho ngawo null amagama asuka kumaseli aphezulu anomyalo Guqula – Gcwalisa – Phansi (Guqula — Gcwalisa — Phansi) bese ususa ikholomu engasadingeki enezinkomba nemigqa enezibongo kukholamu yokuqala. Ngenxa yalokho, sithola:
Isinyathelo 4. Ukuhlanganisa amathebula ahlukene ngabaphathi
Isinyathelo esilandelayo ukuqoqa imigqa yomphathi ngamunye ibe amathebula ahlukene. Ukuze wenze lokhu, kuthebhu ethi Guqula, sebenzisa Iqembu ngomyalo (Guqula - Iqembu Nge) futhi efasiteleni elivulayo, khetha ikholomu yoMphathi kanye nokusebenza Yonke imigqa (Yonke imigqa) ukumane uqoqe idatha ngaphandle kokusebenzisa noma yimuphi umsebenzi wokuhlanganisa. kubo (isamba, isilinganiso, njll.). P.):
Njengomphumela, sithola amathebula ahlukene omphathi ngamunye:
Isinyathelo sesi-5: Guqula Amathebula Akhiwe
Manje sinikeza amathebula alele kuseli ngayinye yekholomu ewumphumela Yonke idatha esimeni esihle.
Okokuqala, susa ikholomu engasadingeki kuthebula ngalinye Umphathi. Sisebenzisa futhi Ikholomu yangokwezifiso ithebhu Uguquko (Guqula — Ikholomu yangokwezifiso) nefomula elandelayo:
Bese, ngenye ikholomu ebaliwe, siphakamisa umugqa wokuqala etafuleni ngalinye ezihlokweni:
Futhi ekugcineni, senza uguquko oluyinhloko - ukwembula ithebula ngalinye sisebenzisa i-M-function Ithebula.UnpivotOtherColumns:
Amagama ezifunda asuka kunhlokweni azongena kukholomu entsha futhi sizothola elincanyana, kodwa ngesikhathi esifanayo, ithebula elide elejwayelekile. Amaseli angenalutho nge null azinakwa.
Ukuqeda amakholomu amaphakathi angadingekile, sine:
Isinyathelo sesi-6 Nweba Amathebula Afakwe Isidleke
Kusele ukunweba wonke amathebula afakwe esidlekeni ajwayelekile abe ohlwini olulodwa kusetshenziswa inkinobho enemicibisholo ekabili enhlokweni yekholomu:
… futhi ekugcineni sithola ebesikufuna:
Ungakwazi ukukhipha ithebula eliwumphumela ulibuyisele ku-Excel usebenzisa umyalo Ikhaya - Vala futhi Ulayishe - Vala futhi Ulayishe... (Ekhaya — Vala&Layisha — Vala&Layisha ku…).
- Yakha amatafula anezihloko ezahlukene ezivela ezincwadini eziningi
- Iqoqa idatha kuwo wonke amafayela kufolda enikeziwe
- Iqoqa idatha kusuka kuwo wonke amashidi encwadi etafuleni elilodwa