new/popular titles: Vista | Office 2007 | Project 2003/2007 | Crystal Reports XI | Visual Basic 2005

Microsoft Office 2007 Suite

Video-Based Training with Instructor Deanna Reynolds

Microsoft Access 2007: Beginner

1.0 Getting Started
1.1 About Relational Databases and Access 2007
1.2 Launching Access 2007
1.3 Touring the Access Environment
1.4 Using the Office Menu
1.5 Database Components
1.6 Using the Navigation Pane
1.7 Getting Help
1.8 Opening and Closing Access Databases
1.9 Creating an Access Database Using a Preloaded Template

2.0 Working with an Existing Table
2.1 Exploring Datasheet View
2.2 Editing and Selecting Table Data
2.3 Adding and Deleting Records
2.4 Find and Replace
2.5 Undo and Redo

3.0 Working with an Existing Form
3.1 Exploring Form View
3.2 Editing and Selecting Form Data
3.3 Adding and Deleting Records
3.4 Find and Replace

4.0 Sorting and Filtering
4.1 Sorting a Table and a Form
4.2 About Filters
4.3 Common Filters
4.4 Filter by Selection
4.5 Filter by Form
4.6 Advanced Filter

5.0 Designing Select Queries
5.1 Using the Query Wizard
5.2 Using Query Design View
5.3 Using Criteria
5.4 Sorting and Showing Query Fields
5.5 Adding Tables to a Query

6.0 Form Basics
6.1 Using the Forms Wizard
6.2 Using the Form Tool
6.3 Working with Form Design View
6.4 Working with Form Layout View
6.5 Working with Form Controls

7.0 Report Basics
7.1 Using the Reports Wizard
7.2 Using the Report Tool
7.3 Working with Report Design View
7.4 Working with Report Layout View
7.5 Working with Report Controls

8.0 Printing Database Objects
8.1 Printing Tables or Queries
8.2 Printing Forms
8.3 Printing Reports

Microsoft Access 2007: Intermediate

1.0 Planning and Designing a Database
1.1 Database Design Process
1.2 Creating a Database Using a Wizard
1.3 Creating a Database from Scratch

2.0 Building and Modifying Tables
2.1 Creating a Table Using a Table Template
2.2 About Data Types
2.3 Creating a Table in Datasheet View
2.4 Creating a Table in Design View
2.5 Using Field Templates
2.6 Setting Primary Keys

3.0 Working with Relationships
3.1 Types of Relationships
3.2 Referential Integrity
3.3 Cascading Updates and Deletes
3.4 Multi-Valued Fields
3.5 Printing Relationships

4.0 Sharing Your Data
4.1 Export Your Access Report to Word
4.2 Export Your Access Table to Excel
4.3 Import Your Excel Spreadsheet into Access
4.4 Copying the Table Structure and Data

5.0 Enhancing Your Forms
5.1 Using the Field List Task Pane
5.2 Using the Forms Controls Group
5.3 Adding and Formatting Labels
5.4 Adding Graphics
5.5 Adding Command Buttons

6.0 Enhancing Your Reports
6.1 Using the Reports Control Group
6.2 Adding Graphic Details
6.3 Working with White Space and Report Width

Microsoft Access 2007: Advanced

1.0 Preventing Data Entry Errors
1.1 Using the Lookup Wizard
1.2 Data Validation
1.3 Working with Combo Boxes
1.4 Working with List Boxes

2.0 Advanced Table Design
2.1 Field Properties
2.2 Using Input Masks
2.3 Using the Datasheet Total Row
2.4 Using Rich Text in the Memo Field

3.0 Advanced Query Design
3.1 Creating a Calculated Field
3.2 Creating a Crosstab Query

4.0 Advanced Form Design
4.1 Split Forms
4.2 Working with the Property Sheet
4.3 Changing Control Tab Order
4.4 Conditional Formatting
4.5 Adding Tab Pages

