Microsoft kela aku He polokalamu ikaika a hiki ke kōkua i nā mea hoʻohana e hoʻonohonoho, hoʻopaʻa, a hōʻike i kā lākou ʻikepili. ʻO ia kekahi o nā papahana pāpalapala kaulana loa a hoʻohana ʻia ma nā ʻano ākea ākea a o na oihana. He mea hoʻomaka a mea hoʻohana paha ʻoe, hiki iā ʻoe ke pōmaikaʻi mai ka hoʻomaʻamaʻa manuahi e aʻo ai pehea e hoʻohana ai iā Excel a loaʻa i nā mea maikaʻi loa o kāna mau hiʻohiʻona. Ma kēia ʻatikala, e nānā mākou i nā hiʻohiʻona nui o Excel a haʻi iā ʻoe pehea e hiki ai iā ʻoe ke pōmaikaʻi mai ka hoʻomaʻamaʻa manuahi e haku iā lākou.
ʻO nā hiʻohiʻona nui o Excel
Hāʻawi ʻo Excel i kahi ākea o nā hiʻohiʻona e kōkua i nā mea hoʻohana e hoʻokele a nānā i kā lākou ʻikepili. ʻO nā hiʻohiʻona koʻikoʻi ka hoʻokele ʻikepili, ka helu ʻikepili a me ka nānā ʻana, nā pakuhi a me nā papa pivot (DCTs).
- Hoʻokele ʻikepili: Hiki iā Excel i nā mea hoʻohana ke hoʻoponopono, ʻano, kānana a hoʻonohonoho i kā lākou ʻikepili. Hiki iā ʻoe ke hoʻokomo i ka ʻikepili mai nā kumu waho a hana i nā ʻōkuhi no ka helu ʻana i ka ʻikepili.
- Ka helu ʻana a me ka nānā ʻana: Hiki ke hoʻohana ʻia ʻo Excel e hana i nā helu paʻakikī a me ka nānā ʻana i kāu ʻikepili. Hiki iā ʻoe ke hoʻohana i nā hana i kūkulu ʻia e hana i nā helu helu helu a me ka ʻikepili ʻikepili holomua.
- Nā Palapala: Hiki iā Excel ke hana i nā pakuhi e hōʻike maka i kāu ʻikepili. Hiki iā ʻoe ke koho mai nā ʻano pakuhi like ʻole e like me nā pakuhi pahu, nā pakuhi pai, nā kiʻi kolamu, a me nā palapala hoʻopuehu.
- Nā Papa Pivot: Hāʻawi nā PCT iā ʻoe e nānā wikiwiki a maʻalahi i ka ʻikepili. Hiki iā ʻoe ke hana i nā TCD e hōʻike i ka ʻikepili ma nā papa a me nā kiʻi.
E aʻo i ka haku Excel
Nui nā ala e aʻo ai i ka haku Excel. Hiki iā ʻoe ke loaʻa manuahi aʻoaʻo pūnaewele, nā alakaʻi hoʻohana a me nā puke hoʻohana. Hiki iā ʻoe ke lawe i nā papa kūikawā a i ʻole nā papahana aʻo mamao.
- Nā haʻawina aʻoaʻo pūnaewele manuahi: Hāʻawi nā kumu aʻo pūnaewele i kahi ala kūpono e aʻo ai pehea e hoʻohana ai iā Excel. Hiki iā ʻoe ke loaʻa nā haʻawina manuahi ma nā pūnaewele e like me YouTube a i ʻole blogs.
- Nā alakaʻi o nā mea hoʻohana: ʻO nā alakaʻi o nā mea hoʻohana nā palapala e hāʻawi i ka ʻike kikoʻī e pili ana i nā hiʻohiʻona a me ka hoʻohana ʻana o Excel. Hiki iā ʻoe ke loaʻa nā alakaʻi hoʻohana ma ka pūnaewele a i ʻole ma nā hale kūʻai kamepiula.
- Nā manual mea hoʻohana: He ala maikaʻi nā manual mea hoʻohana e aʻo pehea e hoʻohana ai iā Excel. Hāʻawi lākou i ka ʻike kikoʻī a me ka wehewehe ʻana o kēlā me kēia hiʻohiʻona. Hiki iā ʻoe ke loaʻa nā manual hoʻohana ma ka pūnaewele a i ʻole ma nā hale kūʻai kamepiula.
- Nā papahana kūikawā: He ala maikaʻi loa nā papa kūikawā e aʻo ai pehea e hoʻohana ai iā Excel. Hiki iā ʻoe ke loaʻa nā papa kūikawā ma ka pūnaewele a ma nā kula kūloko. Hiki ke lōʻihi nā papa mai kekahi mau hola a hiki i kekahi mau lā a hiki ke manuahi a uku ʻia paha.
- Ke aʻo mamao: ʻO ke aʻo mamao kahi ala kūpono e aʻo ai pehea e hoʻohana ai iā Excel. Hiki iā ʻoe ke loaʻa nā papa aʻo mamao ma nā pūnaewele e like me Udemy a i ʻole nā kahua aʻo pūnaewele e like me Coursera.
Aʻo manuahi Excel
Nui nā ala e loaʻa ai ke aʻo manuahi Excel. Hiki iā ʻoe ke loaʻa nā haʻawina manuahi, nā puke, a me nā haʻawina pūnaewele e kōkua iā ʻoe e haku i ka papahana.
- Nā Aʻoaʻo manuahi: Hāʻawi nā kumu aʻo pūnaewele i kahi ala kūpono a manuahi e aʻo ai pehea e hoʻohana ai iā Excel. Hiki iā ʻoe ke loaʻa nā haʻawina manuahi ma nā pūnaewele e like me YouTube a i ʻole blogs.
- Nā puke manuahi: Nui nā puke manuahi e kōkua iā ʻoe e aʻo pehea e hoʻohana ai iā Excel. Hiki iā ʻoe ke loaʻa iā lākou ma nā pūnaewele e like me Amazon a i ʻole nā papa hoʻolaha e like me Leanpub.
- Nā papa pūnaewele manuahi: He ala maikaʻi loa nā papa pūnaewele manuahi e aʻo ai i ka haku Excel. Hiki iā ʻoe ke loaʻa nā haʻawina manuahi manuahi ma nā pūnaewele e like me Udemy, edX, a me Coursera.
Panina
He polokalamu ikaika ʻo Microsoft Excel i hiki ke kōkua i nā mea hoʻohana e hoʻonohonoho, kālailai, a hōʻike i kā lākou ʻikepili. ʻO ka mea pōmaikaʻi, nui nā ala e loaʻa ai ke aʻo manuahi Excel. Hiki iā ʻoe ke loaʻa nā haʻawina aʻoaʻo pūnaewele, nā puke manuahi, a me nā haʻawina manuahi manuahi e kōkua iā ʻoe e haku i ka papahana.
