Excel Formulas - Basics and Beyond

Excel Formulas - Basics and Beyond

ExcelIsFun via YouTube Direct link

Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751

39 of 48
Previous
Next

39 of 48

Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Formulas - Basics and Beyond

Automatically move to the next video in the Classroom when playback concludes
  1. 1 Excel Basics 12: Complete Formula Lesson of Formula Types & Formula Elements 12 Examples
  2. 2 Excel & Business Math 03: Excel's Golden Rule: Formula Inputs, What If Analysis and Excel Models
  3. 3 Excel Basics 13: IF Function Made Easy! IS Functions Too! 14 Epic Examples!!
  4. 4 Excel Basics 14: Excel VLOOKUP Function Made Easy! 9 Examples to Make Your Job Easier!
  5. 5 Excel & Business Math 06: All About Excel Formulas (17 Examples) for Business Math Class
  6. 6 Excel Basics 16: Mixed Cell References #1 Trick to Creating Formulas Quickly!!!
  7. 7 Excel Basics 19: SUMIFS, COUNTIFS, AVERAGEIFS, functions calculations w 1 or more Criteria
  8. 8 Highline Excel 2016 Class 02: Excel Fundamentals: Comprehensive Formula Lesson (15 Examples)
  9. 9 Highline Excel 2013 Class Video 02: Comprehensive Excel Formula Types & Elements Video 12 Examples
  10. 10 Highline Excel 2013 Class Video 03: How Formulas Calculate: Order of Precedence in Excel
  11. 11 Highline Excel 2013 Class Video 07: Worksheet & Workbook References, 3-D Cell References
  12. 12 Basic Excel Business Analytics #10: Find & Fix Excel Formula Errors in Spreadsheet Models
  13. 13 Highline Excel 2013 Class Video 09: Defined Names & Aggregate Functions
  14. 14 Highline Excel 2013 Class Video 08: Excel Table Formula Nomenclature / Structured References 22 Ex.
  15. 15 Highline Excel 2013 Class Video 14: AND, OR, IF Functions For AR Dept (Multiple Logical Tests)
  16. 16 Highline Excel 2013 Class Video 15: IF & IS Functions To Deliver Numbers, Text, Formulas, Nested IFs
  17. 17 Highline Excel 2013 Class Video 16: Round Functions: ROUND, MROUND, ROUNDUP, CEILING, more...
  18. 18 Highline Excel 2013 Class Video 17: Introduction To SUMPRODUCT Function
  19. 19 Highline Excel 2013 Class Video 18: VLOOKUP Function 20 Examples, VLOOKUP Formula, Excel VLOOKUP
  20. 20 Office 2013 Class #37: Excel Basics 19: SUMIFS, COUNTIFS: Add & Count with Criteria/Conditions
  21. 21 Highline Excel 2013 Class Video 32: Introduction To Array Formulas and Array Functions
  22. 22 Highline Excel 2013 Class Video 05: Cell References: Relative, Absolute & Mixed (8 Examples)
  23. 23 Highline Excel 2016 Class 06: Conditional Calculations with Excel Formulas: Comprehensive Lessons
  24. 24 Excel Basics 15: Excel Table Feature & Dynamic Ranges for VLOOKUP, PivotTables, & more!
  25. 25 Excel Formulas & Functions in 10 Minutes. Excel Magic Trick 1629.
  26. 26 Excel Formula for Discounted Sales: Standard Formula or Spilled Arrays? Excel Magic Trick 1636
  27. 27 Excel IF Function. Everything You Need to Know. Excel Magic Trick 1634
  28. 28 OR Logical Test Average Excel Formula. DAVERAGE or Array Formula? Excel Magic Trick 1645
  29. 29 Dynamic Excel Multiplication Table with Conditional Formatting. Excel Magic Trick 1683.
  30. 30 Learn how to use SUMIFS & COUNTIFS function. SUM or COUNT only certain items! EMT1708.
  31. 31 Instant Help with Excel Function: Hot Link, Keyboard or Screen Tip? Excel Magic Trick #1715
  32. 32 Column of Records Into Table with Excel Formula. 2 Amazing Methods! Excel Magic Trick 1716
  33. 33 Excel Formulas for Sequential Numbers 1,1,1,2,2,2 or 1,2,3,1,2,3. Number Incrementors. EMT 1722
  34. 34 Excel Formula to Lookup Nth Value. FILTER, AGGREGATE or SMALL Function? Excel Magic Trick 1727.
  35. 35 Unbelievable New Stock Market Data Tools in Microsoft 365 Excel!!! Excel Magic Trick 1731
  36. 36 Join text items in a cell using TEXTJOIN or ARRAYTOTEXT functions. Excel Magic Trick 1741
  37. 37 Day of the Week Sales Report: Helper Column, PivotTable, Formulas, Array Formula? EMT 1742
  38. 38 OR Logical Tests Made Easy with FILTER Function! Excel Magic Trick 1743
  39. 39 Lookup Last Price In Column Based On Criteria In Other Columns. LOOKUP or XLOOKUP? EMT 1751
  40. 40 Insert a Colon using an Excel Formula. Convert Text Time to Time Value. EMT 1753
  41. 41 VLOOKUP or XLOOKUP for Currency Conversion in Excel Formula? Excel Magic Trick 1758
  42. 42 Excel Formula Master Tricks for Empty Cells, Zeros, Zero Length Text String and ‘Blanks’ EMT 1764
  43. 43 Show all Formulas in Single Column – Awesome Model Documentation Trick - Excel Magic Trick 1800
  44. 44 UnPivot Cross Tabulated Table with Power Query or Dynamic Spilled Array Formula? EMT 1805
  45. 45 Three Way Lookup with Power Query & XLOOKUP (Two-Way Lookup too). Excel Magic Trick 1810
  46. 46 Average Difference Between Ship Date Column & Order Date Column - Excel Magic Trick 1813 #Shorts
  47. 47 Value Preview for Excel Formula Elements: No More F9 & Ctrl + Z!!!! Excel Magic Trick 1816 #Shorts
  48. 48 Top 6 Excel Counting Formulas: COUNTIFS, FILTER or SUM(IF) functions? Excel Magic Trick 1819

Never Stop Learning.

Get personalized course recommendations, track subjects and courses with reminders, and more.

Sign up for free
Someone learning on their laptop while sitting on the floor.