5.0 Advanced Report Design
5.1 Creating Groups and Total Reports
5.2 Working with Total Fields
5.3 Adding Calculated Controls to a Report

6.0 Managing Databases
6.1 Identify Object Dependencies
6.2 Database Documenter

Microsoft Access 2007: Expert

1.0 Expertly Designed Select Queries
1.1 Single Parameter Queries
1.2 Multiple Parameter Queries
1.3 Query Joins

2.0 Action Queries
2.1 Types of Action Queries
2.2 Update Queries
2.3 Append Queries
2.4 Make Take Queries
2.5 Delete Queries

3.0 Expertly Designed Forms
3.1 Creating a Lookup Field
3.2 Using a Bitmap as a Form Background
3.3 Adding Calculated Controls to a Form

4.0 Expertly Designed Reports
4.1 Setting Section Properties
4.2 Adding Graphics
4.3 Arranging Report Data Into Columns

5.0 Data Access Pages
5.1 Creating a Data Access Page
5.2 Editing a Data Access Page
5.3 Grouping a Data Access Page
5.4 Creating a PivotTable Data Access Page

6.0 Macros
6.1 Create a Macro
6.2 Edit a Macro
6.3 Attach a Macro to a Command Button

7.0 Database Security
7.1 About Database Security
7.2 Using a Database Password
7.3 Creating Users and Groups

Microsoft Excel 2007: Beginner

1.0 Getting Started
1.1 Launching Excel 2007
1.2 Touring the Excel Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Save vs. Save As
1.6 File and Folder Management
1.7 Opening and Closing Files
1.8 Getting Help

2.0 Entering Data
2.1 Navigation and Selection Techniques
2.2 Data Entry Techniques
2.3 AutoFill
2.4 AutoComplete
2.5 Undo and Redo
2.6 Exiting Excel

3.0 Changing Worksheet Layout
3.1 Inserting Rows, Columns and Cells
3.2 Deleting Rows, Columns and Cells
3.3 Adjusting Column Widths and Row Heights
3.4 Hiding Columns and Rows
3.5 Moving and Copying Data
3.6 Create, Modify and Delete Named Ranges
3.7 Go To, Find and Replace

4.0 Entering Formulas
4.1 Anatomy of a Formula
4.2 Using the Formula Tab
4.3 AutoSum
4.4 Basic Functions
4.5 Copying Formulas

5.0 Formatting
5.1 Using the Home Tab
5.2 Using the Quick Format Mini Toolbar
5.3 Number Formats
5.4 Format as a Table
5.5 Merging and Splitting Cells
5.6 Applying Worksheet Backgrounds

6.0 Using Themes and Styles
6.1 Applying Themes
6.2 Creating Custom Themes
6.3 Applying Styles
6.4 Creating Custom Styles

7.0 Printing
7.1 Using the Page Layout Tab
7.2 Changing Margins and Page Orientation
7.3 Exploring Worksheet Views
7.4 Adding Headers and Footers
7.5 Adding Print Titles and a Print Area
7.6 Viewing and Setting Page Breaks
7.7 Printing

8.0 Charts
8.1 Using the Insert Tab
8.2 Creating a Chart
8.3 Using the Chart Contextual Tabs
8.4 Creating a Chart Sheet
8.5 Adding and Removing Chart Data
8.6 Format and Resize Charts

Microsoft Excel 2007: Intermediate

1.0 Managing Workbooks
1.1 Creating New Workbooks from a Template
1.2 Rename and Move Workbook Tabs
1.3 Insert and Delete Worksheets
1.4 Copy and Paste Worksheets
1.5 Using the View Tab
1.6 Splitting Your Worksheet View
1.7 Freezing and Unfreezing Your View

2.0 Tables and Data Management
2.1 Table Guidelines
2.2 Using the Data Tab
2.3 Sorting
2.4 Grouping and Outlining Data
2.5 AutoFilter
2.6 Advanced Filter Using Single Criteria
2.7 Advanced Filter Using Multiple Criteria
2.8 Automatic Subtotals

