Office Apps | Geekgirl's

Display each Word document in its own window

If you have a document open in Word 2007 or Word 2010 and you open another document, that second document is displayed in the same window as the first. To view the now-hidden first document, you can’t, as you might expect, swap between the two documents by...

Should you install the 64-bit version of Microsoft Office 2010?

Office Apps, Tips

The latest version of Microsoft Office comes in 32-bit and 64-bit flavours. It’d be natural to assume that if you have a 64-bit computer running a 64-bit version of Windows then you should install the 64-bit version of Office 2010. Not so. You’re almost...

Databasics IV: Streamlining data entry

Databases, Office Apps

In the previous tutorial I discussed some guidelines for creating data entry screens that are easy to use. In this tutorial, we’ll put those guidelines into action by refining the membership database we introduced in part two of this series. I’ll step...

Sorting Outlook contacts and messages by multiple criteria

Blog, Office Apps, Outlook, Tips

It’s a trivial task to sort your Outlook contacts: simply display them in List view and click any of the column headers. So, to sort by category, click the Category column header; to sort by name, click the Full Name column header. It’s an equally trivial...

Spreadsheeting I: Basic concepts

Basic Computing, Excel, Office Apps

While word processing programs are the most commonly used office application and browsers are probably the most commonly used application of all, much of the success of personal computers is due to spreadsheets. In 1979, two blokes – Dan Bricklin and Bob Frankston –...

Shading every other row in Excel

Excel, Office Apps

I sometimes wonder whether Microsoft spends so much on its programming budget it has little left over to spend on designers. This thought often crosses my mind when working with Office sample files, templates and styles. Take, for example, the auto-formats supplied...

« Older Entries

Next Entries »