learn to solve problems using MS Excel
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. …
Continue Reading about How to Create Index Sheet Hyper-linked to Other Sheets →
Use of SUM formula is very common to add a range of cells. You can also use SUMIF as well if some condition has to be fulfilled for addition of certain cells. But if we have to add certain cells from …
Continue Reading about How To Add Colored Cells in Microsoft Excel →
