Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Microsoft Office 2013

Von Sonic Performance

In this course, you will learn the basics of the Office package, including tips and tricks on how to use new features of Microsoft Office 2013.

The course „Office 2013“ is for both individuals and managers at all levels who wish to use the Office package with all its possibilities. The following topics are covered:
  • Switch from Office 2010 to Office 2013
  • Word
  • Excel
  • Outlook
  • PowerPoint 

Inhalte

Microsoft Word 2013 (EN)

Word 2013 Introduction

play symbol Word 2013 Overview
00:44
play symbol Getting Started with Word 2013 - Lesson Introduction
00:25
play symbol Display a Document
07:21
lecture locked Working with the Ribbon
08:16
lecture locked Create a Word Document
05:46
lecture locked AutoCorrection
07:50
lecture locked Printing in Word
05:29
lecture locked Saving in Word
06:35
lecture locked Help Function in Word
03:04
Quiz zum Kurs „Word 2013 Introduction“

Editing a Document in Word

play symbol Editing a Document - Lesson Introduction
00:15
lecture locked Navigate and Select Text
07:33
lecture locked Modify Text
04:11
lecture locked Find and Replace Text
07:27
Quiz zum Kurs „Editing a Document in Word“

Formatting Text and Paragraphs in Word 2013

play symbol Formatting Text and Paragraphs - Lesson Introduction
00:29
play symbol Apply Character Formatting
06:27
lecture locked Align Text Using Tabs
07:52
lecture locked Display Text as List Items
07:20
lecture locked Control Paragraph Layout
06:58
lecture locked Apply Borders and Shading
04:31
lecture locked Apply Styles
05:32
lecture locked Manage Formatting
07:35
Quiz zum Kurs „Formatting Text and Paragraphs in Word 2013“

Adding Tables in Word 2013

play symbol Adding Tables - Lesson Introduction
00:27
play symbol Insert a Table
07:23
lecture locked Modify a Table
08:52
lecture locked Format a Table
07:32
lecture locked Convert Text to a Table
05:01
Quiz zum Kurs „Adding Tables in Word 2013“

Managing Lists in Word 2013

play symbol Managing Lists - Lesson Introduction
00:30
lecture locked Sort a List
03:24
lecture locked Renumber a List
05:22
lecture locked Customize a List
10:45
Quiz zum Kurs „Managing Lists in Word 2013“

Inserting Graphic Objects in Word 2013

play symbol Inserting Graphic Objects - Lesson Introduction
00:29
lecture locked Insert Symbols and Special Characters
07:05
lecture locked Add Images to a Document
10:26
Quiz zum Kurs „Inserting Graphic Objects in Word 2013“

Controlling Page Appearance in Word 2013

play symbol Controlling Page Appearance - Lesson Introduction
00:35
play symbol Apply a Page Border and Color
03:55
lecture locked Add a Watermark
05:07
lecture locked Add Headers and Footers
07:59
lecture locked Control Page Layout
06:28
Quiz zum Kurs „Controlling Page Appearance in Word 2013“

Proofing a Document in Word 2013

play symbol Proofing a Document - Lesson Introduction
00:36
lecture locked Check Spelling and Grammar
08:20
lecture locked Other Proofing Tools
03:44
lecture locked Check Accessibility
05:34
Quiz zum Kurs „Proofing a Document in Word 2013“

Customizing the Word Environment

play symbol Customizing the Word Environment - Lesson Introduction
00:23
lecture locked Customize the Word Options
04:17
lecture locked Customize the Word Interface
06:14
lecture locked Additional Save Options
06:05
Quiz zum Kurs „Customizing the Word Environment“

Working with Tables and Charts in Word 2013

play symbol Tables and Charts Overview
00:41
play symbol Working with Tables and Charts - Lesson Introduction
00:29
lecture locked Sort Table Data
04:53
lecture locked Control Cell Layout
07:13
lecture locked Perform Calculations in a Table
06:12
lecture locked Create a Chart
06:43
Quiz zum Kurs „Working with Tables and Charts in Word 2013“

Customizing Formats Using Styles and Themes in Word 2013

play symbol Customizing Formats Using Styles and Themes - Lesson Introduction
00:22
lecture locked Create and Modify Text Styles
08:13
lecture locked Create Custom List or Table Styles
06:36
lecture locked Apply Document Themes
05:00
Quiz zum Kurs „Customizing Formats Using Styles and Themes in Word 2013“

Using Images in a Word 2013 Document

play symbol Using Images in a Document - Lesson Introduction
00:19
play symbol Resize an Image
04:24
lecture locked Adjust Image Appearance
03:36
lecture locked Advanced Image Management
05:28
lecture locked Integrate Pictures and Text
07:37
lecture locked Insert and Format Screenshots
04:34
lecture locked Insert Video
06:48
Quiz zum Kurs „Using Images in a Word 2013 Document“

Creating Custom Graphic Elements in Word 2013

play symbol Creating Custom Graphic Elements - Lesson Introduction
00:24
play symbol Create Text Boxes and Pull Quotes
06:31
lecture locked Draw Shapes
03:08
lecture locked Add WordArt and Other Text Effects
04:32
lecture locked Create Complex Illustrations with SmartArt
06:41
Quiz zum Kurs „Creating Custom Graphic Elements in Word 2013“

