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 Videos (40m)
    • Introduction to formulas

      4:44
    • Order of operations

      3:42
    • Introduction to Functions

      5:22
    • What are Relative and Absolute references?

      4:34
    • Mouse selection tricks

      1:04
    • Mouse selection trick

      1:04
    • Filling a Range

      0:39
    • Defining a name range

      2:34
    • Clearing a Range

      1:10
    • Selecting 3D Ranges

      1:10
    • SUMIF Function

      1:54
    • COUNTIF Function

      0:59
    • AVERAGE IFS

      3:14
    • AVERAGE IF

      2:03
    • VLOOKUP FUNCTION

      3:42
    • 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

210

Students

1

Project

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

Level

Community Generated

The level is determined by a majority opinion of students who have reviewed this class. The teacher's recommendation is shown until at least 5 student responses are collected.

Gilberto Berlanga

International Relationist / Industrial Engineer

Report class