Articles by Department

David Horowitz illustrates the use of the Word.Range.FormattedText property to move text in Word documents without copying and pasting to the clipboard.

Bill Coan, Microsoft Word MVP and expert, gives you his take on his power-user book for Word 2007.

Herb Tyson, Word MVP and author of Microsoft Word 2007 Bible, explains how to deal with Word 2007's new Normal default file in its 2007 xml format.

Bill Coan reviews this book.

Geetesh Bajaj shows you how to turn your favorite photo into a puzzle using PowerPoint and a few graphic tricks!

Learn how to help ensure that data is properly entered into your database.

Having trouble dealing with AutoText in Word 2007? This article provides some ansewers.

If you've noticed that Outlook is running slower lately, it may be due to mime sniffing. Find out how to fix the problem.

Dian Chapman shows you how to quickly reformat pasted text that contains excess returns.

Geetesh Bajaj shows you how to handle PowerPoint 2007's new SmartArt.

Geetesh Bajaj shows you how to handle PowerPoint 2007's new SmartArt.

David Horowitz demystifies the use of the IIf function in VBA, which is used to select one of two values based on whether a test value is True or False.

Dian Chapman shows you how to work with checkboxes on a Word form.

PowerPoint MVP, Geetesh Bajaj helps you navigate around PPT 2007.

Bill Coan provides you with reviews and details on two, new Office 2007 Ribbon customizing addins.

This basic article explains how to create a table of contents in Word. It also covered how to use the TC field code to add addition items to your TOC or modify entry content without changing your headings.

Dian Chapman shows you some of the cool things you can do with Microsoft OneNote.

Make your own recording to let you know when you have new mail from someone special.

Herb Tyson, Word MVP and author of Microsoft Word 2007 Bible, provides a fix for Word's lagging when using the Adobe Acrobat addin.

Learn a couple tricks that will allow you to create master template that will contain content that can be inserted and locked down to ensure it is always contained within your company documents.

Microsoft MVP, Bill Coan, reviews this new Microsoft Office Advanced Document book.

Dian Chapman explains licensing and installation issues regarding using multiple versions of Microsoft Office on the same system and then shows you a cool trick to remove the long lag time when switching between versions.

Mike Glen examines the exporting of Project data as a gif picture and into a Web page.

Joanne Swensrude shows you how to take advantage of Outlook categories.

A paired comparison chart is used to compare pairs of experimental values over a set of different conditions. Microsoft Excel MVP Jon Peltier shows how to make a paired comparison chart in Excel.

Extract data from XML documents with Word 2003/2007 and the XML Path language. Word MVP Bill Coan's new freeware tool XPath Explorer for Word shows you how.

Dawn Crosier attempts to shed some light on section breaks. She pays special attention to troubleshooting a document which has been converted to Word from another application such as WordPerfect.

Linda Johnson shares a terrific tip from her recently published Microsoft Office Specialist: Excel 2003 Study Guide by Wiley.

Karen Clark shows you how to jazz up your name badge Word merges by adding graphics behind text.

Shawn K. Hall shows you how to decipher the version of PST file for Outlook so you can decide how best to use them within the new format of Outlook 2003.

Dian Chapman shows you how to setup and access the Microsoft virtual server to allow you to try Office 2007 without having to install it on your own system.

In Part III of this 4 part series, Geetesh Bajaj gives you a free excerpt from his new Wiley published book, Cutting Edge PowerPoint for Dummies.

In Part IV of this 4 part series, Geetesh Bajaj gives you a free excerpt from his new Wiley published book, Cutting Edge PowerPoint for Dummies.

Dian Chapman explains a widely missed, but very valuable, default display for Outlook.

Bill Coan provides expert advice to developers who wish to provide customization to Microsoft Word.

Joanne Swensrude shows you how to calculation time durations in Excel.

In Part II of this 4 part series, Geetesh Bajaj gives you a free excerpt from his new Wiley published book, Cutting Edge PowerPoint for Dummies.

Joanne Swensrude shows you how to print selected data from Excel.

Dian Chapman explains character styles in Word

Dian Chapman shows you what to expect in the next version of Office.

Learn how to use the Content Wizard in PowerPoint to quickly create professional presentations.

Candi Thomas covers the basics of Word's Compare and Merge feature.

Not sure what Office is all about? This article will explain it.

In Part I of this 4 part series, Geetesh Bajaj gives you a free excerpt from his new Wiley published book, Cutting Edge PowerPoint for Dummies.

Microsoft Excel MVP Jon Peltier shows how to use simple IO commands to exchange information between a running Microsoft Excel program and a text file. This is a simple technique to store parameters and log debugging information.

