How-To Geek on MSN

I love Excel's PIVOTBY function—but this one feature keeps me using PivotTables

PIVOTBY is great for analysis, but PivotTables still have the edge when formatting needs to adapt to data changes.
Geeky Gadgets

How to Build a Excel PivotTable from Multiple Sources

Excel’s PivotTable feature is a fantastic option for data analysis, allowing users to consolidate and analyze data from various sources in a single, dynamic table. By mastering the art of creating ...
How-To Geek on MSN

Nobody told me about these 5 Excel PivotTable tricks—now I use them every day

PivotTables can do more than you think, from splitting reports by category to calculating unique counts and percentage growth ...
TechRepublic

How to return the first and last times from timestamps in a Microsoft Excel PivotTable

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

How to return the top or bottom n records without a filter or PivotTable in Excel

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

Create interactive dashboards with Excel PivotCharts and slicers

Q. How can I use Excel to turn static financial reports into interactive dashboards that decision-makers can explore? A. You can use Excel for creating interactive dashboards using PivotCharts ...