Entdecken Sie, was Sie lernen können.

Mit Videokursen für Beruf, Studium und Freizeit.

Creating Advanced Formulas in Excel 2013

Von Sonic Performance

If you attempt to create advanced formulas in Microsoft Excel 2013 you have come to the right place. In this course for beginners you are going to learn all the basic steps you need to create advanced formulas in Microsoft Excel 2013. As well as giving you a general introduction into creating advanced formulas it is going to help you completing the following tasks:

• Editing and Deleting Range Names
• Using Range Names in a Formula
• Using Specialized Functions

Inhalte

 Creating Advanced Formulas - Lesson Introduction 00:46 Add Range Names 06:49 Edit and Delete Range Names 03:34 Use Range Names in a Formula 06:12 Use Specialized Functions 06:36 Use the SUM Function 02:47 Use the AVERAGE Function 03:20 Use the MIN Function 03:40 Use the MAX Function 03:10 Use COUNT, COUNTA and COUNTIF Functions 07:03 Use the ROUND Function 04:46 Use the AND Function 04:23 Use the CONCATENATE Function 04:44 Use HLOOKUP and VLOOKUP Functions 05:02

Details

• Enthaltene Vorträge: 14
• Laufzeit: 1:02 h
• Enthaltene Quizfragen: 2
• Enthaltene Lernmaterialien: 1

Dozenten des Kurses Creating Advanced Formulas in Excel 2013

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