Connect with us

MS Excel

How to make or create a word cloud in Excel with VBA – very easy

Published

on

How to make or create a word cloud in Excel with VBA - very easy

It is possible that we have ever seen a word cloud or tag cloud, they are groups of words. They are of different colors and sizes, with vertical and horizontal letters, which attract attention and we do not know how to do it. I have good news for you, by reading this information you will be able to create your own word cloud.

In a practical and simple way, and from the comfort of your home, without having to install other complicated programs. You just have to have Excel installed on your computer, a tool that we all use regularly since it is well known. The functions of our Excel program installed on our computer may surprise us since it is a necessary tool, it can even become a data search engine.

What is a word cloud? What is your function?

A word cloud is a graphic representation in space in order to see what the words are. The purpose of this graph is to see which words are the most repeated in our cloud. This allows us to determine the density of the words and from that visualization to be able to make the right decision.

How to make or create a word cloud in Excel with VBA - very easy

Cloud function

This tool can be used in many fields, such as education or statistics since it allows the most repeated opinions. It is important to note that one of the fields where word clouds are most used is online marketing.

In them is where people can quickly visualize which are the most repeated concepts on the web. We can also find them in blogs since they are used to make word labels and help the user. The user will be able to visualize the words that interest him the most and will see the most important for the page.

Learn to create word clouds in Excel with VBA

Whenever we talk about VBA, the first thing we must do is order the data to be used in the correct way. Having all this in the correct way we can apply the macros, it is necessary to use at least two columns. In the first column, we must place the words, which we want to highlight, and which appear in the word cloud. In the second we can place the percentage or value that we want Excel to take when creating the cloud.

The result will be the generation of a macro with two lines, one for the first and one for the second. After having made these arrangements it is important to select a number of cells to run the macro on them. If we omit these first steps our operation will be wrong, we must take into account our data table. Since it should not exceed two columns, if we do, we will get an error message.

It highlights line 55, otherwise, the number of rows in the table has no effect at all. The important thing is that you select the number of rows that contain data, that way you will not be missing.

To make the macro, we must take into account the following: First, we must expose all the variables. These must be from line 4, later we go to the Dim instruction, having the variable, it is stored.

What should be stored is the result of dividing between two chosen cells, and with ReDim, we create the elements. Let us consider that the elements that we create must be from the label arrangement and the most important arrangement according to size.

We must assign the value 1 to variables Cells and Index, a sample if we are in the right or left column. The second shows us the Excel row and lets us set the values ​​to the arrangements that are made. If I pay due attention to each of these steps, we will achieve it

And the most important thing that it will be in an easy way and from our home, without the need for the internet. We only need to have the Excel program on our computer, and from there we can make our word cloud. By having Excel installed on our computer, in addition to creating word clouds, we can also make spreadsheets, in turn being able to hide data from cells that we want.

Advertisement

MS Excel

Determining Lowest and Highest Values ​​in Microsoft Excel

Published

on

Determining Lowest and Highest Values ​​in Microsoft Excel

Determining the lowest and highest values ​​requires a special formula or function that you can do with Microsoft Excel.

Determining the highest value can be done easily when there is very little data, but what about when there is a lot of data?

For that you need an Excel formula.

How to? Come on, follow this tutorial in full.

HOW TO DETERMINE THE LOWEST AND HIGHEST VALUE

To do this, the formula you can use is MAX and MIN.

As the name implies, MAX is to find the highest value, while MIN is to find the lowest value.

Meanwhile, for writing the formula, the highest value is MAX(Number1; [Number2]; …)

Number is the range of numbers for which you want to know the highest value.

Finding Lowest Value

Now, to find the lowest value you can use the formula MIN(Number1; [Number2]; …).

As usual number is a range of numbers, or the same when you look for the previous highest value.

How, very easy isn’t it? Although it looks complicated, Excel formulas will really make things easier for you.

That’s all and good luck.

Continue Reading

MS Excel

How to Use Automatic Ranking Formulas in Excel

Published

on

How to Use Automatic Ranking Formulas in Excel

The formula for finding rankings in Excel is also available for those of you who want to rank in a group.

This one formula is a formula that is quite widely used, especially in the field of education.

Well, here’s an Excel formula tutorial to find rankings.

RANKING FORMULAS IN EXCEL

There are several formulas you can use that basically have the same function for finding rankings.

And the first formula you can use is = RANK(Number;Reference;[order]).

The order in the formula is the number 0 or 1 as a ranking reference.

When you want to sort the value in descending or descending order, fill it with 0 or empty, while when you want to give the value ascending then fill it with the number 1.

But you also need to know that the formula will also give the same rank when there are the same values.

To overcome this you can use this one formula.

RANK.AVG Rumus formula

