To all piping engineers here...how to use Excel to deal with MTOs

Hi all,

The title is pretty explicit...I'm wondering if threre are some piping engineers / designers reading this sub and what tips and tricks they are using with Excel in order to get the most of big MTO files produced by other software. I know you can filter and get most of the numbers concerning pipes and accesories or even setup a Pivot Table for it, but I'm open to all type of nice tricks which makes easier to deal with this really large files .... for the record, we are speaking of files of tens of thousands of rows and around 30 - 40 columns.

Thanks in advance for your suggestions.