You can apply currency, percentage, date, and other formats in Excel using keyboard shortcuts conveniently located in a group in the top left corner of your keyboard.

Have you ever wanted to know how many items in a list met a certain condition? Excel’s COUNTIF function can help you answer questions like “How many are more than $100” or “How many have the word blue in the description?”

This tip shows how you can easily print more than one worksheet in Excel, even when you don’t want to print the entire workbook.

Did you ever want to see, or jump to, the cells referenced in a formula, or the cells that reference the cell you are currently in? Excel’s Trace Precedents and Trace Dependents features do exactly that.

While tabs still have their place, tables are a much more powerful and flexible tool to help format documents in MS-Word. And the good news is, they are extremely easy to use.

When copying a field in Excel that contains a formula, Excel will adjust the formula for the new location. Sometimes that is exactly what you want, but other times you want the formula to stay the same. This tip will explain the difference between relative references and absolute references and how they affect a copied formula.

What good is a “Print Screen” button that doesn’t print your screen? It’s very helpful when you know what it does.

Have you ever wanted to have more control over what people can enter in a form or list you have created in Excel? Well, nerds call that “data validation” and it’s actually not hard to do.

I still meet people who are struggling to find the features they used before they upgraded to Microsoft Office 2007. These tools will help reduce the frustration level.