 |
Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
 |
|
 |
| |
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
- Navigating the Ribbon and Dialog Launcher
- Setting defaults with the Office button
- Customising 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
- Summarising 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 summarising 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 text from other programs
- Applying 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
- Customising 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
|
|
|
|
|
|
| |
| Customer Service or Enrol: 0800 282 353 or +44 1372 364610 |
|
|
Print Friendly
E-mail a Colleague
Course PDF
Course FAQ
Home
