Download Excel File: https://excelisfun.net/files/EMT1652.xlsx
Learn how to create a single cell Yearly Sales Report with each year’s sales on a different line. Learn about the new Office 365 functions: LET, SORT, UNIQUE and TEXTJOIN. See old school Excel Functions: YEAR & SUMIFS. Learn about the New LET Functions that lets you define variables in formulas.
1. (00:01) Introduction
2. (00:23) Formula #1: TEXTJOIN, CHAR and the DOLLAR Functions, was well as Spilled Arrays. Also see the functions, SORT, UNIQUE, YEAR, SUMIFS.
3. (01:57) Formula #2: Mash all the formula elements into a single Mega Formula. Learn how to use Clipboard for Mega Formulas.
4. (02:50) Formula #3: Use LET and define the Year Variable. New Era of Office 365 and LET Function to define variables!
5. (04:44) Formula #4: Use LET Function with three defined variables. This means that the variables are calculated one time, and then the result is used in the result of the LET Function formula.
6. (05:05) Summary and End Video Links