LearnKey Training

Office 2013 Series

Office 2013 Series

Back to Product Page


Office 2013 Series

0 Sessions -
46 Hours of Interactive Training

The Office 2013 certification training series from LearnKey is packed with information covering the new features of Office 2013. This series is ideal for professionals who are looking to improve their proficiency with Office or for any individuals who are looking to enhance their skill set with the MOS certifications offered by Microsoft. Create your competitive edge with the knowledge of Microsoft Office 2013. This series includes LearnKey's Access 2013, Excel 2013, Outlook 2013, PowerPoint 2013, and Word 2013 courses.

Benefits
  • Become proficient with the 2013 versions of Access, Excel, Outlook, PowerPoint, and Word
  • Test your understanding of Access, Excel, Outlook, PowerPoint, and Word with hundreds of practice test questions
  • Put your skills to the test with labs and demos in every session

Word 2013 (77-418)
Session 1

Section A: Tour of the Interface

  • Quick Access Toolbar
  • Title Bar, Learn the Ribbon
  • Show/Hide Paragraph
  • Modify Font, Paragraph
  • Modify Styles
  • Status Bar, Views, Create Document
  • Save Documents
  • Navigation Pane, Search Text

Section B: Navigation and Views

  • Navigation Tools and Tabs
  • Cut, Copy, Paste
  • Change Document Views
  • Outline View
  • Save Down
  • Compatibility Mode

Section C: Create a New Document

  • Create a New Document with a Template
  • Insert a Hyperlink
  • Insert a Quick Table
  • Insert Live Feeds
  • Open a PDF
  • Insert Pictures
  • Open Non-Native Files, Use Go To
  • Import Excel Table
  • Adjust Document

Section D: Modify a Document

  • Heading Styles, SmartArt
  • Insert Watermarks
  • Portrait vs. Landscape
  • Insert Headers, Footers
  • Insert Page Numbers

Section E: Table of Contents

  • Insert Table of Contents
  • Split the Window
  • Record Simple Macro
  • Macro Security
  • Show/Hide, Document Properties

Section F: Print

  • Configure to Print
  • Print Scale
  • Protect Documents with Password

Word 2013 (77-418)
Session 2

Section A: Advanced Formatting Options

  • Use Format Painter
  • Copy and Paste Text
  • Find and Replace Text
  • Insert Text, AutoCorrect
  • Insert Building Blocks
  • Insert Text Boxes
  • Insert Line Spacing
  • Clear Format
  • WordArt
  • Insert Paragraph Indentations
  • Insert Tabs, Signature Line
  • Insert Quick Parts
  • Insert Section Breaks
  • Create Multiple Columns with Sections
  • Prevent Paragraph Orphans
  • Add Titles to Sections

Section B: Create and Modify a Table

  • Create a Table
  • Convert Tables to Text
  • Define Table Dimensions
  • Set AutoFit Options
  • Modify a Table
  • Apply Styles to Tables
  • Sort Table Data
  • Merge Cells in Table
  • Create a Quick Table
  • Apply a Formula

Section C: Lists

  • Create and Modify Lists
  • Create a Numbered List
  • Modify Numbers

Word 2013 (77-418)
Session 3

Section A: Reference Tools

  • Footnotes
  • Insert Endnotes
  • Configure Endnote Formats
  • Insert Citation, Placeholders
  • Insert Bibliography

Section B: Captions

  • Add Captions, Change Format
  • Exclude Labels from Captions

Section C: Shapes and Images

  • Insert and Format a Shape
  • Position and Align Shapes
  • Insert an Image
  • Apply Artistic Effects
  • Remove the Background
  • Wrap Text around Images
  • Add Quick Styles to Images

Section D: Résumés

  • Views, Table Tools
  • Header, Footer, Indentation
  • Insert, Add Styles to Text
  • Format

