Three things you must do when you inherit an Excel workbook

When you inherit a workbook, don’t put it into play without checking it out first with these three vital steps.

Office solution: Two ways to eliminate Excel grid lines from a PowerPoint slide

This week, learn the solution to the earlier challenge, how would you eliminate Excel grid lines from a PowerPoint slide?

Use Access validation rules to ensure accurate data entry

Your Access database is only as sound as the data it stores. Data types can only do so much. The next step is to constrain input values using validation rules.

Office challenge: Can you continue numbering by column?

This week, test your Word skills by out-smarting Word’s Numbering option to force numbering by column before by row.

How to delete duplicate values and duplicate records in Excel 2007 and 2010

Using Excel 2007 and 2010, you can use the same built-in feature to to delete duplicates in columns as well as duplicate rows.

Office solution: How to quickly add numbers in Word without a table

This week, learn the solution to last week’s Office challenge: What’s the quickest way to sum a series of numbers in Word?

Save replies in folders other than the Sent folder to increase productivity

Finding messages in the Sent folder isn’t for the meek; save replies with the messages instead. You’ll never hunt for another reply.

Office challenge: What’s the quickest way to sum a series of numbers in Word?

In this week’s challenge, test your Office skills by explaining how to sum numbers in Word without using table formulas.

Save keystrokes with this simple shortcut for copying in Word

Save a few keystrokes by using this keyboard shortcut for duplicating text and objects in Word.

Double-click shortcuts provide quick access to Word formatting options

Don’t wander around a tab or a menu looking for a command when a double-click can get you where you want to go.

Next Page »