(9:30 a.m. - 12:30 p.m and 2:00 p.m - 5:00 p.m.)

 

• Formatting Tricks
  • Quickly Modifying The Normal Style
  • Selecting Text with similar formatting
  • Copying Formatting From One Section to Another
  • Replacing One Style with Another
  • Applying Formatting From The Keyboard
  • Converting Uppercase Words to Another Case
  • Ensuring Consistent Document Dormatting
• Document Tricks
  • Showing More Items On The Recent Documents List
  • Clear The Recent Documents List
  • Locking Document Formatting
  • Viewing Two Documents Side By Side
• Page Layout Tricks
  • Creating A Custom Watermark
  • Displaying Text With Line Numbers
  • Making The First Page Header And Footer Unique
• Working And Worksheet Tricks
  • Applying Text Or Formatting To Multiple Worksheets
  • Keeping Track Of Worksheet Changes
  • Sharing A Workbook With Other Users
  • Preventing Users From Changing Parts Of A Worksheet
  • Transposing Range Rows And Columns
• Data Analysis Tricks
  • Determining The Break-Even Point
  • Highlighting Cells Above Or Below A Certain Value
  • Highlighting Values Below The Median
  • Analysing Cell Values With Data Bars
• Chart Tricks
  • Plotting The Average On The Value Axis
  • Stacking A Picture As A Bar Chart Data Marker
  • Displaying A Second Vertical Axis
  • Charting Small Values With A Bar Of Pie Chart
  • Plotting A Best-Fit Trend line
  • Plotting Forecasted Values
• Slide And Presentation Tricks
  • Converting A Word Outline Into A PowerPoint Presentation
  • Creating Custom Bullets
  • Replacing Fonts-Throughout A Presentation
  • Recoloring A Picture To Match Your Presentation
  • Creating A Custom Slide Layout
  • Using Multiple Slide Masters
• Animation Tricks
  • Making Bullets Display Individually
  • Animating An Organization Chart
  • Emphasizing The Current Bullet Point
• Slide Show Tricks
  • Adding Narration To A Slide Show
  • Setting Up An Automatic Slide Show
  • Controlling A Slide Show From The Keyboard