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

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 recommend

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.

179

Students

1

Project

#### Gilberto Berlanga

International Relationist / Industrial Engineer