Computer Class Agendas

MICROSOFT EXCEL

BASIC

• Excel Window Properties
• Creating a New Workbook
• Creating New Worksheets
• Selecting Cells
• Working with Data
• Basic Formatting
• Basic Sorting
• Basic Mathematical Operations
• The AutoSum Feature

INTERMEDIATE: DATA PROCESSING

• Advanced Formatting
• Inserting Comments
• The Freeze Panes Option
• Solving Bizarre Excel Printing Problems
• Formulas
• Relative and Absolute References
• Linking Cells, Worksheets and Workbooks

ADVANCED: DATA MANIPULATION

• The Autofil Function
• The Paste Special Function
• Multiple-Level Sorting
• Subtotaling Sorted Data Sets
• Filtering Data
• Conditional Formatting
• Charts
• Sparklines

MICROSOFT POWERPOINT

• PowerPoint Window Properties
• Inserting and Using Different Types of Slides
• Adding Images, Shapes, Tables, and Hyperlinks to Slides
• Different PowerPoint Views
• Applying & Creating Design Themes
• Slide Transitions
• Animating Objects within a Slide
• Adding Sound to Your Presentation
• Your Presentation in Action
• Printing Options

MICROSOFT WORD

CREATING A LEGAL RESEARCH PAPER

• Setting Default Fonts and Line Spacing
• Lists, Indentations, Tabs, and the Ruler
• Inserting Page Numbers
• Inserting Headers and Footers
• Inserting Different Types of Page Numbers on Different Pages
• Footnotes and Endnotes
• Creating a Table of Contents
• Creating a Table of Authorities

WHAT'S NEW & HOW TO CUSTOMIZE IT

• The Ribbon
• A New Graphic Interface
• The Backstage View
• Customizing the Quick Access Toolbar
• Word Options - Changing Program Settings and Preferences
• The Help Feature
• Browsing for Files
• The Navigation Pane Within Microsoft Word 2010
• Setting Default Fonts and Line Spacing
• Page Setup Options
• The Status Bar
• Lists, Indentations, Tabs, and the Ruler
• Inserting Watermarks

DOCUMENT TOOLS

• Inserting Page Numbers
• Inserting Headers and Footers
• Inserting Different Types of Page Numbers on Different Pages
• Footnotes and Endnotes
• Inserting Columns
• Inserting Tables
• Reviewing (Red-lining) Documents
• The Mail Merge Function

STYLES, TABLES OF CONTENTS, & TABLES OF AUTHORITIES

• What is a Style?
• Viewing and Applying Styles
• Using Microsoft's Predesigned Style Sets
• Creating New Styles
• Modifying Styles
• Copying Styles to Other Documents
• Deleting Styles
• Creating a Table of Contents
• Creating a Table of Authorities