Contents
Aʻo Excel no nā Dummies e ʻae iā ʻoe e hoʻomaopopo maʻalahi a haku i nā mākau kumu o ka hana ʻana ma Excel, i hiki iā ʻoe ke neʻe me ka hilinaʻi i nā kumuhana paʻakikī. Na ke kumu aʻo e aʻo iā ʻoe pehea e hoʻohana ai i ka interface Excel, e hoʻopili i nā ʻōkuhi a me nā hana e hoʻoponopono ai i nā pilikia like ʻole, kūkulu i nā kiʻi a me nā pakuhi, hana me nā papa pivot a ʻoi aku.
Ua hana kūikawā ʻia ke kumu aʻo no nā mea hoʻohana Excel novice, ʻoi aku ka pololei no nā "dummies piha". Hāʻawi ʻia ka ʻike ma nā pae, e hoʻomaka ana me nā kumu kumu. Mai ka ʻāpana a i ka ʻāpana o ke kumu aʻo, hāʻawi ʻia nā mea hoihoi a me nā mea hoihoi. Ma hope o ka pau ʻana o ka papa holoʻokoʻa, e hoʻohana pono ʻoe i kou ʻike i ka hoʻomaʻamaʻa a aʻo pehea e hana ai me nā mea hana Excel e hoʻonā ai i ka 80% o kāu mau hana āpau. A ʻo ka mea nui loa:
- E poina mau ʻoe i ka nīnau: "Pehea e hana ai ma Excel?"
- I kēia manawa ʻaʻohe mea e ʻaʻa e kapa iā ʻoe he "teapot".
- ʻAʻole pono e kūʻai i nā kumu aʻo pono ʻole no ka poʻe hoʻomaka, a laila e hōʻiliʻili i ka lepo ma ka papa no nā makahiki. E kūʻai wale i nā palapala kūpono a pono hoʻi!
- Ma kā mākou pūnaewele e ʻike ʻoe i nā papa like ʻole he nui, nā haʻawina a me nā manual no ka hana ʻana ma Microsoft Excel a ʻaʻole wale. A ʻo kēia mau mea a pau ma kahi hoʻokahi!
Mahele 1: Nā Kumu Excel
- Hoʻolauna iā Excel
- ʻO Microsoft Excel interface
- Lipine ma Microsoft Excel
- Nānā i hope ma Excel
- ʻO ka ʻaoʻao kiʻekiʻe a me ka ʻike puke
- Hana a wehe i nā puke hana
- E hana a wehe i nā puke hana Excel
- Ke ʻano hoʻohālikelike ma Excel
- Mālama i nā puke a kaʻana like
- E mālama a hoʻihoʻi hou i nā puke hana ma Excel
- Ke lawe ʻana aku nei i nā puke hana Excel
- Kaʻana like ʻana i nā puke hana Excel
- Nā Kumu Pūnaewele
- Pūnaewele ma Excel - nā manaʻo kumu
- Maʻiʻo pūnaewele ma Excel
- Ke kope, hoʻoneʻe a me ka holoi ʻana i nā cell ma Excel
- Hoʻopiha piha i nā pūnaewele ma Excel
- E huli a hoʻololi i Excel
- Hoʻololi i nā kolamu, nā lālani a me nā pūnaewele
- E hoʻololi i ka laulā kolamu a me ke kiʻekiʻe o ka lālani ma Excel
- Hoʻokomo a holoi i nā lālani a me nā kolamu ma Excel
- E neʻe a hūnā i nā lālani a me nā kolamu ma Excel
- Wehi i ka kikokikona a hoʻohui i nā pūnaewele ma Excel
- Hoʻopili pūnaewele
- Ka hoʻonohonoho kikokikona ma Excel
- Hoʻopololei i nā kikokikona ma nā pūnaewele Excel
- Nā palena, pale a me nā ʻano kelepona ma Excel
- Hōʻano helu ma Excel
- Nā Kuleana Pepa Excel
- Hoʻololi hou, hoʻokomo a holoi i kahi pepa ma Excel
- E kope, hoʻoneʻe a hoʻololi i ke kala o kahi pepa hana ma Excel
- Ka hui pū ʻana i nā palapala ma Excel
- Hoʻonohonoho ʻaoʻao
- Hōʻano i nā palena a me ka ʻaoʻao ʻaoʻao ma Excel
- E hoʻokomo i nā haʻihaʻi ʻaoʻao, paʻi i nā poʻo a me nā wāwae ma Excel
- Pai puke
- Papa paʻi ma Microsoft Excel
- E hoʻonoho i kahi paʻi ma Excel
- Ka hoʻonohonoho ʻana i nā palena a me ka unahi i ka paʻi ʻana ma Excel
Mahele 2: Nā ʻōkuhi a me nā hana
- Māmā Māmā
- Nā mea hoʻohana makemakika a me nā helu kelepona ma nā ʻano hoʻohālikelike Excel
- Ke hana ʻana i nā ʻōkuhi maʻalahi ma Microsoft Excel
- Hoʻoponopono i nā ʻōkuhi ma Excel
- Nā ʻōlelo paʻakikī
- ʻO ka hoʻomaka ʻana i nā formula paʻakikī ma Excel
- Ke hana ʻana i nā ʻōkuhi paʻakikī ma Microsoft Excel
- Pili pili a pili pono
- Nā loulou pili ma Excel
- Nā kuhikuhi piha ma Excel
- Nā loulou i nā pepa ʻē aʻe ma Excel
- Nā ʻōhumu a me nā hana
- Hoʻomaka i nā hana ma Excel
- Hoʻokomo i kahi hana ma Excel
- Hale Waihona Puke ma Excel
- Wizard hana ma Excel
Mahele 3: Hana me ka ʻikepili
- Ka Mana o ka Pepa Hana
- Nā ʻāina maloʻo ma Microsoft Excel
- E hoʻokaʻawale i nā pepa a nānā i ka puke hana Excel ma nā puka makani like ʻole
- Hoʻokaʻawale i ka ʻikepili ma Excel
- Kānana ʻikepili ma Excel
- E hana pū me nā hui a me ka hoʻopaʻa ʻana
- Nā pūʻulu a me nā subtotal ma Excel
- Nā papa ma Excel
- Hana, hoʻololi a holoi i nā papa ma Excel
- Nā Palapala Kiʻi a me nā Sparklines
- Nā kiʻi ma Excel - Nā kumu
- Hoʻolālā, Kāhua, a me nā koho palapala ʻē aʻe
- Pehea e hana ai me nā sparklines ma Excel
Mahele 4: Nā hiʻohiʻona kiʻekiʻe o Excel
- Ke hana nei me nā memo a me nā hoʻololi ʻana
- E hahai i nā hoʻoponopono ma Excel
- E nānā i nā hoʻoponopono ma Excel
- Nā ʻōlelo kelepona ma Excel
- Hoʻopiha a pale ʻana i nā puke hana
- E pani a pale i nā puke hana ma Excel
- Ka Hoʻomumu Kūʻai
- Hōʻano Kūlana ma Excel
- Nā papa kuhikuhi a me ka ʻikepili ʻikepili
- Hoʻomaka i nā Pivot Tables ma Excel
- Pivot Data, Nā kānana, nā mea ʻoki, a me nā papa kuhikuhi
- He aha inā inā ʻike ʻia ma Excel
Mahele 5: Nā Kūlana Kiʻekiʻe ma Excel
- Hoʻoponopono mākou i nā pilikia me ka hoʻohana ʻana i nā hana logical
- Pehea e hoʻonohonoho ai i kahi kūlana boolean maʻalahi ma Excel
- Ke hoʻohana nei i nā hana Boolean Excel e wehewehe i nā kūlana paʻakikī
- IF hana ma Excel me kahi laʻana maʻalahi
- Ka helu ʻana a me ka hōʻuluʻulu ʻana ma Excel
- E helu i nā pūnaewele ma Excel me ka hoʻohana ʻana i nā hana COUNTIF a me COUNTIF
- E hōʻuluʻulu i Excel me ka hoʻohana ʻana i nā hana SUM a me SUMIF
- Pehea e helu ai i ka huina kumulative ma Excel
- E helu i nā awelika kaumaha me ka SUMPRODUCT
- Ke hana nei me nā lā a me nā manawa ma Excel
- Ka lā a me ka manawa ma Excel - nā manaʻo kumu
- Ke hoʻokomo ʻana a me ka hoʻopili ʻana i nā lā a me nā manawa ma Excel
- Nā hana e unuhi i nā ʻāpana like ʻole mai nā lā a me nā manawa ma Excel
- Nā hana e hana a hōʻike i nā lā a me nā manawa ma Excel
- Nā hana Excel no ka helu ʻana i nā lā a me nā manawa
- Huli ʻikepili
- Hana VLOOKUP ma Excel me nā hiʻohiʻona maʻalahi
- VIEW hana ma Excel me kahi laʻana maʻalahi
- INDEX a me MATCH hana ma Excel me nā hiʻohiʻona maʻalahi
- Maikaʻi eʻike
- ʻO nā hana helu Excel e pono ai ʻoe e ʻike
- Pono ʻoe e ʻike i nā hana makemakika Excel
- Nā hana kikokikona Excel ma nā laʻana
- ʻO ka ʻike nui o nā hewa i loaʻa i nā formula Excel
- Ke hana nei me nā inoa ma Excel
- ʻO ka hoʻomaka ʻana i nā inoa kelepona a me nā laina ma Excel
- Pehea e inoa ai i kahi cell a i ʻole ka laulā ma Excel
- 5 Nā rula a me nā alakaʻi no ka hana ʻana i nā inoa kelepona a me nā inoa ma Excel
- Luna inoa ma Excel - Nā mea hana a me nā hiʻohiʻona
- Pehea e inoa ai i nā mea mau ma Excel?
- Ke hana nei me nā arrays ma Excel
- ʻO ka hoʻomaka ʻana i nā formula array ma Excel
- Nā ʻōlelo hoʻohālikelike multicell ma Excel
- ʻO nā ʻōlelo hoʻohālikelike hoʻokahi ma Excel
- Nā pūʻulu o nā mea mau ma Excel
- Ke hoʻoponopono ʻana i nā ʻano papa hana ma Excel
- Ke hoʻohana nei i nā ʻōkuhi array ma Excel
- ʻO ke ala e hoʻoponopono ai i nā ʻōkuhi array ma Excel
Pauku 6: Koho
- Ka hoʻopilikino ʻana i ke kikowaena
- Pehea e hana ai i ka Ribbon ma Excel 2013
- E kaomi i ke ʻano o ka Ribbon ma Excel 2013
- Nā ʻano loulou ma Microsoft Excel
Makemake ʻoe e aʻo hou e pili ana iā Excel? No ʻoe, ua hoʻomākaukau mākou i ʻelua mau haʻawina maʻalahi a pono hoʻi: 300 mau hiʻohiʻona Excel a me 30 mau hana Excel i 30 mau lā.