Free Excel Tips and Articles

[TUT] visual basic 2005

Submitted by Support on Fri, 06/06/2008 - 19:07

tutorial about visual basic 2005 with: visual basic 2005 express edition

UK Excel User Conference

Submitted by Support on Fri, 12/12/2008 - 08:16

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?

Understanding Excel Services Load Balancing Options

Submitted by Support on Fri, 12/12/2008 - 08:06

Today's author, Steve Tullis, a Program Manager on the Excel Services team, talks about the various load balancing schemes available for Excel Services. 

Using Excel to Optimize a Network Problem

Submitted by Support on Thu, 12/04/2008 - 06:59

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

Using the Open XML SDK to Work With Excel Files

Submitted by Support on Tue, 11/25/2008 - 17:58

Over on Brian Jones' blog there are two recent articles that may be of interest to our readers here.&nbs

Using PivotTables to Analyze Data From a SharePoint List

Submitted by Support on Thu, 11/06/2008 - 19:40

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

Excel Web Application Announced at PDC

Submitted by Support on Wed, 10/29/2008 - 06:42

During today’s Professional Development Conference k

Creating a Master-Detail View in Excel

Submitted by Support on Fri, 10/24/2008 - 04:35

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).

Don't forget about the "A" in "VBA"!

Submitted by Support on Fri, 10/17/2008 - 18:36

Today's author, Stephane Viot, a Program Manager in the Office Global Experience Platform team, re

Using Office Data Connection files (.odc) and the DataConnections Web Part in SharePoint to Specify External Data Connections in

Submitted by Support on Wed, 10/15/2008 - 23:55

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

What is the fastest way to scan a large range in Excel?

Submitted by Support on Fri, 10/03/2008 - 21:43

Today's author, Dany Hoter, a Product Planner on the Excel team, talks about some performance characteristics he recently discovered using various methods to manipulate large ranges using VBA.<

Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 2/2

Submitted by Support on Thu, 10/02/2008 - 06:25

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

Building a Basic, Understandable Sudoku Solver Using Excel Iterative Calculation - Part 1/2

Submitted by Support on Tue, 09/30/2008 - 05:56

Today's author, Charlie Ellis, a Program Manager on the Excel team, shares a spreadsheet he built in Excel for solving Sudoku puzzles.  The spreadsheet can be found in the attachments at t

New Online Training Courses for Excel Services

Submitted by Support on Tue, 09/09/2008 - 23:15

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

Video Tip: Conditional Formatting and Data Validation

Submitted by Support on Fri, 09/05/2008 - 20:47

Today's author: Sam Radakovitz, a Program Manager on the Excel team that enjoys creating VBA applications in Excel.

How to Save a Chart as Image using Excel VBA

Submitted by Support on Sun, 03/15/2009 - 13:09

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.

How to Show Field Codes in Word Document – using VBA

Submitted by Support on Sun, 01/04/2009 - 13:32

Word VBA – Show Field Codes

Here is a simple way to show the field codes in Word

How to Hide Field codes in a Word Document using VBA

Submitted by Support on Sun, 01/04/2009 - 13:32

Word VBA – Hide Field Codes

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

How to Insert Document Properties in Word Document

Submitted by Support on Sun, 01/04/2009 - 13:25

Update Document Properties in a Word document using Field codes

How to delete Folder using VBA

Submitted by Support on Thu, 01/01/2009 - 11:38

VBA RmDir Method

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

How to Convert Decimal to Hexadecimal using VBA

Submitted by Support on Thu, 01/01/2009 - 11:36

How to Convert Decimal to Octal using VBA

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

Enable AutoRecovery using Word VBA / Set Auto Recovery Duration using VBA

Submitted by Support on Thu, 01/01/2009 - 11:35

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

How to Disable AutoRecovery using Word VBA

Submitted by Support on Thu, 01/01/2009 - 11:33

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

Expand Ranges in Word using VBA

Submitted by Support on Thu, 01/01/2009 - 11:30

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

How to Undo the last action using Excel VBA

Submitted by Support on Thu, 01/01/2009 - 11:26

How to Validate Keypress in Excel VBA

Convert Symbols to Entities using Word VBA

Submitted by Support on Thu, 12/25/2008 - 01:35

Word VBA Symbols to Entities Conversion Program

How to Show File Print Setup Dialog Box using Word VBA

Submitted by Support on Thu, 12/25/2008 - 01:34

The following code displays the Print Setup Dialog

Sub Show_PrintSetup()

With Dialogs(wdDialogFilePrintSetup)
.Show
End With

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

Submitted by Support on Wed, 12/17/2008 - 00:38

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

How to set and reset track changes using Word VBA

Submitted by Support on Wed, 12/17/2008 - 00:38

Word VBA Set / Reset TrackRevisons

How to Search a specific Colored Text (Range) using Excel VBA

Submitted by Support on Wed, 12/17/2008 - 00:35

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

How to Search Italic Text (Range) using Excel VBA

Submitted by Support on Wed, 12/17/2008 - 00:32

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

How to Search Bold Text (Range) using Excel VBA

Submitted by Support on Wed, 12/17/2008 - 00:30

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

How to Search Underlined Text (Range) using Excel VBA

Submitted by Support on Wed, 12/17/2008 - 00:27

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

How to use Connection events in ADO (VBA)

Submitted by Support on Sat, 12/06/2008 - 01:54

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

Call a Method in VSTO Addin from Visual Basic Applications

Submitted by Support on Wed, 11/26/2008 - 01:47

How to call a VSTO Addin Function from VBA

VSTO Addins we write might contain good num