When you start a new blog or a website, after you have selected a domain name, you have the option to use www with a domain name or use the domain name without www. It was an enormous achievement for a 9th-grade student 15 years ago to know that ‘www’ stands for “world wide web”. Now it … Read more

## How to Create Index Sheet Hyper-linked to Other Sheets in Excel

The problem is creating a detailed statistical analysis report with multiple sheets in a single Excel file. The target audience is middle-level management that doesn’t require summaries but detailed analyses. And the report should be self-explanatory and easy to switch through the required sheets. First of all, name all the sheets so that they speak for … Read more

## Keyboard shortcut for AutoSum option in Excel

Working with Excel in an office environment extensively needs you to work with a keyboard. You need to be quick to be productive. Time and motion study proves that making use of keyboard shortcuts reduces the time required to accomplish a task. You must learn the shortcuts for the tasks you use more frequently. The probability … Read more

## Calculate Age and Remaining Days in an Event using DATEDIF in Excel

Do you need to calculate your age in Excel? Or there is a requirement to find the number of years, months, and days between two dates. Excel function DATEDIF helps us find this difference. The syntax for this function is as under: To use the above function, the first date must be occurring before the second … Read more

## How To Add Data in 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 of … Read more