Ahakoa karekau he ahua kapua kupu a Excel, ka taea e koe te hanga Nga kapua kupu Excel ngawari ki te whakamahi i tetahi o nga tikanga e toru i raro nei:
Tikanga 1: Whakamahia he taapiri Excel
Ko te tikanga whakauru ko te whakamahi i te taapiri-mai, ka taea e koe te hanga i tetahi kapua kupu ki roto i to ripanga Excel. He kōwhiringa rongonui me te kore utu ko Bjorn Word Cloud. Ka taea e koe te rapu i etahi atu taputapu kapua kupu i roto i te whare pukapuka taapiri.
Hipanga 1: Whakaritehia o raraunga
- Whakanohoia nga tuhinga katoa e hiahia ana koe ki te tātari ki te pou kotahi. Ka taea e ia pūtau te whakauru i tetahi kupu maha ranei.
Hipanga 2: Tāutahia te taapiri "Bjorn Word Cloud".
- Haere ki te Kōkuhu ripa ki runga ria.
- Pāwhiritia te Tikina Tāpiri-mai.
- I roto i te toa Tāpiri-mai Office, rapua "Bjorn Word Cloud".
- Pāwhiritia te Tāpiri te paatene i te taha o te taapiri Pro Word Cloud.
Hipanga 3: Hangaia te kupu kapua
- Haere ki te Kōkuhu ripa ka pāwhiritia Taku Tāpiri-mai.
- Tīpakohia Bjorn Kupu Kapua ki te whakatuwhera i tana panui i te taha matau o to mata.
- Ka kitea aunoa e te taapiri-mai to awhe kuputuhi kua tohua. Patohia te Waihangatia he kupu kapua pātene.
Hipanga 4: Whakaritea me te tiaki
- Ko te taapiri-mai he maha nga whiringa hei whakarite i te momotuhi, nga tae, te whakatakotoranga (whakapae, poutū, aha atu), me te keehi o o kupu.
- Ka taea hoki te whakatika i te maha o nga kupu ka whakaatuhia me te tarai i nga "kupu kati" noa (penei i te 'te', 'me', 'a').
- Ka puta te kupu kapua ki te paewhiri. Ka taea e koe te kaweake hei SVG, GIF, hei wharangi paetukutuku ranei.
Tikanga 2: Whakamahia he kaihanga kapua kupu ipurangi koreutu
Mena kaore koe e hiahia ki te whakauru i tetahi taapiri, ka taea e koe te whakamahi i tetahi taputapu ipurangi koreutu. He maha nga wa ka whakaratohia e tenei tikanga nga whiringa whakaritenga ake.
Hipanga 1: Whakaritea me te kape i o raraunga ki Excel
- Whakaritehia o kuputuhi katoa ki te pou kotahi.
- Miramirahia te tīwae katoa ka tārua ki tō papatopenga (Ctrl+C).
Hipanga 2: Whakamahia he taputapu ipurangi
- Whakatere ki te paetukutuku kaihanga kupu kupu kore utu, penei AhaSlides kupu kaihanga kapua, https://www.google.com/search?q=FreeWordCloud.com ranei.
- Rapua he kōwhiringa "Kawemai" "Whakapiri Kuputuhi" ranei.
- Whakapirihia to tuhinga i kapea mai i a Excel ki te pouaka kuputuhi kua whakaratohia.
Hipanga 3: Hanga, whakarite, me te tango
- Patohia te paatene "Hanga", "Tirohia" hei hanga i te kupu kapua.
- Whakamahia nga taputapu o te paetukutuku ki te whakarite momotuhi, ahua, tae, me te whakatakotoranga kupu.
- Kia makona koe, tango i te kupu kapua hei ahua (he PNG, JPG ranei).
Tikanga 3: Whakamahia te Power BI
Mena kei a koe te Power BI kua reri i runga i to papamahi, he huarahi pai tenei engari he huarahi matatau ake ki te whakaputa i nga kapua kupu Excel ina hiahia koe ki te tukatuka i te maha o nga kupu.
Hipanga 1: Whakaritehia o raraunga ki Excel
Tuatahi, me whakarite tika koe i o raraunga kuputuhi ki roto i te rau Excel. Ko te whakatakotoranga pai he pou kotahi kei roto i ia pūtau nga kupu me nga kianga e hiahia ana koe ki te tātari.
- Waihangatia he Tīwae: Whakauruhia o tuhinga katoa ki roto i te pou kotahi (hei tauira, te Tiwae A).
- Whakahōputu hei Ripanga: Tīpakohia ō raraunga ka pēhi Ctrl + T. Ka whakahōputuhia hei Ripanga Excel mana, he ngawari ake te panui a Power BI. Homai he ingoa marama mo te ripanga (hei tauira, "WordData").
- Tiaki tō kōnae Excel.
Hipanga 2: Kawemai i to konae Excel ki Power BI
Whai muri, whakatuwherahia te Papamahi Power BI (he tango kore utu mai i Microsoft) ki te hono atu ki to kōnae Excel.
- Whakatuwheratia te Power BI.
- I runga i te Kāinga ripa, pāwhiritia Tikina he Raraunga ka tīpako Pukamahi Excel.
- Kimihia ka whakatuwheratia te kōnae Excel i tiakina e koe.
- i roto i te Navigator te matapihi ka puta, tirohia te pouaka i te taha o te ingoa o to ripanga ("WordData").
- Pāwhiritia Utaina. Ka puta to raraunga inaianei ki te Raraunga pihanga kei te taha matau o te matapihi Power BI.
Hipanga 3: Waihanga me te whirihora i te kupu kapua
Inaianei ka taea e koe te hanga i te tino tirohanga.
- Tāpirihia te tirohanga: i roto i te Ngā tirohanga pihanga, kimihia ka paato i te Kapua Kupu tohu. Ka puta he tauira patea ki runga i to konae purongo.
- Tāpirihia ō raraunga: Tuhinga ka whai mai Raraunga pihanga, toia to pou kuputuhi ka taka ki roto i te kāwai āpure i te pihanga Whakaaturanga.
- Hanga: Ka tatau aunoa a Power BI te auau o ia kupu ka whakaputa i te kupu kapua. Ka nui ake te auau o te kupu, ka nui ake te puta.
Tips
- Horoia o raraunga i te tuatahi: tangohia nga kupu mutu (penei i te "me", "te", "ko"), tohu tohu, me nga taarua mo nga hua marama ake.
- Mēnā kei roto tō kuputuhi i ngā pūtau maha, whakamahia ngā tātai pēnei
=TEXTJOIN(" ",TRUE,A1:A50)ki te whakakotahi i nga mea katoa ki roto i te pūtau kotahi. - He pai nga kapua kupu mo te whakaata, engari kaua e whakaatu i nga tatau auau tika—whakaarohia ki te hono ki te ripanga kaurori, ki te tūtohi pae mo te tātari hohonu.
