Maitiro ekugadzira iyo Excel Shoko Cloud (3 Fast Nzira)

Nepo Excel isina yakavakirwa-mukati mezwi gore, iwe unogona kugadzira Excel izwi makore nyore kushandisa chero yeatatu maitiro ari pazasi:

Method 1: Shandisa Excel yekuwedzera-mukati

Iyo yakanyanya kubatanidzwa nzira ndeye kushandisa yekuwedzera-mukati, iyo inobvumidza iwe kugadzira izwi gore rakananga mukati meExcel spreadsheet yako. Yakakurumbira uye yemahara sarudzo ndeye Bjorn Shoko Cloud. Iwe unogona kutsvaga mamwe mazwi maturusi egore mune yekuwedzera-muraibhurari.

Danho 1: Gadzirira data rako

• Isa zvinyorwa zvese zvaunoda kuongorora muchikamu chimwe chete. Sero rega rega rinogona kuve nezwi rimwechete kana akawanda.

Nhanho yechipiri: Isa iyo "Bjorn Shoko Cloud" yekuwedzera-mukati

1. Enda kune Insert tab paribhoni.
2. Click on Tora maAdd-ins.
3. MuHofisi Yekuwedzera-ins chitoro, tsvaga "Bjorn Shoko Cloud".
4. Baya wedzera bhatani padivi pePro Word Cloud yekuwedzera-mukati.

Danho rechitatu: Gadzira izwi rekuti gore

1. Enda kune Insert tab uye chengeta My Add-ins.
2. sarudza Bjorn Shoko Cloud kuti uvhure pani yayo kurudyi rwechidzitiro chako.
3. Iyo yekuwedzera inozoona otomatiki mavara ako akasarudzwa. Dzvanya iyo Gadzira izwi gore bhatani.

Danho 4: Gadzirisa uye chengetedza

• Iyo yekuwedzera-mukati inopa akati wandei sarudzo kugadzirisa iyo font, mavara, marongerwo (yakatwasuka, yakatwasuka, nezvimwewo), uye nyaya yemashoko ako.
• Iwe unogona zvakare kugadzirisa huwandu hwemazwi anoratidzwa uye kusefa akajairika "kumisa mazwi" (senge 'the', 'uye', 'a').
• Izwi rekuti gore richaonekwa mupanera. Unogona kuitumira kunze seSVG, GIF, kana peji rewebhu.

Method 2: Shandisa emahara online izwi gore jenareta

Kana iwe usingade kuisa yekuwedzera-mukati, unogona kushandisa yemahara online chishandiso. Iyi nzira inowanzopa mamwe epamusoro ekugadzirisa sarudzo.

Danho 1: Gadzirira uye ukope data rako muExcel

• Ronga zvinyorwa zvako zvese muchikamu chimwe chete.
• Simbisa iyo koramu yese uye ikope kune yako clipboard (Ctrl + C).

Danho 2: Shandisa online turusi

1. Enda kune yemahara izwi gore jenareta webhusaiti, senge AhaSlides izwi gore jenareta, kana https://www.google.com/search?q=FreeWordCloud.com.
2. Tsvaga "Import" kana "Namira Runyoro" sarudzo.
3. Namira zvinyorwa zvako zvakakopwa kubva kuExcel mubhokisi remavara rakapihwa.

Danho 3: Gadzira, gadzirisa, uye dhawunirodha

1. Dzvanya bhatani rekuti "Gadzira" kana "Visualise" kugadzira izwi rekuti gore.
2. Shandisa maturusi ewebhusaiti kugadzirisa mafonti, maumbirwo, mavara, uye kutaridzika kwemazwi.
3. Kana wangogutsikana, dhawunirodha izwi rekuti gore semufananidzo (kazhinji PNG kana JPG).

Nzira 3: Shandisa Simba BI

Kana iwe uine Power BI yakagadzirira padesktop yako, iyi inogona kunge iri yakanaka asi yakanyanyisa nzira yekugadzira Excel izwi makore kana uchinge wagadzirisa huwandu hukuru hwemashoko.

Danho 1: Gadzirira data rako muExcel

Kutanga, iwe unofanirwa kurongedza data rako remavara nemazvo muExcel sheet. Mafomati akakodzera ikoramu imwe chete apo sero rega rega rine mazwi kana mitsara yaunoda kuongorora.

1. Gadzira Column: Isa zvinyorwa zvako zvese muchikamu chimwe chete (semuenzaniso, Column A).
2. Fomati seTafura: Sarudza data rako uye tinya Ctrl + T. Izvi zvinoigadzira seyepamutemo Excel Tafura, iyo Power BI inoverenga zviri nyore. Ipa tafura zita rakajeka (semuenzaniso, "WordData").
3. Save yako Excel faira.

Step 2: Ngenisa yako Excel faira muPower BI

Tevere, vhura Power BI Desktop (inova yemahara kurodha kubva Microsoft) kuti ubatanidze kune yako Excel faira.

1. Vhura Power BI.
2. Pa Home tab, kanda Tora Dhata uye sarudza Excel Bhuku rebasa.
3. Tsvaga uye vhura iyo Excel faira iwe uchangochengeta.
4. Mu Navigator hwindo rinoonekwa, tarisa bhokisi riri padivi pezita retafura yako ("WordData").
5. Click mutoro. Yako data zvino ichaonekwa mune Data pane padivi rekurudyi rePower BI hwindo.

Nhanho 3: Gadzira uye gadzirisa izwi gore

Iye zvino unogona kugadzira iyo chaiyo yekuona.

1. Wedzera zvinoonekwa: Mu Visualizations pane, tsvaga uye tinya pane Cloud Cloud icon. A blank template ichaonekwa pane yako report canvas.
2. Wedzera data rako: Kubva ku Data pane, dhonza chinyorwa chako uye uidonhedze mu chikamu munda mune Visualisations pane.
3. Gadzira: Power BI ichaverenga otomatiki kuwanda kweshoko rega rega uye kugadzira iro izwi gore. Iro izwi rinowanzoita, rinobva rakura.

Tips

• Chenesa data rako kutanga: bvisa mazwi ekumisa (senge "uye", "the", "is"), zviratidzo zvepumikira, uye zvakapetwa kuti uwane mhedzisiro yakajeka.
• Kana mavara ako ari mumaseru akawanda, shandisa mafomula se =TEXTJOIN(" ",TRUE,A1:A50) kubatanidza zvinhu zvose musero rimwe.
• Makore emazwi akanaka pakuona, asi haaratidze maverengero chaiwo — funga kuabatanidza netafura yepivot kana bhachati yekuongorora zvakadzama.