Accellis Training Courses

 

 

 

 

 

 

 

 

Microsoft Excel 2007 for Law Firms

Microsoft Excel is a powerful program that is often underutilized.  This course covers what you need to know about working with and formatting Workbooks, inserting Graphics and Charts, using legal Functions, uncovering Metadata, and much more.

Dates:  Check back soon for our 2010 schedule or call (216) 662-3200!
Location: Accellis Technology Group – Training Center
5350 Transportation Blvd. Suite 1

Cleveland, OH 44125

Cost: $295 per person

$195 for each additional person from the same firm

Course Agenda
Introduction
Working with Workbooks
  • Navigating within a Worksheet - Cells, Rows, and Columns
  • Entering and Editing Data – Text and Numbers
  • Entering and Auditing Formulas
  • Understanding References
  • Copying and Moving Data
  • Find and Replace
  • Spell Check
  • Customizing Toolbars and Menus
  • Sample Legal Workbooks
  • Working with Multiple Worksheets
  • Naming, Rearranging Worksheets
  • Protecting a Workbook
  • Linking Sheets in the same and different Workbooks
Formulas and Functions
  • Basic Formulas useful to the Legal Industry
Formatting Workbooks
  • Changing Row Height and Column Width
  • Changing Alignment
  • Using Merge and Center
  • Hiding Columns, Rows, and Gridlines
  • Applying Style Formats
  • Applying borders and Shading
  • Working with Number, Date, and Time Formats
  • Using Auto Format
  • Using Conditional Formats
Printing Worksheets
  • Selecting What to Print
  • Specifying a Print Range
  • Previewing
  • Page Options – Margins, Header and Footers, Sheet Options
  • Printer Properties
Excel Graphics and Charts
  • Using Excel’s Chart Wizard
  • Changing Charts you Just Created
  • Saving and Printing Charts
  • Formatting and Clearing Chart Objects
  • Inserting Graphics in Your Worksheets and Charts
Metadata and Security
  • Metadata Overview
  • Microsoft Excel Metadata
  • Uncovering Metadata
  • Options for Minimizing Metadata
  • Workbook Security