Structured references use table columns instead of cell coordinates, making formulas easier to read, update, and trust.

Replace confusing cell references with global constants, local variables, and reusable custom functions.

Imagine you’re tasked with analyzing two datasets—one containing a list of products and another with customer segments. How do you uncover every possible pairing to identify untapped opportunities?

Excel 2007's new table feature eliminates the need to copy formulas; once you define a data range as a table, Excel will do it for you! Tables are new to Excel 2007 ...

Q. I usually like Excel PivotTables, but because they don’t allow me to do certain things, such as delete cells or insert new columns or rows, I’m wondering if there is a reasonable alternative? A.