3.0 Using Cell References
3.1 Using Relative Cell References
3.2 Using Absolute Cell References
3.3 Using Mixed Cell References

4.0 Auditing
4.1 About Auditing
4.2 Tracing Precedents
4.3 Tracing Dependents
4.4 Tracing Errors

5.0 Creating Web Pages from Workbooks
5.1 Publishing a Web Page
5.2 Viewing Your Published Web Page

6.0 Using Excel with Other Applications
6.1 Importing Data to Excel
6.2 Exporting Data from Excel
6.3 About XML

7.0 Customizing Excel
7.1 Customizing the Quick Access Toolbar
7.2 Modifying Excel Options

8.0 Using Scenarios and Watching Cells
8.1 Creating and Displaying Scenarios
8.2 Editing and Removing Scenarios
8.3 Summarizing Scenarios
8.4 Using the Watch Window

9.0 PivotTables and PivotCharts
9.1 About PivotTables and PivotCharts
9.2 Creating a PivotTable
9.3 Modifying a PivotTable
9.4 Creating a PivotChart
9.5 Modifying a PivotChart

Microsoft Excel 2007: Advanced

1.0 Collaborating
1.2 Inserting and Deleting Comments
1.3 Viewing and Printing Comments
1.4 Protecting Workbooks, Worksheets and Cells
1.5 Enabling Workbook Security
1.6 Sharing Workbooks

2.0 Advanced Formulas and Functions
2.1 IF Functions
2.2 Nested IF Functions
2.3 Using the VLOOKUP Function
2.4 Using the HLOOKUP Function
2.5 Using the DSUM Function

3.0 Data Consolidation
3.1 About Data Consolidation
3.2 Three Dimensional Formulas
3.3 Data Consolidation by Position
3.4 Data Consolidation by Category

4.0 SmartArt
4.1 About SmartArt
4.2 Creating a List
4.3 Creating a Hierarchy
4.4 Creating a Pyramid
4.5 Editing SmartArt

5.0 Track Revisions
5.1 Tracking Changes
5.2 Accepting and Rejecting Changes

6.0 Data Validation and Conditional Formatting
6.1 Working with Data Validation Rules
6.2 Set Conditional Formatting
6.3 Use Expressions in Conditional Formatting

7.0 Creating Templates
7.1 Using Excel Pre-Defined Templates
7.2 Creating and Modifying a Template

8.0 Macros
8.1 Create a Macro
8.2 Run a Macro
8.3 Edit a Macro

Microsoft Outlook 2007: Beginner

1.0 Getting Started
1.1 Launching Outlook 2007
1.2 Touring the Outlook Window
1.3 Using the Navigation Pane
1.4 Exploring the To-Do Bar

2.0 Reading & Sending E-mail
2.1 Creating & Sending an E-mail Message
2.2 Using the Message Tab
2.3 Using the Address Book
2.4 Saving a Message as a Draft
2.5 Adding an Attachment to an E-mail Message
2.6 Reading Messages
2.7 Viewing Attachments

3.0 Replying to & Forwarding Messages
3.1 Reply vs. Reply to All
3.2 Forwarding a Message
3.3 Understanding Message Icons in Your Inbox

4.0 Formatting Messages
4.1 Using the Format Text Tab
4.2 Using the Quick Format Mini Toolbar
4.3 Marking Message Importance
4.4 Working with Styles
4.5 Using the Zoom Feature
4.6 Using Find & Replace

5.0 Working with E-mail Addresses
5.1 Adding & Editing a Contact
5.2 Using the Contact Tab
5.3 Adding a Contact from an E-mail Message
5.4 Sending a Message from Contact View
5.5 Creating & Using Distribution Lists
5.6 Exporting E-mail Addresses
5.7 Importing E-mail Addresses

