Completed
) Homework
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Fundamentals - Comprehensive Formula Lesson
Automatically move to the next video in the Classroom when playback concludes
- 1 ) Introduction
- 2 ) Excel’s Golden Rule
- 3 ) Look at list of Formula Types and Formula Elements
- 4 ) Number Formula Examples
- 5 ) Text and Number Formulas for counting numbers above a hurdle
- 6 ) When to combine Comparative Operator and Number in a cell or when to combine Comparative Operator and Number in the formula.
- 7 ) DOLLAR function.
- 8 ) How to combine Comparative Operator and Number in the formula.
- 9 ) VLOOKUP function and Array Constant
- 10 ) IF Function
- 11 ) Logical Formula
- 12 ) Aggregate Calculation / Aggregate Formula
- 13 ) Array Calculation / Array Formula
- 14 ) Excel Formula Order of Precedence (Excel’s Order of Operations)
- 15 ) Tracking Down Errors in Excel: 4 Step Method.
- 16 ) Types of Errors
- 17 ) When to use ROUND function
- 18 ) 3 ways to enter cell references into formulas
- 19 ) Summary
- 20 ) Homework
