Course Objective

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

 

<p d