6.0 Managing Mail
6.1 Deleting Messages
6.2 Emptying Your Deleted Items Folder
6.3 Using Folders to Manage Your E-mail
6.5 Move & Copy Messages to a Folder
6.5 Renaming a Folder

7.0 Printing E-mail Messages
7.1 Using the Print Dialog Box
7.2 Printing in Table vs. Memo Style
7.3 Printing Attachments

Microsoft Outlook 2007: Intermediate

1.0 Using the Calendar
1.1 Creating an Appointment
1.2 Using the Appointment Tab
1.3 Creating a Recurring Appointment
1.4 Editing an Appointment
1.5 Setting Appointment Reminder Options
1.6 Working with Calendar View Options
1.7 Printing Your Calendar

2.0 Planning Meetings & Appointments
2.1 Creating & Sending a Meeting Request
2.2 Using the Meeting Tab
2.3 Responding to a Meeting Request
2.4 Updating a Meeting Request
2.5 Searching for Appointments

3.0 Advanced Contact Options
3.1 Viewing Contacts
3.2 Searching for Contacts
3.4 Sorting Contacts
3.4 Forwarding Contacts
3.5 Printing Contacts

4.0 Using Tasks
4.1 Creating a Task
4.2 Using the Task Tab
4.3 Editing, Sorting & Viewing Tasks
4.4 Creating a Recurring Task
4.5 Creating a Task Request
4.6 Responding to a Task Request
4.7 Marking a Task as Complete

5.0 Using Notes
5.1 Creating Notes
5.2 Editing, Viewing & Sorting Notes
5.3 Formatting Notes

6.0 Advanced Mail Message Options
6.1 Using Spell Check
6.2 Creating & Editing Signatures
6.3 Using Stationery

7.0 Working with Themes
7.1 Using Themes
7.2 Creating Custom Themes

Microsoft Outlook 2007: Advanced

1.0 Filtering, Finding & Flagging Messages
1.1 Filtering Messages
1.2 Finding Messages
1.3 Flagging Messages
1.4 Completing & Clearing a Flag

2.0 Archiving Outlook Data
2.1 About Archiving Data
2.2 Enabling & Disabling AutoArchive
2.3 Running the Manual Archive

3.0 Personal File Folders
3.1 About Personal File Folders
3.2 Creating a Personal File Folder
3.3 Moving & Copying Messages

4.0 Using the Journal
4.1 Creating a Journal Entry
4.2 Creating Automatic Journal Entries
4.3 Editing a Journal Entry

5.0 Organizing Your Outlook Items
5.1 Creating Rules
5.2 Editing & Deleting Rules
5.3 Using Conditional Formatting
5.4 Grouping Items

6.0 Custom Forms
6.1 Creating a Custom Form
6.2 Using a Custom Form

7.0 Working with Pictures and Shapes
7.1 Using the Insert Tab
7.2 Inserting ClipArt & Pictures
7.3 Drawing AutoShapes
7.4 Using the Format Tabs
7.5 Resizing Objects
7.6 Layering Objects

8.0 Working with WordArt & SmartArt
8.1 Inserting a WordArt Object
8.2 Editing a WordArt Object
8.3 About SmartArt
8.4 Creating a List
8.5 Creating a Hierarchy
8.6 Creating a Pyramid
8.7 Editing SmartArt

9.0 Customizing Outlook
9.1 Working with the Quick Access Toolbar
9.2 Working with Outlook Options
9.3 Customizing Toolbars

Microsoft PowerPoint 2007: Beginner

1.0 Getting Started
1.1 Launching PowerPoint 2007
1.2 Touring the PowerPoint Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Getting Help
1.6 Opening & Closing Files

2.0 Creating a New Presentation
2.1 Creating a New Presentation from a Template
2.2 Creating a New Presentation from Scratch
2.3 Using the Home Tab
2.4 Adding & Editing Text
2.5 Undo, Redo & Repeat
2.6 Save vs. Save As
2.7 File & Folder Manageme
t 2.8 Exiting PowerPoint

