Posts Tagged 'Excel consolidation'
There are many ways to consolidate data in Microsoft Excel. You can use the Table feature and its associated filters, you can create PivotTables, or you can consolidate large amounts of data into a summary form. In this post I'll show you how to use the Consolidate data feature in Excel to take data from a series of worksheets – or workbooks – and summarize them into a single worksheet. Continue reading
Using Subtotals in Excel is one of those features that I have avoided like the plague. I found it confusing, difficult to manage and understand what was going on, so in the end I would figure out some other way to get the answers I was looking for... Continue reading