Dawn Crosier provides tips for working with documents in a legal environment, such as how to add the document's path to the title bar as well as how to modify the commands for working with documents which contain either tracked changes or comments.

Mike Glen continues with progressing the project by using Project’s Tracking facilities to update tasks, changing resource assignments, overtime and calendars to “crash” the project.

Outlooks Organize Window provides you with a few easy ways to organize your email.

Geetesh Bajaj gives you a peak into the revolutionary next version of PowerPoint

Geetesh Bajaj explains the new Research Pane in Office 2003.

Mike Glen continues with progressing the project by using Project's Tracking facilities to update tasks with % Complete, Actual Start, Actual Work and Remaining Work, producing a tailored Input form.

Microsoft Excel MVP Jon Peltier shows how to create a combination Line-Area chart in Excel, which allows the region between the lines to be shaded a unique color.

Have you been frustrated running images between Photoshop and PowerPoint to achieve some simple effects. Geetesh Bajaj shows you how to create simple montages in PowerPoint itself.

Microsoft MVP and Word Developer, Bill Coan, gives you a terrific macro that you can use to create various sized graph paper in Word.

Mike Glen continues with progressing the project by using Project’s Tracking facilities, including Gridlines, Progress Lines and rescheduling.

Dian Chapman provides you with some tips to use your Outlook Contact list better.

David Horowitz demonstrates how to programmatically control a third party application to take charge of Outlook security warnings, exploring Outlook Read Receipts, MailItems, Recipients and Application_ItemSend event handlers along the way.

Candi Thomas helps you get a handle on your Mail Merge address list.

Dawn Crosier shows you how to separate table of content codes in a Word doc.

David Horowitz tells us about a third party application that can help you control Outlook security warnings.

Mike Glen begins progressing the project by using Project’s Tracking facilities.

Bill Coan reviews a popular Word book.

Dennis Roche helps you work through a consolidation of updates for Office 2003 installs.

Dian Chapman shows you how to add automation to your template to get header fields to automatically update.

Mike Glen continues deliberating on customizing by looking at the possibilities with Project’s Reports.

Dian Chapman shows you some of the great things you can do with Publisher 2003.

Geetesh Baja gives you some professional tips to keep in mind when creating your presentations.

Dawn Crosier shows you how use V BA code to add a little control to the Select Browse Object feature in Word.

Mike Glen shows you how to make use of various view in MS Project.

Karen Clark provides some great details for those of you who must convert complex documents into PDF files.

Microsoft Excel MVP Jon Peltier shows how to create a pivot table and its related pivot chart, and how to create a regular chart from a pivot table.

Candi Thomas helps you set up a basic letter mail merge in Word XP.

Dian Chapman shows you how to setup a master template with VBA so your users can add/remove stationery logos with just a click.

Microsoft Excel MVP Jon Peltier shows how to use a stacked area chart to mimic a floating bar chart with variable thickness bars.

Mike Glen continues deliberating on Views with customizing Filters.

John Mansfield follows up last month's Dynamic Formula Charting article with information about how to hide some data you don't want to display.

Dian Chapman explains why much of the assume document corruption in Word is really user error. And in this article, she shows you how to fix presumed table corruption.

Dian Chapman show you how to access special font characters to use in your documents.

Dian Chaman shows you how to use Microsoft Word to create your own letterhead.

Herb Tyson tells you why using Word as a web editor is not the smartest move.

John Mansfield shows you how to handle dynamic charts in Excel.

Mike Glen begins a dialog on customizing views, starting with Tables.

Dian Chapman shows you how convenient, useful and fun Outlook's Notes can be.

Bill Coan shows you how to add AutoText popups to allow you to easily customize documents you use over and over.

David Horowitz provides some additional and updated info on emails attachments with VBA.

Mike Glen continues a dialog on levelling, this time across multiple projects, with discussion on some of the levelling settings, including priorities and granularity.

Kim Hedrich finishes up her Text Effects lessons.

Need help keeping your daily ToDo list organized? Dian Chapman shows you how easily you can manage your life with Outlook Tasks.

Guest author, Terry O'Connor, shares his enhancement to Greg Chapman's Word Crayon. Terry provides you with two cliché list to check your documents.

Excel MVP Jon Peltier gives an advanced tutorial describing how to create variable width stacked column charts in Microsoft Excel.

John Mansfield discusses the limitations of Excel’s built-in data tables and provides a simple alternative solution.

Kim Hedrich shows you how to get more from ordinary fonts in Word.

Beth Melton shows you how to gain control over the new online help in Office 2003.

