Entdecken Sie, was
Sie lernen können.Mit Videokursen für Beruf, Studium und Freizeit.
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:
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 |
Quiz zum Kurs „Creating Advanced Formulas in Excel 2013“ |