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.

Last week, I wrote a blog post about creating a validation harness in Excel VBA. I laid out a structure you can add to your Excel file...

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.

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

There’s a cool feature in PowerPoint that allows you to see all of your slides in sequence, move them around, and double-click to edit...

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

I am the first to admit that when it comes to Excel, I don’t know it all. Hard to believe, I know (LOL!!) I’ve had students who don’t...

Excel is a great tool for data analysis, with a powerful suite of built-in functions to help. You’re probably already familiar with some...

Excel has some amazing report tools including charts and pivot tables. These tools are quick and easy to use, and produce some...

Excel or Access? Microsoft has lots of great tools, and in most cases, it’s pretty clear which you need to use. If you need to write a...

If you've ever thought about creating macros in Excel, you've probably heard the term "VBA". In this post, I'm going to give you a little...