Dian Chapman explains how Frames and Anchors work in Word.

Bill Coan reviews the new Word Hacks book by O'Reilly publishing.

David Horowitz explains POP3 and SMTP to help you more easily setup your email accounts.

Mike Glen continues a dialog on levelling a project covering time-limited and resource-limited levelling and analyzing the results.

Geetesh Bajaj discussed PowerPoint with database integration.

Do you wish you could provide feedback to Microsoft but assume no one will listen? Microsoft Office MVP, Beth Melton, gives you her findings.

Smart Tags can enrich your interactions with Office documents; Bill Coan explains what they can do, shows how they work and points to sources of further information.

In this tutorial, Geetesh Bajaj shows you how to import a vector image and recolor it so that it matches well with the overall slide color combination.

One of PowerPoint's most well hidden secrets is its ability to recolor images. Geetesh Bajaj gives you the details to take advantage of this feature.

Mike Glen continues a dialog on multi-project management by explaining two other methods of consolidating projects into a master project and then levelling the result.

Kim Hedrich shows you how to work with photos in PowerPoint.

Excel MVP Jon Peltier gives an advanced tutorial about Pie Charts, Pie-of-Pie Charts, and extended pie chart techniques in Microsoft Excel.

Dian Chapman shows you how to easily create greeting cards in Word.

Kim Hedrich discusses issues to consider when using photos in Word docs

Mike Glen begins a dialog on multi-project management by explaining how you can consolidate projects into a master project and use a resource pool.

Linda Johnson clears up the mysteries of using VLOOKUP in Excel.

Excel MVP Jon Peltier gives a tutorial about Surface Charts and Contour Charts in Microsoft Excel.

Beth Melton provides further information on this popular issue

Dian Chapman shows you how to create a custom dialog box to insert watermarks, automatically.

Herb Tyson shows you how to make some visual adjustments to Outlook so the change to 2003 is not such a shock.

Learn some graphics for PowerPoint.

David Horowitz shows you how to save time and make your emails look more professional by using Outlook Signatures.

Kim Hedrich continues teaching you how to use clipart by discussing groups and shadows.

Mike Glen encourages you to automate your repetitive work through the use of Macros, by recording the keystrokes and mouse clicks, editing the resulting VBA code and then customizing a toot button to run the macro.

Susan Ramlet, Microsoft Office System MVP, jumps into TechTrax this month as a guest author to provide our readers with a fantastic FAQ (frequently asked question) article all about updating versions of Microsoft Office.

Word power user and MVP, Bill Coan, explains how you, too, can take advantage of the power of Microsoft Word.

Lisa Green, guest author for TechTrax, gives you a pile of great tips for using the VB Editor in Office.

Mark Thorpe continues his Excel VBA lessons showing you how to create a procedure to export data to an HTML file.

Kim teaches you how to add clipart to a Word document. This article also covers word wrap around your clipart object.

Articulate Presenter allows you to create Flash based online rich media from PowerPoint presentations - find out more in this full review by Geetesh Bajaj

Mike Glen continues with the customization theme with renaming columns (fields), value lists and more formulae, concluding with creating a new table with graphical indicators (stop light or traffic lights).

In this article, Mark Thorpe shows you how to use event handlers in VBA Excel to create exciting colorful artwork in Excel. No experience necessary.

Greg Chapman shows some easy methods to ease your design time VB debugging work.

Jon Peltier provides a hands-on description of Excel's number formats, to help you customize the appearance of worksheets and charts.

Learn how to save time and work more efficiently by setting Rules in Outlook. Dian Chapman shows you how it works.

Learn how to handle storyboards.

Kim Hedrich teaches you how to add watermarks to a Word document, both on a single page and on every page. It includes instructions for Word 2000 and Word 2002.

Linda Johnson shows you how to use Excel's financial functions and Insert Function feature to create detailed formulas for predicting loan payments and investment payoffs.

In this article, Mark Thorpe walks through creating a simple Excel VBA project from scratch. From the VBA Editor, create a new form, add controls to the form, write code and add a button to the spreadsheet itself to up the form. No experience necessary.

Jon Peltier gives us the recipe for creating expert pie charts in Excel.

Dian Chapman shows you how to zip through document styling...by bypassing the Task Pane.

Mike Glen makes a start with custom fields (in Project 98+) their customization (in Project 2000+) with formulae and their application to the Gantt Chart.

Geetesh Bajaj shows you how to create cool images by putting photos or designs in PowerPoint's AutoShapes.

Linda Johnson shows you how to use the Summary feature in Excel.

