One often overlooked feature of Excel is the What-If Analysis that allows you to explore different scenarios without changing the values in your spreadsheet. This function is particularly useful for economics and management majors as well as business owners because you can see how different values affect models, formulas, and projected profits. Excel’s What-If Analysis [...]

4 There are 4 comments, care to add yours?

Excel 2007 is a versatile application having grown far beyond its early versions as simply a spreadsheet solution. Employed as a record keeper, address book, forecasting tool, and much more, many people even use Excel in ways its programmer never intended If you use Excel to keep track of many addresses, products SKUs, receipts, expenses, [...]

2 There are 2 comments, care to add yours?

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

0 There are 0 comments, care to add yours?

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

12 There are 12 comments, care to add yours?

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

21 There are 21 comments, care to add yours?

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

106 There are 106 comments, care to add yours?

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

4 There are 4 comments, care to add yours?

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

18 There are 18 comments, care to add yours?

I am a heavy screenshot taker.  I use it to take pictures of windows, buttons, and screens that are otherwise hard to explain using words.  Seems like Office 2010 developers are aware of this growing demand for better screenshot taking tools also.  Traditionally I use the print screen button and then crop the image using [...]

3 There are 3 comments, care to add yours?

I am a big fan of text-to-speech technology.  Excel 2007 is packed with many features, including one called Speak Cells, which basically lets you feed your chosen cells to a text-to-speech engine.  It is a great accessibility tool – when my eyes are  too tired to read the cells on my computer screen, I just [...]

1 There are 1 comments, care to add yours?