Learn MS Office 2007: Word, Excel, PowerPoint & Outlook

Course Cost: 6 Month Subscription

Basic Course (no certificate) = $70.00
Course with Online Certificate* = $95.00

* Document your course completion with an online certificate (additional shipping/handling charges apply for hard copy delivery). Instantly download, print, and share your certificate and CEUs once awarded. UniversalClass™ offers many wonderful learning tools to help you get the most out of your online course, including an online portfolio service that manages all your course completions, and a Certificate Verification Service you can use so others may view and verify the authenticity of your awards.

Course Description

MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook.

MS Word 2007

It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as well as focuses on the more advanced tools that all students will find useful. Additionally, this course introduces new features exclusive to MS Word 2007, as well as includes detailed instructions on how to use them. You'll learn your way around the toolbars and menus, basic editing features,how to insert items into a document, how to create and edit tables,Macros,And much, much more!

MS Excel 2007

Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. With the right training and understanding of Excel 2007, businesses and individual users can unlock the world of opportunities that this powerful business application offers. This Excel 2007 Online Training Course does just that and more! It assumes users have no prior experience with Excel or other spreadsheet programs.

Many new features await the Excel 2007 user. Below are just a few highlights:

Horizontal "ribbons" that display commands left-to-right instead of the traditional vertical water-flow look.
More rows and columns to help manage your really massive spreadsheets!
Memory management increased from 1GB to 2GB's which allows for faster computations and increased performance.
New options for applying themes and styles which enhance the look of your spreadsheets and graphics. And, Excel now supports up to 16 million colors!
Easier creation and use of formulas.
New Pivot Table User Interface to help the user more effectively use pivot tables.

PowerPoint 2007

The purpose of this section of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsoft Office Fluent which allows for the creation of dynamic, professional presentations in a much shorter period of time than earlier versions of PowerPoint. The Fluent interface has all commands, toolbars and task panes categorized into tabs and related groups.

Among the many new options offered by PowerPoint 2007 are new themes and quick styles, custom slide layouts, Smart Art graphics, more advanced graphic effects for text, pictures, objects, charts, graphs and tables, more effective proofing tools, user-friendly collaboration and permission features, and much more. This course will walk you through PowerPoint 2007, beginning with the basics and lead you through to some of the most advanced features available, offering additional helpful tips and hints along the way.

Outlook 2007

This section has been developed to be of benefit to new users of Outlook, individuals migrating from previous versions of Outlook and individuals wanting to learn to use the advanced functionality of Outlook 2007. After completing this section, learners will be able to demonstrate an understanding of the fundamental features of Outlook 2007,set up new email accounts along with understanding how to convert their previous Outlook information to 2007, utilize the toolbars and navigation panes in Outlook 2007, understand how to operate the email tools in Outlook 2007, demonstrate an understanding of how to customize email options and tools, perform personal information management tasks, manage and utilize Outlook 2007's contact management tools, understand and utilize Outlook 2007's calendar, tasks, notes and journal entry tools, and demonstrate an understanding of the collaboration and remote access tools in Outlook 2007.

Before you begin this course:

It is strongly recommended you have MS Office 2007 or have access to this version.

If you are a current user of Microsoft Office 2003 or an earlier version, before you download 2007 we recommend you uninstall these programs. MS Office 2007 may not download properly if you are operating a previous version.
While this course is aimed at both beginners and advanced users, we take for granted that you already know how to turn your computer on, use your mouse and can understand in basic terms how to operate your computer.

Course Lessons

Lesson 1: #1 Word 2007

Word Processing Versus Desktop Publishing
Starting Microsoft Word 2007
Virtual Tour of MS Word 2007
Opening a New Document
Saving a Document
Getting Help with MS Word 2007

Lesson 2: #2 Word 2007: Basic Editing

The Cursor
Inserting Text
Deleting Text
Moving Text
Undo and Redo
Wrap Text

Lesson 3: #3 Word 2007: Formatting

Selecting Text
Applying a Font
Changing Font Size
Font Attributes
Font Color
Clear Formatting
Text Alignment

Lesson 4: #4 Word 2007: Copying and Moving Text and Object

The Clipboard
Paste
Formatting
Changing Defaults
Drag and Drop Text

