by Nate Moore | Jan 5, 2010 | Pivot Tables
When I spoke at the MGMA Annual Conference in Denver, several people asked me if there was a way to consolidate data in multiple ranges, either in different parts of the same spreadsheet, different tabs on the same spreadsheet, or in different spreadsheets altogether,...
by Nate Moore | Jan 4, 2010 | Pivot Tables
Happy New Year! I hope you enjoyed the break. We’re starting 2010 with an easy example to get back into Excel. There’s a cool feature under value filters that allows you to filter for the top or bottom x items, percentage, or sum of items in your table. If you want to...
