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

About This Class

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