Free Excel Tips and Articles

Is Excel an important tool you can't live without?

Would you like to meet with others to learn more about how to optimize your usage of Excel?

Today's author, Diego Oppenheimer, a Program Manager on the Excel team, delves into some of the more advanced functionality of Excel to solve a challenging problem.  The file used in this

Today's author, Diego Oppenheimer, a Program Manager on the Excel team, talks about connecting PivotTables to data stored in SharePoint Lists.

Today's author, Dan Battagin, a Program Manager on the Excel team, talks about joining two tables in Excel (a.k.a. returning multiple rows for VLOOKUP).

Today's author, Christian Stich, a Program Manager on the Excel Services team, discusses how to enable users to quickly and easily create workbooks using external data connections specified in s

Today's author, Charlie Ellis, continues discussing the spreadsheet he built to solve Sudoku puzzles.

We just recently released some online training courses for Excel Services and I wanted to call your attention to them.

Here is the way to save the active chart in Excel 2007 to a JPG file. It is better to size the chart appropriately before exporting it as an image.

Word VBA – Hide Field Codes

The following snippet will hide the field codes present in Word document.

VBA RmDir Method

Here is a simple method to delete the entire folder using VBA

The following code will help to set the AutoRecovery On using VBA. The frequency of Autorecovery Save can also be set / reset

<?xml:namespace prefix = o ns = "urn:schemas-microsoft-com:office:office" />

Word VBA Symbols to Entities Conversion Program

How to check if Range is Within a Table using Word VBA?

Search Formatted Text using Excel VBA / <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />Extract Colored Range using Excel VBA / Exce

Search Formatted Text using Excel VBA / <?xml:namespace prefix = st1 ns = "urn:schemas-microsoft-com:office:smarttags" />Extract Boldfaced Range using Excel VBA / Excel

ADO Connection is associated with some interesting events. To consume the events, create a class and declare the Connection object