Online Course for Microsoft Office 2010 and 2013

The online training offers over 140 modules to master the Office suite that you learn at your own rhythm in the comfort of your home. The complete Microsoft Office training covers the main Office software: Word, Excel, Outlook and PowerPoint. The accompanying videos and exercises help students absorb the content and comprehension tests allow them to see their progress.

• Courses for Word, Excel, Outlook and PowerPoint 2010 and 2013
• Online or downloadable content
• Accompanying videos, exercises and comprehension tests
• Available on tablets and computers
• Completion certificate confirming learned skills
• Accessible for 12 months
• Free email help included

Course syllabus

Microsoft Word

• New interface: the display
  - File tab
  - Ribbon command bar and command tabs
  - Command groups
  - Tool bar with Quick access
  - Display modes and zoom
  - Display tab
  - Advanced tool-tips

• Working on the interface
  - Full-screen reading display mode
  - Word count
  - Mini-translator
  - Language preference settings

• Interactions – Introduction
  - Introducing the tab
  - File (Backstage mode)
  - Customizing the Quick access tool bar
  - Customizing the status bar
  - Customizing the Ribbon
  - Context tools
  - Galleries and previews
  - Protected mode
  - Themes
  - Help

• Charts
  - Inserting a chart and chart tools
  - Modifying data

• SmartArt and WordArt objects
  - Working with SmartArt
  - Working with WordArt

• Working with objects
  - Taking a screenshot
  - Cropping and compressing an image
  - Modifying the appearance of an image

• Quickpart building blocks
  - Defining and building block
  - Inserting a building block
  - Creating a building block

• Style and format
  - Applying a style for the styles gallery
  - Creating a quick style
  - Displaying the Styles pane
  - Inserting a cover page and inserting a blank page

• A few advanced features
  - Inserting a page number
  - Editing headers and foot notes
  - Getting to know direct mailing
  - Comparing documents

• Merging a document
  - Inserting a mathematical equation
  - Creating a data source
  - Modifying a data source
  - Searching for a record
  - Adding a new record
  - Deleting a record
  - Merging data with the main document

• New in 2013
  - New Read Mode
  - Zooming in on objects
  - Saving and sharing files
  - Inserting images
  - Using a model

Microsoft Excel

• New interface: the display
  - Ribbon command bar and command tabs
  - Command groups
  - Tool bar with Quick access
  - Display modes and zoom
  - Display tab
  - Advanced tool-tips

• Working with the interface
  - The Layout display mode
  - Headers and footnotes
  - The limits of Excel
  - Inserting a spreadsheet
  - The formula bar
  - Drop-down list of features and more

• Interactions – Introduction
  - Introducing the tab
  - File (Backstage mode)
  - Customizing the Quick access tool bar
  - Customizing the status bar
  - Customizing the Ribbon
  - Context tools
  - Galleries and previews
  - Protected mode
  - Themes
  - Help

• Charts
  - Creating and modifying charts
  - Creating a “sparkline” chart

• Working with objects
  - Taking a screenshot
  - Cropping and compressing an image
  - Modifying the appearance of an image

• SmartArt and WordArt objects
  - Working with SmartArt
  - Working with WordArt

• Advanced features
  - Sorting and filtering by color
  - Using the Selection pane
  - Using the name manager
  - Basic use of the pivot table

• Working with objects
  - Taking a screenshot
  - Cropping and compressing an image
  - Modifying the appearance of an image

• New in 2013
  - Discovery of main features
  - Instant data analysis
  - A folder, a window
  - Inserting images
  - Sharing a spreadsheet

Microsoft Outlook

• Outlook interface
  - File tab
  - Ribbon and tabs
  - Command groups
  - Customizing the Ribbon
  - Tool bar with Quick access how the zoom works

• Using online help
  - Using online help
  - Context tools and tabs
  - Mini tool bar
  - Galleries and previews

• Interactions with Outlook
  - Introducing the File tab
  - Panes of the File tab

• Email messaging
  - Message box
  - Cleaning your email box
  - Quick actions
  - Improved monitoring indicator
  - Categories
  - Displaying as a conversation
  - Person panes

• The interface
  - Navigation pane
  - Task bar
  - Instant search tool
  - Description of the context tab
  - Search tools

• Time management
  - Time management
  - New display
  - Accessing your appointments
  - Task monitoring on the Calendar
  - Sharing a calendar

• Advanced features
  - Advanced features
  - Sending a calendar by email
  - Email account settings
  - Automatic replies
  - Business card

• New in 2013
  - Showing a preview of a message
  - Replying more quickly
  - Displaying all of your contacts details
  - Customizing your inbox

Microsoft PowerPoint

• New interface: the display
  - Ribbon command bar and command tabs
  - Command groups
  - Tool bar with Quick access
  - Display modes and zoom
  - Display tab
  - Advanced tool-tips

• Applying a theme or model
  - Applying a theme
  - Modifying your theme

• The interactions
  - Introducing the File tab (Backstage mode)
  - Customizing the Quick access tool bar
  - Customizing the status bar
  - Customizing the Ribbon
  - Context tools
  - Galleries and previews
  - Protected Mode
  - Themes
  - Help

• SmartArt and WordArt objects
  - Working with SmartArt
  - Working with WordArt

• Working with objects
  - Taking a screenshot
  - Cropping and compressing an image
  - Modifying the appearance of an image

• Charts
  - Inserting a chart and recognizing chart tools
  - Modifying data with Microsoft Excel

• Working with slides
  - New provisions
  - Organizing in sections

• Advanced PowerPoint features
  - Working with charts
  - Working with presentations
  - Applying transitions and animated effects
  - Working with audio and video