Lunch & Learn

No-Nonsense Shortcuts for Word, Excel,

& PowerPoint 2003

 

Course Length

One hour

 

Prerequisites

Word, Excel, and/or PowerPoint 2003 Introduction or equivalent experience

 

Course Description

This one-hour demonstration features sixty tips, tools, and timesavers for Excel 2003, Word 2003, and PowerPoint 2003. Participants will view hidden features and shortcuts for editing, formatting, printing, and customizing. The tips and shortcuts included provide a “back door” approach to accomplishing a variety of tasks quickly and efficiently.

 

Course Topics

Selected Excel Tips

  • Automatically fill down a column
  • Move data without replacing
  • Transpose rows and columns
  • Autofit all columns or rows
  • Copy formats multiple times
  • Rotate cell contents
  • Add color to worksheet tabs
  • Create multiple lines in a cell
  • Use the AutoFill shortcut menu
  • Change the AutoCalculate function
  • Use page break preview
  • Create a quick chart on a separate sheet
     

Selected Word Tips

  • Find a synonym

  • Select multiple text blocks

  • Split a window

  • Insert border lines

  • Insert watermarks

  • Insert a custom page border

  • Shrink to fit

  • Select a rectangular block

  • Convert tabbed text to a table

  • Wrap text around a table

  • Create an AutoCorrect entry for a symbol

  • Browse a document by object
     

Selected PowerPointTips

  • Replace fonts throughout a presentation

  • Duplicate an object by dragging

  • Float a drop-down list palette

  • Select an object hidden behind another object

  • Apply an animation scheme

  • Add a comment to a slide

  • Animate a piece of a pie chart

  • Display bars of a chart as a picture

  • Create a summary slide

  • Access slide show help

 

What Participants Receive

Each participant receives a list of the tips demonstrated.

 

 

 

 

[Home   |     Services   |   Courses   |   Instructors  |  References  |  Contact Us]