Inserting Content Using Quick Parts in Word 2013

play symbol Inserting Content Using Quick Parts - Lesson Introduction
00:23
lecture locked Insert Building Blocks
05:49
lecture locked Create and Modify Building Blocks
07:54
lecture locked Insert Fields Using Quick Parts
09:33
Quiz zum Kurs „Inserting Content Using Quick Parts in Word 2013“

Controlling Text Flow in Word 2013

play symbol Controlling Text Flow - Lesson Introduction
00:24
play symbol Control Paragraph Flow in Word
04:12
lecture locked Insert Section Breaks
08:30
lecture locked Insert Columns in Word
05:30
lecture locked Link Text Boxes to Control Text Flow
05:56
Quiz zum Kurs „Controlling Text Flow in Word 2013“

Using Templates in Word 2013

play symbol Using Templates - Lesson Introduction
00:27
lecture locked Create a Document Using a Template
06:41
lecture locked Create a Template
08:02

Using Mail Merge

play symbol Using Mail Merge - Lesson Introduction
00:22
lecture locked The Mail Merge Features
12:25
lecture locked Merge Envelopes and Labels
10:08
lecture locked Create a Data Source Using Word
04:23
Quiz zum Kurs „Using Mail Merge“

Using Macros in Word 2013

play symbol Using Macros - Lesson Introduction
00:22
lecture locked Automate Tasks Using Macros
06:36
lecture locked Create a Macro
09:10
Quiz zum Kurs „Using Macros in Word 2013“

Collaborating on Documents with Word 2013

play symbol Collaborating on Documents - Overview
00:40
play symbol Collaborating on Documents - Lesson Introduction
00:33
lecture locked Modify User Information
05:35
lecture locked Share a Document
04:15
lecture locked Compare Document Changes
04:06
lecture locked Review a Document
03:53
lecture locked Merge Document Changes
06:22
lecture locked Review Tracked Changes
04:09
lecture locked Coauthor Documents
09:03
Quiz zum Kurs „Collaborating on Documents with Word 2013“

Adding Reference Marks and Notes in Word 2013

play symbol Adding Reference Marks and Notes - Lesson Introduction
00:32
play symbol Add Captions
06:15
lecture locked Add Cross-References in Word
08:09
lecture locked Add Bookmarks
04:45
lecture locked Add Hyperlinks in Word
05:04
lecture locked Insert Footnotes and Endnotes
04:28
lecture locked Add Citations and a Bibliography
09:49

Managing Long Documents in Word 2013

play symbol Simplifying and Managing Long Documents - Lesson Introduction
00:38
play symbol Insert Blank and Cover Pages
06:43
lecture locked Insert an Index
08:42
lecture locked Insert a Table of Contents
07:35
lecture locked Insert an Ancillary Table
05:10
lecture locked Manage Outlines
07:01
lecture locked Create a Master Document
08:15

Securing a Document in Word 2013

play symbol Securing a Document - Lesson Introduction
00:25
play symbol Suppress Information
07:37
lecture locked Set Formatting and Editing Restrictions
05:07
lecture locked Add a Digital Signature to a Document
07:07
lecture locked Restrict Document Access
04:54
Quiz zum Kurs „Securing a Document in Word 2013“

Forms in Word 2013

play symbol Forms - Overview
00:31
lecture locked Create Forms
10:33
lecture locked Manipulate Forms
04:52
Quiz zum Kurs „Forms in Word 2013“

Managing Document Versions in Word 2013

play symbol Managing Document Versions - Lesson Introduction
00:30
lecture locked Create a New Document Version
08:51
lecture locked Compare and Merge Document Versions
07:36
Quiz zum Kurs „Managing Document Versions in Word 2013“

Working with Legacy Form Fields

play symbol Working with Legacy Form Fields - Lesson Introduction
00:32
lecture locked Modify Legacy Form Field Properties
05:25
lecture locked Form Data Conversion
05:45
Quiz zum Kurs „Working with Legacy Form Fields“

Microsoft Excel 2013 (EN)

Excel 2013 Introduction

play symbol Getting Started with Excel 2013 - Lesson Introduction
00:22
lecture locked Elements of the Application Window
08:06
lecture locked Elements of the Workbook Window
16:06
lecture locked Create a Basic Worksheet
07:14
lecture locked The Help System
03:58
Quiz zum Kurs „Excel 2013 Introduction“

Performing Calculations in Excel 2013

play symbol Performing Calculations - Lesson Introduction
00:14
play symbol Create Formulas in a Worksheet
10:17
lecture locked Insert SUM and AVERAGE Functions
12:22
lecture locked Insert MIN and MAX Functions
10:37
lecture locked Cut and Paste Commands
08:48
lecture locked Absolute Cell References
10:11
Quiz zum Kurs „Performing Calculations in Excel 2013“

Modifying a Worksheet in Excel 2013

