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.

MS Excel

How To Use Rank Function in Microsoft Excel for Beginners

Published

on

How To Use Rank Function in Microsoft Excel for Beginners

Surely you all know the Microsoft Excel application. Microsoft Excel is an application or software that is useful for processing numbers. As you already know, this application has a lot of uses and benefits.

The usefulness of this application is that it can create, analyze, edit, Rank, and sort several data because this application can calculate with arithmetic and statistics.

This tutorial will explain how to sort or rank data using Microsoft Excel.

How to Rank in Microsoft Excel

You can rank data in Microsoft Excel. By using the application, you can easily do work in processing data. Ranking data is also very useful for those who work as teachers.

Because this application can rank data in a very easy way and can be done by everyone. Here are ways to rank data in Microsoft Excel:

1. The first step you can take is to open a Microsoft Excel worksheet that already has the data you want to rank. In the example below, I want to rank students in a class by sorting them from rank 1 to 7 You can also rank according to the data you have.

How-to-use-Rank-function-in-Microsoft-Excel

2. After that, you can place your cursor in the cell, where you will rank the cells in the first order. You can see an example in the image below.

How to Rank in Excel

After that, you can write a formula to rank in Microsoft Excel in the fx column. And here’s the formula, =rank(number;ref;order) .

The meaning of the formula is = Rank Rank, which means it is a rank function. And (number; ref; order) means the initial cell number that has a value to be ranked, its reference, and the final cell number that has a value to be ranked, the reference.

The formula is =Rank(D3;$D$3:$D$9;0) in the example below. After entering the function, you can press the Enter key on your keyboard. And here are the results, namely the ranking on data number 1, which has a ranking of 1.

How to Rank in MS Excel

3. If you want to do the same thing to all data as in data number 1, you have to copy the previous column, and then you can block the column below it and click Paste. Then you can see the results. All the columns in the Rank entity have been ranked in such away.

Rank function in MS Excel

4. The results above are not satisfactory because the data is still not sorted, so it looks messy. We must make it sequentially according to the ranking from the smallest to the largest, and this example must be sorted from rank 1 to rank 9.

The way to sort it is to block the contents of all tables, but not with the column names and the contents of the column number.

Rank in Excel

5. After that, you can do the sorting by going to the Editing tool, clicking Sort & Filter, and then clicking the Custom Sort option…

How to Rank in MS Excel for Beginners

6. Then the Sort box will appear, where you have to choose sort by with the Rank option, some kind on with the Values ​​option, and order with the Smallest to Largest option. After that, you can click OK.

Rank in MS Excel for Beginners

7. Below is the result of the sorting we have done above. In this way, the data that has been ranked will be sorted according to its ranking.

Rank in MS Excel

That’s the tutorial on how to rank using Microsoft Excel. Hopefully, this article can be useful for you.

Continue Reading

MS Excel

How to Move Tables from Excel to Word Easily

Published

on

How to Move Tables from Excel to Word Easily

Microsoft Office Excel is useful as a spreadsheet worksheet document famous for microcomputer activities on Windows platforms and other platforms such as Mac OS. With this excel, the data can be more structured and have handy capabilities.

As for the other product, Word is better known as a word processing application. Where has a WYSIWYG concept, namely ” What You See is What You Get.” This application program is also one of the best made by Microsoft that people on various user platforms widely use.

With the presence of these two application programs, it is expected to make work easier and make your work more optimally as desired.

Like wanting to move an Excel table to Word, how do you get the table you’re moving to match its source. This article will discuss how to transfer tables from Excel to Word quickly and how you want.

How to Move a Table from Excel to Word

One of the features provided to solve this problem is the copy-paste feature, which you must be familiar with. This copy function is to copy something and paste it by pasting it according to what has been copied. Paste also has several more functions, including the following:

Keep Source Formatting: Paste function in this option to maintain the appearance of the original Text according to the source that has been copied.

Use Destination Styles: This option is to format the text to match the style applied to the Text.

Link & Keep Source Formatting: In this option to maintain the link to the source file and display the original text according to the source that has been copied

Link & Use Destination Style: This function maintains a link to the source file and uses a text format that matches the style applied to the Text.

Keep Text Only: This option is only for pasting Text only. So all the formatting of the original text will be lost.

It’s a good idea to determine if you want to move the Excel table to Word with which function you need more. Let’s go straight to the steps to move an Excel table to Word.

1. Open your Excel file that contains the document you want to move to Word.

2. Before copying the table, make sure you give the table a border so that when it is transferred to Word, the results are neat. Block the table, then click Borders as indicated by the arrow.

How to transfer Tables from Excel to Word Easily

3. Then select All Borders.

Transfer Tables from Excel to Word

4. The table has been given a border for a neater result. Next, block the table, then right-click> Copy. Or you can use the Ctrl + C keys.

Move Tables from Excel to Word

5. In the Word document, just right-click> Paste. Or you can press Ctrl + V.

How to shift Tables from Excel to Word