Lesson 5: #5 Word 2007: Editing Features

Spell Check
Thesaurus
Auto Correct
Create Your Own Default Dictionary in MS Word
Check Word Count
Track Changes
Accepting and Rejecting Changes
Page View
Zoom

Lesson 6: #6 Word 2007: Paragraph Formatting

Changing Paragraph Alignment
Indenting Paragraphs
Add Borders or Shading to a Paragraph
Apply Paragraph Styles
Creating Links within a Document
Change Spacing Between Paragraphs and Lines

Lesson 7: #7 Word 2007: Tables

Creating Tables
Creating a table by highlighting the boxes
Create a table by using the Insert Table command
Drawing a Table
Converting text into a table
Quick Tables
Entering Text
Table Tools
Inserting rows and colu

Lesson 8: #8 Word 2007: Lists

Bulleted and Numbered Lists
Creating a Nested List
Format Your List
Creating Outlines

Lesson 9: #9 Word 2007: Page Formatting

Page Margins
How to Change the Orientation, Size of the Page, or Size of the Columns
Apply a Page Border and Color
Insert Headers and Footers (Including Page Numbers)
Create a Page Break
Insert a Cover Page
Insert a Blank Pag

Lesson 10: #10 Word 2007: Inserting Graphics, Pictures, and Table of Contents

Inserting Special Characters Into Your Document
Inserting Equations
How to Insert Illustrations, Pictures, and SmartArt
Resizing Graphics
Watermarks
Table of Contents
Creating a Table of Contents
Update a Table of Conten

Lesson 11: #11 Word 2007: Advanced Tools

References and Citations
How to Insert Citations
Placeholders
Manage Sources
Adding a Bibliography
Adding Footnotes
Macros
Running a Macro
Compare and Merge Documents
Protect Document
Mailing Lists

Lesson 12: #12 Excel 2007

This lesson is intended to help the user become familiar with the functions and features of Microsoft's latest release of one of its most popular and powerful business applications.

Lesson 13: #13 Excel 2007: Opening a Blank or New Workbook, General Organization

Instruction on opening a blank or new workbook, and general organization of Excel.

Lesson 14: #14 Excel 2007: Highlights and Main Functions: Home, Insert, Page Layout, Formulas

Instruction on home navigation, and how to use Insert, Page Layout, and Formulas.

Lesson 15: #15 Excel 2007: Highlights and Main Functions: Data, Review, View, Add-Ins

In this lesson, the Main Tabs - DATA, REVIEW, VIEW, and ADD-INS - will be discussed in more detail.

Lesson 16: #16 Excel 2007: Using the Excel Help Function

How to use the help function is expalined.

Lesson 17: #17 Excel 2007: Customizing the Quick Access Toolbar

How to customized the toolbar by the user to hold many different commands.

Lesson 18: #18 Excel 2007: Creating/Using Templates

Microsoft Excel 2007 provides access to a variety of free TEMPLATES. How to customize the templates as needed for themes, other required fields, logo or company name, and much more, is explained.

Lesson 19: #19 Excel 2007: Working with Data: Entering, Editing, Copy, Cut, Paste, Paste Special

This lesson begins to cover the basics of working with data. After all, this one of Excel's primary functions! Data includes text, numbers, equations and formulas, and more. Any of these data can be edited for multiple purposes.

Lesson 20: #20 Excel 2007: Formatting Data and Using the Right Mouse Click

Formatting helps to provide important visual interest as well as to structure the data and cells so that meaningful analysis and interpretation can be completed. Poorly formatted worksheets rarely accomplish their goals of managing and presenting data.

Lesson 21: #21 Excel 2007: Saving, Page Setup, and Printing

This lesson goes into greater detail to review commands that save the workbook changes, format pages for printing, and then print the workbook output. Page Setup includes functions such as Margins, Orientation, Paper Size, Breaks, Background and Print Ti

Lesson 22: #22 Excel 2007: Using Headers and Footers

This lesson describes the procedures for working with Headers & Footers. Headers include text, numbers, and other content that displays at the top of each printed page.

Lesson 23: #23 Excel 2007: Manipulating Data using Data Names and Ranges, Filters and Sort, and Validation Lists