play symbol Modifying a Worksheet - Lesson Introduction
00:34
play symbol The Auto Fill Feature
09:20
lecture locked The Undo and Redo Commands
06:46
lecture locked Column Width and Row Height Alteration Methods
07:06
lecture locked The Hide and Unhide Options
04:35
lecture locked The Insert and Delete Options
08:37
lecture locked Cell Names and Range Names
07:01
lecture locked The Find and Replace Commands
05:02
lecture locked Spell Check a Worksheet
06:34
Quiz zum Kurs „Modifying a Worksheet in Excel 2013“

Formatting a Worksheet in Excel 2013

play symbol Formatting a Worksheet - Lesson Introduction
00:25
play symbol Modify Fonts
07:44
lecture locked Add Borders and Color to Cells
06:48
lecture locked Apply Number Formats
05:23
lecture locked Align Cell Contents
08:33
lecture locked Apply Cell Styles
09:18
Quiz zum Kurs „Formatting a Worksheet in Excel 2013“

Printing Workbook Contents in Excel 2013

play symbol Printing Workbook Contents - Lesson Introduction
00:28
lecture locked Define the Basic Page Layout
07:49
lecture locked Refine the Page Layout and Apply Print Options
08:10
Quiz zum Kurs „Printing Workbook Contents in Excel 2013“

Managing Large Workbooks in Excel 2013

play symbol Managing Large Workbooks - Lesson Introduction
00:24
lecture locked Format Worksheet Tabs
05:37
lecture locked Managing Worksheets
08:04
lecture locked Manage the View of Worksheets and Workbooks
05:17
Quiz zum Kurs „Managing Large Workbooks in Excel 2013“

Customizing the Excel Environment

play symbol Customizing the Excel Environment - Lesson Introduction
00:20
play symbol Customize General and Language Options
07:32
lecture locked Customize Formula Options
03:38
lecture locked Customize Proofing and Save Options
02:49
lecture locked Customize the Quick Access Toolbar
07:40
lecture locked Customize the Ribbon
09:18
lecture locked Customize the Functionality of Excel by Enabling Add-Ins
04:20
lecture locked Customize Advanced Options
05:06
lecture locked Customize Trust Center Options
03:11
Quiz zum Kurs „Customizing the Excel Environment“

Creating Advanced Formulas in Excel 2013

play symbol Creating Advanced Formulas - Lesson Introduction
00:46
play symbol Add Range Names
06:49
lecture locked Edit and Delete Range Names
03:34
lecture locked Use Range Names in a Formula
06:12
lecture locked Use Specialized Functions
06:36
lecture locked Use the SUM Function
02:47
lecture locked Use the AVERAGE Function
03:20
lecture locked Use the MIN Function
03:40
lecture locked Use the MAX Function
03:10
lecture locked Use COUNT, COUNTA and COUNTIF Functions
07:03
lecture locked Use the ROUND Function
04:46
lecture locked Use the AND Function
04:23
lecture locked Use the CONCATENATE Function
04:44
lecture locked Use HLOOKUP and VLOOKUP Functions
05:02
Quiz zum Kurs „Creating Advanced Formulas in Excel 2013“

Analyzing Data with Logical Functions in Excel 2013

play symbol Analyzing Data with Logical Functions - Lesson Introduction
00:36
lecture locked Work with Logical Functions
06:09
lecture locked Use the Nested IF Function
03:53
Quiz zum Kurs „Analyzing Data with Logical Functions in Excel 2013“

Organizing Worksheet Data with Tables

play symbol Organizing Worksheet Data with Tables - Lesson Introduction
00:33
play symbol Create and Modify Tables
04:57
lecture locked Sort Data
03:52
lecture locked Filter Data with the Auto Filter
02:30
lecture locked Filter Data with the Advanced Filter
05:28
lecture locked Remove Duplicates
04:02
lecture locked Total Row
06:34
Quiz zum Kurs „Organizing Worksheet Data with Tables“

Visualizing Data with Charts in Excel 2013

play symbol Visualizing Data with Charts - Lesson Introduction
00:31
play symbol Create Charts
09:37
lecture locked Change the Default Chart Type
03:37
lecture locked Modify Charts
10:04
lecture locked Edit Chart Axes
09:19
lecture locked Format Charts
03:37
lecture locked Create a Trendline in Excel 2013
09:41
lecture locked Create Advanced Charts
11:52
Quiz zum Kurs „Visualizing Data with Charts in Excel 2013“

Analyzing Data with PivotTables, Slicers, and PivotCharts

play symbol Analyzing Data with PivotTables, Slicers, and PivotCharts - Lesson Introduction
00:25
play symbol Create a PivotTable
07:15
lecture locked Advanced Field Settings
07:09
lecture locked Filter Data by Using Slicers
05:40
lecture locked Analyze Data by Using PivotCharts
07:52
Quiz zum Kurs „Analyzing Data with PivotTables, Slicers, and PivotCharts“

Inserting Graphics in Excel 2013

play symbol Inserting Graphics - Lesson Introduction
00:25
lecture locked Insert and Modify Graphic Objects
06:59
lecture locked Insert and Group Shapes
07:12
lecture locked Incorporate SmartArt in Excel 2013
06:11
Quiz zum Kurs „Inserting Graphics in Excel 2013“

