Creation of a large number of visually consistent charts to represent different data is a time consuming and error prone task, unless you know how to copy formatting between charts. Also Excel 2007 introduced a new ability to create chart templates.read more...
If you need to select all objects embedded into the worksheet, e.g. select all charts to adjust their size, press Ctrl+G and click the Special button or use Ctrl to select objects individually.read more...
In some cases you may want to sort your data in non-standart ways. For example, if your data consists of month names, you usually want it to appear in month order rather than alphabetically.read more...
Range names is a powerful Excel feature which allows you to give a symbolic name for the cell or range of cells to be later used as convenient replacement for cell/range address in formulas.read more...
