Request Info

Salutation

First Name

Last Name

Job Title

Department

Mailstop

Company

Address

P.O. Box

City

State

Zip Code

Country
List

Work Phone

Extension

E-mail

Information provided will be used to communicate with you about our products.
Privacy Statement

A representative will contact you to follow up your request.

  

Microsoft Office®:
Streamlining Tasks for Improved Productivity

Course 972 • 3 Days

 E-mail E-mail a Colleague Course Details Course Details Course Details PDF Course Details PDF

Frequently Asked Questions

What is this course about?

This course covers the features in Word, Excel and PowerPoint that help to increase your productivity. You learn to connect to, analyze and present information using Microsoft Office, with a special focus on how these programs work together. This course offers you the skills to expedite everyday tasks.

Specifically, you learn to build professional documents in Word with enhanced functionality; quickly present and summarize data with Excel using PivotTables and PivotCharts; easily incorporate external data sources; create visually dynamic and effective presentations in PowerPoint; and safeguard documents from viruses and unathorized access.

Which version of Microsoft Office is used in the course?

This course uses both the 2010 and 2007 versions of Microsoft Office. The course exercises can be completed in either version.

Who will benefit from this course?

Business professionals, administrative professionals, IT personnel (especially helpdesk), managers, executives, and PAs (personal assistants) benefit from this course. This course is appropriate for anyone interested in enhancing their Microsoft Office skills for improved productivity.

What background do I need?

A general knowledge of Microsoft Office--experience with Office applications at an introductory level--is assumed.

My company is using Office 2003. Will this course still be helpful to me?

The user interface is significantly different in Office 2007 and 2010, however much of the functionality is the same in versions 2003, 2007 and 2010. There are many new features in Office 2007 and 2010, however the basic principles in the course apply to version 2003 users.

Will the course explore the user interface in detail?

Yes, this course does explore the user interface in detail as well as the expanded formatting functionality in Word, Excel and PowerPoint.

Will the course cover Master pages in PowerPoint?

Yes, the course covers, in detail, how to create and modify the Master page. In addition, focus is given to creating design templates.

Will I learn how to use MS Query?

Yes, you learn how to use the MS Query Wizard to retrieve external data, but this course does not cover the Query By Example (QBE) grid or OLAP cubes.

Will I learn how to program with macros or VBA in this course?

No, this course focuses on application skills without coding. For a course specific to VBA programming, please see Course 209, VBA Programming: A Comprehensive Hands-On Introduction.

Does this course cover Outlook and Access in detail?

No, this course focuses exclusively on Word, Excel and PowerPoint.

Learning Tree also offers courses that focus on Microsoft Access, including Course 970, Microsoft Access®: A Comprehensive Hands-On Introduction, and Course 971, Building Applications with Microsoft Access®: Hands-On.

In addition, Learning Tree also offers these courses on Microsoft Excel and Visio:

Course 1361, Microsoft Excel®: A Comprehensive Hands-On Introduction

Course 195, Power Excel®: Analyzing Data to Make Business Decisions

Course 1372, Excel® Macros: Increasing Productivity through Automation

Course 194, Hands-On Visio®: Designing Effective Visual Solutions

Please refer to individual course Q&As for details about each of these courses.

How much time is spent on each topic?

ContentHours
Introducing Microsoft Office2.0
Creating professional documents in Word3.0
Referencing and navigating documents 2.0
Producing rapid results with Excel3.0
Integrating data sources2.0
Developing PowerPoint presentations 3.0
Document security and collaboration2.0
Times, including the workshops, are estimates; exact times may vary according to the needs of each class.

How much time is devoted to the hands-on exercises?

Approximately 45% of class time is spent on hands-on exercises. These exercises are designed to provide you with practical, real-world experience using the more advanced features of Office. Exercises include:

  • Customizing Office 2010/2007
  • Designing documents with styles, themes and tables
  • Implementing the TOC, headers and footers in Word
  • Analyzing data with PivotTables and PivotCharts
  • Applying conditional formatting and SmartArt
  • Refining the data with formulas in Excel
  • Creating PowerPoint presentations with Master layouts and design masters
  • Tracking and versioning Word documents

How detailed are the PivotTable and PivotChart topics covered in this course?

A basic introduction to these topics is covered in this course, which can be used as foundational knowledge for Course 195, Power Excel®: Analyzing Data to Make Business Decisions, followed by Course 1372, Excel® Macros: Increasing Productivity through Automation.

How does this course relate to other Learning Tree courses?

The following courses may be of interest:

Microsoft is a registered trademark of Microsoft Corporation.

Learning Tree AnyWareTM is a trademark of Learning Tree International, Inc. in the United States and other countries, and is covered by a patent application pending in the United States.
  
Microsoft Office®: Streamlining Tasks for Improved Productivity

Training Dates

Live online classroom training.Most events below can be taken in-class or live, online from your home or office with AnyWare.
Jun 6 - 8New York enroll
Jun 20 - 22Reston, VA enroll
Aug 15 - 17New York enroll
Aug 22 - 24Rockville, MD enroll
Sep 12 - 14Reston, VA enroll
Oct 10 - 12New York enroll
Nov 7 - 9Rockville, MD enroll
Dec 19 - 21New York enroll
Jan 16 - 18Reston, VA enroll

For AnyWare enrollments, please register at least 7 days prior to the start of the course.

More Dates and Locations.

Tuition for Course 972 (3 Days)

Special Price $1,790
Special Price $1,575

Bring this or any Learning Tree Course on-site to your location!

Your Course Tuition
Entitles You to...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate awarding Continuing Education Units
  • FREE participation in Professional Certification
  • FREE participation in College Credit programs (including related exams)