Mmene Mungapangire Chidwi ku Excel

Tsatirani mauthenga, magulu, ndi zina zina ndi deta ya Excel

Nthawi zina, tifunika kusunga chidziwitso cha chidziwitso ndipo malo abwino kwa izi ndi mu fayilo ya mndandanda wa Excel. Kaya ndi mndandanda wa manambala a foni, mndandanda wa anthu omwe ali bungwe kapena timagulu, kapena mndandanda wa ndalama, makadi, kapena mabuku, fano lachinsinsi la Excel limapangitsa kukhala kosavuta kulowa, kusunga, ndi kupeza zambiri.

Microsoft Excel yakhazikitsira zida kuti zikuthandizeni kufufuza deta ndikupeza chidziwitso chenicheni pamene mukufuna. Komanso, ndi mazenera ambirimbiri ndi mizere zikwi zambiri, Excel spreadsheet ikhoza kukhala ndi deta yochuluka kwambiri.

Kulowa Deta

Makhalidwe oyambirira a kusungirako deta m'ndandanda wa Excel ndi tebulo.

Kamodzi patebulo lipangidwa, zida za data za Excel zingagwiritsidwe ntchito kufufuza, kutulutsa, ndi kufotela zolembedwa m'mabuku kuti mudziwe zambiri.

Kuti muzitsatira limodzi ndi phunziro ili, lowetsani deta monga ikusonyezedwera mu chithunzi pamwambapa.

Lowani mofulumira ID ya Ophunzira:

1. Lembani zizindikiro ziwiri zoyambirira - ST348-245 ndi ST348-246 m'maselo A5 ndi A6, mofanana.
2. Onetsani ma ID omwewa kuti muwasankhe.
3. Dinani pazitsulo chodzaza ndi kukokera ku selo A13 .
4. Zina zonse za ID ya Ophunzira ziyenera kulowa mu maselo A6 mpaka A13 molondola.

Kulowa Data molondola

Mukalowa mu deta, nkofunika kuonetsetsa kuti yalowa bwino. Zina kusiyana ndi mzere 2 pakati pa mutu wa spreadsheet ndi mutu wa mutuwo, musasiye mizere ina iliyonse yopanda kanthu mukalowa deta yanu. Ndiponso, onetsetsani kuti musasiye maselo opanda kanthu.

Zolakwitsa zapadera , zomwe zimayambitsidwa ndi zolakwika zosalowa, ndizo zimayambitsa mavuto ambiri okhudzana ndi kasamalidwe ka deta. Ngati deta imalowa bwino pamayambiriro, pulogalamuyi imakhala ikubwezeretsani zotsatira zomwe mukufuna.

Mizere ndi Records

Mndandanda uliwonse wa deta, mu database umadziwika ngati mbiri . Mukalowetsa zolemba mumaganizo awa:

• Siyani mizera yosalongosola patebulo yomwe yakhazikitsidwa. Izi zikuphatikizapo OSASANKHA mzere wopanda kanthu pakati pa mutu wa mutu ndi mzere woyamba wa deta.
• Zolemba zingakhale ndi deta za chinthu chimodzi chokha.
• Chiwerengero chiyenera kukhala ndi zonse ZONSE zomwe zili mu deta yokhudza chinthucho. Sipangakhale chidziwitso cha chinthu mu mzere umodzi.

Mizati ndi Masamba

Ngakhale mizere m'ndandanda wa Excel imatchulidwa ngati zolemba, zipilala zimadziwika ngati minda . Chigawo chilichonse chikusowa mutu kuti mudziwe deta yomwe ili. Mitu imeneyi imatchedwa mayina akumunda.

• Mayina amtundu akugwiritsidwa ntchito kuti atsimikizire kuti deta ya mbiri iliyonse imalowa mofanana.
• Onetsetsani kuti zonse zomwe zili muzomwe zili m'kalembedwe zimalowa mofanana. Ngati mutayamba kulowa manambala monga chiwerengero (monga 10 kapena 20) chitetezeni. Musasinthe mbali yina ndikuyamba kulowa manambala monga mawu (monga khumi kapena makumi awiri). Khalani osasinthasintha.
• Musasiye mazenera opanda kanthu patebulo.

Kupanga Tabulo

