Class Syllabus: MS Office 2007: Word, Excel, PowerPoint and Outlook

Office Hours:	Continuous
Course Meeting Times:	Continuous

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 Requirements

This course will not require you to have previous experience in any particular area but you should have the following:

high school reading level.

-MS Word version 2007

-MS Excel version 2007

-PowerPoint version 2007

-Outlook version 2007

No books will be required.

Course Topics

#1 Word 2007
#2 Word 2007: Basic Editing
#3 Word 2007: Formatting
#4 Word 2007: Copying and Moving Text and Object
#5 Word 2007: Editing Features
#6 Word 2007: Paragraph Formatting
#7 Word 2007: Tables
#8 Word 2007: Lists
#9 Word 2007: Page Formatting
#10 Word 2007: Inserting Graphics, Pictures, and Table of Contents
#11 Word 2007: Advanced Tools
#12 Excel 2007
#13 Excel 2007: Opening a Blank or New Workbook, General Organization
#14 Excel 2007: Highlights and Main Functions: Home, Insert, Page Layout, Formulas
#15 Excel 2007: Highlights and Main Functions: Data, Review, View, Add-Ins
#16 Excel 2007: Using the Excel Help Function
#17 Excel 2007: Customizing the Quick Access Toolbar
#18 Excel 2007: Creating and Using Templates
#19 Excel 2007: Working with Data: Entering, Editing, Copy, Cut, Paste, Paste Special
#20 Excel 2007: Formatting Data and Using the Right Mouse Click
#21 Excel 2007: Saving, Page Setup, and Printing
#22 Excel 2007: Using Headers and Footers
#23 Excel 2007: Manipulating Data using Data Names and Ranges, Filters and Sort, and Validation Lists
#24 Excel 2007: Data from External Sources
#25 Excel 2007: Using and Formatting Tables
#26 Excel 2007: Basic Formulas and Use of Functions
#27 Excel 2007: Data Analysis Using Charts and Graphs
#28 PowerPoint 2007
#29 PowerPoint 2007: Creating a Basic Presentation
#30 PowerPoint 2007: Building Blocks of a Presentation
#31 PowerPoint 2007: Working with Text
#32 PowerPoint 2007: Working with Themes and Styles
#33 PowerPoint 2007: Working with Charts, Graphs, & Tables
#34 PowerPoint 2007: Working with Media Clips and Animation
#35 PowerPoint 2007: Working with Macros and Customizing PowerPoint 2007
#36 PowerPoint 2007: Troubleshooting PowerPoint 2007
#37 PowerPoint 2007: Packaging and Publishing your Presentation
#38 Outlook 2007
#39 Outlook 2007: Understanding the Fundamental Features of Outlook 2007
#40 Outlook 2007: Getting Started With Outlook 2007
#41 Outlook 2007: Understanding Email in Outlook 2007
#42 Outlook 2007: Customizing Email Options and Tools
#43 Outlook 2007:: Managing your Contacts
#44 Outlook 2007: Understanding the Outlook 2007 Calendar
#45 Outlook 2007: Understanding Tasks and Using them to Manage your Workload
#46 Outlook 2007: Using Outlook 2007 Notes and Journal Entries
#47 Outlook 2007: Collaboration Options in Outlook 2007
#48 Outlook 2007: Organizing and Customizing Outlook 2007

Course Materials

All course material will be provided in the lessons and netlinks. There are no required materials to purchase before taking the class. In order to fully benefit from this course, though, you do need access to Microsoft Word, MS Excel and PowerPoint version 2007.

Grading Policy

Each lesson will include a lesson review quiz along with one or two assignments. Students will successfully complete this course with 70% or better .

Learning Outcomes

By successfully completing this course, students will be able to:

Start MS Word, perform basic editing functions, format text, copy and move objects and text.
Format paragraphs, insert tables, create lists, and format pages in Word 2007.
Insert graphics, pictures, and table of contents in Word 2007.
Review Excel 2007 navigation, features, and create a worksheet.
Use the help function and customize the Quick Access Toolbar in Excel 2007.
Create/Use templates, enter, edit, copy, cut, paste, and format data in Excel 2007.
Save, page setup, and print worksheets in Excel 2007.
Insert headers and footers in Excel 2007.
Manipulate data using data names and ranges, filters and sort, and validation lists in Excel 2007.
Use formulas, create charts and graphs in Excel 2007.
Create a basic presentation in PowerPoint 2007.
Work with text, themes, and styles in PowerPoint 2007.
Create charts, grants, and tables in PowerPoint 2007.
Insert media clips and animation in PowerPoint 2007.
Use macros, customize, package and publish your presentation in PowerPoint 2007.
Describe the major features and functions of Outlook 2007.
Customize email options, tools, and manage your contacts in Outlook 2007.
Use the Outlook 2007 calendar, create tasks, and manage your workload.
Create notes, journal entries, and perform collaboration options in Outlook 2007.
Organize and customize Outlook 2007, and
Demonstrate mastery of lesson content at levels of 70% or higher.

Recommended Books

Featured Courses in Computer Training

1. Computer Basics 101 ($60.00) Do you find yourself intimidated by computer jargon?. more		2. Introduction to Excel 2003 ($65.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 ($60.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

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...
Quickbooks 101 QuickBooks 101 is a course geared for the small business and the small business owner. It contains the features that you loved in Quicken, then goes a step further to give small businesses the accounting software they need to take their numbers from an e...
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 ...
Photoshop Elements Version 7.0 (or earlier) 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...
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 ...
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 like ...
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...
Quicken Deluxe 2010 Quicken Deluxe is a personal finance management tool that provides features that we all need to keep track of where our money is going. However, this software gives you more than just the power to log your finances and manage your bills. It can also ...
Photoshop Elements 101 The Photoshop Elements software package is a condensed version of the popular Adobe Photoshop. As the lesser priced version of Adobe's Photoshop, Elements offers all the same features, but just with less options. However, don't let that scare you away fr...
Microsoft Project 2007 Microsoft Project 2007 is a project management software that helps project managers better structure, organize, and plan for all their projects. This includes budgets, tasks, resources, assignments, and everything in between. It can create critical pat...
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...
MS Publisher 2010 Microsoft Publisher 2010 is a desktop publishing software program that comes with the Microsoft Office suite. While Microsoft Word is a word processing program, Microsoft Publisher is used for page layout and design. You can use Publisher to create brochu...
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...

Areas of Study