You can make excel to format numbers the way you want using “format cell. Select the cell with number you want to format and presst ctrl+1 or right mouse click then choose format cells Go to Number tab in the dialog box. Select “custom” category and enter format as 000000 00000 (6 zeros followed by
Using named ranges in formulas saves you a lot of time In order to define one: Select some cells,go to menu – insert – named ranges – define
How to calculate weighted average in Excel 2007: use SUMPRODUCT() function
To create partially overlapped column / bar charts in Excel 2007 Use overlap and gap settings in the format data series area. A overlap of 100 will completely overlap one series on another 0 separates them completely
To move a chart and align it with cells, hold down ALT key while moving the chart
To create an instant micro-chart from your normal chart, use the camera tool Go to menu then tools then customize In the dialog go to “Commands” tab and select “tools” in categories. Scroll down the commands until you see the camera tool Drag and drop this in your tool bar as shown below How to
To change the shape of cell comments from rectangle to a different symbol Select the comment Go to drawing tool bar Change the shape from there
How to align multiple objects in Excel Eg – charts, drawings, pictures Use drawing toolbar > align and select alignment option
