Excel formulas are getting scary good.

Q. Traditional PivotTables have always intimidated me. I see there is a new Excel function called PIVOTBY. What is the difference between it and the traditional PivotTable? With the PIVOTBY function, ...

If you've ever used Excel, you're probably familiar with the panicky feeling that comes with using Microsoft's spreadsheet app. It can feel a little overwhelming and tough to navigate, even if you are ...

Most people know that you can reference one or more cells, tables and their column headers, or named ranges in Excel formulas. However, fewer know that you can reference specific data points in ...

Overview Excel remains a core tool for data analysts, and a small set of functions can handle most tasks related to lookups, ...