Learn six different methods to calculate the time between starting college and taking the first geology class in Excel. Explore solutions using MIN, MAX, IF, SEARCH functions, INDEX and MATCH with LEFT, AGGREGATE with ISNUMBER and SEARCH, MAXIFS and MINIFS, PivotTables with formulas, and Power Query. Discover techniques applicable to various Excel versions, from older releases to the latest Excel 2016 and beyond. Download the provided start and finished Excel files to follow along with the 27-minute tutorial.
Overview
Syllabus
) Intro.
) MIN & MAX & IF & SEARCH solution (Any Version of Excel).
) INDEX & MATCH & LEFT solution (Any Version of Excel).
) AGGREGATE & ISNUMBER & SEARCH solution (Excel 2010 or later).
) MAXIFS & MINIFS solution (Excel 2016 Insider Program or later versions of Excel).
) 2 PivotTables and a Formula solution (Any Version of Excel).
) Power Query solution (Excel 2016, or as Download in Excel 2010 or 2013).
Taught by
ExcelIsFun
