One of the most unusual — and fun — events in college sports is a high-stakes spreadsheeting competition in Las Vegas.

Q. Could you explain how the AGGREGATE function works in Excel? A. AGGREGATE is possibly the most versatile function in Excel. Think of it as an advanced version of the SUBTOTAL function that offers ...

Q. In your November Tech Q&A article on Excel’s Scenario Manager, you mentioned two other “what-if” tools: Goal Seek and Data Table. Can you show how those work like you did with Scenario Manager?

Excel’s new “Show Details” checkbox is a fantastic option for interacting with and visualizing your data. By seamlessly integrating this feature with advanced formulas, you can effortlessly display ...

MESCIUS inc. (formerly GrapeCity) provides JavaScript and .NET grids, UI, reporting, spreadsheets, document APIs, etc. MESCIUS inc. (formerly GrapeCity) provides ...

The Excel JavaScript API lets your add-in create PivotTables and interact with their components. This article describes how PivotTables are represented by the Office JavaScript API and provides code ...

> This only applies to multiple Excel workbooks open on Windows or Mac. ## Coauthoring See [Coauthoring in Excel add-ins](co-authoring-in-excel-add-ins.md) for ...