Sefa muExcel - Basics

Kusefa data muExcel inobvumidza iwe kuratidza pakati pehuwandu hweruzivo chete izvo zvauri kuda izvozvi. Semuenzaniso, kuva nerunyorwa rwezviuru zvezvinhu mu hypermarket hombe pamberi pako, unogona kusarudza chete shampoos kana makirimu kubva pairi, uye uvanze kwechinguva zvimwe. Muchidzidzo chino, tichadzidza mashandisiro ezvisefa kune zvinyorwa muExcel, kusefa pamakoramu akati wandei kamwechete, uye kubvisa mafirita.

Kana tafura yako iine huwandu hukuru hwe data, zvingave zvakaoma kuwana ruzivo rwaunoda. Mafirita anoshandiswa kuderedza huwandu hwe data inoratidzwa paExcel sheet, ichikubvumira kuti uone chete ruzivo rwaunoda.

Kushandisa sefa muExcel

Mumuenzaniso unotevera, isu tichaisa sefa kune iyo hardware yekushandisa log kuratidza chete malaptop uye mahwendefa aripo kuti aongororwe.

1. Sarudza chero sero patafura, semuenzaniso sero A2.

Kuti kusefa kuti kushande nemazvo muExcel, pepa rebasa rinofanira kunge riine musoro wemutsetse unoshandiswa kudoma koromo yega yega. Mumuenzaniso unotevera, data riri papepa rebasa rakarongwa semakoramu ane misoro pamutsara 1: ID #, Type, Iron Tsanangudzo, zvichingodaro.

1. Baya Data, wobva wadzvanya command firita.
2. Mabhatani emiseve anooneka mumisoro yekoramu yega yega.
3. Tinya bhatani rakadaro muchikamu chaunoda kusefa. Kwatiri isu, isu tichaisa sefa kune column B kuti tione chete mhando dzemidziyo yatinoda.
4. Iyo sefa menyu ichaonekwa.
5. Bvisa bhokisi Sarudza zvosekukurumidza kubvisa zvinhu zvese.
6. Tarisa mabhokisi emhando dzemidziyo yaunoda kusiya mutafura, wobva wadzvanya OK. Mumuenzaniso wedu, tichasarudza Laptops и mahwendefakuona chete idzo mhando dzemidziyo.
7. Iyo data tafura ichasefa, ichivanza kwenguva pfupi zvese zvisingaenderane nemaitiro. Mumuenzaniso wedu, malaptop uye mahwendefa chete ndiwo akasara achionekwa.

Kusefa kunogona kushandiswawo nekusarudza murairo Ronga uye sefa Tab Home.

Isa akawanda mafirita muExcel

Mafirita muExcel anogona kupfupikiswa. Izvi zvinoreva kuti iwe unokwanisa kuisa akawanda mafirita patafura imwe chete kuti udzikise mafirita. Mumuenzaniso wapfuura, isu takatosefa tafura kuratidza chete malaptop uye mahwendefa. Iye zvino basa redu nderekudzikisa data zvakanyanya uye kuratidza chete malaptop uye mahwendefa akaunzwa kuti aongororwe muna Nyamavhuvhu.

1. Dzvanya bhatani remuseve muchikamu chaunoda kusefa. Muchiitiko ichi, tichaisa imwe sefa kune column D kuti uone ruzivo nemazuva.
2. Iyo sefa menyu ichaonekwa.
3. Tarisa kana kusatarisa mabhokisi zvichienderana nedata raunoda kusefa, wobva wadzvanya OK. Tichabvisa zvinhu zvese kunze kwekunge Nyamavhuvhu.
4. Iyo sefa nyowani ichashandiswa, uye malaptops chete nemapiritsi akaunzwa kuti aonekwe muna Nyamavhuvhu ndiwo acharamba ari patafura.

Kubvisa sefa muExcel

Mushure mekushandisa sefa, nekukurumidza kana gare gare zvichave zvakakosha kuibvisa kana kuibvisa kuitira kusefa zvirimo neimwe nzira.

1. Dzvanya bhatani remuseve muchikamu chaunoda kubvisa sefa kubva. Mumuenzaniso wedu, tichabvisa sefa kubva mukoramu D.
2. Iyo sefa menyu ichaonekwa.
3. Sarudza chinhu Bvisa sefa kubva muchikamu... Mumuenzaniso wedu, isu tichabvisa sefa kubva mukoramu Yakatumirwa kuti iongororwe.
4. Iyo sefa ichabviswa uye iyo yakambovigwa data ichaonekwa zvakare muExcel sheet.

Kuti ubvise mafirita ese muExcel tafura, tinya murairo firita Tab Data.