A lull in the action this week gives me time to talk about Excel 2010. So I've made this week, Excel 2010 Improvements week.
Every day this week, I'll take time to blog about some of the new features in Excel 2010 that strike me as real improvements.
Today's topic is the new 'Percent of PivotTable SubTotals' function in Excel 2010.
» More: Excel 2010 Week – PivotTable SubTotals
If you've been an analyst for more than a week, you've been asked to compare two separate tables to come up with some brilliant analysis about the differences between them. Frankly, the task of comparing two separate tables in Excel is so common, it's suprising there aren't more/better tools in Excel to handle these types of analyses.
Now, I'm personally a database guy, preferring to use Access or SQL Server to find the differences between two tables. However, I definately think there is value in having a few good tools in Excel to do this kind of comparison.
While we wait for that magic solution from Microsoft, we have our hacky workarounds. Today's post will show you one particularly hacky workaround I use, leveraging a pivot table to compare two tables.
.
. » More: Comparing Tables with a PivotTable
We haven't had a PivotTable trick an a while. So today's post is for all you nerds who are jonesing for your PivotTable fix.
The conventional wisdom is that you can't apply an Autofilter to a PivotTable. Technically, that's true. But there is a way to trick Excel into making it happen.
Today, I want to show you a trick that's been around for a while. I think I first learned this trick from J-walk's site pre-Walkenbach pony tail.
With this trick you can transpose an entire table using a 'Multiple Consolidation Range' PivotTable.
Every now and then, I have to deal with a situation where a normalized dataset makes it difficult to build an appropriate pivot table.
Here's an example:
In honor of the upcoming 4th of July weekend, I've declared this week to be Pivot Table week. What do Pivot Tables have to do with Independence day? I'll let you know when I find out.
In the meantime, are you 'that guy' who keeps clogging everyone's email with 20 megabyte files. I want to share a simple trick to cut the size of your Pivot Table workbooks in half. » More: Cut the Size of Your Pivot Table Workbooks in Half
If you've been following the blog, you'll know that it's Pivot Table week. That's right. All in honor of the upcoming Independence Day holiday.
Here's another dose of PivotTable awesomeness. (That's right Kusleika, I said 'dose'. You don't own that word.)
Today I'll show a trick I often use to explode a dataset into separate workbooks – using a pivot table.
In honor of the upcoming 4th of July weekend, I've declared this week to be Pivot Table week.
Afterall, what's more American than slaving away on a pivot table during a holiday.
In today’s post, I’d like to share a trick that allows you to create a frequency distribution with a pivot table.
» More: Creating a Frequency Distribution with a Pivot Table
It's almost the 4th of July here in the US – probably everywhere else in the world too. But in the US, the 4th of July is Independence Day.
So in honor of the upcoming 4th of July weekend, I've declared this week to be Pivot Table week. I'm pretty sure our founding fathers used pivot tables.
Today, I'll show you a trick to add visualizations into your pivot table. » More: Adding Visualizations to your Pivot Tables
