Chii Excel wevacheche, uye chii nokuda?

Kana wakambokurukura aishanda spreadsheet pakombiyuta yako, nechivimbo chikuru tinogona kutaura kuti akazarurwa uye aongorore navo Microsoft Excel, iwe inozivikanwa chirongwa. Uye ichi hazvishamisi, sezvo chikumbiro ndiyo yechipiri rakajairika ari chidimbu neezvitendero hofisi Ezvemutauro.

Zvinosuruvarisa padanho ruzivo vanoshandisa Kazhinji disappointingly yakaderera, izvo zvinowanzoita kuti dzakasiyana-siyana nemigumisiro, kana kutadza wakakwana kuita zvinhu kushandiswa. Zvikurukuru, sei muchiziva kuti Excel ndiye nzira? Kana kwete, nyaya yedu zvakanyorwa zvakananga iwe!

Nokudaro, zvokuimba fomu iri raireva chaiwo rwezuva mirayiro kuti vanobvumira vanoshandisa ari nyore uye zvakakunakira fomu kuti kutsungirira zvikuru kunzwisisa masvomhu. Somuenzaniso, kushandisa mano avo, unogona kusika yako mabasa. Kwete kuva kusina, kuti Excel Masvomhu, akanyorwa se "= Verengai (B1: B64)".

Regai kunyonganisa chiratidzo ":" nekupesana, sezvo iyi, ndiyo chete kuwanda. Kana decipher, mashoko aya anopa murayiro kuti summation tsika iri mumasero, izvo siyana B1 kusvika B64.

Mikana pahupamhi chaizvo Masvomhu. Tora mamiriro ezvinhu apo unofanira zvacho zvaitika zvinodiwa zvakawanda masero. Chokwadi, unogona kushandisa richikunetesa Chinyorwa Masvomhu (kwete zano kuita kudaro!), Asi chii kana kunoshanda spreadsheet? Kuti aite izvi, edza zvinotevera: Vhurai tafura mutsva muchitokisi rokutanga (A1) kuti chipi nechipi. Ngatitii wako Excel payakavakirwa kuti vapiwa kaviri kunokosha muchitokisi chimwe nechimwe tevera.

Zvadaro tinya kuruboshwe negonzo bhatani pamusoro muchitokisi A2, uye ipapo woisa cursor iri nzira chiyamuro bhokisi. Kupinda chiratidzo "=", nyora "A1 * 2" (pakupedzisira wasvikapo "= A1 * 2"). Click on «Kupinda», uye ipapo yechipiri mbiru pakarepo anooneka nhamba "2". Asi iwe uchida Excel payakavakirwa rwakapararira mamwe masero? Musafunganya, kuti kunyange nyore.

Nekudzvanya kuruboshwe negonzo bhatani pamusoro sero A2, mukati kwaari nechepazasi rworudyi pakona pamwe negonzo, achizvuzvurudza kubudikidza kuwanda masero kuti unoda. Zvino haugoni kunetseka Conversion: exchange ose chirongwa zvichabviswa vaurayiwe kwaita. Ndinoziva sei zvakarurama payakavakirwa chinorondedzerwa muna Excel spreadsheet? Simply sarudza kuruboshwe bhatani muchitokisi uchifarira, zvino tarisa panopindwa mutsetse: Kana pane kuratidza zvakada "A8 * 2", ipapo zvose zvakanaka.

Haina refu kutaura sei zvikuru chinobatsira functionality ichi vaya vari kuramba kumanikidzwa kushanda zvemagetsi magwaro! Iwe achasiyiwa kubva kuva kune richikunetesa uye kuramba basa ne "Calculator", aurayiwe nguva kunyange kunzwisisa kushanda akavhiyiwa vachawa kakawanda chose. Mukuwedzera, tambo pakati zvokuimba Excel zvirokwazvo aivabatsira zvikuru upenyu vadzidzi, sezvo ivo nokukurumidza uye effortlessly achaita overenga chero rabhoritari basa.

Muchidimbu, kudzidza zvakanaka kushandisa chirongwa, iwe uchava husava zvikuru upenyu hwako nokuwedzera kunyatsoshanda yavo.