1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Microsoft Office 2007: Streamlining Tasks for Improved Productivity

 
Course: 972   Type: Hands-On Training   Duration: 3 Days
 
 

You Will Learn How To

  • Leverage the extensive features in Word, Excel and PowerPoint
  • 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
  • Safeguard documents from viruses and unauthorized access with the Trust Center

Course Benefits

Organizations depend on highly skilled employees to work effectively and efficiently to produce quality documents. This course is designed to improve productivity by leveraging the power of Microsoft Office 2007 applications. Throughout this course, you gain the skills to stand out in a competitive market by maximizing the innovative features and integration techniques required to streamline day-to-day tasks and enable better decision-making in the workplace.

Who Should Attend

Anyone interested in enhancing their Microsoft Office 2007 skills for improved productivity. Experience with Microsoft Office applications at an introductory level is assumed.

Hands-On Training

Hands-on exercises provide you with practical experience using Office 2007. Exercises include:
  • Customizing Office 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, slide libraries and design masters
  • Tracking and versioning Word documents

Related Courses

 
Microsoft is a registered trademark of Microsoft Corporation. 		 

Upcoming Dates

Mar 4 - 6, 2009
 New York
Mar 11 - 13, 2009
 Washington, DC (Alexandria, VA)
Mar 18 - 20, 2009
 Chicago (Schaumburg)
Mar 25 - 27, 2009
 Toronto
Apr 1 - 3, 2009
 Washington, DC (Rockville, MD)
Apr 8 - 10, 2009
 Los Angeles
Apr 29 - May 1, 2009
 Washington, DC (Reston, VA)
May 20 - 22, 2009
 Ottawa
Jun 10 - 12, 2009
 New York
Jun 17 - 19, 2009
 Washington, DC (Alexandria, VA)
Jun 24 - 26, 2009
 Chicago (Schaumburg)
Jun 24 - 26, 2009
 Toronto
Jul 8 - 10, 2009
 Washington, DC (Rockville, MD)
Jul 29 - 31, 2009
 Los Angeles
Aug 5 - 7, 2009
 Washington, DC (Reston, VA)

For complete schedule, please visit www.learningtree.com
 
http://www.learntree.com/courses/972pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Microsoft Office 2007: Streamlining Tasks for Improved Productivity

 
Course: 972   Type: Hands-On Training   Duration: 3 Days
 
 
Course 972 Content
 

Introducing Microsoft Office 2007

Discovering the Fluent User Interface

  • Navigating the Ribbon and Dialog Launcher
  • Setting defaults with the Office button
  • Customizing the Quick Access Toolbar

Exploring file formats and the Trust Center

  • Reviewing supported file extensions
  • Configuring trust options

Creating Professional Documents in Word

Establishing the document setup

  • Handling multiple headers and footers
  • Implementing styles, themes and backgrounds

Displaying data with Word tables

  • Building, modifying and formatting tables
  • Summarizing data with table formulas

Enhancing documents with graphics

  • Taking advantage of SmartArt graphics
  • Adding watermarks

Automating documents and text

  • Creating new documents with templates
  • Inserting and modifying Quick Parts and Building Blocks

Referencing and Navigating Documents

Streamlining document tasks

  • Inserting cover pages
  • Condensing the document to an outline and viewing the document map

Citing references

  • Creating notes, comments and hyperlinks
  • Constructing the TOC, index and table of authorities

Producing Rapid Results with Excel

Leveraging Excel functionality

  • Making use of the Function Wizard
  • Absolute versus relative addressing

Organizing and displaying data

  • Inserting a table to present information
  • Sorting, selecting and summarizing tables

Optimizing graphical objects

  • Graphing data with charts
  • Visually enhancing data with conditional formatting

Creating interactive PivotTables and PivotCharts

  • Generating, editing and formatting PivotTable fields
  • Filtering, sorting and pivoting charts and tables

Integrating Data Sources

Retrieving external data

  • Web
  • Text
  • Access
  • SQL Server
  • XML
  • Connecting to data sources using MS Query
  • Extracting and correcting data types with formulas

Assembling mass mailings

  • Connecting to Excel data
  • Constructing the primary document
  • Producing the result documents: letters, envelopes and labels

Developing PowerPoint Presentations

Building a dynamic slide show

  • Best practices for creating presentations
  • Retrieving data from other applications
  • Employing text from other programs

Enhancing the slides

  • Applying themes
  • Setting up and refining master layouts
  • Creating custom slide libraries

Incorporating objects

  • Embedding versus linking data
  • Inserting charts and pictures
  • Drawing business graphics

Finalizing and adding special effects

  • Adding transitions and animations
  • Publishing the presentation

Document Security and Collaboration

Protecting documents

  • Removing private and personal information
  • Enabling digital signatures
  • Customizing document properties

Implementing revision control

  • Managing multiple versions of a document
  • Reviewing and tracking changes

SharePoint and Outlook

  • Linking Excel spreadsheets with SharePoint
  • Subscribing to RSS feeds in Outlook
  • Managing e-mail with the follow-up flag
 
http://www.learntree.com/courses/972pf.htm
 
 
1-800-THE-TREE (1-800-843-8733)
TRAINING YOU CAN TRUST
 
 

Microsoft Office 2007: Streamlining Tasks for Improved Productivity Tuition

 
Course: 972   Type: Hands-On Training   Duration: 3 Days
 
 

Course Tuition
$ 2,390 Standard Tuition
Tuition with a Savings Plan
$ 1,350 10-Day Pass
$ 1,670 Training Passport
$ 1,625 Premium-Pass
$ 2,200 Voucher 10-Pack
$ 2,155 Alumni Gold Discount
$ 2,124 Government Discount
 

 

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)
  
 

Tuition Savings Plans

Training Passport
  • 3 courses in 12 months
  • As little as $1,670 per course
  • Savings as much as 45%
  • Only $5,000
Premium Pass
  • 4 courses in 24 months
  • As little as $1,625 per course
  • Save as much as 45%
10-Day Pass
  • A NEW way to save on training
  • 10 days of training for one person
  • Save as much as $990 per course
  • Only $4,500
Training Vouchers
  • Save as much as $990 per course
  • Fully transferable
  • As low as $2,200 per course
Alumni Gold Discount Attend your first course and you'll receive a personalized Alumni Gold Discount card, entitling you to save as much as $305 on each course you take within the following 12 months. Take just one course each year and you'll be entitled to ongoing discounts...year after year!

Your Guarantee of Satisfaction

Unless you feel 100% satisfied that Learning Tree delivered even more than you expected, there is no fee for your course attendance. Our Guarantee of Quality lets you experience the value of the course--and then pay only if you feel the course was well worth the tuition.

Enrolling is Easy and Flexible!

Enroll by phone or online. If your plans change, just let us know and, without a fee, you can transfer to another course or cancel your enrollment. Pay after you've taken the course, and then only if you are 100% satisfied.
 
http://www.learntree.com/courses/972pf.htm