1. Software & Programmieren

Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Excel 2016 - Intermediate (EN)

Excel 2016 - Intermediate (EN)

Von Sonic Performance

In this course you'll learn create advanced workbooks and worksheets that can help deepen your understanding of organizational intelligence. The ability to analyze massive amounts of data, extract actionable information from it, and present that information to decision makers is at the foundation of a successful organization that is able to compete at a high level.

You will:
• Work with functions.
• Work with lists.
• Analyze data.
• Visualize data with charts.
• Use PivotTables and PivotCharts

Upon successful completion of this course, you will be able to leverage the power of data analysis and
presentation in order to make informed, intelligent organizational decisions.

Inhalte

Working with Functions in Excel 2016 (EN)

play symbol Course Overview: Excel 2016 – Intermediate 		02:27
play symbol Introduction to Functions in Excel 2016 		01:04
lecture locked Introduction to Ranges in Excel 2016 		00:56
lecture locked Naming and Editing Ranges 		05:34
lecture locked Using Defined Names in a Formula 		03:12
lecture locked Using Specialized Functions 		05:06
lecture locked Introduction to Logical Functions in Excel 2016 		02:13
lecture locked How to Use the IF Function in Excel 		04:29
lecture locked How to Use the AND, OR and NOT Function 		05:40
lecture locked Combining Functions in Excel 		06:18
lecture locked Alternatives to the IF Function 		05:14
lecture locked Introduction to Date and Time Functions in Excel 2016 		01:24
lecture locked Using Date Functions in Excel: TODAY, NOW and DATE 		02:54
lecture locked Functions to Calculate Working Days And Weeknumbers: NETWORKDAY, WEEKDAY and More 		05:28
lecture locked Introduction to Text Functions in Excel 2016 		00:47
lecture locked How to Use the String Functions in Excel: LEFT, RIGHT and MID 		02:40
lecture locked How to Use the FIND Function in Excel 		03:19
lecture locked Split Text into Different Columns 		03:38
lecture locked Combining Names in Excel: CONCATENATE 		02:59
lecture locked Converting Text to Upper, Lower, or Proper Case 		02:38
Quiz zum Kurs „Working with Functions in Excel 2016 (EN)“

Working with Lists in Excel 2016 (EN)

play symbol Introduction to Sorting Data in Excel 2016 		00:30
lecture locked How to Sort Data in Excel 		03:00
lecture locked Introduction to Filter Data in Excel 2016 		00:36
lecture locked How to Filter Data in Excel 		02:29
lecture locked Using Functions for Database Queries 		00:42
lecture locked Using Database Functions: SUM and AVERAGE 		03:12
lecture locked Preventing Double-counting in Excel: SUBTOTAL 		00:36
lecture locked Summarize Data with Subtotals 		03:28
Quiz zum Kurs „Working with Lists in Excel 2016 (EN)“

Data Analysis in Excel 2016 (EN)

play symbol Introduction to Tables in Excel 2016 		00:44
lecture locked How to Create and Format Tables in Excel 		06:49
lecture locked Using Summary Functions to Summarize Data 		03:21
lecture locked Introduction to Intermediate Conditional Formatting in Excel 2016 		00:41
lecture locked How to Apply Intermediate Conditional Formatting in Excel 		02:44
lecture locked Introduction to Advanced Conditional Formatting in Excel 2016 		00:35
lecture locked Using Logical Functions to Apply Conditional Formatting 		03:32
Quiz zum Kurs „Data Analysis in Excel 2016 (EN)“

Visualizing Data in Excel 2016 (EN)

play symbol Introduction to Charts in Excel 2016 		00:38
lecture locked How to Create Charts in Excel 		04:28
lecture locked Introduction to Creating and Modifying Charts in Excel 2016 		01:09
lecture locked How to Create and Modify Charts in Excel 		05:15
lecture locked Introduction to Using Advanced Chart Features in Excel 2016 		00:29
lecture locked How to Create a Dual Axis Chart in Excel 		04:27
lecture locked Creating Chart Templates in Excel 		03:02
lecture locked Data Visualization: Best Practices 		03:52
Quiz zum Kurs „Visualizing Data in Excel 2016 (EN)“

Using PivotTables and PivotCharts in Excel 2016 (EN)

play symbol Introduction to PivotTables in Excel 2016 		00:17
lecture locked How to Create a PivotTable in Excel 		04:03
lecture locked Introduction to Using PivotTables for Data Anylsis in Excel 2016 		00:38
lecture locked Analyzing Data with PivotTables 		04:29
lecture locked Introduction to PivotCharts in Excel 2016 		00:50
lecture locked How to create a PivotChart in Excel 		05:01
lecture locked Introduction to Slicers and Timelines in Excel 2016 		00:54
lecture locked Filtering Data with Slicers and Timelines 		04:18
lecture locked Follow-Up: Excel 2016 – Intermediate 		01:35
Quiz zum Kurs „Using PivotTables and PivotCharts in Excel 2016 (EN)“
Quiz zum Kurs „Excel 2016 - Intermediate (EN)“

Details

  • Enthaltene Vorträge: 52
  • Laufzeit: 2:26 h
  • Enthaltene Quizfragen: 22
  • Enthaltene Lernmaterialien: 6

Dozenten des Kurses Excel 2016 - Intermediate (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
1
4 Sterne
0
3 Sterne
0
2 Sterne
0
1  Stern
0
 
Absolute Empfehlung
von Alina C. am 20. March 2020 für Excel 2016 - Intermediate (EN)

Super ausführlich und verständlich erklärt, alle Themenbereiche abgedeckt, regelmäßiges Wiederholen zur Vertiefung der Inhalte

© 2025 Lecturio GmbH. Alle Rechte vorbehalten.

Betreuung durch Dozenten
Auch unterwegs auf Tablet und Smartphone lernen
100% Geld-zurück-Garantie