Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

# Microsoft Excel 2013 (EN)

Von Sonic Performance

## Getting started with Excel 2013

This course will give you an appropriate insight to Excel and its features. You will learn Excel from the very start:

• Performing calculations
• Printing workbook contents
• and so much more

## Inhalte

### Excel 2013 Introduction

 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 in Excel 2013

 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 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 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 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 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

 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 in Excel 2013

 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 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

 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 in Excel 2013

 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

 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 in Excel 2013

 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 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 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 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 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 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

 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“

## Details

• Enthaltene Vorträge: 116
• Laufzeit: 10:01 h
• Enthaltene Quizfragen: 65
• Enthaltene Lernmaterialien: 1

## Dozenten des Kurses Microsoft Excel 2013 (EN)

### 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

(1)
4,0 von 5 Sternen
 5 Sterne 0 4 Sterne 1 3 Sterne 0 2 Sterne 0 1  Stern 0

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