As of Excel 2007, tables offer you the great benefit of organizing information in a way that is easily updatable. If not already, turn your data into a table instead of raw data (and give the table a name in the Properties group on the Design tab). Specific steps to complete the tips will vary based on the version of Excel 2007-2013 being used. Images in this article were taken using Excel 2013 on the Windows 7 OS. Here are two tips to make creating and editing PivotTables easier. However, there are some ways a macro can be really helpful when adjusting your PivotTables to get them to look consistent and useful. Unless you are turning the exact same format and type of data into PivotTables over and over, it might not make sense to record a macro that only works against one spreadsheet. The same is true of macros – convenient shortcuts that make your life easier! But have you tried to combine the two?
Once you’ve harnessed the power of PivotTables, you probably find yourself looking for ways to use them all the time. Categories: PivotTables Tags: Excel Macro Pivot Table