Excel Essentials

• Starting Excel
• Identifying Parts of the Screen
• Using Selection Techniques
• Selecting a Range of Cells
• Selecting Nonadjacent Cells and Ranges
• Selecting an Entire Worksheet
• Entering Data
• Entering Text Data into a Cell
• Entering Values
• Entering Data into a Range
• Quickly Adjusting a Column Width
• Finishing a Workbook
• Saving a Named Workbook
• Printing a Worksheet
• Closing a Workbook and Exiting from Excel

Formatting Text & Printing a Document

• Opening a Workbook
• Creating a New Workbook
• Opening a Recently Used Workbook
• Creating Simple Formulas
• Creating a Formula by Pointing
• Using Functions
• Using the AutoSum Button
• Using the Formula Palette
• Editing Data on the Worksheet
• Editing the Data in a Cell
• Editing a Formula
• Clearing the Contents from a Cell or Range
• Using Undo and Redo

• Creating and Using Named Ranges
• Automatically Naming Ranges
• Navigating with Named Ranges
• Using Range Names in Formulas
• Pasting a List of Named Ranges
• Deleting and Editing Range Names
• Creating Named Constants
• Copying Data with AutoFill
• Creating a Series with AutoFill
• Creating Simple formulae
• Using paste functions
• Defining Relative, Mixed, and Absolute References
• Copying Formulas

Formatting the Worksheet

• Moving and Copying Data
• Copying Data
• Changing the Appearance of Data
• Changing Row Height
• Applying Fonts
• Adding Enhancements
• Aligning Data in Cells
• Merging and Centering Cells
• Rotating and Indenting Text
• Adding Borders and Shading
• Using Drawing Tools
• Creating Graphic Objects
• Editing a Graphic Object
• Creating and Editing 3-D Objects

Functions

• Using Basic Functions
• Lookup Functions
• If Function
• Nested functions
• And/Or Functions

Advanced Functions

• Creating and Using Functions
• Using Built-in Functions
• Working with Arguments: The PMT Function
• Using Dates and Times
• Using Dates in Calculations
• Using Nested Functions
• Auditing Worksheets
• Identifying the Auditing Commands
• The Watch Window
• The Formula Evaluator
• Tracing and Correcting Worksheet Errors

• Using Comments in a Worksheet
• Reviewing, Showing, and Hiding Comments
• Deleting a Comment
• Working with Styles
• Applying a Style
• Redefining and Modifying Existing Styles
• Using Format Painter
• Applying an AutoFormat
• Applying a Conditional Format

What -If

• Pivot Tables
• What is a Scenario?
• What-If-Analysis
• Using Goal Seek
• Using Solver

Using Multiple Sheets and Workbooks

• Using Multiple Worksheets
• Inserting New Worksheets
• Renaming Worksheets
• Deleting Worksheets
• Creating Multiple Views
• Freezing Panes
• Viewing and Arranging Multiple Worksheet Windows
• Navigating in Multiple Workbooks
• Selecting and Viewing Multiple Workbooks
• Creating and Opening a Workspace
• Managing Multiple Worksheets and Workbooks
• Selecting Multiple Worksheets
• Moving and Copying Data between Worksheets
• Linking Data Between Worksheets
• Creating a 3-D Formula

Charting

• Using Charts
• Creating a Chart
• Specifying the Chart Source Data
• Selecting Chart Options
• Selecting a Chart Location
• Managing Chart Objects
• Moving and Resizing Chart Objects
• Deleting Chart Objects
• Adding Data Series’ and Objects to a Chart
• Enhancing the Chart
• Changing the Chart Type
• Formatting Chart Objects
• Adding Text to a Chart
• Printing Charts

Formatting Text & Printing a Document

• Enhancing Text
• Applying Text Formatting Effects
• Removing Text Formatting
• Using Undo and Redo
• Using the Repeat Command to Apply Formatting
• Viewing and Copying Formatting
• Using Format Painter
• Using Bullets and Numbers
• Applying Bullets and Numbers as You Type

Formatting Documents

• Formatting Paragraphs
• Changing Line or Paragraph Spacing
• Indenting Paragraphs
• Setting Tabs Using the Tabs Dialog Box
• Setting Tabs Using the Ruler
• Formatting Pages and Sections
• Setting Margins
• Inserting Page Numbers
• Inserting and Deleting Section Breaks
• Using the Go To Command
• Applying Page Setup Formatting to Sections
• Changing a Section’s Page Numbering
• Using Headers and Footers

• Getting Started with PowerPoint 2003
• Starting PowerPoint
• Opening an Existing Presentation
• Identifying Elements of the PowerPoint Window
• Moving Between Slides
• Using PowerPoint Help
• Using the Office Assistant
• Using the Help Topics Index
• Using What’s This?
• Changing PowerPoint Views
• Changing the Zoom Level
• Viewing the Presentation in Outline View
• Viewing the Presentation in Slide Sorter View
• Ending a PowerPoint Session
• Closing a Presentation

Creating a Presentation

• The Task Pane and Panels
• Beginning a New Presentation
• Using the AutoContent Wizard to Begin a New Presentation
• Using a Template to Begin a New Presentation   
• Adding Text and Slides
• Adding a New Slide in Normal View
• Entering Text in a Bulleted List
• Adding Slides and Text in Outline View
• Using AutoCorrect       
• Using the Undo and Redo Commands
• Using Find and Replace
• Deleting Slides

• Working with Organization Charts
• Update an Organization Chart
• Applying a Chart Layout
• Create a Diagram
• Draw a Flowchart

Adding Special Effects

• Add Sound and Movies
• Add Animation
• Emphasize Objects
• Set a Motion Path
• Set the Order of Effects