Ulenza njani iLifu leLizwi le-Excel (Iindlela ezi-3 ezikhawulezayo)

Ngelixa i-Excel ingenalo uphawu lwelifu olwakhelwe ngaphakathi, unokwenza Excel igama amafu ngokulula usebenzisa naziphi na iindlela ezi-3 ezingezantsi:

Indlela yoku-1: Sebenzisa i-Excel add-in

Eyona ndlela idibeneyo kukusebenzisa i-add-in, ekuvumela ukuba wenze ifu lamagama ngokuthe ngqo kwi-spreadsheet yakho ye-Excel. Inketho edumileyo kunye nesimahla yiBjorn Word Cloud. Unokukhangela ezinye izixhobo zefu zamagama kwilayibrari eyongezelelweyo.

Inyathelo 1: Lungisa idatha yakho

• Beka wonke umbhalo ofuna ukuwuhlalutya kumhlathi omnye. Iseli nganye inokuqulatha igama elinye okanye amaninzi.

Inyathelo lesi-2: Faka i-"Bjorn Word Cloud" yokongeza

1. Yiya kwi Faka tab kwiribhoni.
2. Cofa kwi Fumana ezongezo.
3. Kwivenkile yokongeza kwiOfisi, khangela i-"Bjorn Word Cloud".
4. nqakraza i Yongeza iqhosha ecaleni kwe-Pro Word Cloud add-in.

Inyathelo lesi-3: Veza igama elithi ilifu

1. Yiya kwi Faka ithebhu kwaye nqakraza Izongezo zam.
2. khetha Bjorn iLizwi Cloud ukuvula iphaneli yayo kwicala lasekunene lesikrini sakho.
3. I-add-in iya kubona ngokuzenzekelayo uluhlu lwakho lokubhaliweyo olukhethiweyo. Cofa i Yenza ilifu lamagama iqhosha.

Inyathelo 4: Lungiselela kwaye ugcine

• I-add-in inika iinketho ezininzi ukwenza ifonti, imibala, ubeko (othe tye, ngokuthe nkqo, njl.njl.), kunye nemeko yamagama akho.
• Unako kwakhona ukunyenyisa inani lamagama abonisiweyo kwaye uhluze ngaphandle "amagama okuphelisa" aqhelekileyo (njenge 'the', 'kunye', 'a').
• Igama elithi cloud liya kuvela kwiqela lenjongo. Ungayithumela ngaphandle njenge-SVG, i-GIF, okanye iphepha lewebhu.

Indlela yesi-2: Sebenzisa ijenereyitha yelifu ye-intanethi yasimahla

Ukuba awufuni ukufaka isongezo, ungasebenzisa isixhobo sasimahla se-intanethi. Le ndlela ihlala ibonelela ngeendlela eziphucukileyo zokuzenzela.

Inyathelo 1: Lungisa kwaye ukope idatha yakho kwi-Excel

• Lungiselela yonke isicatshulwa sakho kwikholamu enye.
• Gqamisa yonke ikholamu kwaye uyikopishe kwibhodi eqhotyoshwayo (Ctrl+C).

Inyathelo 2: Sebenzisa isixhobo se-intanethi

1. Yiya kwiwebhusayithi ye-free cloud generator, njenge AhaSlides igama generator ilifu, okanye https://www.google.com/search?q=FreeWordCloud.com.
2. Khangela "Ngenisa" okanye "Coca isiqendu".
3. Ncamathelisa umbhalo wakho okhutshelweyo kwi-Excel kwibhokisi yokubhaliweyo enikiweyo.

Inyathelo 3: Yenza, yenza ngokwezifiso, kwaye ukhuphele

1. Cofa iqhosha elithi "Yenza" okanye "Jonga" ukwenza igama elithi cloud.
2. Sebenzisa izixhobo zewebhusayithi ukwenza iifonti, iimilo, imibala, kunye nokuqhelaniswa namagama.
3. Wakuba wanelisekile, khuphela igama elithi cloud njengomfanekiso (udla ngokuba yiPNG okanye iJPG).

Indlela yesi-3: Sebenzisa i-Power BI

Ukuba unePower BI elungile kwi-desktop yakho, le inokuba yindlela elungileyo kodwa ehambele phambili yokuvelisa amafu egama le-Excel xa kufuneka usebenze isixa esikhulu samagama.

Inyathelo 1: Lungisa idatha yakho kwi-Excel

Okokuqala, kufuneka ulungelelanise idatha yakho yokubhaliweyo ngokufanelekileyo kwiphepha le-Excel. Ifomathi eyiyo yintsika enye apho iseli nganye iqulathe amagama okanye amabinzana ofuna ukuwahlalutya.

1. Yenza uKholamu: Beka konke okubhaliweyo kwakho kuluhlu olunye (umzekelo, uKholam A).
2. Ifomathi njengeTheyibhile: Khetha idatha yakho kwaye ucinezele Ctrl + T. Oku kuyifomatha njengeTheyibhile ye-Excel esemthethweni, apho i-Power BI ifundeka ngokulula ngakumbi. Nika itheyibhile igama elicacileyo (umz., "WordData").
3. Gcina ifayile yakho ye-Excel.

Inyathelo 2: Ngenisa ifayile yakho ye-Excel kwi-Power BI

Okulandelayo, vula i-Power BI Desktop (ekukukhuphela simahla kuyo Microsoft) ukuqhagamshela kwifayile yakho ye-Excel.

1. Vula Amandla BI.
2. Kwi Ikhaya ithebhu, nqakraza Fumana idatha kwaye ukhethe Incwadi Yokusebenzela ye-Excel.
3. Fumana kwaye uvule ifayile ye-Excel osanda kuyigcina.
4. Kwi Navigator window evelayo, khangela ibhokisi ecaleni kwegama letafile yakho ("WordData").
5. nqakraza umthwalo. Idatha yakho ngoku iya kuvela kwi Iinkcukacha ipayini kwicala lasekunene lefestile ye-BI yePower.

Inyathelo 3: Yenza kwaye uqwalasele igama elithi ilifu

Ngoku unokwakha eyona ibonwayo.

1. Yongeza okubonakalayo: Kwi Ukubonakala kwi pane, fumana kwaye nqakraza kwi Ilifu lelizwi i icon. Ithempleyithi engenanto iya kuvela kwi-canvas yengxelo yakho.
2. Yongeza idatha yakho: Isuka e Iinkcukacha kwi pane, tsala ikholamu yakho yokubhaliweyo kwaye uyilahle kwi udidi isithuba kwindawo yoMboniso.
3. Yenza: I-Power BI iya kubala ngokuzenzekelayo ukuphindaphinda kwegama ngalinye kwaye ivelise ilifu legama. Okukhona igama liqhelekile, kokukhona liya kuvela.

Tips

• Coca idatha yakho kuqala: susa amagama amisayo (afana "kunye", "i", "yi"), iziphumlisi, kunye nempinda ukuze ufumane iziphumo ezicacileyo.
• Ukuba umbhalo wakho ukwiiseli ezininzi, sebenzisa iifomula ezifana =TEXTJOIN(" ",TRUE,A1:A50) ukudibanisa yonke into kwiseli enye.
• I-Word clouds ilungile ekuboniseni, kodwa ayibonisi ukubala okuphindaphindiweyo-cinga ngokudibanisa netafile yepivot okanye itshathi yebha ukuze uhlalutye nzulu.