Discover what you can learn.
With video courses for work, study and leisure.
Discover what you can learn.
With video courses for work, study and leisure.
Word 2013 Overview
|
00:44 |
|
Getting Started with Word 2013 - Lesson Introduction
|
00:25 |
|
Display a Document
|
07:21 |
Working with the Ribbon
|
08:16 |
|
Create a Word Document
|
05:46 |
|
AutoCorrection
|
07:50 |
|
Printing in Word
|
05:29 |
|
Saving in Word
|
06:35 |
|
Help Function in Word
|
03:04 |
| Quiz for course „Word 2013 Introduction“ | |
|
Editing a Document - Lesson Introduction
|
00:15 |
|
Navigate and Select Text
|
07:33 |
|
Modify Text
|
04:11 |
|
Find and Replace Text
|
07:27 |
| Quiz for course „Editing a Document in Word“ | |
|
Formatting Text and Paragraphs - Lesson Introduction
|
00:29 |
|
Apply Character Formatting
|
06:27 |
|
Align Text Using Tabs
|
07:52 |
|
Display Text as List Items
|
07:20 |
|
Control Paragraph Layout
|
06:58 |
|
Apply Borders and Shading
|
04:31 |
|
Apply Styles
|
05:32 |
|
Manage Formatting
|
07:35 |
| Quiz for course „Formatting Text and Paragraphs in Word 2013“ | |
|
Adding Tables - Lesson Introduction
|
00:27 |
|
Insert a Table
|
07:23 |
|
Modify a Table
|
08:52 |
|
Format a Table
|
07:32 |
|
Convert Text to a Table
|
05:01 |
| Quiz for course „Adding Tables in Word 2013“ | |
|
Managing Lists - Lesson Introduction
|
00:30 |
|
Sort a List
|
03:24 |
|
Renumber a List
|
05:22 |
|
Customize a List
|
10:45 |
| Quiz for course „Managing Lists in Word 2013“ | |
|
Inserting Graphic Objects - Lesson Introduction
|
00:29 |
|
Insert Symbols and Special Characters
|
07:05 |
|
Add Images to a Document
|
10:26 |
| Quiz for course „Inserting Graphic Objects in Word 2013“ | |
|
Controlling Page Appearance - Lesson Introduction
|
00:35 |
|
Apply a Page Border and Color
|
03:55 |
|
Add a Watermark
|
05:07 |
|
Add Headers and Footers
|
07:59 |
|
Control Page Layout
|
06:28 |
| Quiz for course „Controlling Page Appearance in Word 2013“ | |
|
Proofing a Document - Lesson Introduction
|
00:36 |
|
Check Spelling and Grammar
|
08:20 |
|
Other Proofing Tools
|
03:44 |
|
Check Accessibility
|
05:34 |
| Quiz for course „Proofing a Document in Word 2013“ | |
|
Customizing the Word Environment - Lesson Introduction
|
00:23 |
|
Customize the Word Options
|
04:17 |
|
Customize the Word Interface
|
06:14 |
|
Additional Save Options
|
06:05 |
| Quiz for course „Customizing the Word Environment“ | |
|
Tables and Charts Overview
|
00:41 |
|
Working with Tables and Charts - Lesson Introduction
|
00:29 |
|
Sort Table Data
|
04:53 |
|
Control Cell Layout
|
07:13 |
|
Perform Calculations in a Table
|
06:12 |
|
Create a Chart
|
06:43 |
| Quiz for course „Working with Tables and Charts in Word 2013“ | |
|
Customizing Formats Using Styles and Themes - Lesson Introduction
|
00:22 |
|
Create and Modify Text Styles
|
08:13 |
|
Create Custom List or Table Styles
|
06:36 |
|
Apply Document Themes
|
05:00 |
| Quiz for course „Customizing Formats Using Styles and Themes in Word 2013“ | |
|
Using Images in a Document - Lesson Introduction
|
00:19 |
|
Resize an Image
|
04:24 |
|
Adjust Image Appearance
|
03:36 |
|
Advanced Image Management
|
05:28 |
|
Integrate Pictures and Text
|
07:37 |
|
Insert and Format Screenshots
|
04:34 |
|
Insert Video
|
06:48 |
| Quiz for course „Using Images in a Word 2013 Document“ | |
|
Creating Custom Graphic Elements - Lesson Introduction
|
00:24 |
|
Create Text Boxes and Pull Quotes
|
06:31 |
|
Draw Shapes
|
03:08 |
|
Add WordArt and Other Text Effects
|
04:32 |
|
Create Complex Illustrations with SmartArt
|
06:41 |
| Quiz for course „Creating Custom Graphic Elements in Word 2013“ | |
|
Inserting Content Using Quick Parts - Lesson Introduction
|
00:23 |
|
Insert Building Blocks
|
05:49 |
|
Create and Modify Building Blocks
|
07:54 |
|
Insert Fields Using Quick Parts
|
09:33 |
| Quiz for course „Inserting Content Using Quick Parts in Word 2013“ | |
|
Controlling Text Flow - Lesson Introduction
|
00:24 |
|
Control Paragraph Flow in Word
|
04:12 |
|
Insert Section Breaks
|
08:30 |
|
Insert Columns in Word
|
05:30 |
|
Link Text Boxes to Control Text Flow
|
05:56 |
| Quiz for course „Controlling Text Flow in Word 2013“ | |
|
Using Templates - Lesson Introduction
|
00:27 |
|
Create a Document Using a Template
|
06:41 |
|
Create a Template
|
08:02 |
|
Using Mail Merge - Lesson Introduction
|
00:22 |
|
The Mail Merge Features
|
12:25 |
|
Merge Envelopes and Labels
|
10:08 |
|
Create a Data Source Using Word
|
04:23 |
| Quiz for course „Using Mail Merge“ | |
|
Using Macros - Lesson Introduction
|
00:22 |
|
Automate Tasks Using Macros
|
06:36 |
|
Create a Macro
|
09:10 |
| Quiz for course „Using Macros in Word 2013“ | |
|
Collaborating on Documents - Overview
|
00:40 |
|
Collaborating on Documents - Lesson Introduction
|
00:33 |
|
Modify User Information
|
05:35 |
|
Share a Document
|
04:15 |
|
Compare Document Changes
|
04:06 |
|
Review a Document
|
03:53 |
|
Merge Document Changes
|
06:22 |
|
Review Tracked Changes
|
04:09 |
|
Coauthor Documents
|
09:03 |
| Quiz for course „Collaborating on Documents with Word 2013“ | |
|
Adding Reference Marks and Notes - Lesson Introduction
|
00:32 |
|
Add Captions
|
06:15 |
|
Add Cross-References in Word
|
08:09 |
|
Add Bookmarks
|
04:45 |
|
Add Hyperlinks in Word
|
05:04 |
|
Insert Footnotes and Endnotes
|
04:28 |
|
Add Citations and a Bibliography
|
09:49 |
|
Simplifying and Managing Long Documents - Lesson Introduction
|
00:38 |
|
Insert Blank and Cover Pages
|
06:43 |
|
Insert an Index
|
08:42 |
|
Insert a Table of Contents
|
07:35 |
|
Insert an Ancillary Table
|
05:10 |
|
Manage Outlines
|
07:01 |
|
Create a Master Document
|
08:15 |
|
Securing a Document - Lesson Introduction
|
00:25 |
|
Suppress Information
|
07:37 |
|
Set Formatting and Editing Restrictions
|
05:07 |
|
Add a Digital Signature to a Document
|
07:07 |
|
Restrict Document Access
|
04:54 |
| Quiz for course „Securing a Document in Word 2013“ | |
|
Forms - Overview
|
00:31 |
|
Create Forms
|
10:33 |
|
Manipulate Forms
|
04:52 |
| Quiz for course „Forms in Word 2013“ | |
|
Managing Document Versions - Lesson Introduction
|
00:30 |
|
Create a New Document Version
|
08:51 |
|
Compare and Merge Document Versions
|
07:36 |
| Quiz for course „Managing Document Versions in Word 2013“ | |
|
Working with Legacy Form Fields - Lesson Introduction
|
00:32 |
|
Modify Legacy Form Field Properties
|
05:25 |
|
Form Data Conversion
|
05:45 |
| Quiz for course „Working with Legacy Form Fields“ | |
|
Getting Started with Excel 2013 - Lesson Introduction
|
00:22 |
|
Elements of the Application Window
|
08:06 |
|
Elements of the Workbook Window
|
16:06 |
|
Create a Basic Worksheet
|
07:14 |
|
The Help System
|
03:58 |
| Quiz for course „Excel 2013 Introduction“ | |
|
Performing Calculations - Lesson Introduction
|
00:14 |
|
Create Formulas in a Worksheet
|
10:17 |
|
Insert SUM and AVERAGE Functions
|
12:22 |
|
Insert MIN and MAX Functions
|
10:37 |
|
Cut and Paste Commands
|
08:48 |
|
Absolute Cell References
|
10:11 |
| Quiz for course „Performing Calculations in Excel 2013“ | |
|
Modifying a Worksheet - Lesson Introduction
|
00:34 |
|
The Auto Fill Feature
|
09:20 |
|
The Undo and Redo Commands
|
06:46 |
|
Column Width and Row Height Alteration Methods
|
07:06 |
|
The Hide and Unhide Options
|
04:35 |
|
The Insert and Delete Options
|
08:37 |
|
Cell Names and Range Names
|
07:01 |
|
The Find and Replace Commands
|
05:02 |
|
Spell Check a Worksheet
|
06:34 |
| Quiz for course „Modifying a Worksheet in Excel 2013“ | |
|
Formatting a Worksheet - Lesson Introduction
|
00:25 |
|
Modify Fonts
|
07:44 |
|
Add Borders and Color to Cells
|
06:48 |
|
Apply Number Formats
|
05:23 |
|
Align Cell Contents
|
08:33 |
|
Apply Cell Styles
|
09:18 |
| Quiz for course „Formatting a Worksheet in Excel 2013“ | |
|
Printing Workbook Contents - Lesson Introduction
|
00:28 |
|
Define the Basic Page Layout
|
07:49 |
|
Refine the Page Layout and Apply Print Options
|
08:10 |
| Quiz for course „Printing Workbook Contents in Excel 2013“ | |
|
Managing Large Workbooks - Lesson Introduction
|
00:24 |
|
Format Worksheet Tabs
|
05:37 |
|
Managing Worksheets
|
08:04 |
|
Manage the View of Worksheets and Workbooks
|
05:17 |
| Quiz for course „Managing Large Workbooks in Excel 2013“ | |
|
Customizing the Excel Environment - Lesson Introduction
|
00:20 |
|
Customize General and Language Options
|
07:32 |
|
Customize Formula Options
|
03:38 |
|
Customize Proofing and Save Options
|
02:49 |
|
Customize the Quick Access Toolbar
|
07:40 |
|
Customize the Ribbon
|
09:18 |
|
Customize the Functionality of Excel by Enabling Add-Ins
|
04:20 |
|
Customize Advanced Options
|
05:06 |
|
Customize Trust Center Options
|
03:11 |
| Quiz for course „Customizing the Excel Environment“ | |
|
Creating Advanced Formulas - Lesson Introduction
|
00:46 |
|
Add Range Names
|
06:49 |
|
Edit and Delete Range Names
|
03:34 |
|
Use Range Names in a Formula
|
06:12 |
|
Use Specialized Functions
|
06:36 |
|
Use the SUM Function
|
02:47 |
|
Use the AVERAGE Function
|
03:20 |
|
Use the MIN Function
|
03:40 |
|
Use the MAX Function
|
03:10 |
|
Use COUNT, COUNTA and COUNTIF Functions
|
07:03 |
|
Use the ROUND Function
|
04:46 |
|
Use the AND Function
|
04:23 |
|
Use the CONCATENATE Function
|
04:44 |
|
Use HLOOKUP and VLOOKUP Functions
|
05:02 |
| Quiz for course „Creating Advanced Formulas in Excel 2013“ | |
|
Analyzing Data with Logical Functions - Lesson Introduction
|
00:36 |
|
Work with Logical Functions
|
06:09 |
|
Use the Nested IF Function
|
03:53 |
| Quiz for course „Analyzing Data with Logical Functions in Excel 2013“ | |
|
Organizing Worksheet Data with Tables - Lesson Introduction
|
00:33 |
|
Create and Modify Tables
|
04:57 |
|
Sort Data
|
03:52 |
|
Filter Data with the Auto Filter
|
02:30 |
|
Filter Data with the Advanced Filter
|
05:28 |
|
Remove Duplicates
|
04:02 |
|
Total Row
|
06:34 |
| Quiz for course „Organizing Worksheet Data with Tables“ | |
|
Visualizing Data with Charts - Lesson Introduction
|
00:31 |
|
Create Charts
|
09:37 |
|
Change the Default Chart Type
|
03:37 |
|
Modify Charts
|
10:04 |
|
Edit Chart Axes
|
09:19 |
|
Format Charts
|
03:37 |
|
Create a Trendline in Excel 2013
|
09:41 |
|
Create Advanced Charts
|
11:52 |
| Quiz for course „Visualizing Data with Charts in Excel 2013“ | |
|
Analyzing Data with PivotTables, Slicers, and PivotCharts - Lesson Introduction
|
00:25 |
|
Create a PivotTable
|
07:15 |
|
Advanced Field Settings
|
07:09 |
|
Filter Data by Using Slicers
|
05:40 |
|
Analyze Data by Using PivotCharts
|
07:52 |
| Quiz for course „Analyzing Data with PivotTables, Slicers, and PivotCharts“ | |
|
Inserting Graphics - Lesson Introduction
|
00:25 |
|
Insert and Modify Graphic Objects
|
06:59 |
|
Insert and Group Shapes
|
07:12 |
|
Incorporate SmartArt in Excel 2013
|
06:11 |
| Quiz for course „Inserting Graphics in Excel 2013“ | |
|
Enhancing Workbooks - Lesson Introduction
|
00:36 |
|
Comments in Excel 2013
|
05:00 |
|
Hyperlinks in Excel 2013
|
05:21 |
|
Watermarks in Excel 2013
|
04:39 |
|
Manage Themes in Excel 2013
|
05:18 |
|
Create and Use Templates
|
06:12 |
|
Protect Files
|
08:27 |
| Quiz for course „Enhancing Workbooks in Excel 2013“ | |
|
Automating Worksheet Functionality - Lesson Introduction
|
00:25 |
|
Update Workbook Properties
|
03:40 |
|
Apply Conditional Formatting
|
05:43 |
|
Edit a Conditional Formatting Rule
|
04:47 |
|
Add Data Validation Criteria
|
07:58 |
| Quiz for course „Automating Worksheet Functionality in Excel 2013“ | |
|
Auditing Worksheets - Lesson Introduction
|
00:39 |
|
Trace Cells
|
02:58 |
|
Troubleshoot Invalid Data
|
02:26 |
|
Troubleshoot Invalid Formulas
|
06:08 |
|
Evaluate Formulas
|
02:39 |
|
Watch Formulas
|
02:05 |
|
Create a Data List Outline
|
03:00 |
|
Add Subtotals to Grouped Data
|
03:52 |
| Quiz for course „Auditing Worksheets in Excel 2013“ | |
|
Analyzing and Presenting Data - Lesson Introduction
|
00:22 |
|
Create Sparklines
|
04:51 |
|
Create Scenarios
|
04:49 |
|
Perform a What-If Analysis
|
03:02 |
| Quiz for course „Analyzing and Presenting Data in Excel 2013“ | |
|
Working with Multiple Workbooks - Lesson Introduction
|
00:28 |
|
Consolidate Data
|
03:56 |
|
Link Cells in Different Workbooks
|
04:52 |
|
Merge Workbooks
|
02:38 |
| Quiz for course „Working with Multiple Workbooks in Excel 2013“ | |
|
Exporting Excel Data - Lesson Introduction
|
00:28 |
|
Export Excel Data
|
05:19 |
|
Import a Delimited Text File
|
05:46 |
|
Integrate Excel Data with the Web
|
06:01 |
|
Create a Web Query
|
06:10 |
| Quiz for course „Exporting Excel Data“ | |
|
Getting Started with PowerPoint 2013 - Lesson Introduction
|
00:43 |
|
Navigate the PowerPoint Environment
|
08:23 |
|
Create and Save a PowerPoint Presentation
|
04:21 |
|
Use PowerPoint Help
|
04:01 |
| Quiz for course „PowerPoint 2013 Introduction“ | |
|
Developing a PowerPoint Presentation - Lesson Introduction
|
00:22 |
|
Create a Presentation from a Template
|
03:53 |
|
View and Navigate a Presentation
|
07:24 |
|
Edit Text in PowerPoint 2013
|
06:57 |
|
Add, Delete and Modify Slides
|
05:56 |
|
Arrange Slides
|
03:53 |
|
Work with Themes
|
05:11 |
| Quiz for course „Developing a PowerPoint Presentation“ | |
|
Performing Advanced Text Editing - Lesson Introduction
|
00:37 |
|
Format Characters in PowerPoint 2013
|
05:31 |
|
Use Bullets and Number Lists
|
02:59 |
|
Format Paragraphs
|
04:04 |
|
Format Text Boxes in PowerPoint 2013
|
05:48 |
| Quiz for course „Performing Advanced Text Editing in PowerPoint 2013“ | |
|
Adding Graphical Elements to Your Presentation - Lesson Introduction
|
00:33 |
|
Insert Clip Art and Images in PowerPoint 2013
|
04:56 |
|
Insert Shapes in PowerPoint 2013
|
06:47 |
| Quiz for course „Adding Graphical Elements to Your Presentation“ | |
|
Modifying Objects in Your Presentation - Lesson Introduction
|
00:26 |
|
Edit Objects
|
05:06 |
|
Format Objects
|
05:04 |
|
Group Objects
|
03:09 |
|
Arrange Objects
|
04:57 |
|
Animate Objects
|
05:13 |
| Quiz for course „Modifying Objects in Your Presentation“ | |
|
Adding Tables to Your Presentation - Lesson Introduction
|
00:56 |
|
Create a Table in PowerPoint 2013
|
05:11 |
|
Format a Table in PowerPoint 2013
|
04:28 |
|
Insert a Table from Other Office Applications
|
05:15 |
| Quiz for course „Adding Tables to Your Presentation in PowerPoint 2013“ | |
|
Adding Charts to Your Presentation - Lesson Introduction
|
00:49 |
|
Create Charts in Powerpoint 2013
|
05:12 |
|
Format Charts in PowerPoint 2013
|
06:59 |
|
Insert a Chart from Excel
|
04:01 |
| Quiz for course „Adding Charts to Your Presentation in PowerPoint 2013“ | |
|
Preparing to Deliver Your Presentation - Lesson Introduction
|
01:03 |
|
Review Your Presentation
|
02:46 |
|
Apply Transitions
|
03:01 |
|
Print Your Presentation
|
04:18 |
|
Deliver Your Presentation in PowerPoint 2013
|
04:21 |
|
Save a Presentation as a PDF
|
02:45 |
| Quiz for course „Preparing to Deliver Your Presentation in PowerPoint 2013“ | |
|
Modifying the PowerPoint Environment - Lesson Introduction
|
00:50 |
|
Customize the Ribbon
|
04:09 |
|
Customize the Quick Access Toolbar and Status Bar
|
06:10 |
|
Work with Windows Simultaneously
|
02:04 |
|
Set PowerPoint 2013 Options
|
03:20 |
| Quiz for course „Modifying the PowerPoint Environment“ | |
|
Customizing Design Templates - Introduction
|
00:37 |
|
Work with Slide Masters
|
04:01 |
|
Create a Custom Slide Layout
|
05:14 |
|
Add Headers and Footers
|
05:47 |
|
Modify the Notes Master and the Handout Master
|
04:26 |
| Quiz for course „Customizing Design Templates in PowerPoint 2013“ | |
|
Adding SmartArt to a Presentation - Introduction
|
00:32 |
|
Adding SmartArt to a Presentation
|
03:21 |
|
Modify SmartArt
|
04:06 |
| Quiz for course „Adding SmartArt to a Presentation with PowerPoint 2013“ | |
|
Working with Media and Animations - Introduction
|
00:42 |
|
Add Audio to a Presentation
|
04:45 |
|
Add Video to a Presentation
|
03:41 |
|
Set Video Playback Options
|
03:20 |
|
Create Custom Animation Effects
|
06:15 |
|
Timing Slide Transitions
|
03:57 |
| Quiz for course „Working with Media and Animations in PowerPoint 2013“ | |
|
Collaborating on a Presentation - Introduction
|
00:41 |
|
Add and Manage Sections and Comments
|
05:14 |
|
Compare and Merge Presentations
|
05:19 |
|
Share a Presentation on the Web
|
07:01 |
| Quiz for course „Collaborating on a Presentation with PowerPoint 2013“ | |
|
Customizing a Slide Show - Introduction
|
00:57 |
|
Annotate a Presentation
|
04:14 |
|
Set Up and Create a Slide Show
|
05:11 |
|
Add Action Buttons to a Presentation
|
05:34 |
|
Record a Presentation
|
05:44 |
| Quiz for course „Customizing a Slide Show in PowerPoint 2013“ | |
|
Securing and Distributing a Presentation - Introduction
|
00:48 |
|
Secure a Presentation
|
04:17 |
|
Present a Slide Show Online
|
05:49 |
|
Convert a Presentation to a Video
|
02:51 |
|
Package a Presentation
|
05:01 |
| Quiz for course „Securing and Distributing a Presentation“ | |
|
Overview: Access 2013
|
01:05 |
|
Introduction: Getting Started With Access
|
00:31 |
|
Orientation to Access
|
04:35 |
|
How to Edit Tables and Rows
|
05:04 |
|
The Records Bar in Access
|
01:57 |
|
How to Use Forms for Data Entry
|
04:15 |
|
How to Use Queries
|
04:13 |
|
How to Use Reports
|
01:11 |
|
Explore Access Ribbon Commands
|
01:13 |
|
Create a Simple Access Database
|
12:59 |
|
How to Create a Form
|
06:13 |
|
Get Help in Microsoft Access
|
02:52 |
|
Summary: Getting Started With Access
|
00:35 |
| Quiz for course „Getting Started with Access“ | |
|
Introduction: Working With Table Data in Access
|
00:52 |
|
How to Modify Table Data
|
13:54 |
|
Sort and Filter Records in Access
|
09:04 |
|
Purpose of Primary Key
|
03:34 |
|
Configuring Form Lookup Field in Access
|
09:12 |
|
Summary: Working With Table Data in Access
|
00:38 |
| Quiz for course „Working With Table Data in Access 2013“ | |
|
Introduction: Querying a Database in Access
|
00:58 |
|
How to Join Data From Different Tables in a Query
|
12:28 |
|
How to Sort and Filter Data in a Query
|
14:44 |
|
Perform Calculations in a Query
|
11:10 |
|
Summary: Querying a Database in Access
|
00:24 |
| Quiz for course „Querying a Database in Access 2013“ | |
|
Introduction: Creating advanced Queries in Access
|
00:50 |
|
How to Create Parameter Queries
|
05:02 |
|
Use Wildcards in a Parameter Query
|
03:31 |
|
How to Create a Query With Multiple Parameters
|
04:23 |
|
How to Create Action Queries
|
07:53 |
|
How to Create Unmatched and Duplicate Queries
|
07:20 |
|
Summarizing Data in Access
|
05:25 |
|
Summary: Creating Advanced Queries in Access
|
00:24 |
| Quiz for course „Creating Advanced Queries in Access 2013“ | |
|
Introduction: Generating Reports in Access
|
00:57 |
|
How to Create a Report
|
05:47 |
|
Using the Report Wizard in Access
|
04:48 |
|
How to Add Controls to a Report
|
08:07 |
|
How to Enhance the Appearance of a Report
|
07:28 |
|
Preparing a Report for Print in Access
|
04:53 |
|
Summary: Generating Reports in Access
|
00:26 |
| Quiz for course „Generating Reports in Access 2013“ | |
|
Introduction: Customizing the Access Environment
|
00:22 |
|
The Access Options Dialog Box
|
07:28 |
|
Summary: Customizing the Acess Environment
|
00:22 |
|
Follow Up in Access
|
00:57 |
| Quiz for course „Customizing the Access 2013 Environment“ | |
|
Overview: Designing a Relational Database in Access
|
01:15 |
|
Introduction: Designing a Relational Database in Access
|
00:40 |
|
Analyzing the Relational Database Design Process
|
00:25 |
|
How to Create a Table in Access
|
08:12 |
|
How to Create a Table Relationship in Access
|
05:51 |
|
Summary: Designing a Relational Database in Access
|
00:34 |
| Quiz for course „Designing a Relational Database in Access 2013“ | |
|
Introduction: Joining Tables in Access
|
00:50 |
|
How to Create Inner and Outer Joins
|
08:05 |
|
Join Unrelated Tables
|
04:04 |
|
How to Create a Self Join
|
03:47 |
|
Modify Data in a SubDatasheet
|
06:19 |
|
How to Create Subqueries
|
05:50 |
|
Summary: Joining Tables in Access
|
00:36 |
| Quiz for course „Joining Tables in Access 2013“ | |
|
Introduction: Organizing a Database for Efficiency in Access
|
00:45 |
|
How to Run the Table Analyzer Wizard
|
07:59 |
|
How to Create Many to Many Relationship
|
04:47 |
|
How to Improve Table Structure
|
06:11 |
|
Summary: Organizing a Database for Efficiency in Access
|
00:25 |
| Quiz for course „Organizing a Database for Efficiency in Access 2013“ | |
|
Introduction: Sharing Data Across Applications in Access
|
01:27 |
|
How to Import Data from Text File
|
06:26 |
|
How to Import Data from Excel File
|
04:34 |
|
How to Export Data to Text File Formats
|
06:34 |
|
How to Export Data to Excel
|
03:57 |
|
Merging Access Data With Word
|
07:11 |
|
Summary: Sharing Data Across Applications in Access
|
00:52 |
| Quiz for course „Sharing Data Across Applications in Access 2013“ | |
|
Introduction: Advanced Reporting in Access
|
00:47 |
|
How to Make Report Design Modifications
|
17:08 |
|
Formating Reports in Access
|
07:35 |
|
How to Add Data Bars to Reports
|
03:49 |
|
How to Add a Calculated Field to a Report
|
05:51 |
|
How to Add a Subreport to an Existing Report
|
05:59 |
|
Summary: Advanced Reporting in Access
|
00:27 |
|
Follow Up in Access 2013
|
00:49 |
| Quiz for course „Advanced Reporting in Access 2013“ | |
|
Overview: Implementing Advanced Form Design in Access
|
01:23 |
|
Introduction: Implementing Advanced Form Design in Access
|
00:47 |
|
How to Add Controls to Forms
|
03:37 |
|
Creating Subforms
|
03:45 |
|
How to Organize Information With Tab Pages
|
06:07 |
|
Enhancing Navigation of Forms
|
06:30 |
|
Applying Conditional Formatting
|
03:51 |
|
Summary: Implementing Advanced Form Design in Access
|
01:00 |
| Quiz for course „Implementing Advanced Form Design in Access 2013“ | |
|
Introduction: Using Data Validation in Access
|
01:01 |
|
The Field and Record Validation in Access
|
03:11 |
|
The Form Validation in Access
|
03:45 |
|
Summary: Using Data Validation in Access
|
00:29 |
| Quiz for course „Using Data Validation in Access 2013“ | |
|
Introduction: Using Macros to Improve User Interface Design in Access
|
00:34 |
|
How to Create a Macro in Access
|
03:24 |
|
Restricting Records Using a Condition
|
03:22 |
|
Validating Data Using a Macro
|
06:01 |
|
Automating Data Entry Using a Macro
|
04:20 |
|
How to Convert a Macro to VBA in Access
|
02:14 |
|
Summary: Using Macros to Improve User Interface Design in Access
|
00:39 |
| Quiz for course „Using Macros to Improve User Interface Design in Access 2013“ | |
|
Introduction: Using Advanced Database Management in Access
|
00:56 |
|
How to Link Tables to External Data Sources
|
03:34 |
|
Managing a Database in Access
|
04:15 |
|
How to Determine Object Dependency
|
02:07 |
|
Documenting a Database in Access
|
03:23 |
|
Analyzing the Performance of a Database
|
01:43 |
|
Summary: Using Advanced Database Management in Access
|
00:51 |
| Quiz for course „Using Advanced Database Management in Access 2013“ | |
|
Introduction: Distributing and Securing a Database in Access
|
01:02 |
|
How to Split a Database for Multiple User Access
|
03:13 |
|
How to Implement Security in Access
|
01:52 |
|
Setting Passwords in Access
|
02:08 |
|
Converting an Access Database to an ACCDE File
|
02:25 |
|
Packaging a Database With a Digital Signature
|
02:25 |
|
Summary: Distributing and Securing a Database in Access
|
00:41 |
| Quiz for course „Distributing and Securing a Database in Access 2013“ | |
|
Introduction: Managing Switchboards in Access
|
00:42 |
|
How to Create a Database Switchboard in Access
|
03:39 |
|
Modifying a Database Switchboard
|
02:32 |
|
Setting Startup Options
|
01:54 |
|
Summary: Managing Switchboards in Access
|
00:25 |
|
Closing: Access 2013
|
00:36 |
| Quiz for course „Managing Switchboards in Access 2013“ | |
|
Overview: Outlook 2013
|
00:49 |
|
Introduction: Getting Started With Outlook 2013
|
00:32 |
|
How to Identify the Elements of the Application Window
|
06:32 |
|
How to Identify the Workspaces
|
05:16 |
|
Creating and Sending an Email
|
02:22 |
|
Reading and Responding to Emails
|
03:50 |
|
Printing an Email Message
|
03:05 |
|
Deleting Email Messages
|
03:10 |
|
How to Use the Outlook Help
|
03:49 |
|
Summary: Getting Started With Outlook 2013
|
00:24 |
| Quiz for course „Getting Started with Outlook 2013“ | |
|
Introduction: Composing Messages in Outlook
|
00:30 |
|
How to Create an Email Message
|
04:02 |
|
Checking the Spelling and Grammar
|
04:38 |
|
How to Format Message Content
|
03:51 |
|
Pasting in an Email Message
|
03:39 |
|
Attaching Files and Items
|
01:51 |
|
Enhancing an Email Message With an Image
|
04:02 |
|
Enhancing an Email Message With SmartArt and Themes
|
05:20 |
|
How to Specify Font Options
|
04:46 |
|
How to Create and Apply an Email Signature
|
03:35 |
|
Summary: Composing Messages in Outlook
|
00:25 |
| Quiz for course „Composing Messages in Outlook 2013“ | |
|
Introduction: Reading and Responding to Messages in Outlook
|
00:27 |
|
How to Customize Reading Options
|
03:33 |
|
Working With Attachments
|
02:58 |
|
Using Tracking Options
|
03:47 |
|
How to Recall a Sent Message
|
03:16 |
|
Summary: Reading and Responding to Messages in Outlook
|
00:24 |
| Quiz for course „Reading and Responding to Messages in Outlook 2013“ | |
|
Introduction: Managing Your Messages in Outlook
|
00:34 |
|
How to Use Tags to Manage Messages
|
05:02 |
|
How to Use Flags to Manage Messages
|
04:40 |
|
How to Use Commands to Manage Messages
|
04:08 |
|
Organizing Messages Using Folders
|
04:19 |
|
Summary: Managing Your Messages
|
00:23 |
| Quiz for course „Managing Your Messages in Outlook 2013“ | |
|
Introduction: Managing Your Calendar in Outlook
|
00:33 |
|
How to View the Calendar
|
06:14 |
|
Managing Appointments
|
04:51 |
|
Responding to a Meeting Request
|
03:50 |
|
Proposing a New Time for a Meeting
|
02:59 |
|
How to Create a Recurring Meeting Request
|
06:35 |
|
Printing Your Calendar
|
04:19 |
|
Summary: Managing Your Calendar in Outlook
|
00:36 |
| Quiz for course „Managing Your Calendar in Outlook 2013“ | |
|
Introduction: Managing Your Contacts in Outlook
|
00:38 |
|
How to Create and Update Contacts
|
08:00 |
|
How to View and Organize Your Contacts
|
03:07 |
|
Printing Your Contacts
|
04:40 |
|
Summary: Managing Your Contacts in Outlook
|
00:23 |
| Quiz for course „Managing Your Contacts in Outlook 2013“ | |
|
Introduction: Working With Tasks and Notes in Outlook
|
00:36 |
|
Managing Tasks in Outlook
|
06:55 |
|
Managing Notes in Outlook
|
05:50 |
|
Summary: Working With Tasks and Notes in Outlook
|
00:39 |
| Quiz for course „Working With Tasks and Notes in Outlook 2013“ | |
|
Introduction: Customizing the Environment in Outlook
|
00:30 |
|
Customizing the Background and Theme of the Outlook Interface
|
02:38 |
|
Customizing the Ribbon in Outlook
|
03:45 |
|
Customizing the Quick Access Toolbar
|
03:55 |
|
How to Create and Manage Quick Steps
|
03:57 |
|
Summary: Customizing the Environment in Outlook
|
00:25 |
|
Follow Up: Outlook 2013
|
00:47 |
| Quiz for course „Customizing the Environment in Outlook 2013 “ | |
|
Overview: Configure Advanced Message Options in Outlook
|
00:54 |
|
Introduction: Configure Advanced Message Options in Outlook
|
00:51 |
|
How to Insert Advanced Characters and Objects in an Email
|
13:58 |
|
Modifying Message Settings and Properties
|
04:32 |
|
The Language Options
|
05:25 |
|
The advanced Options
|
03:09 |
|
Using Automatic Replies
|
05:37 |
|
Summary: Configure Advanced Message Options in Outlook
|
00:30 |
| Quiz for course „Configure Advanced Message Options in Outlook 2013“ | |
|
Introduction: Advanced Messages Management in Outlook
|
00:34 |
|
How to Sort Messages
|
03:14 |
|
How to Filter Messages
|
03:16 |
|
Organizing Messages
|
09:04 |
|
How to Search Messages
|
04:55 |
|
Using Search Folders
|
04:48 |
|
Managing Junk Mails
|
03:51 |
|
Managing Your Mailbox
|
06:44 |
|
Summary: Advanced Messages Management in Outlook
|
00:33 |
| Quiz for course „Advanced Messages Management in Outlook 2013“ | |
|
Introduction: Advanced Calendar Management in Outlook
|
00:41 |
|
Managing Advanced Calendar Options
|
05:09 |
|
Managing Additional Calendars
|
07:11 |
|
Managing Meeting Responses
|
04:56 |
|
Summary: Advanced Calendar Management in Outlook
|
00:36 |
| Quiz for course „Advanced Calendar Management in Outlook 2013“ | |
|
Introduction: Advanced Contact Management in Outlook
|
00:31 |
|
How to Edit an Electronic Business Card
|
06:00 |
|
Working With a Contact Group
|
07:24 |
|
Forward Contacts in Outlook
|
03:48 |
|
How to Export Contacts in Outlook
|
03:52 |
|
Summary: Advanced Contact Management in Outlook
|
00:36 |
| Quiz for course „Advanced Contact Management in Outlook 2013“ | |
|
Introduction: Managing Activities by Using Tasks and Journal Entries in Outlook
|
00:33 |
|
How to Assign a Task
|
04:50 |
|
How to Reply a Task Request
|
02:36 |
|
Managing a Task Assigned to you
|
04:28 |
|
Managing Journal Entries
|
04:37 |
|
Summary: Managing Activities by Using Tasks and Journal Entries in Outlook
|
00:25 |
| Quiz for course „Managing Activities by Using Tasks and Journal Entries in Outlook 2013“ | |
|
Introduction: Sharing Workspaces With Other in Outlook
|
00:31 |
|
How to Delegate Folder Access by Using Folder Permissions
|
02:23 |
|
Sharing Your Calendar With Another User
|
04:32 |
|
Sharing Your Contacts With Another User
|
01:49 |
|
Summary: Sharing Workspaces With Other in Outlook
|
00:34 |
| Quiz for course „Sharing Workspaces With Others in Outlook 2013“ | |
|
Introduction: Managing Data Files in Outlook
|
00:33 |
|
How to Create a Data File
|
04:28 |
|
How to Change Data File Settings
|
02:26 |
|
Summary: Managing Data Files in Outlook
|
00:27 |
|
Closing: Outlook 2013
|
01:16 |
| Quiz for course „Managing Outlook Data Files“ | |
| Quiz for course „Microsoft Office 2013“ |
Sonic Performance Support is a provider of web-based video learning solutions in multiple languages for consumers, corporations of every size, associations and educational institutions.
All videos can be accessed instantly from any computer or mobile device via any browser and come with a human touch. Experienced trainers guide you step-by-step through the software features.
Top Trainers, Top Content, best e-learning experience ever. We are conviced of that - 100%. That´s why we offer a 100% Money-Back Guarantee. You are not satisfied at all? Please drop us some lines. Up to 5 days within your purchase we refund the complete price you paid - no ifs and buts.