Enhancing Workbooks in Excel 2013

play symbol Enhancing Workbooks - Lesson Introduction
00:36
play symbol Comments in Excel 2013
05:00
lecture locked Hyperlinks in Excel 2013
05:21
lecture locked Watermarks in Excel 2013
04:39
lecture locked Manage Themes in Excel 2013
05:18
lecture locked Create and Use Templates
06:12
lecture locked Protect Files
08:27
Quiz zum Kurs „Enhancing Workbooks in Excel 2013“

Automating Worksheet Functionality in Excel 2013

play symbol Automating Worksheet Functionality - Lesson Introduction
00:25
play symbol Update Workbook Properties
03:40
lecture locked Apply Conditional Formatting
05:43
lecture locked Edit a Conditional Formatting Rule
04:47
lecture locked Add Data Validation Criteria
07:58
Quiz zum Kurs „Automating Worksheet Functionality in Excel 2013“

Auditing Worksheets in Excel 2013

play symbol Auditing Worksheets - Lesson Introduction
00:39
play symbol Trace Cells
02:58
lecture locked Troubleshoot Invalid Data
02:26
lecture locked Troubleshoot Invalid Formulas
06:08
lecture locked Evaluate Formulas
02:39
lecture locked Watch Formulas
02:05
lecture locked Create a Data List Outline
03:00
lecture locked Add Subtotals to Grouped Data
03:52
Quiz zum Kurs „Auditing Worksheets in Excel 2013“

Analyzing and Presenting Data in Excel 2013

play symbol Analyzing and Presenting Data - Lesson Introduction
00:22
lecture locked Create Sparklines
04:51
lecture locked Create Scenarios
04:49
lecture locked Perform a What-If Analysis
03:02
Quiz zum Kurs „Analyzing and Presenting Data in Excel 2013“

Working with Multiple Workbooks in Excel 2013

play symbol Working with Multiple Workbooks - Lesson Introduction
00:28
lecture locked Consolidate Data
03:56
lecture locked Link Cells in Different Workbooks
04:52
lecture locked Merge Workbooks
02:38
Quiz zum Kurs „Working with Multiple Workbooks in Excel 2013“

Exporting Excel Data

play symbol Exporting Excel Data - Lesson Introduction
00:28
play symbol Export Excel Data
05:19
lecture locked Import a Delimited Text File
05:46
lecture locked Integrate Excel Data with the Web
06:01
lecture locked Create a Web Query
06:10
Quiz zum Kurs „Exporting Excel Data“

Microsoft PowerPoint 2013 (EN)

PowerPoint 2013 Introduction

play symbol Getting Started with PowerPoint 2013 - Lesson Introduction
00:43
lecture locked Navigate the PowerPoint Environment
08:23
lecture locked Create and Save a PowerPoint Presentation
04:21
lecture locked Use PowerPoint Help
04:01
Quiz zum Kurs „PowerPoint 2013 Introduction“

Developing a PowerPoint Presentation

play symbol Developing a PowerPoint Presentation - Lesson Introduction
00:22
play symbol Create a Presentation from a Template
03:53
lecture locked View and Navigate a Presentation
07:24
lecture locked Edit Text in PowerPoint 2013
06:57
lecture locked Add, Delete and Modify Slides
05:56
lecture locked Arrange Slides
03:53
lecture locked Work with Themes
05:11
Quiz zum Kurs „Developing a PowerPoint Presentation“

Performing Advanced Text Editing in PowerPoint 2013

play symbol Performing Advanced Text Editing - Lesson Introduction
00:37
play symbol Format Characters in PowerPoint 2013
05:31
lecture locked Use Bullets and Number Lists
02:59
lecture locked Format Paragraphs
04:04
lecture locked Format Text Boxes in PowerPoint 2013
05:48
Quiz zum Kurs „Performing Advanced Text Editing in PowerPoint 2013“

Adding Graphical Elements to Your Presentation

play symbol Adding Graphical Elements to Your Presentation - Lesson Introduction
00:33
lecture locked Insert Clip Art and Images in PowerPoint 2013
04:56
lecture locked Insert Shapes in PowerPoint 2013
06:47
Quiz zum Kurs „Adding Graphical Elements to Your Presentation“

Modifying Objects in Your Presentation

play symbol Modifying Objects in Your Presentation - Lesson Introduction
00:26
play symbol Edit Objects
05:06
lecture locked Format Objects
05:04
lecture locked Group Objects
03:09
lecture locked Arrange Objects
04:57
lecture locked Animate Objects
05:13
Quiz zum Kurs „Modifying Objects in Your Presentation“

Adding Tables to Your Presentation in PowerPoint 2013

play symbol Adding Tables to Your Presentation - Lesson Introduction
00:56
play symbol Create a Table in PowerPoint 2013
05:11
lecture locked Format a Table in PowerPoint 2013
04:28
lecture locked 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 in PowerPoint 2013

play symbol Adding Charts to Your Presentation - Lesson Introduction
00:49
lecture locked Create Charts in Powerpoint 2013
05:12
lecture locked Format Charts in PowerPoint 2013
06:59
lecture locked Insert a Chart from Excel
04:01
Quiz zum Kurs „Adding Charts to Your Presentation in PowerPoint 2013“

