Upgrade 2003-2007

Course Duration

Duration – 1 Day. Course timings 0930-1630 (approximate)

Course Aims

This course will provide delegates with a view of the new features and functions of Microsoft Office 2007 applications, including Word, Excel, PowerPoint, Outlook.

Pre-requisites

Although no in-depth knowledge or experience of Microsoft Office is assumed or required, it would be beneficial to have a workable knowledge of Office and its applications.

Target Audience

This course is designed for new users who wish to understand the new features and functions of Microsoft Office 2007.

Content/Topics

The Microsoft Office 2007 Upgrade course will cover the following topics enabling delegates at the end of the course to be able to:

—————————————————————————————————————————————————————

Office 2007 Environment

Exploring the Fluid User Interface
Ribbon
Groups
Dialog Box Launcher
Galleries
Customise the Quick Access Toolbar
Mini Toolbar
Live Preview
Zoom Slider
Views
Status Bar
Compatibility Checker
Contextual Tabs
Backstage View
                Info
                Recent
                New
Print & Print Preview
                Save and Send
Help
                Options

Excel

Excel Screen
Excel New Data Limits
Creating New Workbooks
New File Formats
Formula Bar
Excel Options
New View
Create PDF/XPS
Paste with Live Preview
Name Manager
Chart Creation
Table Creation
Pivot Tables
Sumifs & Countifs &Averageifs Functions
Iferror Functions
Filtering
                Text
                Colour
Sort
                Text
                Colour
Conditional Formats
                New Rules
                Manage Rules
                Clearing Rules
                Icon Sets
                Data Bars
                Colour Scales
Formula Construction

Word

Full Screen Reading View
Navigation Pane
Text Effects
Character Spacing
Paste with Live Preview
Create PDF/XPS
New Customised Numbering Lists
Watermarks
New Text Boxes
Cover Pages
AutoText and Quick Parts
Document Inspector
Themes
New File Formats
Building Blocks
Tables
Illustrations
SmartArt

Outlook

Panes
To Do Bar
People Pane
Maximise-Minimise Panes
Pane Options
Arranging Emails
Instant Search
Flagging
Categorise
Quick Category
Conversations
Calendars
Calendars Overlay
International Dates
Schedule Meetings
Contacts
Creating Electronic Business Cards
MapIt

PowerPoint

Changing Views
Text Box Rotation
Copy between Presentations
Presentation Sections
Smart Guides
Slide Masters
Insert Video
Add Bookmarks to Video
Format Video
Compress Presentation
Picture Presentation
SmartArt
3D Slide Transitions
Build Animations
Control Animations Individual Objects
Animation Painter
Narrations
Broadcast Presentation