Microsoft Excel 2007 for the Legal Profession - Part 1

Course Length: 1 day

Objective:Work with Excel workbooks, enter data, format and modify data and create formulas and functions.
Prerequisites:Familiarity with Windows
Introduction to ExcelMoving and Copying Data
Excel screenInserting rows and ranges
The workbook environmentMoving and copying data
Worksheet viewsAbsolute references
New file formatsUsing the Fill Series feature
Saving as PDFAutoFill Options
Entering Data and Navigating a WorksheetFormatting a Worksheet
Navigation and movement techniquesFormatting a worksheet
Entering text and valuesNumber format and text alignment
Creating formulasCopying and pasting formats
Using named ranges in formulasSpecial and custom formats
Using basic functions (Sum, Average, Max, Min)Conditional Formatting
Function AutoCompletePrinting a Worksheet
Using If functionSpell check
Modifying a Workbook Using Print Preview
Working with ranges Printing a large worksheet
Editing cell content Additional print options
   Introduction to the Workbook Environment
   Using the multi-sheet workbook
   Creating a 3-D workbook with linked cells
   Creating an Excel template

Course Inquiry

 Classes Available
Webinar Schedule    Training Services    CLE Classes    Floor Support    Help Desk