Excel 2002

Post image for Weekly Roundup: Popular Word fixes, Excel row headers, and Office for iPad

Now that it’s past the annual holiday season here in the US, it’s back in the saddle again for the Weekly Roundup. This week: Microsoft Office blog does its own list of most popular posts (including a couple of issues that continually plague legal office users), a quick-and-dirty Excel tutorial on printing title rows, and an exciting rumor for iPad users.

Read More
Post image for Reader Question: Calculate difference between two dates in Microsoft Excel

A reader asked me recently how to calculate the difference between two dates. My response? Well, it depends. Fortunately, there are only two scenarios to pick between, and I’ve illustrated them both in this post. Click through for complete tutorial on how to calculate in Microsoft Excel using dates.

Read More

Creating a custom timeline in Excel

by VideoTutor on April 4, 2011

Jessica, a reader from Miami, wanted some help with creating a custom timeline in Microsoft Office. Here’s the Excel-based solution I created for her.

Read More

Customizing the Status Bar

by The Guru on February 23, 2011

There’s a whole host of ways you can make the various Microsoft Office applications easier to use. In fact, most users don’t take full advantage of the options for customizing these applications to make the Office suite work better for them.

Today, we’re going to talk about one of the easiest customizations: the Status Bar.

Read More

If you use Microsoft Excel to organize data (say, a list of documents being produced), you may have run across The Cell That’s Too Small For Its Data. Fortunately, there are ways to get information to fit into a single cell. Here’s how to wrap text, insert manual line breaks, and control vertical alignment in a cell.

Read More

If someone sends you a document with a .docx extension, it’s a Word 2007/2010 file. You don’t have to upgrade to open or edit it, but you do need to download and install an easy conversion tool from Microsoft. Here’s how.

Read More