Georgetown Law home page Continuing Legal Education A-Z index Directories Search Student Services Admissions & Financial Aid Academic Programs About Georgetown Law Alumni Workshops & Institutes Library Faculty & Administration About this site Site map
Public Computer Class Agendas

ruler

The class agendas listed below pertain to the public computer class schedule that can be found at http://www.law.georgetown.edu/ist/public_classes/class_schedules.htm.

If you have any questions about the classes, please contact Dianne Ferro, Assistant Director of Training, at dhf2@law.georgetown.edu or 202-662-9023.

BASIC MICROSOFT EXCEL 2010

  • New Window Properties
  • Changing Program Settings and Preferences
  • Creating a New Workbook
  • Creating New Worksheets
  • Selecting Cells
  • Working with Data
  • Basic Formatting
  • Basic Sorting
  • Basic Mathematical Operations
  • The AutoSum Feature

INTERMEDIATE MICROSOFT EXCEL 2010

  • Advanced Formatting
  • Inserting Comments
  • The Freeze Panes Option
  • Formulas
  • Relative and Absolute References
  • The Autofil Function
  • Linking Cells, Worksheets and Workbooks
  • Adding Headers and Footers to a Worksheet
  • Solving Bizarre Excel Printing Problems

ADVANCED MICROSOFT EXCEL 2010

  • The Paste Special Function
  • Multiple-Level Sorting
  • Subtotaling Sorted Data Sets
  • Filtering Data
  • Conditional Formatting
  • Charts
  • Sparklines

Revised February 2, 2012 (DHFM)