Microsoft has been adding new features to Excel lately, and the latest one could change the way people work with formulas.

Excel table formulas driving you crazy? Learn the fix to lock column references, prevent errors, and simplify your spreadsheet calculations ...

In the Tables group, click PivotTable and then choose From Table/Range in the dropdown. In this case, Excel will base the PivotTable on TableCalls2. In the resulting dialog, click Existing Worksheet.

Excel's new Copilot function turns your prompts into formulas - how to try it It's so much easier to create, summarize, and analyze data now - no complex manual formulas required.