MS Office 2013

Course Overview

Microsoft Office 2013 is the latest productivity suite, version of Microsoft Office. This version includes new features that integrate into online services, improved format supports and new support for multi-touch interfaces. Learn about new features and functionality in this course.

Course Outline

Access 2013

Microsoft Access 2013 Basic – 6hrs, 25mins

  • Getting Started with Access 2013
  • Learning the Essential Access Building Blocks-Tables
  • Working with Access Data
  • Using Queries
  • Designing Forms
  • Generating Reports

Microsoft Access 2013 Intermediate – 4 hrs, 9 mins

  • Enhancing Tables
  • Using a Variety of Query Types
  • Enhancing Forms
  • Enhancing Reports
  • Maintaining and Customizing the Database

Microsoft Access 2013 Advanced – 4 hrs, 22mins

  • Recovering and Using Macros
  • Applying Database Tools
  • Using Access with other Applications
  • Applying Query Tools
  • Applying Techniques to Forms and Reports

Excel 2013

Microsoft Excel 2013: New Features – 1 hr, 17 mins

  • Using the Startup Page, Opening New Windows and Changing Accounts
  • Animating Dependent Formula Cells and Pasting as a Picture
  • Using Flash Fill
  • Accessing Quick Analysis Tools
  • Sharing Online
  • Turning Off the Workbook Share
  • Creating Surveys Using SkyDrive
  • Posting Spreadsheets to Social Networks
  • Searching for and Inserting Graphics
  • Building Data Model Relationships
  • Importing Data as a Table or PivotTable Report
  • Adding Timelines and Slicers

Microsoft Excel 2013 Basic – 6 hrs, 42 mins

  • Learning Basic Excel Elements
  • Applying Selection and Viewing Techniques
  • Utilizing Data Entry and Editing Techniques
  • Working with Excel Data
  • Formatting an Excel Worksheet
  • Performing Calculations

Microsoft Excel 2013 Intermediate – 5 hrs, 28 mins

  • Applying Formatting Techniques
  • Organizing Worksheet and Table Data
  • Using Multiple Pages, Worksheets and Workbooks
  • Inserting Graphic Objects
  • Creating Charts
  • Utilizing Formulas
  • Finishing Details before the Workbook is Complete

Microsoft Excel 2013 Advanced – 6 hrs, 13 mins

  • Managing Data
  • Collaborating with Others
  • Working with Data Tools
  • Recording and Using Macros
  • Using Functions
  • Analyzing Data with Pivot Tables and Pivot Charts

Outlook 2013

Microsoft Outlook 2013: New Features – 2 hrs, 2 mins

  • What’s new in Outlook 2013

Microsoft Outlook 2013: Basic – 8 hrs, 21 mins

  • Getting Started with Outlook 2013
  • Exploring Messages
  • Accessing EMail Features
  • Organizing Messages
  • Creating and Finding People (Contacts)
  • Managing a Calendar
  • Using Tasks

Microsoft Outlook 2013: Intermediate – 4 hrs, 17 mins

  • Applying Email Enhancements
  • Organizing and Locating Messages
  • Utilizing Message Modifications
  • Developing Contacts (People)
  • Adjusting Calendars
  • Making Use of Tasks
  • Engaging the Journal and Notes

Microsoft Outlook 2013: Advanced – 5 hrs, 15 mins

  • Accessing, Adding, Connecting and Removing Accounts
  • Managing Calendars
  • Customizing Outlook Tools
  • Customizing Outlook Text and Views
  • Mastering Email
  • Engaging Outlook Tools

PowerPoint 2013

PowerPoint 2013 Basic – 6 hrs, 43 mins

  • Starting with PowerPoint Basics
  • Getting Comfortable with the OneDrive
  • Creating Basic Presentations
  • Modifying Text
  • Working with Views
  • Adding Objects to Slides
  • Arranging Shapes

PowerPoint 2013 Intermediate – 13 hrs, 56 mins

  • Working with Shapes
  • Formatting Pictures
  • Using Themes
  • Working with Slides
  • Using Animations
  • Preparing the Presentation
  • Exporting, Importing and Saving

PowerPoint 2013 Advanced – 6 hrs, 23 mins

  • Working in the Backstage
  • Working with Masters
  • Inserting Media
  • Modifying Media
  • Accessing Extra Features
  • Creating Tables and Charts
  • Checking the Presentation

Project 2013

Microsoft Project 2013 Basic – 4 hrs, 9 mins

  • Getting Started with Project 2013
  • Creating a Project
  • Entering Project Tasks
  • Working with Project Tasks
  • Utilizing Resources in a Project Plan
  • Finalizing the Project Plan

Microsoft Project 2013 Advanced – 5 hrs, 34 mins

  • Tracking a Project
  • Project and Other Applications
  • Printing and Reporting in Project
  • Multiple Projects and the Sharing of Resources
  • Displaying and Formatting Data

SharePoint Designer 2013 – 5 hrs, 44 mins

  • Introducing SharePoint Designer 2013
  • Working with Sites
  • Exploring Lists and Libraries
  • Using Content Types
  • Getting Started with Workflow Actions
  • Using Visio with Workflows
  • Using Workflow Features

Word 2013

Microsoft Word 2013 What’s New – 1 hr, 23 mins

  • What’s New in Word 2013

Microsoft Word 2013 Basic – 5 hrs, 30 mins

  • Basic Word Elements
  • Basic Word Details
  • Editing Text
  • Preparing to Print and Printing
  • Formatting Text
  • Formatting Paragraphs
  • Working with Pages

Microsoft Word 2013 Intermediate – 6 hrs, 13 mins

  • Creating Tables
  • Using Quick Parts
  • Customizing Word Elements
  • Inserting Graphics
  • Working with Formatting Features
  • Utilizing Mail Merge

Microsoft Word 2013 Advanced – 7 hrs, 23 mins

  • Using Templates and Macros
  • Reviewing and Combining Documents
  • Protecting and Sharing Documents
  • Working with Long Documents
  • Adding References and Special Features
  • Working with Other Microsoft Applications
  • Creating Forms

Microsoft Business Contact Manager 2013 – 7 hrs, 36 mins

  • Learning Basic Elements of Business Contact Manager
  • Using Contacts and Accounts
  • Identifying Opportunities and Marketing Campaigns
  • Using Communications History and Linking
  • Managing Databases
  • Creating Reports and Charts
  • Utilizing Business Projects
  • Applying Project Tasks
  • Using Leads