Deta ikadalowa, ikhoza kukhala tebulo . Kuchita izi:

1. Sungani maselo A3 mpaka E13 mu tsamba la ntchito.
2. Dinani pa tsamba la Pakiti.
3. Dinani pa Fomu monga Gulu lazithunzi pa riboni kuti mutsegule menyu.
4. Sankhani buluu la Table Style Medium 9 njira yoti mutsegule fomu yomwe ili ngati Gulu lakulumikiza.
5. Pamene bokosili liri lotseguka, maselo A3 mpaka E13 ali pa tsambalo ayenera kumayendetsedwa ndi nyerere.
6. Ngati nyererezi zikuzungulira kuzungulira maselo ofanana, dinani Ok mu Format monga Table dialog box.
7. Ngati nyerere siziyenda mozungulira ma selo oyenera, onetsetsani zofunikira zomwe zili mu tsambali ndipo dinani Ok mu Format monga Table dialog.
8. Gome liyenera kukhala ndi mivi yowonongeka pambali pa dzina lililonse lamasamba ndipo mzere wa tebulo uyenera kupangidwira popanga kuwala ndi mdima wandiweyani.

Kugwiritsa Ntchito Zida Zida

Mukadapanga deta, mungagwiritse ntchito zida zomwe zili pansi pa mizere yoponya pansi pambali pa dzina lililonse lamasamba kuti musankhe kapena kusungani deta yanu.

Dongosolo la Kusankha

1. Dinani pamzere woponya pansi pafupi ndi dzina la Last Name field .
2. Dinani mtundu wa A mpaka Z kuti muyambe mndandanda wazinenero.
3. Kamodzi akakonzedwe, Graham J. ayenera kukhala woyamba kulemba patebulo ndi Wilson. R ayenera kukhala wotsiriza.

Kusuta Data

1. Dinani pamsana wotsika pansi pafupi ndi dzina la Programme .
2. Dinani kabokosi pafupi ndi Kusankha Zonse kuti muchotse mabotolo onse.
3. Dinani ku bokosi lofufuzira pafupi ndi Bungwe lanu kuti muwonjezere chizindikiro ku bokosi.
4. Dinani OK .
5. Ophunzira awiri okha - G. Thompson ndi F. Smith ayenera kuoneka popeza ndi awiri okha omwe amalembetsa pulogalamu yamalonda.
6. Kuti muwonetsere zolemba zonse, dinani pamzere wotsika pansi pafupi ndi dzina la Field field.
7. Dinani pa Fuluta Yoyera kuchokera ku "Program" kusankha.

Kukulitsa Zambiri

Kuwonjezera zolemba zina ku database yanu:

• Ikani khola lanu la mbewa pamphindi kakang'ono pansi pa dzanja lamanja la gome.
• Msoti wamagulu adzasintha n'kukhala muvi wotsatirana.
• Izi zikachitika, dinani ndi kugwiritsira ntchito batani lamanja la mbewa ndikukoka pointer kuti muwonjezere mzera wopanda kanthu pansi pa deta.
• Onjezerani zotsatira zotsatirazi ku mzere watsopano uwu:
  Cell - Data
  A14 - ST348-255
  B14 - Christopher
  C14 - A.
  D14 - 22
  E14 - Sayansi

Kumaliza Kulemba Mapu

1. Sungani maselo A1 mpaka E1 mu tsamba la ntchito.
2. Dinani pa tsamba la Pakiti.
3. Dinani pa Chophatikizana ndi Pakati pazitsulo kuti mukhale mutu.
4. Dinani pa Kudzaza Mtundu (kumawoneka ngati utoto ukhoza) pa riboni kuti mutsegule mzere wotsitsa mtundu.
5. Sankhani Buluu, Kalankhulidwe 1 kuchokera pa mndandanda kuti musinthe mtundu wa chiyambi m'maselo A1 - E1 kupita ku buluu lakuda.
6. Dinani pa Chithunzi cha mtundu wa Font pa Formatting toolbar (ndilo chilembo chachikulu "A") kutsegula mndandanda wazithunzi.
7. Sankhani White kuchokera pa mndandanda kuti musinthe mtundu wa malemba m'maselo A1 - E1 kuti akhale oyera.
8. Onetsetsani maselo A2 - E2 mu tsamba la ntchito.
9. Dinani pa Lembani Mzere pa peboni kuti mutsegule mndandanda wamatsitsi.
10. Sankhani Buluu, Mphindi 1, Wopenya 80 kuchokera mndandandawo kuti musinthe mtundu wa chiyambi m'maselo A2 - E2 kuti muwone buluu.
11. Onetsetsani maselo A4 - E14 mu worksheet.
12. Dinani pa Pakati pa Chingwe pa riboni kuti mugwirizane kulumikiza mawu mu maselo A14 mpaka E14.
13. Panthawiyi, ngati mwatsatira ndondomeko yonse ya phunziro ili molondola, tsamba lanu liyenera kufanana ndi spreadsheet yomwe ikuwonetsedwa mu Gawo 1 la phunziroli.

