Upgrading to Microsoft® Outlook, Word, and Excel 2007

Length: 1 day
Prerequisites: Familiarity and working knowledge with previous versions of Microsoft Office.

Target Student:  Take this course if you are upgrading to MS Office 2007 and use Outlook, Word and Excel on a regular basis.  This class covers all of the new and most commonly used features of this latest version of the Office Suite, with lots of surprises and useful tips along the way!

Course Content

Getting Familiar With Outlook 2007 New Features  
How To Use The Improved Navigation Pane       
How To Use The To-Do Bar         
How To Use The Instant Search
How To Use The Query Builder 
How To Use the Quick Access Toolbar
WORKING WITH MAIL AND RSS FEEDS  
Creating And Receiving Messages           
How To Create And Send Message In A New Screen Layout        
How To Preview Attachments   
 

Managing Emails Messages        
How To Create A New Color Category   
How To Assign A Color Category To A Message 
How To Set The Quick Click Category      
How To Assign A Quick Click Category    
How To Set A Follow-Up Flag For Recipients       
How To Use The Email Postmarks            
 

Using RSS Feeds in Outlook        
How To Add An RSS Feed From A Quick Link       
How To Add An RSS Feed Through Account Settings       
How To Read RSS Feeds               
How To Cancel An RSS Feed       
 

WORKING WITH THE CALENDAR              
Understanding The New Interface          
How To Navigate In The Calendar            
How To Create A New Calendar Entry    
How To Assign A Color Category For An Appointment    
Sharing Calendars           
How To Send A Calendar Snapshot In An E-mail Message             
How To Work With Multiple Calendars  
How To Open Multiple Calendars Side-by-Side  
How To Overlay The Calendars 
How To Add An Internet Calendar Subscription 
 

WORKING WITH CONTACTS AND TASKS               
Using The Electronic Business Cards       
How To Create An Electronic Business Cards       
How To Use An Image As A Background For A Card         
How To Insert An Electronic Business Card In A Message              
How To Receive Electronic Business Cards           
Working With Tasks       
How To Create A Task From An E-mail message
How To Create A To-Do Item From A Contact     
How To Create a Task In The Daily Task List In Calendar  
How To Assign A Color Category To A Task           
How To View Your Tasks in Tasks             
How To View Your Tasks In The To-Do Bar           
How To View Your Tasks In The Daily Task List In Calendar

 

Getting Familiar with Microsoft Word 2007 New Features

What’s New In Word 2007

Getting Familiar With The Word 2007 Screen

Using the Office Word 2007 Ribbon

How To Work With The Ribbon

How To Customize The Status Bar

How To Change The Views

How To Show And Hide Document Elements

How To Use The Zoom

How To Use The Compatibility Checker

How To Customize The Word Options

How To Save A Document In A Different File Format

How To Pin A Document

How To Document Workbook Properties

How To Diagnose And Repair Problems

 

FORMATTING DOCUMENTS

How To Format Text

How To Change Case

How To Apply A Quick Style

How To Create A New Style

How To Change A Style Set

How To Use A Theme

How To Change Theme Colors

How To Change Theme Fonts

How To Create A New Theme

How To Add A Cover Page

How To Add A Blank Page

How To Insert A Building Block

How To Create A Building Block (Quick Part and AutoText)

How To Use The Building Block Organizer

How To Change The Page Setup

How To Insert A Page Break Or A Section Break

How To Insert A Header Or A Footer

 

WORKING WITH TABLES AND CHARTS

How To Insert A Quick Table

How To Change A Table Style

How To Change The Table Layout

How To Insert A Chart

How To Edit The Data

How To Change A Chart Design

How To Change A Chart Layout

How To Save A Chart Template

 

         

WORKING WITH OBJECTS AND ILLUSTRATIONS

Working With Objects And Illustrations

How To Insert A Quote Or A Sidebar

How To Insert And Change A Picture Style

How To Apply A Shape To A Picture

How To Apply An Effect

How To Recolor A Picture

How To Insert A SmartArt

How To Use The SmartArt Text Pane

How To Change The Shape In A SmartArt

How To Change The SmartArt Style

How To Change The SmartArt Color

How To Change The SmartArt Layout

How To Convert An Embedded Object To A Previous Object Type

 

PROOFING AND PROTECTING A WORD DOCUMENT

How To Change The Proofing Options

How To Use Translate ScreenTip

How To Translate Text

How To Inspect A Document

How To Restrict Unauthorized Editing

How To Mark A Document As Final

 

Getting Familiar with Excel 2007 New Features
 Viewing the Excel 2007 Window
Using the Excel 2007 Ribbon

How To Work With The Ribbon

How To Customize The Status Bar

How To Change The Views

How To Show And Hide Workbook Elements

How To Use The Zoom

How To Use The Compatibility Checker

How To Save A Workbook

How To Save With A Different File Format

How To Document Workbook Properties

How To Change The Margin In The Page Layout View

How To Add A Header

How To Add An Image As A Watermark

 

Performing Calculations

How To Resize The Formula Bar

How To Use AutoComplete To Create Formulas

How To Turn Formula AutoComplete on or off

How To Insert Other Functions Using AutoSum Button

How To Create Names Using Create From Selection Button

How To Insert A Name In A Formula

How To Manage Names Using The Name Manager

How To Evaluate A Nested Formula

How To Use The Watch Window

 

Formatting Worksheets

How To Format The Data

How To Draw A Border To Cells

How To Use The Conditional Formatting To Highlight Cells

How To Use The Data Bars

How To Use The Color Scales

How To Use The Icon Sets

How To Edit The Rules

How To Change The Precedence Of The Rules

How To Stop A Rule

How To Clear The Rules

How To Apply A Built-in Cell Style

How To Create A Custom Cell Style

How To Apply A Custom Cell Style

How To Modify / Delete A Cell Style

How To Apply A Theme

How To Create New Theme Colors

How To Create New Theme Fonts

How To Select The Theme Effects

How To Save The Custom Theme

 

Working with Tables

Working With Tables

How To Create A Table

How To Format A Table

How To Create A New Table Style

How To Show Or Hide Table Elements

How To Create A Calculation In A Table

How To Insert And Delete Rows In A Table

How To Resize A Table

How To Sort The Data In A Table

How To Convert A Table To A Range

How To Create A PivotTable

How To Change The Layout Of A PivotTable

How To Change The Value Settings

How To Show Filtered Data

How To Change A PivotTable Options

 

Working with Illustrations and Charts

Working With Illustrations And Charts

How To Insert An Object And Apply A Style To It

How To Apply Shape To A Picture

How To Apply An Effect

How To Rearrange Objects Using The Selection Pane

How To Insert A SmartArt

How To Use The SmartArt Text Pane

How To Change  The Shape In A SmartArt

How To Insert A Chart

How To Edit Chart Data Source

How To Change A Chart Layout And Style

How To Modify  The Chart Elements

How To Format The Chart Elements

 

Click here for course cost and dates

 

BACK