I will show you how to highlight cells with errors among an array of values. Here I am having an array of values and among them, I have some cells which contain errors. If you need to highlight those cells …
Lesson#113: How to highlight cells with errors in it Read more »
Here I will show you a funny trick to make a dancing chart in excel. For that, you have to follow some steps. 1. Make a range of data names like A, B, C, and D….. 2. Then put values …
Lesson#109: Tricks to make a dancing chart in excel Read more »
Hi friend. Here I will show a method to divert a user to anywhere in the workbook when a link is clicked. For this, some steps are required. Right-click on the cell where the link has to be created. Then …
Lesson#108: How to divert the user to another cell in workbook when clicked Read more »
Okay, friends here I will show you some interesting tricks about Excel. That is how to VLOOKUP pictures in excel. We have learned to look up values from a table but looking up a picture from the table is a …
Do you know which is the easiest method to separate words from the text? It is Text to Columns. Yes, my friend, there is no other easiest way to do it. Now I show you the easiest method to separate …
Lesson#104: The easiest method to separate words from a text Read more »
Often we need to find the duplicate values in an Excel worksheet. Here in this post, I will discuss 4 Ways to find duplicate values in a worksheet. 1st Method: Function MODE and MODE.MULT The Excel MODE function returns the …
Lesson#103: 4 Ways to find duplicate values in a worksheet Read more »
How to avoid name conflict errors when copying a sheet in Excel. In this post, I will discuss a serious problem faced by many Excel users. Whenever we try to copy a sheet Excel sometimes shows an error. The name …
Lesson#102: How to avoid name conflict error when copying a sheet in Excel Read more »
Here in this post, I will show you how to hyperlink all files and folders in the worksheet within a minute. This can be done very easily. Often we need to make the summary of soft copies and link those …
Lesson#101: Hyperlink all files and folders in the worksheet within a minute Read more »
So I have discussed creating a chart and what type of data is suitable for what type of chart. Now I am going about a detailed discussion about the features and options behind the chart. These are very important when …
Here I will show you some examples for column charts and bar charts as well. Column charts can be used to represent data or values graphically which are arranged in categories. Here we are having a whole year of average …