Section E: Cover Pages and Thank You Letters

  • Cover Page
  • Bulleted Text
  • Date, Save, Compatibility Mode
  • Share Files Online
  • Thank You Letter
  • Themes
  • Print Options

Section F: Research Papers

  • Date, Time
  • Insert Citations
  • Chart Tools, Bibliography, Endnotes
  • Export as a PDF

Access 2013 (77-424)
Session 1

Section A: Databases

  • What Is a Database?
  • Access Databases
  • Queries
  • Forms
  • Parts of Access Database
  • Tour of the Backstage View
  • Backstage View Recap
  • Get Help
  • Customize Quick Access Toolbar

Section B: Existing Data

  • Work with Existing Data
  • Adding Records to Labels
  • Updating Records
  • Deleting Records
  • Find Data
  • Replace Data
  • Sort Data
  • Filter Fields
  • Filter Multiple Fields
  • Filter Options
  • Add Row Totals
  • Change View
  • Run Queries
  • Forms
  • Reports
  • Navigation Options

Section C: Relational Databases

  • Flat vs. Relational Databases
  • Flat File
  • Relational Database
  • Rule 1
  • Rule 2
  • Rule 3
  • Rule 4
  • Rule 5
  • Identify Entities and Attributes
  • Planning a Database
  • Database Diagram

Access 2013 (77-424)
Session 2

Section A: Create a Database

  • Create Database with Template
  • Create Database with Wizard
  • Create Database in Old Format
  • Create a New Database

Section B: Create Tables

  • Create Tables in Datasheet View
  • Tables from Templates, Application Parts
  • Import Tables from Other Databases
  • Import External Data into Tables
  • Create Linked Tables from Other Sources
  • Create Tables in Design View
  • Format Tables, Hide Fields in Tables
  • Add Table Descriptions
  • Rename Tables

Section C: Create and Modify Fields

  • Table Views
  • Unique Values
  • Test Fields
  • Set Primary Key Fields, Auto Increment
  • Change Field Captions
  • Change Field Sizes
  • Change Field Data Types
  • Change Data Formats
  • Set Default Values
  • Require Value in Fields
  • Use of Input Masks
  • Validation Rules
  • Delete Fields

Section D: Manage Table Relationships

  • Create Field Lookups
  • Lookup Tips
  • Edit Reference between Tables
  • View Relationships
  • Create Relationships
  • Relationship Types
  • Edit Relationships
  • Enforce Referential Integrity
  • Modify Relationships

Access 2013 (77-424)
Session 3

Section A: Create Forms

  • Introduction to Creating Forms
  • Creating a Form
  • Create Form with Wizard
  • Split Forms and Blank Forms
  • Create Forms with Application Parts
  • Modify Forms
  • Layout View vs. Design View
  • Prebuilt Form Layouts
  • Manage Labels
  • Move Form Controls
  • Make Multiple Selections
  • Arrange Items in Forms
  • Work with Form Layouts

Section B: Enhance Forms

  • Insert Headers and Footers
  • Add Form Controls
  • Add a Button
  • Set Form Control Properties
  • Remove Form Controls

Section C: Organize Forms

  • Organizing a Form
  • Modify Tab Order in Forms
  • Modify Data Sources
  • Add Subforms

Section D: Format Forms

  • Format Forms, Apply Themes
  • Insert Backgrounds
  • Insert Images
  • Sort Records
  • Format Printing Layouts, Change Margins

Section E: Navigation Forms

  • Work with and Create Navigation Forms
  • Format Navigation Forms

Access 2013 (77-424)
Session 4

Section A: Queries

  • Purpose of Queries
  • Create Queries
  • Add Fields and Save Queries

Section B: Modify Queries

  • Hide and Remove Fields
  • Rename and Delete Queries
  • Modify and Sort Queries
  • Format Fields in Queries

Section C: Multitable Queries

  • Create Multitable Queries
  • Inner and Outer Joins