Preparing to Deliver Your Presentation in PowerPoint 2013

play symbol Preparing to Deliver Your Presentation - Lesson Introduction
01:03
play symbol Review Your Presentation
02:46
lecture locked Apply Transitions
03:01
lecture locked Print Your Presentation
04:18
lecture locked Deliver Your Presentation in PowerPoint 2013
04:21
lecture locked Save a Presentation as a PDF
02:45
Quiz zum Kurs „Preparing to Deliver Your Presentation in PowerPoint 2013“

Modifying the PowerPoint Environment

play symbol Modifying the PowerPoint Environment - Lesson Introduction
00:50
lecture locked Customize the Ribbon
04:09
lecture locked Customize the Quick Access Toolbar and Status Bar
06:10
lecture locked Work with Windows Simultaneously
02:04
lecture locked Set PowerPoint 2013 Options
03:20
Quiz zum Kurs „Modifying the PowerPoint Environment“

Customizing Design Templates in PowerPoint 2013

play symbol Customizing Design Templates - Introduction
00:37
lecture locked Work with Slide Masters
04:01
lecture locked Create a Custom Slide Layout
05:14
lecture locked Add Headers and Footers
05:47
lecture locked Modify the Notes Master and the Handout Master
04:26
Quiz zum Kurs „Customizing Design Templates in PowerPoint 2013“

Adding SmartArt to a Presentation with PowerPoint 2013

play symbol Adding SmartArt to a Presentation - Introduction
00:32
lecture locked Adding SmartArt to a Presentation
03:21
lecture locked Modify SmartArt
04:06
Quiz zum Kurs „Adding SmartArt to a Presentation with PowerPoint 2013“

Working with Media and Animations in PowerPoint 2013

play symbol Working with Media and Animations - Introduction
00:42
play symbol Add Audio to a Presentation
04:45
lecture locked Add Video to a Presentation
03:41
lecture locked Set Video Playback Options
03:20
lecture locked Create Custom Animation Effects
06:15
lecture locked Timing Slide Transitions
03:57
Quiz zum Kurs „Working with Media and Animations in PowerPoint 2013“

Collaborating on a Presentation with PowerPoint 2013

play symbol Collaborating on a Presentation - Introduction
00:41
lecture locked Add and Manage Sections and Comments
05:14
lecture locked Compare and Merge Presentations
05:19
lecture locked Share a Presentation on the Web
07:01
Quiz zum Kurs „Collaborating on a Presentation with PowerPoint 2013“

Customizing a Slide Show in PowerPoint 2013

play symbol Customizing a Slide Show - Introduction
00:57
lecture locked Annotate a Presentation
04:14
lecture locked Set Up and Create a Slide Show
05:11
lecture locked Add Action Buttons to a Presentation
05:34
lecture locked Record a Presentation
05:44
Quiz zum Kurs „Customizing a Slide Show in PowerPoint 2013“

Securing and Distributing a Presentation

play symbol Securing and Distributing a Presentation - Introduction
00:48
lecture locked Secure a Presentation
04:17
lecture locked Present a Slide Show Online
05:49
lecture locked Convert a Presentation to a Video
02:51
lecture locked Package a Presentation
05:01
Quiz zum Kurs „Securing and Distributing a Presentation“

Microsoft Access 2013 (EN)

Getting Started with Access

play symbol Overview: Access 2013
01:05
play symbol Introduction: Getting Started With Access
00:31
play symbol Orientation to Access
04:35
lecture locked How to Edit Tables and Rows
05:04
lecture locked The Records Bar in Access
01:57
lecture locked How to Use Forms for Data Entry
04:15
lecture locked How to Use Queries
04:13
lecture locked How to Use Reports
01:11
lecture locked Explore Access Ribbon Commands
01:13
lecture locked Create a Simple Access Database
12:59
lecture locked How to Create a Form
06:13
lecture locked Get Help in Microsoft Access
02:52
lecture locked Summary: Getting Started With Access
00:35
Quiz zum Kurs „Getting Started with Access“

Working With Table Data in Access 2013

play symbol Introduction: Working With Table Data in Access
00:52
play symbol How to Modify Table Data
13:54
lecture locked Sort and Filter Records in Access
09:04
lecture locked Purpose of Primary Key
03:34
lecture locked Configuring Form Lookup Field in Access
09:12
lecture locked Summary: Working With Table Data in Access
00:38
Quiz zum Kurs „Working With Table Data in Access 2013“

Querying a Database in Access 2013

play symbol Introduction: Querying a Database in Access
00:58
play symbol How to Join Data From Different Tables in a Query
12:28
lecture locked How to Sort and Filter Data in a Query
14:44
lecture locked Perform Calculations in a Query
11:10
lecture locked Summary: Querying a Database in Access
00:24
Quiz zum Kurs „Querying a Database in Access 2013“

Creating Advanced Queries in Access 2013

