Here are 33 well written PowerPoint 2007 Training Tutorials, hosted by AgileConcepts. These free PowerPoint training materials are in Word (docx), PowerPoint (pptx), and Windows Media (wmv) file formats. They consist of 15 beginning and 18 intermediate tutorials, all of which will give you a great training opportunity for many important PowerPoint features. Some of these include using and working with: backgrounds, themes, importing slides, automatic formatting, templates, picutures, smartart graphics, tables, outlines, animation, presenation layouts, and music and sound. You can also use the search form to help you find what features and tasks you need to learn and use.

15 Beginning PowerPoint 2007 Tutorials:
(wmv) New Features in PowerPoint 2007
(pptx) What’s New in PowerPoint2007: the Ribbon and more
(pptx) Create your Presentation Slides
(docx) Adding Backgrounds to your Slide Presentation
(docx) Adjusting Indents or Tab Stops in Lists
(docx) Applying Themes in PowerPoint
(docx) Change Starting Slide Number in your Presentation
(docx) Importing and Adding Slides from other Presentations
(docx) Using Automatic Formatting as you type in PowerPoint.
(docx) Using Templates to Fomat your Presentations
(pptx) Insert, Crop, and Format Pictures into your Slide Show
(pptx) How to Apply Themes, Insert Pictures, and Arrance Slide Elements
(pptx) Proof, Print, and Prep your Slide Show
(pptx) Tips for Working in the new PowerPoint
(pptx) Working with the New File Format

18 Intermediate PowerPoint 2007 Tutorials:
(docx) Guide to Customizing and Changing the Look of PowerPoint Tables
(docx) How to Import Outlines into your Presentations from Word and other apps
(docx) Adding, Modifying, and Deleting Tables in PowerPoint Slides
(docx) Adding Tables to PowerPoint Slides
(docx) Moving and Resizing PowerPoint Tables
(docx) Using the Format Painter to Copy from one slide to another
(pptx) How to Style, Polish, and Update your Graphics
(docx) Saving and Reusing SmartArt Graphics
(docx) Use Pictures and SmartArt Graphics to your Presentation
(docx) Create and Use SmartArt Graphics
(pptx) Creating SmartArt Graphics: Edit Text and Shapes
(docx) When Should you Use SmartArt Graphics
(pptx) SmartArt Graphic Types
(wmv) Using Animation in your Slides to Gain Attention
(pptx) Build and Customomize your Presentation Layouts
(pptx) How Themes Word and How to Customize them
(pptx) Playing Music from a CD
(pptx) How to Insert and Play Sound Files

Here are 55 great Excel 2007 Training Tutorials, hosted by AgileConcepts. These include 11 Excel 2007 Video Training Modules. These free Excel training materials are in Word (docx), PowerPoint (pptx), and Windows Media (wmv) file formats. Included are18 beginning, 24 intermediate, and 13 advanced tutorials, all of which provide an excellent overview and learning opportunity for mostl of Excel’s important features and tools, from the very beginning to more advanced topics, including charting, pivot tables, formulas, functions, sorting, and filtering. You can also use the search form to help you find what features and tasks you are looking to learn more about.


18 Beginning Excel 2007 Tutorials:
(docx) Display or Hide Chart Gridlines
(docx) Change a Chart Type
(docx) Changing the font face and size in Excel
(wmv) Creating Charts- visualize raw data in an attractive format
(docx) Creating or deleting Formulas
(docx) Define Worksheet Print Area
(docx) Designing effective Cell Styles in Excel 2007
(pptx) Editing Data, Remove Formatting, and Revise Worksheets
(pptx) Entering Text, Number and Date data into Cells
(wmv) Hiding and Unhiding Rows
(pptx) Introduction to Excel, Create a Worksheet and Workbook
(docx) Print and Adjust Gridlines in aWorksheet
(docx) Set Worksheet Page Margins
(docx) Using Automatic Formatting to format text as you type.
(docx) Using Chart Templates
(pptx) What’s new in Excel 2007: Ribbon, New Commands, and other New Features
(docx) Working with Gridlines
(pptx) Worksheet basics: Format data, Create Columns and Footers, and Printing

24 Intermediate Excel 2007 Tutorials:
(pptx) Calculate Dates using Formulas
(docx) Changing Cell Styles in Excel
(docx) Converting Numbers Stored as Text into Actual Numbers.
(docx) Copying Excel Data to PowerPoint
(docx) Copying Excel Data to Word
(docx) Create a Chart in Excel
(docx) Create conditional formulas
(docx) How to Create and Customize Charts
(pptx) Creating Charts – customize charts and use charting tools
(pptx) Customizing Charts – formatting titles and columns
(docx) Filter data in a range or table
(wmv) Freezing and unfreezing Panes of Rows and Columns
(docx) Guidelines and examples for Sorting and Filtering Data by Color and Icons
(pptx) How Excel Handles and Stores Dates
(pptx) Introduction to Excel Formulas, totaling values
(docx) Insert and Modify Page Breaks in Worksheets
(docx) Reapply a Filter and Sort
(pptx) Simplify Formulas by using Functions
(docx) Sort Data in a Range or Table
(docx) Ten Ways to Clean Up Your Data
(pptx) The new Excel file format
(pptx) How to Use Cell References in Formulas
(docx) Using Chart Template to create publication-ready Charts
(docx) Using the Format Painter to copy formatting from one section of worksheet to another

