|
Onsite Microsoft Office 2007 Training - we come to you! |
|
 |
Microsoft Office 2007 Training
Microsoft
Office 2007 offers a brand new
user interface as well as considerable
enhancements to the Office suite
of applications - Word, Excel,
PowerPoint, Outlook etc. This
course introduces you the major
changes and enhancements and
will enable you to get the best
out of your new software.
A one day course, covering
Microsoft Word 2007, Microsoft
Excel 2007, Microsoft PowerPoint
2007,Outlook 2007 and Access
2007. The course mixes demonstration
and hands-on practise.
*If you require a different
mix of applications say Access,
Publisher and Word, we can deliver
this on request.
For pricing click here |
|
|
|
Microsoft Office 2007 Application Specific Courses |
|
|
|
|
|
Course Outline |
The
New Office 2007 Interface and
Shared Features |
Download
a pdf of this course outline
for filing and future reference
- The Ribbon and Ribbon Tabs
- Minimising and maximising
- Key tips and shortcut
keys
- Standard vs contextual
tabs
- Live Preview
- Dialogue Box/ Task
Pane launchers
- The Office Button
- The Mini-Toolbar
- Quick Access Toolbar
- Adding and removing
buttons
- Customising the Quick
Access Toolbar
- New Customising Options
For The Status Bar
- New Documents
- Creating new Office
documents
- Downloading on-line
templates
- Opening Existing Documents
- Set the default location
- Set the number of recently
opened files listed in
the open menu
- Pin documents to the
recently opened documents
menu
- Opening a document
created in a previous
version of Microsoft Office
– using compatibility
mode
- Arranging Windows
- The View Tab
- Switch Windows
- Arrange All
- Compare side by side
- Getting Help
- Help connection to Office
online status
- Saving Files In Office 2007
- Saving 97-2003 files
in compatibility mode
- Saving 2007 files in
the new XML format
- Compatibility checker
- Setting the default
save format
- Setting the default
file location
- Saving a document as
a PDF
- Marking a document
as final
- Switching Views
- The View Selector on
the status bar
- The View tab
- The Zoom controls
- Document Recovery
- The Document recovery
task pane
- AutoRecover setting
- Repairing Problems
- Microsoft Office Diagnostics
- Exiting Documents And Applications
- Where to find…
- Copy, cut and paste
- The Office clipboard
- Find and replace –
the new highlight all
feature
- Autocorrect settings
- Proofing tools –
spelling checker, thesaurus
- Symbols
- Undo, redo
- Print preview
- Clip Art and pictures
- WordArt
- Autoshapes
- Formatting options
– alignment, font
size etc
- New Formatting Features
- Quick styles
- Office shapes
- Picture effects
- Themes
- SmartArt Graphics
|
|
|
Microsoft
Word 2007 |
- Views
- New options in Full
Screen View
- The new Draft View
- Displaying rulers
- Finding Page Layout Options
- Page Size
- Margins
- Page breaks
- Headers and Footers
- Columns
- Page Borders
- Finding Table Creation Options
- Table quick style and
effects
- Finding Mailing Options
- Letters and envelopes
- Mail merge
- Finding Reference Options
- Table of Contents
- Footnotes
- Bookmarks
- Cross references
- Finding Track Changes Options
- Compare and Merge
- Track Changes
- Advanced Formatting
- Styles and Style Sets
- Text wrapping options
- New Features
|
|
|
Microsoft
Excel 2007 |
- Finding Basic Editing Functions
- Clearing cell contents
- Deleting and inserting
cells, columns, rows and
sheets
- Go to Special
- Finding Formatting Functions
- Adjusting column width/
row height
- Hiding/unhiding columns
and rows
- Freezing Panes
- Formatting numbers
- Text flow
- Borders and fills –
New Draw a Border feature
- New Cell Styles
- Conditional Formatting
– New improved features
- New – split cells
- Finding View Options
- Show rulers
- Show gridlines
- Show Formula Bar –
new adjustment settings
- Show Headings
- New – Page Layout
View
- Finding Lists And Database
Options
- Custom list options
- Naming cells and ranges
with the New Name Manager
- Manage Data Table with
the New Insert Table option
- Sorting data –
New Sort Options (sort
by colour)
- Filtering data –
Improved Filtering Options
- Finding Function Options
- The Functions Library
- Formula AutoComplete
- Table reference
- Nested functions to
64 levels
|
|
|
Microsoft
PowerPoint 2007 |
- Finding Slide Management
Options
- Creating new slides
- Changing slide layout
- Finding Content Editing
Options
- New – selecting
non-contiguous text
- Rearranging slides
- Using slides from other
presentations
- Finding Content Formatting
Options
- Modifying text
- Text rotation and stacking
- Indenting/outdenting
text
- Creating text columns
- Line and paragraph
spacing
- Master slides
- Finding How to Insert Objects
Into Slides
- Tables
- SmartArt
- Charts (now uses Excel)
- WordArt
- Sound
- Movies
- Headers and Footers
- The Selection Pane
- Finding The Animation Options
- Transitions
- Standard Animation
- Custom Animations and
Timings
- Slide Timings
- Finding Slide Show Options
- Setting up a show
- Custom Shows
- Starting a slide show
- !6:9 screen ratio
- Finding Other Output Options
|
|
|
Microsoft
Outlook 2007 |
- Finding E-mails Options
- Formatting E-mails
- Attaching Items to
E-mails
- Inserting Other Content
Into E-mails
- Addressing E-mails
- Setting Message Delivery
and Security Options
- Managing Your Inbox
- Quick Flag
- Categorising messages
by colour
- Instant search
- View attachments from
within the Reading Pane
- Scheduling Out of Office
in Advance
- Working with the Calendar
- Related tasks appear
at the bottom of the calendar
- E-mailing a snap shot
of your calendar
- Overlaying multiple
calendars to compare
- Other New Features
- Business Cards
- Colour categories
|
|
|
|
Microsoft
Access 2007 |
- Creating and Viewing Databases and
Objects
- Creating databases
- Creating Objects
- Switching views
- The Navigation Pane
- Tabbed Documents
- Display Options
- Object Dependency Pane
- Database Management
- Backing up
- Compacting and repairing
- New Table Features
- Total Row
- Date selector
- New sort and filter options
- Formatting a datasheet
- Changing the datasheet defaults
- New Form Features
- Creating a form
- The new layout view and features
- Add fields
- Changing field properties
- New Report Features
- Creating a report
- The new layout view and features
- Add fields
- Changing field properties
- Adding sorts and groups
- Adding Totals
|
|
|
|
|
Onsite Microsoft Office Training |
Microsoft
Office Computer Training Courses throughout Surrey, Sussex, Hampshire, Kent, Essex, Berkshire, Buckinghamshire, Dorset, Hertfordshire, Oxfordshire, Wiltshire and London including Crawley, Brighton, Portsmouth, Southampton, Winchester, Farnham, Guildford, Basingstoke, Salisbury, Bournemouth, Poole, Dorchester, Tunbridge Wells, Ashford, Canterbury, Maidstone, Gravesend, Croydon, Kingston-upon-Thames, Reading, Newbury, Oxford, Watford, Hemel Hempstead, Dartford, Stevenage, Milton Keynes, Basildon, Chelmsford, Southend on Sea and Colchester.
|
|
|
|
|