Customer Service or Enrol: 0800 282 353 or +44 1372 364610
 

Microsoft Office® 2007: Streamlining Tasks for Improved Productivity

Course: 972   Type: Hands-On   Duration: 3 Days
Quick Enrol  

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 summarise 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 unauthorised access with the Trust Center

Course Benefits
Organisations 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 maximising 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:
  • Customising Office 2007
  • Designing documents with styles, themes and tables
  • Implementing the TOC, headers and footers in Word
  • Analysing 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

Course Content
Introducing Microsoft Office 2007
Discovering the Fluent User Interface
  • Navigating the Ribbon and Dialog Launcher
  • Setting defaults with the Office button
  • Customising 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
  • Summarising 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
Organising and displaying data
  • Inserting a table to present information
  • Sorting, selecting and summarising tables
Optimising 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
Finalising 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
  • Customising 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

Related Courses
 

request more info Salutation*:

First Name*:

Last Name*:

Job Title:

Company*:

Post Code*:

Country*:
   Codes
Office Telephone*:

Extension:

E-mail*:

* Required

A Learning Tree representative will contact you to follow up your request for information.

Save £275
Office 2007: Streamlining Tasks for Productivity
25 - 27 Feb, 2009
London
7 - 9 Apr, 2009
London
27 - 29 May, 2009
London
15 - 17 Jul, 2009
London
23 - 25 Sep, 2009
London
Complete Schedule
On-Site Courses

Course participants rapidly creating documents with Office 2007.

£ 1,435 - Standard Tuition
Savings Plans
£ 840 - 10-Day Training Pass
£ 1,000 - Flex-Training Passport
£ 1,050 - Short Course Vouchers
£ 1,295 - Alumni Gold Tuition

All Saving Plans
 
Customer Service or Enrol: 0800 282 353 or +44 1372 364610