In this article, we are going to learn about recommended charts in Excel. What is the use of a recommended chart? Where we can make use of it? What i...
Date bars update automatically Enter a start date and an End date and watch the date bars populate. This is what every excel based Gantt chart should...
Jazzing up charts with interesting shapes makes a strong visual statement when displaying results. There are times when we need to show charts with ma...
If you want to select range of cells - without using Mouse seletion Or Shift key, you can use F8 key as briefed below :- Suppose you wish to select t...
Updating the size of a source data range is necessary in order to update the reference in any formula using range Name, especially when using a PivotT...
Example 1: Add a formula for calculating the number of the previous year: = YEAR(TODAY())-1 To define a Name that returns the result of a formula...
To add a reference such as a workbook name, a sheet name, a printing date and time, or a path in one sheet: 1. Select Page Layout -> Print Titl...
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.