Microsoft has restarted its monthly feature round-up, detailing how Excel changed during January 2026 across Windows, Mac, and the web. The headline upgrade is Agent ...

AddPowerQuery Adds a connection using power query. This requires a connection string using the Microsoft.Mashup.OleDb.1 provider and a M-Formula to describe the data source. AddDatabase Adds a ...

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 ...

Have you ever opened an Excel file and felt a pang of unease? Rows upon rows of data, cryptic formulas sprawled across cells, and a tangle of manual formatting that seems one misstep away from chaos.

Restoring the drag-and-drop menu in your Excel Pivot Table is typically a quick fix. By using either right-click options or ribbon commands, you can easily access the field list again. If all else ...

A monthly overview of things you need to know as an architect or aspiring architect. Unlock the full InfoQ experience by logging in! Stay updated with your favorite authors and topics, engage with ...

Charts and sparklines are powerful data visualization tools in Excel. Here’s a guide to the most popular chart types in Excel and how to best use them. Microsoft Excel offers a plethora of tools for ...

If you are working with Excel spreadsheets or workbooks, juggling multiple tables of data, at some time you might need to combine them into one. Rather than spending hours manually copying and pasting ...

Placing spreadsheet data into a table quickly formats it and makes it easy to work with and analyze. Here’s how to use this basic yet powerful Excel tool. Tables are one of the fundamental tools in ...

is a former weekend editor who covered tech and entertainment. He has written news, reviews, and more as a tech journalist since 2020. Google has now added a way to create easily formatted tables in ...