Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

# 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)

 Course Overview: Excel 2016 – Intermediate 02:27 Introduction to Functions in Excel 2016 01:04 Introduction to Ranges in Excel 2016 00:56 Naming and Editing Ranges 05:34 Using Defined Names in a Formula 03:12 Using Specialized Functions 05:06 Introduction to Logical Functions in Excel 2016 02:13 How to Use the IF Function in Excel 04:29 How to Use the AND, OR and NOT Function 05:40 Combining Functions in Excel 06:18 Alternatives to the IF Function 05:14 Introduction to Date and Time Functions in Excel 2016 01:24 Using Date Functions in Excel: TODAY, NOW and DATE 02:54 Functions to Calculate Working Days And Weeknumbers: NETWORKDAY, WEEKDAY and More 05:28 Introduction to Text Functions in Excel 2016 00:47 How to Use the String Functions in Excel: LEFT, RIGHT and MID 02:40 How to Use the FIND Function in Excel 03:19 Split Text into Different Columns 03:38 Combining Names in Excel: CONCATENATE 02:59 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)

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

### Data Analysis in Excel 2016 (EN)

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

### Visualizing Data in Excel 2016 (EN)

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

### Using PivotTables and PivotCharts in Excel 2016 (EN)

 Introduction to PivotTables in Excel 2016 00:17 How to Create a PivotTable in Excel 04:03 Introduction to Using PivotTables for Data Anylsis in Excel 2016 00:38 Analyzing Data with PivotTables 04:29 Introduction to PivotCharts in Excel 2016 00:50 How to create a PivotChart in Excel 05:01 Introduction to Slicers and Timelines in Excel 2016 00:54 Filtering Data with Slicers and Timelines 04:18 Follow-Up: Excel 2016 – Intermediate 01:35 Quiz zum Kurs „Using PivotTables and PivotCharts in Excel 2016 (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 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. März 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