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.

In this video, we explore eight new Excel features for 2026, including: - **Formula Auto-Complete**: Automatically generates ...

Discover 8 2026 Excel updates, including AI formula creation and a year of change history, so your team works quicker with fewer mistakes.

Pivot tables are an advanced method of arranging organized data and using formulae in Microsoft Excel. We could use standalone formulae over rows and columns but upon adding or deleting rows these ...

How to combine and analyze data from multiple data sets using Excel Power Pivot Your email has been sent If you've have lots of data and lots of analysis to do, but little time or skill, you need ...

Discover 15 modern Excel functions for 2026, including Group By and Scan, so you speed up your workflows, summaries and ...

Please note: This item is from our archives and was published in 2018. It is provided for historical reference. The content may be out of date and links may no longer function. Because the field names ...

Once data is loaded into Excel, Copilot allows users to ask questions in natural language instead of building new formulas.