Pehea e helu ai i nā pūnaewele me nā kikokikona ma Excel: i kēlā me kēia ʻanuʻu alakaʻi

He mea hoʻohana Microsoft Excel ʻoe? Ke haʻi aku nei mākou iā ʻoe pehea e helu ai i nā cell me nā kikokikona ma Excel a me nā ʻanuʻu loa, no laila ʻaʻole ʻoe kānalua. In Tecnobits Nui mākou i ka lawe ʻana iā ʻoe i nā alakaʻi i kēlā me kēia ʻanuʻu i ka Microsoft office suite, ʻo ia hoʻi, Microsoft Office. A i kēia manawa e nānā hou aku mākou iā Microsoft Excel. No ka mea, ua ʻike mākou he nui nā poʻo poʻo, akā hāʻawi ia i ka hauʻoli nui ke ʻike ʻoe i ka hoʻohana pono ʻana a me ka hoʻohana pono ʻana.

Pehea ka helu ʻana i nā cell me ka kikokikona ma Excel ʻaʻole paʻakikī e like me kou manaʻo, akā maikaʻi ke kū, heluhelu a aʻo mālie. Ma waho aʻe o kēlā, E lawe mākou iā ʻoe i kēlā mau ʻano liʻiliʻi, nā code a i ʻole nā ​​​​hana e hoʻoponopono ai i kou ola me hoʻokahi intro ma Microsoft Excel. No laila, ʻaʻohe āu mea e hopohopo ai, no ka mea, e alakaʻi ana mākou iā ʻoe i kēlā me kēia hana. E hele pū me kekahi ʻatikala e pili ana iā Microsoft Excel ma Tecnobits!

He aha ka maikaʻi o ka helu ʻana i nā cell me nā kikokikona ma Microsoft Excel?

Ua ʻike mua mākou i ke ʻano o Excel, no laila ua aʻo mākou iā ʻoe i nā manawa ʻē aʻe pehea e hoʻouna pololei ai i nā leka uila mai Excel. Ua ʻike nō hoʻi mākou he mea hana maikaʻi loa ia e maʻalahi ai ka mālama ʻana i ka nui o ka ʻikepili a no laila e hoʻokō i kahi loiloi maikaʻi. ʻAʻole mākou e noʻonoʻo lōʻihi ma ia mea. No ka mea makemake mākou e aʻo i kēia manawa pehea e helu ai i nā cell me ka kikokikona ma Excel.

He mea maʻamau ka helu ʻana i nā kelepona me nā kikokikona ma Excel ʻoiai ʻaʻole like me ia. ʻO ka ʻike ʻana i ka nui o nā cell i loaʻa i nā kikokikona e kōkua iā ʻoe e hoʻonohonoho i ka ʻike, E kōkua nō hoʻi ia iā ʻoe e kālailai i ka ʻikepili a hoʻoholo i nā hoʻoholo e pili pono ana i nā hopena.. ʻO ia hoʻi, e hoʻohana i ka Excel a ʻoi aku ka maikaʻi.

ʻO kahi laʻana inā loaʻa iā ʻoe kahi pālahalaha me kahi papa inoa nui o nā hana i kākau ʻia, a makemake ʻoe e ʻike i ka nui o ia mau mea i hoʻopau ʻia, me kahi huaʻōlelo i hoʻokomo ʻia e like me "complete", ʻike pehea e helu ai i nā cell me nā kikokikona ma Excel. E kōkua ana ʻo ia iā ʻoe e hana hou i kēia wikiwiki a maikaʻi. Akā no ka hana ʻana i kēia, pono ʻoe e ʻike i nā ʻōkuhi āpau e hoʻokō ai.

Nā ʻōkuhi like ʻole no ka helu ʻana i nā kelepona me nā kikokikona ma Excel

 

Aia nā ala like ʻole e aʻo ai pehea e helu ai i nā cell me nā kikokikona ma Excel, akā ʻo ka mea nui me nā formula. A ʻo ia ke kumu e hele ai mākou i kēia manawa me ka hopena o ka ʻatikala, formula after formula i hiki iā ʻoe ke hoʻomaka e hoʻohana. E hele kāua me kēlā me kēia ʻano hoʻohālikelike:

