My previous post Excel is always there when you need a customized report stirred up a lot of interest in the actual Pipe Weld Report I created. I received several requests for the Excel file I created and instructions how to use it.
Instead of writing the steps I thought I would create a video instead because it will better demonstrate the interactive report.
Before you can use the Pipe Weld Report Excel file there is a prerequisite:
- If you are using Excel 2013 you will need to enable PowerPivot. This is done by opening the Pipe Weld Report Excel file and saying yes to the prompts to enable the PowerPivot Plug-in. Create a Power View sheet in Excel 2013
- If you are using an older version of Excel you will need to download the PowerPivot plugin
Why did I use PowerPivot?
The main reason is it creates very nice interactive reports easily. You will notice in the video as you select some of the widgets on a Power View that it filters the other views with what you have selected. This is very nice when you are analyzing the data.
Pipe Weld Report Excel