print
Course Name
Microsoft® Excel® 2013: Essentials

Contact Hours: 24

Course Description
In the first lesson of the course, you'll learn new features that are the same in all the Office 2013 programs. Each of the remaining five lessons will focus specifically on one of the programs: Word, Excel, PowerPoint, Outlook and OneNote.

This course can be completed as quickly as you care to progress through it. As a benefit, the e-learner is provided 1 year post course completion access to this course including any updates that are made to the curriculum from the time of official enrollment.

Outcome
You will learn:

  • How to access Office features using a free Microsoft account
  • How to invite people to share a document in the cloud
  • How to turn a PowerPoint presentation into a video viewable on any device
  • How to create graphs and PivotTables with just a few clicks
  • How to integrate contact info in Outlook with social networks

Assessment
This course allows for self-directed work and does not require that you take a test. Apply what you have learned to your own projects.

Outline
Lesson 1: New Common Features

  • Opening & Saving
  • Creating a New File & Using Save As Options
  • Managing Your Microsoft Account
  • Activating Touch Mode
  • Exploring New Window Controls
  • Exporting Documents
  • Sharing Documents
  • Inserting Pictures from Online Sources
  • Support for Third-Party Apps

Lesson 2: Microsoft Word® New Features

  • New Word Templates
  • Read Mode with Zooming
  • Read Mode with Comments
  • Automatically Pick Up Where You Left Off
  • Enhanced Review Features
  • Importing Adobe® PDF Files
  • Using Alignment Guides
  • Table Enhancements
  • Setting Word Options

Lesson 3: Microsoft Excel® New Features

  • New Excel Templates
  • Sharing Excel Workbooks
  • Flash Fill
  • Recommended Pivot Tables
  • Recommended Charts
  • Chart Formatting Tools
  • Power View Reports
  • Quick Analysis
  • Social Sharing
  • Share Workbooks on the Web with the Excel Button

Lesson 4: Microsoft PowerPoint® New Features

  • New PowerPoint Templates
  • Sharing PowerPoint Presentations
  • Improved Presenter View & Zoom Tool
  • Alignment Guides
  • Better Control Over Motion Paths
  • Grouping, Merging & Coloring Shapes
  • Commenting
  • Online Collaboration
  • Automatically Picking Up Where You Left Off

Lesson 5: Microsoft Outlook® New Features

  • Exchange ActiveSync
  • New Searching & Navigation
  • Improved Calendar & Lync Meetings
  • People Cards & Social Integration
  • Using the Weather Bar

Lesson 6: Microsoft OneNote® New Features

  • Navigation & Adding Subpages
  • Exporting Notebook Content
  • Integrating with Mobile Devices
  • Inserting File Attachments & Printouts
  • Using the Clipping Tool to Insert Text & Graphics
  • Creating a Table
  • Converting a Table to an Excel Spreadsheet
  • Sharing Notes
  • Improved Searching
  • Credits