This one-day instructor-led training course will provide a through understanding of the Office 2007 concepts and skills that will enable the participant to effectively use Microsoft Office 2007 including group and individual instruction, hands-on practical exercises, visual aids, and comprehensive training manuals and materials.
Skills Gained:
This course aims to make the user of previous versions of Microsoft Office proficient in the use and operation of Microsoft Office 2007.
Course Modules:
Microsoft Office 2007 • The Office Button • Using The Office Button • Access Keys • Using Access Keys • The Ribbon • Using The Quick Access Toolbar • Understanding Help • Using Help • Understanding Live Preview • Using Live Preview • Customising The Status Bar • Understanding View Options • Using Full Screen Reading View • Zooming • What Happened To...
Microsoft Word 2007 • What's New In Word 2007 • The Word 2007 Screen • Creating New Documents • Word 2007 File Formats • Using The Compatibility Checker • Word 2007 Options • The Word 2007 Ribbon • More On The Word 2007 Ribbon • Using The Ribbon • Using The Mini-Toolbar • The Quick Styles Gallery • Changing Style Sets • Changing The Colours Theme • Changing The Fonts Theme • Working With Themes • Creating New Themes • Adding A Cover Page • Inserting A Blank Page • Page Colour And Borders • Building Blocks
Using Tables In Word 2007 • Inserting A Quick Table • Using Table Styles • Changing The Table Layout • Inserting A Table • Drawing Tables
Proofing And Printing • Changing The Page Setup • Inserting Section Breaks • Using Headers And Footers • Odd And Even Headers And Footers • Adding Page Numbers • Saving A Header Or Footer To The Gallery • Printing • Using The Spell Checker
Working With Illustrations • The Illustrations Group • Inserting A Picture • Changing The Picture Styles • Using ClipArt SmartArt • Inserting SmartArt • The SmartArt Text Pane • Changing The SmartArt Style • Changing The Colour Of SmartArt Styles • Changing The SmartArt Layout • Adding A New Shape To A SmartArt Graphic • The SmartArt Tools Format Tab • Resizing And Moving SmartArt
Microsoft Excel 2007 • New Features In Excel 2007 • More New Features In Excel 2007 • The Excel 2007 Screen • The Excel 2007 Ribbon • More On The Excel 2007 Ribbon • Creating New Workbooks • Excel 2007 File Formats • 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 • Modifying Built-In Cell Styles • Saving A Workbook As A Template • Conditional Formatting • Highlight Cell Rules • Using Data Bars • Using Colour Scales And Icon Sets • Managing Rules
Working With Formulas • Expanding The Formula Bar And • Name Box • The Formulas Tab • Using The Formulas Tab • Using Names In Formulas • Using AutoComplete To Create Formulas • New Statistical Formulas • Using The Name Manager • Using The Watch Window
Working With Tables • Creating A Table • Inserting Or Deleting Rows • Modifying A Table • Sorting Data In A Table • Filtering
Creating Charts In Excel 2007 • Creating A New Chart • Changing The Chart Layout • Formatting Chart Elements • Moving A Chart To A New Location • Saving A Chart Template
Using PivotTables • Creating A PivotTable Report • Adding Fields To A PivotTable • Applying A Filter To A PivotTable • Changing The PivotTable Value Settings • PivotTable Design Options • Creating A PivotChart From A Report
Microsoft PowerPoint 2007 • New Features In PowerPoint 2007 • The PowerPoint 2007 Screen • The PowerPoint 2007 Ribbon • Creating New Presentations • PowerPoint 2007 File Formats • PowerPoint 2007 Options
Working With PowerPoint 2007 • Changing The View • Changing The Presentation Theme • Backgrounds • Inserting New Slides • Formatting Text • Slide Masters • Inserting A Slide Layout • Saving A PowerPoint Template
Illustrations And Tables • Using SmartArt Graphics • Creating A Table • Inserting A Chart • Modifying A Chart • Creating A Photo Album
Animation And Slide Shows • Setting Up Slide Shows • Narration • Setting Slide Transitions • Applying Custom Animation
Microsoft Outlook 2007 • New Features in Outlook 2007 • More New Features in Outlook 2007 • Opening an Outlook Data File • The Outlook 2007 Screen • The Navigation Pane • The To-Do Bar • Using Instant Search • Expanding the Search • Recent Searches and Searching the Desktop • Search Options • Searching Other Outlook Items • RSS Feeds
Working with Mail • Mail Messages • Creating New Messages • Previewing Attachments • Colour Categories • Assigning a Colour Category • Setting the Quick Click Category • Flagging Messages • Managing Follow-Ups in the To-Do Bar • Setting a Follow-Up Flag for Recipients
Working with the Calendar • Calendar Views • Creating a New Calendar Entry • Task Integration on the Calendar • Internet Calendars • Creating a Calendar Snapshot • Internet Calendar Subscriptions • Working with Multiple Calendars • Scheduling Meetings
Working with Contacts • Electronic Business Cards • Creating an Electronic Business Card • Sending and Receiving Business Cards • Managing Electronic Business Cards
Who Should Attend:
The primary audience for this course is users of previous versions of Microsoft Office including information workers and business decision makers anticipating deployment of the 2007 Microsoft Office system.
Prerequisites:
Familiarity with one or more previous versions of Microsoft Office.
