Training

Webinar Topics

Top

Upgrading Microsoft Office?  Explore the Changes

» Differences Between Office 2007 and 2010
» Upgrading to Office 2007
» Upgrading to Access 2007
» Upgrading to Excel 2007
» Overview of Office 2007

What's New in Office 2010

» What's New in Word 2010
» What's New in Excel 2010
» What's New in Outlook 2010

Microsoft OneNote

» Introduction to Microsoft OneNote

Microsoft Word 2010 or 2007

» Word Styles for Decision Makers
» Secrets to a Quick and Easy Table of Contents
» New Features of Word
» Work with Tables in Word
» Mail Merge in Word
» Create a Table of Contents in Word
» Work with Styles in Word
» Work with Reference Tools in Word
» Automate Word
» Track Changes and Compare Documents in Word
» Create and Use Style Sets in Word
» Multi-Level Numbering in Word
» Work with Long Documents in Word

Microsoft Excel 2010 or 2007

» Create and Modify Charts in Excel
» Data Tools in Excel
» Advanced Data Tools in Excel
» Introduction to Formulas and Functions in Excel
» Advanced Formulas and Functions in Excel

Microsoft PowerPoint 2010 or 2007

» Introduction to PowerPoint
» New Features of PowerPoint
» Create a Slide Show in PowerPoint
» Animate and Enhance PowerPoint Presentations

Microsoft Outlook 2010 or 2007

» New Features of Outlook

Microsoft Access 2010 or 2007

» Introduction to Access
» Introduction to Reports in Access

Microsoft Office 2003 - Available by Request

Adobe Acrobat

» Explore Adobe Acrobat 9

Workshare Compare

» Compare Documents with Workshare Compare


Differences Between Office 2007 and 2010

» What's New in the Office interface?
» Overview of changes in Word 2007 to 2010
» Overview of changes in Excel 2007 to 2010
» Overview of changes in Outlook 2007 to 2010
» Overview of changes in PowerPoint 2007 to 2010
Back to Top


Upgrading to Office 2007

» What's In and What's Out
» Use the Ribbon
» Use the Office button
» Understand new file formats
» Customize the Quick Access toolbar
» Inspect a document
Back to Top


Upgrading to Access 2007

» New Access interface
» New templates
» New Access views
» Overview of improved tools
Back to Top


Upgrading to Excel 2007

» New interface
» Enhanced worksheet limits
» Revised conditional formatting
» Formula enhancements
» Database enhancements
» Chart enhancements
Back to Top


Overview of Office 2007

» Ribbon
» Quick Access toolbar
» Dialog box launcher
» Microsoft Office button
» New status bar
» Save as PDF
Back to Top


Introduction to Microsoft OneNote

» How to begin a OneNote binder
» Adding and uses for Sections, Pages, various Tags and links
» How to share non-case related binders
Back to Top


What's New in Word 2010

» What's In and What's Out?
» Explore the Ribbon
» Use the File tab
» Use the navigation pane
» Understand new file formats
» Customize the Quick Access toolbar
» Customize the Ribbon
» Inspect a document
Back to Top


What's New in Excel 2010

» Ribbon
» File tab
» Sparklines
» Pivot tables
» Slicers
» Improved conditional formatting
» Paste with Live Preview
» Customizable ribbon
» Enhanced data features
Back to Top


What's New in Outlook 2010

» Ribbon
» Expanded ribbon
» New search filters
» Quick Steps
» Working with conversations
» Calendar groups
Back to Top


Word Styles for Decision Makers

» Overview of how quickly Styles can be applied and how that time translates to billable
   hours
Back to Top


Secrets to a Quick and Easy Table of Contents

» Do you spend hours marking for TOC?
» Do you use Styles?
» How Styles speeds up TOC generation
» Applying Styles
» Generating a TOC
» Updating sections and TOC
Back to Top


New Features of Word

» New interface
» Formatting features
» Styles features
» Quick Parts
» Track Changes enhancements
Back to Top


Work with Tables in Word

» Insert a table
» Enter information
» Format a table
» Insert and delete rows and columns
» Table Design tools on the Ribbon
» Table Layout tools on the Ribbon
» Table properties
Back to Top


Mail Merge in Word

