Excel Fundamentals - Comprehensive Formula Lesson

Overview

Dive into a comprehensive 55-minute video tutorial on Excel 2016 fundamentals, focusing on formulas with 15 practical examples. Learn Excel's Golden Rule, explore various formula types and elements, and master essential functions like VLOOKUP, IF, and DOLLAR. Understand the intricacies of number, text, logical, aggregate, and array formulas. Discover Excel's order of precedence, troubleshoot errors using a 4-step method, and explore when to use the ROUND function. Gain insights on different ways to enter cell references and conclude with a summary and homework assignment to reinforce your learning.

Syllabus

) Introduction.
) Excel’s Golden Rule.
) Look at list of Formula Types and Formula Elements.
) Number Formula Examples.
) Text and Number Formulas for counting numbers above a hurdle.
) When to combine Comparative Operator and Number in a cell or when to combine Comparative Operator and Number in the formula..
) DOLLAR function..
) How to combine Comparative Operator and Number in the formula..
) VLOOKUP function and Array Constant.
) IF Function.
) Logical Formula.
) Aggregate Calculation / Aggregate Formula.
) Array Calculation / Array Formula.
) Excel Formula Order of Precedence (Excel’s Order of Operations).
) Tracking Down Errors in Excel: 4 Step Method..
) Types of Errors.
) When to use ROUND function.
) 3 ways to enter cell references into formulas.
) Summary.
) Homework.