0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

Microsoft Office: 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 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 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 skills for improved productivity. Experience with Microsoft Office applications at an introductory level is assumed.

Hands-On Training

Exercises provide you with practical experience using Microsoft Office. Exercises include:
  • Customising Microsoft Office
  • Designing documents with styles, themes and sections
  • 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 and design masters
  • Securing documents using visible and invisible digital signatures and the Trust Center

Related Courses

  • 195 Power Excel: Analysing Data
  • 209 VBA Programming Comprehensive Introduction
  • 194 Hands-On Visio: Effective Visual Solutions
  • 970 Microsoft Access Comprehensive Introduction
  • 971 Building Applications with Microsoft Access
  • 538 SharePoint 2007 Technologies Comprehensive Introduction
  • 345 Delivering Dynamic Presentations
  • 919 SharePoint for Project Management
  • 126 Crystal Reports
  • 1501 SharePoint 2010 Technologies Comprehensive Introduction

 
Microsoft is a registered trademark of Microsoft Corporation.
   MS Office: Streamlining Tasks for Productivity

Upcoming Dates

12 - 14 JanLondon 
6 - 8 JulLondon 

Live online classroom training.

Attend highlighted events
in person or online with Learning Tree AnyWareTM.


For complete schedule, please visit www.learningtree.co.uk
 
http://www.learningtree.co.uk/courses/uk972.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

Microsoft Office: Streamlining Tasks for Improved Productivity

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

Introducing Microsoft Office

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

  • Reviewing supported file extensions
  • Discovering the Compatibility Pack

Creating Professional Documents in Word

Establishing the document setup

  • Configuring the status bar
  • Working with sections
  • Handling multiple headers and footers

Formatting the document

  • Implementing styles
  • Condensing the document to an outline and viewing the document map
  • Discovering themes

Automating documents and text

  • Exploring templates
  • Inserting and modifying Quick Parts and Building Blocks

Referencing and Navigating Documents

Streamlining document tasks

  • Customising document properties
  • Inserting cover pages
  • Creating the TOC
  • Adding watermarks

Implementing revision control

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

Producing Rapid Results with Excel

Leveraging Excel functionality

  • Taking advantage of the Function Wizard
  • Absolute versus relative addressing

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

  • Connecting to MS Access using MS Query
  • Extracting and correcting data types with formulas

Assembling mass mailings

  • Connecting to Excel data
  • Working with a template document
  • Producing the result documents: letters, envelopes and labels

Developing PowerPoint Presentations

Building a dynamic slide show

  • Best practices for creating presentations
  • Designing effective slides
  • Incorporating animation and sound
  • Exploring slide show options

Enhancing the slides

  • Applying themes
  • Setting up and refining master layouts

Enhancing documents with graphics

  • Leveraging SmartArt graphics
  • Employing text to create SmartArt graphics

Finalising and adding special effects

  • Adding slide transitions
  • Customising animation panes
  • Publishing the presentation

Document Security and Collaboration

Protecting documents

  • Setting up document restriction using encryption
  • Removing private and personal information
  • Enabling digital signatures

Safeguarding documents with the Trust Center

  • Manipulating the Document Inspector features
  • Configuring Trust Center options

SharePoint and Outlook

  • Linking Excel spreadsheets with SharePoint
  • Subscribing to RSS feeds in Outlook
 
http://www.learningtree.co.uk/courses/uk972.htm
 
 
0800 282 353 or +44 1372 364610
Productivity through Education®
 
 

Microsoft Office: Streamlining Tasks for Improved Productivity Tuition

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

Course Fees
£ 1,475 Standard Fee
Savings Plans
£ 1,000Flex-Training Pass
£ 75010-Day Training Pass
£ 1,520Voucher 10-Pack
£ 1,330Alumni Gold Discount
 

Your Course Fee Entitles You To...

  • Class participation
  • Team workshops
  • Use of in-class hands-on equipment
  • Comprehensive course materials
  • Morning and afternoon refreshments
  • Course Completion Certificate
  • FREE participation in the Learning Tree Professional Certification Programmes (including related exams)
  
 

Tuition Savings Plans

Flex-Training Pass
  • 3 Courses for £2,995
  • As little as £1,000
  • Savings as much as 50%
  • 3 courses in 24 months
10-Day Training Pass
  • Save as much as £895 per course
  • Any combination of courses
  • Only £2,495
Training Vouchers
  • Save as much as £625 per course
  • Fully transferable
  • As low as £1,520 per course
Alumni Gold Discount Attend your first course and you will receive a personalised Alumni Gold Discount card, entitling you to save as much as £210 on each course you take in the following 24 months. Take just one course every two years, and you will be entitled to ongoing discounts...year after year. You save 10%.
* Exact savings may vary depending on courses selected.

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 fee.

Enrolling is Easy and Flexible!

Enrol 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.learningtree.co.uk/courses/uk972.htm