# 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
##### How students rated this class
Best Suited for

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.

Be the first!

No ratings just yet—watch a few lessons to be the first to share whether this class met your expectations.

Expectations Met?
• Exceeded!
0%
• Yes
0%
• Somewhat
0%
• Not really
0%
Be the first to leave a review in our updated system!
##### Reviews Archive

In October 2018, we updated our review system to improve the way we collect feedback. Below are the reviews written before that update. You are welcome to edit your old review into the new system!

##### Dave Gerhart

Percussionist, Educator, & Composer

Another good class. Everything is presented very clearly. Again, the audio cut off on the last couple of videos. Please fix.
##### Hector G. Muñoz

Always be learning

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?
##### Elise Price
The last lesson the volume was turned off.
##### Jodi Rothwell
Though the information was presented clearly for the most part, the audio cut out in several places, specifically, during the vLookup section, which was one of the more complicated ones covered during the course. This would have to be fixed in order for me to recommend it. There were also a few typos throughout the course, which should be fixed to make it look more professional.