play symbol Introduction: Creating advanced Queries in Access
00:50
play symbol How to Create Parameter Queries
05:02
lecture locked Use Wildcards in a Parameter Query
03:31
lecture locked How to Create a Query With Multiple Parameters
04:23
lecture locked How to Create Action Queries
07:53
lecture locked How to Create Unmatched and Duplicate Queries
07:20
lecture locked Summarizing Data in Access
05:25
lecture locked Summary: Creating Advanced Queries in Access
00:24
Quiz zum Kurs „Creating Advanced Queries in Access 2013“

Generating Reports in Access 2013

play symbol Introduction: Generating Reports in Access
00:57
play symbol How to Create a Report
05:47
lecture locked Using the Report Wizard in Access
04:48
lecture locked How to Add Controls to a Report
08:07
lecture locked How to Enhance the Appearance of a Report
07:28
lecture locked Preparing a Report for Print in Access
04:53
lecture locked Summary: Generating Reports in Access
00:26
Quiz zum Kurs „Generating Reports in Access 2013“

Customizing the Access 2013 Environment

play symbol Introduction: Customizing the Access Environment
00:22
lecture locked The Access Options Dialog Box
07:28
lecture locked Summary: Customizing the Acess Environment
00:22
lecture locked Follow Up in Access
00:57
Quiz zum Kurs „Customizing the Access 2013 Environment“

Designing a Relational Database in Access 2013

play symbol Overview: Designing a Relational Database in Access
01:15
play symbol Introduction: Designing a Relational Database in Access
00:40
lecture locked Analyzing the Relational Database Design Process
00:25
lecture locked How to Create a Table in Access
08:12
lecture locked How to Create a Table Relationship in Access
05:51
lecture locked Summary: Designing a Relational Database in Access
00:34
Quiz zum Kurs „Designing a Relational Database in Access 2013“

Joining Tables in Access 2013

play symbol Introduction: Joining Tables in Access
00:50
play symbol How to Create Inner and Outer Joins
08:05
lecture locked Join Unrelated Tables
04:04
lecture locked How to Create a Self Join
03:47
lecture locked Modify Data in a SubDatasheet
06:19
lecture locked How to Create Subqueries
05:50
lecture locked Summary: Joining Tables in Access
00:36
Quiz zum Kurs „Joining Tables in Access 2013“

Organizing a Database for Efficiency in Access 2013

play symbol Introduction: Organizing a Database for Efficiency in Access
00:45
lecture locked How to Run the Table Analyzer Wizard
07:59
lecture locked How to Create Many to Many Relationship
04:47
lecture locked How to Improve Table Structure
06:11
lecture locked Summary: Organizing a Database for Efficiency in Access
00:25
Quiz zum Kurs „Organizing a Database for Efficiency in Access 2013“

Sharing Data Across Applications in Access 2013

play symbol Introduction: Sharing Data Across Applications in Access
01:27
play symbol How to Import Data from Text File
06:26
lecture locked How to Import Data from Excel File
04:34
lecture locked How to Export Data to Text File Formats
06:34
lecture locked How to Export Data to Excel
03:57
lecture locked Merging Access Data With Word
07:11
lecture locked Summary: Sharing Data Across Applications in Access
00:52
Quiz zum Kurs „Sharing Data Across Applications in Access 2013“

Advanced Reporting in Access 2013

play symbol Introduction: Advanced Reporting in Access
00:47
lecture locked How to Make Report Design Modifications
17:08
lecture locked Formating Reports in Access
07:35
lecture locked How to Add Data Bars to Reports
03:49
lecture locked How to Add a Calculated Field to a Report
05:51
lecture locked How to Add a Subreport to an Existing Report
05:59
lecture locked Summary: Advanced Reporting in Access
00:27
lecture locked Follow Up in Access 2013
00:49
Quiz zum Kurs „Advanced Reporting in Access 2013“

Implementing Advanced Form Design in Access 2013

play symbol Overview: Implementing Advanced Form Design in Access
01:23
play symbol Introduction: Implementing Advanced Form Design in Access
00:47
lecture locked How to Add Controls to Forms
03:37
lecture locked Creating Subforms
03:45
lecture locked How to Organize Information With Tab Pages
06:07
lecture locked Enhancing Navigation of Forms
06:30
lecture locked Applying Conditional Formatting
03:51
lecture locked Summary: Implementing Advanced Form Design in Access
01:00
Quiz zum Kurs „Implementing Advanced Form Design in Access 2013“

Using Data Validation in Access 2013

play symbol Introduction: Using Data Validation in Access
01:01
lecture locked The Field and Record Validation in Access
03:11
lecture locked The Form Validation in Access
03:45
lecture locked Summary: Using Data Validation in Access
00:29
Quiz zum Kurs „Using Data Validation in Access 2013“

Using Macros to Improve User Interface Design in Access 2013

play symbol Introduction: Using Macros to Improve User Interface Design in Access
00:34
play symbol How to Create a Macro in Access
03:24
lecture locked Restricting Records Using a Condition
03:22
lecture locked Validating Data Using a Macro
06:01
lecture locked Automating Data Entry Using a Macro
04:20
lecture locked How to Convert a Macro to VBA in Access
02:14
lecture locked 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“

Using Advanced Database Management in Access 2013

