Tips

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

How to Add and Remove Excel Add-in or plugins?

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

How to Remove Duplicates in Excel 2003?

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

How to Login as Administrator in Vista from Welcome Screen?

Login as administrator in vista. Access administrator account from vista login screen. Enable hidden administrator account in vista.

How to Run as Administrator in Vista Command Line?

Recently I wanted to do some actions in Windows Vista command line prompt but with elevated access as an Administrator. You may need this access to do actions like creating symbolic links etc. So, how to run as administrator in Vista command line?

How to Change the Priority of Wireless Network in Vista?

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.

How to Calculate Non-Zero Average in Excel?

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.