Microsoft Office 2007 Training

Microsoft Office 2007 Training
The new Microsoft Office package is changing the old interface with new features on an interface now known as the Ribbon. How do you find the commands you already know? What new commands are available in Word, Excel, Outlook, PowerPoint, and Access? Take a look at the changes in Office 2007 and learn how to make the most of them.
Audience:
This online training series is for anyone who wants to be able to locate both old and new commands in the Microsoft Office 2007 applications: Word, Excel, PowerPoint, Access, and Outlook.
Features:
  • Flash and audio provide animated, interactive Lesson Introductions, Activities, and Simulations.
  • Audio accompanies each lesson page throughout the course.
  • Show Me Hows allow learners to access instructional demonstrations from all courses in the series.
  • Simulations teach learners to perform specific tasks in applications through guided, multi-step exercises.
  • Activities allow learners to apply course concepts in an interactive questioning environment.
  • Full-page images allow learners to experience an application as if it were open on their computer.
  • Exercises allow learners to practice in the actual application being studied.
  • A Course Topics list contains active hyperlinks, permitting quick access to specific topics.
  • Find-A-Word allows learners to look up an unfamiliar term in the Glossary, on the Web, or in a dictionary. In addition, it lets them find other occurrences of the term in the same course.
  • Search text enables learners to rapidly search all text within a course to easily retrieve information required.
  • Courses challenge the learner with a variety of question formats, including multi-step simulations, true/false, multiple choice, and fill-in-the-blank.
  • A skill assessment generates a customized learning path based on the results of a pre-test.
  • A glossary provides a reference for definitions of unfamiliar terms.
  • Bookmarking tracks the learner's progress in a course.
Click on the titles below to show/hide included course information if the tooltips go out of view.


This course provides information on the basic features of PowerPoint 2007: becoming familiar with the Ribbon interface, opening and closing presentations, changing views, searching for help, and saving and printing slides and other presentation elements.

Summary:

This course shows you how to input data to an Excel spreadsheet.

Objectives:

  • Input text, values, and formulas
  • Edit data
  • Use the speech and handwriting recognition features
  • Use AutoCorrect, AutoFill, and AutoSum
  • Retrieve backup files following a system crash

Topics:

  • Data entry
  • Text and values
  • Fixed decimal places
  • Dates and formulas
  • Complex formulas
  • Editing cells
  • Speech recognition
  • Dictation and voice command
  • Handwriting and AutoComplete
  • Using AutoFill
  • Special symbols and shortcuts
  • Using functions
  • Using AutoSum
  • Saving your worksheet

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides the user with information on editing and printing worksheets in Excel 2003.

Objectives:

  • Find and open a workbook
  • Edit a workbook
  • Find and correct errors
  • Prepare a workbook for printing
  • Print a workbook

Topics:

  • Opening workbooks
  • Finding files
  • Using the Search task pane
  • Undo and redo
  • Editing with drag and drop
  • Copying formulas
  • Cut, copy, and paste
  • Deleting and inserting cells
  • Correcting errors
  • Print preview
  • Selecting print options
  • Page setup
  • Headers and footers
  • Setting sheet options
  • Controlling page breaks and formulas

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides information about formatting the cells and tables of your Excel worksheets.

Objectives:

  • Use AutoFormat
  • Apply different number formats
  • Change the size of rows and columns
  • Change fonts and font sizes
  • Modify the alignment of cell entries
  • Add borders, shading, and colors to cells

Topics:

  • Selecting cells
  • Using AutoFormat
  • Moving toolbars
  • Using the Format Cells dialog box
  • Dates and special numbers
  • Calibrating columns
  • Changing fonts
  • Altering the alignment
  • Altering cell appearances
  • Patterns and format painter

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the use of the Excel 2003 interface and new product features.

Objectives:

  • Identify the parts of the Excel interface
  • Start and exit Excel
  • Use menus to execute commands
  • Move around the workbook window
  • Search for help topics

Topics:

  • What is Excel
  • Cells and worksheets
  • Opening Excel
  • Toolbars
  • The Formula bar and worksheet window
  • The Status bar, task panes, and scrolling
  • Moving in the worksheet
  • Using menus
  • Shortcut menus and dialog boxes
  • Getting help
  • Online help and exiting Excel

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides information about the Web functions available in Excel.

Objectives:

  • Add hyperlinks to Excel worksheets
  • Follow and edit hyperlinks
  • Save static and interactive Web pages in Excel
  • Edit Web pages
  • Send Excel workbooks in e-mail

