As we move into a new month, Microsoft is giving us the usual rundown of what new features came to its Excel spreadsheet app in the previous month. For January 2023, Microsoft Excel received a trio of ...

Many people treat a completed PivotTable as the finish line, but it's actually just the first step. In fact, pro-level Excel spreadsheets let users navigate the data primarily through Slicers 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 ...

Returns a PivotField object that represents all the data fields in a PivotTable. Read-only. This example moves the second PivotItem object to the first position. It assumes that a PivotTable exists on ...

You don’t need a complex expression to add conditional formatting to a filtered PivotTable in Microsoft Excel. Microsoft Excel PivotTables range from easy to complex, and data and reporting ...

When analyzing grouped data, bypass complex functions and use a Microsoft Excel PivotTable. The article How to return first and last times from timestamps in Microsoft Excel uses dynamic array ...

Creates and returns a PivotTable object. This method doesn't display the PivotTable Wizard. This method isn't available for OLE DB data sources. Use the Add method to add a PivotTable cache, and then ...

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.