3.0 Viewing Presentations
3.1 Navigating Through a Presentation
3.2 Presentation Views
3.3 Using Slide Show View

4.0 Modifying an Existing Presentation
4.1 Slide Basics
4.2 Choosing a Design Theme
4.3 Working with Text Boxes
4.4 Formatting Text
4.5 Using Bullets & Numbering
4.6 Working with Indents & Line Spacing
4.7 AutoCorrect

5.0 Preparing a Presentation for Delivery
5.1 Using Spell Check
5.2 Using the Thesaurus & Research Panes
5.3 Working with Speaker Notes
5.4 Adding a Header & Footer
5.5 Printing Presentations and Handouts

Microsoft PowerPoint 2007: Intermediate

1.0 Outlines
1.1 Adding & Editing Slides in Outline View
1.2 Formatting Slide Text in Outline View
1.3 Exporting a PowerPoint Outline

2.0 Working with Pictures and Shapes
2.1 Using the Insert Tab
2.2 Inserting ClipArt & Pictures
2.3 Working with AutoShapes
2.4 Using the Format Tabs
2.5 Grouping & Ungrouping Objects
2.6 Layering Objects

3.0 Working with Presentation Colors
3.1 Using the Design Tab
3.2 Applying Themes
3.3 Creating Custom Themes

4.0 Working with Animation
4.1 Using the Animations Tab
4.2 Adding Entrance & Exit Animation
4.3 Adding Emphasis
4.4 Using Motion Paths
4.5 Assigning the Order of Animation Effects

5.0 Organizing & Enhancing Your Presentation
5.1 Duplicating & Deleting Slides
5.2 Hiding Slides
5.3 Rearranging Slides
5.4 Adding Slide Transitions

6.0 Managing Presentations
6.1 Inserting Slides from Other Presentations
6.2 Using Find & Replace

7.0 Customizing PowerPoint
7.1 Customizing the Quick Access Toolbar
7.2 Modifying PowerPoint Options

Microsoft PowerPoint 2007: Advanced

1.0 Working with Tables
1.1 Adding a Table to a Slide
1.2 Using Table Contextual Tabs
1.3 Navigating & Selecting in a Table
1.4 Inserting & Deleting Columns and Rows
1.5 Formatting a Table
1.6 Inserting a h3. Microsoft Excel Table

2.0 Working with Charts
2.1 Creating a Chart
2.2 Using the Chart Tab
2.3 Adding & Removing Chart Data
2.4 Formatting & Resizing Charts

3.0 WordArt & SmartArt
3.1 Insert a WordArt Object
3.2 Editing a WordArt Object
3.3 About SmartArt
3.4 Creating a List
3.5 Creating a Hierarchy
3.6 Creating a Pyramid
3.8 Editing SmartArt

4.0 Working with Templates, Masters & Custom Layouts
4.1 Creating and Editing a Custom Template
4.2 Working with Masters
4.3 Working with Custom Layouts

5.0 Saving Presentations for the Web
5.1 Adding a Hyperlink to a Slide
5.2 Publishing a Presentation to the Web

6.0 Collaboration
6.1 Using the Review Tab
6.2 Inserting, Viewing & Editing Comments

7.0 Advanced Presentation Delivery Options
7.1 Working with Action Buttons
7.2 Annotating a Presentation
7.3 Using Slide Timings
7.4 Slide Show Options

Microsoft Word 2007: Beginner

1.0 Getting Started
1.1 Launching Word 2007
1.2 Touring the Word Window
1.3 Using the Office Menu
1.4 Using the Quick Access Toolbar
1.5 Getting Help

2.0 Creating New Documents
2.1 Starting a New Document
2.2 Editing Text
2.3 Saving Your Work
2.4 Preview & Print a Document
2.5 Using a Template
2.6 Exiting Word

