Excel Array Formulas - Comprehensive Lessons with 12 Examples

Excel Array Formulas - Comprehensive Lessons with 12 Examples

ExcelIsFun via YouTube Direct link

) Array Formula 8: Function Argument Array Operation in criteria1 argument. Goal: Score Myers-Briggs Test in Human Resource Department.

14 of 20

14 of 20

) Array Formula 8: Function Argument Array Operation in criteria1 argument. Goal: Score Myers-Briggs Test in Human Resource Department.

Class Central Classrooms beta

YouTube videos curated by Class Central.

Classroom Contents

Excel Array Formulas - Comprehensive Lessons with 12 Examples

Automatically move to the next video in the Classroom when playback concludes

  1. 1 ) Download Files
  2. 2 ) Aggregate vs. Array Calculations & Define Array
  3. 3 ) Define Array Formulas
  4. 4 ) Example of non-array formula. Standard Formula: Formulas that calculate a single answer. Goal: Calculate Total Expense and Total Net Income.
  5. 5 ) Array Formula 1: Math Array Operation. Goal: Calculate Total Expense for each month without making calculations in many cells (we don’t need all the individual numbers). Main reason we use Array Fo…
  6. 6 ) How to decide whether or not you must use Ctrl + Shift + Enter to put the array formula into the cell.
  7. 7 ) Implicit Intersection.
  8. 8 ) SUMPRODUCT function to house an array calculation to avoid using Ctrl + Shift + Enter.
  9. 9 ) Array Formula 2: Math Array Operations. Goal: Calculate Overall Total Expense in a single cell.
  10. 10 ) Array Formula 3: Math Array Operations. Goal: Calculate Overall Net Income in a single cell.
  11. 11 ) Formula 4: Use more than one argument in SUMPRODUCT. Goal: Calculate total Bank Deposit. Learn about SUMPRODUCT and discussion about size and dimensions of arrays in array calculations.
  12. 12 ) Array Formula 5: Function Argument Array Operation in k argument. Goal: Add 3 biggest and 3 smallest. Use Array Constant to avoid Ctrl + Shift + Enter.
  13. 13 ) Array Formula 6: Function Argument Array Operation in criteria1 argument. Goal: Add Sales for each Sales Team. Example of using an Array Formula to create a MUCH smaller formula than non-Array Form…
  14. 14 ) Array Formula 8: Function Argument Array Operation in criteria1 argument. Goal: Score Myers-Briggs Test in Human Resource Department.
  15. 15 ) Array Formula 9: Function Argument Array Operation in criteria1 argument. Join Array Operation. Goal: Score Myers-Briggs Test in Human Resource Department.
  16. 16 ) Array Formula 10: IF function array formula to filter out values for an aggregate function. Goal: Calculate Average Gross Profit for Each Sales Rep. Learn about how to use IF Function to filter out…
  17. 17 ) List of Functions that can NEVER do Array Calculations.
  18. 18 ) Array Formula 11: Built-in Array Function: TRANSPOSE. Goal: Transpose rows and columns so we have Assumption Table that allows Mixed Cell References. Example of Array Formula where we enter multipl…
  19. 19 ) Array Formula 12: Built-in Array Function: FREQUENCY. Goal: Count how many sales are in each category.
  20. 20 ) Summary

Never Stop Learning.

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

Someone learning on their laptop while sitting on the floor.