Momwe Mungapangire Mtambo wa Mawu a Excel (Njira 3 Zofulumira)

Ngakhale Excel ilibe mawonekedwe amtambo omangika, mutha kupanga Excel mawu mitambo mosavuta kugwiritsa ntchito njira iliyonse ya 3 ili pansipa:

Njira 1: Gwiritsani ntchito chowonjezera cha Excel

Njira yophatikizika kwambiri ndiyo kugwiritsa ntchito chowonjezera, chomwe chimakulolani kuti mupange mtambo wa mawu mwachindunji mkati mwa Excel spreadsheet. Njira yotchuka komanso yaulere ndi Bjorn Word Cloud. Mutha kusaka zida zina zamtambo mulaibulale yowonjezera.

Gawo 1: Konzani deta yanu

• Ikani zolemba zonse zomwe mukufuna kusanthula mugawo limodzi. Selo lililonse limatha kukhala ndi mawu amodzi kapena angapo.

Khwerero 2: Ikani "Bjorn Word Cloud" yowonjezera

1. Pitani ku Ikani tabu pa nthiti.
2. Dinani Pezani Zowonjezera.
3. Mu sitolo ya Office Add-ins, fufuzani "Bjorn Word Cloud".
4. Dinani kuwonjezera batani pafupi ndi chowonjezera cha Pro Word Cloud.

Gawo 3: Pangani mawu oti mtambo

1. Pitani ku Ikani tabu ndipo dinani Zowonjezera Zanga.
2. Sankhani Bjorn Mawu Cloud kuti mutsegule gulu lake kumanja kwa skrini yanu.
3. Zowonjezera zidzazindikira zokha zomwe mwasankha. Dinani pa Pangani mawu mtambo batani.

Khwerero 4: Sinthani Mwamakonda Anu ndikusunga

• Chowonjezeracho chimapereka zosankha zingapo kuti musinthe mafonti, mitundu, masanjidwe (opingasa, ofukula, ndi zina), ndi mawu anu.
• Mutha kusinthanso kuchuluka kwa mawu omwe akuwonetsedwa ndikusefa "mawu oyimitsa" wamba (monga 'the', 'ndi', 'a').
• Mawu mtambo adzaoneka pa gulu. Mutha kutumiza ngati SVG, GIF, kapena tsamba lawebusayiti.

Njira 2: Gwiritsani ntchito jenereta yamtambo yaulere pa intaneti

Ngati simukufuna kukhazikitsa chowonjezera, mutha kugwiritsa ntchito chida chaulere pa intaneti. Njirayi nthawi zambiri imapereka zosankha zapamwamba kwambiri.

Khwerero 1: Konzani ndi kukopera deta yanu mu Excel

• Konzani zolemba zanu zonse kukhala gawo limodzi.
• Onetsani gawo lonse ndikulikopera ku bolodi lanu (Ctrl + C).

Khwerero 2: Gwiritsani ntchito chida cha intaneti

1. Yendetsani ku tsamba laulere la cloud generator, monga AhaSlides mawu jenereta wamtambo, kapena https://www.google.com/search?q=FreeWordCloud.com.
2. Yang'anani njira ya "Import" kapena "Paste Text".
3. Matani zolemba zanu zomwe mwakopera kuchokera ku Excel mubokosi loperekedwa.

Gawo 3: Pangani, sinthani mwamakonda, ndikutsitsa

1. Dinani batani la "Pangani" kapena "Onani" kuti mupange mawu amtambo.
2. Gwiritsani ntchito zida za tsambalo kuti musinthe mafonti, mawonekedwe, mitundu, ndi kalembedwe ka mawu.
3. Mukakhutitsidwa, tsitsani mawu akuti mtambo ngati chithunzi (nthawi zambiri PNG kapena JPG).

Njira 3: Gwiritsani Ntchito Mphamvu BI

Ngati muli ndi Power BI yokonzeka pa kompyuta yanu, iyi ikhoza kukhala njira yabwino koma yapamwamba kwambiri yopangira mitambo ya mawu a Excel mukayenera kukonza mawu ambiri.

Khwerero 1: Konzani deta yanu mu Excel

Choyamba, muyenera kukonza zolemba zanu bwino papepala la Excel. Mtundu wabwino ndi gawo limodzi pomwe selo lililonse limakhala ndi mawu kapena ziganizo zomwe mukufuna kusanthula.

1. Pangani Mzere: Ikani zolemba zanu zonse mugawo limodzi (monga, Mzere A).
2. Maonekedwe a Table: Sankhani deta yanu ndikusindikiza Ctrl + T. Izi zimapanga ngati Table Excel yovomerezeka, yomwe Power BI imawerenga mosavuta. Perekani tebulo dzina lomveka bwino (mwachitsanzo, "WordData").
3. Save fayilo yanu ya Excel.

Khwerero 2: Lowetsani fayilo yanu ya Excel mu Power BI

Kenako, tsegulani Power BI Desktop (yomwe ndi kutsitsa kwaulere kuchokera Microsoft) kuti mulumikizane ndi fayilo yanu ya Excel.

1. Open Power BI.
2. pa Kunyumba tabu, dinani Pezani Zambiri ndi kusankha Buku la Ntchito la Excel.
3. Pezani ndi kutsegula fayilo ya Excel yomwe mwasunga kumene.
4. Mu Navigator zenera lomwe likuwoneka, chongani bokosi pafupi ndi dzina la tebulo lanu ("WordData").
5. Dinani katundu. Deta yanu tsopano idzawonekera mu fayilo ya Deta pane kumanja kwa zenera la Power BI.

Khwerero 3: Pangani ndikusintha mawu amtambo

Tsopano mutha kupanga mawonekedwe enieni.

1. Onjezani zowonera: Mu Zowonera pane, pezani ndikudina pa Mtambo wa Mawu chizindikiro. Tsamba lopanda kanthu liwoneka pansalu ya lipoti lanu.
2. Onjezani deta yanu: Kuchokera ku Deta pane, kokerani zolemba zanu ndikuziponya mu Category m'munda wa Visualisations pane.
3. Pangani: Power BI imangowerengera pafupipafupi liwu lililonse ndikupanga mtambo wa mawu. Liwu likamachulukirachulukira, limawonekeranso lalikulu.

Nsonga

• Chotsani deta yanu kaye: chotsani mawu oyimitsa (monga "ndi", "the", "ndi"), zizindikiro zopumira, ndi zobwereza kuti mupeze zotsatira zomveka.
• Ngati mawu anu ali m'maselo angapo, gwiritsani ntchito njira ngati =TEXTJOIN(" ",TRUE,A1:A50) kuphatikiza zonse kukhala selo limodzi.
• Mitambo ya mawu ndi yabwino kuti muwonetsere, koma samawonetsa mawerengedwe enieni - ganizirani kuwagwirizanitsa ndi pivot table kapena bar chart kuti muwunike mozama.