Kuzungulira mu Excel n'kosavuta!

M'nkhaniyi, tiyang'ana pa ofesi ya MS Office Excel.

MS Office Excel - pulogalamu yomwe ikuphatikizidwa mu Microsoft Office yovuta. Amagwiritsidwa ntchito powerengetsera masamu, kupanga zithunzi, kupanga matebulo, ndi zina zotero.

Pulogalamu ya pulogalamuyi ndi buku lothandizira. Bukhuli liri ndi ziwerengero zopanda malire, zomwe zimayikidwa ndi wogwiritsa ntchito.

Pulogalamu iliyonse ya pulogalamuyi ndi tebulo lokhala ndi mizere 65536 ndi 256 zipilala. Selo lirilonse la tebulo limenelo limatchedwa selo.

Selo la Excel lili ndi adiresi yakeyake, yomwe ili ndi nambala ya mzere ndi kalata yachilatini ya chigawo (mwachitsanzo, 1A, 2B, 5C).

Ntchito zazikulu za pulogalamuyi

Ntchito "SUM" (kuchuluka kwa Excel)

Kukambitsirana kwa manambala ndi manambala ku Excel kungachitidwe m'njira zitatu.

1. Pogwiritsa ntchito chizindikiro chowonjezera chowonjezera - kuphatikiza ("+"). Kawirikawiri njira iyi imagwiritsidwa ntchito powonjezera chiwerengero chochepa cha manambala kapena manambala, komanso mawonekedwe apakati pa kuwonjezera mawerengedwe a ntchito zina.
2. Pogwiritsa ntchito ndondomeko ya ntchito "SUM" ndi kusankha mfundo. Amakulolani kuti muwonjezere manambala omwe ali mbali imodzi (gawo la mzere, mizera), maselo angapo osagwirizana, mbali ziwiri zozungulira, maselo omwe ali pafupi ndi gawo la maselo osayandikana nawo. Chiwerengero cha Excel ndi kugwiritsa ntchito ntchitoyi chikhoza kuwerengedwa.
3. Kugwiritsira ntchito chizindikiro cha "auto-sum" Σ "ndikusankha mawu osiyanasiyana. Ankawerengetsera ndalama zomwezo ndi "SUMM".

Mndandanda wa "DISTRICT"

Zotsatira za mawerengedwe alionse, komanso kuchuluka kwa Excel, zingatheke . Kuzungulira mu Excel n'kofunika kuti musasokonezedwe ndi kuwonetsera kwa mtengo.
Kuti muchite "kuyendetsa mu Excel", muyenera kusankha selo yomwe ili ndi zotsatira za kuwerengera, ikani chizindikiro chofanana ("=") musanakhale nambala, sankhani ntchito "ROUND" ndikuyika nambala yofunikira ya chiwerengero.

Pankhani yowonetsa zizindikiro, ziyenera kudziwika kuti selo likuwonetsera chiwerengero cha ziwerengero zomwe zimayika pakuwoneka kwa wogwiritsa ntchito. Koma panopa nkhaniyi ikuchitika. Pamene kukula kwa selo kumasinthidwa, chiwerengero cha ziwerengero chimasintha ndi chachikulu, ndi kuwonjezeka mu selo, ndi ku mbali yaying'ono, pamene imachepa.

Monga mukuonera, kuyendayenda mu Excel si ntchito yovuta.

"CHINENERO", "DLSTR" - malemba omwe amakulolani kusintha kutalika kwa chingwe kapena kajambulidwa ntchito, komanso kuphatikiza kapena kugawa mizere.

"BBSCHET", "BDSUMM" - ntchito zazitukuko . Lolani kuti muwerenge chiwerengero cha marekodi mu database, chiwerengero cha ziyeso. Ntchito izi zikufanana ndi chiwerengero cha ntchito ya Excel ya mtundu wa "SUMM".

"CELL" - ntchitoyi imapatsa wogwiritsa ntchito zambiri zokhudza katundu wa selo.

Mathematical ntchito ndizomwe zili pa Excel. Kuwerengera ndi ntchito yawo ndiko cholinga chachikulu cha pulogalamuyi. Mu Excel, ntchito zambiri za masamu, monga sine, cosine, arccosine, arcsine, tangent, cotangent. Mukamagwiritsira ntchito ntchitozi, ma mulingo ambiri amapezeka nthawi zambiri. Kotero ndime yakuti "Kuzungulira mu Excel" ya mutu uno ili othandiza pa izi.

"MUMS", "MOPRED", "MOBR" kuti agwire ntchito ndi zilembo zamakono, matrices.

"AGGREGATE", "INTERMEDIATES" kuti apeze zoyenera komanso zamkati.

Mapulaneti, ma logarithms ofanana, ma logarithm.

Chiwerengero. "BETAABR" - amachititsa kubwerera kwa ntchito yopindulitsa kuntchito yofunikira ya beta. " Weibull " - kubweranso kwa kugawa kwa Weibull.

Komanso, MS Office Excel ili ndi ntchito zachuma , ntchito zowonongeka ndi zolemba , nthawi ndi nthawi zomwe zimagwira ntchito , kutsimikiziridwa kwa ntchito ndi katundu.

Choncho, pulogalamuyi ndiwothandizira kwambiri kwa anthu a ntchito iliyonse, omwe mwa njira imodzi amagwirizana ndi nambala ndi manambala.