Topics:

  • Adding hyperlinks to a workbook
  • Following hyperlinks
  • Editing hyperlinks
  • Saving a static Web page
  • Interactive Web pages
  • Interactive databases and charts
  • Editing Web pages
  • Saving and sending worksheets
  • Top ten features
  • Top ten beginner basics
  • Ten commandments of Excel 2003

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course shows users how to view and manage information in a worksheet.

Objectives:

  • View information in a worksheet
  • Insert comments
  • Use Find and Replace
  • Protect a worksheet
  • Manage multiple worksheets
  • Create a summary worksheet

Topics:

  • Viewing worksheets
  • Headings
  • Comments
  • Assigning names
  • Find and replace
  • Researching and calculating
  • Protecting your work
  • Maintaining multiple worksheets
  • Editing multiple worksheets
  • Naming and arranging sheets
  • Manipulating worksheet windows
  • Comparing and copying worksheets
  • Summary worksheets

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course teaches the user how to add charts and graphics to worksheets, and how to create and manage databases using Excel 2003.

Objectives:

  • Create charts using Chart Wizard
  • Insert clip art into a worksheet
  • Create your own graphics
  • Create a database
  • Manage a database

Topics:

  • Using the Chart Wizard
  • Editing charts
  • Changing the chart options
  • Adding images
  • WordArt and organizational charts
  • Grouping and hiding images
  • Creating a database
  • Adding e-mail and Web addresses
  • Viewing and finding records
  • Sorting records
  • Using AutoFilter
  • Custom AutoFilters

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
This course provides information about using Microsoft Excel 2007. It provides basic information for beginners, or for those individuals wanting to brush up on working in Excel.
This course provides information about entering text, values and formulas into worksheet cells in Microsoft Excel 2007. It also provides information about calculating formulas and using built-in functions, like AutoComplete, AutoFill, Insert Function, and AutoSum.
This course shows you how to select, adjust and apply different formats to cells in Excel 2007.
This course provides information about using different viewing modes to preview workbooks, distinguishing between relative and absolute cell references, copying formulas from one cell to another, and viewing copied items on the clipboard. It also provides information about deleting, inserting and hiding cells; and using the Page Setup dialog box to insert headers, footers and page breaks.
This course provides information about managing multiple worksheets, naming cells and ranges, and searching for data within your worksheet. It also covers sharing and protecting your workbooks and adding cell-specific information such as Web links and comments.
This course provides a detailed look at how you can insert and modify charts, shapes, text boxes, pictures, SmartArt, and clip art to visually enhance your worksheets.

Summary:

This course provides information about the new user interface designed for the Microsoft Office 2007 applications.

Objectives:

  • List and describe the features of the new Office 2007 user interface
  • Change application settings in Office 2007 products
  • Use the Live Preview feature

Topics:

  • Why the big change?
  • The Ribbon: Command tabs and contextual tabs
  • The Ribbon: The Office menu
  • Galleries and live preview
  • Other new interface features

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the new features in Microsoft Office Word 2007.

Objectives:

  • Identify features of the new Word 2007 user interface
  • Insert building blocks, references, and other elements into a Word 2007 document
  • Use the features of the Page Layout tab
  • Compare documents using the new tri-pane review panel
  • Finalize a Word 2007 document

Topics:

  • The new look of Word 2007
  • Building blocks
  • Inserting elements
  • Working with themes
  • Adding references
  • Viewing documents
  • Comparing documents
  • Completing documents

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the new features in Microsoft Office Excel 2007.

Objectives:

  • Identify features of the new Excel 2007 user interface
  • Convert Excel data into table format
  • Use Excel 2007's Formula AutoComplete feature
  • Analyze data in Excel 2007 using conditional formatting
  • Create professional looking reports
  • Insert and format charts
  • Work with PivotTables and PivotCharts

Topics:

  • The new look of Excel 2007
  • Using the workbook
  • Creating and formatting tables
  • Formula features
  • Analyzing data using conditional formatting
  • Creating reports
  • Creating charts
  • Creating PivotTables and PivotCharts

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the new features in Microsoft Office PowerPoint 2007. It shows you how to create tables and charts, apply themes and effects, set presentation options, and finalize a presentation.

Objectives:

  • Create diagrams, tables, and charts
  • Apply themes to your presentations
  • Set presentation options
  • Use the Slide Library
  • Finalize a presentation

