IST Home Page

IST Fac/Staff Page

IST Student Page

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)