Our Microsoft Office 2013 training includes a variety of courses designed to teach individuals of all skill levels about using all of the Office 2013 programs. Our instructor led training is offered by certified instructors to professionals and individuals as well as corporate and government customers. With our MS Office 2013 training, individuals can improve their skills and knowledge for all of the latest Office 2013 programs. This is beneficial for individuals who are hoping to increase their value in the workplace and for companies that are interested in boosting employee productivity and efficiency.

Getting comfortable in Office Professional 2013

  • Exploring the Office environment

  • Working with Office files

  • Recovering unsaved files and versions

  • Customizing the user interface

  • Customizing the Office environment

  • Customizing the Quick Access toolbar

  • Customizing the status bar

  • Customizing the ribbon

  • Choosing the right application for the task at hand

Using shared Office features

  • Identifying new shared features in Office Professional 2013

  • Applying Office themes

  • Inserting graphics, videos, charts, and diagrams

  • Inserting charts

  • Searching for online templates

  • Presenting Office documents online

  • Inserting online video

Sharing and collaborating

  • Defining the term cloud service

  • Signing in and managing your Office account

  • Connecting cloud services to your Office account

  • Saving files on SharePoint Online and SkyDrive

  • Sharing files with others from SharePoint Online or SkyDrive

  • Opening files from the cloud

  • Syncing files with SkyDrive for offline use

  • Syncing with SkyDrive Pro

  • Syncing with SkyDrive for a Microsoft account

  • Getting started with co-authoring

Using touch in Office

  • Getting comfortable with Office on a tablet

  • Looking at unsupported features

  • Using touch mode

  • Selecting content with touch

  • Working with ink in Office

Week 1 -- Word 2013

Getting comfortable in Word 2013

  • Exploring the Word 2013 user interface

  • Modifying your document view

  • Changing other view options

  • Discovering what’s new in Word 2013

Navigating and reading documents

  • Navigating a document by scrolling and using keyboard shortcuts

  • Searching and navigating a document by using the Navigation pane

  • Collapsing and expanding document content

  • Working with documents in the new Read Mode

  • Exploring research tools in Read Mode

Editing and composing documents

  • Moving the cursor by using keyboard shortcuts

  • Selecting text by using the keyboard and mouse

  • Selecting text by using the keyboard

  • Selecting text by using the mouse

  • Using other selection methods

  • Using formatting marks during document composition

  • Inserting symbols, international characters, and other special characters

  • Inserting special characters

  • Using AutoCorrect

  • Composing documents faster by using building blocks

Formatting documents

  • Formatting documents more efficiently

  • Setting default document formatting for your documents

  • Setting section formatting

  • Using styles for paragraph and character formats

  • Exploring other paragraph formats

  • Exploring other character formats

  • Changing case

  • Managing pagination through formatting

Presenting information

  • Formatting simple lists by using bullets and numbering

  • Creating tabbed lists

  • Inserting tables

  • Enhancing tables

Finalizing documents

  • Correcting proofing errors

  • Inspecting documents before publishing

  • Marking documents as final

  • Creating PDF files in Word

  • Printing documents

Week 2-3 -- Excel 2013 & Access 2013

Getting comfortable in Excel 2013

  • Starting Excel 2013

  • Identifying what’s new in Excel 2013

Creating and editing worksheets

  • Entering and organizing data

  • Changing column widths

  • Using formatting to alter the appearance of data

  • Extending a series with AutoFill

  • Introducing Flash Fill

  • Selecting and naming cell ranges

  • Using column headers to define names

  • Moving around in the worksheet

  • Moving and adjusting cells

  • Moving and copying rows and columns

  • Copying one or more cells to many

Manipulating numbers and text

  • Creating, editing, and copying formulas

  • Using functions

  • Using the AutoSum button and built-in function

  • Inserting functions

  • Using relative, fixed, and mixed cell references

  • Using names in formulas and validating cell entries

  • Looking at useful functions

  • Working with text in Excel

  • Combining text from multiple cells into one string

  • Removing extra spaces

  • Copying cells containing formulas and pasting only their resulting values

  • Changing the case of text

  • Restricting cell entries