» Overview of the Mailing tab on the Ribbon
» Select the document type
» Select recipients
» Insert fields into the form
» Preview results
» Complete the merge
» Merge to e-mails and labels
Back to Top


Create a Table of Contents in Word

» Use heading styles
» Add text to the Table of Contents
» Use table entry fields
» Create the Table of Contents
» Update the Table of Contents
» Work with Style Separator
Back to Top


Work with Styles in Word

» Understand the importance of Styles in Word
» Understand the Style Sets
» Understand the Normal Styles
» Apply QuickStyles
» Display the Styles task pane
» Create Styles
» Modifying Styles
Back to Top


Work with Reference Tools in Word

» Insert footnotes
» Create a Table of Contents
» Create a Table of Authorities
» Create an index
Back to Top


Automate Word

» Understand building blocks
» Create and use QuickParts
» Add custom headers and/or footers to the gallery
» Useful Word options customization
» Record and play macros
Back to Top


Track Changes and Compare Documents in Word

» Track Changes in a document
» Accept and reject changes
» Track changes options
» Compare documents
» Specify what to compare
» Ways of viewing compared documents
Back to Top


Create and Use Style Sets in Word

» Understand Style Sets
» Use Word's built in Style Sets
» Modify Styles
» Saving as a Quick Style set
» Use a Style Set in a different document
Back to Top


Multi-Level Numbering in Word

» Multi-level numbering gallery
» Create a new multi-level list
» Modify a numbering format
» Attach to Heading Styles
» Save a multi-level list as a Quick Style Set
» Use a Quick Style Set in a new document
Back to Top


Work with Long Documents in Word

» Headers and Footers
» Headers and Footers in sections
» Page Layout
» Section breaks
» Change page numbering in sections
Back to Top


Create and Modify Charts in Excel

» Create a chart
» Chart commands on the Ribbon
» Chart Design commands
» Chart Layout commands
» Chart Formatting commands
Back to Top


Data Tools in Excel

» Quick sorting
» Custom sorts
» Saving as a table
» Filtering a table
» Viewing a Total row
Back to Top


Advanced Data Tools in Excel

» Work with subtotals
» Create Pivot tables
» Modify Pivot tables
» Create a Pivot chart
Back to Top


Introduction to Formulas and Functions in Excel

» Create a basic formula
» Copy a formula
» Introduction to Functions
» Use Sum, Average, Max and Min functions
» Understand Absolute Reference
Back to Top


Advanced Formulas and Functions in Excel

» Link data in Excel
» Link formulas in Excel
» Advanced functions: =IF, =SUMIF, =COUNT, =COUNTA
Back to Top


Introduction to PowerPoint

» Navigating the PowerPoint screen
» Understanding slide layouts
» Adding and editing slides
» Understanding objects
Back to Top


New Features of PowerPoint

» New interface
» SmartArt
» Custom slide layouts
» QuickStyles
» Text enhancements
» Presenter view
Back to Top


Create a Slide Show in PowerPoint

» Starting a presentation
» Title slide
» Add new content slides
• Illustrations
• Bullets
• Text
» Applying a theme
» View and save a Slide Show
Back to Top


Animate and Enhance PowerPoint Presentations

» Add animation to bullets
» Dimming previous bullets
» Animate slide objects
» Ordering and timing the animation
» Slide transitions
» Hyperlinks and action settings
Back to Top


New Features of Outlook

» New interface
» Navigation pane
» Mail tabs
» Calendar tabs
» Contact tabs
» Receiving messages
» To Do bar
» Instant search
» Color categories
Back to Top


Introduction to Access

» Introduction to database concepts and terminology
» Introduction to Access
» Examine Access objects (Queries, Forms, Reports)
» Find and edit records
» Sort and filter records
Back to Top


Introduction to Reports in Access

» Overview of reports
» Create a report with the Report Wizard
» Create a report containing Totals
» Modify the design of a report
Back to Top


Explore Adobe Acrobat 9

» Browse through a PDF document
» Navigate to specific content
» Search for information
» Search using OCR
» Export content from a PDF document
» Print a PDF document
» Create PDF documents
Back to Top


Compare Documents with Workshare Compare

» Compare documents in Word and Compare
» Workshare menu
» Select the original document
» Select the modified document
» Preview results
» Edit, save and print the redline document
Back to Top