Tip of the Month:  ARCHIVES

 2008

Requires Adobe Acrobat Reader 2008 printer friendly version will be available in December.

  • January – Microsoft Word 2007:  Use the new Alignment Tab feature to align text with margins
  • February – Microsoft Excel 2007:  Show percentages with a little color
  • March – Microsoft PowerPoint 2007:  Guides, where are my Guides???
  • April – Microsoft Access 2007:  Hidden Menu in the Navigation Pane
  • May – Microsoft Word 2007:  Remove Extra Space between Paragraphs
  • June – Microsoft PowerPoint 2007:  Setting Your Default Theme in PowerPoint
  • July – Adobe InDesign CS3: The calculating nature of InDesign
  • August – Microsoft PowerPoint 2007:   Status Bar View Switching
  • September –
  • October –
  • November –
  • December –

 2007

Requires Adobe Acrobat Reader 2007 printer friendly

  • January – Microsoft Word: Create a shortcut to your favorite font
  • February – Microsoft Excel: Compute an average that excludes zero values
  • March – Microsoft PowerPoint: Change Your PowerPoint Presentations View
  • April – Microsoft Access: Keyboard Shortcuts to Navigate Design View of Forms
  • May – Microsoft Word: Changing the default Date field format
  • June – Microsoft Access: Use three properties to make data entry easier in Access
  • July – Microsoft Excel: Get the lowdown on the CONCATENATE function vs. the ampersand (&)
  • August – Microsoft PowerPoint: Presenter's view for slide shows
  • September – Microsoft Word: Jump from a hyperlink destination to the hyperlink itself
  • October – Microsoft Access: Calculate the percentage of records in a group
  • November – Microsoft Excel: Enter the same value in several cells at once
  • December – Adobe InDesign: Create Boilerplate Text with Autocorrect

 2006

Requires Adobe Acrobat Reader 2006 printer friendly

  • January – Microsoft Access: Create an AutoLookup query to fill in a form
  • February – Microsoft Excel: Force your workbook to save before closing (VBA)
  • March – Microsoft PowerPoint: Prevent placeholders from automatically resizing
  • April – Microsoft Word: Strip all hyperlinks in a document
  • May – Microsoft Windows: Add fields to the Details view
  • June – Microsoft Access: Quickly copy data to new records
  • July – Microsoft Excel: Making vertical entries horizontal, or horizontal entries vertical
  • August – Microsoft PowerPoint: Create a Photo Album
  • September – Microsoft Word: Compare Documents Side By Side
  • October – Microsoft Access: Custom AutoFormats for your Reports
  • November – Microsoft Excel: Copy worksheet data into a chart sheet
  • December – Adobe InDesign: Export an item without the entire page coming along for the ride

 2005

Requires Adobe Acrobat Reader 2005 printer friendly

  • January – Microsoft Access:  Change the Starting Value of an AutoNumber Field
  • February – Microsoft Excel: Create a Fixed Decimal Point
  • March – Microsoft PowerPoint:  Using the Grid and Guides
  • April – Microsoft Word:  Create Multiple Versions
  • May – Lotus Notes r6:  Color Code Incoming Mail Messages
  • June – Microsoft Access:  Organize Objects in the Database Window
  • July – Microsoft Excel:  Create a Custom List
  • August – Microsoft PowerPoint:  Record Action Items and Meeting Minutes
  • September – Microsoft Word:  Compare and Merge Documents
  • October – Microsoft Access:  Stop Empty Reports
  • November – Microsoft Excel:  Subtotals
  • December – Lotus Notes:  Add University Holidays

 2004

Requires Adobe Acrobat Reader 2004 printer friendly

  • January – Microsoft Excel XP: Recolor Worksheet Tabs
  • February – Microsoft Word: Use the Document Map
  • March – Microsoft PowerPoint:  Save a Slide as a Picture
  • April – Microsoft Access: Maximize a Form when it is opened
  • May – Microsoft Word:  Navigate a Table Using the Keyboard
  • June – Lotus Notes:  Send a Special Message
  • July – Microsoft Excel:  Parse Text in a Column
  • August – Microsoft Word:  Spike It!
  • September – Microsoft Access:  Use the Ampersand (&) in a Label
  • October – Microsoft PowerPoint:  Duplicate Duplicate
  • November – Lotus Notes:  Use Notes Minder
  • December – Microsoft Excel:  Change the Formatting of Cells Containing Formulas

 2003

Requires Adobe Acrobat Reader 2003 printer friendly

  • January – Microsoft Excel: Resize a Column
  • February – Lotus Notes: Create a Link Hotspot in Mail Messages
  • March – Microsoft Excel: Shortcuts
  • April – Microsoft Access: Select Multiple Objects on a Form or Report
  • May – Microsoft Word: Change the column width in a table
  • June – Microsoft PowerPoint: Use Action Buttons and Settings
  • July – Lotus Notes: Insert (not attach) a picture
  • August – Microsoft Excel: Freeze Headings When Scrolling
  • September – Microsoft Access: Combine Text Values From Multiple Fields on a Form or Report
  • October – Microsoft Word: Retain repeating table headings when controlling page breaks
  • November – Microsoft PowerPoint: Create a Summary Slide
  • December – Microsoft Windows: Using the Recycle Bin

 2002

Requires Adobe Acrobat Reader 2002 printer friendly

  • April – Microsoft Excel: Fit your spreadsheet to a page
  • May – Microsoft Word: Turn off automatic bullets and numbering
  • June – Lotus Notes: Use rules to filter messages
  • July – Microsoft PowerPoint 2000: Create scrolling credits in your presentation
  • August – Microsoft Access: Limit the buttons on your taskbar
  • September – Microsoft: Drag-and-drop to move or copy
  • October – Microsoft Word: Table tricks
  • November – Microsoft Excel: Print the worksheet formulas
  • December – Microsoft PowerPoint: Create a custom show