6. The result will be like this, exactly like the one in Excel.

How to switch Tables from Excel to Word

This is a tutorial on how to move tables from Excel to Word. Many features have never been used at all. So it’s a shame if we don’t try the features provided, moreover these features are handy for us. So many tutorials this time, hopefully, are useful for you.

Continue Reading

MS Excel

How to Create a Table in Microsoft Excel

Published

on

How to Create a Table in Microsoft Excel

How to create a table in Microsoft Excel is very easy, you know, because basically, Excel consists of tables and a number processor.

The use of internal tables in this number processing software has become one of the things that are definitely needed, guys. Especially if you play with a lot of data in it.

However, until now there may still be many who do not know how to make it. Therefore, we will provide a complete tutorial for you.

But before going into the steps, you need to know a few things about the following table.


Table of Contents :


HOW TO CREATE A TABLE IN MICROSOFT EXCEL

Create a Table in Microsoft Excel

Before creating a table, make sure you already have the data and already know what kind of table you want to create.

Btw, do you know what a table is? And how is it different from tables in other software?

What is a Table in Excel?

Tables are a feature that can help you group data together, so the data you have is easier to read.

Like tables in general, this number processing software also consists of columns and rows that you can adjust the amount according to your needs.

Table Functions in Microsoft Excel

The main function of a table in Excel is to add rows of data without changing the writing structure that has been created.

No less important, the tables in this number processing software can serve to make your data look more attractive and easy to understand.

You can edit the table as needed, so the existence of the table feature is very important for making a data report.

How to Create a Table in Microsoft Excel

To make it is quite easy, you know. Do not believe? Take a look at the tutorial below.

If you think how to create a table in Microsoft Excel requires additional applications, then you are wrong guys. Because you can create tables directly, without third-party applications. So, this is the way.

  • The first step, open Microsoft Excel on your PC.
  • The block of data that you want to insert into the table.
  • Then, click Insert – Table.
  • Then, make sure the data you want to enter into the table is correct.
  • Finally, click OK.

Finished! If you think the table made is less attractive, you can edit it on the Table Style menu. In addition, you can also change the color of the column to make it easier for others to read.

How? How to make a table in Microsoft Excel is really easy, right?

So, good luck with that!

Continue Reading
Advertisement

Latest

How to change the username in Windows 10 How to change the username in Windows 10
Windows 103 days ago

How to change the username in Windows 10

SHARE More If you want to know how to change your username in Windows 10, This article will show you...

How to Remove Ad Banners in Windows 11 File Explorer How to Remove Ad Banners in Windows 11 File Explorer
Microsoft5 days ago

Microsoft Releases Windows 11 Insider Build 25120 For Insider Dev Channel

SHARE More Last week, Microsoft started releasing Windows 11 Insider Dev Build 25115 (Sun Valley 3) for Insider Dev Channel...

Microsoft Release Windows 11 Insider Build 22581 Microsoft Release Windows 11 Insider Build 22581
Windows 111 week ago

How to Upgrade Windows 11 Home to Windows 11 Pro

SHARE More Generally, nowadays many new devices have received Windows 11 Home by default, even though Windows 11 Home itself...

Here's Leaked One Outlook, Email Client For Windows 11 Here's Leaked One Outlook, Email Client For Windows 11
Microsoft2 weeks ago

Again, Here’s Leaked One Outlook, Email Client For Windows 11

SHARE More As previously reported, Microsoft is developing a new Mail Client that aims to replace all existing Mail Clients,...

Xiaomi 12 Lite 5G - price, specification and what we know before the premiere Xiaomi 12 Lite 5G - price, specification and what we know before the premiere
Phones3 weeks ago

Xiaomi 12 Lite 5G – price, specification and what we know before the premiere

SHARE More Xiaomi 12 Lite 5G is the upcoming medium brand whose premiere is fast approaching. What will the price...

How to avoid closing a business How to avoid closing a business
Business1 month ago

How to avoid closing a business?

SHARE More How to avoid closing a business? The Covid-19 pandemic has wreaked havoc on everyone’s pockets, but especially on...

How to save money How to save money
Finance1 month ago

How to save money: 4 easy steps to get started

SHARE More How to save money: 4 easy steps to get started Undoubtedly, the new year’s arrival is always accompanied...

How to apply for a credit card How to apply for a credit card
Credits1 month ago

How to apply for a credit card?

SHARE More How to apply for a credit card? If you are thinking of applying for a credit card, let...

What is inflation, and how does it affect your business What is inflation, and how does it affect your business
Finance1 month ago

What is inflation, and how does it affect your business?

SHARE More Surely you have heard the term inflation, and it is that it has become relevant in the national...

How to Restore Deleted Photos on PC How to Restore Deleted Photos on PC
Life Hack1 month ago

How to Restore Deleted Photos on PC/Laptop

SHARE More The problem of losing photos is also often experienced by users who store their images on a PC...

Categories

Trending

Share via
Copy link
Powered by Social Snap