Section D: Criteria in Queries

  • Types of Criteria in Queries
  • Use Criteria in Queries
  • Use AND and OR in Queries
  • Use IN in Queries
  • Use NOT and BETWEEN in Queries
  • Use NULL in Queries
  • Use Wildcards in Queries
  • Use Parameters in Queries

Section E: Calculations in Queries

  • Calculated Fields
  • Expression Builder
  • Text Calculation
  • Numeric Calculation
  • Group and Summarize Data
  • Crosstab Queries
  • Return Top Result

Section F: Action Queries

  • Use Action Queries
  • Make Table Query
  • Append Query
  • Update Query
  • Delete Query
  • Recap Action Queries

Access 2013 (77-424)
Session 5

Section A: Create Reports

  • Build Reports
  • Create New Reports
  • Group Reports
  • Create Reports with Application Parts

Section B: Modify Reports

  • Modify Existing Reports
  • Manage Labels
  • Add Report Controls
  • Add Calculated Fields
  • Group Data by Fields
  • Sort Data
  • Change Sort Order
  • Modify Data Sources

Section C: Reports

  • Format Reports
  • Apply Themes and Add Backgrounds
  • Insert Images
  • Insert Headers and Footers
  • Insert Page Numbers
  • Format Reports into Multiple Columns

Section D: Print and Distribute Reports

  • Print and Distribute
  • Change Report Orientation
  • Set Margins
  • Print Reports
  • Export Data to Alternate Formats
  • Save and Run Export
  • Delete Reports

Section E: Finalize

  • Finalize Database
  • Setting a Form as a Startup Option
  • Saving Databases as Templates
  • Saving Databases to External Locations
  • Maintain Backward Compatibility

Section F: Protection

  • Protect a Database
  • Split Databases
  • Merge Databases
  • Encrypt Databases

Section G: Database Maintenance

  • Maintain a Database
  • Backup Database
  • Recover Data from Backups
  • Compact and Repair Database

Section H: Tips

  • Test Taking Tips

Excel 2013 (77-420)
Session 1

Section A: Introduction

  • Introduction to Excel
  • Excel Interface
  • Templates, Workspace, Quick Access
  • More Commands, Popular Commands
  • Camera Button, Remove Button
  • Ribbon
  • Customize Ribbon
  • Add, Remove, Custom Buttons

Section B: Navigating Excel

  • Touch Screen, Document Window
  • Basic Navigation

Section C: Shortcuts

  • Esc Key, Undo, Right-Click
  • Three Windows Shortcuts
  • Function Key Shortcuts
  • Ctrl Key Shortcuts
  • Copy, Paste, Print, Select All
  • Select Data Range, Save
  • New Document
  • Alt Key Shortcuts
  • Insert Column, Row, Worksheet
  • Visible Keys
  • Drop-Down, Ribbon

Section D: Creating and Manipulating Data

  • Entering Data
  • Auto Fill
  • Expand Data
  • Working with Auto Fill
  • Custom Lists
  • Creating Custom Lists
  • Text Strings
  • Active Cells
  • Grouping Worksheets
  • Ungrouping Worksheets
  • Flash Fill
  • Flash Fill Numbers
  • Column Headings

Section E: Managing Worksheets

  • Managing Worksheet, Copy and Move
  • Copy and Move Workbook
  • Rename, Inserting, Deleting Worksheets

Section F: Paste Special

  • Windows Copy and Paste Rule
  • Four Steps of Paste Special
  • Quick Multiplication
  • Benefits of Paste Special
  • Format Painter
  • Removing Duplicates

Section G: Changing Views

  • Changing Views, Zoom
  • Changing Workbook View
  • Mirror Images
  • Freeze Panes
  • Split the Window
  • Page Layout
  • Custom View
  • View Show

Excel 2013 (77-420)
Session 2

Section A: Formatting Data

  • Formatting Data, Color, Size
  • Change Sheet, Tab Color, Office Workbook
  • Change Office Themes
  • Backgrounds
  • Watermarks

