The “Control Panel Spreadsheet” — How to Use Excel to Quickly Launch Links, Documents and Programs

Excel

Microsoft Excel is a powerful tool to analyze data, display charts and graphs, and create reports. While most people use MS Excel for these tasks, they often overlook the flexible features and many possibilities that Excel offers. For example, I created a spreadsheet storing hyperlinks to launch folders, documents, web pages, and even programs that I use most often. I then categorized the links under various categories to retrieve them quickly. There are many benefits to using such a … [Read more...]

5 Useful Outlook Functions You Might Not Know About

Outlook

Microsoft's Outlook is a powerful e-mail front end, which also has heaps of functions for managing your calendar, address book, tasks, notes, and even a journal. It's a bit mind-boggling, actually, but I thought I'd mention a few features that I've found to be extremely useful. I happen to be using Outlook 2007 at the moment, but most of these are available in previous versions. … [Read more...]

5 Functions You Might Not Know About in Microsoft Word

Microsoft Word

Like most of Microsoft's products, Word contains about ten times as much functionality as most of us will ever even be aware of. That's the state of PC software these days, and one of the reasons why I find applications on my phone to be quite refreshing – they do one thing very well, but they don't attempt to do everything. … [Read more...]

Creating Watermarks in Word, Excel and PowerPoint (2003)

Watermark

Watermarks are texts or pictures that appear as background in a document.  In an office setting, they are often used to identify the status of a document or qualify the document (i.e., draft, final, for discussion, internal, etc.).  For example, if you are writing a memorandum to a partner or an opinion to a client, it is recommended that you add a watermark if additional work is required.  This is helpful to the reader, but also for liability purposes.  Using watermarks is not the only way … [Read more...]