Microsoft Excel 2003 for the Legal Profession - Part 2

Course Length: 1 day

Objective:Create Excel databases, sort and filter data, import and export data and use the database in a mail merge with Word
Prerequisites:Familiarity with Excel Basics
Creating a Database in ExcelCreating Charts
What is a database?Creating a chart sheet
Why create a database in Excel?Creating an embedded chart
Guidelines for creating a databaseModifying and Formatting Charts
Sorting DataFormatting chart text
Single level sortingFormatting chart data
Multiple level sortingPrinting a chart
Sorting optionsAdding and removing chart items
Design considerationsProtect and Display Options
Working with ListsProtecting and worksheet or workbook
Creating a listUsing comments
Filtering a listMetadata in Excel Workbooks
Custom criteriaDocument properties, track changes, comments
Multiple-condition criteriaOther Excel features to consider when emailing workbook
Managing a filtered list
Using an Excel Database in a Word Mail MergeOverview of Excel's Analysis Tools
Setting up a worksheet to be used as a data source in a mail mergeGoal Seek
Perform Mail Merge with Excel data sourceScenario
Working with ListsPivot
Import a table from Word of WordPerfect
Import a text file
Course RegistrationCourse RateClasses Available
Webinar Schedule    Training Services    CLE Classes    Floor Support    Help Desk