Discover what you can learn.
With video courses for work, study and leisure.
Discover what you can learn.
With video courses for work, study and leisure.
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 for course „Creating Advanced Formulas in Excel 2013“ |
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.
Top Trainers, Top Content, best e-learning experience ever. We are conviced of that - 100%. That´s why we offer a 100% Money-Back Guarantee. You are not satisfied at all? Please drop us some lines. Up to 5 days within your purchase we refund the complete price you paid - no ifs and buts.
