Excel has more than 450 functions, many of which are unused by business professionals. This session will put you on a path to improved Excel productivity by introducing you to powerful but little used Excel functions, such as IFS (for nested IF statements), AGGREGATE (best described as SUBTOTAL on steroids), GETPIVOTDATA (for producing formal reports from data summarized in a pivot table), CUBEVALUE (for building reports directly from the Excel Data Model) or TEXTJOIN (for joining text or creating CSV files quickly and easily).