Excel Array Formula Series 12: MMULT function Matrix Algebra
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to use the array function MMULT to multiple Matrices in Matrix Algebra. This is an array function that requires the Ctrl + Shift + Enter trick. In this series ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #8: FREQUENCY function
by
ExcelIsFun
on
Youtube
Duration:
0.09 hours
See how to use the Array FREQUNCY function correctly. See how to use the FREQUNCY function to counts occurrences in categories. Then use the frequencies ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #7: Boolean Logic & Criteria
by
ExcelIsFun
on
Youtube
Duration:
0.17 hours
See how to create array formulas for Summing and Counting when there are multiple conditions. See how to use Boolean logic and array formulas to calculate ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #6: Statistics Bayes' Theorem
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
Create an array formula for Bayes' Theorem in Statistics. See the Root (Prior) probability, Conditional Probability, Joint Probability and Posterior Probability.
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #5: SUM 3 Largest Values
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to create array formula for adding the 3 largest or smallest values in a data set. This is a great trick for scoring the Maximum Time Aloft Boomerang ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #2: TRANSPOSE function
by
ExcelIsFun
on
Youtube
Duration:
0.04 hours
See how to use the Array function TRANSPOSE to transpose a table, switching rows and columns to columns and rows. In this series see how to create array ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #1: Basics of Array Formulas
by
ExcelIsFun
on
Youtube
Duration:
0.14 hours
See how to create a basic array formula. Learn about the syntax, the Ctrl + Shift + Enter method of formula entry and the curly brackets that get entered ...
About Channel:
Over 3000 Excel How To Videos from Beginner to Advanced, including downloadable Excel files to pr...
Excel Array Formula Series #3: Expected Return For Stocks
by
ExcelIsFun
on
Youtube
Duration:
0.06 hours
See how to create array formula that will calculate the Expected Return for Stocks. See how to calculate individual stock return and standard deviation given ...
