Microsoft Excel 2007 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 ExcelInserting Charts
What is a database?Inserting a chart
Why create a database in Excel?Working with Chart Design Tools
Guidelines for creating a databaseChanging chart type, layout and design
Sorting DataSwitching rows and columns
Single level sortingWorking with Chart Layout Tools
Multi-level sortingCustomizing chart labels
Sorting optionsInserting shapes and text boxes
Design considerationsInserting a trend line
Working with TablesWorking with Chart Format Tools
Creating a tableShapes and shape styles
Filtering a tableWordArt tools
Custom criteriaProtect and Display Options
Multiple-condition criteriaProtecting a worksheet or workbook
Managing a filtered listUsing comments
Using an Excel Database in a Word Mail MergeMetadata in Excel Workbooks
Setting up a worksheet to be used as a data source in a mail mergeDocument properties, track changes, comments
Perform Mail Merge with Excel data sourceInspecting a document and removing metadata
Data tools 
Text to Columns
Removing duplicates
Course Inquiry Classes Available
Webinar Schedule    Training Services    CLE Classes    Floor Support    Help Desk