Welcome to part two of this two part series covering how to use Excel with a MySQL database. Part one of this series can be found here:
Connecting Excel to MySQL – Part I
In this post we are going to use a tool that is built into Excel. It’s called Microsoft Query Wizard and it will [...]

Sure Excel is used for spreadsheets, but did you know you can connect Excel to external data sources?
In this article we’re going to discuss how to connect an Excel spreadsheet to a MySQL database table and use the data in the database table to populate our spreadsheet.  There are a few things you need to [...]

I recently upgraded Office 2003 to Office 2007 on my computer and learned that my spell checker was no longer working in Outlook 2007! Usually, it would automatically show me misspelled words immediately if I mistyped them, however, after the upgrade, nothing was being marked.
Even if I ran the spell checker manually, it would complete [...]

Recently, I had a user in my office get the following error when trying to open a Word document:
Word cannot start the converter mswrd632.wpc.
Whenever the user clicked the OK button, it would simply pop back up. What was really weird is that if she clicked on the red X button, the document would open just [...]

One of the most common tasks in Excel is deleting blank lines. Whatever type of data you may have in Excel, there are many occasions where you will also have a bunch of blank lines throughout the file.
If you have thousands of rows, manually deleting blank lines is a major pain and virtually impossible. The [...]

So previously I wrote about how you can create a simple dropdown list in Excel, which is perfect for any kind of data validation. If you have a range of values that people are required to enter repeatedly, it’s best to create a dropdown list so that no invalid data can be entered.
That’s all great, [...]