# Excel Formulas Training Video Series

We have recently published a Free Excel Formulas Training Video Course explaining how to use the most important functions/formulas in Excel. All videos include well-prepared examples which help the user to understand the real-life usage of that specific function. This course has been published on our Youtube Channel but you can watch all the individual videos below as well.

** Please note that all examples being used in this course are provided as a separate Excel Template in which you can practice your Excel skills. You can check all our Excel Training Templates.

## Excel Formulas Training Video Course Details

• Covers the most important 30+ functions in separate videos
• Suitable for both Beginner and Advanced users
• Includes more than 100 well-prepared examples
• Total of ~3 hours of hands-on training
• Easy to follow, step by step on screen instructions for all examples

 1. Basic Math Operators 11. VLOOKUP Function 21. Advanced VLOOKUP Function 2. SUM Function 12. IF Function 22. IF – AND Combinations 3. COUNT Function 13. COUNTIF Function 23. IF – OR Combinations 4. AVERAGE Function 14. SUMIF Function 24. Nested IFs 5. MAX and MIN Functions 15. IS Functions 25. MATCH Function 6. Date Functions 16. CONCATENATE Function 26. INDEX Function 7. LEN Function 17. HLOOKUP Function 27. MID and SEARCH Function 8. COUNTA Function 18. RIGHT and LEFT Functions 28. OFFSET Function 9 ROUND Function 19. RAND Function 29. INDIRECT Function 10. SUMPRODUCT Function 20. IFERROR Function 30. ARRAY Formulas

### Lesson 30 – Excel Array Formulas Explained with Examples

As stated above, all examples being used in this course are provided as a separate template of which you can see the details here:

Hope this course was helpful to you!

Feel free to leave comments below and don’t forget to subscribe our youtube channel.

This Post Has One Comment
1. I am Brazilian and I have a blog of excel, I am taking several tips with you to teach people to learn excel in Brazil, thanks for everything.