In this video learn about:
(00:11) Introduction to these new Excel 2016 Functions
(01:13) MINIFS function to find minimum value with conditions or criteria.
(03:23) MAXIFS function to find max value with conditions or criteria.
(04:19) IFS function to select from more than two items and put a particular item into a cell based on logical tests.