Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Excel 2016: Advanced (EN)

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

play symbol Course Overview: Excel 2016 – Advanced
02:11
lecture locked Introduction to Links and External References in Excel 2016
01:04
lecture locked Using Links and External References
05:37
lecture locked Introduction to 3-D References in Excel 2016
00:49
lecture locked How to Use 3-D References in Excel
04:23
lecture locked Introduction to Data Cosolidation in Excel 2016
00:31
lecture locked How to Consolidate Data in Excel
05:01
Quiz zum Kurs „Working with Multiple Worksheets and Workbooks in Excel 2016 (EN)“
play symbol Introduction to the LOOKUP Function in Excel 2016
00:49
lecture locked Using the LOOKUP Function
08:14
lecture locked Introduction to Precedent and Dependent Cells in Excel 2016
00:44
lecture locked Tracing Precedent and Dependent Cells
02:58
lecture locked Introduction to Watch and Evaluate Formulas in Excel
00:44
lecture locked Watching and Evaluating Formulas
03:58
Quiz zum Kurs „Using LOOKUP Functions and Formula Auditing in Excel 2016 (EN)“
play symbol Introduction to Collaborations on a Workbook in Excel
00:43
lecture locked Collaborating on a Workbook
05:32
lecture locked Introduction to Comparing and Merging Workbooks in Excel
02:52
lecture locked Introduction to Protecting Worksheets and Workbooks in Excel
00:38
lecture locked How to Protect Worksheets and Workbooks in Excel
04:02
Quiz zum Kurs „Collaborate on a Workbook With Multiple People in Excel 2016 (EN)“
play symbol Introduction to Data Validation
00:51
lecture locked Applying Data Validation to Cells
04:16
lecture locked Introduction to the Data Validation and Error Checking Tool
00:39
lecture locked Searching for Invalid Data and Formulas with Errors
02:59
lecture locked Introduction to Automating Tasks with Macros in Excel
00:40
lecture locked Working with Macros
05:17
lecture locked Editing a Macro
02:14
Quiz zum Kurs „Automating Workbook Functionality in Excel 2016 (EN)“
play symbol Introduction to Visual Representation of Data in Excel
00:34
lecture locked Creating Sparklines
03:50
lecture locked Introduction to Display Geographic Data in Excel
00:39
lecture locked How to Map Data
04:07
Quiz zum Kurs „Creating Sparklines and Mapping Data in Excel 2016 (EN)“
play symbol Introduction to Data Tables in Excel
00:44
lecture locked Determining Potential Outcomes by Using Data Tables
05:21
lecture locked Introduction to Data Scenarios in Excel
00:22
lecture locked Determining Potential Outcomes by Using Data Scenarios
05:06
lecture locked Introduction to the What-if-Analysis in Excel
00:33
lecture locked Using the Goal Seek Feature
02:55
lecture locked Introduction to Forecast Data Tends in Excel
00:15
lecture locked Using the Forecast Sheet Tool
03:25
lecture locked Follow-Up: Excel 2016 – Advanced
01:36
Quiz zum Kurs „Forecasting Data in Excel 2016 (EN)“
Quiz zum Kurs „Excel 2016: Advanced (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

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