Entdecken Sie, was Sie lernen können.
Mit Videokursen für Beruf, Studium und Freizeit.
Entdecken Sie, was Sie lernen können.
Mit Videokursen für Beruf, Studium und Freizeit.
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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „Using Mail Merge“ | |
|
Using Macros - Lesson Introduction
|
00:22 |
|
Automate Tasks Using Macros
|
06:36 |
|
Create a Macro
|
09:10 |
| Quiz zum Kurs „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 zum Kurs „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 zum Kurs „Securing a Document in Word 2013“ | |
|
Forms - Overview
|
00:31 |
|
Create Forms
|
10:33 |
|
Manipulate Forms
|
04:52 |
| Quiz zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „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 zum Kurs „Managing Outlook Data Files“ | |
| Quiz zum Kurs „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.
Die besten Dozenten, die besten Inhalte, das beste Lernergebnis. Davon sind wir 100%ig überzeugt. Daher auch unsere 100% Geld-zurück-Garantie. Sind Sie wirklich nicht zufrieden? Schreiben Sie uns. Bis fünf Tage nach dem Kauf erstatten wir Ihnen den vollen Preis zurück - ohne Wenn und Aber.
