Please enter a date range below to find available courses
From to
Provider: 1816
Office 2007 New Features
Course aim
The skills and knowledge covered in this upgrade course will allow participants to familiarise themselves with the changes and new features introduced in MS Office 2007. This course provides an overview of the new functionality that is intended to be a demonstration of the possibilities.
Course outline
---THE OFFICE 2007--- • The Office Button • Access Keys & The Ribbon • Using the Quick Access Toolbar • Understanding & Using Live Preview & Help • Customising the Status Bar • Understanding View Options • Zooming • What Happened To? ---MS WORD 2007--- • What’s New • The Word 2007 Screen & Ribbon • Creating New Documents • Using the Compatibility Checker • Word 2007 Options • Using the Mini-Toolbar • Quick Style Gallery, Working with Themes • Adding a Cover Page, Colour & Borders Working with Illustrations • Inserting Pictures & Changing Atyles • Using ClipArt & SmartArt • The SmartArt Text Pane & Changing Style • The SmartArt Tools Format Tab • Resizing & Moving SmartArt Using Tables in Word 2007 • Inserting a Quick Table • Using Table Style & Layout • Inserting & Drawing Tables Proofing and Printing • Changing the Page Setup • Inserting Section Breaks • Using & Saving Headers & Footers • Printing • Using Spell Checker ---MS EXCEL 2007--- • New Features • The Excel 2007 Screen & Ribbon • Creating New Workbooks • Using the Compatibility Checker • Excel 2007 Options • Changing the View Formatting in Excel 2007 • Using the Home Tab • Commands to Format Data • Merging Cells • Themes • Cell Styles & Highlight Cell Rules • Conditional Formatting • Using Data Bars Working with Formulas • Expanding the Formula Bar & Name Box • Using the Formulas Tab & Names
• Using AutoComplete to Create Formulas • Using the Name Manager Working with Tables • Creating & Modifying a Table • Inserting or Deleting Rows • Sorting Data in a Table & Filtering Creating Charts in Excel 2007 • Creating & Saving a New Chart • Changing Layout & Formatting Elements Using PivotTables • Creating a PivotTable Report • Adding Fields & Applying a Filter • PivotTable Design Options • Creating a PivotChart from a Report ---MSPOWERPOINT 2007--- • New Features in PowerPoint 2007 • The PowerPoint 2007 Screen & Ribbon • Creating New Presentations • PowerPoint 2007 Options Working with PowerPoint 2007 • Changing the View & Presentation Theme • Backgrounds & Formatting Text • Inserting New Slides • Slide Masters & Inserting a Slide Layout Illustrations and Tables • Using SmartArt Graphics • Creating a Table & Photo Album • Inserting a Chart Animation and Slide Shows • Setting up Slide Shows & Tansitions • Applying Custom Animation ---MS OUTLOOK 2007--- • New Features • Opening an Outlook Data File • The Outlook 2007 Screen • The Navigation Pane & The To-Do Bar • Using Instant Search & Expanding Search • RSS Feeds Working with Mail • Creating New Messages • Previewing Attachments • Colour Categories Assigning a Colour • Setting the Quick Click Category • Flagging Messages Working with Calendar • Calendar Views • Creating a New calendar Entry • Task Integration on the Calendar • Creating a Calendar Snapshot • Working with Multiple Calendars • Scheduling Meetings Working with Contacts • Creating an Electronic Business Card • Sending & Receiving Business Cards
Pre-requisites
Pre-Requisites
It is assumed that the participant has a medium working knowledge with one or more previous versions for MS Office. A working knowledge of the Windows
operating system and basic mouse and keyboard skills are also required.