Intro to Excel Tables and Power Query for Creo Users! (repost)
I posted this in Assembly ... but think it also applies in Detailing since BOM and Excel come up quite a bit.
We did a webinar last week with Elite Digital Enterprise to help educate people on Microsoft Excel Tables and Power Query functionality.
The Webinar was focused on Bill of Materials (BOM) Data, covering the problems typically encountered using conventional Excel Approaches (Cell Address/Named Range References) and why Excel Tables and especially Power Query should be more widely used/adopted.
Creo BOM export techniques and options were also covered as well as a live example of exporting Creo BOM data to Excel Tables (via Nitro-BOM) and Manipulating them with Power Query to automatically summarize costs.