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 →
Working with Excel in office environment extensively needs you to work with keyboard. You need to be quick to be productive. Time and motion study proves it that making use of keyboard shortcuts …
Continue Reading about Keyboard shortcut for Autosum option in Excel →
You might need to calculate your age in Excel. There may be requirement to find number of years, months and days between two dates. Excel function DateDif helps us find this difference: Syntax for …
Continue Reading about Calculate Age and Remaining Days in an Event using DateDif in Excel →
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 →
If you are used to keyboard short-cuts, it really makes life easier. You can really do tasks way faster. You have plenty of keyboard shortcuts once you are working in Excel. But you want to open …
Continue Reading about How to Assign Keyboard Shortcut to Open Excel in Windows →
Era of electronic spreadsheets started from VisiCalc in 1983 and now well developed version of Microsoft Excel 2010 is available at this moment and too much is to appear yet. Name any profession …
