Excel Fundamentals - Comprehensive Formula Lesson

YouTube·Microsoft Excel

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.