ʻAʻoleʻike nui nā mea hoʻohana i ka mana piha o Excel. ʻAe,ʻo ia, ua lohe mākou i ka papahana no ka hanaʻana me nā papa,ʻae lākou e hoʻohana ai, e nānā i kekahi mau palapala. Keʻae nei au, he hana like wau, a hiki i ka hāʻuleʻehaʻana wau ma luna o kahi hana maʻalahi, e like me keʻano: e helu i nā huina o nā pūnaewele ma kekahi o kaʻu papa ma Excel. Ua hana au i kahi ma ka heluhelu (i kēia manawa heʻakaʻaka :-P), akā i kēia manawa ua nui loa ka papaʻaina, a ua hoʻoholo wau ua hiki i ka wā e noiʻi i hoʻokahi aʻelua paha mau kumuhana maʻalahi ...
Ma kēiaʻatikala, e kamaʻilio wau e pili ana i ke kumukūʻai nui, i maʻalahi ka maopopoʻana, e nānā mākou i kahi mau hiʻohiʻona.
1) No ka heluʻana i kekahi huina o nā koho nui, hiki iāʻoe ke kaomi i kekahi pūnaewele ma Excel a kākau i loko o ia mea, no ka laʻana, "= 5 + 6", a laila kaomi wale i Enter.
2)ʻAʻole ka lōʻihi o ka hopena, ma loko o ke keʻena i kākau aiʻoe i ke kumuhana e hōʻikeʻia ka hopena "11". Ma ke ala, ināʻoe e kaomi ma kēia kamepiula (kahi e kākauʻia ai ka helu 11) - ma ka paʻina'ōlelo (e nānā i ka pakuhi ma luna, arrow number 2, ma ka'ākau) -ʻaʻoleʻoe eʻike i ka helu 11, akā, likeʻole "= 6 + 5".
3)'Ānō e ho'āʻo mākou e helu i ka huina o nā helu mai nā pūnaewele. No ka hanaʻana i kēia, e hele mua i ka māhele "FORMULA" (menu ma luna aʻe).
Ma hope aʻe, koho i nā pūnaewele he nui i ka helu waiwai āu e makemake ai e helu (ma ka hoʻolele i lalo,ʻekolu mauʻano waiwai e hoʻonuiʻia i ka'ōmaʻomaʻo). A laila, e kaomi ma kaʻaoʻao "AutoSum".
4) Ma muli o ka hopena, eʻikeʻia ka huina o nā pūnaewele muaʻekolu i loko o ka pūnaewele pili. E nānā i kaʻaoʻao i lalo ma lalo.
Ma ke ala, inā mākou e hele i ka pūnaewele me ka hopena, eʻike mākou i ka huahana pono'ī: "= SUM (C2: E2)", kahi i waiho aiʻo C2: E2 i nā pūnaewele e pono e'ōwiliʻia.
5) Ma ke ala, inā makemakeʻoe e helu i ka huina ma nā lālani i koe ma ka papa, a laila e kope kope wale i ka formula (= SUM (C2: E2) i nā pūnaewele'ē aʻe. Hoʻopili ka Excel i nā mea a pau.
ʻO kēia kumuhanaʻano maʻalahi ka Excel i mea hana ikaika no ka heluʻana i nāʻikepili! E noʻonoʻoʻoeʻo Excelʻaʻole hoʻokahi, akā, he mau haneli o nā kumu likeʻole (ma ke ala, ua kamaʻilio mua wau e pili ana i ka hanaʻana me nā mea kaulana loa). Mahalo iā lākou, hiki iāʻoe ke helu i kekahi mea a me kekahi mea,ʻoiai e mālama i ka nui o kou manawa!
ʻO ka mea maikaʻi loa ia.
