Microsoft Excel
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 2007/2008:
-
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 2007/2008:
-
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.
Subscribe via RSS
I heard about a not too bad program that works with Microsoft Excel files, it’s called Recovery Toolbox for Excel. It is free utility to save important information, such as graphics, statistic and mathematics. The program will help you to recover valuable information and avoid its losses, tool scans your broken worksheet, and then gets the data from this document. It will help you to repair damaged files in Microsoft Excel sheet recognizable format, and repair file Excel this file is not in a recognizable format.
mutu26
17 Feb 09 at 10:28 am
I took a quick look at the web site allowing the comment but I changed the link to the home page for a set of tools. I’ve never tried them and can’t vouch for them. The fact that the tool for Excel was an *.EXE not an *.MSI made me a bit nervous. If somebody else checks it out, please let us know whether it’s a good thing or not. I’ll try to setup a contained test environment after March 2009. Thanks.
maclochlainn
17 Feb 09 at 12:40 pm