Forsythes IT & Training Newcastle
About Us Courses Schedules Learning Options Certifications Training Rooms Skills Testing Case Studies Events Contact Us
 Training Information Technology Forsythes Group
Courses & Certifications

Desktop Applications
Microsoft Product Courses
Microsoft Word Courses
Microsoft Excel Courses
Microsoft Access Courses
Microsoft Outlook Courses
Microsoft Project Courses
MS PowerPoint Courses
Updating to Office 2007
InfoPath 2003
Microsoft Visio
Microsoft Publisher
Microsoft Frontpage
Windows XP
Adobe Product Courses
Adobe Acrobat 8
Adobe InDesign CS
Photoshop CS Courses
Adobe Photoshop CS-3
Adobe Illustrator CS
Adobe Flash CS3
Dreamweaver 8
Dreamweaver MX
MYOB Accounting
Corel Draw v12
Crystal Reports Level 1
Crystal Reports Level 2
Technical
Professional Development



Need further information on Microsoft Office 2007 Courses?
Click here
Enrollment form PDF Document

Upgrading to Microsoft Office 2007 Word, Excel, PowerPoint and Outlook

Course start date:09-Oct-2008, 05-Nov-2008, 03-Dec-2008
Duration:1 day
Price: $440.00 Inc GST

Overview

The skills and knowledge covered in this publication will allow you to become quickly proficient in the changes and new features introduced in Microsoft Office 2007.

At the completion of Upgrading to Microsoft Office 2007 you should be able to:
  • work within the new Office 2007 user interface
  • use the new features in Word 2007
  • create tables using the new features in Word 2007
  • use the new methods for proofing and printing documents
  • insert and work with illustrations
  • identify and work with the new features available in Microsoft Excel 2007
  • use new formatting features in Excel 2007
  • use the Formulas tab to create and manage formulas and functions
  • create, format, sort and filter tables in a workbook
  • create and manage charts in Excel 2007
  • create and manipulate PivotTable reports
  • work with the new features available in Microsoft PowerPoint 2007
  • work with the new design features available in Microsoft PowerPoint 2007
  • use the new illustration and table features within PowerPoint 2007
  • animate and run a slide show
  • use the new time management and information features in Outlook 2007
  • use the new features in Outlook 2007 mail
  • use the new and improved features of the Outlook 2007 calendar and scheduling
  • create and manage contact information using the new Electronic Business Card feature
TARGET AUDIENCE

Upgrading to Microsoft Office 2007 is designed for people who are upgrading to Microsoft Office 2007 and need to understand the changes and new features in Word, Excel, PowerPoint and Outlook.

Prerequisites

As this is an upgrade course it is assumed that the reader has some familiarity with one or more previous versions of Microsoft Office. It would also be beneficial to have a general understanding of personal computers and the Windows operating system as you will be required to start applications, work with and copy files and locate file folders.

Course Outline
Microsoft Office 2007
  • The Office Button
  • Using The Office Button
  • Access Keys
  • Using Access Keys
  • The Ribbon
  • Using The Quick Access Toolbar
  • Understanding Help
  • Using Help
  • Understanding Live Preview
  • Using Live Preview
  • Customising The Status Bar
  • Understanding View Options
  • Using Full Screen Reading View
  • Zooming
  • What Happened To
Microsoft Word 2007
  • What’s New In Word 2007
  • The Word 2007 Screen
  • Creating New Documents
  • Word 2007 File Formats
  • Using The Compatibility Checker
  • Word 2007 Options
  • The Word 2007 Ribbon
  • More On The Word 2007 Ribbon
  • Using The Ribbon
  • Using The Mini-Toolbar
  • The Quick Styles Gallery
  • Changing Style Sets
  • Changing The Colours Theme
  • Changing The Fonts Theme
  • Themes
  • Working With Themes
  • Creating New Themes
  • Adding A Cover Page
  • Inserting A Blank Page
  • Page Colour And Borders
  • Building Blocks
Using Tables In Word 2007
  • Inserting A Quick Table
  • Using Table Styles
  • Changing The Table Layout
  • Inserting A Table
  • Drawing Tables
Proofing And Printing
  • Changing The Page Setup
  • Inserting Section Breaks
  • Using Headers And Footers
  • Odd And Even Headers And Footers
  • Adding Page Numbers
  • Saving A Header Or Footer To The Gallery
  • Printing
  • Using The Spell Checker