Section B: Modify Cells

  • Modify Cell Alignment, Wrap Text
  • Indentation
  • Merge Cells
  • Apply Number Formats, Special Formats
  • Custom Format
  • Text to WordArt
  • Existing Text to WordArt

Section C: Tables

  • Find and Replace
  • Asterisk, Question Mark
  • Sorting
  • Filtering
  • Create Tables
  • Modify Tables
  • Total Rows
  • Define Titles, Go To
  • Remove Duplicates

Section D: Text Formulas

  • CONCATENATE
  • Working with CONCATENATE
  • Edit Formula
  • Correct Columns
  • Split Cell Contents Apart
  • Convert Formulas to Text
  • Delimiters
  • UPPER, LOWER, PROPER
  • LEFT
  • RIGHT, MID
  • TRIM

Section E: Operations

  • Define Order of Operations
  • Four Most Popular Operators
  • More Operators, CONCATENATE
  • SUM
  • AVERAGE, MIN, MAX
  • COUNT, COUNTA
  • AutoCalculate
  • Formula Auditing
  • Relative, Absolute Cell References
  • Mixed Cell References

Excel 2013 (77-420)
Session 3

Section A: Totals and Sparklines

  • Totaling Multiple Sheets
  • Working with Totaling Sheets
  • Quick Analysis, Grand Totals
  • Sparkline Graphics
  • Sparkline Tools
  • Incorrect Data
  • Consolidation
  • Hierarchical Outline

Section B: Subtotals

  • Using Subtotals, Subtotal Options
  • Selecting Visible Data

Section C: VLOOKUP

  • What Is VLOOKUP?
  • VLOOKUP Specifications
  • Name the Range
  • Column Index Number
  • VLOOKUP with Optional Argument

Section D: Nested Formulas

  • Using Nested Formulas
  • Absolute Value Formula
  • Nesting a Formula
  • Nested Formula Logic
  • FIND Formula
  • LEFT Formula
  • ROW, COLUMN Formula

Section E: Conditional Logic

  • Using Conditional Logic
  • IF Formula
  • Nested IF
  • Maintain Backward Compatibility
  • Text Wrap within Cells
  • Formula Wizard, AND
  • OR
  • NOT
  • IFERROR
  • SUMIF
  • COUNTIF
  • AVERAGEIF
  • SUMIFS
  • AVERAGEIFS
  • COUNTIFS

Excel 2013 (77-420)
Session 4

Section A: Excel Financial Formulas

  • Working with Financial Formulas
  • Finding the PMT Formula
  • PMT Function Arguments
  • Goal Seek
  • Solver
  • Solver Reports, Solver.com

Section B: What-If Scenarios

  • Scenario Manager
  • Scenario Reports
  • Introduction to Data Table
  • Quick Analysis Tool
  • Data Table Continued

Section C: Charts and Graphs

  • Definitions of Chart Types
  • Intro to Charts, Instant Charts
  • Adding Data to a Chart
  • Modifying and Customizing Charts
  • Graphical Charts
  • Working with Disproportionate Figures
  • Making a Combination Chart
  • Quick Analysis Charts, Move Chart
  • Switch Rows and Columns
  • Add Legend, Quick Layout, Change Colors
  • Resize a Chart
  • Saving a Chart as a Template

Excel 2013 (77-420)
Session 5

Section A: Advanced Operations

  • Working with Cells
  • Hiding Cells
  • Hiding Worksheets
  • PivotTables
  • PivotTable Layouts
  • Filter Options
  • Updating and Modifying Data
  • Grand Totals
  • Filter Data
  • Slicers
  • Timelines
  • Calculated Fields
  • Calculated Items

Section B: Conditional Formatting

  • Conditional Formatting Options
  • Manage Rules
  • Wildcard Characters
  • Top/Bottom Rules
  • Data Bars
  • Color Scales and Icon Sets
  • Alternate Row Shading via Formulas

