Posts from this author will be added to your daily email digest and your homepage feed. is a senior editor and author of Notepad, who has been covering all things Microsoft, PC, and tech for over 20 ...

Discover 17 new Excel features and functions for 2026, so you track edits and data faster. Including auto-refreshing pivots ...

After playing with Copilot in Excel for a while, I decided to throw a messy sales sheet at Copilot to see if it could ...

Row precision vs. Aggregation errors: MAP is the best way to use "greedy" functions like AND or OR in a single, dynamic ...

When something so obvious is available in competitors, even in other Microsoft programs and features, and Excel is only now getting it. When working with Excel, one would expect that pivot tables, ...

Reviews and recommendations are unbiased and products are independently selected. Postmedia may earn an affiliate commission from purchases made through links on this page. Pivot tables in Excel allow ...

One of the best features in Microsoft Excel is the Pivot Table, believe it or not. There is no need to learn any formatting or coding to create hundreds of rows of data along with quick summaries of ...

Microsoft Excel tables are a way to organize complex data into rows and columns, making your information easy to understand. Table styles let users add color and change the font of their tables. If ...

Have you ever felt limited by the rigidity of Excel PivotTables when creating interactive reports? Many users assume that Excel slicers, the sleek, clickable filters that make data exploration a ...

In Microsoft Excel 2010, you can create large tables in which to store your data and then use it in formulas and store the results in the same table. You can insert and calculate almost anything ...