This lesson covers several basic procedures for manipulating data, governing how data relates to other data, viewing data in different ways, and ensuring data that is entered is valid for the specific business or other criteria.

Lesson 24: #24 Excel 2007: Data from External Sources

This lesson discusses the different data sources and how data can get into an Excel worksheet other than typing or copying and pasting from within the same worksheet.

Lesson 25: #25 Excel 2007: Using and Formatting Tables

This lesson discusses how to use the Table functions within Excel 2007. Excel 2007 introduces predefined table formats to help quickly organize data within Excel, as well as display that data to maximize visual appeal.

Lesson 26: #26 Excel 2007: Basic Formulas and Use of Functions

This lesson begins delving into the heart of Excel 2007; using formulas and functions to manipulate and analyze data.

Lesson 27: #27 Excel 2007: Data Analysis Using Charts and Graphs

This lesson takes data analysis to the next level; turning numbers into visually interesting charts and graphs. Excel 2007 represents the next generation Charts Wizard! The Chart Wizard very quickly enables the creation of interesting, colorful an

Lesson 28: #28 PowerPoint 2007

Introduction to terminology and elements of PowerPoint presentations
Demonstrate understanding of templates
Demonstrate understanding of slide layouts
Demonstrate understanding of Ribbon tabs
Demonstrate understanding of Tool bars

Lesson 29: #29 PowerPoint 2007: Creating a Basic Presentation

