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 »