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

Office Q&A: An advanced Excel filter to match multiple values and a PowerPoint picture timesaver

This month, Susan Harkins introduces an Excel user to advanced filtering and helps a PowerPoint user reduce his work when positioning pictures in PowerPoint. In this month’s Office Q&A, Jean asks how ...
Geeky Gadgets

Excel’s Ultimate FILTER Hack : Multiple Columns Multiple Values

What if you could take the chaos of a sprawling Excel spreadsheet and distill it into exactly the information you need—no fluff, no manual sifting, just precision? For anyone who’s ever wrestled with ...
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 ...
TechRepublic

How to display multiple subtotal rows in a Microsoft Excel PivotTable

If you want to display multiple subtotals in your Microsoft Excel PivotTables, learn how to use a hard-to-find setting. Microsoft Excel PivotTables are a great way to summarize data. They’re easy to ...
JournalofAccountancy

Using Advanced Filter in Excel

Q. I have used the filter feature in Excel, but what does the Advanced Filter feature do? A. There is a simple filter feature available in Excel, which is very useful. However, sometimes you may need ...