Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

# Excel 2016 - Beginner (EN)

Von Sonic Performance

Microsoft Excel 2016 can help you organize, calculate, analyze, revise, update, and present your data in ways that will help you or other decision makers in your organization steer you in the right direction.

This course provides you with a foundation for Excel knowledge and skills, which you can build upon to become an expert in Excel 2016.

The instructor will explain all of the features and functionalities the application offers in an easy to understand, step-by-step method.

Exercise files are available to assist you. They can be downloaded and used to follow along with the trainer.

It’s easy to validate your knowledge with our end of chapter Quizzes.

## Inhalte

### Getting Started with Excel 2016 (EN)

 Navigate the Excel User Interface: Introduction 00:40 Navigate the Excel User Interface 06:18 Use Excel Commands: Introduction 00:41 Use Excel Commands 04:14 Create and Save a Basic Workbook: Introduction 00:29 Create and Save a Basic Workbook 05:01 Enter Cell Data: Introduction 00:29 Enter Cell Data 05:15 Flash Fill and Auto Fill 04:42 Use Excel Help: Introduction 00:47 Use Excel Help 03:13 Quiz zum Kurs „Getting Started with Excel 2016 (EN)“

### Performing Calculations in Excel 2016 (EN)

 Create Worksheet Formulas: Introduction 00:35 Create Worksheet Formulas 05:54 Insert Functions: Introduction 01:09 Insert Functions 05:44 Reuse Formulas and Functions: Introduction 00:58 Reuse Formulas and Functions 05:02 Quiz zum Kurs „Performing Calculations in Excel 2016 (EN)“

### Modifying a Worksheet in Excel 2016 (EN)

 Insert, Delete and Adjust Cells, Columns and Rows: Introduction 00:17 Insert, Delete and Adjust Cells, Columns and Rows 04:48 Search for and Replace Data: Introduction 00:18 Search for and Replace Data 06:18 Use Proofing and Research Tools 00:17 Check the Spelling in a Worksheet 03:08 Insights Task Pane 03:04 Quiz zum Kurs „Modifying a Worksheet in Excel 2016 (EN)“

### Formatting a Worksheet in Excel 2016 (EN)

 Apply Text Formats: Introduction 00:36 Apply Text Formats 06:06 Apply Number Formats: Introduction 00:57 Apply Number Formats 03:15 Align Cell Contents: Introduction 00:27 Align Cell Contents 00:23 Apply Cell Styles and Themes: Introduction 00:23 Apply Cell Styles and Themes 05:59 Apply Basic Conditional Formatting: Introduction 00:50 Apply Basic Conditional Formatting 03:38 Create and Use Templates: Introduction 00:31 Create and Use Templates 04:22 Quiz zum Kurs „Formatting a Worksheet in Excel 2016 (EN)“

### Printing Workbooks in Excel 2016 (EN)

 Preview and Print a Workbook 00:30 Configure and Preview a Print Job 03:02 Set Up the Page Layout: Introduction 00:21 Set Up the Page Layout 03:59 Configure Headers and Footers: Introduction 00:28 Configure Headers and Footers 02:13 Quiz zum Kurs „Printing Workbooks in Excel 2016 (EN)“

### Managing Workbooks in Excel 2016 (EN)

 Manage Worksheets: Introduction 00:17 Manage Worksheets 05:13 Manage Workbook and Worksheet Views: Introduction 00:46 Manage Workbook and Worksheet Views 04:35 Manage Workbook and Properties: Introduction 00:27 Manage Workbook and Properties 03:15 Course Follow Up 01:29 Quiz zum Kurs „Managing Workbooks in Excel 2016 (EN)“

## Details

• Enthaltene Vorträge: 49
• Laufzeit: 2:03 h
• Enthaltene Quizfragen: 23
• Enthaltene Lernmaterialien: 6

## Dozenten des Kurses Excel 2016 - Beginner (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)
5,0 von 5 Sternen
 5 Sterne 5 4 Sterne 0 3 Sterne 0 2 Sterne 0 1  Stern 0