Microsoft Excel is more than just a number cruncher! It is a tool that easily manipulates any list of data needing prioritizing, filtering, subtotaling and rearranging. This three-hour class demonstrates the key knowledge for using this tool to massage data and print the results OR transfer them to a Microsoft Word document or Outlook e-mail.

Outline:

• The Microsoft Environment (Menus and Toolbars)
• Online Help - The New Owner's Manual
• Workbook Composition (Worksheets, Adding and Renaming)
• Worksheet Composition (Rows, Columns)
• Understanding Cell Contents vs. Cell Display
• Moving Around with the Mouse and Keyboard
• Active Cell vs. Selection(s)
• Fill Down and Copy, Automatic Lists
• Cell Contents - Constants, Formulas, Operators, Addresses, Functions
• Real World Example 1, Simple Calculations, Relative vs. Absolute Addressing
• The Concept of Functions
• Real World Example 2, Sum, Average, Roman and the Function Tool
• Printing Basics and the Concepts of Print Area, Fit-To, and Repeated Rows
• Real World Example 3, Databases
• Database Creation and Data Entry
• Filtering
• Sorting
• Subtotaling
• Instant Reporting through Sum, Sumif, Count and Countif
• Real World Example 4, Running Totals
• Window Split
• Copying and/or Linking Information to Microsoft Word
• Basic Charting Techniques
• Real World Example 6, Plotting Sales by Product and Region

Usually presented in a one-hour session, this seminar is designed for the legal professional who works with legal briefs and wishes to utilize the automatic features available in Word to cite authorities and generate an automatic Table of Authorities.

Outline:

• Creating a Table of Authorities
• Add or Change a Citation Category for a Table of Authorities
• Edit or Format a Table of Authorities Entry
• Delete an Entry from a Table of Authorities
• Update a Table of Authorities
• Change the Appearance of a Table of Authorities
• How Does the Next Citation Feature Work?
• The Long and the Short of It
• Field Codes: TOA (Table of Authorities) Field
• Switches
• Examples

Usually presented in one three-hour session, this course is designed for legal professionals who wish to maximize their production skills and avoid the frustrations of inconsistent formatting, header and footer arrangement, numbering and pleading formatting. The outline is designed to address features in Word that will increase efficiency and make use of tools and methods that are typically underutilized.

Day 1 Outline:

• Menus and Toolbars vs. Keyboard Actions
• The Online Help System and Word’s Equivalent to Reveal Codes
• Keyboard vs. Mouse Movements in Word
• Understanding AutoCorrect, AutoFormat and the Magic of Undo
• Customizing the Grammar and Spelling Checkers
• AutoText, Word's Answer to Macros
• Symbols and Non-breaking Spaces
• Understanding Why WordPerfect Uses Codes and Why Word Does Not
• Formatting in Word, Three Levels: Character, Paragraph, Document
• Understanding Character Formatting
• Using the Format Painter
• Creating a Document from a Template

(Continued from Word Core Concepts I)

Usually presented in one three-hour session, this course is designed for legal professionals who wish to maximize their production skills and avoid the frustrations of inconsistent formatting, header and footer arrangement, numbering and pleading formatting. The outline is designed to address features in Word that will increase efficiency and make use of tools and methods that are typically underutilized.

Day 2 Outline:

• Review of Day 1
• Paragraph Formatting
• Document Formatting and Section Breaks
• Understanding Headers and Footers
• Section Breaks as They Relate to Headers and Footers
• Directly Applied Formatting vs. Styles
• Understanding the Importance of Styles
• Creating and Modifying Styles
• The Advantage of Copying and Pasting When Styles Are Present
• Styles and Their Parent Templates
• The Importance of Linking Numbering to Styles
• Table Basics
• Putting It All Together: A Legal Brief

Usually presented in a one-hour session, this seminar is designed for the legal professional who needs instruction or a refresher in understanding styles and how to troubleshoot difficult or badly formatted documents. Topics include how to update styles, how to track formatting and how to copy from one document to another. Students may bring generic problem documents to the seminar if desired.

Outline:

Formatting Basics

• Selecting Items that Aren't Next to Each Other
• Selecting Text with the Same Formatting
• The Format Painter

Tracking Formatting

• Reapplying Formatting
• Checking How Many Times a Specific Type of Formatting Occurs

Microsoft Word Style Basics

• Applying Styles by Using the Style Gallery
• Creating and Modifying Styles
• Copy Styles to Another Document or Template
• Automatically Update a Paragraph Style
• Display Paragraph Style Names in the Document Window
• Display or Hide the Styles and Formatting Task Pane
• Turn On or Off Automatic Style Defininition

Troublesome Documents

• Troubleshoot Using Styles and Reapplying Formatting
• About Checking the Consistency of Formatting
• Troubleshoot Format Checking