Tuesday, November 9, 2010

Firefox useful plugins for Web developer

  • Firebug - Web development and debugging tools to debug HTML, Javascript and CSS
  • Firefox Throttle - Bandwidth utilization throttling plug-in
  • HTTP Fox - An HTTP protocol/packets/requests analyzer
  • User Agent Switcher - Tool to switch the user agents without switching the browsers

Tuesday, November 2, 2010

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,")")