Microsoft Excel 2013 (EN)

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“

Quiz zum Kurs „Microsoft Excel 2013 (EN)“