Excel 2013: Understanding Formulas and Functions from scratch | Gilberto Berlanga | Skillshare

# Excel 2013: Understanding Formulas and Functions from scratch

#### Gilberto Berlanga, International Relationist / Industrial Engineer

Play Speed
• 0.5x
• 1x (Normal)
• 1.25x
• 1.5x
• 2x
16 Lessons (40m)
• 1. Introduction to formulas

4:44
• 2. Order of operations

3:42
• 3. Introduction to Functions

5:22
• 4. What are Relative and Absolute references?

4:34
• 5. Mouse selection tricks

1:04
• 6. Mouse selection trick

1:04
• 7. Filling a Range

0:39
• 8. Defining a name range

2:34
• 9. Clearing a Range

1:10
• 10. Selecting 3D Ranges

1:10
• 11. SUMIF Function

1:54
• 12. COUNTIF Function

0:59
• 13. AVERAGE IFS

3:14
• 14. AVERAGE IF

2:03
• 15. VLOOKUP FUNCTION

3:42
• 16. Project Assignment

2:33

In this class, I will introduce Formulas and Functions from scratch, you will understand the basics and the sintax of functions which help us to increase the productivity when we work in Excel

212

Students

1

Project

• --
• Beginner
• Intermediate
• All Levels
• Beg/Int