Working With Illustrations
  • The Illustrations Group
  • Inserting A Picture
  • Changing The Picture Styles
  • Using ClipArt
  • SmartArt
  • Inserting SmartArt
  • The SmartArt Text Pane
  • Changing The SmartArt Style
  • Changing The Colour Of SmartArt Styles
  • Changing The SmartArt Layout
  • Adding A New Shape To A
  • SmartArt Graphic
  • The SmartArt Tools Format Tab
  • Resizing And Moving SmartArt
Microsoft Excel 2007
  • New Features In Excel 2007
  • More New Features In Excel 2007
  • The Excel 2007 Screen
  • The Excel 2007 Ribbon
  • More On The Excel 2007 Ribbon
  • Creating New Workbooks
  • Excel 2007 File Formats
  • Using The Compatibility Checker
  • Excel 2007 Options
  • Changing The View
Formatting In Excel 2007
  • Using The Home Tab Commands To Format Data
  • Merging Cells
  • Themes
  • Cell Styles
  • Modifying Built-In Cell Styles
  • Saving A Workbook As A Template
  • Conditional Formatting
  • Highlight Cell Rules
  • Using Data Bars
  • Using Colour Scales And Icon Sets
  • Managing Rules
Working With Formulas
  • Expanding The Formula Bar And Name Box
  • The Formulas Tab
  • Using The Formulas Tab
  • Using Names In Formulas
  • Using AutoComplete To Create Formulas
  • New Statistical Formulas
  • Using The Name Manager
  • Using The Watch Window
Working With Tables
  • Creating A Table
  • Inserting Or Deleting Rows
  • Modifying A Table
  • Sorting Data In A Table
  • Filtering
Creating Charts In Excel 2007
  • Creating A New Chart
  • Changing The Chart Layout
  • Formatting Chart Elements
  • Moving A Chart To A New Location
  • Saving A Chart Template
Using PivotTables
  • Creating A PivotTable Report
  • Adding Fields To A PivotTable
  • Applying A Filter To A PivotTable
  • Changing The PivotTable Value Settings
  • PivotTable Design Options
  • Creating A PivotChart From A Report
Microsoft PowerPoint 2007
  • New Features In PowerPoint 2007
  • More New Features In PowerPoint 2007
  • The PowerPoint 2007 Screen
  • The PowerPoint 2007 Ribbon
  • More On The PowerPoint 2007 Ribbon
  • Creating New Presentations
  • PowerPoint 2007 File Formats
  • PowerPoint 2007 Options
Working With PowerPoint 2007
  • Changing The View
  • Changing The Presentation Theme
  • Backgrounds
  • Inserting New Slides
  • Formatting Text
  • Slide Masters
  • Inserting A Slide Layout
  • Saving A PowerPoint Template
Illustrations And Tables
  • Using SmartArt Graphics
  • Creating A Table
  • Inserting A Chart
  • Modifying A Chart
  • Creating A Photo Album
Animation And Slide Shows
  • Setting Up Slide Shows
  • Narration
  • Setting Slide Transitions
  • Applying Custom Animation
Microsoft Outlook 2007
  • New Features in Outlook 2007
  • More New Features in Outlook 2007
  • Opening an Outlook Data File
  • The Outlook 2007 Screen
  • The Navigation Pane
  • The To-Do Bar
  • Using Instant Search
  • Expanding the Search
  • Recent Searches and Searching the Desktop
  • Search Options
  • Searching Other Outlook Items
  • RSS Feeds
Working with Mail
  • Mail Messages
  • Creating New Messages
  • Previewing Attachments
  • Colour Categories
  • Assigning a Colour Category
  • Setting the Quick Click Category
  • Flagging Messages
  • Managing Follow-Ups in the To-Do Bar
  • Setting a Follow-Up Flag for Recipients
Working with the Calendar
  • Calendar Views
  • Creating a New Calendar Entry
  • Task Integration on the Calendar
  • Internet Calendars
  • Creating a Calendar Snapshot
  • Internet Calendar Subscriptions
  • Working with Multiple Calendars
  • Scheduling Meetings
Working with Contacts
  • Electronic Business Cards
  • Creating an Electronic Business Card
  • Sending and Receiving Business Cards
  • Managing Electronic Business Cards
Print this course

Forsythes IT & Training provides instructor led computer training on the Microsoft Office and Adobe range of applications.
We service Newcastle, the Hunter Valley, Lake Macquarie and the Central and Northern Coasts of New South Wales (NSW) Australia. With our mobile training room we can provide a range of courses on-site at your premises.

Privacy Policy Terms & Conditions Site Map Links & Resources Home Website Design - Indelible Image