Microsoft Office 2007: Streamlining Tasks for Improved Productivity

Course Overview

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 skills required to streamline day-to-day tasks and enable better decision-making in the workplace.

Microsoft is an increasing popular career choice. This Microsoft training course will help accelerate your job prospects.

Related Courses

• Microsoft Office 2007: Experience the 2007 Microsoft Microsoft Office: System
• Microsoft Office 2007: Upgrade to MS Office 2007
• Microsoft Office 2007: Upgrade/New Features
• Microsoft Office 2007: Deploying Microsoft Office 2007 Professional Plus
• Microsoft Office 2007 VBA: Introduction to VBA in Office 2007
• Microsoft Office InfoPath 2007 3 Day Course
• Microsoft Office 2007: Advanced VBA
• Microsoft Office Power Point 2007/10 Smart og Avansert

Audience

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

Skills Gained

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

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 Outline

Introducing Microsoft Office 2007

Discovering the Fluent User Interface

• Navigating the Ribbon and Dialogue 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 the AutoContent Wizard

Enhancing the slides

• Applying design templates with 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

 

Microsoft Office 2007: Streamlining Tasks for Improved Productivity / 972

Request availability or enquire by clicking a date: