How to Create Index Sheet Hyper-linked to Other Sheets

Some days ago, I was working with some data which was distributed in about 18 sheets within a single Excel file. I was supposed to make calculations and then present that file to senior management. Now presentation was important as well. I must have made it easier for...
How To Add Colored Cells in Microsoft Excel

How To Add Colored Cells in Microsoft Excel

The use of the SUM formula is common to add a range of cells. You can also use SUMIF as well if some condition has to be fulfilled for the addition of certain cells. But if we need to add certain cells from a range on basis of the cell background color or font color...

Subscribe To Excel Newsletter


You will receive it when a new post is published

You have Successfully Subscribed!

Pin It on Pinterest