Teaching analytics with modern Excel
A friend sent me the following Excel question: I am sorting a list, multiple of thousand entries. When I use the magnifying glass and enter a search term I get a pop-up window that says there are …
Continue Reading about How to filter the results of an Excel worksheet in another worksheet →
If you've read my blog, you'll know that I love PivotTables.Subscribe for more Excel tips and get your free ebook on getting "Hired with Excel." One nuisance with PivotTable is report maintenance. If …
Continue Reading about Excel Tip: Multiple Pivots with Report Filter Pages →
Yesterday I quoted a tip on filters from "Learn Excel from Mr. Excel," a great read. Filters are a powerful Excel feature. They allow you to hone in on your data. The only problem is they're a little …
Usually when you apply a filter to your Excel workbook it applies to the whole data tab. Sometimes you don't want this. Here is a great workaround from "Learn Excel 2007 through Excel 2010 From …
Continue Reading about Filter on just part of a tab in Excel →
