Excel Formulas and Functions | Full Course

In this step-by-step Microsoft Excel tutorial, learn how to use Formulas and Functions. We start with the fundamentals of entering formulas into Excel. Then we advance to the most common formulas and functions that you’ll encounter in Excel. This video is perfect for beginners who are new to formulas and functions, and even more advanced users who want to pick up a new trick or two.

• Additional resources
  • Excel Workbook without formulas to follow along
  • Completed Workbook with all formulas and Functions
• Timestamps
  • 0:00 Introduction
  • 0:45 Status bar metrics
  • 2:03 Enter formula to add
  • 2:50 Edit formulas
  • 3:06 Relative references
  • 5:29 Fill handle
  • 6:13 Subtract
  • 6:57 Multiply
  • 7:40 Absolute reference
  • 9:46 Reference cells on other sheets
  • 10:45 Name manager
  • 12:03 Divide
  • 12:44 Order of operations
  • 14:40 Basic functions
  • 15:04 Sum function
  • 17:46 Formula text function
  • 18:13 Discovering functions
  • 18:37 Auto sum
  • 19:37 Max function
  • 20:15 Min function
  • 20:48 Large function
  • 21:54 Small function
  • 22:35 Count function
  • 23:00 Counta function
  • 23:49 Countblank function
  • 24:08 Average function
  • 24:44 Median function
  • 25:00 Mode function
  • 25:23 Sumif function
  • 27:29 Wildcards
  • 28:36 Sumifs function
  • 31:26 Proper function
  • 32:00 Trim function
  • 32:25 Concat function
  • 33:39 & function
  • 34:05 Textjoin function
  • 34:52 Right, left and mid functions
  • 35:27 Len function
  • 35:46 Find and search functions
  • 36:40 Left together with find
  • 38:23 Logical functions
  • 39:21 And function
  • 39:53 Or function
  • 40:14 If function
  • 41:27 If together with and
  • 42:23 If together with or
  • 43:00 Nested if
  • 44:41 Ifs function
  • 45:32 Vlookup function
  • 47:18 Xlookup function
  • 49:24 Today and now functions
  • 49:51 Bonus
  • 52:04 Wrap up