Kānana ma Excel – Kumu

ʻO ka kānana ʻikepili ma Excel hiki iā ʻoe ke hōʻike i waena o ka nui o ka ʻike i ka mea āu e pono ai i kēia manawa. No ka laʻana, loaʻa kahi papa inoa o nā tausani o nā waiwai i kahi hypermarket nui i mua ou, hiki iā ʻoe ke koho wale i nā shampoos a i ʻole nā ​​​​kilika mai ia mea, a hūnā i ke koena. Ma kēia haʻawina, e aʻo mākou pehea e hoʻopili ai i nā kānana i nā papa inoa ma Excel, e hoʻonohonoho i ka kānana ma nā kolamu i ka manawa hoʻokahi, a e wehe i nā kānana.

Inā nui ka ʻikepili i kāu papaʻaina, paʻakikī paha ka ʻimi ʻana i ka ʻike āu e pono ai. Hoʻohana ʻia nā kānana e hōʻemi i ka nui o nā ʻikepili i hōʻike ʻia ma kahi pepa Excel, e ʻae iā ʻoe e ʻike wale i ka ʻike āu e pono ai.

Ke noi ʻana i kahi kānana ma Excel

Ma kēia laʻana, e hoʻopili mākou i kahi kānana i ka log hoʻohana lako e hōʻike i nā kamepiula a me nā papa i loaʻa no ka loiloi.

1. E koho i kekahi cell i ka papaʻaina, no ka laʻana cell A2.

No ke kānana ʻana e hana pololei ma Excel, pono e loaʻa i ka pepa haʻawina kahi lālani poʻomanaʻo i hoʻohana ʻia e kapa i kēlā me kēia kolamu. Ma kēia laʻana, ua hoʻonohonoho ʻia ka ʻikepili ma ka pepa haʻawina ma ke ʻano he kolamu me nā poʻomanaʻo ma ka lālani 1: ID #, Type, Iron Description, a pēlā aku.

1. E kaomi i ka 'Ikepili, a laila kaomi i ke kauoha Kānana.
2. Hōʻike ʻia nā pihi pua ma nā poʻomanaʻo o kēlā me kēia kolamu.
3. Kaomi ma ia pihi ma ke kolamu āu e makemake ai e kānana. I kā mākou hihia, e hoʻopili mākou i kahi kānana i ke kolamu B e ʻike i nā ʻano mea pono wale nō.
4. E hōʻike ʻia ka papa koho kānana.
5. Wehe i ka pahu E koho i nā mea a paue wehe koke i nā mea a pau.
6. E nānā i nā pahu no nā ʻano mea hana āu e makemake ai e waiho i ka pākaukau, a laila kaomi OK. Ma kā mākou laʻana, e koho mākou Laptops и papae ʻike wale i kēlā mau ʻano lako.
7. E kānana ʻia ka papa ʻikepili, e hūnā i nā ʻike āpau i kūpono ʻole i nā koina. I kā mākou laʻana, ʻike ʻia nā kamepiula a me nā papa.

Hiki ke hoʻohana ʻia ke kānana ma ke koho ʻana i ke kauoha Hoʻokaʻina a me ka kānana uku pila Home.

E hoʻopili i nā kānana he nui ma Excel

Hiki ke hōʻuluʻulu ʻia nā kānana ma Excel. 'O ia ho'i, hiki iā 'oe ke ho'opili i nā kānana he nui i ka papa ho'okahi e hō'emi i nā hualoa'a kānana. I ka laʻana mua, ua kānana mākou i ka papaʻaina e hōʻike i nā kamepiula a me nā papa wale nō. ʻO kā mākou hana ʻo ka hōʻemi ʻana i ka ʻikepili a hōʻike wale i nā kamepiula a me nā papa i waiho ʻia no ka loiloi i ʻAukake.

1. Kaomi i ke pihi pua ma ke kolamu āu e makemake ai e kānana. I kēia hihia, e hoʻopili mākou i kahi kānana hou i ke kolamu D e ʻike i ka ʻike ma ka lā.
2. E hōʻike ʻia ka papa koho kānana.
3. E nānā a wehe paha i nā pahu ma muli o ka ʻikepili āu e makemake ai e kānana, a laila kaomi OK. E wehe mākou i nā mea a pau koe ʻAukake.
4. E hoʻohana ʻia ka kānana hou, a ʻo nā laptops a me nā papa i waiho ʻia no ka hōʻoia ʻana i ʻAukake e waiho ʻia ma ka papa.

Ke wehe nei i kahi kānana ma Excel

Ma hope o ka hoʻohana ʻana i ka kānana, ma hope a ma hope paha e pono e wehe a wehe paha i mea e kānana i ka ʻike ma kahi ʻano ʻē aʻe.

1. Kaomi i ke pihi pua ma ke kolamu āu e makemake ai e wehe i ke kānana. I kā mākou laʻana, e wehe mākou i ka kānana mai ka kolamu D.
2. E hōʻike ʻia ka papa koho kānana.
3. E koho i ka mea Wehe i ka kānana mai ke kolamu… I kā mākou laʻana, e wehe mākou i ka kānana mai ke kolamu Waiho ʻia no ka nānā ʻana.
4. E wehe ʻia ka kānana a e ʻike hou ʻia nā ʻikepili huna mua ma ka pepa Excel.

No ka wehe ʻana i nā kānana a pau ma kahi papa Excel, kaomi i ke kauoha Kānana uku pila 'Ikepili.