Mike Glen covers the basics of Project costs with currency setting and the setting up of resources’ costs using standard rates, cost profiles and cost rates. He also covers overtime, material and fixed costs.

Mark Thorpe takes you into Lesson 4 of his Excel VBA series.

News bytes.

This month, TechTrax turns 2 years old! In celebration, we're giving away some goodies from our authors. Don't miss this opportunity to enter these drawings!

Bill Coan offers up his renowed DataPrompter in our Anniversary drawing.

Linda Johnson offers up her Office Tutorial CD for our Anniversary drawing. Don't miss a chance to enter this drawing.

Geetesh Bajaj offers his Nirvana slide set of PowerPoint backgrounds for our Anniversary Drawing. Be sure to enter your name to try to win this beautiful set.

Vic Ferri is offering up his PPT conversion service to a lucky winner, which makes presentations secure and simple to use. Be sure to enter this drawing!

Dian Chapman gives away two of her popular Word Autoforms and Beginning VBA video course CDs in celebration of TechTrax's second anniversary. Don't miss your chance to try to win!

Geetesh Bajaj shows you how to create your own presentation playlist.

David Horowitz shows you how easy it is to program in a code to Outlook to remind you to add those attachments.

Jon Peltier shows you how to create Gantt charts in Excel to help you better manage your projects.

Linda Johnson shows you how to tame how Excel prints your pages.

Kim Hedrich shows you how much fun Word's WordArt can be.

Mike Glen teaches you how to handle working patterns in MS Project.

Mark Thorpe continues teaching your Excel VBA in this third lesson in his series.

The next lesson in this terrific Excel VBA series.

Geetesh Bajaj shows you how to add narration to your PowerPoint presentations.

Kim Hedrich discusses adding text to shapes in her part 5 discussion of autoshapes.

Ray Blake shows you how to create custom reports in Access.

Mike Glen continues his Project lessons in this article that covers tasks types.

Beth Melton teaches you how to control Microsoft Office's Task Pane.

Beth Melton explains what happened to the Office Shortcut Bar and ways around the problem.

Kevin Christy explains how to create a quoting system in Excel.

Find out how to use the new photo features associated with Office.

Jon Peltier gives you a terrific source for details about charting types you can create in Excel.

Create an HTML newsletter and email it using Publisher.

Lesson 10 in a series teaching you how to use Microsoft Project

Start learning Excel VBA with this terrific series.

Ray Blake shows you how to save your searches and save time reusing your code.

Lesson 3 in this series explaining how to create a quoting system in Excel.

Learn how to write VBA code that will write VBA code. Great for customizing your programs!

Learn how to use the more powerful animation feature in PowerPoint.

Learn how to properly wrap text around graphic images in Word

Learn what you need to consider when create a book or manual in Word

Learn how to troubleshoot one of the most common problems in Word.

Geetesh Baja gives you tips about handling photos within PowerPoint.

Learn tricks to help you dazzle up your holiday letter in Word.

Learn how to use a cool photo tool that will help you build special effect into your Power Point presentations.

Learn how to create custom style toolbars to match your custom templates.

Learn how to combine several address field values into a single string and have it placed on the Windows clipboard.

Learn how to create custom dialog boxes in Office apps that change their appearance depending on the data selected.

Find out how easy it is to enhance your presentation with a Break Time slide show.

Lesson 8 in a series teaching you how to use Microsoft Project

Part I of a segmented article teaching you how to create a quoting system in Excel, without programming.

Find out why users are excited about XML in Office.

Learn how to add images to a style toolbar to make styling even faster.

Some great tips to help you make Excel sing and dance.

Lesson 7 in a series teaching you how to use Microsoft Project

Lesson 2 in a series explaining how to use the IF statement in Excel.

See how Word's Compare feature can save you lots of time.

By helping test a new software program, you can get cool, free Word templates.

Learn how to create dynamic charts in Excel.

Learn a trick to creating upside down text in Word.

Learn how to better control characters in Word

Part III in a series teaching you how to use AutoShapes in Word

Tag along with Dian as she goes to New York to attend the Office 2003 launch.

Lean how to deal with Word's Review Toolbar

Learn how to make decision in Excel

Part II in a series teaching you how to use AutoShapes in Word

Lesson 6 in a series teaching you how to use Microsoft Project

Find out how using styles in Word can save your company money!

Learn what improvements have been made to the 2003 version of Publisher when it comes to designing web sites with Publisher.

An incredible wealth of info about Excel and it's charting features!

Learn how to enhance your slide presentations in PowerPoint by adding music.

Kim Hedrich shows teachs you more about Words Autoshapes in this new lesson.

