Imagine you have multiple identical sheets in a workbook that contains identical tables (like attendance records of each month in a separate sheet). N...
Deleting unused blank rows from a sheet can help you reduce file size significantly and make your dashboard cleaner. In this article we will learn...
You may have observed the "You've Entered Too Few Arguments For This Function" error while using Excel. This happens when you don't provide all th...
Activate the Wrap Text to make CHAR(10) formula work. So in my previous article, I had told you how to use the CHAR(10). The CHAR(10) formula...
In my previous article, I had explained how to convert a number to words in Excel using VBA. I had written a number of code lines to achieve this....
When you work with multiple workbooks in a business, you import data from various external data sources. The external source can be another excel ...
The SUMIF function is a useful function when it comes to summing up values based on some given condition. But there are times when you will face s...
"Data source reference is not valid" is one annoying problem that can be hard to get rid of, if you don't know the source problem. In this article...
Excel is fast enough to calculate 6.6 million formulas in 1 second in Ideal conditions with normal configuration PC. But sometimes we observe exce...
Excel is an amazing tool for analyzing and visualizing data sets. To visualize and make report we often need to save small chunks of data. These...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.
