e-academy – IT training excellence in Cardiff, Newport, Bristol and South Wales

Course details
Fee £115
Days 1
Code OFF07NF

There are currently no dates scheduled for this course.

However it can still be provided on a closed-company basis – or we may schedule it on demand. Please contact us for further information.

e-mail us
or call us on
0845 650 6500

Office 2007 New Feature

The Office 2007 New Feature training course is available at our Cardiff training centre in Wales, which is also within easy reach of Newport, Bristol and South WalesMicrosoft Certified Gold Partner for Learning Solutions

Examination information

  • There is currently no examination associated with this course

Course outline

 

Module 1: Outlook - Exploring the New Interface

  • The Navigation Pane
  • Working with the Ribbon
  • Quick Access Toolbar
  • Attachment Preview

 

Module 2: Organising Outlook Items

  • The To-Do Bar
  • Instant Search
  • Query Builder
  • Colour Categories

 

Module 3: New Calendar Features

  • Calendar Overlay
  • Daily Task List
  • Calendar Snapshots

 

Module 4: Excel - Exploring New Features

  • Hiding the Ribbon
  • Using KeyTips
  • Using Page Layout View

 

Module 5: New Conditional Formatting Features

  • Using Highlight Cell Rules
  • Managing Rules
  • Data Bars

 

Module 6: New Table Features

  • Creating a Table
  • Removing Duplicates

 

Module 7: New Formula Features

  • Using Formula AutoComplete
  • Viewing New Functions

 

Module 8: Using New Sort and Filtering Features

  • Sorting by Multiple Fields
  • Filtering to Find Above Average

 

Module 9: New Graphic Features

  • New Chart Features
  • Using SmartArt

 

Module 10: New File Format Features

  • Document Inspector
  • Marking a Workbook as Final
  • Saving as a PDF

 

Module 11: Word - Using New Features in Styles

  • Using Quick Styles
  • The Style Inspector
  • The Quick Style Gallery

 

Module 12: Formatting a Document with Themes

  • Selecting a Theme
  • Creating a Theme
  • Changing Theme Effects

 

Module 13: Using Quick Parts

  • Creating a Quick Part
  • Inserting Document Property Fields
  • Using Building Block Organiser

 

Module 14: Using New Chart Creation Features

  • Creating a Chart
  • Editting a Chart

 

Module 15: Working with Comments and Revision

  • Enabling Balloon Options
  • Showing Mark Up
  • Displaying the Reviewing Pane

 

Module 16: PowerPoint - Using SmartArt

  • Inserting SmartArt Objects
  • Formatting SmartArt

 

Module 17: Enhancing Slide Layout

  • Creating Custom Layout
  • Applying a Theme
  • Applying a Background Style
  • Changing Slide Orientation

 

Module 18: Access - Exploring Access

  • The New Database Environment
  • Using Tabbed Documents

 

Module 19: Creating and Working with Tables

  • Creating a Table in Datasheet View
  • Using Field Templates
  • Using Multi-Valued Fields in a Table
  • Displaying a Total Row

 

Module 20: Finding and Filtering Data

  • Using the Search Box
  • Using AutoFilter
  • Using QuickFilters
  • Changing a Control Property

 

Module 21: Working with Queries and Record Sets

  • Using Multi-Valued Fields in a Query
  • Displaying a Total Row

 

Module 22: Working with Forms

  • Creating a Form with the Create Tab
  • Using Form/Layout/DesignView
  • Splitting Forms

 

Module 23: Working with Reports

  • Creating a Report with the Create Tab
  • Grouping and Sorting
  • Displaying Report Totals

 

Module 24: Working with Macros

  • Displaying the Macro Design Arguement
  • Using Embedded Macros
  • Exploring Increased Security
  • Using Error Checking
  • Using Smart Tags

 

Module 25: Using Data Collection by Email

  • Using Data Collection
  • Settting Data Collection Options
  • Processing Replies