|
|
1-800-THE-TREE (1-800-843-8733)
|
|
|
 |
|
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
Course 972 Content
- Navigating the Ribbon and Dialog Launcher
- Setting defaults with the Office button
- Customizing the Quick Access Toolbar
- Reviewing supported file extensions
- Configuring trust options
- Handling multiple headers and footers
- Implementing styles, themes and backgrounds
- Building, modifying and formatting tables
- Summarizing data with table formulas
- Taking advantage of SmartArt graphics
- Adding watermarks
- Creating new documents with templates
- Inserting and modifying Quick Parts and Building Blocks
- Inserting cover pages
- Condensing the document to an outline and viewing the document map
- Creating notes, comments and hyperlinks
- Constructing the TOC, index and table of authorities
- Making use of the Function Wizard
- Absolute versus relative addressing
- Inserting a table to present information
- Sorting, selecting and summarizing tables
- Graphing data with charts
- Visually enhancing data with conditional formatting
- Generating, editing and formatting PivotTable fields
- Filtering, sorting and pivoting charts and tables
- Web
- Text
- Access
- SQL Server
- XML
- Connecting to data sources using MS Query
- Extracting and correcting data types with formulas
- Connecting to Excel data
- Constructing the primary document
- Producing the result documents: letters, envelopes and labels
- Best practices for creating presentations
- Retrieving data from other applications
- Employing the AutoContent Wizard
- Applying design templates with themes
- Setting up and refining master layouts
- Creating custom slide libraries
- Embedding versus linking data
- Inserting charts and pictures
- Drawing business graphics
- Adding transitions and animations
- Publishing the presentation
- Removing private and personal information
- Enabling digital signatures
- Customizing document properties
- Managing multiple versions of a document
- Reviewing and tracking changes
- Linking Excel spreadsheets with SharePoint
- Subscribing to RSS feeds in Outlook
- Managing e-mail with the follow-up flag
|
Related Courses
Microsoft is a registered trademark of Microsoft Corporation.
|
|
|
|
|
|
|
Print Friendly
E-mail a Colleague
Course FAQ
Course PDF
Home