Analyzing data

  • Exploring a built-in template

  • Performing what-if analyses

  • Managing multiple what-if models

  • Using the Quick Analysis tools

  • Formatting conditionally

  • Analyzing data from another source

  • Filtering data with tables

  • Filter menu commands

  • Adding data to tables

  • Sorting data

  • Creating a custom sort list

  • Creating a PivotTable

Formatting worksheets

  • Applying number formatting

  • Formatting with styles

  • Creating custom themes

  • Formatting in cells

  • Working with custom number formats

  • Working with percentage formats

  • Working with fraction formats

  • Working with date formats

  • Protecting worksheets

  • Setting view options

  • Storing formats in templates

Manipulating workbooks and worksheets

  • Inserting rows and columns

  • Inserting and deleting cells

  • Working with panes and page layout options

  • Printing row and column labels on every page

  • Adjusting page breaks

  • Creating a multisheet workbook

  • Manipulating sheets

  • Summarizing a multisheet workbook

  • Working with sheet references

  • Managing multiple workbooks

Creating charts and graphics

  • Creating and modifying a chart

  • Adding a slicer to a PivotChart

  • Manipulating chart elements

  • Adding a timeline to a chart

  • Manipulating objects

  • Creating and sharing graphics

  • Using graphics elsewhere

Week 4 -- PowerPoint 2013 & Access 2013

Getting comfortable in PowerPoint 2013

  • Getting started working with PowerPoint 2013

  • Exploring the PowerPoint 2013 tools

  • Discovering the new features in PowerPoint 2013

Designing and creating presentations

  • Creating a new presentation based on a theme or template

  • Applying a theme to an existing presentation

  • Customizing your file with colors, fonts, and effects

  • Theme fonts

  • Theme colors

  • Applying theme effects to your presentation

  • Applying background styles to your presentation

  • Formatting placeholders on the slide master

  • Adding graphics to the slide master and layouts

  • Creating a custom slide layout

  • Changing your presentation from a 16:9 to a 4:3 format

Creating on-slide content

  • Choosing a slide layout and adding text in placeholders

  • Adding manual text boxes

  • Adding and formatting a table

  • Inserting and formatting charts

  • Creating and formatting SmartArt diagrams

  • Reusing slides and keeping their source formatting

Creating Office graphics

  • Adding and formatting shapes

  • Applying enhanced fills and effects

  • Creating your own shapes

  • Inserting, cropping, and formatting pictures

Adding animation and multimedia

  • Adding animation to text and shapes

  • Editing video and applying transitions

  • Inserting and playing online video

  • Saving your presentation as a video

Finalizing and presenting

  • Adding and renaming sections

  • Inserting comments

  • Printing slides and notes

  • Finalizing your presentation

  • Delivering a presentation

  • Practicing with Presenter view

Access 2013

Getting comfortable in Access 2013

  • Starting Access 2013

  • Looking at the desktop database window

  • Exploring the Web App window

  • Displaying results in a browser

  • Discovering what’s new in Access 2013

Understanding Access 2013 databases

  • Creating a desktop database

  • Importing and exporting data

  • Navigating the user interface

  • Working with data in a datasheet

  • Copying and pasting from a datasheet

  • Configuring Access options

  • Linking Access to external data

  • Compacting, repairing, and encrypting a database

Creating basic tables and queries

  • Creating tables for your data

  • Creating a table in Datasheet view

  • Choosing a field data type

  • Adding validation and calculated fields to your tables

  • Adding a table validation rule

  • Adding a calculated field

  • Indexing a table

  • Linking tables together with relationships

  • Creating a manual relationship

  • Creating a select query

  • Creating a query by selecting specific fields

  • Joining multiple tables in a query

  • Working with query criteria

  • Filtering and sorting a field

  • Adding multiple criteria to a query

  • Adding parameters to queries

  • Working with totals and crosstab queries

  • Crosstabulating data

Designing forms and reports

  • Creating a continuous form

  • Working with a form in Layout view

  • Creating a datasheet with conditional formatting

  • Creating a single record form

  • Creating a single record form by using the Split Form template

  • Creating a parent/child form

  • Creating a parent/child pop-up form by using the Form Wizard

  • Tying your forms together with a navigation form

  • Creating a single record report

  • Creating a tabular report with grouping

  • Creating a continuous report with conditional formatting

  • Creating a parent/child report