The usage is still the same, only the formula is different which becomes RANK.AVG(Number; Reference; [order])

And when you apply it and there is the same value, it will produce an average ranking of that value.

So, for an assessment, this formula is the most appropriate.

Well, if you look at the example, a value of 70 gets a rating of 7.5 while a value of 75 gets a rating of 5.5.

That’s how the ranking formula in Excel works.

That’s all and good luck.

Continue Reading

MS Excel

How to Calculate Workdays with Excel Formulas

Published

on

How to Calculate Workdays with Excel Formulas

Calculating weekdays will be very effective when you use the easiest formula in Microsoft Excel.

Most people are lazy to use Excel for their daily needs, even though this software is very useful.

Then what about the formula for finding the working day? It’s really easy. Here’s the full tutorial.

HOW TO CALCULATE WORKING DAYS

You can do this with the NETWORKDAYS formula which only counts weekdays, without weekends.

But you also need to know that the weekends here are Saturday and Sunday.

For example, if you want to determine the weekend with another day, then there is a different formula which I will discuss later.

The formula for writing is =NETWORKDAYS(Start_Date; End_Date, [Holiday_Day])

For more details, consider the following image.

How to Calculate Workdays with Excel Formulas

In this example, the number of effective working days is 87 days, where Saturday and Sunday are not included.

NETWORKDAYS.ITL

Well, for this formula you can determine the time off or weekend as needed.

The formula for writing is =NETWORKDAYS.INTL(Start_Date; End_Date; [Weekend_End]; [Holiday_Holiday])

The difference in this formula is that [weekends] are used to exclude and treat as weekdays.

If you do not fill it in, it will be considered as the previous formula.

You can also use a holiday code with a seven-character text string consisting of a combination of the text numbers 1 and 0 to represent Monday-Sunday.

So what happens is the number 1 represents holidays while the number 0 for workdays.

For example, on weekends or holidays Saturday and Sunday, the string code you are using is 0000011.

As for working days only Monday, Tuesday and Thursday or Wednesday, Friday, Saturday and Sunday off, the code used is 0010111.

That’s all and good luck.

Continue Reading
Advertisement

Latest

How to Create GraphsCharts Using Microsoft Word How to Create GraphsCharts Using Microsoft Word
MS Word13 mins ago

How to Create Graphs/Charts Using Microsoft Word

SHARE Often, when working on an assignment for a paper, paper, thesis, thesis, or dissertation, it is necessary to include...

How to delete my information from the Internet How to delete my information from the Internet
Internet1 day ago

How to delete my information from the Internet

SHARE The Internet is one of the best tools of the 21st century. With his arrival, the digital revolution began,...

How to report a fraudulent website How to report a fraudulent website
How-To1 day ago

How to report a fraudulent website

SHARE The Internet has reached such magnitude that for many unscrupulous people it has become a way to amass money...

How to upload YouTube videos to Instagram How to upload YouTube videos to Instagram
Internet1 day ago

How to upload YouTube videos to Instagram

SHARE Social networks have become one of the most important communications and entertainment media today and, of all of them,...

How to be YouTuber and earn money How to be YouTuber and earn money
Internet1 day ago

How to be YouTuber and earn money

SHARE The Internet has become a new source of income for people who know how to take advantage of social...

How to Shop on TikTok Shop Live, Also While Live Streaming How to Shop on TikTok Shop Live, Also While Live Streaming
TikTok1 day ago

How to Shop on TikTok Shop Live, Also While Live Streaming

SHARE Online shopping has now become a lifestyle for people and is available on many social media, including TikTok. The...

How to Check a PC that Supports Windows 11, Use PC Health Check How to Check a PC that Supports Windows 11, Use PC Health Check
Windows 111 day ago

How to Check a PC that Supports Windows 11, Use PC Health Check

SHARE Windows 11 will soon be available for general users. Ahead of its official launch, Microsoft has prepared various related...

How to Backup WhatsApp iPhone to iCloud How to Backup WhatsApp iPhone to iCloud
iPhone1 day ago

iPhone: How to Backup WhatsApp iPhone to iCloud

SHARE Are you a user of the iPhone who is actively wearing WhatsApp? If so, you must be familiar with...

How to Type Documents in Microsoft Word with Voice How to Type Documents in Microsoft Word with Voice
MS Word3 days ago

How to Type Documents in Microsoft Word with Voice

SHARE Have you ever known, if it turns out that you can type documents in Microsoft Word by voice? How...

How to calculate interest for a fixed term How to calculate interest for a fixed term
Business3 days ago

How to calculate interest for a fixed term

SHARE In this article, you will discover the implications that exist within the calculation of the interest rate of a...

Advertisement

Categories

Trending

Copy link
Powered by Social Snap