Upgrading to Office 2007
Existing users of previous versions of Microsoft Office will learn new skills, tips and shortcuts to harness the power of Office 2007. Be more productive across the full suite of Office applications.
Quick Facts
Duration: 2 Days
Class Size: 10
Level: Int / Adv
Times: 9.00am - 5.00pm approx
About the Course
During this 2 day course, instructors will take you through the changes in Microsoft Office 2007. You will learn to master all the new features introduced in Word, Excel, PowerPoint and Outlook.
Who should do this course?
This course is designed for people who are upgrading to Microsoft Office 2007 from previous versions (such as Office 2003), and need to understand the changes and new features introduced.
Prerequisites
As this is an upgrade course it is assumed that the participant 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 Units
- Unit 1: Microsoft Office 2007
- - The Office Button
- - Using the Office Button
- - Access Keys
- - Using Access Keys
- - The Ribbon
- - Understanding Help
- - Using Help
- - Understanding Live Preview
- - Using Live Preview
- - Customising the Status Bar
- - Understanding View Options
- - Using Full Screen Reading View
- - Zooming
|
- Unit 2: 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
- - 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
|
- Unit 3: Using Tables in Word 2007
- - Inserting a Quick Table
- - Using Table Styles
- - Changing the Table Layout
- - Inserting a Table
- - Drawing Tables
|
- Unit 4: 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
|
- Unit 5: 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
|
- Unit 6: 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
|
- Unit 7: 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
|
- Unit 8: 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
|
- Unit 9: Working with Tables
- - Creating a Table
- - Inserting or Deleting Rows
- - Modifying a Table
- - Sorting Data in a Table
- - Filtering
|
- Unit 10: 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
|
- Unit 11: 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
|
- Unit 12: 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
|
- Unit 13: 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
|
- Unit 14: Illustrations And Tables
- - Using SmartArt Graphics
- - Creating a Table
- - Inserting a Chart
- - Modifying a Chart
- - Creating a Photo Album
|
- Unit 15: Animation And Slide Shows
- - Setting Up Slide Shows
- - Narration
- - Setting Slide Transitions
- - Applying Custom Animation
|
- Unit 16: 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
|
- Unit 17: 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
|
- Unit 18: 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
|
- Unit 19: Working with Contacts
- - Electronic Business Cards
- - Creating an Electronic Business Card
- - Sending and Receiving Business Cards
- - Managing Electronic Business Cards
|
-
|
Upcoming Courses
|
Sydney
Level 11, 32 Walker Street
North Sydney
View map
|
- Date:
- 23-24 Sep 10
- 17-18 Nov 10
|
|
Melbourne
Level 12, 379 Collins Street
Melbourne
View map
|
- Date:
- 30 Sep - 01 Oct 10
- 25-26 Nov 10
|
|
Brisbane
C/- Training Choice, Mezzanine Level, 88 Creek Street
Brisbane
View map
|
- Date:
- 18-19 Oct 10
|
|
Canberra
C/- Training Choice, Level 4, 54 Marcus Clarke Street
Canberra
View map
|
Date: upon demand
|
|
Adelaide
C/- Mindfull Computer & Seminar, Level 4, 74 Pirie Street
Adelaide
View map
|
Date: upon demand
|
|
Perth
C/- Training Choice, Level 7, 105 St Georges Terrace
Perth
View map
|
Date: upon demand
|
Duration: 2 Days
Class Size: 10
Level: Int / Adv
Times: 9.00am - 5.00pm approx