play symbol Introduction: Using Advanced Database Management in Access
00:56
play symbol How to Link Tables to External Data Sources
03:34
lecture locked Managing a Database in Access
04:15
lecture locked How to Determine Object Dependency
02:07
lecture locked Documenting a Database in Access
03:23
lecture locked Analyzing the Performance of a Database
01:43
lecture locked Summary: Using Advanced Database Management in Access
00:51
Quiz zum Kurs „Using Advanced Database Management in Access 2013“

Distributing and Securing a Database in Access 2013

play symbol Introduction: Distributing and Securing a Database in Access
01:02
play symbol How to Split a Database for Multiple User Access
03:13
lecture locked How to Implement Security in Access
01:52
lecture locked Setting Passwords in Access
02:08
lecture locked Converting an Access Database to an ACCDE File
02:25
lecture locked Packaging a Database With a Digital Signature
02:25
lecture locked Summary: Distributing and Securing a Database in Access
00:41
Quiz zum Kurs „Distributing and Securing a Database in Access 2013“

Managing Switchboards in Access 2013

play symbol Introduction: Managing Switchboards in Access
00:42
lecture locked How to Create a Database Switchboard in Access
03:39
lecture locked Modifying a Database Switchboard
02:32
lecture locked Setting Startup Options
01:54
lecture locked Summary: Managing Switchboards in Access
00:25
lecture locked Closing: Access 2013
00:36
Quiz zum Kurs „Managing Switchboards in Access 2013“

Microsoft Outlook 2013 (EN)

Getting Started with Outlook 2013

play symbol Overview: Outlook 2013
00:49
play symbol Introduction: Getting Started With Outlook 2013
00:32
play symbol How to Identify the Elements of the Application Window
06:32
lecture locked How to Identify the Workspaces
05:16
lecture locked Creating and Sending an Email
02:22
lecture locked Reading and Responding to Emails
03:50
lecture locked Printing an Email Message
03:05
lecture locked Deleting Email Messages
03:10
lecture locked How to Use the Outlook Help
03:49
lecture locked Summary: Getting Started With Outlook 2013
00:24
Quiz zum Kurs „Getting Started with Outlook 2013“

Composing Messages in Outlook 2013

play symbol Introduction: Composing Messages in Outlook
00:30
play symbol How to Create an Email Message
04:02
lecture locked Checking the Spelling and Grammar
04:38
lecture locked How to Format Message Content
03:51
lecture locked Pasting in an Email Message
03:39
lecture locked Attaching Files and Items
01:51
lecture locked Enhancing an Email Message With an Image
04:02
lecture locked Enhancing an Email Message With SmartArt and Themes
05:20
lecture locked How to Specify Font Options
04:46
lecture locked How to Create and Apply an Email Signature
03:35
lecture locked Summary: Composing Messages in Outlook
00:25
Quiz zum Kurs „Composing Messages in Outlook 2013“

Reading and Responding to Messages in Outlook 2013

play symbol Introduction: Reading and Responding to Messages in Outlook
00:27
play symbol How to Customize Reading Options
03:33
lecture locked Working With Attachments
02:58
lecture locked Using Tracking Options
03:47
lecture locked How to Recall a Sent Message
03:16
lecture locked Summary: Reading and Responding to Messages in Outlook
00:24
Quiz zum Kurs „Reading and Responding to Messages in Outlook 2013“

Managing Your Messages in Outlook 2013

play symbol Introduction: Managing Your Messages in Outlook
00:34
play symbol How to Use Tags to Manage Messages
05:02
lecture locked How to Use Flags to Manage Messages
04:40
lecture locked How to Use Commands to Manage Messages
04:08
lecture locked Organizing Messages Using Folders
04:19
lecture locked Summary: Managing Your Messages
00:23
Quiz zum Kurs „Managing Your Messages in Outlook 2013“

Managing Your Calendar in Outlook 2013

play symbol Introduction: Managing Your Calendar in Outlook
00:33
play symbol How to View the Calendar
06:14
lecture locked Managing Appointments
04:51
lecture locked Responding to a Meeting Request
03:50
lecture locked Proposing a New Time for a Meeting
02:59
lecture locked How to Create a Recurring Meeting Request
06:35
lecture locked Printing Your Calendar
04:19
lecture locked Summary: Managing Your Calendar in Outlook
00:36
Quiz zum Kurs „Managing Your Calendar in Outlook 2013“

Managing Your Contacts in Outlook 2013

play symbol Introduction: Managing Your Contacts in Outlook
00:38
lecture locked How to Create and Update Contacts
08:00
lecture locked How to View and Organize Your Contacts
03:07
lecture locked Printing Your Contacts
04:40
lecture locked Summary: Managing Your Contacts in Outlook
00:23
Quiz zum Kurs „Managing Your Contacts in Outlook 2013“

Working With Tasks and Notes in Outlook 2013

play symbol Introduction: Working With Tasks and Notes in Outlook
00:36
lecture locked Managing Tasks in Outlook
06:55
lecture locked Managing Notes in Outlook
05:50
lecture locked Summary: Working With Tasks and Notes in Outlook
00:39
Quiz zum Kurs „Working With Tasks and Notes in Outlook 2013“

Customizing the Environment in Outlook 2013

