MS Office

 

Course Description

MS Office 2007 will provide – 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 Interfaceto 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:

 

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

we'll one over 5 Years of experience you always the best guidance

GET STARTED