Basic
1.0 Creating a Basic Worksheet
1.1 Explore the User Interface and the Ribbon
1.2 Customize the Quick Access Toolbar
1.3 Navigate and Select in Excel
1.4 Enter Data and Save a Workbook
1.5 Lab: Customize the Quick Access Toolbar
1.6 Lab: Using the Help Feature
2.0 Performing Calculations
2.1 Create Basic Formulas
2.2 Calculate with Functions
2.3 Copy Formulas and Functions
2.4 Lab: Creating Basic Formulas
2.5 Lab: Calculate with Functions
2.6 Lab: Copy Formulas and Functions
3.0 Modifying a Worksheet
3.1 Manipulate Data
3.2 Working with Cells, Columns, and Rows
3.3 Search for Data in a Worksheet
3.4 Spell Check a Worksheet
3.5 Lab: Working with Cells, Columns, and Rows
3.6 Lab: Search for Data in a Worksheet
3.7 Lab: Spell Check a Worksheet
4.0 Formatting a Worksheet
4.1 Modify Fonts
4.2 Add Borders and Color to Cells
4.3 Change Column Width and Row Height
4.4 Apply Number Formats
4.5 Using Styles
4.6 Lab: Modifying Fonts
4.7 Lab: Adding Borders and Color to Cells
4.8 Lab: Apply Number Formats
5.0 Printing Workbook Contents
5.1 Print Workbook Contents Using Default Print Options
5.2 Setting Page Breaks
5.3 Lab: Printing Workbook Contents
6.0 Managing Large Workbooks
6.1 Format Worksheet Tabs
6.2 Manage Worksheets in a Workbook
6.3 Manage the View of Large Worksheets
Basic
1.0 Getting Started with Microsoft Outlook 2007
1.1 Getting Started with Microsoft Outlook
2.0 Email Basics
2.1 Setting up an Email Account
2.2 Working with Email Messages
Lab 2.1 Working with Email Messages
3.0 Creating and Sending Simple Email Messages
3.1 Using Spell Check
3.2 Properly Addressing Email Messages
3.3 Formatting Email Messages
3.4 Attaching Files to Messages
3.5 Forwarding and Replying to Email Messages
3.6 Printing and Deleting Messages
Lab 3.1 Using Spell Check
Lab 3.2 Attaching Files to Messages
Lab 3.3 Printing and Deleting Messages
4.0 Managing Your Emails
4.1 Setting Message Options
4.2 Handling Junk Mail
4.3 Moving and Copying Messages to Folders
4.4 Searching Folders
4.5 Deleting Folders
4.6 Opening and Saving Attachments
4.7 Flagging Messages
Lab 4.1 Searching Folders
Lab 4.2 Opening and Saving Attachments
Lab 4.3 Flagging Messages
5.0 Contact Management
5.1 Using Outlook for Managing Contacts
5.2 Editing Outlook Contacts
5.3 Navigating the Address Book
5.4 Using Distribution Lists
5.5 Deleting Contacts
5.6 Using Electronic Business Cards
5.7 Creating New Messages with the Address Book
Lab 5.1 Editing Outlook Contacts
Lab 5.2 Using Distribution Lists
6.0 Working with Tasks
6.1 Using the Outlook Task List
6.2 Editing and Updating Tasks
Lab 6.1 Using the Outlook Task List
7.0 Working with Appointments and Events
7.1 Exploring the Outlook Calendar
7.2 Creating Appointments
7.3 Adding Categories to Outlook Items
7.4 Editing a Calendar Item
Lab 7.1 Flagging Messages
8.0 Working with Meeting Requests and Responses
8.1 Working with Meetings in Outlook
8.2 Managing Meeting Responses
9.0 Working with Notes
9.1 Using Notes in Outlook
Lab 9.1 Using Notes in Outlook
Basic
1.0 The PowerPoint Environment
1.1 Exploring the PowerPoint Environment
1.2 Customizing Quick Access Toolbar
Lab 1.1 Exploring Powerpoint Environment
2.0 How to Navigate Presentations
2.1 Navigation Steps in PowerPoint
2.2 Different Presentation Views
2.3 Rearranging and Deleting Slides
Lab 2.1 Navigation Steps in Powerpoint
3.0 Creating and Formatting Slides
3.1 Working with Themes
3.2 Adding Slides to Your Presentations
3.3 Entering and Modifying Text
3.4 Formatting Paragraphs in a Slide
Lab 3.1 Working With Themes
4.0 Adding Graphics and Drawing Objects to Your Presentations
4.1 Inserting Pictures
4.2 Inserting ClipART
4.3 Creating and Modifying Shapes
4.4 Inserting WordART
Lab 4.1 Inserting Pictures
5.0 Modifying Objects
5.1 How to Change an Object's Orientation
5.2 Grouping and Ungrouping Objects
5.3 Arranging Your Objects
Lab 5.1 Grouping and Ungrouping Objects
6.0 Adding Tables and Charts
6.1 How to Create Tables
6.2 Formatting Tables
6.3 How to Insert Tables from Microsoft Word
6.4 How to Add a Chart
6.5 Modifying Charts
6.6 Working with Diagrams
Lab 6.1 How to Create Tables
Lab 6.2 Formatting Tables
7.0 Modifying Presentations
7.1 Working with Slide Masters
7.2 Setting up Slide Shows
7.3 Adding Transitions
7.4 Adding Animation Effects
7.5 How to Package Your Presentations
Lab 7.1 Setting up Slide Shows
8.0 Proofing and Delivering Presentations
8.1 Working with Spell Check
8.2 How to Print Your Presentations
Lab 8.1 Working with Spell Check
Lab 8.2 How to Print your Presentations
Basic
1.0 Getting Started with Word 2007
1.1 Exploring the Word Window
1.2 Exploring the User Interface
1.3 Exploring the Ribbon
1.4 Document Navigation
1.5 Selection Techniques
1.6 Viewing Documents
Lab 1.1 Exploring User Interface
2.0 Creating a Word Document
2.1 Entering, Navigating, Selecting Text
2.2 Working with Blocks of Text
2.3 Searching for and Replacing Text
2.4 How to Save Your Document
2.5 How to Preview and Print Your Document
Lab 2.1 Search and Replace
Lab 2.2 Preview and Print
3.0 Formatting the Contents of a Document
3.1 Text Formatting
3.2 Copy Formatting
3.3 Find and Replace Formatting
3.4 Automatic Formatting
3.5 Paragraph Spacing and Indents
3.6 Setting Tabs and Aligning Text
3.7 Paragraph Alignment and Page Breaks
3.8 Adding Borders and Shading to Paragraphs
3.9 Applying Styles
3.10 Creating Lists
Lab 3.1 Automatic Formatting
Lab 3.2 Applying Styles
4.0 Page Layout
4.1 Modifying the Orientation
4.2 Page Borders and Colors
4.3 Adding Headers and Footers
4.4 Modifying Content from Print Preview
Lab 4.1 Modifying Orientation
Lab 4.2 Adding Headers and Footers
5.0 Proofing and Printing your Word Documents
5.1 Spelling and Grammar
5.2 Using AutoCorrect and Word Count
6.0 Graphics
6.1 Adding and Using Graphics
6.2 Adding Symbols and Special characters
6.3 Watermarks
Lab 6.1 Adding and Using Graphics
Lab 6.2 Watermarks
7.0 Tables
7.1 How to Create a Table and Enter Data
7.2 How to Change the Table Structure
7.3 Formatting the Table
7.4 Converting Text to Table
Lab 7.1 Converting Text to Table
Basic
1.0 Exploring Access 2007
1.1 Opening Access 2007
1.2 Getting Started with Access 2007
1.3 Using a Database Template
1.4 Overview of the User Interface
1.5 Navigating in the Database
2.0 Building a Database
2.1 Create a New Database
2.2 Creating a Table
2.3 Managing Tables
2.4 Overview Table Relationships
Lab 1
3.0 Managing Data in a Table
3.1 Add Table Data
3.2 Modify Table Data
3.3 Sort Records
3.4 Filter Records
Lab 2
4.0 Working with Queries
4.1 Create a Query
4.2 Add Criteria to a Query
4.3 Sorting a Query Using Multiple Fields
4.4 Using AND and OR Operators
Lab 3
5.0 Design Forms
5.1 Creating a Form
5.2 View Data Using an Access Form
5.3 Create a Form Using the Form Wizard
5.4 Modify the Design of a Form
5.5 Format the Controls in a Form
Lab 4
6.0 Generating Reports
6.1 View an Access Report
6.2 Creating a Report
6.3 Create a Report Using the Report Wizard
6.4 Apply an AutoFormat to a Report
6.5 Prepare a Report for Print
Lab 5
Intermediate
1.0 Calculating Data with Advanced Formulas
1.1 Manage Cell and Range Names
1.2 Calculating Data Across Worksheets
1.3 Analyzing Data with Logical and Lookup Functions
Lab 1.1 Managing Cell and Range Names
2.0 Organizing Worksheet and Table Data
2.1 Creating and Modifying Tables
2.2 Formatting Tables
2.3 Sorting or Filtering Worksheet or Table Data
2.4 Calculating Data in a Table or Worksheet
Lab 2.1 Formatting Tables
3.0 Presenting Data Using Charts
3.1 How to Create a Chart
3.2 Modifying Charts
3.3 Formatting Charts
Lab 3.1 How to Create a Chart
Lab 3.2 Modifying Charts
Lab 3.3 Formatting Charts
4.0 Analyzing Data Using PivotTables and PivotCharts
4.1 Creating a PivotTable Report
4.2 Analyzing and Modifying a PivotTable
5.0 Inserting Graphic Objects
5.1 Inserting and Modifying Pictures and ClipArt
5.2 Drawing and Modifying Shapes
Lab 5.1 Inserting and Modifying Pictures and ClipArt
6.0 Customizing and Enhancing Workbooks and the Excel Environment
6.1 How to Customize the Excel Environment
6.2 Customizing Workbooks
6.3 Managing Themes
6.4 How to Create and Use Templates
Lab 6.1 How to Customize the Excel Environment
Lab 6.2 How to Create and Use Templates
Intermediate
1.0 Customizing MS Outlook 2007
1.1 Exploring Outlook's Environment
1.2 Working with Groups and Shortcuts
1.3 Using the Address Book
1.4 Setting Options in the Calendar
1.5 Setting up Work Days and Times
1.6 Showing Additional Time Zones
1.7 Setting up Availability Options
Lab 1.1 Setting Options in the Calendar
Lab 1.2 Showing Additional Time Zones
2.0 Customizing Messages
2.1 Customizing Message Appearance
2.2 Setting up Message Signatures
2.3 Modifying Additional Message Options
2.4 Sending Messages with Voting Options
2.5 Setting up an Out of Office Message
2.6 Creating Mailing Groups
Lab 2.1 Setting up Message Signatures
3.0 Organization
3.1 Using Instant and Advanced Search
3.2 Sorting Messages and Customizing Views
3.3 Organizing Messages
3.4 Categorizing Outlook Items
3.5 Working with Personal Folders
3.6 Setting Rules in Outlook
3.7 Working with Junk Email
3.8 Using Public Folders
3.9 Working in Offline Mode
3.10 Working with Shared Calendars
Lab 3.1 Organizing Messages
Lab 3.2 Setting Rules in Outlook
4.0 Using the Journal
4.1 Recording Journal Entries Automatically
4.2 Recording Journal Entries Manually
4.3 Setting Journal Options
Lab 4.1 Recording Journal Entries Manually
5.0 Managing Tasks
5.1 Working with Tasks
Lab 5.1 Working with Tasks
6.0 Customizing Outlook's Environment
6.1 Customizing Outlook's Toolbar
6.2 Creating New Custom Menus
6.3 Customizing the Quick Access Toolbar
6.4 Creating a Folder Home Page
Lab 6.1 Customizing the Quick Access Toolbar
Intermediate
1.0 Working with Styles
1.1 Creating Text Styles
1.2 Modifying Styles
1.3 Renumbering Lists
1.4 Sorting Lists
1.5 Customizing and Structuring Lists
Lab 1.1 Creating Text Styles
Lab 1.2 Sorting Lists
2.0 Sections and Columns
2.1 How to Create and Format a Section
2.2 Controlling the Appearance of Characters
2.3 Adding Headers and Footers
Lab 2.1 How to Create and Format a Section
3.0 Formatting Tables
3.1 Positioning the Text in a Cell
3.2 Adding Borders and Shading
3.3 Sorting Table Data
3.4 Performing Calculations in a Table
Lab 3.1 Positioning Text in a Cell
Lab 3.2 Adding Borders and Shading
4.0 Printing Labels and Envelopes
4.1 Printing Labels and Envelopes
5.0 Templates and Building Blocks
5.1 Introduction to Templates
5.2 Creating a Template
5.3 How to Apply a Theme
5.4 What are QuickParts
5.5 Modifying QuickParts
Lab 5.1 Introduction to Templates
Lab 5.2 Creating a Template
Lab 5.3 What are Quick Parts
6.0 Graphics
6.1 Working with Diagrams
6.2 Customizing SmartART
6.3 Drawing Tools in MS Word
6.4 Displaying Text as a Graphic
7.0 Document Revision Management
7.1 Tracking Changes in a Document
7.2 Adding, Editing, and Viewing Comments
Lab 7.1 Adding Editing and Viewing Comments
8.0 Web Features of MS Word
8.1 Saving a Document as a Web Page
8.2 Adding Hyperlinks
Lab 8.1 Saving a Document as a Web Page
Intermediate
1.0 Working with Field Properties
1.1 Add a Primary Key to a Table
1.2 Insert, Delete, and Reorder Fields
1.3 Change a Field's Data Type
1.4 Change the Field Size
1.5 Adding a Caption
1.6 Create a List of Values for a Field
Lab 1
2.0 Creating Relational Databases
2.1 Understanding Table Relationships
2.2 Creating Relationships Between Tables
2.3 Enforcing Referential Integrity
2.4 Printing and Deleting Table Relationships
2.5 Overview Relationship Types
Lab 2
3.0 More on Queries
3.1 Create Query Joins
3.2 Relate Data Within a Table
3.3 Set Query Properties
3.4 Create a Calculated Field
Lab 3
4.0 Enhancing Forms
4.1 Design a Form Layout
4.2 Improve the Appearance of a Form
4.3 Add a Command Button to a Form
4.4 Create a Subform
Lab 4
5.0 Customizing Reports
5.1 Organize Report Information
5.2 Format the Report
5.3 Set Report Control Properties
5.4 Control Report Pagination
5.5 Summarize Report Information
Lab 5
6.0 Integrate Data With Other Applications
6.1 Import Data into Access
6.2 Export Data
6.3 Analyze Access Data in Excel
6.4 Export Data to a Text File
6.5 Merge Access Data with a Word Document
Lab 6
Advanced
1.0 Streamlining Workflow
1.1 Creating Macros
1.2 Adding Macros to the Quick Access Toolbar
1.3 Editing a Macro
1.4 Using Conditional Formatting
1.5 Applying Data Validation to a Worksheet
1.6 Updating Workbook Properties
1.7 Modifying Excel Options
2.0 Collaborating with Others
2.1 Protecting Files and Sharing Workbooks
2.2 Merging Multiple Workbooks
2.3 Adjusting Macro Settings
2.4 Restricting Document Access
3.0 Auditing Worksheets
3.1 Tracing Cell Precedents and Dependents
3.2 Troubleshooting Errors in Formulas
3.3 Watching and Evaluating Formulas
3.4 Creating a Data List Outline
4.0 Analyzing Data
4.1 Adding a Trend Line to Charts
4.2 Create Scenarios and Performing What-If Analysis
5.0 Working with Multiple Workbooks
5.1 Create a Workspace
5.2 Consolidate Data
5.3 Managing Linked Cells in Different Workbooks
6.0 Importing and Exporting Data
6.1 Exporting Excel Data
6.2 Importing a Table from Word
6.3 Importing a Delimited Text File
Advanced
1.0 Working with Mailbox
1.1 Creating and Managing DataFiles
1.2 Using Stationary and Themes
1.3 Encrypting Your Messages
2.0 Organizing Outlook Items
2.1 Grouping Outlook Items
2.2 Creating Search Folders
2.3 Moving Mail Between Folders
2.4 Applying Conditional Formatting
3.0 Overview of the Notes and Journal
3.1 Using the Notes Folder
3.2 Exploring the Journal Folder
4.0 Calendar and Contacts
4.1 Examining the Calendar
4.2 Contacts Folder Overview
4.3 Working with Electronic Business Cards
4.4 Sending Electronic Business Cards
4.5 Adding an Electronic Business Card as a Signature
4.6 Exporting Contacts
4.7 Linking Specific Items to Contact
5.0 Outlook's Collaboration Features
5.1 Sharing Outlook Components
5.2 Using RSS Feeds
6.0 Templates and Forms
6.1 Working with Templates
6.2 Working with Forms
7.0 Saving and Archiving Emails
7.1 Saving Messages in Various Formats
7.2 Archiving Messages
7.3 Protecting Personal Folders
8.0 How to Work Offline and Remotely
8.1 Creating Offline Folder Files
8.2 Using RPC over HTTP
9.0 Synchronizing with Outlook
9.1 Categorizing Contact Name in MS Outlook
9.2 Synchronizing with MS Outlook
Advanced
1.0 Customizing Presentations
1.1 Custom Themes
1.2 Custom Templates
1.3 Customizing Your Save Options
1.4 Customizing Bullets
Lab 1.1 Custom Themes
2.0 Working with Graphics and Multimedia Content
2.1 Enhancing Pictures
2.2 Adding Media Clips
2.3 Adding Photo Albums and Looping
Lab 2.1 Enhancing Pictures
Lab 2.2 Adding Photo Albums and Looping
Lab 2.3 Adding Photo Albums and Looping
3.0 Working with Action Buttons and Customizing Your Slide Shows
3.1 Interactive Elements
3.2 Customizing Slide Shows
3.3 Annotating Your Presentation
Lab 3.1 Interactive Elements
Lab 3.2 Interactive Elements
Lab 3.3 Customizing Slide Shows
4.0 Finalizing the Presentation
4.1 Adding comments
4.2 How to Publish to Web
Lab 4.1 Adding Comments
Lab 4.2 Adding Comments
Lab 4.3 How to Publish to Web
5.0 Integration with Other Microsoft Office programs
5.1 How to Hyperlink Other Files
Advanced
1.0 Mail Merge
1.1 Creating a Mail Merge
1.2 Creating Labels
2.0 Forms
2.1 Adding Form Fields
3.0 Sharing and Securing Your Documents
3.1 Updating the Properties of a Document
3.2 Hiding Text
3.3 Modifying User Information
3.4 Removing Personal Information
3.5 Setting Restrictions on Formatting and Editing
3.6 Adding Digital Signatures
3.7 Setting Password Protection
3.8 Creating and Merging Multiple Versions
4.0 Macros
4.1 Recording and Running Macros
4.2 Modifying and Deleting Macros
5.0 Toolbar and Keyboard Customization
5.1 Customize the Quick Access Toolbar
5.2 Customizing Keyboard Layout
6.0 Working with Long Documents
6.1 Inserting Blank and Cover Pages
6.2 Adding Tables of Contents
6.3 Inserting Footnotes and Endnotes
6.4 Adding Captions
7.0 XML Features
7.1 Working with XML in Word
8.0 Using Word 2007 with Other Programs
8.1 How to Link to an Excel 2007 Worksheet
Advanced
1.0 Database Management
1.1 Compact and Repair a Database
1.2 Backing up Your Database
1.3 Editing Database Properties
2.0 Writing Advanced Queries
2.1 Create Unmatched and Duplicate Queries
2.2 Group and Summarize Records Using Criteria
2.3 Summarize Data Using a Crosstab Query
2.4 Create a PivotTable and a PivotChart
3.0 Simplifying Tasks with Macros
3.1 Create a Macro
3.2 Attach a Macro
3.3 Restrict Records Using a Condition
3.4 Validate Data Using a Macro
3.5 Automate Data Entry Using a Macro
4.0 Making Effective Use of Forms
4.1 Display a Calendar on a Form
4.2 Organize Information with Tab Pages
5.0 Making Reports More Effective
5.1 Include a Chart in a Report
5.2 Print Data in Columns
5.3 Cancel Printing of a Blank Report
5.4 Create a Report Snapshot
6.0 Maintaining an Access Database
6.1 Link Tables to External Data Sources
6.2 Determine Object Dependencies
6.3 Document a Database
6.4 Analyze the Performance of a Database
| 