Microsoft Office 2013 – Upgrade from Older Versions (2203, 2007 and 2010)

OBJECTIVES

The participant will explore the differences and will learn about the new functions of Office 2013.

CLIENTELE

Public

PREREQUISITES

General knowledge of Windows as well as Office 2003, 2007 or 2010

DURATION

2 days (15 hours)

 

COURSE SYLLABUS

1. Office 2013 Common changes

  • The ribbon
  • Various displays of the ribbon
  • File menu
  • Backstage display mode
  • Saving in Skydrive by default
  • Quick Access tool bar
  • Activate / deactivate the tactile function
  • Tabs and complementary tabs
  • Groups
  • Help
  • Instant display
  • Mini tool bar
  • Keyboard shortcuts
  • Automatic bookmarks
  • Galleries
  • Themes
  • Accessibility verifier
  • Charts
  • SmartArt
  • Inserting Web content
  • File extensions
  • Sharing files and simultaneous work
  • Management tools for documents
    • Older versions
    • Protection
    • Approved documents

 

2. Word 2013 – Novelties

  • Information and construction blocks
    • Galleries
  • Charts and schematics
  • Spell check
  • Convert and open PDF documents
  • Final draft
  • Screen shots
  • Dynamic displays and alignment guides
  • Modifying and image editor
    • Artistic effects
    • Image correction
    • Background deletion
    • Image touch-ups
  • Integration of online videos
  • Equation and symbol editor
  • Opentype
  • QuickPart
  • Insert references
  • Simple marks in the modifying follow-ups section
  • Extras
  • Navigation
  • Search section
  • New forms
  • Manuscript data
  • The translator
  • New full screen reading tools

 

3. Excel 2013 – Novelties

  • File size and spreadsheets
  • Developer and saving macros
  • Page mode
    • Headers and footers
  • Formula bar
  • Formula creation assistant and semi-automatic data entry of names
  • Instant filling of a column
  • Instant data analysis
  • Chart functions
  • Sort filters
    • Segments
    • Comparing data
  • Conditional format
  • Sparkline charts
  • Improved new charts
  • Recommended charts
  • Equation editor in text zones
  • Improved crossed dynamic charts
    • Performance
    • Labels
    • Filters
    • Differed writing
    • Display values
    • Crossed charts
    • Data chronology
  • Crossed dynamic charts based on many charts
  • PowerPivot for Excel
    • Microsoft SQL
  • Adding math functions
    • Search and references
    • Logic
    • Text
    • Statistics
    • Cubic and engineering
  • Using Excel Web App
  • Excel mobile 2013
  • External data sources

 

4. Outlook 2013 – Novelties

  • Group display
  • Displays
  • Grouping box
  • Home Quick Action tab
  • Display by conversation and intermediate messages
  • Clean button
  • Categories
  • Follow-up file and adding tasks
  • Tasks bar
  • Answer an email directly in reading mode
  • Commands for quick action in message lists
  • Follow-up of messages and call-backs sent
  • Filter email using the ribbon
  • Accounts, signatures and send boxes by account
  • Saving automatic meetings
  • The weather integrated in calendar
  • Automatic data entry of names in address books
  • Resizing joint photos
  • Screen shot
  • Suggest meetings and planning
  • Calendar groups
  • Send calendar
  • Send Outlook elements

 

5. PowerPoint 2013 – Novelties

  • New themes and theme variations
  • Multiple templates
  • Automatic saves of presentation versions
  • Sections in a presentation
  • SmartArt and charts
  • Alignment and positioning of improved objects
  • Fusion of drawing forms
  • One mask per disposition
  • Creating a mask and a content zone
    • Personalized page layout
  • Fusion and comparison of presentations
  • Library of slides
  • Cut a video or audio clip
  • Bookmark in video or audio clips
  • Create links to an online video
  • Convert a presentation into a video clip
  • Improved transition and animation
  • Presentation mode
  • Convert mouse to a laser pointer
TOP