Course Outline MS Office 2007
Duration: 2 Days
Introducing the 2007 Microsoft Office System
Module 1: Time for Something New
The Changing Way We Work
The Changing Nature of the Microsoft Office System
Meeting Today’s Work Challenges
Finding What You Need to Make Educated Business Decisions
Prioritizing Your Work Efforts—Weeding Out the Irrelevant
Connecting to the Right People and Getting the Job Done
Learning and Using Flexible Tools for Varying Experience Levels
The Microsoft Office 2007 —Tools for Today
New Version of Microsoft Office 2007
Upgrading to the Microsoft Office 2007
Benefits of Microsoft Office 2007
A Lower Learning Curve
Legacy Mode and Keyboard Support
Create It Once; Use It Many Times
Module 2: A New Look
The Microsoft Office 2007 User Interface
Using the New User Interface
Command Tabs
Command Sets
Contextual Tools
Dialog Launchers
Galleries
Live Preview
The New File Menu
Quick Access Toolbar
New View Controls
Keyboard Support
Key Tips
Keyboard Shortcuts
Module 3: Important Systems: Help and Security
Finding Help in All the Right Places
Changes in the 2007 Release Help System
More than a Name: Super Tool tips
New Offerings from Microsoft Office Online
Safeguarding Your Files
Publishing Your Document in PDF or XPS Format
Finishing and Protecting Your Files
Removing Personal or Private File Information
Adding a Digital Signature
Marking a Document as Final
Old-Fashioned Document Protection
Module 4: Microsoft Office Word 2007
Module 4.1: Section Breaks
Creating sections within a document
Viewing and deleting section breaks within a document
Module 4.2: Columns
Creating multiple column layouts
Additional column formatting options, width and spacing
Applying and deleting column breaks
Module 4.3: Tables
Creating a table
Sorting data within a table
Formulas and tables
Merging and splitting cells within a table
Merging cells
Splitting cells
Module 4.4: Mail Merge
Starting the Mail Merge Wizard
Using the Mail Merge Wizard
Creating a mailing list to be used within a mail merge
Merging a mailing list to produce labels
Module 5: Microsoft Office Excel 2007
Module 5.1: Manipulating Data, Named Ranges & Templates
Paste Special Techniques
Importing a text file and delimiting
Module 5.2: Named Ranges
What does naming a cell range mean?
Rules for naming cells and ranges
Naming cell range(s) in a worksheet
Navigating through workbooks using named ranges
Creating named ranges automatically based on cell values
Module 5.3: Sub-Totalling
Creating subtotals
Removing subtotals
Module 5.4: Advanced Formatting & Display Techniques
Cell Styles
Table Styles
Conditional Formatting
Custom number formats
Freezing row and column titles
Hiding and un-hiding rows and columns
Hiding / un-hiding worksheets
Module 5.5: Sorting and Querying Data
Sorting data by multiple columns
Custom sorts
Using AutoFilter
Using advanced query / filter options
Module 5.6: Linking & Embedding Data
Linking data or a chart within a worksheet
Linking data or a chart between worksheets [within a workbook]
Linking data or a chart between spreadsheets [workbooks]
Linking data or a chart into a word processing document
Consolidating data in adjacent worksheets using a 3D sum function
Module 5.7: Charts Formatting Techniques
Changing pie slide angles
Formatting chart axis fonts and scales
Chart title
Chart legend
Modifying a Data Series in a Chart
Module 5.8: Workbook Password Protection
Password for opening a workbook
Read-only recommended
Module 5.9: Protecting / Un-Protecting Worksheets
Protect worksheet elements
Removing workbook protection
Module 5.10: Functions
Getting help with using a particular function
SUMIF
COUNT
COUNTIF
HLOOKUP
VLOOKUP
IF
Using nested functions
Module 5.11: Using One-Input or Two-Input Data Tables / What-If Tables
One input Data Table command
Two input data table command
Module 5.12: Pivot Tables
Creating a PivotTable
Dropping data into the Pivot Table
Modifying data and refreshing the Pivot Table
Grouping data within a Pivot table
Module 5.13: Scenarios
Creating named Scenarios from defined cell ranges
Viewing an alternative scenario
Creating a scenario summary
Module 6: Microsoft Office PowerPoint 2007
Module 6.1: Slide Show Animation Effects
What are animation effects?
Applying animation effects to text
Applying animation effects to illustrations
Custom animation
Changing the sequence of animation within a slide
Module 6.2: Slide Show Manipulation
Inserting Action Buttons
Setting Mouse over properties
Practicing slide timings
Using slide timings
Slide show looping options
Hiding slides
Displaying hidden slides
Annotating slide shows
Creating a custom slide show
Editing a custom slide show
Running custom slide shows
Module 6.3: Templates and Slide Masters
Templates, Slide Masters and Themes
Creating and saving a template
Modifying a Slide Master
Creating footers and inserting the date
Handout and Notes Masters
Modifying the Handout Master
Modifying the Notes Master
Module 6.4: Slide Manipulation
Merging slides or complete presentations
Merging a word-processed outline into a presentation
Applying graduated background fill colours, texture & patterns
Saving a slide in gif, jpeg or bmp format
Module 7: Microsoft Office Outlook 2007
Module 7.2: Inbox
Organizing the Inbox
Rules wizard
Mailbox management
Email methods
Module 7.1: CALENDAR
Calendar Overview What Is the Calendar? Calendar Items Calendar Views
Work With the Calendar
The Calendar Window Appointments Area Date Navigator
Use the Date Navigator
Use the Go Menu & Auto Date
Print Your Calendar Schedule Appointments Make An Appointment
Make Recurring Appointment Assign Categories to Appointments
Appointment Labels
Format Appointments Automatically
Schedule Meetings
Schedule A Meeting
Schedule A Resource
Adding & Removing Attendees Respond To A Meeting Request Schedule Events
Schedule An Event
Module 7.2: TASKS & NOTES
Work With Tasks The Tasks Folder Task Views
Create & Update Tasks Organize Tasks By Category Assign Tasks
Assigning Tasks
Assign A Task
Accept, Decline Or Delegate Tasks
Work With Notes
The Notes Folder
Create & Edit A Note
Assign Contacts & Categories To
Notes
Organize Notes
Module 7.3: Advanced CALENDAR
Customize The Calendar Calendar Options Customize Calendar Views
Share Calendar Information
Permissions
Open Another User’s Calendar
Share Your Calendar
Set Private Appointments
Use Multiple Calendars
Creating Additional Calendars Side-By-Side Calendars Manage Meetings
Update A Meeting
Cancel A Meeting
Module 7.4: Advanced TASKS
Manage Tasks Assigning Tasks Assign A Task
Create & Update A Task Change Task Details Track Assigned Tasks
View Another User’s Task List
Send Task Information
