How to format numbers the way you want in Excel

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 […]

How to create an instant micro-chart from your normal chart in Excel

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 […]