Introduction to the different options available for creating your presentation
Learn how to create a presentation from a template (include web templates)
Learn how to create a presentation from an existing presentation (include converting a pres

Lesson 30: #30 PowerPoint 2007: Building Blocks of a Presentation

Introduction to the basics of a slide show and presentation (include tips for good presentation practice including goals of a presentation)
Demonstrate understanding of the Elements of a slide
Learn how to Add slides

More Class Lessons...

Optional Certificates Awarded

Certificate of Merit
Certificate of Academic Excellence

In addition to the standard Certificate of Course Completion, Merit Awards may be issued by the instructor at his/her own discretion and are based on student achievement. Merit awards also incur an additional $30.00 processing fee that covers the customization, printing, and delivery of the award, as well as access to the UniversalClass™ Portfolio Service that documents your achievements online. Official Merit Awards have a serial number that verifies the authenticity of the award (great for employers to verify your achievement).

Request Information

Additional Information

Course Title	:	MS Office 2007: Word, Excel, PowerPoint and Outlook
CEU Value	:	1.0 (Continuing Education Units)
Course Number	:	7550161
Course Type	:	How To
Course URL	:	http://office2007.onlineclasses.com
Course Rating	:
Instructor	:	Sean Mellencamp
Syllabus	:	View Syllabus
Duration	:	Continuous: Enroll anytime!
Course Fee	:	Basic Course: $70
		with CEUs & Certificate: $95

NOT FOR COLLEGE CREDIT

This is a non-credit course, and is provided for your personal enrichment. This course is not intended to be a substitute for any state, government, licensing, or educational requirements.

Choose from 5 Payment Methods

	Credit Card Online		Credit Card through FAX
	Check/Money Order through Mail		Credit Card over the Phone
	PayPal

To use any of these methods you must press the "Join this Course" button on this screen and go through the online registration process in order to generate the correct order form and correctly process your enrollment.

Recommended Books

Featured Courses in Computer Training

1. Computer Basics 101 ($55.00) Do you find yourself intimidated by computer jargon?. more		2. Introduction to MS Excel ($60.00) Whether you've used MS Excel before and just want to learn more about Excel or are completely new to the program, this course is designed to teach you the features of MS Excel to have you using it like a pro. more

3. Effective Presentations ($55.00) Speaking in front of a group of people is one of the most common fears people experience. more		4. MS Office 2003: Word, Excel, PowerPoint ($90.00) This all in one training course will provide comprehensive instruction on three popular MS Office programs: MS Word 2003, MS Excel 2003, PowerPoint 2003. more

Other Related Classes in Computer Training

Adobe Flash 101 Adobe Flash CS4 can be a complex program to use and understand, even if you already have basic knowledge. It's very easy to get lost in the interface and confused by the many features it offers. This course was designed to solve the mysteries of Adob...
Adobe Photoshop 101 Adobe Photoshop is a complex graphics and image editing software and paint program. Chances are, you've heard of Photoshop frequently in the past even if this will be the very first time that you use the program. Adobe's Photoshop program has become a ...
Business Math 101 This course takes you through an overview of the wonderful world of business mathematics. The course is designed for a person of any age and anywhere in the world. All that is required of the learner are a computer, a connection to the internet, a c...
Computer Basics 101 Do you find yourself intimidated by computer jargon? Would you like to have a clearer understanding (in non-jargon language) of how your computer works? Computer Basics 101 will both demonstrate and explain how your computer works in an easy-to-follow, ...
Dreamweaver 101 Whether this is your first time using Dreamweaver or you've used it in the past, this course will walk you through the program step-by-step and teach you how to use its many features and options to create professional web pages with little more than ...
Excel 2007 Microsoft Excel 2007 is Microsoft's latest version of its very popular business productivity application for the management and manipulation of data. Microsoft Excel is often packaged as part of Microsoft Office that includes other applications such as M...
How to Create Web Pages These days, everyone can benefit from an online presence, and that means developing a website. This course covers a basic introduction of how to create your own website page-by-page using HTML, a common website coding process. From basic HTML defin...
Internet Fundamentals 101 Are you in the dark about how the Internet works? Do you wonder how in the world it is possible to communicate with someone on another continent in the blink of an eye? This straightforward course clearly and plainly lays out the basics of the Internet...
Introduction to MS Excel Whether you've used MS Excel before and just want to learn more about Excel or are completely new to the program, this course is designed to teach you the features of MS Excel to have you using it like a pro. It's a fact that a lot of people just like...
Managerial Accounting 101 Managerial accounting is not as widely used as other forms of accounting, nor is it as known. While companies concern themselves with financial accounting methods like audits, budgets and financial statements, they often completely ignore the forward-th...
Microsoft Publisher 2007 Microsoft Publisher can be an amazing tool. It can help us complete impressive tasks in a fraction of the time, and help to accomplish things that we could never have done on our own. But you have to know how to use this program. This course will sho...
MS Office 2003: Word, Excel, PowerPoint This all in one training course will provide comprehensive instruction on three popular MS Office programs: MS Word 2003, MS Excel 2003, PowerPoint 2003. MS Word 2003 T his course teaches you all the basics of MS Word, from doing simply functions li...
MS Office 2007: Word, Excel, PowerPoint and Outlook MS Office 2007 will provide a comprehensive tutorial of these programs- Word, Excel, PowerPoint, and Outlook. MS Word 2007 It doesn't matter if you're new to MS Word or an experienced user, this comprehensive course teaches the most basic features as w...
MS Word 2003 It doesn't matter if you've never used MS Word before or you just want to familiarize yourself with MS Word 2003. This course teaches you all the basics of MS Word, from doing simply functions like typing in the text area to formatting text, to give the ...
MS Word 2007 This Microsoft Word 2007 course is not only designed to give the experienced MS Word user a tour of the new version of Word, but to also introduce new MS Word users to a comprehensive look at the features and utilities that this word processing software...
Outlook 2007 The purpose of this course is to help you understand what Outlook 2007 can do for you, whether you are familiar with Outlook 2003 or new to the application altogether. This course has been developed to be of benefit to new users of Outlook, individuals ...
Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. Lesser priced, it contains all the features of Photoshop, but contains fewer options that are much easier to understand. Elements was designed with the consum...
PowerPoint 2003 MS PowerPoint 2003 is probably one of the most convenient software applications in the Office suite because it allows you to do so much – easily. Whether you want to create professional presentations for the office or just brush up on your skills...
PowerPoint 2007 The purpose of this course is to help you understand what PowerPoint 2007 can do for you, whether you are familiar with PowerPoint 2003 or new to the application altogether. One of the most noticeable changes is the new user interface called the Microsof...
Typing and Keyboarding 101 Today, knowing how to type fast is almost a necessity in the business world. More and more corporate-world employees are being asked to create reports, sales letters, business plans, blogs, web content, forecasts and more. Knowing how to type can sav...

Areas of Study