In recent posts, I’ve been talking about validating your Excel data using VBA. I talked about creating a validation harness, which you...

Use Excel's Data Validation feature, in conjunction with Excel functions, to validate numeric data.

Use MS Access to clean numeric fields that contain text.

Use Excel's formatting and data validation features to validate phone numbers

Use MS Access to clean phone numbers in your Excel data.

Adding a Visual Basic structure to your Excel file for validating data.

Use Excel tools to validate a U.S. state.

Excel data can be messy. Use MS Access features to clean it up.

Use an append query to add Excel data to an Access table

Tips for making your Excel data import smoothly into Access

Find cells containing specific text A customer called me today to ask a question about Excel. I thought it was an interesting challenge,...

Relative references vs absolute references in Microsoft Excel macros

When getting started with the Excel macro recorder, start small, and build on your successes.

Last week I discussed using Excel effectively, in order to ensure it best serves your small business. I’m going to expand on that today,...

Ideas for maximizing your use of Microsoft Excel

Excel is a great tool for helping you stay organized, and many people create checklists in Excel for just that purpose. I’ve got a...

Adding a Watermark to an Excel document only when printing

A brief introduction to Pivot Tables, explaining what they are and why you might want to use them.

Using a scaffolding technique to build complex formulas in Excel

In previous blogs, I’ve talked about Excel’s VLOOKUP function. In one, I covered the purpose of VLOOKUP, and in the other, I explained...