13 Advanced Excel 2007 Tutorials:
(pptx) Calculations in Excel Services
(docx) Combining Text and Numbers in Excel
(docx) Conditional Formatting in Excel
(docx) Excel 2007 Worksheet Functions, by category
(pptx) Excel Services control content that users can see
(pptx) Exporting to a SharePoint site
(docx) Filter by using  Criteria
(pptx) How to create PivotTables, how they work and why they are needed
(docx) Summary of PivotTable Functions
(docx) Summing up ways to Sum up Data in Excel
(wmv) Using Conditional Formatting in reports
(wmv) Using Pivot Tables for analyzing complicated worksheets
(docx) Guide to Using Excel Shortcut and Function Keys

Here are 84 excellent and easy to understand Word 2007 Training Tutorials, hosted by AgileConcepts. These include 12 Word 2007 Video Training Modules. These free Word training materials are in Word (docx), PowerPoint (pptx), and Windows Media (wmv) file formats. There are 37 beginning, 47 intermediate, and 10 advanced tutorials here in total, which provide a great overview, understanding, and training opportunity to learn all of Word’s important features and tools, from the very beginning to more advanced topics. You can also use the search form to help you find what features and tasks you are looking to learn more about.


37 Beginning Word 2007 Tutorials:
(docx) Adjusting page margins
(docx) Apply a style
(wmv) Beginning) Mail Merge
(docx) Change bullet and number formatting
(docx) Changing a style
(docx) Clear text formatting
(docx) Consistent alignment in lists
(docx) Create a Quick Style
(pptx) Creating a document
(docx) Creating a dropped cap
(pptx) Creating simple lists
(docx) Creating tables
(pptx) Editing basics
(pptx) Finding the most popular commands
(docx) Fluent UI Overview
(pptx) Formatting text and applying styles
(pptx) Headers and footers
(wmv) Improve the Look of Your Documents
(docx) Indent paragraphs
(docx) Insert a picture
(docx) Inserting images from cameras and scanners
(wmv) Introduction to Headers and Footers
(wmv) Introduction to Table of Contents
(wmv) Making Labels with Mail Merge
(docx) Missing top margins
(docx) Moving or copying tables
(wmv) New in Word 2007
(docx) Removing page numbers
(docx) Removing page numbers from the first page
(docx) Restarting endnote numbering
(docx) Select page orientation
(docx) Setting tab stops
(docx) Superscript and subscript
(docx) The Microsoft Office Button
(docx) The Ribbon Overview
(docx) Using automatic formatting in Microsoft Word.
(docx) Using Quick Tables

47 Intermediate Word 2007 Tutorials:
(docx) Adding a drawing
(docx) Adding backgrounds or watermarks
(pptx) Adding borders, shading, and styles
(docx) Adding rows and columns to tables
(wmv) Advanced) Table of Contents
(docx) Analyze document readability
(docx) Bulleted or numbered lists
(pptx) Change the appearance of your TOC
(docx) Changing bullet formatting.
(pptx) Creating a table of contents
(pptx) Creating multilevel lists
(pptx) Creating your own templates
(pptx) Custom titles in your TOC
(wmv) Customizing Mailing Labels
(docx) Disabling automatic bullets
(docx) Drawing tables
(docx) Enabling change tracking
(pptx) Find and use document building blocks
(docx) Formatting tables
(docx) Headers and footers
(pptx) Headers and footers for document sections
(pptx) Including outline levels in your TOC
(docx) Insert page numbers
(wmv) Intermediate) Headers and Footers
(pptx) Introducing building blocks
(pptx) Introducing templates
(pptx) Mail merge basics
(docx) Modifying the Quick Styles gallery
(pptx) Perform a complete mail merge
(docx) Picture bullets
(wmv) Printing and Updating Labels
(docx) Quick Styles and shapes
(pptx) Recipient lists
(docx) Restarting endnote numbering
(docx) Reviewing tracked changes
(docx) Scanning with the Clip Organizer
(docx) Styles and Formatting
(pptx) Swap, format, and remove building blocks
(pptx) The new Word file format
(docx) Tracking changes
(docx) Using drawing gridlines
(pptx) Using mail merge from the Ribbon
(docx) Using Quick Style sets
(pptx) Using special text effects
(pptx) Watermarks and backgrounds
(docx) Word 2007 Tabs and Options
(wmv) Working With Old Versions of Word Documents 

16 Advanced Word 2007 Tutorials:
(docx) Adding bullets to SmartArt graphics
(wmv) Advanced) Headers and Footers
(pptx) Advanced mail merge
(docx) Converting footnotes and endnotes
(pptx) Creating a TOC using fields
(docx) Merging comments from multiple reviewers
(docx) Missing headers and footers
(pptx) Tracking changes basics
(pptx) Tracking changes beyond the basics
(pptx) Using multiple TOCs in a document