Tips and Tricks

When you are working with a large workbook having multiple worksheets in it, one concern that comes in mind is about printing all or selected… Read Article

Have you ever wondered that we can even send an email from excel using an excel formula by just a simple mouse click? In this… Read Article

If you are a regular excel user with a large number of data in it, a day may come when you wish to change and… Read Article

Many a time, you may want to hide the zero value in a cell in Excel. In this blog, we would unlock the technique to… Read Article

Do you know how to convert a decimal number to a fraction in Excel? There are two ways using which you can display decimal numbers… Read Article

Have you ever wondered how to count the number of characters, string, or words in a cell or multiple cells in Excel? In this blog,… Read Article

Have you ever wondered how to insert a degree symbol in an excel cell? If not, then you are in a right blog.… Read Article

In this blog, we would learn multiple ways to insert a checkmark (tick mark) and cross mark symbol in excel. However, before learning it, it… Read Article

In this amazing tutorial, we would unlock the technique to find and replace the cell color in Excel. Let us take a small example to… Read Article

In this blog, we would learn what are the wildcard characters and how can you use the wildcard characters in Excel to filter your data… Read Article

In our previous blog, we had learned to create a macro by recording it. In this blog, we would learn multiple ways to run a… Read Article