• Hana COUNTIF: e helu i nā pūnaewele me nā kikokikona: kekahi o nā mea maʻalahi a maikaʻi loa e aʻo i ka helu ʻana i nā cell me ka kikokikona ma Excel. Hāʻawi ia iā ʻoe e helu i nā cell e kū ana i kahi criterion kikoʻī. I kēia hihia, pono ʻoe e komo = COUNTIF(nui, koho) e helu i na keena. No ka laʻana: =COUNTIF(A1:A10, «*»)
• COUNTA hana- He hiʻohiʻona ʻē aʻe kēia no ke kumu like. E helu ia i nā cell āpau ʻaʻole i kaʻawale, me ka nānā ʻole inā he kikokikona, nā helu a i ʻole kekahi ʻikepili. No ka hana ʻana i kēia, pono ʻoe e komo = COUNT (kaulana). No ka laʻana: = COUNT(A1:A10). I kekahi mau hihia, hiki iā ʻoe ke hoʻohui i nā hana ʻelua, akā inā loaʻa iā ʻoe ka laulā o ka ʻikepili e pili ana i nā ʻāpana ʻelua, ʻoi aku ka maikaʻi o ka hoʻohana ʻana i ka COUNTIF i hoʻohui ʻia i ka ISNUMBER e hoʻokomo i nā cell helu. ʻAe, he hui ia a hōʻike mākou iā ʻoe ma lalo nei.
• huiia: I kēia manawa ua hoʻomaopopo mua ʻoe i ka mechanics, ua hana ʻia ka hui ʻana ma kēia ʻano = SUM(–(ISNUMBER(A1:A10)=FALSE)) me kēia ʻano hoʻohālikelike e helu ʻoe i ka nui o nā cell i loaʻa ka kikokikona a e kāpae ʻia nā cell me helu. E hoʻokaʻawale mākou i ke kikokikona mai ke koena o ka ʻikepili.

Kānana kikokikona me Excel

Akā aia ia ʻO kahi ala hope e kānana ai i nā kelepona me nā kikokikona ma Microsoft Excel. Inā manaʻo ʻoe ua ʻike mua ʻoe i ka helu ʻana i nā cell me ka kikokikona ma Excel, hewa ʻoe, ʻo ka hapa wale nō ʻoe i ʻike. Ke nalo nei mākou i kahi ala hope loa a ke hele nei mākou me ia.

Ma ka hoʻohana ʻana i nā kānana e hiki iā mākou ke helu i nā cell me nā kikokikona ma Excel. ʻOiai he ʻoiaʻiʻo ʻaʻole mākou e kamaʻilio e pili ana i kahi ʻano e like me ia, hiki iā ia ke kōkua iā ʻoe inā paʻakikī nā mea āpau i luna iā ʻoe. No ka hana ʻana i kēia, e hana i kēia:

1. E koho i ka nui o nā pūnaewele āu e makemake ai e kānana
2. Kaomi ma ka ʻaoʻao "Data" a laila koho i ka "Filter"
3. E ʻike ʻoe i nā pua ma kēlā me kēia kolamu poʻo. I kēia manawa pono ʻoe e kaomi i ka pua āu e makemake ai e kānana a kaomi i nā kānana kikokikona.
4. E koho i waena o ia mea i loko a i ʻole i loko e like me kou kūpono
5. Ke hoʻohana ʻia ka kānana, ʻike wale ʻoe i nā cell i loaʻa ka kikokikona a i ʻole.

Manaʻo mākou ua aʻo ʻoe pehea e helu ai i nā cell me nā kikokikona ma Excel i kēia manawa. Manaʻo mākou he mea nui ka ʻike pehea e hoʻohana maikaʻi ai i ka papahana, a ʻo ia ke kumu e hoʻoikaika nui ai mākou i kēia mau ʻatikala. No ka mea mākou nā mea hoʻohana ʻO Microsoft Excel i ko mākou ola i kēlā me kēia lā a makemake mākou e haʻi i ke ʻano o ka polokalamu maikaʻi inā ʻike ʻoe i ka hoʻohana pono ʻana. E ʻike iā ʻoe ma ka ʻatikala aʻe!