Section C: Data Protection

  • Data Validation and Lists
  • Input Messages and Error Alerts
  • Data Validation Settings

Section D: Add Graphics

  • Add Graphics and Insert Comments
  • Insert Text Boxes
  • Insert Images
  • Remove Background
  • Position Objects
  • Insert SmartArt

Section E: Excel and the Web

  • Insert a Hyperlink
  • Open Non-Native Files
  • Import Files
  • Open Text File

Section F: Saving and Printing

  • Saving Worksheets
  • Document Inspector
  • Save Files to Remote Locations
  • Save Alternate File Formats
  • Print Worksheets
  • Headers and Footers
  • Repeat Headers
  • Set Print Scaling
  • Printing Options

Section G: Macros

  • Macro Capabilities
  • Macro Security
  • Options for Recording Macros
  • Shortcuts
  • Network
  • Recording a Macro
  • Test the Macro
  • Assigning a Button to a Macro
  • Shapes and Macros
  • Edit Macros
  • Macro Comment
  • Macro Statements
  • Run the Macro

Outlook 2013 Course (77-423)
Session 1

Section A: Outlook

  • Interface Tour, Navigation Options
  • Outlook Ribbon
  • Quick Steps
  • Search Mail

Section B: Outlook Settings

  • Customize Outlook Settings
  • Configure View
  • Sort Mail Messages
  • Task Pane
  • Status Bar
  • Manage Multiple Accounts
  • Add or Delete Email Accounts

Section C: New Messages

  • Create a Message
  • Add Cc and Bcc
  • Add another Email Address
  • Subject Field and Spelling Checker
  • Language Settings
  • Font Size
  • Format Text

Section D: Manage Messages

  • Reply to an Email
  • Reply to All
  • Forward Message
  • Include Original Message
  • Delete Emails
  • Create Automatic Replies
  • Message Options
  • Apply Quick Steps
  • Create and Manage Rules
  • Create and Assign Signatures
  • Conditional Formatting
  • Prioritize Messages
  • Add or Remove Attachments
  • Delegate Access

Section E: Format a Message

  • Insert Hyperlinks
  • Apply Themes and Styles
  • Insert Images
  • Add a Specific Signature
  • Format a Signature
  • Create and Use Quick Parts
  • Modify a Style

Outlook 2013 Course (77-423)
Session 2

Section A: Messages

  • Add New Local Folders
  • Move Messages into Folders
  • Flag Messages
  • Apply Categories
  • Sort Messages
  • Configure Junk Email Settings
  • Ignore Messages
  • Clean Up Messages
  • Mark as Read or Unread
  • Attachment Reminder Options
  • Search for Messages
  • Print Messages

Section B: Save and Back Up Messages

  • Save Messages
  • Text Only
  • Create Data Files

Section C: New Contacts

  • Create New Contacts
  • Edit Contact Info
  • Add New Contact
  • Import Contacts
  • Sharing Files
  • Manage Contact Lists

Section D: Groups

  • New Contact Group
  • Delete Members and Groups
  • Update Contacts within Groups
  • Search for Contacts
  • Print Contacts
  • New Search Folder
  • Keywords

Outlook 2013 Course (77-423)
Session 3

Section A: Calendars

  • Create, Manage Calendars
  • Schedule View
  • Go To
  • Calendar Navigation Options
  • Modify Time Zones
  • Delete Calendars
  • Create Multiple Calendars
  • Manage Calendar Groups
  • Share Calendars
  • Share Calendar Options

Section B: Calendar Items

  • Create Calendar Options
  • Calendar Options
  • Recurrence
  • Drag and Drop Appointments
  • Attachments for Appointments
  • Cancel Calendar Items
  • Categorize Calendar Items
  • Scheduling Assistant
  • Forward Calendar Items
  • Respond to Invitations
  • Share Meeting Notes
  • Search Calendar
  • Print Calendar

