This links to my blog posts and pages dealing with using Microsoft Excel 2007 and 2008, including Visual Basic for Applications. The blog pages show below the top-level page in the right hand column, while blog posts only show in the list below.
Functions in Excel:
Learn how to compare values instead of values and types.
Learn how to create IF statements and both why and how they work.
Learn how to left pad a text field in Excel
Learn how to parse text string from the left, right, and middle.
Querying external database sources:
Tricks and Techniques in Excel:
Learn how to convert a date to a string without a format mask.
Learn how to insert an image into a cell comment.
Learn how to LPAD a cell’s content.
Learn how to an exclusive or logical comparison statement.
If you have suggestions for other concepts, post a comment.