Maofesi ogwira ntchito

Syntax : Dfunction (Database_arr, Field_str | num, Criteria_arr)

Pamene D ntchito ndi chimodzi mwa zotsatirazi:

• DAVERAGE
• DCOUNT
• DCOUNTA
• DGET
• DMAX
• DMIN
• DPRODUCT
• DSTDEV
• DSTDEVP
• DSUM
• DVAR
• DVARP

Mtundu : Database

Zolemba zamtunduwu zimathandiza makamaka pamene Google Mapepala amagwiritsidwa ntchito kuti asunge deta, monga database. Deta iliyonse ikugwira ntchito, Kugwira ntchito , imagwirizanitsa ntchito yofanana pa gawo la selo lotengedwa ngati tebulo lachinsinsi. Zolemba zamtunduwu zimatenga zifukwa zitatu:

• Database_arr ndi mndandanda, zolemba kapena zolemba zomwe zimapangidwa ndi ndondomeko yowonongeka kuti mzere uliwonse pambuyo pa Row 1 ndi mbiri yachinsinsi, ndipo ndime iliyonse ndi malo achinsinsi. Mzere 1 uli ndi malemba pa munda uliwonse.
• Field_str | nambala imasonyeza kuti ndime (munda) ili ndi chikhalidwe choyenera. Izi zikhoza kufotokozedwa monga dzina lamasamba (malemba chingwe) kapena nambala ya mzere, kumene mbali yotsalirayo idzayimiridwa ngati 1.
• Criteria_arr ndi mndandanda, zigawo zolembedwera kapena zigawo zomwe zimapangidwa ndi ndondomeko yowonongeka yomwe mzere woyamba uli ndi dzina lachidziwitso limene lingagwiritsidwe ntchito, ndipo mzere wotsatira uli ndi mayesero ovomerezeka (s) .

Mzere woyamba mu Criteria umatchula mayina a kumunda. Mzere wina uliwonse mu Criteria umayimira fyuluta, yomwe ndiyeso la zoletsedwa pazinthu zoyenera. Zoletso zimayankhidwa pogwiritsa ntchito chiwerengero cha Query-by-Example, ndipo zingaphatikizepo mtengo wofanana kapena wogwiritsira ntchito poyerekeza ndi mtengo woyerekeza. Zitsanzo za zoletsedwa ndi: "Chokoleti", "42", "> = = 42", "<> 42". Selo lopanda kanthu silikutanthauza kuti palibenso malire pamtunda womwewo.

Fyuluta ikufanana ndi mndandanda wazitsulo ngati zoletsa zonse za fyuluta (zoletsedwa mu mzere wa fyuluta) zatha. Mndandanda wachinsinsi (mbiri) imakhutitsa Criteria ngati ndipokha ngati fyuluta imodzi ikufanana. Dzina la munda lingayambe kasanu ndi kamodzi mu Mndandanda wa Zolinga kuti mulole zoletsedwa zambiri zomwe zimagwiritsidwa ntchito nthawi imodzi (mwachitsanzo, kutentha> = 65 ndi kutentha <= 82).

DGET ndi ntchito yokha yachinsinsi yomwe siyikuphatikiza malamulo. DGET imabweretsanso mtengo wa munda womwe umatchulidwa muzokambirana yachiwiri (mofananamo ndi VLOOKUP) pokhapokha pamene zolemba chimodzi zikugwirizana ndi Zowona; mwina, imabweretsanso zolakwika zomwe sizikugwirizana ndi ma matches osiyanasiyana