Entdecken Sie, was
Sie lernen können.Mit Videokursen für Beruf, Studium und Freizeit.
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)“ |
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)“ |
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)“ |
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)“ |
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)“ |
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)“ |
Quiz zum Kurs „Excel 2016: Advanced (EN)“ |