Create a Simple Word Cloud in Excel

Word clouds are a simple visual that gives some text more emphasis than others based on color, style and size. There's many tools on how to create words clouds and here's another one. The tool of choice will be Excel and how to create a simple word cloud in it. This trick uses a few functions and special paste feature.

📝 This description may contain affiliate links and we'll receive a small commission if a purchased is made using the links (but at no additional cost to you). It'll support the channel and so more videos like this can be made. Thanks for your support!

#excel
#msexcel
#doughexcel

-~-~~-~~~-~~-~-
Please watch: "Convert Table in a PDF File to Excel"
-~-~~-~~~-~~-~-

[richardwalton]

This is word cloud as an artistic exercise - meaning you have the time to do the artwork. I was hoping for something more functional, like for a business setting (i.e. survey responses) where we do not have the time to position and resize every single word. Thank you for the tutorial, but it's not quite what I was hoping for.

[Sammyarshad]

Can the words be generated with respect to its frequency?

[Alloyka]

sorry, I did not undersatnd, does this cloud adjust the size of the words according to their ranks? thanks in advance!

[stevegrey]

When you created your Rank formula you forgot to press F4 for an absolute reference, so your rankings are incorrect. However, this was still an interesting tutorial which I might try to find a use for. Thanks.

[sambitdash]

sorry to say but word clouds should adjust the size automatically otherwise no point in having this and resizing this manually..

[crazcomchronicles]

OMG. You explain this so well. I love the shortcuts that you have shown me as well.  Thank you very much....

[jenkinsmacedo]

The only problem is that there is no association between the randomized number, the rank and the words. The size of the word in the cloud should reflect the frequency (that is how many times that word appeared in the words listed).

[fishdevelopmnt]

The formula was good, but I was looking for excel to generate a word cloud (infogram) and this is copying and pasting!

[chd]

no...isnt there a simple way? like excel doing all the stuff ..and return the word cloud?

[sheilamolombemawi]

Great tricks but you don't want to this for 900 rows or do you?

[Abhishek]

You spent more time explaining how to generate random numbers and ranks than the technique you promised in the title, if we take out all the basic stuff out of your video it will not be more than 3-5 minutes. Please mention in title/description if the video is for beginners or experts.

[kalena]

nothing like a teacher talking for his own sake

[asu]

Spent 8 minutes creating a fake list...then you created a box with manually resized words.

[andyh]

Simple and 13 minutes of talking do not jive. TLDW