Yadda ake ƙirƙirar Cloud Word Cloud (Hanyoyin Sauri 3)

Yayin da Excel ba shi da ginanniyar fasalin girgije na kalma, kuna iya ƙirƙira Excel word girgije a sauƙaƙe ta amfani da kowane ɗayan dabaru 3 da ke ƙasa:

Hanyar 1: Yi amfani da ƙari na Excel

Hanyar da ta fi dacewa ita ce yin amfani da add-in, wanda ke ba ka damar ƙirƙirar kalma gajimare kai tsaye a cikin ma'auni na Excel. Shahararren zaɓi kuma kyauta shine Bjorn Word Cloud. Kuna iya nemo wasu kayan aikin girgije na kalma a cikin ɗakin karatu na ƙarawa.

Mataki 1: Shirya bayanan ku

• Sanya duk rubutun da kake son tantancewa zuwa shafi guda. Kowane tantanin halitta na iya ƙunsar kalmomi ɗaya ko ma yawa.

Mataki 2: Shigar da "Bjorn Word Cloud" add-in

1. Je zuwa Saka tab a kan kintinkiri.
2. Click a kan Samu Add-ins.
3. A cikin Store Add-ins Office, bincika "Bjorn Word Cloud".
4. danna Ƙara maɓallin kusa da ƙarawar Pro Word Cloud.

Mataki 3: Ƙirƙirar kalmar girgije

1. Je zuwa Saka tab kuma danna kan Add-ins na.
2. Select Bjorn Word Cloud don buɗe rukunin sa a gefen dama na allo.
3. Ƙarin zai gano kewayon rubutun da kuka zaɓa ta atomatik. Danna Ƙirƙirar girgije kalma button.

Mataki na 4: Keɓance kuma ajiyewa

• Ƙarin yana ba da zaɓuɓɓuka da yawa don tsara font, launuka, shimfidawa (a kwance, tsaye, da sauransu), da yanayin kalmominku.
• Hakanan zaka iya daidaita adadin kalmomin da aka nuna da kuma tace "kalmomin tsaida" gama gari (kamar 'da', 'da', 'a').
• Kalmar girgije za ta bayyana a cikin kwamitin. Kuna iya fitar dashi azaman SVG, GIF, ko shafin yanar gizo.

Hanyar 2: Yi amfani da janareta na kalma na kan layi kyauta

Idan ba kwa son shigar da add-in, zaku iya amfani da kayan aikin kan layi kyauta. Wannan hanyar sau da yawa tana ba da ƙarin zaɓuɓɓukan gyare-gyare na ci gaba.

Mataki 1: Shirya da kwafi bayanan ku a cikin Excel

• Tsara duk rubutunku zuwa shafi guda.
• Hana dukkan ginshiƙi kuma kwafa shi zuwa allon allo (Ctrl+C).

Mataki 2: Yi amfani da kayan aikin kan layi

1. Kewaya zuwa gidan yanar gizon janareta na girgije kyauta, kamar AhaSlides kalmar girgije janareta, ko https://www.google.com/search?q=FreeWordCloud.com.
2. Nemo wani zaɓi na "Shigo da" ko "Manna Rubutun".
3. Manna da kwafin rubutunku daga Excel cikin akwatin rubutu da aka tanadar.

Mataki na 3: Ƙirƙira, tsarawa, da zazzagewa

1. Danna maballin "Ƙirƙira" ko "Visualise" don ƙirƙirar kalmar girgije.
2. Yi amfani da kayan aikin gidan yanar gizon don keɓance fonts, siffofi, launuka, da daidaita kalmomi.
3. Da zarar kun gamsu, zazzage kalmar girgije azaman hoto (yawanci PNG ko JPG).

Hanyar 3: Yi amfani da Power BI

Idan kuna da Power BI a shirye akan tebur ɗinku, wannan na iya zama hanya mai kyau amma mafi ci gaba don samar da gajimare kalmomin Excel lokacin da zaku aiwatar da adadin kalmomi.

Mataki 1: Shirya bayanan ku a cikin Excel

Da farko, kuna buƙatar tsara bayanan rubutunku da kyau a cikin takardar Excel. Tsarin da ya dace shine ginshiƙi guda ɗaya inda kowane tantanin halitta ya ƙunshi kalmomi ko jimlolin da kuke son tantancewa.

1. Ƙirƙiri Shafi: Saka duk rubutunku cikin shafi guda (misali, Rukunin A).
2. Tsara a matsayin Teburi: Zaɓi bayanan ku kuma latsa Ctrl + T. Wannan yana tsara shi azaman Teburin Excel na hukuma, wanda Power BI ke karantawa cikin sauƙi. Ba wa tebur cikakken suna (misali, "WordData").
3. Ajiye your Excel fayil.

Mataki 2: Shigo da fayil ɗin Excel ɗin ku zuwa Power BI

Na gaba, bude Power BI Desktop (wanda shine saukewa kyauta daga Microsoft) don haɗawa da fayil ɗin Excel.

1. Bude Power BI.
2. a Gida tab, danna Nemi Bayanai kuma zaži Littafin Aiki na Excel.
3. Nemo kuma buɗe fayil ɗin Excel da kuka adana yanzu.
4. a cikin Navigator taga wanda ya bayyana, duba akwatin kusa da sunan tebur ɗin ku ("WordData").
5. Click load. Bayanan ku yanzu zai bayyana a cikin data aiki a gefen dama na taga Power BI.

Mataki 3: Ƙirƙiri kuma saita kalmar girgije

Yanzu zaku iya gina ainihin gani.

1. Ƙara abin gani: a cikin Ziyara babban aiki, nemo kuma danna kan Maganar girgije ikon. Samfurin da ba komai zai bayyana akan zanen rahoton ku.
2. Ƙara bayanan ku: daga data babban aiki, ja ginshiƙin rubutun ku kuma jefa shi cikin category filin a cikin Kunshin gani.
3. Haɗa: Power BI zai ƙidaya mitar kowace kalma ta atomatik kuma ya haifar da kalmar girgije. Yawan yawaitar kalma, mafi girman ta zai bayyana.

tips

• Tsabtace bayananku da farko: cire kalmomin tsayawa (kamar "da", "da", "shine"), alamar rubutu, da kwafi don ƙarin sakamako mai haske.
• Idan rubutunku yana cikin sel da yawa, yi amfani da dabaru kamar =TEXTJOIN(" ",TRUE,A1:A50) don hada komai zuwa tantanin halitta daya.
• Gizagizai na kalmomi suna da kyau don gani, amma kar a nuna ainihin ƙididdiga na mita - yi la'akari da haɗa su tare da tebur pivot ko ginshiƙi don bincike mai zurfi.