3.0 Editing Existing Documents
3.1 Opening a Document
3.2 Navigating a Document
3.3 Working with Multiple Page Documents

4.0 Essential Word 2007 Skills
4.1 Selecting Text
4.2 Moving & Copying Text
4.3 Clipboard Task Pane
4.4 Undo, Redo & Repeat
4.5 AutoCorrect

5.0 Formatting Text & Paragraphs
5.1 Using the Home Tab
5.2 Using the Quick Format Mini Toolbar
5.3 Working with Text Formatting
5.4 Working with Line & Paragraph Spacing
5.5 Using Format Painter
5.6 Adding Symbols & Special Characters

6.0 Proofing Tools
6.1 Spelling & Grammar
6.2 Using the Thesaurus & Other Research Options
6.3 Checking Character & Word Count
6.4 Working with the Custom Dictionary
6.5 Editing in Print Preview

7.0 Changing Your Page Appearance
7.1 Using the Page Layout Tab
7.2 Changing Margins & Page Orientation
7.3 Working with Page Breaks
7.4 Adding Line Numbers

Microsoft Word 2007: Intermediate

1.0 Managing Documents
1.1 Document Views
1.2 Using the View Tab
1.3 Working with Multiple Documents
1.4 Saving Your Word Document as a Web Page

2.0 Additional Editing Tools
2.1 Go To, Find & Replace
2.2 Format Painter
2.3 AutoCorrect

3.0 Paragraph Formatting
3.1 Bullets & Numbering
3.2 Tabs & Indents
3.3 Borders & Shading
3.4 Using Styles

4.0 Introduction to Graphics
4.1 Inserting ClipArt & Pictures
4.2 Inserting Watermarks
4.3 Using the Format Tabs
4.4 AutoShapes
4.5 Editing Images
4.6 Using Captions
4.7 Working with Text Boxes
4.8 WordArt

5.0 Document Formatting
5.1 Section Breaks
5.2 Headers & Footers
5.3 Page Backgrounds & Page Borders
5.4 Drop Caps
5.5 Columns

6.0 Tables
6.1 Creating Tables
6.2 Using Table Contextual Tabs
6.3 Navigating & Selecting in a Table
6.4 Inserting & Deleting Columns and Rows
6.5 Sorting
6.6 Formatting Tables
6.7 Performing Calculations in a Table
6.8 Converting a Table to Text

7.0 Customizing Word
7.1 Customizing the Quick Access Toolbar
7.2 Customizing Word Options

Microsoft Word 2007: Advanced

1.0 Working with Document Templates
1.1 Creating & Editing a Template
1.2 Creating Forms
1.3 Protect & Restrict Forms & Documents

2.0 Mail Merge
2.1 The Mail Merge Process
2.2 Using the Mailing Tab
2.3 Working with a Data Source
2.4 Creating Form Letters
2.5 Creating Envelopes
2.6 Creating Labels

3.0 Macros
3.1 Creating a Macro
3.2 Running a Macro
3.3 Editing a Macro

4.0 Working with Themes
4.1 Using Themes
4.2 Creating Custom Themes

5.0 SmartArt
5.1 About SmartArt
5.2 Creating a List
5.3 Creating a Hierarchy
5.4 Creating a Pyramid
5.5 Editing SmartArt

6.0 Long or Complex Documents
6.1 Using the References Tab
6.2 Bookmarks
6.3 Footnotes & Endnotes
6.4 Table of Contents & Index
6.5 Table of Figures & Table of Authorities

7.0 Collaborating
7.1 Using the Review Tab
7.2 Using Track Changes
7.3 Inserting Comments
7.4 Compare & Combine Document Versions
7.5 Ways to Secure a Document
7.6 Attaching Digital Signatures

8.0 Using Word with Other Programs
8.1 Linking vs. Embedding
8.2 Word & Excel
8.3 Word & PowerPoint
8.4 Word & Outlook

9.0 Using XML
9.1 Overview of XML
9.2 Saving as XML