LyteByte

Tweaks on Computers, Internet, Blogging, Web 2.0 and Gadgets

Calculate Non-zero average in Excel 2003 and Excel 2007 excluding all cells with zeros. Use formulas with AVERAGE, AVERAGEIF, SUM, COUNTIF to get non-zero average. Take average of numbers greater than zero.

Keyboard shortcut to open Firefox in Windows XP and Vista. Assign a keyboard shortcut ctrl + alt + F to open any instance of firefox

Keyboard Shortcut to open IE, Internet Explorer in Windows XP and Vista. Assign a keyboard shortcut to open Internet Explorer

how to insert the same header and footer in all the Excel sheets from Office 2007 and how to multiple select sheets in Excel?

How to send offline messages to friends who are offline or invisble from Yahoo Messenger inside Yahoo Mail

For website which does not render properly in IE8, use meta tag to forcefully render them using IE7 in IE8 Beta

Use Chart Advisor from Microsoft Office Labs in Excel 2007 to present the data with the best chart and also use the features like Filter data and Modify chart to present data in bar chart, cluster chart, line chart, area chart, scatter plot etc.