Topics:

  • The new look
  • Diagrams, tables, and charts
  • Themes
  • Effects
  • Presentation options
  • The Slide Library
  • Finalizing a presentation

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the new features in Microsoft Office Access 2007.

Objectives:

  • Navigate Access using the Ribbon, Office Menu, and Navigation Pane
  • Create a database
  • Create new forms
  • Filter the data in a table
  • Generate reports from a table
  • Migrate database objects to SQL Server and Windows SharePoint Services

Topics:

  • The new look
  • Creating a database
  • Importing data
  • Filtering data
  • Creating reports
  • Upsizing and moving data

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of the new features in Microsoft Office Outlook 2007.

Objectives:

  • Navigate Outlook using the To-Do Bar, a tabbed messaging window, and the Office menu
  • Set up an e-mail account
  • Search mail messages, calendars, and contacts
  • Use color categories and flags to organize and prioritize messages and contacts
  • Subscribe to RSS feeds
  • Set e-mail security options

Topics:

  • The new look
  • Setting up e-mail accounts
  • Instant Search
  • Setting up color categories
  • Adding RSS feeds
  • Defining messages as tasks
  • Using the calendar
  • Protecting yourself

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.

Summary:

This course provides an overview of common tasks in Microsoft Office 2007. After taking this course, learners will be able to perform basic document management, publishing, and editing tasks.

Objectives:

  • Create, save, open and close documents
  • Print documents
  • Prepare documents
  • Send and publish documents
  • Perform basic editing tasks and check spelling and grammar
  • Search for help in Office 2007

Topics:

  • Creating documents
  • Saving, opening and closing documents
  • Printing documents
  • Preparing documents
  • Sending and publishing documents
  • Basic editing tasks
  • Checking spelling and grammar
  • Getting help

Technical Requirements:

P500+ Processor, 128MB of RAM; Windows 2000, 2003, XP, Vista, Minimum screen resolution 800x600, Internet Explorer 5.5 or higher; Windows Media Player 9.0 or higher; Flash 8.0 or higher; 56K minimum connection; broadband (256 kpbs or higher) connection recommended; Javascript, DHTML and cookies enabled; Sound card with speakers or headphones strongly recommended.
This course explains how to use Outlook 2007 to send and receive e-mail messages.
This course explains how to manage the e-mail you receive.
This course covers managing your contacts in Outlook 2007. It discusses adding new contacts, creating and working with distribution lists, and sending contact information to other people via e-mail.
This course explains how to use the Calendar in Outlook 2007.
This course introduces tasks, distinguishes how they are different from to-do items, and looks at the ways Outlook helps manage them.
This course explains how to use the e-mail security and privacy protection features in Outlook 2007.
This course presents the use of search and archive features to manage your Outlook 2007 items.
This course provides information on inserting and deleting slides, selecting and sizing objects, working with placeholders, manipulating and formatting text, as well as inserting both shapes and symbols in PowerPoint 2007.
This course provides information on the design elements offered by PowerPoint 2007. This includes information on masters, placeholders, slide backgrounds, headers and footers, and themes.
This course provides information on using PowerPoint 2007's pre-designed shapes, line options, and freeform tools that allow you to draw, size, and format your own shapes and forms.
This course provides information on enhancing a PowerPoint 2007 presentation by formatting its shapes. This includes information on adding color, creating fill patterns, rotating shapes, and applying shadowing and 3-D effects.
This course provides information on working with pictures and WordArt text in a PowerPoint 2007 presentation. It covers how to search for and insert pictures, and how to resize and add effects to them. It also covers how to format and insert WordArt text.
This course provides information on creating and manipulating SmartArt graphics.
This course provides information on using PowerPoint 2007 features to insert and format charts and tables.
This course provides information about the new user interface of Word 2007. You will find out how to change the document view, how to create a new document, and how to print and save documents.
This course provides information on how to use features and functions of Microsoft Word 2007, including Undo, Redo, and Repeat to correct mistakes; Paste Options to control how copied text is pasted; Office Clipboard to store and paste text; and the Find.
This course provides an overview of the tools used to format text in Microsoft Word 2007.
This course introduces basic Word 2007 features for formatting paragraphs and lists.
This course provides an overview of the tools used to create and modify tables in Microsoft Word 2007.
This course provides an introduction to working with images in Word 2007.

Our training is available 24 hours a day, 365 days a year. Smart Horizons changes the way companies train their employees, bringing lower costs, and higher quality training to employees across town or around the world.