Completed
09:44 - Absolute vs relative cell references
Class Central Classrooms beta
YouTube videos curated by Class Central.
Classroom Contents
Excel Tutoring for Beginners - Learn Formulas and Functions Step-by-Step
Automatically move to the next video in the Classroom when playback concludes
- 1 00:00 - Intro to Excel formulas & functions
- 2 00:23 - Understanding formulas in Excel
- 3 01:23 - Referencing cells vs hardcoding numbers
- 4 02:09 - Subtract, multiply & divide with formulas
- 5 03:33 - When to use functions instead of formulas
- 6 04:04 - How to use the SUM function
- 7 05:14 - Key difference: formula vs function
- 8 05:31 - Using the AVERAGE function
- 9 06:12 - Using the MAX function
- 10 06:39 - Using the MIN function
- 11 06:49 - Using the COUNT function
- 12 07:05 - Using the IF function with logic
- 13 08:42 - Bonus: IF function walkthrough with function helper
- 14 09:16 - Explore Excel’s function library
- 15 09:44 - Absolute vs relative cell references
- 16 11:30 - Wrap-up and next steps
