Excel's GROUPBY function lets you group and aggregate ... because the data is in a formatted Excel table called TabFood, a structured reference to the column name is added to my formula: =GROUPBY ...

Excel's PERCENTOF function returns the percentage that ... In my example, I've used a formatted Excel table and structured references. As a result, my formulas are easier to parse, and if I ...

In this tutorial ... you’d need the longer structured reference, =SORT(UNIQUE(TableSales[Personnel])). Image: Susan Harkins/TechRepublic. Excel populates the list with the entire spill range.

Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the ...