From raw data to report-ready in minutes!

ExcelPivotTable.Calculate(refresh) Calculates the pivot table. Parameter 0 - if true the cache will be refreshed before calculating. If false the existing cache will be used. If no cache exists the ...

Copilot in Excel introduces new finance-focused capabilities that help teams work to their standards, use trusted financial data, and stay in control of every change. GPT‑5.5 Instant is now available ...

Pivot table slicers are drawing objects that map to a Pivot table fields value filter. The slicer can be connected to any item filter in a Pivot table. A slicer can also be connected to multiple Pivot ...

Sometimes, when you’re analysing data, you need to be able to change variables and see what the impact is: for example you might want to see what your profit margin looks like if tax rates are set at ...

There are lots of ways to return the top or bottom n records from a data set in Microsoft Excel, but the new dynamic array functions make doing so easier than ever. Returning the top or bottom n ...