In this article we will learn how to put an Excel file or table inside a word file . This is the simplest method available. Why should we embed an Excel file in Word software and what are the…
In a project, we may get large Excel tables used at the beginning of some of the cells at that point. The question that arises is how can I add them or get rid of them?…
Read this article if you do not know how to enable spell checker in Excel software. In this section you will learn how to enable spelling correction using VBA . Let’s start with an example: In the image below, you…
In this section, we will learn how to convert text to numbers in Excel. We all know that in Excel by default, the numbers on the right and the text on the left of the cell…
How to compare the two columns through “Conditional Formatting” and make the area red in places where there is a difference? I want to compare 2 columns (column A and column B ) and change them to red if the data in column B is different. I can give a…
Excel software sorts data according to certain rules. We can sort numerical data in ascending or descending order. Also arrange the text in alphabetical order A to Z and Z to A. We can also sort them by font color or cell color. This option is…
Working with Excel has become much easier since Microsoft presented all the commands in Excel software in an interesting category. In this article, we will introduce these menus, which are known as ribbons. File tab in…
Sorting data makes it easier to review and read. If you have a large data set and want to do multi-level data sorting (ie column-by-column sorting), there are two ways to do this: Method 1 –…
Pie chart: This chart is used to show the total ratio. The total number of numbers and ratios is considered to be 100, and the graph contains only a few sections (if the number of sections…
If you use Excel regularly, you will definitely see dates and times in your cells. The history of creating or updating data is usually recorded, so it is important to know how to work with this…