LyteByte

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

Recently we saw how to change the default OS while dual booting Windows Vista and Windows 7. If you had installed Windows 7 on the machine which earlier had Windows Vista, then by default you will not be able to access the Vista partition.
So let see how to access vista partition in Windows 7?

Change the boot order of the default OS when using dual boot or multiple boot system. For example to change boot order between Windows 7 and Windows Vista

Add Excel 2007 Macro to Quick Access Toolbar for easy access of Excel Macros. Also use keyboard shortcut to access Excel Macro in Office 2007.

How to load and unload add-in or plugin in Excel 2007. Choose from lots of Excel plugins to install and uninstall. Analysis ToolPak – Provides data analysis tool for statistical and engineering analysis
Analysis ToolPak VBA
Conditional Sum Wizard
Euro Currency Tools
Internet Assistant VBA
Lookup Wizard
Solver Add-in

Easy method to delete, remove duplicate cells, columns or rows in Excel 2003.

Changing the wireless network priority in windows vista. Use manage wireless networks to change the order of priority in which vista connects to wireless networks.

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.