Section C: Tasks

  • Quick Speed Keys
  • Create and Manage Tasks
  • Update Tasks Status
  • Search for Tasks
  • Print Tasks
  • Create and Manage Notes
  • Attach Notes to Contacts
  • Create Journal Entries

PowerPoint 2013 Course (77-422)
Session 1

Section A: Tour of the Interface

  • Interface Tour, Templates
  • The Ribbon
  • Status Bar
  • Backstage View
  • Reuse Slides
  • Project Plan

Section B: Organize Your Presentation

  • Creating a Presentation
  • Changing Presentation Themes
  • Modify Slide Backgrounds
  • Adding and Modifying Slides
  • Duplicate, Hide Slides
  • Apply Styles to Slides
  • Change Slide Layout

Section C: Inserting and Formatting Shapes

  • Inserting Slide Content
  • Inserting Shapes, Resizing Shapes
  • Apply Borders to Shapes
  • Modify Shape Backgrounds
  • Apply Styles to Shapes
  • Align and Group Shapes
  • Order Shapes
  • Modify Slide Order
  • Merge and Ungroup Shapes

Section D: Inserting and Formatting Text

  • Formatting and Text Styles
  • Change Text to WordArt

PowerPoint 2013 Course (77-422)
Session 2

Section A: Customize a Blank Document

  • Create Bulleted Lists
  • Create Multiple Columns
  • Numbered Lists
  • Insert Hyperlinks
  • Hyperlinks Insert Menu
  • Hyperlinks Action
  • Email Hyperlinks
  • Link to Slide Content

Section B: Insert and Format Tables

  • Insert and Create Tables
  • Apply Table Styles
  • Import Tables
  • Insert Excel Table
  • Modify Tables

Section C: Create and Modify Charts

  • Create Chart
  • Modify Chart Type
  • Modify Chart Style
  • Insert and Import Chart
  • Add and Modify a Legend

Section D: SmartArt

  • Create SmartArt
  • Change Color, Change Text
  • Move Text, Reverse Direction
  • Insert Images
  • Resize Images
  • Apply Effects
  • Create Screenshot
  • Create Photo Album

Section E: Insert Media

  • Working with Media
  • Trimming Media
  • Set Start and Stop Times
  • Link to External Media
  • Insert Audio
  • Inspect Presentation

Section F: Adding Animations and Transitions

  • Adding Transitions
  • Working with Transitions
  • Animate Slide Content, Animation Pane
  • Animation Duration
  • Add Animation to Text
  • Add Animation to Shapes
  • Paths to Animations
  • Animation on Charts
  • Animate a Picture
  • Entrance Animations
  • SmartArt Animations
  • Reorder Animations

PowerPoint 2013 Course (77-422)
Session 3

Section A: Slide Masters

  • Customizing Slides, Slide Master
  • Insert Master Layout
  • Master Layout Backgrounds
  • Name Master Layout
  • New Slide Master
  • Add and Change Background

Section B: Creating Custom Layouts

  • Add a Picture to Master
  • Apply Master Layout
  • Add Header and Footer
  • Add Notes and Handouts
  • Modifying Presentation Options
  • Setup Options

Section C: Presentation Properties

  • Modify Presentation Properties
  • Create Custom Slide Show
  • Rehearse Timings and Configuration
  • Configuring Slide Show Options
  • Altering Presentation Views
  • Section Headers

Section D: Printing Presentations

  • Printer Selection and Color Options
  • Printer Settings
  • Print Selections

Section E: Saving Presentations

  • Saving the Presentation
  • Sharing the Presentation
  • Present Online
  • Export and Compatibility Checker

Section F: Navigating and Annotating

  • Presenting the Presentation
  • Presenter View
  • Configure Slide Show Resolution
  • Adding Password Protection
  • Restrict Permissions
  • Proof Presentations
  • Merge Multiple Presentations

Section G: Checking the Presentation

  • Inspect Document
  • Compress Media
  • Compatibility and Accessibility
  • Embed Fonts