Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Von Sonic Performance

The ability to collaborate with colleagues, automate complex or repetitive tasks, and use conditional logic to construct and apply elaborate formulas and functions will put the full power of Excel right at your fingertips. The more you learn about how to get Excel to do the hard work for you, the more you'll be able to focus on getting the answers you need from the vast amounts of data your organization generates.

You will:
• Work with multiple worksheets and workbooks.
• Use Lookup functions and formula auditing
• Share and protect workbooks.
• Automate workbook functionality.
• Create sparklines and map data.
• Forecast data

Upon successful completion of this course, you will be able to perform advanced data analysis, collaborate on workbooks with other users, and automate workbook functionality.

## Inhalte

### Working with Multiple Worksheets and Workbooks in Excel 2016 (EN)

 Course Overview: Excel 2016 – Advanced 02:11 Introduction to Links and External References in Excel 2016 01:04 Using Links and External References 05:37 Introduction to 3-D References in Excel 2016 00:49 How to Use 3-D References in Excel 04:23 Introduction to Data Cosolidation in Excel 2016 00:31 How to Consolidate Data in Excel 05:01 Quiz zum Kurs „Working with Multiple Worksheets and Workbooks in Excel 2016 (EN)“

### Using LOOKUP Functions and Formula Auditing in Excel 2016 (EN)

 Introduction to the LOOKUP Function in Excel 2016 00:49 Using the LOOKUP Function 08:14 Introduction to Precedent and Dependent Cells in Excel 2016 00:44 Tracing Precedent and Dependent Cells 02:58 Introduction to Watch and Evaluate Formulas in Excel 00:44 Watching and Evaluating Formulas 03:58 Quiz zum Kurs „Using LOOKUP Functions and Formula Auditing in Excel 2016 (EN)“

### Collaborate on a Workbook With Multiple People in Excel 2016 (EN)

 Introduction to Collaborations on a Workbook in Excel 00:43 Collaborating on a Workbook 05:32 Introduction to Comparing and Merging Workbooks in Excel 02:52 Introduction to Protecting Worksheets and Workbooks in Excel 00:38 How to Protect Worksheets and Workbooks in Excel 04:02 Quiz zum Kurs „Collaborate on a Workbook With Multiple People in Excel 2016 (EN)“

### Automating Workbook Functionality in Excel 2016 (EN)

 Introduction to Data Validation 00:51 Applying Data Validation to Cells 04:16 Introduction to the Data Validation and Error Checking Tool 00:39 Searching for Invalid Data and Formulas with Errors 02:59 Introduction to Automating Tasks with Macros in Excel 00:40 Working with Macros 05:17 Editing a Macro 02:14 Quiz zum Kurs „Automating Workbook Functionality in Excel 2016 (EN)“

### Creating Sparklines and Mapping Data in Excel 2016 (EN)

 Introduction to Visual Representation of Data in Excel 00:34 Creating Sparklines 03:50 Introduction to Display Geographic Data in Excel 00:39 How to Map Data 04:07 Quiz zum Kurs „Creating Sparklines and Mapping Data in Excel 2016 (EN)“

### Forecasting Data in Excel 2016 (EN)

 Introduction to Data Tables in Excel 00:44 Determining Potential Outcomes by Using Data Tables 05:21 Introduction to Data Scenarios in Excel 00:22 Determining Potential Outcomes by Using Data Scenarios 05:06 Introduction to the What-if-Analysis in Excel 00:33 Using the Goal Seek Feature 02:55 Introduction to Forecast Data Tends in Excel 00:15 Using the Forecast Sheet Tool 03:25 Follow-Up: Excel 2016 – Advanced 01:36 Quiz zum Kurs „Forecasting Data in Excel 2016 (EN)“

## Details

• Enthaltene Vorträge: 38
• Laufzeit: 1:37 h
• Enthaltene Quizfragen: 17
• Enthaltene Lernmaterialien: 6

## Dozenten des Kurses Excel 2016: Advanced (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