Office Tips

Turn Columns into Rows Using Excel’s Transpose Function

by File in: Office Tips

If you work extensively with Excel at home, at work, or in a home office you have the luxury of setting up your worksheets exactly as you want them. However, each person has their own quirks and methods for working with Excel. Some prefer organizing data into columns and others into rows. If someone gives […]

How to Use Excel’s What-If Analysis

by File in: Office Tips

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

Automatically Remove Duplicate Rows in Excel

by File in: Office Tips

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, […]

Connecting Excel to MySQL: Query Wizard

by File in: Office Tips

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

Connecting Excel to MySQL

by File in: Office Tips

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

Outlook 2007 Spell Checker Not Working

by File in: Office Tips

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

Fix “Word Cannot Start the Converter MSWRD632.WPC” Error

by File in: Office Tips

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

How to Delete Blank Lines in Excel

by File in: Office Tips

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

How to Create Multiple Linked Dropdown Lists in Excel

by File in: Office Tips

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

How to Take Instant Screenshots using OneNote 2010

by File in: Office Tips

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