Sometimes, when you’re analysing data, you need to be able to change variables and see what the impact is: for example you might want to see what your profit margin looks like if tax rates are set at ...

Up-to-date information can be critical; these 4 tips will add flexibility and increase efficiency when refreshing pivot tables. Image: Getty Images/iStockphoto PivotTable objects are only as good as ...

Excel-Integrator (EI) is a semi-automated procedure to include periodically updated CSV data into an Excel workbook table that serves as a source for other analysis such as pivot tables or structured ...

The pivot table is arguably Excel's most powerful tool. It can summarize so much data in so little time with no more than a few clicks and drags. But creating and controlling one using VBA is a ...

At the end of last year two new, fairly minor, improvements were made to Excel VBA’s support for Power Query: you can now refresh and delete individual Power Query queries. These methods are available ...

Data wonks, rejoice! Pivot tables now automatically refresh themselves in a new beta version of Microsoft Excel. You might expect that pivot tables—which can be used to summarize rows and columns of ...