play symbol Introduction: Customizing the Environment in Outlook
00:30
play symbol Customizing the Background and Theme of the Outlook Interface
02:38
lecture locked Customizing the Ribbon in Outlook
03:45
lecture locked Customizing the Quick Access Toolbar
03:55
lecture locked How to Create and Manage Quick Steps
03:57
lecture locked Summary: Customizing the Environment in Outlook
00:25
lecture locked Follow Up: Outlook 2013
00:47
Quiz zum Kurs „Customizing the Environment in Outlook 2013 “

Configure Advanced Message Options in Outlook 2013

play symbol Overview: Configure Advanced Message Options in Outlook
00:54
play symbol Introduction: Configure Advanced Message Options in Outlook
00:51
lecture locked How to Insert Advanced Characters and Objects in an Email
13:58
lecture locked Modifying Message Settings and Properties
04:32
lecture locked The Language Options
05:25
lecture locked The advanced Options
03:09
lecture locked Using Automatic Replies
05:37
lecture locked Summary: Configure Advanced Message Options in Outlook
00:30
Quiz zum Kurs „Configure Advanced Message Options in Outlook 2013“

Advanced Messages Management in Outlook 2013

play symbol Introduction: Advanced Messages Management in Outlook
00:34
play symbol How to Sort Messages
03:14
lecture locked How to Filter Messages
03:16
lecture locked Organizing Messages
09:04
lecture locked How to Search Messages
04:55
lecture locked Using Search Folders
04:48
lecture locked Managing Junk Mails
03:51
lecture locked Managing Your Mailbox
06:44
lecture locked Summary: Advanced Messages Management in Outlook
00:33
Quiz zum Kurs „Advanced Messages Management in Outlook 2013“

Advanced Calendar Management in Outlook 2013

play symbol Introduction: Advanced Calendar Management in Outlook
00:41
lecture locked Managing Advanced Calendar Options
05:09
lecture locked Managing Additional Calendars
07:11
lecture locked Managing Meeting Responses
04:56
lecture locked Summary: Advanced Calendar Management in Outlook
00:36
Quiz zum Kurs „Advanced Calendar Management in Outlook 2013“

Advanced Contact Management in Outlook 2013

play symbol Introduction: Advanced Contact Management in Outlook
00:31
play symbol How to Edit an Electronic Business Card
06:00
lecture locked Working With a Contact Group
07:24
lecture locked Forward Contacts in Outlook
03:48
lecture locked How to Export Contacts in Outlook
03:52
lecture locked Summary: Advanced Contact Management in Outlook
00:36
Quiz zum Kurs „Advanced Contact Management in Outlook 2013“

Managing Activities by Using Tasks and Journal Entries in Outlook 2013

play symbol Introduction: Managing Activities by Using Tasks and Journal Entries in Outlook
00:33
play symbol How to Assign a Task
04:50
lecture locked How to Reply a Task Request
02:36
lecture locked Managing a Task Assigned to you
04:28
lecture locked Managing Journal Entries
04:37
lecture locked 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“

Sharing Workspaces With Others in Outlook 2013

play symbol Introduction: Sharing Workspaces With Other in Outlook
00:31
lecture locked How to Delegate Folder Access by Using Folder Permissions
02:23
lecture locked Sharing Your Calendar With Another User
04:32
lecture locked Sharing Your Contacts With Another User
01:49
lecture locked Summary: Sharing Workspaces With Other in Outlook
00:34
Quiz zum Kurs „Sharing Workspaces With Others in Outlook 2013“

Managing Outlook Data Files

play symbol Introduction: Managing Data Files in Outlook
00:33
lecture locked How to Create a Data File
04:28
lecture locked How to Change Data File Settings
02:26
lecture locked Summary: Managing Data Files in Outlook
00:27
lecture locked Closing: Outlook 2013
01:16
Quiz zum Kurs „Managing Outlook Data Files“
Quiz zum Kurs „Microsoft Office 2013“

Details

  • Enthaltene Vorträge: 528
  • Laufzeit: 38:03 h
  • Enthaltene Quizfragen: 292
  • Enthaltene Lernmaterialien: 5

Dozenten des Kurses Microsoft Office 2013

 Sonic Performance

Sonic Performance

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.


Rezensionen

(5)
3,8 von 5 Sternen
5 Sterne
2
4 Sterne
2
3 Sterne
0
2 Sterne
0
1  Stern
1
 
too old
von DIIIva Y. am 15. September 2021 für Microsoft Excel 2013 (EN)

too old for the version 2020 in excel. not using it quite

 
Good!!
von Karoline J. am 13. Juli 2021 für Microsoft Access 2013 (EN)

This course was nicely structured and helped me immensely. Thank you!

 
Managing Document ...
von Hans-Joachim F. am 26. März 2018 für Managing Document Versions in Word 2013

der Kurs ist ok. Ich jedoch habe nichts neues Erfahren ...

 
Kurz und bündig erklärt - klare Sprache
von Manfred S. am 02. März 2017 für Adding Tables in Word 2013

Kurz und bündig erklärt. Das Englisch des Autors ist einfach superb. einfach gut. Manfred Sündorf