Sum a Range of Cells that Contains Errors
Every now and then you will need to calculate sum (or average, min, max, etc.) of a range of cells that contains errors. Normal functions...
Category: Advanced
Customize Ribbons
You can customize your ribbons, add new commands or rearrange existing ones as you like. In this post I will show you how to customize...
Website Like Ratings
I was looking for hosting solutions for beatexcel when I saw ratings for hosting companies on almost all affiliate sites. I wondered whether we can...
Text to Columns
Sometimes you may need to divide text data columns. This can quickly become a dreadful task. To overcome this problem, Excel provides a tool named...
Excel Heat Map
Heat map is a good way of visualizing distribution and it is very useful for quickly seeing where data is piling up, thus which data...
How to Disable Send A Smile
This time I will show you how to disable Send a Smile that places itself on your office apps and never goes away. I was...