Week 5 -- Outlook 2013

Getting comfortable in Outlook 2013

  • Setting up an email account in Outlook

  • Navigating the Outlook interface

  • Discovering what’s new in Outlook 2013

Using mail

  • Creating and sending messages

  • Addressing messages

  • Saving and sending messages

  • Attaching files to messages

  • Viewing messages and message attachments

  • Configuring Reading pane behavior

  • Viewing Reading pane content

  • Marking messages as read

  • Single-key reading

  • The People pane

  • Responding to messages

  • Inline replies

Staying on schedule

  • Scheduling and changing appointments

  • Using Quick Entry mode to create date-specific events

  • Creating recurring appointments and using appointment features

  • Creating appointments from messages

  • Configuring a Quick Step to create an appointment from an email message

  • Scheduling and changing meetings

  • Updating and canceling meetings

  • Responding to meeting requests

  • Displaying different views of a calendar

  • Views

  • Arrangements

  • Using the Date Navigator

  • Calendar item peeks

Working with tasks

  • Creating tasks from scratch

  • Setting task options

  • Creating tasks from Outlook items

  • Updating tasks

  • Removing tasks and items from task lists

  • Managing task assignments

  • Reclaiming an assigned task

  • Dealing with tasks other people assign to you

Managing contacts and people

  • Viewing contacts

  • Using the People Hub

  • Viewing Contact Cards

  • Using contact views

  • Using the People peek

  • Creating contacts

  • Using inline editing

  • Managing linked contacts

  • Configuring a social network account

  • Viewing social network updates

Saving time with Outlook

  • Flagging and reviewing important messages

  • Applying a message flag

  • Categorizing a message

  • Creating a high-priority Quick Step

  • Reviewing high-priority messages

  • Using the Calendar peek to plan your schedule

  • Planning ahead with the Weather bar

  • Organizing your mail with Folder Favorites

  • Rearranging key folders

  • Searching for related messages

  • Finding messages from a specific sender

  • Conducting quick searches

  • Using Search Folders to view today’s mail

  • Creating items quickly

  • Creating contextual appointments, contacts, and tasks from email messages

OneNote 2013

Getting comfortable in OneNote 2013

  • Getting started with OneNote 2013

  • Exploring the OneNote interface

  • Identifying new and improved features in OneNote 2013

Working with notebooks, sections, and pages

  • Creating a notebook

  • Creating and organizing sections

  • Section groups

  • Creating and organizing pages

  • Creating subpages

  • Adding and organizing notes

  • Inserting images

  • Working with ink and shapes

  • Custom pens

  • Shapes

  • Erasing ink or shapes

  • Inserting space

  • Arranging shapes

  • Recovering deleted sections or pages

Using organizational tools

  • Using tags

  • Creating and customizing tags

  • Using styles to format your notes

  • Connecting OneNote to Outlook

  • Sending email messages to OneNote

  • Connecting appointments to OneNote

  • Annotating contacts

  • Connecting OneNote tasks to Outlook

  • Using hyperlinks to tie your notes together

  • Creating custom hyperlinks to other pages

  • Creating and organizing tables

  • Using the Insert Table feature

  • Searching your notes to find information quickly

  • Changing your search scope

33 Sharing notes with others

  • Creating a new notebook on SkyDrive

  • Moving a notebook to SkyDrive

  • Stopping sharing in SkyDrive

  • Using a file server to share notes

  • Stopping sharing on a file server

  • Sharing notes via SharePoint

  • Sharing notes with others during a meeting

  • Sending notes via email

  • Exporting to other formats

Using OneNote everywhere

  • Syncing your notes by using SkyDrive

  • Accessing your notes in a web browser

  • Using OneNote on your phone or tablet

  • Using OneNote on an iPhone or iPad

  • Using OneNote Mobile for Android

  • Using OneNote Mobile on a Windows Phone

  • Using OneNote with a Windows 8 tablet

Saving time with OneNote

  • Finding tags

  • Recording audio

  • Using Quick Notes

  • Using screen clipping

  • Using linked notes

  • Searching your images

  • Inserting a spreadsheet

  • Using the Napkin Math feature

  • Formatting with templates