Highline Excel 2016 Class 02

Excel Fundamentals: Comprehensive Formula Lesson (15 Examples)

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

WORKBOOKS

Download “Highline Excel 2016 Class 02” Highline-Excel-2016-Class-02.zip – Downloaded 31 times – 527 KB




Be the first to comment

Leave a Reply