OFF105: Excel Skills For Advocates (Intermediate)

This page offers an overview of the Training Outline, Presenters, Training Materials, Resources, and links to the Recorded Training.

 

August 2008 Training:

Training Materials:

 

Training Outline:

  • What is Excel and Why Use It?
  • Excel Fundamentals
  • Using Worksheets
  • Formatting Worksheets
  • Fill Function
  • Relative versus Absolute References
  • Charts and Graphs
  • Importing and Exporting Data
  • Excel 2003 vs. Excel 2007

 

Presenter: Jeff Narabrook

 

February 2007 Training:

Training Materials:

  • Training Presentation (Download as PowerPoint or PDF)
  • Training Recording (flash) available here.
  • NTAP Cheatsheet: This pdf file gives you a brief printable summary of how to use the tools discussed in the training.

Outline of the Training: This training is geared for an intermediate Excel audience of legal aid advocates and covers:

  • A Review of the Fundamentals
  • Multiple Worksheets
  • Formatting Worksheets
  • Fixing Headers for View and Print
  • Using the Fill Function
  • Relative versus Absolute References
  • Charts and Graphs
  • Mail Merge from Excel Data

Presenter: Gabrielle Hammond

 


AttachmentSize
NTAP’s Intermediate Excel Training_LSNTAPFinal.ppt1.87 MB
NTAP’s Intermediate Excel Training_LSNTAPFInal.pdf1.67 MB
NTAP Microsoft Excel Training Cheatsheet.pdf25.79 KB
OFF105 MS Excel (2008 training powerpoint)5.34 MB
OFF105 MS Excel 2008.pdf (PDF version of the 2008 training)9.09 MB
OFF105_quick_reference.pdf58.98 KB