Lesson 5 in this series of Project training lessons.

Create an automated quiz for in Word that will calculate the users score.

Learn how to use Word's Wildcard searches to transform entire documents.

Learn how to add lines and arrows to your Word documents

Learn what type of Excel graph is best to display your data.

See how easy it is to create a web photo album using PowerPoint

Learn how to manage your projects with this series of lesson for Microsoft Project.

David Horowitz shows you how to install digital certificates in your office to avoid annoying macro warning messages.

Read tips regarding how to use File Cataloger to create yourself a support or code library.

Another great, free utility from Greg Chapman. This one allows you to print your directory structure.

Learn how to link documents together in Word using field codes.

Three things you probably thought you couldn't do in Word.

Lesson 3 in a series learning how to manage projects with Microsoft Project.

The beginning of series teaching you how to use the drawing features in Office.

Learn how to clean up your data to better normalize it.

Part 4: Getting printer driver details

Learn how to create your own RedefineStyle shortcut and how to better customize Change Case text formatting in Word.

Lesson two in a series of MS Project tutorials.

Get this great utility to allow you to backup your system with a simple Word template.

A great list of 10 of the top PowerPoint resource sites.

A fun and useful macro utility to colorize words in your Word documents, and great programming details for programmers!

Learn how to control page numbering within a Word document with fields.

A very useful utility to get a reading on all your optional settings in Word.

Learn how to handle all the alternatives for sharing macros, so you can decide the best way for your staff.

Learn how to manage section in Microsoft Word

Find out how to make Word XP more closely resemble Word 2000

An intro to a series of article on project management

Learn about many addins for extending PowerPoint and adding options to your presentations.

Get code that allows you to print a list of all your programs.

Learn how to apply special formatting to Excel cells.

This macro will make the job of creating a table of contents in a long doc, easier.

Everything you always wanted to know about Normal.dot, but were afraid to ask!

Find out how easy it can be to make fun, customized, photo labels for the holidays!

Manage your email by using an automatic reply when you're unavailable.

Learn how to save time with Paste Special and also how to create a macro to do the job for you.

Lean how to properly create a Word outline, so you can easily turn it into a PowerPoint presentation.

Part 3 in a series explaining how to use VBA to handle printer code in Word.

Download a copy of this Word document listing all the Word shortcuts.

More details regarding Word security and addins/patches to help make the risk less.

Discussion regarding using Flash SWF files within PowerPoint

Lesson two in a series of VBA instructions explaining how to control a printer using Word VBA and API code.

Become familar with Office XP's new Task Pane feature.

Learn how to adjust the default zoom percentage by writing a little VBA code.

Learn the proper way to format your documents in Word to ensure they turn out the way you want them to look.

Get a free utility to fix a potential security problem with Word.

Learn the details of how Norton's Office Plug-in can cause application conflicts.

Find out what presentation color most people prefer and enter your vote.

Learn how to use VBA to control printer access from Word

Learn what Array Formulas are and how to use them.

Find out the meaning behind the "merge changes" message request in your Word 2002 documents.

Learn where to find lots of useful info about Office

Lesson II in a series explaining databases.

Learn how to create a neat calendar that you can easily updated for all those school appointments.

Learn how to use an image to represent a macro button field.

Get the inside facts about some of PPT new features and how to modify them.

Learn how to use Word's Letter Wizard to create professional looking letters.

Lesson I in a series of database training.

Learn how to use a field and a little VBA code to add instant envelope printing to your letter template.

Ever want to pull emails out of your email program and convert them to regular files. Learn how to do it!

Learn how to set alarmed reminders in Outlook

Learn how to create individual PST files so you can sort and organize your email into smaller files.

Learn how to adjust the tab order in Word's AutoForm using VBA.

See just how easy it is to filter out just the data you need to see.

Discover the various ways to export out the image(s) you need.

See how easy it is to make Word work the way you want.

Learn how to control Excel's numbering format

Learn how to set up links within Outlook so you can access web pages and your hard drive from within Outlook.

Protect Your Inbox from E-Mail-borne Viruses

Learn five tricks that will help you save time using Word.

Learn how to use VBA to code a macro that will allow you to save Word docs with sequentially-numbered file names.

A collections of tips for using Excel, Microsoft spreadsheet application.

Information about links to provide template and assistance to use Office application for home purchasing.

Learn how to use Paste Special in Microsoft Office apps to save yourself time and aggrevation.

Learn how to create custom dialog boxes in Word using VBA.

Ways to use Office XP to create shower invites, party planning and photo albums.

Understand the different way to save a document in Word.