### DESCRIPTION

In this video learn about:

**(00:13)** Introduction

**(01:09)** Excel’s Golden Rule

**(04:31)** Look at list of Formula Types and Formula Elements

**(06:29)** Number Formula Examples

**(08:24)** Text and Number Formulas for counting numbers above a hurdle

**(11:15)** When to combine Comparative Operator and Number in a cell or when to combine Comparative Operator and Number in the formula.

**(12:36)** DOLLAR function.

**(14:09)** How to combine Comparative Operator and Number in the formula.

**(16:53)** VLOOKUP function and Array Constant

**(22:31)** IF Function

**(25:09)** Logical Formula

**(27:06)** Aggregate Calculation / Aggregate Formula

**(28:12)** Array Calculation / Array Formula

**(32:40)** Excel Formula Order of Precedence (Excel’s Order of Operations)

**(37:05)** Tracking Down Errors in Excel: 4 Step Method.

**(40:37)** Types of Errors

**(46:19)** When to use ROUND function

**(49:43)** 3 ways to enter cell references into formulas

**(53:22)** Summary

**(54:25)** Homework

Highline Excel 2016 Professional Class taught by Michael excelisfun Girvin

## Leave a Reply

You must be logged in to post a comment.