Microsoft office 2010 update workshop

Description

This workshop is a quick way to learn the new features in Ms Office 2010 and will cover Ms Word, Excel, PowerPoint and Outlook. This workshop is fully-customisable and can be a 1/2 day workshop or include an in-depth focus on one of the programs at intermediate level.

Who should attend?

Existing users of Office who need to get up to speed with Office 2010 as quickly and efficiently as possible. First time users of Office who are starting with Office 2010 should attend a Level I course in either Excel, Word, PowerPoint or Outlook.

Duration

1/2 day or 1 day (groups)

Where

On-site at company premises

Prerequisites

Delegates must have knowledge of Windows,

Course content

Module 1: The new features in Ms Office 2010

• The new common features in Ms Office 2010:
  • The Ribbon
  • Task-orientated Tabs
  • Customising the Ribbon
  • The File tab and "back office"
  • Contextual tools and program tabs
• The Quick Access Toolbar:
  • Display options
  • How to customise

• How to find Word/Excel/PowerPoint options
• The Developer tab
• Dialog box launchers
• Keyboard shortcuts
• Shortcut menus

Module 2: File formats

• New file formats in Office 2010
• Saving to earlier versions of Office
• Saving macros in Office 2010

Module 3: Ms Excel

• Enlarged grid size and its implications
• File conversion and compatibility
• Changes to the worksheet screen
• Customising the Status Bar
• New Page Layout view and adding headers and footers directly into the worksheet
• New formatting options – cell styles, table styles, conditional formatting, pivot table formatting
• How to find Freeze panes
• Improved help in creating Functions
• New Sort options
• Excel lists now called Excel Tables
• Name Manager
• Pivot Tables
• Slicers
• Sparklines
• What happened to the Chart Wizard?

Module 4: Ms Word

• New Interface features
• Cover page, blank page
• Themes
• Quick styles
• Headers/footers
• QuickParts
• Navigation pane

Module 5: Ms Outlook

• To do bar
• Categories
• Conversation view
• Clean-up and Ignore
• QuickSteps
• Back Office menu
• Sharing calendars
• Displaying multiple calendars and overlaying them
• Sending a calendar via e-mail

Module 6: Ms PowerPoint

• New interface features
• SmartArt Graphics
• New object formatting
• Artistic formatting
• Charts
• Working with designs
• Tables
• Animations
• Saving your presentation as a video
• Video editing