Archive for MS Office
You are browsing the archives of MS Office.
How to change or move the location of Gmail pst file in Outlook 2007?
Move the default location of Gmail IMAP pst files in Outlook 2007 in Vista and Windows 7. Step by step guide to change the location of pst files in Outlook from Office 2007.
How to Create Excel Chart With 2 Y-axis or X-axis?
How to create excel charts with multiple y-axis and x-axis? Create charts with secondary and primary vertical and horizontal axis.
How to Check or Convert Equations in Linear From to Hand-Written or Text Book Style?
How to use your Office Word 2007 to check or convert the equations that are in linear form to professional form or like hand written equations like you see in text books. You can also use MathCad but that is a costly alternative.
How to add Excel Macro to Quick Access Toolbar in Office 2007?
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 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 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.
