Excel 2013: Understanding Formulas and Functions from scratch Premium class

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

7 of 8 students recommendSee All

Another good class. Everything is presented very clearly. Again, the audio cut off on the last couple of videos. Please fix.
Dave Gerhart

Percussionist, Educator, & Composer

The professor is very straightforward in explaining the topics in a way that's understandable to everyone. I'm actually an Excel advanced user and I not only remembered things I was forgetting how to use, but I also learned a couple of cool tricks throughout the course. Ps. The audio is muted for some reason in the final part of the last couple of videos, is there anything that can be done for other users to be able to grasp what's being said?
Hector G. Muñoz

Always be learning

The last lesson the volume was turned off.

173

Students

1

Project

Gilberto Berlanga

International Relationist / Industrial Engineer