Microsoft Excel Useful Tips

Click the followings to see the solution (tested in Ms Excel 2007), these links will open in new popup window:

1. Convert Column to Rows and vice versa
2. Get started with PivotTable Reports
3. Create a drop-down list from a range of cells
4. Get started with PivotTable reports in Excel 2007
5. Example of formatting a cell to percentage :: =TEXT(J5,"0.0%")
6. Example of concatenating cells/texts :: =CONCATENATE(H3, "(",H6,")")