Ungawakha kanjani ifu le-Excel Word (Izindlela ezi-3 ezisheshayo)

Nakuba i-Excel ingenaso isici sefu esakhelwe ngaphakathi, ungakha Excel izwi amafu usebenzisa kalula noma yiziphi izindlela ezi-3 ezingezansi:

Indlela 1: Sebenzisa isengezo se-Excel

Indlela edidiyelwe kakhulu ukusebenzisa isengezo, esikuvumela ukuthi udale ifu lamagama ngqo ngaphakathi kwespredishithi sakho se-Excel. Inketho edumile nemahhala yi-Bjorn Word Cloud. Ungasesha amanye amathuluzi efu lamagama kulabhulali yokwengeza.

Isinyathelo sesi-1: Lungiselela idatha yakho

• Beka wonke umbhalo ofuna ukuwuhlaziya ube yikholomu eyodwa. Iseli ngalinye lingaqukatha igama elilodwa noma amaningi.

Isinyathelo sesi-2: Faka isengezo se-"Bjorn Word Cloud".

1. Yiya ku Faka ithebhu kubambo.
2. Chofoza Thola Izengezo.
3. Esitolo Sezengezo ze-Office, sesha i-"Bjorn Word Cloud".
4. Chofoza Engeza inkinobho eduze kwesengezo se-Pro Word Cloud.

Isinyathelo sesi-3: Khiqiza igama elithi ifu

1. Yiya ku Faka ithebhu bese uchofoza Izengezo zami.
2. Khetha Bjorn Word Cloud ukuze uvule iphaneli yayo ngakwesokudla kwesikrini sakho.
3. Isengezo sizothola ngokuzenzakalela ububanzi bombhalo obukhethiwe. Chofoza u- Dala ifu lamagama inkinobho.

Isinyathelo sesi-4: Enza ngendlela oyifisayo futhi ulondoloze

• Isengezo sinikeza izinketho ezimbalwa zokwenza ifonti ngokwezifiso, imibala, isakhiwo (evundlile, iqonde, njll.), kanye necala lamagama akho.
• Ungaphinda ulungise inani lamagama abonisiwe futhi uhlunge "amagama okumisa" ajwayelekile (njengokuthi 'the', 'kanye', 'a').
• Igama elithi ifu lizovela kuphaneli. Ungayithekelisa njenge-SVG, i-GIF, noma ikhasi lewebhu.

Indlela yesi-2: Sebenzisa ijeneretha yamafu yamagama aku-inthanethi yamahhala

Uma ungafuni ukufaka isengezo, ungasebenzisa ithuluzi lamahhala le-inthanethi. Le ndlela ngokuvamile inikeza izinketho ezithuthuke kakhulu zokwenza ngokwezifiso.

Isinyathelo 1: Lungiselela futhi ukopishe idatha yakho ku-Excel

• Hlela wonke umbhalo wakho ube ikholomu eyodwa.
• Gqamisa yonke ikholomu bese uyikopishela ebhodini lakho lokunamathisela (Ctrl+C).

Isinyathelo sesi-2: Sebenzisa ithuluzi eliku-inthanethi

1. Zulazulela kuwebhusayithi yamahhala ye-cloud generator, njenge Ijeneretha yamafu yegama ye-AhaSlides, noma https://www.google.com/search?q=FreeWordCloud.com.
2. Bheka inketho ethi "Ngenisa" noma "Namathisela Umbhalo".
3. Namathisela umbhalo wakho okopishiwe osuka ku-Excel ebhokisini lombhalo elinikeziwe.

Isinyathelo sesi-3: Khiqiza, yenza ngendlela oyifisayo, bese ulanda

1. Chofoza inkinobho ethi "Khiqiza" noma "Bona ngeso lengqondo" ukuze udale igama elithi ifu.
2. Sebenzisa amathuluzi ewebhusayithi ukwenza amafonti ngendlela oyifisayo, umumo, imibala, nomumo wamagama.
3. Uma usunelisekile, landa igama elithi ifu njengesithombe (ngokuvamile i-PNG noma i-JPG).

Indlela yesi-3: Sebenzisa i-Power BI

Uma une-Power BI elungile kudeskithophu yakho, lokhu kungaba indlela enhle kodwa ethuthuke kakhulu yokwenza amafu egama le-Excel uma kufanele ucubungule inani elikhulu lamagama.

Isinyathelo 1: Lungiselela idatha yakho ku-Excel

Okokuqala, udinga ukuhlela idatha yakho yombhalo kahle eshidini le-Excel. Ifomethi ekahle yikholomu eyodwa lapho iseli ngalinye liqukethe amagama noma imishwana ofuna ukuyihlaziya.

1. Dala Ikholomu: Faka wonke umbhalo wakho kukholomu eyodwa (isb, Ikholomu A).
2. Fometha Njengethebula: Khetha idatha yakho bese ucindezela Ctrl + T. Lokhu kulifometha njengeThebula le-Excel elisemthethweni, i-Power BI elifundeka kalula. Nikeza ithebula igama elicacile (isb, "WordData").
3. Londoloza ifayela lakho le-Excel.

Isinyathelo sesi-2: Ngenisa ifayela lakho le-Excel ku-Power BI

Okulandelayo, vula i-Power BI Desktop (okuwukulanda mahhala kusuka Microsoft) ukuze uxhume kufayela lakho le-Excel.

1. Vula i-Power BI.
2. Use Ikhaya ithebhu, chofoza Thola Idatha Bese ukhetha Incwadi Yokusebenzela ye-Excel.
3. Thola futhi uvule ifayela le-Excel osanda kuligcina.
4. In the Navigator ifasitela elivelayo, khetha ibhokisi eduze kwegama letafula lakho ("WordData").
5. Chofoza Layisha. Idatha yakho manje izovela ku- Idatha ifasitelana ngakwesokudla kwewindi le-Power BI.

Isinyathelo sesi-3: Dala futhi ulungiselele igama elithi ifu

Manje ungakha okubonakalayo kwangempela.

1. Engeza okubonakalayo: In the Ukubukwa pane, thola bese uchofoza ku- ILifu Lamafu isithonjana. Isifanekiso esingenalutho sizovela kukhanvasi yombiko wakho.
2. Engeza idatha yakho: Ukusuka Idatha pane, hudula ikholomu yakho yombhalo bese uyiphonsa ku Isigaba inkambu kufasitelana le-Visualizations.
3. Khiqiza: I-Power BI izobala ngokuzenzakalelayo imvamisa yegama ngalinye futhi ikhiqize igama elithi ifu. Uma igama livame kakhulu, lizovela likhulu.

Amathiphu

• Hlanza idatha yakho kuqala: susa amagama amisayo (njengokuthi “kanye”, “the”, “is”), izimpawu zokubhala, nezimpinda ukuze uthole imiphumela ecacile.
• Uma umbhalo wakho ukumaseli amaningi, sebenzisa amafomula afana nala =TEXTJOIN(" ",TRUE,A1:A50) ukuhlanganisa yonke into ibe yingqamuzana eyodwa.
• Amafu e-Word mahle kakhulu ekuboniseni ngeso lengqondo, kodwa awabonisi ukubala okuyimvamisa okuqondile—cabanga ngokumatanisa nethebula le-pivot noma ishadi lebha ukuze uthole ukuhlaziya okujulile.