PRIME Resources
Resource Home Page

Contact PRIME

Contact Webmaster

Office Computing Magazine Articles

Lee Hudspeth and T. J. Lee serve as Senior Contributing Editors to Office Computing magazine where they provide hands-on step by step solutions to the real problems that users face every day.

Office Computing January 1998 Issue Cover Story: Build an Intranet in an Hour    Set up your own intranet with Office 97? You bet - even if you have only a simple Windows 95 peer-to-peer network. With a pair of Microsoft freebies, Personal Web Server and the 60 Minute Intranet Kit, plus Microsoft FrontPage 97 with Bonus Pack, you can set up and run your own internal Web site from any Windows 95 computer on your network. This project shows you how to fit the pieces together even on a simple two-computer network. Project 2: Master Excel Spreadsheets    Are your spreadsheets bulletproof? Are you sure? Just because you faithfully update them, there's no guarantee they're accurate. But here's a little spreadsheet insurance: In this project we'll cover the basic arsenal at your disposal for auditing Excel spreadsheets. Complete with one click Formula_Flipper and Style_Flipper macros to make your spreadsheets airtight! Project 3: Move from Exchange to Outlook with Ease    Address books -- big deal. That's what you may think, but if you Microsoft Exchange to Outlook, you're in for a big surprise. While Exchange's Personal Address Book did the job, it's skimpy compared to the vastly superior Contacts List in Outlook. You get lots more fields, along with the ability to truly customize your entries. In this project we cover how to migrate gracefully from Exchange to Outlook.

Office Computing October 1997 Issue Cover Story: Build the Perfect Time Tracker    Do you have trouble keeping track of projects, clients, and the hours you spend getting your work done? Then you need TimeIt, a timesaving utility that works with Microsoft Excel to record client names, tasks, work start and stop times, and other project-specific data. It's a boon for businesses that bill per hour or per project, and comes in handy for professionals who simply need to record their daily routine. We'll show you how to build TimeIt using Office's Visual Basic Editor. Project 1: Master Your Workday With Pivot Tables    In our cover story Build the Perfect Time Tracker, you created the TimeIt tool to log the hours you work. Now make it crank out meaningful reports. Add some code and arrange a few timesaving PivotTables to easily tally the hours spent on a project or a client. Project 2: Make Word's Shortcut Menus Do What You Want    What's another word for frustrating? In Microsoft Word 95, finding a synonym was only a right-click away. Unfortunately, Microsoft removed this handy feature in Word 97. Here's how to get that indispensable Thesaurus command back on the shortcut menu. Use this technique to customize other parts of Office's interface too. Project 3: Save Files To and From the Internet - Instantly!    If you think the term FTP means for the pros, then we're about to demystify one of the Internet's most basic functions--and reveal a hidden Office 97 feature that takes advantage of it. FTP, or file transfer protocol, is a common method for sharing files on the Internet. Here's how Office 97 lets you save and retrieve files on the Net directly from within Office applications. Project 4: Build an Office Diagram That's Smart and Secure    When you design a diagram using Excel's drawing tools, you can add flashy graphics but few words. If you want to elaborate beyond, say, names and titles, you're limited to the tiny space in each shape, right? Wrong. Our exclusive ShapeNotes program lets you add more text to flowcharts and diagrams built using Excel and Office Art.