Entdecken Sie, was
Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Überall verfügbar
Lernen Sie am PC oder mobil auf Tablet oder Smartphone.

Tempo

Eigenes Lerntempo
Wiederholen Sie, sooft Sie wollen.

Schneller Lernerfolg
Lernvideos, Übungen und Quizfragen bringen Sie ans Ziel.

Working with Functions in Excel 2016 (EN)

Von Sonic Performance

You already know how to get Microsoft® Office Excel® 2016 to perform simple calculations to make your job easier. However, manually entering formulas will take you only so far. As you progress with Excel, you'll need to know how to ask Excel more complex questions about your data and to get the answers you expect.

Inhalte

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

Details

Enthaltene Vorträge: 20
Laufzeit: 1:08 h
Enthaltene Quizfragen: 5
Enthaltene Lernmaterialien: 1

Diese Kurse könnten Sie interessieren

Excel 2016 - Intermediate (EN)

Sonic Performance

(1)

~~1,95 € mtl.~~ 1,70 € mtl.

Sie sparen 13 %

Dozenten des Kurses Working with Functions in Excel 2016 (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